SQLAlchemy ORM¶
Here, the Object Relational Mapper is introduced and fully described. If you want to work with higher-level SQL which is constructed automatically for you, as well as automated persistence of Python objects, proceed first to the tutorial.
- ORM Quick Start
- Object Relational Tutorial (1.x API)
- Version Check
- Connecting
- Declare a Mapping
- Create a Schema
- Create an Instance of the Mapped Class
- Creating a Session
- Adding and Updating Objects
- Rolling Back
- Querying
- Building a Relationship
- Working with Related Objects
- Querying with Joins
- Eager Loading
- Deleting
- Building a Many To Many Relationship
- Further Reference
- ORM Mapped Class Configuration
- Relationship Configuration
- Querying Data, Loading Objects
- Using the Session
- Events and Internals
- ORM Extensions
- ORM Examples