SQLAlchemy
The Database Toolkit for Python
The Database Toolkit for Python
  • home
  • features
    • Philosophy Statement
    • Feature Overview
    • Testimonials
  • news
  • documentation
    • Current Documentation (version 2.0)

    • Documentation by Version
    • Version 2.0
    • Version 1.4
    • Version 1.3

    • Talks and Tutorials
    • Published content overview
  • community
    • Get Support
    • Participate
    • Develop
    • Code of Conduct
    • Github
  • download
    • Download
    • Current Release Series (2.0)
    • Maintenance Release (1.4)
    • Development Access
    • License
    • Version Numbering
    • Release Status
Release: 1.3.24 legacy version | Release Date: March 30, 2021

SQLAlchemy 1.3 Documentation

SQLAlchemy 1.3 Documentation

legacy version

Home | Download this Documentation

SQLAlchemy ORM

  • Object Relational Tutorial
  • Mapper Configuration¶
    • Types of Mappings
    • Mapping Columns and Expressions
    • Mapping Class Inheritance Hierarchies
    • Non-Traditional Mappings
    • Configuring a Version Counter
    • Class Mapping API
  • Relationship Configuration
  • Loading Objects
  • Using the Session
  • Events and Internals
  • ORM Extensions
  • ORM Examples

Project Versions

  • 1.3.24

Home | Download this Documentation

  • Previous: Object Relational Tutorial
  • Next: Types of Mappings
  • Up: Home
    • SQLAlchemy ORM
  • On this page:
    • Mapper Configuration

Mapper Configuration¶

This section describes a variety of configurational patterns that are usable with mappers. It assumes you’ve worked through Object Relational Tutorial and know how to construct and use rudimentary mappers and relationships.

  • Types of Mappings
    • Declarative Mapping
    • Classical Mappings
    • Runtime Introspection of Mappings, Objects
  • Mapping Columns and Expressions
    • Mapping Table Columns
    • SQL Expressions as Mapped Attributes
    • Changing Attribute Behavior
    • Composite Column Types
  • Mapping Class Inheritance Hierarchies
    • Joined Table Inheritance
    • Single Table Inheritance
    • Concrete Table Inheritance
  • Non-Traditional Mappings
    • Mapping a Class against Multiple Tables
    • Mapping a Class against Arbitrary Selects
    • Multiple Mappers for One Class
  • Configuring a Version Counter
    • Simple Version Counting
    • Custom Version Counters / Types
    • Server Side Version Counters
    • Programmatic or Conditional Version Counters
  • Class Mapping API
    • mapper()
    • object_mapper()
    • class_mapper()
    • configure_mappers()
    • clear_mappers()
    • identity_key()
    • polymorphic_union()
    • Mapper
Previous: Object Relational Tutorial Next: Types of 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 5.3.0. Documentation last generated: Sun 05 Feb 2023 04:29:27 PM

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.

Mastodon