begin working with the data, we’ll define the model classes that correspond to the tables in the diagram. Note In some cases we explicitly specify column names for a particular field. This is so our models MD5(FileChunk.data)) .group_by(FileChunk.filename) .order_by(FileChunk.filename, FileChunk.sequence)) Example collation: @db.collation('ireverse') def collate_reverse(s1, s2): # Case-insensitive table constraints = None - a list of one or more constraints, e.g. [Check('price > 0')] sequence = None – sequence to populate field (if backend supports it) collation = None – collation to use for ordering

MD5(FileChunk.data)) .group_by(FileChunk.filename) .order_by(FileChunk.filename, FileChunk.sequence)) Example collation: @db.collation('ireverse') def collate_reverse(s1, s2): # Case-insensitive key for the table constraints = None - one or more constraints, e.g. [Check('price > 0')] sequence = None – sequence name (if backend supports it) collation = None – collation to use for ordering the field dest_table='entry', dest_column='id', table='entrytag'), ...] sequence_exists(seq) seq (str) – Name of sequence. Whether sequence exists. bool create_tables(models[, **options]) models (list) –

begin working with the data, we’ll define the model classes that correspond to the tables in the diagram. Note In some cases we explicitly specify column names for a particular field. This is so our models MD5(FileChunk.data)) .group_by(FileChunk.filename) .order_by(FileChunk.filename, FileChunk.sequence)) Example collation: @db.collation('ireverse') def collate_reverse(s1, s2): # Case-insensitive table constraints = None - a list of one or more constraints, e.g. [Check('price > 0')] sequence = None – sequence to populate field (if backend supports it) collation = None – collation to use for ordering

begin working with the data, we’ll define the model classes that correspond to the tables in the diagram. Note In some cases we explicitly specify column names for a particular field. This is so our models MD5(FileChunk.data)) .group_by(FileChunk.filename) .order_by(FileChunk.filename, FileChunk.sequence)) Example collation: @db.collation('ireverse') def collate_reverse(s1, s2): # Case-insensitive table constraints = None - a list of one or more constraints, e.g. [Check('price > 0')] sequence = None – sequence to populate field (if backend supports it) collation = None – collation to use for ordering

filename, fn.MD5(FileChunk.data)) .group_by(FileChunk.filename) .order_by(FileChunk.filename, FileChunk.sequence)) Example collation: @db.collation('ireverse') def collate_reverse(s1, s2): # Case-insensitive the table • constraints = None - one or more constraints, e.g. [Check('price > 0')] • sequence = None – sequence name (if backend supports it) • collation = None – collation to use for ordering the field dest_table='entry', dest_column='id', table='entrytag'), ...] sequence_exists(seq) Parameters seq (str) – Name of sequence. Returns Whether sequence exists. Return type bool create_tables(models[, **options])

begin working with the data, we’ll define the model classes that correspond to the tables in the diagram. Note: In some cases we explicitly specify column names for a particular field. This is so our models filename, fn.MD5(FileChunk.data)) .group_by(FileChunk.filename) .order_by(FileChunk.filename, FileChunk.sequence)) Example collation: @db.collation('ireverse') def collate_reverse(s1, s2): # Case-insensitive [Check('price > 0')] 64 Chapter 1. Contents: peewee Documentation, Release 3.3.0 • sequence = None – sequence to populate field (if backend supports it) • collation = None – collation to use for ordering

begin working with the data, we’ll define the model classes that correspond to the tables in the diagram. Note: In some cases we explicitly specify column names for a particular field. This is so our models filename, fn.MD5(FileChunk.data)) .group_by(FileChunk.filename) .order_by(FileChunk.filename, FileChunk.sequence)) Example collation: @db.collation('ireverse') def collate_reverse(s1, s2): # Case-insensitive • constraints = None - a list of one or more constraints, e.g. [Check('price > 0')] • sequence = None – sequence to populate field (if backend supports it) • collation = None – collation to use for ordering

MD5(FileChunk.data)) .group_by(FileChunk.filename) .order_by(FileChunk.filename, FileChunk.sequence)) Example collation: @db.collation('ireverse') def collate_reverse(s1, s2): # Case-insensitive key for the table constraints = None - one or more constraints, e.g. [Check('price > 0')] sequence = None – sequence name (if backend supports it) collation = None – collation to use for ordering the field name='entries_public', sql='CREATE VIEW entries_public AS SELECT ... '), ...] sequence_exists(seq) seq (str) – Name of sequence. Whether sequence exists. bool create_tables(models[, **options]) models (list) –

filename, fn.MD5(FileChunk.data)) .group_by(FileChunk.filename) .order_by(FileChunk.filename, FileChunk.sequence)) Example collation: @db.collation('ireverse') def collate_reverse(s1, s2): # Case-insensitive the table • constraints = None - one or more constraints, e.g. [Check('price > 0')] • sequence = None – sequence name (if backend supports it) • collation = None – collation to use for ordering the field sql='CREATE VIEW entries_public AS SELECT ... '), ...] sequence_exists(seq) Parameters seq (str) – Name of sequence. Returns Whether sequence exists. Return type bool create_tables(models[, **options])

of the database table this model maps to ordering: a sequence of columns to use as the default ordering for this model pk_sequence: name of sequence to create for the primary key (peewee will autogenerate create_sequence(sequence_name) Parameters: sequence_name – name of sequence to create Note only works with database engines that support sequences drop_sequence(sequence_name) Parameters: sequence_name sequence_name – name of sequence to drop Note only works with database engines that support sequences get_indexes_for_table(table) Parameters: table – the name of table to introspect Return type: a list of (index_name