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 Generation
    • Internals
  • Schema Introspection
  • Column and Data Types
    • Generic Types
    • SQL Standard Types
    • Vendor-Specific Types
    • Custom Types
  • Interfaces
  • Utilities
• 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.dialects
  • Supported Databases
    • Firebird
    • Microsoft SQL Server
    • MySQL
    • Oracle
    • PostgreSQL
    • SQLite
    • Sybase
  • Unsupported Databases
    • Microsoft Access
    • Informix
    • MaxDB
• sqlalchemy.ext
  • declarative
    • Synopsis
    • Defining Attributes
    • Association of Metadata and Engine
    • Configuring Relationships
    • Configuring Many-to-Many Relationships
    • Defining Synonyms
    • Table Configuration
    • Mapper Configuration
    • Inheritance Configuration
    • Mixin Classes
    • Class Constructor
    • Sessions
    • API Reference
  • associationproxy
    • Simplifying Relationships
    • Simplifying Association Object Relationships
    • Building Complex Views
    • API
  • orderinglist
    • API Reference
  • serializer
  • SqlSoup
    • Introduction
    • Loading objects
    • Modifying objects
    • Joins
    • Relationships
    • Advanced Use
  • compiler
    • Synopsis
    • Dialect-specific compilation rules
    • Compiling sub-elements of a custom expression construct
    • Changing the default compilation of existing constructs
    • Changing Compilation of Types
    • Subclassing Guidelines
  • Horizontal Shard
    • API Documentation