peewee Documentation Release 3.5.0 charles leifer Jul 27, 2018 Contents 1 Contents: 3 1.1 Installing and Testing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . special/custom field types. Contents 1 peewee Documentation, Release 3.5.0 2 Contents CHAPTER 1 Contents: 1.1 Installing and Testing Most users will want to simply install the latest version, hosted on PyPI: membercost * 1.1 FROM facilities WHERE facid = 0), guestcost = (SELECT guestcost * 1.1 FROM facilities WHERE facid = 0) WHERE facid = 1; -- OR -- WITH new_prices (nmc, ngc) AS ( SELECT membercost * 1.1, guestcost

peewee Documentation Release 3.3.0 charles leifer Jul 27, 2018 Contents 1 Contents: 3 1.1 Installing and Testing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . special/custom field types. Contents 1 peewee Documentation, Release 3.3.0 2 Contents CHAPTER 1 Contents: 1.1 Installing and Testing Most users will want to simply install the latest version, hosted on PyPI: membercost * 1.1 FROM facilities WHERE facid = 0), guestcost = (SELECT guestcost * 1.1 FROM facilities WHERE facid = 0) WHERE facid = 1; -- OR -- WITH new_prices (nmc, ngc) AS ( SELECT membercost * 1.1, guestcost

peewee Documentation Release 3.4.0 charles leifer Jul 27, 2018 Contents 1 Contents: 3 1.1 Installing and Testing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . special/custom field types. Contents 1 peewee Documentation, Release 3.4.0 2 Contents CHAPTER 1 Contents: 1.1 Installing and Testing Most users will want to simply install the latest version, hosted on PyPI: membercost * 1.1 FROM facilities WHERE facid = 0), guestcost = (SELECT guestcost * 1.1 FROM facilities WHERE facid = 0) WHERE facid = 1; -- OR -- WITH new_prices (nmc, ngc) AS ( SELECT membercost * 1.1, guestcost

peewee Documentation Release 3.6.0 charles leifer Jul 27, 2018 Contents 1 Contents: 3 1.1 Installing and Testing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Relationships and joins Contents 1 peewee Documentation, Release 3.6.0 2 Contents CHAPTER 1 Contents: 1.1 Installing and Testing Most users will want to simply install the latest version, hosted on PyPI: want to. UPDATE facilities SET membercost = (SELECT membercost * 1.1 FROM facilities WHERE facid = 0), guestcost = (SELECT guestcost * 1.1 FROM facilities WHERE facid = 0) WHERE facid = 1; (continues on

membercost * 1.1 FROM facilities WHERE facid = 0), guestcost = (SELECT guestcost * 1.1 FROM facilities WHERE facid = 0) WHERE facid = 1; -- OR -- WITH new_prices (nmc, ngc) AS ( SELECT membercost * 1.1, guestcost guestcost * 1.1 FROM facilities WHERE name = 'Tennis Court 1') UPDATE facilities SET membercost = new_prices.nmc, guestcost = new_prices.ngc FROM new_prices WHERE name = 'Tennis Court 2' sq1 = Facility Facility.select(Facility.membercost * 1.1).where(Facility.facid == 0) sq2 = Facility.select(Facility.guestcost * 1.1).where(Facility.facid == 0) query = (Facility .update(membercost=sq1, guestcost=sq2)

membercost * 1.1 FROM facilities WHERE facid = 0), guestcost = (SELECT guestcost * 1.1 FROM facilities WHERE facid = 0) WHERE facid = 1; -- OR -- WITH new_prices (nmc, ngc) AS ( SELECT membercost * 1.1, guestcost guestcost * 1.1 FROM facilities WHERE name = 'Tennis Court 1') UPDATE facilities SET membercost = new_prices.nmc, guestcost = new_prices.ngc FROM new_prices WHERE name = 'Tennis Court 2' sq1 = Facility Facility.select(Facility.membercost * 1.1).where(Facility.facid == 0) sq2 = Facility.select(Facility.guestcost * 1.1).where(Facility.facid == 0) query = (Facility .update(membercost=sq1, guestcost=sq2)

membercost * 1.1 FROM facilities WHERE facid = 0), guestcost = (SELECT guestcost * 1.1 FROM facilities WHERE facid = 0) WHERE facid = 1; -- OR -- WITH new_prices (nmc, ngc) AS ( SELECT membercost * 1.1, guestcost guestcost * 1.1 FROM facilities WHERE name = 'Tennis Court 1') UPDATE facilities SET membercost = new_prices.nmc, guestcost = new_prices.ngc FROM new_prices WHERE name = 'Tennis Court 2' sq1 = Facility Facility.select(Facility.membercost * 1.1).where(Facility.facid == 0) sq2 = Facility.select(Facility.guestcost * 1.1).where(Facility.facid == 0) query = (Facility .update(membercost=sq1, guestcost=sq2)

membercost * 1.1 FROM facilities WHERE facid = 0), guestcost = (SELECT guestcost * 1.1 FROM facilities WHERE facid = 0) WHERE facid = 1; -- OR -- WITH new_prices (nmc, ngc) AS ( SELECT membercost * 1.1, guestcost guestcost * 1.1 FROM facilities WHERE name = 'Tennis Court 1') UPDATE facilities SET membercost = new_prices.nmc, guestcost = new_prices.ngc FROM new_prices WHERE name = 'Tennis Court 2' sq1 = Facility Facility.select(Facility.membercost * 1.1).where(Facility.facid == 0) sq2 = Facility.select(Facility.guestcost * 1.1).where(Facility.facid == 0) query = (Facility .update(membercost=sq1, guestcost=sq2)

membercost * 1.1 FROM facilities WHERE facid = 0), guestcost = (SELECT guestcost * 1.1 FROM facilities WHERE facid = 0) WHERE facid = 1; -- OR -- WITH new_prices (nmc, ngc) AS ( SELECT membercost * 1.1, guestcost guestcost * 1.1 FROM facilities WHERE name = 'Tennis Court 1') UPDATE facilities SET membercost = new_prices.nmc, guestcost = new_prices.ngc FROM new_prices WHERE name = 'Tennis Court 2' sq1 = Facility Facility.select(Facility.membercost * 1.1).where(Facility.facid == 0) sq2 = Facility.select(Facility.guestcost * 1.1).where(Facility.facid == 0) query = (Facility .update(membercost=sq1, guestcost=sq2)

peewee Documentation Release 0.9.7 charles leifer June 22, 2013 CONTENTS 1 Contents: 3 1.1 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . where clauses CONTENTS 1 peewee Documentation, Release 0.9.7 2 CONTENTS CHAPTER ONE CONTENTS: 1.1 Overview peewee is a lightweight ORM written in python. Examples: # a simple query selecting a user