Essential SQLAlchemy

Preface

Part 1: SQLAlchemy Core
1. Schema and Types
-Types
-Metadata
-Tables
-Persisting the Tables

2. Working with Data via SQLAlchemy Core
-Inserting Data
-Querying Data
-Updating Data
-Deleting Data
-Joins
-Aliases
-Grouping
-Chaining
-Raw Queries

3. Exceptions and Transactions
-Exceptions
-Transactions

4. Testing
-Testing with a Test Database
-Using Mocks

5. Reflection
-Reflecting Individual Tables
-Reflecting a Whole Database
-Query Building with Reflected Objects

Part 2: SQLAlchemy ORM
6. Defining Schema with SQLAlchemy ORM
-Defining Tables via ORM Classes
-Relationships
-Persisting the Schema

7. Working with Data via SQLAlchemy ORM
-The Session
-Inserting Data
-Querying Data
-Updating Data
-Deleting Data
-Joins
-Grouping
-Chaining
-Raw Queries

8. Understanding the Session and Exceptions
-The SQLAlchemy Session
-Exceptions
-Transactions

9. Testing with SQLAlchemy ORM
-Testing with a Test Database
-Using Mocks

10. Reflection with SQLAlchemy ORM and Automap
-Reflecting a Database with Automap
-Reflected Relationships

Part 3: Alembic
11. Getting Started with Alembic
-Creating the Migration Environment
-Configuring the Migration Environment

12Building Migrations
-Generating a Base Empty Migration
-Autogenerating a Migration
-Building a Migration Manually

13. Controlling Alembic
-Determining a Database’s Migration Level
-Downgrading Migrations
-Marking the Database Migration Level
-Generating SQL

14. Cookbook
-Hybrid Attributes
-Association Proxy
-Integrating SQLAlchemy with Flask
-SQLAcodegen

15. Where to Go from Here

Index