Release: 2.0.36
current release
| Release Date: October 15, 2024
SQLAlchemy 2.0 Documentation
SQLAlchemy ORM
- ORM Quick Start
- ORM Mapped Class Configuration
- Relationship Configuration¶
- ORM Querying Guide
- Using the Session
- Events and Internals
- ORM Extensions
- ORM Examples
Project Versions
- Previous: Mapping Table Columns
- Next: Basic Relationship Patterns
- Up: Home
- On this page:
Relationship Configuration¶
This section describes the relationship()
function and in depth discussion
of its usage. For an introduction to relationships, start with
Working with ORM Related Objects in the SQLAlchemy Unified Tutorial.
- Basic Relationship Patterns
- Adjacency List Relationships
- Configuring how Relationship Joins
- Handling Multiple Join Paths
- Specifying Alternate Join Conditions
- Creating Custom Foreign Conditions
- Using custom operators in join conditions
- Custom operators based on SQL functions
- Overlapping Foreign Keys
- Non-relational Comparisons / Materialized Path
- Self-Referential Many-to-Many Relationship
- Composite “Secondary” Joins
- Relationship to Aliased Class
- Row-Limited Relationships with Window Functions
- Building Query-Enabled Properties
- Notes on using the viewonly relationship parameter
- Working with Large Collections
- Collection Customization and API Details
- Special Relationship Persistence Patterns
- Using the legacy ‘backref’ relationship parameter
- Relationships API
Previous:
Mapping Table Columns
Next:
Basic Relationship Patterns
© Copyright 2007-2024, the SQLAlchemy authors and contributors.
flambé! the dragon and The Alchemist image designs created and generously donated by Rotem Yaari.
Created using Sphinx 7.2.6. Documentation last generated: Thu 12 Dec 2024 05:39:06 PM EST