Books & Videos

Table of Contents

  1. SQLAlchemy Core

    1. Chapter 1 Schema and Types

      1. Types
      2. Metadata
      3. Tables
      4. Persisting the Tables
    2. Chapter 2 Working with Data via SQLAlchemy Core

      1. Inserting Data
      2. Querying Data
      3. Updating Data
      4. Deleting Data
      5. Joins
      6. Aliases
      7. Grouping
      8. Chaining
      9. Raw Queries
    3. Chapter 3 Exceptions and Transactions

      1. Exceptions
      2. Transactions
    4. Chapter 4 Testing

      1. Testing with a Test Database
      2. Using Mocks
    5. Chapter 5 Reflection

      1. Reflecting Individual Tables
      2. Reflecting a Whole Database
      3. Query Building with Reflected Objects
  2. SQLAlchemy ORM

    1. Chapter 6 Defining Schema with SQLAlchemy ORM

      1. Defining Tables via ORM Classes
      2. Relationships
      3. Persisting the Schema
    2. Chapter 7 Working with Data via SQLAlchemy ORM

      1. The Session
      2. Inserting Data
      3. Querying Data
      4. Updating Data
      5. Deleting Data
      6. Joins
      7. Grouping
      8. Chaining
      9. Raw Queries
    3. Chapter 8 Understanding the Session and Exceptions

      1. The SQLAlchemy Session
      2. Exceptions
      3. Transactions
    4. Chapter 9 Testing with SQLAlchemy ORM

      1. Testing with a Test Database
      2. Using Mocks
    5. Chapter 10 Reflection with SQLAlchemy ORM and Automap

      1. Reflecting a Database with Automap
      2. Reflected Relationships
  3. Alembic

    1. Chapter 11 Getting Started with Alembic

      1. Creating the Migration Environment
      2. Configuring the Migration Environment
    2. Chapter 12 Building Migrations

      1. Generating a Base Empty Migration
      2. Autogenerating a Migration
      3. Building a Migration Manually
    3. Chapter 13 Controlling Alembic

      1. Determining a Database’s Migration Level
      2. Downgrading Migrations
      3. Marking the Database Migration Level
      4. Generating SQL
    4. Chapter 14 Cookbook

      1. Hybrid Attributes
      2. Association Proxy
      3. Integrating SQLAlchemy with Flask
      4. SQLAcodegen
    5. Chapter 15 Where to Go from Here