application: Strings (unicode or otherwise) Integers, floats, and Decimal numbers. Boolean values Dates, times and datetimes None (NULL) Binary data Creating tables In order to start using the models select(Facility.name, cost.alias('cost')) Note See documentation Case for more examples. Working with dates How can you produce a list of members who joined after the start of September 2012? Return the memid slots. SELECT facid, SUM(slots) FROM bookings WHERE (date_trunc('month', starttime) = '2012-09-01'::dates) GROUP BY facid ORDER BY SUM(slots) query = (Booking .select(Booking.facility, fn.SUM(Booking

application: Strings (unicode or otherwise) Integers, floats, and Decimal numbers. Boolean values Dates, times and datetimes None (NULL) Binary data Creating tables In order to start using the models print(message) DateTimeField, DateField and TimeField The three fields devoted to working with dates and times have special properties which allow access to things like the year, month, hour, etc. DateField month)) Note SQLite does not have a native date type, so dates are stored in formatted text columns. To ensure that comparisons work correctly, the dates need to be formatted so they are sorted lexicographically

application: Strings (unicode or otherwise) Integers, floats, and Decimal numbers. Boolean values Dates, times and datetimes None (NULL) Binary data Creating tables In order to start using the models select(Facility.name, cost.alias('cost')) Note See documentation Case for more examples. Working with dates How can you produce a list of members who joined after the start of September 2012? Return the memid slots. SELECT facid, SUM(slots) FROM bookings WHERE (date_trunc('month', starttime) = '2012-09-01'::dates) GROUP BY facid ORDER BY SUM(slots) query = (Booking .select(Booking.facility, fn.SUM(Booking

application: Strings (unicode or otherwise) Integers, floats, and Decimal numbers. Boolean values Dates, times and datetimes None (NULL) Binary data Creating tables In order to start using the models select(Facility.name, cost.alias('cost')) Note See documentation Case for more examples. Working with dates How can you produce a list of members who joined after the start of September 2012? Return the memid slots. SELECT facid, SUM(slots) FROM bookings WHERE (date_trunc('month', starttime) = '2012-09-01'::dates) GROUP BY facid ORDER BY SUM(slots) query = (Booking .select(Booking.facility, fn.SUM(Booking

and Decimal numbers. • Boolean values 1.3. Example app 13 peewee Documentation, Release 3.5.0 • Dates, times and datetimes • None (NULL) • Binary data Creating tables In order to start using the models print(message) DateTimeField, DateField and TimeField The three fields devoted to working with dates and times have special properties which allow access to things like the year, month, hour, etc. DateField month)) Note: SQLite does not have a native date type, so dates are stored in formatted text columns. To ensure that comparisons work correctly, the dates need to be formatted so they are sorted lexicographically

and Decimal numbers. • Boolean values 1.3. Example app 13 peewee Documentation, Release 3.3.0 • Dates, times and datetimes • None (NULL) • Binary data Creating tables In order to start using the models select(Facility.name, cost.alias('cost')) Note: See documentation Case for more examples. Working with dates How can you produce a list of members who joined after the start of September 2012? Return the memid 3.0 SELECT facid, SUM(slots) FROM bookings WHERE (date_trunc('month', starttime) = '2012-09-01'::dates) GROUP BY facid ORDER BY SUM(slots) query = (Booking .select(Booking.facility, fn.SUM(Booking.slots))

and Decimal numbers. • Boolean values 1.3. Example app 13 peewee Documentation, Release 3.4.0 • Dates, times and datetimes • None (NULL) • Binary data Creating tables In order to start using the models select(Facility.name, cost.alias('cost')) Note: See documentation Case for more examples. Working with dates How can you produce a list of members who joined after the start of September 2012? Return the memid 4.0 SELECT facid, SUM(slots) FROM bookings WHERE (date_trunc('month', starttime) = '2012-09-01'::dates) GROUP BY facid ORDER BY SUM(slots) query = (Booking .select(Booking.facility, fn.SUM(Booking.slots))

application: Strings (unicode or otherwise) Integers, floats, and Decimal numbers. Boolean values Dates, times and datetimes None (NULL) Binary data Creating tables In order to start using the models print(message) DateTimeField, DateField and TimeField The three fields devoted to working with dates and times have special properties which allow access to things like the year, month, hour, etc. DateField month)) Note SQLite does not have a native date type, so dates are stored in formatted text columns. To ensure that comparisons work correctly, the dates need to be formatted so they are sorted lexicographically

• Strings (unicode or otherwise) • Integers, floats, and Decimal numbers. • Boolean values • Dates, times and datetimes • None (NULL) • Binary data Creating tables In order to start using the models print(message) DateTimeField, DateField and TimeField The three fields devoted to working with dates and times have special properties which allow access to things like the year, month, hour, etc. DateField month)) Note: SQLite does not have a native date type, so dates are stored in formatted text columns. To ensure that comparisons work correctly, the dates need to be formatted so they are sorted lexicographically

application: Strings (unicode or otherwise) Integers, floats, and Decimal numbers. Boolean values Dates, times and datetimes None (NULL) Binary data Creating tables In order to start using the models print message DateTimeField, DateField and TimeField The three fields devoted to working with dates and times have special properties which allow access to things like the year, month, hour, etc. DateField month)) Note SQLite does not have a native date type, so dates are stored in formatted text columns. To ensure that comparisons work correctly, the dates need to be formatted so they are sorted lexicographically