Mapping Classes with Declarative — SQLAlchemy 2.0.0b1 documentation

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.

• 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