Essential SQLAlchemy by Myers, Jason -- Read -- Imperial Library of Trantor

Index

Preface

Who This Book Is For How to Use the Examples Assumptions This Book Makes Conventions Used in This Book Using Code Examples Safari® Books Online How to Contact Us Acknowledgments

Introduction to SQLAlchemy

Why Use SQLAlchemy?

SQLAlchemy Core and the SQL Expression Language ORM

Choosing Between SQLAlchemy Core and ORM Installing SQLAlchemy and Connecting to a Database

Installing Database Drivers Connecting to a Database

I. SQLAlchemy Core 1. Schema and Types

Types Metadata Tables

Columns Keys and Constraints Indexes Relationships and ForeignKeyConstraints

Persisting the Tables

2. Working with Data via SQLAlchemy Core

Inserting Data Querying Data

ResultProxy Controlling the Columns in the Query Ordering Limiting Built-In SQL Functions and Labels Filtering ClauseElements Operators Boolean Operators Conjunctions

Updating Data Deleting Data Joins Aliases Grouping Chaining Raw Queries

3. Exceptions and Transactions

Exceptions

AttributeError IntegrityError Handling Errors

Transactions

4. Testing

Testing with a Test Database Using Mocks

5. Reflection

Reflecting Individual Tables Reflecting a Whole Database Query Building with Reflected Objects

II. SQLAlchemy ORM 6. Defining Schema with SQLAlchemy ORM

Defining Tables via ORM Classes

Keys, Constraints, and Indexes

Relationships Persisting the Schema

7. Working with Data via SQLAlchemy ORM

The Session Inserting Data Querying Data

Controlling the Columns in the Query Ordering Limiting Built-In SQL Functions and Labels Filtering Operators Boolean Operators Conjunctions

Updating Data Deleting Data Joins Grouping Chaining Raw Queries

8. Understanding the Session and Exceptions

The SQLAlchemy Session

Session States

Exceptions

MultipleResultsFound Exception DetachedInstanceError

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

III. Alembic 11. Getting Started with Alembic

Creating the Migration Environment Configuring the Migration Environment

12. Building 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

← Prev
Back
Next →

← Prev
Back
Next →