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: Legacy Query API
- Next: Session Basics
- Up: Home
- On this page:
Using the Session¶
The declarative base and ORM mapping functions described at
ORM Mapped Class Configuration are the primary configurational interface for the
ORM. Once mappings are configured, the primary usage interface for
persistence operations is the
Session
.
- Session Basics
- State Management
- Cascades
- Transactions and Connection Management
- Additional Persistence Techniques
- Embedding SQL Insert/Update Expressions into a Flush
- Using SQL Expressions with Sessions
- Forcing NULL on a column with a default
- Fetching Server-Generated Defaults
- Case 1: non primary key, RETURNING or equivalent is supported
- Case 2: Table includes trigger-generated values which are not compatible with RETURNING
- Case 3: non primary key, RETURNING or equivalent is not supported or not needed
- Case 4: primary key, RETURNING or equivalent is supported
- Case 5: primary key, RETURNING or equivalent is not supported
- Notes on eagerly fetching client invoked SQL expressions used for INSERT or UPDATE
- Using INSERT, UPDATE and ON CONFLICT (i.e. upsert) to return ORM Objects
- Partitioning Strategies (e.g. multiple database backends per Session)
- Bulk Operations
- Contextual/Thread-local Sessions
- Tracking queries, object and Session Changes with Events
- Session API
Previous:
Legacy Query API
Next:
Session Basics
© 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: Sat 09 Nov 2024 12:10:24 PM EST