Essential SQLAlchemy / Jason Myers and Rick Copeland.

Format:

Book

Author/Creator:

Myers, Jason, author.

Copeland, Rick, author.

Language:

English

Subjects (All):

Python (Computer program language).

SQL (Computer program language).

Web databases.

Physical Description:

1 online resource (208 p.)

Edition:

2nd ed.

Other Title:

Essential SQLAlchemy : mapping Python to databases

Mapping Python to databases

Place of Publication:

Sebastopol, CA : O'Reilly, 2015.

Language Note:

English

System Details:

text file

Summary:

Dive into SQLAlchemy, the popular, open-source code library that helps Python programmers work with relational databases such as Oracle, MySQL, PostgresSQL, and SQLite. Using real-world examples, this practical guide shows you how to build a simple database application with SQLAlchemy, and how to connect to multiple databases simultaneously with the same metadata. If you’re an intermediate Python developer with knowledge of basic SQL syntax and relational theory, this book serves as both a learning tool and a handy reference.

Contents:

Copyright; Table of Contents; 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; Part I. SQLAlchemy Core; Chapter 1. Schema and Types; Types; Metadata; Tables; Columns; Keys and Constraints; Indexes

Relationships and ForeignKeyConstraintsPersisting the Tables; Chapter 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; Chapter 3. Exceptions and Transactions; Exceptions; AttributeError; IntegrityError; Handling Errors; Transactions; Chapter 4. Testing; Testing with a Test Database; Using Mocks; Chapter 5. Reflection

Reflecting Individual TablesReflecting a Whole Database; Query Building with Reflected Objects; Part II. SQLAlchemy ORM; Chapter 6. Defining Schema with SQLAlchemy ORM; Defining Tables via ORM Classes; Keys, Constraints, and Indexes; Relationships; Persisting the Schema; Chapter 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

Chapter 8. Understanding the Session and ExceptionsThe SQLAlchemy Session; Session States; Exceptions; MultipleResultsFound Exception; DetachedInstanceError; Transactions; Chapter 9. Testing with SQLAlchemy ORM; Testing with a Test Database; Using Mocks; Chapter 10. Reflection with SQLAlchemy ORM and Automap; Reflecting a Database with Automap; Reflected Relationships; Part III. Alembic; Chapter 11. Getting Started with Alembic; Creating the Migration Environment; Configuring the Migration Environment; Chapter 12. Building Migrations; Generating a Base Empty Migration

Autogenerating a MigrationBuilding a Migration Manually; Chapter 13. Controlling Alembic; Determining a Database's Migration Level; Downgrading Migrations; Marking the Database Migration Level; Generating SQL; Chapter 14. Cookbook; Hybrid Attributes; Association Proxy; Integrating SQLAlchemy with Flask; SQLAcodegen; Chapter 15. Where to Go from Here; Index; About the Authors

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed January 20, 2016).

ISBN:

9781491916551

1491916559

9781491916544

1491916540

9781491916568

1491916567

OCLC:

932322837