3 files changed, 48 insertions, 0 deletions
diff --git a/git_taskrepo/sub_commands/cmd_list_runfor.py b/git_taskrepo/sub_commands/cmd_list_runfor.py
new file mode 100644
index 0000000..fca58bb
--- /dev/null
+++ b/git_taskrepo/sub_commands/cmd_list_runfor.py
@@ -0,0 +1,24 @@
+
+# -*- coding: utf-8 -*-
+
+import xml.dom.minidom
+from git_taskrepo.command import Command
+
+class List_RunFor(Command):
+    """List Runfor"""
+    enabled = True
+
+    def options(self):
+        self.parser.usage = "%%prog %s" % self.normalized_name
+
+    def run(self, *args, **kwargs):
+        self.set_repo(**kwargs)
+        self.set_taskrepo(**kwargs)
+        conn = self.taskrepo
+        with conn:
+            cur = conn.cursor()
+            cur.execute("SELECT DISTINCT value FROM runfor")
+            rows = cur.fetchall()
+
+            for row in rows:
+                    print "%s" % row[0]
diff --git a/git_taskrepo/sub_commands/cmd_list.py b/git_taskrepo/sub_commands/cmd_list_tasks.py
index 3381da5..3381da5 100644
--- a/git_taskrepo/sub_commands/cmd_list.py
+++ b/git_taskrepo/sub_commands/cmd_list_tasks.py
diff --git a/git_taskrepo/sub_commands/cmd_list_types.py b/git_taskrepo/sub_commands/cmd_list_types.py
new file mode 100644
index 0000000..0000a4f
--- /dev/null
+++ b/git_taskrepo/sub_commands/cmd_list_types.py
@@ -0,0 +1,24 @@
+
+# -*- coding: utf-8 -*-
+
+import xml.dom.minidom
+from git_taskrepo.command import Command
+
+class List_Types(Command):
+    """List Types"""
+    enabled = True
+
+    def options(self):
+        self.parser.usage = "%%prog %s" % self.normalized_name
+
+    def run(self, *args, **kwargs):
+        self.set_repo(**kwargs)
+        self.set_taskrepo(**kwargs)
+        conn = self.taskrepo
+        with conn:
+            cur = conn.cursor()
+            cur.execute("SELECT DISTINCT value FROM types")
+            rows = cur.fetchall()
+
+            for row in rows:
+                    print "%s" % row[0]