Search results
15 paź 2024 · The typical usage of create_engine () is once per particular database URL, held globally for the lifetime of a single application process. A single Engine manages many individual DBAPI connections on behalf of the process and is intended to be called upon in a concurrent fashion.
- Engine Configuration
The create_engine() function produces an Engine object based...
- Connection Pooling
Connection Pooling ¶ A connection pool ... This pool is used...
- Core Events
connection¶ – the Connection where the CREATE statement or...
- Engine and Connection Use
Working with Engines and Connections. Basic Usage. Using...
- SQL Statements and Expressions API
SQL Statements and Expressions API¶. This section presents...
- Core API Basics
The Database Toolkit for Python. home; features Philosophy...
- Schema Definition Language
Schema Definition Language¶. This section references...
- SQL Datatype Objects
The Database Toolkit for Python. home; features Philosophy...
- Engine Configuration
15 paź 2024 · The create_engine() function produces an Engine object based on a URL. The format of the URL generally follows RFC-1738, with some exceptions, including that underscores, not dashes or periods, are accepted within the “scheme” portion.
15 paź 2024 · Working with Engines and Connections. Basic Usage. Using Transactions. Commit As You Go. Begin Once. Connect and Begin Once from the Engine. Mixing Styles. Setting Transaction Isolation Levels including DBAPI Autocommit. Setting Isolation Level or DBAPI Autocommit for a Connection.
Engine Configuration. The _engine.Engine is the starting point for any SQLAlchemy application. It’s “home base” for the actual database and its DBAPI, delivered to the SQLAlchemy application through a connection pool and a Dialect, which describes how to talk to a specific kind of database/DBAPI combination.
Connection URL Format ¶. See SQLAlchemy’s documentation on Engine Configuration for a complete description of syntax, dialects, and options.
The typical usage of _sa.create_engine() is once per particular database URL, held globally for the lifetime of a single application process. A single _engine.Engine manages many individual DBAPI connections on behalf of the process and is intended to be called upon in a concurrent fashion.
The most generic way is first procure a connection resource, which you get via the Engine.connect() method: connection = engine.connect() result = connection.execute("select username from users") for row in result: print "username:", row['username'] connection.close()