documentation » peewee a small orm written in python provides a lightweight querying interface over sql uses sql concepts when querying, like joins and where clauses Contents: Overview Why? Installing peewee 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()

0.9.7 • a small orm • written in python • provides a lightweight querying interface over sql • uses sql concepts when querying, like joins and where clauses CONTENTS 1 peewee Documentation, Release 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() flask and found myself writing lots of queries and wanting 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

documentation » peewee a small orm written in python provides a lightweight querying interface over sql uses sql concepts when querying, like joins and where clauses support for special extensions like hstore 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()

1.0.0 • a small orm • written in python • provides a lightweight querying interface over sql • uses sql concepts when querying, like joins and where clauses • support for special extensions like hstore 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() flask and found myself writing lots of queries and wanting 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

2.0.0 • a small orm • written in python • provides a lightweight querying interface over sql • uses sql concepts when querying, like joins and where clauses • support for some extensions, like hstore 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 flask and found myself writing lots of queries and wanting 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

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 Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving raw tuples / dictionaries Returning Clause Query operators Three valued 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

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 Retrieving Scalar Values SQL Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning Clause Query operators Three

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 Performance Techniques Query operators Three valued logic Adding user-defined operators Expressions SQL Functions SQL Helper Security and SQL Injection API Documentation Database Query-builder Fields Schema Schema Manager Model Query-builder Internals Constants and Helpers SQLite Extensions Getting started APIs Additional Features Playhouse, extensions to Peewee SqliteQ Sqlite User-Defined Functions apsw

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