SQLAlchemy
The Database Toolkit for Python
  • home
  • features
    • Feature Overview
    • Testimonials
  • blog
  • library
    • Reference
      • Reference Documentation
    • Architecture
    • Citing SQLAlchemy
    • Blog Posts
    • Talks
    • Tutorials
    • Recipes
  • community
    • Get Support
    • Participate
    • Develop
    • Code of Conduct
    • Github
  • download
    • Current Release Series (1.4)
    • Maintenance Release (1.3)
    • Development Access
    • License
    • Version Numbering
    • Release Status
Release: 1.4.22 current release | Release Date: July 21, 2021

SQLAlchemy 1.4 Documentation

SQLAlchemy 1.4 Documentation

current release

Contents | Index | Download as ZIP file

SQLAlchemy ORM

  • Object Relational Tutorial (1.x API)
  • Mapper Configuration
  • Relationship Configuration
  • Querying Data, Loading Objects
  • Using the Session
  • Events and Internals
  • ORM Extensions
    • Asynchronous I/O (asyncio)
    • Association Proxy
    • Automap
    • Baked Queries
    • Declarative Extensions
      • Declarative API
      • Basic Use
      • Declarative Inheritance
      • Mixin and Custom Base Classes
      • Configuring Relationships
      • Table Configuration¶
        • Using a Hybrid Approach with __table__
        • Using Reflection with Declarative
    • Mypy / Pep-484 Support for ORM Mappings
    • Mutation Tracking
    • Ordering List
    • Horizontal Sharding
    • Hybrid Attributes
    • Indexable
    • Alternate Class Instrumentation
  • ORM Examples

Project Versions

  • 1.4.22

Table Configuration¶

This section has moved; see Declarative Table Configuration.

Using a Hybrid Approach with __table__¶

This section has moved; see Declarative with Imperative Table (a.k.a. Hybrid Declarative).

Using Reflection with Declarative¶

This section has moved to Mapping Declaratively with Reflected Tables.

Previous: Configuring Relationships Next: Mypy / Pep-484 Support for ORM Mappings
© Copyright 2007-2021, the SQLAlchemy authors and contributors.

flambé! the dragon and The Alchemist image designs created and generously donated by Rotem Yaari.

Created using Sphinx 4.1.1.

SQLAlchemy Sponsors

Python

Website content copyright © by SQLAlchemy authors and contributors. SQLAlchemy and its documentation are licensed under the MIT license.

SQLAlchemy is a trademark of Michael Bayer. mike(&)zzzcomputing.com All rights reserved.

Website generation by zeekofile, with huge thanks to the Blogofile project.