Module Reference

Previous: 1.3.2 Compatibility with Python Up: 1. Web Modules Next: 1.4.1 Introduction

---

 
1.4 web.database -- SQL database layer

The web.database module is a simple SQL abstraction layer which sits on top of a DB-API 2.0 cursor to implement data type conversions, provide database independance and offer a more Python-like interface to the data returned from queries.

Here are the main features of the module:

• 100% compatible with the underlying DB-API 2.0 cursor. A web.database cursor is also a DB-API 2.0 cursor.
• Provides methods including select(), insert(), update(), delete(), create(), alter() and drop() which build and customise the SQL depending on the database being used providing database independance.
• Provides strong typing for the data being used. No need to deal with SQL strings, the module automatically encodes and decodes data for the approriate column.

• 1.4.1 Introduction
  • 1.4.1.1 Overview of Approach
  • 1.4.1.2 Supported Databases
• 1.4.2 Connecting to a Database
• 1.4.3 Cursor Options
• 1.4.4 Using SQL Commands
  • 1.4.4.1 Understanding Field Types
  • 1.4.4.2 Selecting Data
    • 1.4.4.2.1 The where Parameter
    • 1.4.4.2.2 The order Parameter
    • 1.4.4.2.3 The rest Parameter
    • 1.4.4.2.4 Disabling autoExecute
    • 1.4.4.2.5 Using Aliases
    • 1.4.4.2.6 Using Joins
  • 1.4.4.3 Inserting Data
  • 1.4.4.4 Updating Data
  • 1.4.4.5 Deleting Data
  • 1.4.4.6 Creating Tables
  • 1.4.4.7 Dropping Tables
  • 1.4.4.8 Altering Tables
  • 1.4.4.9 Functions
• 1.4.5 Cursor Methods
• 1.4.6 Debugging
• 1.4.7 Utility Methods
• 1.4.8 Developer Notes
  • 1.4.8.1 The Types Cache
  • 1.4.8.2 Field Information
• 1.4.9 Database Specific Notes
  • 1.4.9.1 MySQL
  • 1.4.9.2 SQLite
  • 1.4.9.3 ODBC
  • 1.4.9.4 Complicaitons with Gadfly
    • 1.4.9.4.1 Creating a Gadfly Database
    • 1.4.9.4.2 Lack of NULL Support
    • 1.4.9.4.3 FTP Transfer
• 1.4.10 Test Code
• 1.4.11 Future

---

Module Reference

Previous: 1.3.2 Compatibility with Python Up: 1. Web Modules Next: 1.4.1 Introduction

---

Documentation released on November 18, 2004 .