Non-integer Primary Keys, Composite Keys and other Tricks Self-referential foreign keys Circular foreign key dependencies Querying Creating a new record Bulk inserts Updating existing records Atomic updates records Counting records Aggregating records Retrieving Scalar Values Window functions Retrieving row tuples / dictionaries / namedtuples Returning Clause Common Table Expressions Foreign Keys and Joins sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions DataSet Fields Hybrid Attributes Key/Value Store Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database

Non-integer Primary Keys, Composite Keys and other Tricks Self-referential foreign keys Circular foreign key dependencies Querying Creating a new record Bulk inserts Updating existing records Atomic updates Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning Clause Query operators Three valued logic Adding user-defined sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions DataSet Fields Hybrid Attributes Key/Value Store Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database

Non-integer Primary Keys, Composite Keys and other Tricks Self-referential foreign keys Circular foreign key dependencies Querying Creating a new record Bulk inserts Updating existing records Atomic updates records Counting records Aggregating records Retrieving Scalar Values Window functions Retrieving row tuples / dictionaries / namedtuples Returning Clause Foreign Keys and Joins Implementing Many to Many sqlite driver Sqlcipher backend Postgresql Extensions MySQL Extensions DataSet Fields Hybrid Attributes Key/Value Store Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database

Non-integer Primary Keys, Composite Keys and other Tricks Self-referential foreign keys Circular foreign key dependencies Querying Creating a new record Bulk inserts Updating existing records Atomic updates Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning Clause Query operators Three valued logic Adding user-defined Object Corresponds to… Model class Database table Field instance Column on a table Model instance Row in a database table When starting a project with peewee, it’s typically best to begin with your data

Non-integer Primary Keys, Composite Keys and other Tricks Self-referential foreign keys Circular foreign key dependencies Querying Creating a new record Bulk inserts Updating existing records Atomic updates Functions, Subqueries and “Raw expressions” Security and SQL Injection Window functions Retrieving row tuples / dictionaries / namedtuples Returning Clause Query operators Three valued logic Adding user-defined Object Corresponds to… Model class Database table Field instance Column on a table Model instance Row in a database table When starting a project with peewee, it’s typically best to begin with your data

Non-integer Primary Keys, Composite Keys and other Tricks Self-referential foreign keys Circular foreign key dependencies Querying Creating a new record Bulk inserts Updating existing records Atomic updates backend Postgresql Extensions DataSet Django Integration Fields Generic foreign keys Hybrid Attributes Key/Value Store Shortcuts Signal support pwiz, a model generator Schema Migrations Reflection Database Thing Corresponds to… Model class Database table Field instance Column on a table Model instance Row in a database table When starting a project with peewee, it’s typically best to begin with your data

input function call as parameter, and returns a dictionary with the name of the single input as its key and the input data as its value: if p < 10: return 'Too young!!' if p > 60: return def edit_row(choice, row): put_text("You click %s button ar row %s" % (choice, row)) put_table([ ['Idx', 'Actions'], [1, put_buttons(['edit', 'delete'], onclick=partial(edit_row, row=1))], [2, put_buttons(['edit', 'delete'], onclick=partial(edit_row, row=2))], [3, put_buttons(['edit', 'delete'], onclick=partial(edit_row, row=3))], ]) In fact, all output can be bound to click events

input function call as parameter, and returns a dictionary with the name of the single input as its key and the input data as its value: if p < 10: return 'Too young!!' if p > 60: return def edit_row(choice, row): put_text("You click %s button ar row %s" % (choice, row)) put_table([ ['Idx', 'Actions'], [1, put_buttons(['edit', 'delete'], onclick=partial(edit_row, row=1))], [2, put_buttons(['edit', 'delete'], onclick=partial(edit_row, row=2))], [3, put_buttons(['edit', 'delete'], onclick=partial(edit_row, row=3))], ]) In fact, all output can be bound to click events

input function call as parameter, and returns a dictionary with the name of the single input as its key and the input data as its value: if p < 10: return 'Too young!!' if p > 60: return def edit_row(choice, row): put_text("You click %s button ar row %s" % (choice, row)) put_table([ ['Idx', 'Actions'], [1, put_buttons(['edit', 'delete'], onclick=partial(edit_row, row=1))], [2, put_buttons(['edit', 'delete'], onclick=partial(edit_row, row=2))], [3, put_buttons(['edit', 'delete'], onclick=partial(edit_row, row=3))], ]) In fact, all output can be bound to click events

cryptographically signed by the releasing developer, who through January 2016 was Marc Delisle. His key id is 0xFEFC65D181AF644A, his PGP fingerprint is: 436F F188 4B1A 0C3F DCBF 0D79 FEFC 65D1 81AF 644A . Beginning in January 2016, the release manager is Isaac Bennetch. His key id is 0xCE752F178259BD92, and his PGP fingerprint is: 3D06 A59E CE73 0EB7 1B51 1C17 CE75 2F17 8259 io/ibennetch>. Some additional downloads (for example themes) might be signed by Michal Čihař. His key id is 0x9C27B31342B7511D, and his PGP fingerprint is: 63CB 1DF1 EF12 CF2A C0EE 5A32 9C27 B313 42B7