records

import records import os # Example using SQLite in-memory or a database URL from an environment variable # For other databases, change the connection string, e.g., # "postgres://user:pass@host:port/dbname" database_url = os.environ.get('DATABASE_URL', 'sqlite:///:memory:') db = records.Database(database_url) # Create a table and insert data (example for SQLite) if 'sqlite' in database_url: db.query('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT, age INTEGER)') db.query('INSERT INTO users (name, age) VALUES (:name, :age)', name='Alice', age=30) db.query('INSERT INTO users (name, age) VALUES (:name, :age)', name='Bob', age=24) # Run a query rows = db.query('SELECT * FROM users WHERE age > :min_age', min_age=25) # Iterate over results print('Users over 25:') for row in rows: print(f" Name: {row.name}, Age: {row.age}") # Access columns by name or index first_row = rows.first() if first_row: print(f"First user found: {first_row.name}") # Export to CSV (requires tablib) # print(rows.export('csv')) # Export to Pandas DataFrame (requires pandas) # df = rows.export('df') # print(df.head()) # Close the connection (important for some databases) db.close()