args – a list of Q or Node objects • kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type SelectQuery with appropriate WHERE clauses Provides a django-like syntax for building args – a list of Q or Node objects • kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type Model instance or raises DoesNotExist exception Get a single row from the database that args – a list of Q or Node objects • kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type a SelectQuery instance Provides a django-like syntax for building a query. The key difference

Parameters: args – a list of Q or Node objects kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type: SelectQuery with appropriate WHERE clauses Provides a django-like syntax for building Parameters: args – a list of Q or Node objects kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type: Model instance or raises DoesNotExist exception Get a single row from the database Parameters: args – a list of Q or Node objects kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type: a SelectQuery instance Provides a django-like syntax for building a query. The key

args – a list of Q or Node objects • kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type SelectQuery with appropriate WHERE clauses Provides a django-like syntax for building args – a list of Q or Node objects • kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type Model instance or raises DoesNotExist exception Get a single row from the database that args – a list of Q or Node objects • kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type a SelectQuery instance Provides a django-like syntax for building a query. The key difference

Parameters: args – a list of Q or Node objects kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type: SelectQuery with appropriate WHERE clauses Provides a django-like syntax for building Parameters: args – a list of Q or Node objects kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type: Model instance or raises DoesNotExist exception Get a single row from the database Parameters: args – a list of Q or Node objects kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type: a SelectQuery instance Provides a django-like syntax for building a query. The key

expressions, e.g. Usre.username == ’foo’ • kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type Model instance or raises DoesNotExist exception Get a single row from the database that peewee Documentation, Release 2.0.0 • kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type SelectQuery with appropriate WHERE clauses Provides a django-like syntax for building args – a list of DQ or Node objects • kwargs – a mapping of column + lookup to value, e.g. “age__gt=55” Return type SelectQuery with appropriate WHERE clauses 46 Chapter 1. Contents: peewee Documentation

Bitmap() # Sets the ith bit, e.g. the 1st bit, the 11th bit, the 63rd, etc. bits_to_set = (1, 11, 63, 31, 55, 48, 100, 99) for bit_idx in bits_to_set: bitmap.data.set_bit(bit_idx) # We can test whether a bit information, see: • Model.add_index() • Model.index() • ModelIndex • Index 1.6. Models and Fields 55 peewee Documentation, Release 3.6.0 Table constraints Peewee allows you to add arbitrary constraints page) # counter value rsum # 1 10. 10. # 1 20. 50. # 1 20. 50. # 2 1. 52. # 2 1. 52. # 2 3. 55. # 3 100 155. With the inclusion of the new rows we now have some rows that have duplicate category

Bitmap() # Sets the ith bit, e.g. the 1st bit, the 11th bit, the 63rd, etc. bits_to_set = (1, 11, 63, 31, 55, 48, 100, 99) for bit_idx in bits_to_set: bitmap.data.set_bit(bit_idx) # We can test whether a 50. # 1 20. 50. # 2 1. 52. # 2 1. 52. # 2 3. 55. # 3 100 155. With the inclusion of the new rows we now have some rows that have duplicate 30. # 1 20. 50. # 2 1. 51. # 2 1. 52. # 2 3. 55. # 3 100 155. Peewee uses these rules for determining what frame-type to use: If the

Bitmap() # Sets the ith bit, e.g. the 1st bit, the 11th bit, the 63rd, etc. bits_to_set = (1, 11, 63, 31, 55, 48, 100, 99) for bit_idx in bits_to_set: bitmap.data.set_bit(bit_idx) # We can test whether a bit price = DecimalField() class Meta: constraints = [Check('price < 10000')] 1.6. Models and Fields 55 peewee Documentation, Release 3.5.0 1.6.5 Non-integer Primary Keys, Composite Keys and other Tricks Bitmap() # Sets the ith bit, e.g. the 1st bit, the 11th bit, the 63rd, etc. bits_to_set = (1, 11, 63, 31, 55, 48, 100, 99) for bit_idx in bits_to_set: (continues on next page) 128 Chapter 1. Contents: peewee

_db_connect(): db.connect() def _db_close(): if not db.is_closed(): (continues on next page) 1.6. Database 55 peewee Documentation, Release 3.3.0 (continued from previous page) db.close() cherrypy.engine. Bitmap() # Sets the ith bit, e.g. the 1st bit, the 11th bit, the 63rd, etc. bits_to_set = (1, 11, 63, 31, 55, 48, 100, 99) for bit_idx in bits_to_set: (continues on next page) 68 Chapter 1. Contents: peewee Bitmap() # Sets the ith bit, e.g. the 1st bit, the 11th bit, the 63rd, etc. bits_to_set = (1, 11, 63, 31, 55, 48, 100, 99) for bit_idx in bits_to_set: bitmap.data.set_bit(bit_idx) # We can test whether a bit

close() In your application main() make sure MyRequest is used as request_factory: 1.6. Database 55 peewee Documentation, Release 3.4.0 def main(global_settings, **settings): config = Configurator(settings=settings page) # Sets the ith bit, e.g. the 1st bit, the 11th bit, the 63rd, etc. bits_to_set = (1, 11, 63, 31, 55, 48, 100, 99) for bit_idx in bits_to_set: bitmap.data.set_bit(bit_idx) # We can test whether a bit Bitmap() # Sets the ith bit, e.g. the 1st bit, the 11th bit, the 63rd, etc. bits_to_set = (1, 11, 63, 31, 55, 48, 100, 99) for bit_idx in bits_to_set: bitmap.data.set_bit(bit_idx) # We can test whether a bit