Essential SQLAlchemy / Rick Copeland.

Format:

Book

Author/Creator:

Copeland, Rick.

Language:

English

Subjects (All):

Web databases.

Web site development.

Physical Description:

1 online resource (230 p.)

Edition:

First edition.

Place of Publication:

Beijing ; Sebastopol, California : O'Reilly Media, 2008.

Language Note:

English

System Details:

text file

Summary:

Essential SQLAlchemy introduces a high-level open-source code library that makes it easier for Python programmers to access relational databases such as Oracle, DB2, MySQL, PostgreSQL, and SQLite. SQLAlchemy has become increasingly popular since its release, but it still lacks good offline documentation. This practical book fills the gap, and because a developer wrote it, you get an objective look at SQLAlchemy's tools rather than an advocate's description of all the ""cool"" features. SQLAlchemy includes both a database server-independent SQL expression language and

Contents:

Table of Contents; Preface; Audience; Assumptions This Book Makes; Contents of this Book; Conventions Used in This Book; Using Code Examples; How to Contact Us; Acknowledgments; Chapter 1. Introduction to SQLAlchemy; What Is SQLAlch; The Object/Relational "Impedance Mismatch"; SQLAlchemy Philosophy; SQLAlchemy Architecture; Engine; Connection Pooling; SQL dialect management; MetaData Management; Types System; SQL Expression Language; Object Relational Mapper (ORM); Chapter 2. Getting Started; Installing SQLAlchemy; Installing the SQLAlchemy Package; Installing setup tools

Installing SQLAlchemy with easy_installTesting the install; Installing Some Database Drivers; Installing the SQLite driver on Python versions before 2.5; Other supported drivers; SQLAlchemy Tutorial; Connecting to the Database and Creating Some Tables; Performing Queries and Updates; Mapping Objects to Tables; Chapter 3. Engines and MetaData; Engines and Connectables; Configuring SQLAlchemy Logging; Database Connections and ResultProxys; Connection Pooling; MetaData; Getting Started with MetaData; Defining Tables; Table reflection; Column Definitions; Constraints; Primary keys; Foreign keys

UNIQUE constraintsCHECK constraints; Defaults; Active defaults; Passive defaults; Defining Indexes; The Index object; Creating Explicit Sequences; MetaData Operations; Binding MetaData; Create/drop MetaData and schema objects; Adapt Tables from one MetaData to another; Chapter 4. SQLAlchemy Type Engines; Type System Overview; Built-in Types; Generic Types; Dialect-Specific Types; Application-Specific Custom Types; Implementing a TypeDecorator; Creating a New TypeEngine; Chapter 5. Running Queries and Updates; Inserts, Updates, and Deletes; Insert Statements; Update Statements

1:1 relations

Notes:

Incudes index.

Description based on online resource; title from PDF title page (ebrary, viewed October 15, 2013).

ISBN:

9781449390846

1449390846

9781449391508

1449391508

OCLC:

780424479