Database Operations

Code

import sqlite3

conn = sqlite3.connect("test.db")
cursor = conn.cursor()

# Create table
cursor.execute("""
    CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY,
        name TEXT NOT NULL,
        age INTEGER
    )
""")

# Insert (parameterized to prevent injection)
cursor.execute("INSERT INTO users (name, age) VALUES (?, ?)", ("Alice", 30))

# Query
cursor.execute("SELECT * FROM users WHERE age > ?", (20,))
for row in cursor.fetchall():
    print(row)

conn.commit()
conn.close()

Explanation

Uses parameterized queries to prevent SQL injection; using context managers is recommended.

More Python Snippets