API Reference

• sqlalchemy
  • Connections
    • Creating Engines
    • Connectables
    • Result Objects
    • Transactions
    • Internals
  • Connection Pooling
    • Connection Pool Configuration
    • Custom Pool Construction
    • Builtin Pool Implementations
    • Pooling Plain DB-API Connections
  • SQL Statements and Expressions
    • Functions
    • Classes
    • Generic Functions
  • Database Schema
    • Tables and Columns
    • Constraints
    • Default Generators and Markers
    • DDL
    • Internals
  • Column and Data Types
    • Generic Types
    • SQL Standard Types
    • Vendor-Specific Types
    • Custom Types
  • Interfaces
• sqlalchemy.orm
  • Class Mapping
    • Defining Mappings
    • Mapper Properties
    • Decorators
    • Utilities
    • Attribute Utilities
    • Internals
  • Collection Mapping
  • Querying
    • The Query Object
    • ORM-Specific Query Constructs
    • Query Options
  • Sessions
  • Interfaces
  • Utilities
• sqlalchemy.databases
  • Access
  • Firebird
    • Firebird backend
  • Informix
  • MaxDB
    • Overview
    • Connecting
    • Implementation Notes
  • SQL Server
    • Driver
    • Connecting
    • Auto Increment Behavior
    • Collation Support
    • LIMIT/OFFSET Support
    • Nullability
    • Date / Time Handling
    • Compatibility Levels
    • Known Issues
  • MySQL
    • Overview
    • Supported Versions and Features
    • Character Sets
    • Storage Engines
    • Keys
    • SQL Mode
    • MySQL SQL Extensions
    • Troubleshooting
    • MySQL Column Types
  • Oracle
    • Driver
    • Connecting
    • Auto Increment Behavior
    • LOB Objects
    • LIMIT/OFFSET Support
    • Two Phase Transaction Support
    • Oracle 8 Compatibility
    • Synonym/DBLINK Reflection
  • PostgreSQL
    • Driver
    • Connecting
    • Sequences/SERIAL
    • INSERT/UPDATE...RETURNING
    • Indexes
    • Transactions
    • Arrays
  • SQLite
    • Driver
    • Connect Strings
    • Threading Behavior
    • Date and Time Types
    • Unicode
  • Sybase
• sqlalchemy.ext
  • declarative
    • Synopsis
    • Defining Attributes
    • Association of Metadata and Engine
    • Configuring Relations
    • Configuring Many-to-Many Relations
    • Defining Synonyms
    • Table Configuration
    • Mapper Configuration
    • Inheritance Configuration
    • Class Usage
  • associationproxy
    • Simplifying Relations
    • Simplifying Association Object Relations
    • Building Complex Views
    • API
  • orderinglist
  • serializer
  • SqlSoup
    • Introduction
    • Loading objects
    • Modifying objects
    • Joins
    • Relations
    • Advanced Use
    • Extra tests
  • compiler
    • Synopsis
    • Dialect-specific compilation rules
    • Compiling sub-elements of a custom expression construct
    • Changing the default compilation of existing constructs