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()