The sqlite3 module is built into the Python Standard Library, meaning no external installation is required.
# Method 1: Using parameterized queries (SECURE - prevents SQL injection) def insert_user(username, email, age): cursor.execute(''' INSERT INTO users (username, email, age) VALUES (?, ?, ?) ''', (username, email, age)) conn.commit() return cursor.lastrowid sqlite3 tutorial query python fixed
import sqlite3 # 1. Connect (creates file if it doesn't exist) connection = sqlite3.connect('example.db') cursor = connection.cursor() # 2. Execute a standard SELECT query query = "SELECT * FROM users WHERE status = 'active'" cursor.execute(query) # 3. Fetch and print results rows = cursor.fetchall() for row in rows: print(row) # Results are returned as a list of tuples # 4. Cleanup connection.close() Use code with caution. Copied to clipboard The sqlite3 module is built into the Python
def delete_inactive_users(days_inactive: int) -> int: """Fixed: Returns number of deleted users""" query = """ DELETE FROM users WHERE last_login < datetime('now', ?) """ days_param = f'-days_inactive days' with get_db_connection() as conn: cursor = conn.cursor() cursor.execute(query, (days_param,)) deleted_count = cursor.rowcount print(f"Deleted deleted_count inactive users") return deleted_count Execute a standard SELECT query query = "SELECT
def tearDown(self): self.conn.close()