Skip to main content
Ctrl+K
Logo image
Documentation
Community
Contributing
Learn how to contribute to the Litestar project
Code of Conduct
Review the etiquette for interacting with the Litestar community
About
Litestar Organization
Details about the Litestar organization
Releases
Details about the Litestar release process
Release notes
What's new in 2.0
2.x Changelog
1.x Changelog
Help
Documentation
Community
Contributing
Learn how to contribute to the Litestar project
Code of Conduct
Review the etiquette for interacting with the Litestar community
About
Litestar Organization
Details about the Litestar organization
Releases
Details about the Litestar release process
Release notes
What's new in 2.0
2.x Changelog
1.x Changelog
Help

Section Navigation

Documentation

  • Tutorials
    • Developing a basic TODO application
      • Application basics
      • Accessing the list
      • Making the list interactive
      • Recap and assembling the final application
    • Improving the TODO app with SQLAlchemy
      • Introduction
      • Providing the session with DI
      • Using the serialization plugin
      • Using the init plugin
      • Final touches and recap
    • Data Transfer Object Tutorial
      • Our first DTO
      • Excluding from nested models
      • Excluding from collections of nested models
      • Max nested depth
      • Renaming fields
      • Receiving data
      • Read only fields
      • Accessing the data
      • Updating instances
      • Declaring DTOs on app layers
    • SQLAlchemy Repository Tutorial
      • Introduction to Database Modeling and Repository Features
      • Interacting with repositories
      • Working with Controllers and Repositories
      • Adding Additional Features to the Repository
  • Usage
    • Applications
    • Routing
      • Routing
      • Route handlers
      • Parameters
    • Requests
    • Responses
    • Dependency Injection
    • WebSockets
    • Data Transfer Object (DTO)
      • Basic Use
      • AbstractDTO
      • Implementing Custom DTO Classes
    • Middleware
      • Using Middleware
      • Built-in middleware
      • Creating Middleware
    • Plugins
    • Security
      • AbstractAuthenticationMiddleware
      • Security Backends
      • Guards
      • JWT Security Backends
    • Channels
    • Databases
      • SQLAlchemy
        • SQLAlchemy Models & Repository
        • Plugins
      • Piccolo ORM
    • Exceptions and exception handling
    • Stores
    • OpenAPI
    • Life Cycle Hooks
    • Caching
    • Templating
    • Events
    • Logging
    • Static Files
    • Metrics
      • OpenTelemetry
      • Prometheus
    • HTMX
    • CLI
    • Testing
    • Debugging
  • API reference
    • app
    • background_tasks
    • channels
      • plugin
      • subscriber
      • backends
        • base
        • memory
        • redis
    • cli
    • config
    • connection
    • contrib
      • HTMX
      • jinja
      • jwt
      • mako
      • opentelemetry
      • piccolo_orm
      • pydantic
      • repository
        • abc
        • filters
        • exceptions
        • testing
        • handlers
      • sqlalchemy
        • plugins
        • repository
        • types
        • base
        • DTO
    • controller
    • data_extractors
    • datastructures
    • di
    • dto
      • config
      • data_structures
      • field
      • types
      • base_dto
      • msgspec_dto
      • dataclass_dto
    • enums
    • events
    • exceptions
    • handlers
    • logging
      • config
      • picologging
      • standard
    • middleware
      • allowed_hosts
      • authentication
      • compression
      • cors
      • csrf
      • logging
      • rate_limit
      • session
        • base
        • client_side
        • server_side
    • openapi
      • openapi
      • spec
    • pagination
    • params
    • plugins
    • response
      • base
      • file
      • redirect
      • streaming
      • SSE (Server Sent Events)
      • template
    • router
    • routes
    • security
      • session_auth
    • serialization
    • static_files
    • status_code
    • stores
      • base
      • file
      • memory
      • redis
      • registry
    • template
    • testing
    • types
    • typing
  • Topics
    • Sync vs. Async
  • Migrating to Litestar
    • From Flask
    • From Starlette / FastAPI
  • Benchmarks
  • Usage
  • Databases
  • SQLAlchemy

SQLAlchemy#

  • SQLAlchemy Models & Repository
    • Features
    • Basic Use
    • Basic Controller Integration
  • Plugins
    • SQLAlchemy Plugin
      • Example
        • Defining the Database Models
        • Setting Up an API Endpoint
        • Initializing the Database
        • Setting Up the Plugin and the App
        • Running the App
    • SQLAlchemy Init Plugin
      • Dependencies
        • Renaming the dependencies
        • Configuring the before send handler
        • Configuring the plugins
      • Example
    • SQLAlchemy Serialization Plugin
      • Example
      • How it works
        • Configuring data transfer

previous

Databases

next

SQLAlchemy Models & Repository

© Copyright 2023, Litestar-Org.

Created using Sphinx 5.3.0.

Built with the PyData Sphinx Theme 0.13.3.