SQLAlchemy 0.6.4 Documentation
Search:
Version: 0.6.4 Last Updated: 08/30/2010 20:10:45
Table of Contents¶
- Overview / Installation
- Object Relational Tutorial
- Introduction
- 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
- SQL Expression Language Tutorial
- Introduction
- Version Check
- Connecting
- Define and Create Tables
- Insert Expressions
- Executing
- Executing Multiple Statements
- Connectionless / Implicit Execution
- Selecting
- Operators
- Conjunctions
- Using Text
- Using Aliases
- Using Joins
- Intro to Generative Selects and Transformations
- Everything Else
- Inserts and Updates
- Deletes
- Further Reference
- Mapper Configuration
- Mapper Configuration
- Customizing Column Properties
- Deferred Column Loading
- SQL Expressions as Mapped Attributes
- Changing Attribute Behavior
- Composite Column Types
- Controlling Ordering
- Mapping Class Inheritance Hierarchies
- 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
- Extending Mapper
- Relationship Configuration
- Basic Relational Patterns
- Adjacency List Relationships
- Specifying Alternate Join Conditions to relationship()
- Rows that point to themselves / Mutually Dependent Rows
- Alternate Collection Implementations
- Configuring Loader Strategies: Lazy Loading, Eager Loading
- Working with Large Collections
- Mutable Primary Keys / Update Cascades
- Mapper Configuration
- 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
- Contextual/Thread-local Sessions
- Partitioning Strategies
- Extending Session
- Database Engines
- Database Meta Data
- 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
- API Reference
- sqlalchemy
- sqlalchemy.orm
- sqlalchemy.dialects
- Supported Databases
- Firebird
- Microsoft SQL Server
- MySQL
- Oracle
- PostgreSQL
- SQLite
- Sybase
- Unsupported Databases
- Supported Databases
- sqlalchemy.ext
- declarative
- Synopsis
- Defining Attributes
- Accessing the MetaData
- Configuring Relationships
- Configuring Many-to-Many Relationships
- Defining Synonyms
- Defining SQL Expressions
- Table Configuration
- Using a Hybrid Approach with __table__
- Mapper Configuration
- Inheritance Configuration
- Mixin Classes
- Class Constructor
- Sessions
- API Reference
- associationproxy
- orderinglist
- serializer
- SqlSoup
- compiler
- Horizontal Shard
- declarative
Indices and tables¶
Next:
Overview / Installation
© Copyright 2007, 2008, 2009, 2010, the SQLAlchemy authors and contributors.
Created using Sphinx 1.0.1.
