SQLAlchemy 0.6 Documentation
Search:
Release: 0.6.9 | Release Date: May 5, 2012
- Prev: Overview
- Next: Object Relational Tutorial
- Table of Contents | Index | view source
SQLAlchemy 0.6 Documentation
»
SQLAlchemy ORM
SQLAlchemy ORM
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.
- Object Relational Tutorial
- Version Check
- Connecting
- Define and Create a Table
- Define a Python Class to be Mapped
- Setting up the Mapping
- Creating Table, Class and Mapper All at Once Declaratively
- Creating a Session
- Adding new Objects
- Rolling Back
- Querying
- Building a Relationship
- Working with Related Objects
- Querying with Joins
- Deleting
- Building a Many To Many Relationship
- Further Reference
- Mapper Configuration
- Customizing Column Properties
- Deferred Column Loading
- SQL Expressions as Mapped Attributes
- Changing Attribute Behavior
- Composite Column Types
- Mapping a Class against Multiple Tables
- Mapping a Class against Arbitrary Selects
- Multiple Mappers for One Class
- Multiple “Persistence” Mappers for One Class
- Constructors and Object Initialization
- The mapper() API
- Relationship Configuration
- Collection Configuration and Techniques
- Mapping Class Inheritance Hierarchies
- Using the Session
- What does the Session do ?
- Getting a Session
- Using the Session
- Cascades
- Managing Transactions
- Embedding SQL Insert/Update Expressions into a Flush
- Using SQL Expressions with Sessions
- Joining a Session into an External Transaction
- The Session object and sessionmaker() function
- Contextual/Thread-local Sessions
- Partitioning Strategies
- Session Utilities
- Attribute and State Management Utilities
- Querying
- Relationship Loading Techniques
- ORM Event Interfaces
- ORM Extensions
- Examples
- Adjacency List
- Associations
- Attribute Instrumentation
- Beaker Caching
- Derived Attributes
- Directed Graphs
- Dynamic Relations as Dictionaries
- Horizontal Sharding
- Inheritance Mappings
- Large Collections
- Nested Sets
- Polymorphic Associations
- PostGIS Integration
- Versioned Objects
- Vertical Attribute Mapping
- XML Persistence
- ORM Exceptions
Previous:
Overview
Next:
Object Relational Tutorial
