and much more). Peewee’s source code hosted on GitHub [https://github.com/coleifer/peewee]. New to peewee? Here is a list of documents you might find most helpful when getting started: Quickstart Framework Integration Executing Queries Managing Transactions Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Field-naming conflicts Creating model tables Model options other Tricks Self-referential foreign keys Circular foreign key dependencies Querying Creating a new record Bulk inserts Updating existing records Atomic updates Deleting records Selecting a single record

and much more). Peewee’s source code hosted on GitHub [https://github.com/coleifer/peewee]. New to peewee? Here is a list of documents you might find most helpful when getting started: Quickstart Framework Integration Executing Queries Managing Transactions Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table metadata Indexes other Tricks Self-referential foreign keys Circular foreign key dependencies Querying Creating a new record Bulk inserts Updating existing records Atomic updates Deleting records Selecting a single record

sqlite full-text-search, schema migrations, and much more). Peewee’s source code hosted on GitHub. New to peewee? Here is a list of documents you might find most helpful when getting started: • Quickstart can test your installation by running the test suite. python runtests.py You can test specific features or specific database drivers using the runtests.py script. To view the available test runner options py build 1.2 Quickstart This 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

sqlite full-text-search, schema migrations, and much more). Peewee’s source code hosted on GitHub. New to peewee? Here is a list of documents you might find most helpful when getting started: • Quickstart can test your installation by running the test suite. python runtests.py You can test specific features or specific database drivers using the runtests.py script. To view the available test runner options py build 1.2 Quickstart This 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

sqlite full-text-search, schema migrations, and much more). Peewee’s source code hosted on GitHub. New to peewee? Here is a list of documents you might find most helpful when getting started: • Quickstart can test your installation by running the test suite. python runtests.py You can test specific features or specific database drivers using the runtests.py script. To view the available test runner options py build 1.2 Quickstart This 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

tons of extensions Peewee’s source code hosted on GitHub [https://github.com/coleifer/peewee]. New to peewee? These may help: Quickstart Example twitter app Models and fields Querying Relationships Framework Integration Executing Queries Managing Transactions Database Errors Logging queries Adding a new Database Driver Models and Fields Fields Creating model tables Model options and table metadata Indexes other Tricks Self-referential foreign keys Circular foreign key dependencies Querying Creating a new record Bulk inserts Updating existing records Atomic updates Deleting records Selecting a single record

supports sqlite, mysql and postgresql • tons of extensions Peewee’s source code hosted on GitHub. New to peewee? These may help: • Quickstart • Example twitter app • Models and fields • Querying • can test your installation by running the test suite. python runtests.py You can test specific features or specific database drivers using the runtests.py script. To view the available test runner options py build 1.2 Quickstart This 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

a very simple abstraction on top of the sql. I had so much fun working on it that I kept adding features. My goal has always been, though, to keep the implementation incredibly simple. I’ve made a couple Creating a new record You can use the Model.create() method on the model: >>> Blog.create(creator='Charlie', name='My Blog') <__main__.Blog object at 0x2529350> This will INSERT a new row into the CREATE TABLE statement in the database. Usually this is something you’ll only do once, whenever a new model is added. Note Adding fields after the table has been created will required you to either drop

a very simple abstraction on top of the sql. I had so much fun working on it that I kept adding features. My goal has always been, though, to keep the implementation incredibly simple. I’ve made a couple Creating a new record You can use the Model.create() method on the model: >>> Blog.create(creator=’Charlie’, name=’My Blog’) <__main__.Blog object at 0x2529350> This will INSERT a new row into the CREATE TABLE statement in the database. Usu- ally this is something you’ll only do once, whenever a new model is added. Note: Adding fields after the table has been created will required you to either drop

a very simple abstraction on top of the sql. I had so much fun working on it that I kept adding features. My goal has always been, though, to keep the implementation incredibly simple. I’ve made a couple with the project. 1.3 Upgrading peewee Peewee went from 2319 SLOC to 1666. 1.3.1 Goals for the new API • consistent: there is one way of doing things • expressive: things can be done that I never was about 600 lines. I was passing around strings and dictionaries and as time went on and I added features, those strings turned into tuples and objects. This meant, though, that I needed code to handle