Essential SQLAlchemy
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 document...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing ; Sebastopol, California :
O'Reilly Media
2008.
|
| Edición: | First edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627278806719 |
Tabla de Contenidos:
- 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
