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

to indexes: a list of fields to index 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

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 46 Chapter 1. Contents: peewee

name of the database table this model maps to • indexes: a list of fields to index • order_by: a sequence of columns to use as the default ordering for this model Specifying indexes: class Transaction(Model): display • primary_key = False – whether this field is the primary key for the table • sequence = None – sequence to populate field (if backend supports it) Field Type Sqlite Postgresql MySQL CharField display • primary_key (boolean) – whether to use this as the primary key for the table • sequence – name of sequence (if backend supports it) db_value(value) Parameters value – python data type to prep

• indexes: a list of fields to index • 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 52 Chapter 1. Contents: peewee Documentation, Release 1.0.0 get_indexes_for_table(table) Parameters table

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 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) –

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) –

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 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) –

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 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) –

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])