blob: 2041ac37e57f156ff2ebf81500a1cee3c20cf233 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
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()
|