def main():
# CREATE
create_items(mock.items())
create_item('beer', price=3.0, quantity=15)
# if we try to re-create an object we get an ItemAlreadyStored exception
# create_item('beer', price=2.0, quantity=10)
# READ
print('READ items')
print(read_items())
# if we try to read an object not stored we get an ItemNotStored exception
# print('READ chocolate')
# print(read_item('chocolate'))
print('READ bread')
print(read_item('bread'))
# UPDATE
print('UPDATE bread')
update_item('bread', price=2.0, quantity=30)
print(read_item('bread'))
# if we try to update an object not stored we get an ItemNotStored exception
# print('UPDATE chocolate')
# update_item('chocolate', price=10.0, quantity=20)
# DELETE
print('DELETE beer')
delete_item('beer')
# if we try to delete an object not stored we get an ItemNotStored exception
# print('DELETE chocolate')
# delete_item('chocolate')
print('READ items')
print(read_items())
def main():
conn = connect_to_db()
table_name = "items"
create_table(conn, table_name)
# CREATE
insert_many(conn, items=mock.items(), table_name=table_name)
insert_one(conn, "beer", price=2.0, quantity=5, table_name=table_name)
# if we try to insert an object already stored we get an ItemAlreadyStored
# exception
# insert_one(conn, 'beer', 2.0, 5, table_name=table_name)
# READ
print("SELECT milk")
print(select_one(conn, "milk", table_name=table_name))
print("SELECT all")
print(select_all(conn, table_name=table_name))
# if we try to select an object not stored we get an ItemNotStored exception
# print(select_one(conn, 'pizza', table_name=table_name))
# UPDATE
print("UPDATE bread, SELECT bread")
update_one(conn, "bread", price=1.5, quantity=5, table_name=table_name)
print(select_one(conn, "bread", table_name=table_name))
# if we try to update an object not stored we get an ItemNotStored exception
# print('UPDATE pizza')
# update_one(conn, 'pizza', 9.5, 5, table_name=table_name)
# DELETE
print("DELETE beer, SELECT all")
delete_one(conn, "beer", table_name=table_name)
print(select_all(conn, table_name=table_name))
def main():
table_name = "items"
conn = connect_to_db() # in-memory database
# conn = connect_to_db(DB_name)
create_table(conn, table_name)
# CREATE
insert_many(conn, mock.items(), table_name="items")
insert_one(conn, "beer", price=2.0, quantity=5, table_name="items")
# if we try to insert an object already stored we get an ItemAlreadyStored
# exception
# insert_one(conn, 'milk', price=1.0, quantity=3, table_name='items')
# READ
print("SELECT milk")
print(select_one(conn, "milk", table_name="items"))
print("SELECT all")
print(select_all(conn, table_name="items"))
# if we try to select an object not stored we get an ItemNotStored exception
# print(select_one(conn, 'pizza', table_name='items'))
# conn.close() # the decorator @connect will reopen the connection
# UPDATE
print("UPDATE bread, SELECT bread")
update_one(conn, "bread", price=1.5, quantity=5, table_name="items")
print(select_one(conn, "bread", table_name="items"))
# if we try to update an object not stored we get an ItemNotStored exception
# print('UPDATE pizza')
# update_one(conn, 'pizza', price=1.5, quantity=5, table_name='items')
# DELETE
print("DELETE beer, SELECT all")
delete_one(conn, "beer", table_name="items")
print(select_all(conn, table_name="items"))
# if we try to delete an object not stored we get an ItemNotStored exception
# print('DELETE fish')
# delete_one(conn, 'fish', table_name='items')
# save (commit) the changes
# conn.commit()
# close connection
conn.close()
old_item_type = self.model.item_type
self.model.item_type = new_item_type
self.view.display_change_item_type(old_item_type, new_item_type)
def delete_item(self, name):
item_type = self.model.item_type
try:
self.model.delete_item(name)
self.view.display_item_deletion(name)
except mvc_exc.ItemNotStored as e:
self.view.display_item_not_yet_stored_error(name, item_type, e)
if __name__ == '__main__':
myitems = mock.items()
c = Controller(ModelBasic(myitems), View())
# c = Controller(ModelSQLite(myitems), View())
# c = Controller(ModelDataset(myitems), View())
c.show_items()
c.show_items(bullet_points=True)
c.show_item('chocolate')
c.show_item('bread')
c.insert_item('bread', price=1.0, quantity=5)
c.insert_item('chocolate', price=2.0, quantity=10)
c.show_item('chocolate')
c.update_item('milk', price=1.2, quantity=20)