Relationship Configuration

• Basic Relationship Patterns
  • One To Many
    • Configuring Delete Behavior for One to Many
  • • Nullable Many-to-One
  • • Setting uselist=False for non-annotated configurations
  • • Setting Bi-Directional Many-to-many
    • Using Sets, Lists, or other Collection Types for Many To Many
  • Association Object
  • Late-Evaluation of Relationship Arguments
    • Using a late-evaluated form for the “secondary” argument of many-to-many
• • Composite Adjacency Lists
  • Configuring Self-Referential Eager Loading
• • Handling Multiple Join Paths
  • Creating Custom Foreign Conditions
  • Overlapping Foreign Keys
  • Self-Referential Many-to-Many Relationship
  • Relationship to Aliased Class
  • Row-Limited Relationships with Window Functions
• Working with Large Collections
  • • Creating and Persisting New Write Only Collections
    • Querying Items
    • Bulk INSERT of New Items
    • Write Only Collections - API Documentation
  • • Dynamic Relationship Loaders - API
  • Using Passive Deletes
• • Customizing Collection Access
  • Custom Collection Implementations
    • Custom Dictionary-Based Collections
  • Collection Internals
    • collection
    • CollectionAdapter
    • InstrumentedList
    • prepare_instrumentation()
• • Rows that point to themselves / Mutually Dependent Rows
  • • Simulating limited ON UPDATE CASCADE without foreign key support
• • Backref Default Arguments
• Relationships API
  • backref()
  • remote()