except sqlite3.Error as e: print(f"An error occurred: e")
deleted = delete_user(4) print(f"\nDeleted deleted user(s)")
cursor.execute(''' CREATE TABLE IF NOT EXISTS posts ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER, title TEXT NOT NULL, content TEXT, FOREIGN KEY (user_id) REFERENCES users (id) ) ''') sqlite3 tutorial query python fixed
results = cursor.fetchall() for row in results: print(f"row[0] ordered row[2]x row[1] on row[3]")
class DatabaseManager: def (self, db_name='my_database.db'): self.db_name = db_name self.create_tables() except sqlite3
def add_user(name, email): with db_connection() as conn: cursor = conn.cursor() cursor.execute( "INSERT INTO users (name, email) VALUES (?, ?)", (name, email) ) return cursor.lastrowid
Now that we have some data in the database, let's perform some queries: title TEXT NOT NULL
This will open the sqlite3 shell, where you can execute SQL commands. Let's create a table called users :