This Asphalt framework component provides connectivity to relational databases.

It is a wrapper for the SQLAlchemy library.

Table of contents

• Configuration
  • Setting engine or session options
  • Multiple databases
• Using engines and sessions
  • Working with the SQLAlchemy session
  • Working with synchronous sessions
  • Releasing database resources during a long operation
• Using SQLAlchemy events with Asphalt
  • Events with synchronous engines/sessions
  • Events with asynchronous engines/sessions
• Testing with asphalt-sqlalchemy
  • Setting up the SQLAlchemy component and the database connection
  • Adding base data
  • Using alternative async testing plugins
• Tips and tricks
  • How to automatically print emitted SQL
  • Handling schema migrations
• API reference
  • Components
  • Utilities
• Version history