2
0

sqlite_keynames.py 304 B

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