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

document presents a brief, high-level overview of Peewee’s primary features. This guide will cover: • Model Definition 4 Chapter 1. Contents: peewee Documentation, Release 2.10.2 • Storing data • Retrieving 1.2.1 Model Definition Model classes, fields and model instances all map to database concepts: Thing Corresponds to. . . Model class Database table Field instance Column on a table Model instance typically best to begin with your data model, by defining one or more Model classes: from peewee import * db = SqliteDatabase('people.db') class Person(Model): name = CharField() birthday = DateField()

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

document presents a brief, high-level overview of Peewee’s primary features. This guide will cover: • Model Definition 4 Chapter 1. Contents: peewee Documentation, Release 3.5.0 • Storing data • Retrieving 1.2.1 Model Definition Model classes, fields and model instances all map to database concepts: Object Corresponds to. . . Model class Database table Field instance Column on a table Model instance typically best to begin with your data model, by defining one or more Model classes: from peewee import * db = SqliteDatabase('people.db') class Person(Model): name = CharField() birthday = DateField()

document presents a brief, high-level overview of Peewee’s primary features. This guide will cover: • Model Definition 4 Chapter 1. Contents: peewee Documentation, Release 3.4.0 • Storing data • Retrieving 1.2.1 Model Definition Model classes, fields and model instances all map to database concepts: Object Corresponds to. . . Model class Database table Field instance Column on a table Model instance typically best to begin with your data model, by defining one or more Model classes: from peewee import * db = SqliteDatabase('people.db') class Person(Model): name = CharField() birthday = DateField()

document presents a brief, high-level overview of Peewee’s primary features. This guide will cover: • Model Definition 4 Chapter 1. Contents: peewee Documentation, Release 3.3.0 • Storing data • Retrieving 1.2.1 Model Definition Model classes, fields and model instances all map to database concepts: Object Corresponds to. . . Model class Database table Field instance Column on a table Model instance typically best to begin with your data model, by defining one or more Model classes: from peewee import * db = SqliteDatabase('people.db') class Person(Model): name = CharField() birthday = DateField()

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