Fixup later command

[matrix-goal-bot.git] / matrix_goal_bot / db.py

diff --git a/matrix_goal_bot/db.py b/matrix_goal_bot/db.py
index 22dca51b66a62e1136691c6698abb547bfb166f8..a9d1b879d6b9b6f3d5005378b13deccd4d10484c 100644 (file)
--- a/matrix_goal_bot/db.py
+++ b/matrix_goal_bot/db.py
@@ -226,9 +226,11 @@ class Data():
 
     def put_off_vision(self, vision_id):
         with Session(self.engine) as session:
 
     def put_off_vision(self, vision_id):
         with Session(self.engine) as session:

-            cmd = select(Goal).where(Vision.id == vision_id)
-            goal = session.exec(cmd).first()
-            goal.start_date = dt.today() + timedelta(days=14)
+            # vision = session.exec(cmd).first()
+            cmd = select(Goal).where(Goal.vision_id == vision_id)
+            goals = session.exec(cmd).all()
+            for goal in goals:
+                goal.start_date = dt.today() + timedelta(days=14)

             session.commit()
         return True
 
             session.commit()
         return True