- #!/usr/bin/python3
- import sqlite3
- s=sqlite3.connect('../Testdata/contacts_with-Maik-Mustermann.db')
- s.row_factory = sqlite3.Row #das macht den Unterschied und liefert die Werte
- sc = s.cursor()
- sc.execute('SELECT * FROM Contacts')
- rows=sc.fetchall()
- for row in rows:
- print(str(row['contactId']))
|