dataset

import dataset import os # Connect to an in-memory SQLite database db = dataset.connect('sqlite:///:memory:') # Get a table reference; it will be created if it doesn't exist table = db['users'] # Insert new records; columns are created automatically table.insert(dict(name='John Doe', age=30, city='New York')) table.insert(dict(name='Jane Smith', age=25, city='London')) # Update an existing record table.update(dict(name='John Doe', age=31), ['name']) # Find all records all_users = table.all() print("All users:") for user in all_users: print(user) # Find one record by a specific field john = table.find_one(name='John Doe') print(f"\nJohn Doe's updated age: {john['age']}") # Find records with a filter london_users = table.find(city='London') print("\nUsers in London:") for user in london_users: print(user) # Using environment variable for database URL (example) # os.environ['DATABASE_URL'] = 'sqlite:///mydb.db' # db_env = dataset.connect() # print(f"\nConnected via env var to: {db_env.url}")