Add visionless command

diff --git a/matrix_goal_bot/bot.py b/matrix_goal_bot/bot.py
index 957051c785f516e50764754af3c7251a7fe7b455..8c8183c386ef42ff9c0b849ca1b92d2fee33f00c 100644 (file)
--- a/matrix_goal_bot/bot.py
+++ b/matrix_goal_bot/bot.py
@@ -142,6 +142,15 @@ async def do_goal(match):
             results.append(item)
         return results
 
+    if match.command('visions'):
+        items = Data().visionless()
+        results = ['# Goals with no vision']
+        if not items:
+            results.append('-- No visionless goals --')
+
+        for item in items:
+            results.append(item)
+        return results
 
     if match.command('set-vision'):
         goal_id = int(match.args()[1])

diff --git a/matrix_goal_bot/db.py b/matrix_goal_bot/db.py
index a47853369c80ea65af5ad583fcc9ce29bb77b752..97ea2c05b623038dffefdc2d6e36999a78f3fccc 100644 (file)
--- a/matrix_goal_bot/db.py
+++ b/matrix_goal_bot/db.py
@@ -177,6 +177,13 @@ class Data():
             goal.vision_id = vision_id
             session.commit()
 
+    def visionless(self):
+        '''Get goals with no vision'''
+        with Session(self.engine) as session:
+            cmd = select(Goal).where(Goal.vision_id  == None)
+            return session.exec(cmd).all()
+
+
     def add_note(self, note, goal):
         '''Notes print with the goal.'''
         pass

diff --git a/matrix_goal_bot/tasks.py b/matrix_goal_bot/tasks.py
index 440afb4790e9eae447ca2fa2c20e618c745e1c99..5e85d18a8f165d5bbf8649b5584e36a9a4346cc6 100644 (file)
--- a/matrix_goal_bot/tasks.py
+++ b/matrix_goal_bot/tasks.py
@@ -25,6 +25,13 @@ def list(c):
         print(goal)
 
 
+@task
+def visionless(c):
+    goals = Data().visionless()
+    for goal in goals:
+        print(goal)
+
+
 @task
 def list_done(c):
     goals = Data().get_done_goals()