Mapping Classes with Declarative

The Declarative mapping style is the primary style of mapping that is used with SQLAlchemy. See the section Declarative Mapping for the top level introduction.

• Declarative Mapping Styles
  • Using a Generated Base Class
  • Creating an Explicit Base Non-Dynamically (for use with mypy, similar)
  • Declarative Mapping using a Decorator (no declarative base)
  • Declarative Mapping with Dataclasses and Attrs
    • Example One - Dataclasses with Imperative Table
    • Example Two - Dataclasses with Declarative Table
    • Example Three - attrs with Imperative Table
• Table Configuration with Declarative
  • Declarative Table
    • Accessing Table and Metadata
    • Declarative Table Configuration
    • Explicit Schema Name with Declarative Table
    • Adding New Columns
  • Declarative with Imperative Table (a.k.a. Hybrid Declarative)
  • Mapping Declaratively with Reflected Tables
    • Using DeferredReflection
    • Using Automap
• Mapper Configuration with Declarative
  • Defining Mapped Properties with Declarative
  • Mapper Configuration Options with Declarative
  • Other Declarative Mapping Directives
    • __declare_last__()
    • __declare_first__()
    • metadata
    • __abstract__
    • __table_cls__
• Composing Mapped Hierarchies with Mixins
  • Augmenting the Base
  • Mixing in Columns
  • Mixing in Relationships
    • Using Advanced Relationship Arguments (e.g. primaryjoin, etc.)
  • Mixing in deferred(), column_property(), and other MapperProperty classes
  • Mixing in Association Proxy and Other Attributes
  • Controlling table inheritance with mixins
  • Mixing in Columns in Inheritance Scenarios
  • Combining Table/Mapper Arguments from Multiple Mixins
  • Creating Indexes with Mixins