Existing Databases Adding Request Hooks Additional connection initialization Advanced Connection Management Using multiple databases Database Errors Automatic Reconnect Logging queries Generating skeleton Retrieving raw tuples / dictionaries Returning Clause Query operators Three valued logic Adding user-defined operators Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many Explicit transaction Autocommit Mode Playhouse, extensions to Peewee Sqlite Extensions SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver BerkeleyDB backend Sqlcipher backend Postgresql

using a Database URL Run-time database configuration Dynamically defining a database Connection Management Connection Pooling Framework Integration Executing Queries Managing Transactions Database Errors row tuples / dictionaries / namedtuples Returning Clause Query operators Three valued logic Adding user-defined operators Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many Extensions Getting started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions DataSet

using a Database URL Run-time database configuration Dynamically defining a database Connection Management Connection Pooling Testing Peewee Applications Async with Gevent Framework Integration Executing row tuples / dictionaries / namedtuples Returning Clause Query operators Three valued logic Adding user-defined operators Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Extensions Getting started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions

using a Database URL Run-time database configuration Dynamically defining a database Connection Management Connection Pooling Testing Peewee Applications Framework Integration Executing Queries Managing row tuples / dictionaries / namedtuples Returning Clause Query operators Three valued logic Adding user-defined operators Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Extensions Getting started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions DataSet

correspond to the table’s columns. For the twitter clone, there are just three models: User: Represents a user account and stores the username and password, an email address for generating avatars using account was created. Relationship: This is a utility model that contains two foreign-keys to the User model and stores which users follow one another. Message: Analagous to a tweet. The Message model model stores the text content of the tweet, when it was created, and who posted it (foreign key to User). If you like UML, these are the tables and relationships: In order to create these models we need

correspond to the table’s columns. For the twitter clone, there are just three models: User: Represents a user account and stores the username and password, an email address for generating avatars using account was created. Relationship: This is a utility model that contains two foreign-keys to the User model and stores which users follow one another. Message: Analagous to a tweet. The Message model model stores the text content of the tweet, when it was created, and who posted it (foreign key to User). If you like UML, these are the tables and relationships: 12 Chapter 1. Contents: peewee Documentation

using a Database URL Run-time database configuration Dynamically defining a database Connection Management Connection Pooling Testing Peewee Applications Async with Gevent Framework Integration Executing Implementing Many to Many Self-joins Performance Techniques Query operators Three valued logic Adding user-defined operators Expressions SQL Functions SQL Helper Security and SQL Injection API Documentation Extensions Getting started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions

correspond to the table’s columns. For the twitter clone, there are just three models: User: Represents a user account and stores the username and password, an email address for generating avatars using account was created. Relationship: This is a utility model that contains two foreign-keys to the User model and stores which users follow one another. Message: Analagous to a tweet. The Message model model stores the text content of the tweet, when it was created, and who posted it (foreign key to User). If you like UML, these are the tables and relationships: 12 Chapter 1. Contents: peewee Documentation

using a Database URL Run-time database configuration Dynamically defining a database Connection Management Connection Pooling Testing Peewee Applications Async with Gevent Framework Integration Executing Clause Common Table Expressions Foreign Keys and Joins Query operators Three valued logic Adding user-defined operators Expressions SQL Functions SQL Helper Security and SQL Injection Relationships and started APIs Additional Features Playhouse, extensions to Peewee Sqlite Extensions SqliteQ Sqlite User-Defined Functions apsw, an advanced sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions

correspond to the table’s columns. For the twitter clone, there are just three models: User: Represents a user account and stores the username and password, an email address for generating avatars using account was created. Relationship: This is a utility model that contains two foreign-keys to the User model and stores which users follow one another. Message: Analagous to a tweet. The Message model model stores the text content of the tweet, when it was created, and who posted it (foreign key to User). If you like UML, these are the tables and relationships: 12 Chapter 1. Contents: peewee Documentation