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 valued logic Adding user-defined operators Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over Migrations Reflection Database URL Connection pool Test Utils Flask Utils Query Builder Declaring tables Select queries Insert queries Update queries Delete queries More Hacks Optimistic Locking Top object

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 valued logic Adding user-defined operators Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over Migrations Reflection Database URL Connection pool Test Utils Flask Utils Query Builder Declaring tables Select queries Insert queries Update queries Delete queries Query Objects More Hacks Optimistic

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 Basic Exercises Joins and Subqueries Modifying Data Aggregation Recursion Query Builder Declaring tables Select queries Insert queries Update queries Delete queries Query Objects More Hacks Optimistic com/coleifer/peewee/issues?state=open] on GitHub or contact me [http://charlesleifer.com/contact/]. Indices and tables Index Module Index Search Page Installing and Testing Most users will want to simply install the

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 valued logic Adding user-defined operators Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over Migrations Reflection Database URL Connection pool Test Utils Flask Utils Query Builder Declaring tables Select queries Insert queries Update queries Delete queries Query Objects More Hacks Optimistic

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 265 2 Note 269 3 Indices and tables 271 i ii peewee Documentation, Release 3.5.0 Attention: Peewee 3.0 has been released (you are creating the tables in the database that will store our data. This will create the tables with the appropriate columns, indexes, sequences, and foreign key constraints: db.create_tables([Person, Pet]) 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, Release 3.5.0 In order to create

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259 2 Note 267 3 Indices and tables 269 i ii peewee Documentation, Release 3.3.0 Attention: Peewee 3.0 has been released (you are creating the tables in the database that will store our data. This will create the tables with the appropriate columns, indexes, sequences, and foreign key constraints: db.create_tables([Person, Pet]) 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, Release 3.3.0 In order to create

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263 2 Note 271 3 Indices and tables 273 i ii peewee Documentation, Release 3.4.0 Attention: Peewee 3.0 has been released (you are creating the tables in the database that will store our data. This will create the tables with the appropriate columns, indexes, sequences, and foreign key constraints: db.create_tables([Person, Pet]) 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, Release 3.4.0 In order to create

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 SQL Injection 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 Basic Exercises Joins and Subqueries Modifying Data Aggregation Recursion Query Builder Declaring tables Select queries Insert queries Update queries Delete queries Query Objects More Hacks Optimistic

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 285 2 Note 289 3 Indices and tables 291 i ii peewee Documentation, Release 3.6.0 Peewee is a simple and small ORM. It has few (but creating the tables in the database that will store our data. This will create the tables with the appropriate columns, indexes, sequences, and foreign key constraints: db.create_tables([Person, Pet]) 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 to instantiate a SqliteDatabase object

Contributing Patches Bugs Questions Managing your Database Creating a database connection and tables Using Postgresql Using SQLite Using BerkeleyDB Using MySQL Connecting using a Database URL Multi-threaded 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 valued logic Adding user-defined operators Expressions Foreign Keys Traversing foreign keys Joining tables Implementing Many to Many Self-joins Performance Techniques Avoiding N+1 queries Iterating over