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 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

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 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

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

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

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

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

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

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

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: Analogous 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

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 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