SQLAlchemy ORM

Here, the Object Relational Mapper is introduced and fully described. If youwant to work with higher-level SQL which is constructed automatically for you,as well as automated persistence of Python objects, proceed first to thetutorial.

• Object Relational Tutorial
  • 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
• Mapper Configuration
  • Types of Mappings
  • Mapping Columns and Expressions
  • Mapping Class Inheritance Hierarchies
  • Non-Traditional Mappings
  • Configuring a Version Counter
  • Class Mapping API
• Relationship Configuration
  • Basic Relationship Patterns
  • Adjacency List Relationships
  • Linking Relationships with Backref
  • Configuring how Relationship Joins
  • Collection Configuration and Techniques
  • Special Relationship Persistence Patterns
  • Relationships API
• Loading Objects
  • Loading Columns
  • Relationship Loading Techniques
  • Loading Inheritance Hierarchies
  • Constructors and Object Initialization
  • Query API
• Using the Session
  • Session Basics
  • State Management
  • Cascades
  • Transactions and Connection Management
  • Additional Persistence Techniques
  • Contextual/Thread-local Sessions
  • Tracking Object and Session Changes with Events
  • Session API
• Events and Internals
  • ORM Events
  • ORM Internals
  • ORM Exceptions
  • Deprecated ORM Event Interfaces
• ORM Extensions
  • Association Proxy
  • Automap
  • Baked Queries
  • Declarative
  • Mutation Tracking
  • Ordering List
  • Horizontal Sharding
  • Hybrid Attributes
  • Indexable
  • Alternate Class Instrumentation
• ORM Examples
  • Mapping Recipes
  • Inheritance Mapping Recipes
  • Special APIs
  • Extending the ORM