Essential SQLAlchemy, 2nd Edition

This new edition of Essential SQLAlchemy is the tool developers need to understand the technology. Rather than being a simple tutorial or API reference, this book builds an application step by step. This application is comprised of many of the most common usages of SQLAlchemy, thus showing how to manage complexity and engaging in real world examples. Using easy, common language, the authors teach you how to turn knowledge into usable work.

Table of Contents

Part I. SQLAlchemy Core
Chapter 1. Schema and Types
Chapter 2. Working with Data via SQLAlchemy Core
Chapter 3. Exceptions and Transactions
Chapter 4. Testing
Chapter 5. Reflection

Part II. SQLAlchemy ORM
Chapter 6. Defining Schema with SQLAlchemy ORM
Chapter 7. Working with Data via SQLAlchemy ORM
Chapter 8. Understanding the Session and Exceptions
Chapter 9. Testing with SQLAlchemy ORM
Chapter 10. Reflection with SQLAlchemy ORM and Automap

Part III. Alembic
Chapter 11. Getting Started with Alembic
Chapter 12. Building Migrations
Chapter 13. Controlling Alembic
Chapter 14. Cookbook
Chapter 15. Where to Go from Here