records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving raw tuples / dictionaries Returning Clause Query Savepoint and ExecutionContext Metadata Types Misc Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Note If you find any bugs, odd behavior, or have your queries as complex as you like. All the other SQL clauses are available as well, such as: group_by() having() limit() and offset() Check the documentation on Querying for more info. Working with

records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning queries Update queries Delete queries More Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Note If you find any bugs, odd behavior, or have alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include people without pets. .group_by(Person) .order_by(Person.name)) for person in query: # "pet_count" becomes an attribute

operators Three valued logic Adding user-defined operators Expressions SQL Functions SQL Helper Security and SQL Injection API Documentation Database Query-builder Fields Schema Manager Model Query-builder Update queries Delete queries Query Objects More Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Changes in 3.0 Backwards-incompatible New stuff alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include people without pets. .group_by(Person) .order_by(Person.name)) for person in query: # "pet_count" becomes an attribute

records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning Update queries Delete queries Query Objects More Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Note If you find any bugs, odd behavior, or have alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include people without pets. .group_by(Person) .order_by(Person.name)) for person in query: # "pet_count" becomes an attribute

records Aggregating records Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning Update queries Delete queries Query Objects More Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Note If you find any bugs, odd behavior, or have alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include people without pets. .group_by(Person) .order_by(Person.name)) for person in query: # "pet_count" becomes an attribute

operators Three valued logic Adding user-defined operators Expressions SQL Functions SQL Helper Security and SQL Injection Relationships and Joins Model definitions Performing simple joins Joining multiple queries Delete queries Query Objects More Hacks Optimistic Locking Top object per group Top N objects per group Writing custom functions with SQLite Changes in 3.0 Backwards-incompatible New stuff alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include people without pets. .group_by(Person) .order_by(Person.name)) for person in query: # "pet_count" becomes an attribute

your queries as complex as you like. All the other SQL clauses are available as well, such as: • group_by() 1.2. Quickstart 9 peewee Documentation, Release 2.10.2 • having() • limit() and offset() questions, but it may take a bit to get to them. • Ask on the mailing list, https://groups.google.com/group/peewee-orm 1.6 Managing your Database This document describes how to perform typical database-related (User .select(User.username, fn.COUNT(Tweet.id).alias('num_tweets')) .join(Tweet, JOIN.LEFT_OUTER) .group_by(User.username)) You can order using the same COUNT expression used in the select clause. In the

fn.COUNT(Pet.id).alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include people without pets. .group_by(Person) .order_by(Person.name)) for person in query: # "pet_count" becomes an attribute on the your queries as complex as you like. All the other SQL clauses are available as well, such as: • group_by() • having() • limit() and offset() Check the documentation on Querying for more info. 1.2 question and answer for other people to find. • Ask on the mailing list, https://groups.google.com/group/peewee-orm 18 Chapter 1. Contents: peewee Documentation, Release 3.5.0 1.5 Database The Peewee

fn.COUNT(Pet.id).alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include people without pets. .group_by(Person) .order_by(Person.name)) for person in query: # "pet_count" becomes an attribute on the your queries as complex as you like. All the other SQL clauses are available as well, such as: • group_by() • having() • limit() and offset() Check the documentation on Querying for more info. 1.2 question and answer for other people to find. • Ask on the mailing list, https://groups.google.com/group/peewee-orm 1.5 Query Examples These query examples are taken from the site PostgreSQL Exercises

fn.COUNT(Pet.id).alias('pet_count')) .join(Pet, JOIN.LEFT_OUTER) # include people without pets. .group_by(Person) .order_by(Person.name)) for person in query: # "pet_count" becomes an attribute on the your queries as complex as you like. All the other SQL clauses are available as well, such as: • group_by() • having() • limit() and offset() Check the documentation on Querying for more info. 1.2 question and answer for other people to find. • Ask on the mailing list, https://groups.google.com/group/peewee-orm 1.5 Query Examples These query examples are taken from the site PostgreSQL Exercises