usage: class Bitmap(Model): data = BigBitField() bitmap = 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: usage: class Bitmap(Model): data = BigBitField() bitmap = 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: store arbitrary key/value pairs on House instances: >>> h = House.create( ... address='123 Main St', ... features={'garage': '2 cars', 'bath': '2 bath'}) ... >>> h_from_db = House.get(House.id ==

facid)) List each member’s first booking after September 1st 2012 Produce a list of each member name, id, and their first booking after September 1st 2012. Order by member ID. SELECT m.surname, m.firstname usage: class Bitmap(Model): data = BigBitField() bitmap = 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: usage: class Bitmap(Model): data = BigBitField() bitmap = 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:

facid)) List each member’s first booking after September 1st 2012 Produce a list of each member name, id, and their first booking after September 1st 2012. Order by member ID. SELECT m.surname, m.firstname usage: class Bitmap(Model): data = BigBitField() bitmap = 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: usage: class Bitmap(Model): data = BigBitField() bitmap = 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:

usage: class Bitmap(Model): data = BigBitField() bitmap = 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: usage: class Bitmap(Model): data = BigBitField() bitmap = 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: now store arbitrary key/value pairs on House instances: >>> h = House.create( ... address='123 Main St', ... features={'garage': '2 cars', 'bath': '2 bath'}) ... >>> h_from_db = House.get(House.id ==

facid)) List each member’s first booking after September 1st 2012 Produce a list of each member name, id, and their first booking after September 1st 2012. Order by member ID. SELECT m.surname, m.firstname usage: class Bitmap(Model): data = BigBitField() bitmap = 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: usage: class Bitmap(Model): data = BigBitField() bitmap = 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:

facid)) List each member’s first booking after September 1st 2012 Produce a list of each member name, id, and their first booking after September 1st 2012. Order by member ID. SELECT m.surname, m.firstname peewee Documentation, Release 3.4.0 (continued from previous 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: usage: class Bitmap(Model): data = BigBitField() bitmap = 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:

facid)) List each member’s first booking after September 1st 2012 Produce a list of each member name, id, and their first booking after September 1st 2012. Order by member ID. SELECT m.surname, m.firstname usage: class Bitmap(Model): data = BigBitField() bitmap = 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: store arbitrary key/value pairs on House instances: >>> h = House.create( ... address='123 Main St', ... features={'garage': '2 cars', 'bath': '2 bath'}) ... >>> h_from_db = House.get(House.id ==

usage: class Bitmap(Model): data = BigBitField() bitmap = 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: usage: class Bitmap(Model): data = BigBitField() bitmap = Bitmap() # Sets the ith bit, e.g. the 1st bit, the 11th bit, the 63rd, etc. Parameters: Parameters: Parameters: Returns: Parameters: Returns: store arbitrary key/value pairs on House instances: >>> h = House.create( ... address='123 Main St', ... features={'garage': '2 cars', 'bath': '2 bath'}) ... >>> h_from_db = House.get(House.id ==

usage: class Bitmap(Model): data = BigBitField() bitmap = 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: usage: class Bitmap(Model): data = BigBitField() bitmap = 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: now store arbitrary key/value pairs on House instances: >>> h = House.create( ... address='123 Main St', ... features={'garage': '2 cars', 'bath': '2 bath'}) ... >>> h_from_db = House.get(House.id ==

can now store arbitrary key/value pairs on House instances: >>> h = House.create(address=’123 Main St’, features={’garage’: ’2 cars’, ’bath’: ’2 bath’}) >>> h_from_db = House.get(House.id == h.id) >>> print h.address, h.keys 123 Main St [u’bath’, u’garage’] >>> for h in House.select(House.address, f.values().alias(’vals’)): ... print h.address, h.vals 123 Main St [u’2 bath’, u’2 cars’] >>> for h h in House.select(House.address, f.items().alias(’mtx’)): ... print h.address, h.mtx 123 Main St [[u’bath’, u’2 bath’], [u’garage’, u’2 cars’]] You can retrieve a slice of data, for example, all the garage