Add Python script to view a table in the db

1 files changed, 17 insertions, 0 deletions

diff --git a/database/view-table.py b/database/view-table.py
new file mode 100644
index 00000000..615b4081
--- /dev/null
+++ b/database/view-table.py
@@ -0,0 +1,17 @@
+import os
+import sqlite3
+import sys
+
+try:
+    BASE_DIR = directory_name=sys.argv[1]
+except:
+    BASE_DIR = os.path.dirname(os.path.abspath(__file__))
+db_location = os.path.join(BASE_DIR, 'opendc.db')
+
+conn = sqlite3.connect(db_location)
+c = conn.cursor()
+
+rows = c.execute('SELECT * FROM ' + sys.argv[2])
+
+for row in rows:
+    print row