{"library":"sqlbag","title":"SQLBag Utilities","type":"library","description":"SQLBag (version 0.1.1617247075) provides various snippets of SQL-related boilerplate, simplifying common SQLAlchemy tasks such as session management, query execution (e.g., `one`, `many`, `chunks`), engine creation, and upsert operations. It aims to reduce repetitive code for database interactions. Releases are frequent, following a timestamp-based micro-versioning system, primarily reflecting a single developer's utility collection.","language":"python","status":"active","last_verified":"Fri Apr 17","install":{"commands":["pip install sqlbag"],"cli":null},"imports":["from sqlbag import S","from sqlbag import one","from sqlbag import many","from sqlbag.engine import get_engine","from sqlbag.engine import make_session","from sqlbag.sqla import upsert"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":null,"github":"https://github.com/djrobstep/sqlbag","docs":null,"changelog":null,"pypi":"https://pypi.org/project/sqlbag/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"import os\nfrom sqlbag import S, one, many\nfrom sqlbag.engine import get_engine\n\n# Configure your database URL\ndatabase_url = os.environ.get('DATABASE_URL', 'sqlite:///./test.db')\n\nengine = get_engine(url=database_url)\n\n# Example usage with S context manager\nwith S(engine) as session:\n    session.execute('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)')\n    session.execute(\"INSERT INTO users (name) VALUES ('Alice')\")\n    session.execute(\"INSERT INTO users (name) VALUES ('Bob')\")\n    session.commit()\n\n    # Fetch a single result\n    alice = one(session, 'SELECT * FROM users WHERE name = :name', name='Alice')\n    print(f\"Found one: {alice}\")\n\n    # Fetch multiple results\n    all_users = many(session, 'SELECT * FROM users')\n    print(f\"Found many: {all_users}\")\n\nprint(\"SQLBag quickstart completed successfully.\")","lang":"python","description":"This quickstart demonstrates how to initialize an SQLAlchemy engine, use the `S` context manager for session handling, and perform basic queries with `sqlbag.one` and `sqlbag.many`.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}