SQLite
Datenbank per Python erzeugen
# Quelle: https://pynative.com/python-sqlite/ import sqlite3 try: sqliteConnection = sqlite3.connect('SQLite_Python.db') cursor = sqliteConnection.cursor() print("Database created and Successfully Connected to SQLite") sqlite_select_Query = "select sqlite_version();" cursor.execute(sqlite_select_Query) record = cursor.fetchall() print("SQLite Database Version is: ", record) cursor.close() except sqlite3.Error as error: print("Error while connecting to sqlite", error) finally: if (sqliteConnection): sqliteConnection.close() print("The SQLite connection is closed")
Ergebnis:
Database created and Successfully Connected to SQLite SQLite Database Version is: [('3.31.1',)] The SQLite connection is closed
Struktur (nicht Inhalt) einer Tabelle anzeigen
# Beispiel-Datenbank von https://www.sqlitetutorial.net/sqlite-sample-database/ import sqlite3 sqliteConnection = sqlite3.connect('chinook.db') cursor = sqliteConnection.cursor() print("Database created and Successfully Connected to SQLite") cursor.execute("PRAGMA table_info(`albums`)") for column in cursor: print(column) cursor.close() sqliteConnection.close() print("The SQLite connection is closed")
Ergebnis:
Database created and Successfully Connected to SQLite (0, 'AlbumId', 'INTEGER', 1, None, 1) (1, 'Title', 'NVARCHAR(160)', 1, None, 0) (2, 'ArtistId', 'INTEGER', 1, None, 0) The SQLite connection is closed
Daten einer Tabelle ausgeben
import sqlite3 sqliteConnection = sqlite3.connect('chinook.db') cursor = sqliteConnection.cursor() print("Database created and Successfully Connected to SQLite") # cursor.execute("PRAGMA table_info(`albums`)") # for column in cursor: # print(column) # cursor.close() with sqliteConnection: cur = sqliteConnection.cursor() cur.execute("SELECT * FROM albums") rows = cur.fetchall() for row in rows: print(row) sqliteConnection.close() print("The SQLite connection is closed")
Ergebnis:
Database created and Successfully Connected to SQLite (1, 'For Those About To Rock We Salute You', 1) (2, 'Balls to the Wall', 2). . . (346, 'Mozart: Chamber Music', 274) (347, 'Koyaanisqatsi (Soundtrack from the Motion Picture)', 275) The SQLite connection is closed [Finished in 0.1s]