Contents: Installing and Testing Installing with git Running tests Optional dependencies Quickstart Model Definition Storing data Retrieving Data Working with existing databases What next? Example app Running Generating skeleton code Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table metadata Indexes and Constraints Non-integer Primary Keys, Composite Keys Integration Fields Generic foreign keys Hybrid Attributes Key/Value Store Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database URL CSV Utils Connection pool Read Slaves Test Utils

Installing with git Running tests Optional dependencies Skip Compilation of SQLite Extensions Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table metadata Indexes and Constraints Non-integer Primary Keys, Composite Keys Helper Security and SQL Injection API Documentation Database Query-builder Fields Schema Manager Model Query-builder Internals Constants and Helpers SQLite Extensions Getting started APIs Additional

Installing with git Running tests Optional dependencies Skip Compilation of SQLite Extensions Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What example Diving into the code More examples Contributing Patches Bugs Questions Query Examples Model Definitions Schema Creation Basic Exercises Joins and Subqueries Modifying Data Aggregation Recursion queries Adding a new Database Driver Models and Fields Fields Field-naming conflicts Creating model tables Model options and table metadata Indexes and Constraints Non-integer Primary Keys, Composite Keys

Contents: Installing and Testing Installing with git Running tests Optional dependencies Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What example Diving into the code More examples Contributing Patches Bugs Questions Query Examples Model Definitions Schema Creation Basic Exercises Joins and Subqueries Modifying Data Aggregation Recursion Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table metadata Indexes and Constraints Non-integer Primary Keys, Composite Keys

with git Running tests Optional dependencies Skip Compilation of SQLite Extensions Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table metadata Indexes and Constraints Non-integer Primary Keys, Composite Keys Relationships and Joins Model definitions Performing simple joins Joining multiple tables Selecting from multiple sources Subqueries Multiple foreign-keys to the same Model Joining on arbitrary fields

Contents: Installing and Testing Installing with git Running tests Optional dependencies Quickstart Model Definition Storing data Retrieving Data Closing the database Working with existing databases What example Diving into the code More examples Contributing Patches Bugs Questions Query Examples Model Definitions Schema Creation Basic Exercises Joins and Subqueries Modifying Data Aggregation Recursion Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table metadata Indexes and Constraints Non-integer Primary Keys, Composite Keys

Configuration Optional Configuration A Note on mod_rewrite Blog Tutorial - Adding a layer Create a Post Model Create a Posts Controller Creating Post Views Adding Posts Data Validation Editing Posts Deleting Rewriting Fire It Up CakePHP Overview What is CakePHP? Why use it? Understanding Model-View-Controller The Model layer The View layer The Controller layer CakePHP request cycle Benefits Where to Get Retrieving Your Data Saving Your Data Deleting Data Data Validation Callback Methods Behaviors DataSources Model Attributes Additional Methods and Properties Virtual fields Transactions Core Libraries General

Django documentation contents Getting started Django at a glance Design your model Install it Enjoy the free API A dynamic admin interface: it’s not just scaffolding – it’s the whole house Design your Multiple databases Tablespaces Database access optimization Database instrumentation Examples of model relationship API usage Handling HTTP requests URL dispatcher Writing views View decorators File files Adding migrations to apps Reverting migrations Historical models Considerations when removing model fields Data Migrations Squashing migrations Serializing values Supporting multiple Django versions

migrations 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 collection of addons apsw, an advanced sqlite driver Postgresql Extensions (hstore, ltree) pwiz, a model generator Signal support Sqlite Extensions Swee’pea, syntactic sugar for peewee Indices and tables following models: import peewee class Blog(peewee.Model): creator = peewee.CharField() name = peewee.CharField() class Entry(peewee.Model): blog = peewee.ForeignKeyField(Blog) title =

Django documentation contents Getting started Django at a glance Design your model Install it Enjoy the free API A dynamic admin interface: it’s not just scaffolding – it’s the whole house Design your Multiple databases Tablespaces Database access optimization Database instrumentation Examples of model relationship API usage Handling HTTP requests URL dispatcher Writing views View decorators File Dependencies Migration files Adding migrations to apps Historical models Considerations when removing model fields Data Migrations Squashing migrations Serializing values Supporting multiple Django versions