bare essentials. It will take you between 5 and 10 minutes to go through it. Guide to the various query operators describes how to construct queries and combine expressions. Field types table lists the Security and SQL Injection Window functions Retrieving raw tuples / dictionaries Returning Clause Query operators Three valued logic Adding user-defined operators Expressions Foreign Keys Traversing CSV Utils Connection pool Read Slaves Test Utils pskel Flask Utils API Reference Models Fields Query Types Database and its subclasses Transaction, Savepoint and ExecutionContext Metadata Types Misc

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50 1.9 Query operators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . bare essentials. It will take you between 5 and 10 minutes to go through it. • Guide to the various query operators describes how to construct queries and combine expressions. • Field types table lists the 1.2. Quickstart 5 peewee Documentation, Release 2.10.2 some arbitrary time later when the first query is executed. It is also good to close the connection when you are done – for instance, a web app might

1 Contents: 1.1 Overview peewee is a lightweight ORM written in python. Examples: # a simple query selecting a user User.get(User.username == ’charles’) # get the staff and super users editors = User simple twitter-like site • using “fn” • the querying docs, which contain an in-depth overview of the query apis 1.3.3 Changes in fields and columns Well, for one, columns are gone. They were a shim that peewee and spits out SQL. It works recursively and knows about a few types of expressions: • the query tree • comparison statements like ‘==’, ‘IN’, ‘LIKE’ which comprise the leaves of the tree • expressions

Keys Field class API Querying API Constructing queries Where clause Performing advanced queries Query evaluation QueryResultWrapper SelectQuery UpdateQuery DeleteQuery InsertQuery RawQuery Databases [http://en.wikipedia.org/wiki/Object-relational_mapping] written in python. Examples: # a simple query selecting a user User.get(username='charles') # get the staff and super users editors = User.select() the exception can be caught during the “connect” step, rather than some arbitrary time later when a query is executed. >>> database = SqliteDatabase('stats.db') >>> database.connect() To use this database

ONE CONTENTS: 1.1 Overview peewee is a lightweight ORM written in python. Examples: # a simple query selecting a user User.get(username=’charles’) # get the staff and super users editors = User.select() the exception can be caught during the “connect” step, rather than some arbitrary time later when a query is executed. >>> database = SqliteDatabase(’stats.db’) >>> database.connect() To use this database records, issue an UPDATE query. The following example will update all Entry objects, marking them as “published”, if their pub_date is less than today’s date. >>> update_query = Entry.update(published=True)

Many Field class API Querying API Constructing queries Where clause Performing advanced queries Query evaluation QueryResultWrapper SelectQuery UpdateQuery DeleteQuery InsertQuery RawQuery Databases [http://en.wikipedia.org/wiki/Object-relational_mapping] written in python. Examples: # a simple query selecting a user User.get(username='charles') # get the staff and super users editors = User.select() the exception can be caught during the “connect” step, rather than some arbitrary time later when a query is executed. >>> database = SqliteDatabase('stats.db') >>> database.connect() It is possible to

ONE CONTENTS: 1.1 Overview peewee is a lightweight ORM written in python. Examples: # a simple query selecting a user User.get(username=’charles’) # get the staff and super users editors = User.select() the exception can be caught during the “connect” step, rather than some arbitrary time later when a query is executed. >>> database = SqliteDatabase(’stats.db’) >>> database.connect() It is possible to records, issue an UPDATE query. The following example will update all Entry objects, marking them as “published”, if their pub_date is less than today’s date. >>> update_query = Entry.update(published=True)

bare essentials. It will take you between 5 and 10 minutes to go through it. Guide to the various query operators describes how to construct queries and combine expressions. Field types table lists the app Running the 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 SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning Clause Query operators Three valued logic Adding user-defined operators Expressions Foreign Keys Traversing

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 1.8 Query operators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181 1.12 Query Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233 1.13 Query Builder . . . . . . . . . . . . . . . . minutes to go through it. • Example Twitter app written using Flask framework. • Guide to the various query operators describes how to construct queries and combine expressions. • Field types table lists the

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 1.5 Query Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 1.9 Query operators . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . extensions to Peewee . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 206 1.17 Query Builder . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .