add script for reading sqlite

1 files changed, 32 insertions, 0 deletions

diff --git a/bjoern/videoanalyse/read_sqlite.py b/bjoern/videoanalyse/read_sqlite.py
new file mode 100644
index 0000000..2041ac3
--- /dev/null
+++ b/bjoern/videoanalyse/read_sqlite.py
@@ -0,0 +1,32 @@
+import sqlite3;
+import fileinput;
+import csv;
+
+def print_sqlite(cursor):
+    for row in cursor.fetchall():
+        print(dict(row))
+
+def create_csv_from_sqlite(data):
+    with open('sqlite_output.csv', 'w', newline='') as f:
+        writer = csv.writer(f)
+        writer.writerow(['id', 'url', ...])
+        writer.writerows(data)
+        
+def get_url_from_sqlite(sqlite_file, title):
+    con = sqlite3.connect(sqlite_file)
+    con.row_factory = sqlite3.Row
+    
+    cur = con.cursor()
+    select_statement = 'SELECT url FROM moz_places WHERE title = ?'
+    dat = cur.execute(select_statement, (title,))
+    
+    print_sqlite(cur) 
+        
+def main():
+    get_url_from_sqlite('chsokl11/places.sqlite', 'Atmosphärische Gegenstrahlung – Wikipedia')
+    
+    #create_csv_from_sqlite(dat)
+    #concat_logfiles()   
+
+if __name__ == "__main__":
+    main()