project_id = int(config['General']['taguette_project_id'])
taguette_database_file = config['General']['taguette_database_file']
+
## connect to sqlite3
con = sqlite3.connect(taguette_database_file)
cur = con.cursor()
+# Run this if you just want tags and no highlights
sql_stmt_get = "SELECT id, path, description FROM tags WHERE project_id = ?"
+
+# Run this if you want tags AND highlights
+#sql_stmt_get = "SELECT tags.id, tags.path, tags.description, highlights.snippet FROM highlight_tags INNER JOIN tags ON highlight_tags.tag_id = tags.id INNER JOIN highlights ON highlight_tags.highlight_id = highlights.id WHERE project_id = ?"
cur.execute(sql_stmt_get, (project_id,))
while True:
tag_id, path, description = row
- m = re.match(r'^(.+)\.(.*)$', path)
+ m = re.match(r'^(.+)\_(.*)$', path)
if m:
axial = m.group(1)
tag = m.group(2)
old_description = tag_info[0][2]
if row['Axial Codes']:
- newname = row['Axial Codes'].lower() + "." + new_name.lower()
+ newname = row['Axial Codes'].lower() + "_" + new_name.lower()
else:
newname = new_name.lower()