]> code.communitydata.science - taguette_google_sheet_integration.git/blobdiff - taguette-export_tags_to_csv.py
added new configuration file and README
[taguette_google_sheet_integration.git] / taguette-export_tags_to_csv.py
index 31a267dd4eff2c69c6bdb6d4590fe81a25938e37..2085e47a94280e1951b793f45848c39c82ba0af6 100755 (executable)
@@ -2,14 +2,19 @@
 
 import re
 import sqlite3
+from configparser ConfigParser
+
+config = ConfigParser()
+config.read('.taguette_gdocs')
+
+## this is project ID from the configuration
+project_id = int(config['General']['taguette_project_id'])
+taguette_database_file = config['General']['taguette_database_file']
 
 ## connect to sqlite3
-con = sqlite3.connect('taguette-working.sqlite3')
+con = sqlite3.connect(taguette_database_file)
 cur = con.cursor()
 
-## this is the hardcoded project id
-project_id = 13
-
 sql_stmt_get = "SELECT id, path, description FROM tags WHERE project_id = ?"
 cur.execute(sql_stmt_get, (project_id,))
 

Community Data Science Collective || Want to submit a patch?