peewee

• a small orm
• written in python
• provides a lightweight querying interface over sql
• uses sql concepts when querying, like joins and where clauses

Contents:

• Overview
  • Why?
• Installing peewee
  • Installing with git
• Peewee Cookbook
  • Database and Connection Recipes
  • Creating, Reading, Updating and Deleting
  • Working with transactions
  • Introspecting databases
• Example app
  • Running the example
  • Diving into the code
• Model API (smells like django)
  • Creating tables
  • Model instances
  • Model options
  • Model methods
• Fields
  • Field types table
  • Self-referential Foreign Keys
  • Implementing Many to Many
  • Field class API
• Querying API
  • Constructing queries
  • Where clause
  • Performing advanced queries
  • Query evaluation
  • QueryResultWrapper
  • SelectQuery
  • UpdateQuery
  • DeleteQuery
  • InsertQuery
  • RawQuery
• Databases
  • Database and its subclasses
  • BaseAdapter and its subclasses

Indices and tables

• Index
• Module Index
• Search Page