def update_one(mydb, item, table_name): """Summary of update_one. Args: mydb item table_name Raises: mvc_exc: ItemNotStored """ table_name = scrub(table_name) table = mydb.table(table_name) if table_name == PLAYER: if not table.update( { 'first_name': item.first_name, 'last_name': item.last_name, 'birth_date': item.birth_date, 'gender': item.gender, 'rank': item.rank, 'match_score': item.match_score, 'current_score': item.current_score, 'opponents': item.opponents }, ((where('first_name') == item.first_name) & (where('last_name') == item.last_name))): raise mvc_exc.ItemNotStored( 'Can\'t update "{}" because it\'s not stored ' 'in the table "{}"'.format( item.first_name + ' ' + item.last_name, table_name)) else: rounds = [] for roun in item.rounds: rounds.append(json.loads(roun.to_json())) players = [] for play in item.players: players.append(json.loads(play.to_json())) if not table.update( { 'name': item.name, 'place': item.place, 'date': item.date, 'round_count': item.round_count, 'rounds': rounds, 'players': players, 'time_control': item.time_control, 'description': item.description }, where('name') == item.name): raise mvc_exc.ItemNotStored( 'Can\'t update "{}" because it\'s not stored ' 'in the table "{}"'.format(item.name, table_name))
def select_one(item_name, table_name): result = products_collection.find_one({'name': item_name}) if result is not None: return result else: raise mvc_exc.ItemNotStored( f"Can't read '{item_name}' because it's not stored in table '{table_name}'" )
def delete_one(name, table_name): result = products_collection.find_one({'name': name}) if result is not None: products_collection.delete_one({'name': name}) else: raise mvc_exc.ItemNotStored( f"Can't delete '{name}' because it's not stored in table '{table_name}'" )
def select_one(conn, item_name, table_name): product = conn.query(Product).filter(Product.name == item_name).first() if product is not None: return product.to_dict() else: raise mvc_exc.ItemNotStored( f"Can't read '{item_name}' because it's not stored in table '{table_name}'")
def delete_one(conn, name, table_name): product = conn.query(Product).filter(Product.name == name).first() if product is not None: conn.delete(product) conn.commit() else: raise mvc_exc.ItemNotStored( f"Can't delete '{name}' because it's not stored in table '{table_name}'")
def delete_one(conn, item_name, table_name): table = conn.load_table(table_name) row = table.find_one(name=item_name) if row is not None: table.delete(name=item_name) else: raise mvc_exc.ItemNotStored( f"Can't delete '{item_name}' because it's not stored in table '{table.table.name}'" )
def select_one(conn, item_name, table_name): result = conn.execute( select([products]).where(products.c.name == item_name)).first() if result is not None: return tuple_to_dict(result) else: raise mvc_exc.ItemNotStored( f"Can't read '{item_name}' because it's not stored in table '{table_name}'" )
def select_one(conn, name, table_name): table = conn.load_table(table_name) row = table.find_one(name=name) if row is not None: return dict(row) else: raise mvc_exc.ItemNotStored( f"Can't read '{name}' because it's not stored in '{table.table.name}'" )
def delete_one(conn, name, table_name): result = conn.execute(select([products ]).where(products.c.name == name)).first() if result is not None: conn.execute(delete(products).where(products.c.name == name)) else: raise mvc_exc.ItemNotStored( f"Can't delete '{name}' because it's not stored in table '{table_name}'" )
def update_one(conn, name, price, quantity, table_name): table = conn.load_table(table_name) row = table.find_one(name=name) if row is not None: item = {'name': name, 'price': price, 'quantity': quantity} table.update(item, keys=['name']) else: raise mvc_exc.ItemNotStored( f"Can't update '{name}' because it's not stored in table '{table.table.name}'" )
def update_one(conn, name, price, quantity, table_name): product = conn.query(Product).filter(Product.name == name).first() if product is not None: product.price = price product.quantity = quantity conn.commit() else: raise mvc_exc.ItemNotStored( f"Can't update '{name}' because it's not stored in table '{table_name}'")
def update_one(conn, name, price, quantity, table_name): result = conn.execute(select([products ]).where(products.c.name == name)).first() if result is not None: conn.execute( update(products).where(products.c.name == name).values( price=price, quantity=quantity)) else: raise mvc_exc.ItemNotStored( f"Can't update '{name}' because it's not stored in table '{table_name}'" )
def select_one(conn, item_name, table_name): table_name = scrub(table_name) item_name = scrub(item_name) sql = f'SELECT * FROM {table_name} WHERE name="{item_name}"' c = conn.execute(sql) result = c.fetchone() if result is not None: return tuple_to_dict(result) else: raise mvc_exc.ItemNotStored( f"Can't read '{item_name}' because it's not stored in table '{table_name}'" )
def update_one(name, price, quantity, table_name): result = products_collection.find_one({'name': name}) if result is not None: products_collection.update( {'name': name}, {'$set': { 'price': price, 'quantity': quantity }}) else: raise mvc_exc.ItemNotStored( f"Can't update '{name}' because it's not stored in table '{table_name}'" )
def delete_one(conn, name, table_name): table_name = scrub(table_name) sql_check = f'SELECT EXISTS(SELECT 1 FROM {table_name} WHERE name=? LIMIT 1)' sql_delete = f'DELETE FROM {table_name} WHERE name=?' c = conn.execute(sql_check, (name, )) result = c.fetchone() if result[0]: c.execute(sql_delete, (name, )) conn.commit() else: raise mvc_exc.ItemNotStored( f"Can't delete '{name}' because it's not stored in table '{table_name}''" )
def update_one(conn, name, price, quantity, table_name): table_name = scrub(table_name) sql_check = f'SELECT EXISTS(SELECT 1 FROM {table_name} WHERE name=? LIMIT 1)' sql_update = f'UPDATE {table_name} SET price=?, quantity=? WHERE name=?' c = conn.execute(sql_check, (name, )) result = c.fetchone() if result[0]: c.execute(sql_update, (price, quantity, name)) conn.commit() else: raise mvc_exc.ItemNotStored( f"Can't update '{name}' because it's not stored in table '{table_name}'" )
def read_item(name): global items myitems = list( filter( lambda x: x['name'] == name, items ) ) if myitems: return myitems[0] else: raise mvc_exc.ItemNotStored( f"Can't read '{name}' because it's not stored")
def delete_item(name): global items idx_items = list( filter( lambda i_x: i_x[1]['name'] == name, enumerate(items) ) ) if idx_items: i, item_to_delete = idx_items[0][0], idx_items[0][1] del items[i] else: raise mvc_exc.ItemNotStored( f"Can't delete '{name}' because it's not stored")
def update_item(name, price, quantity): global items idx_items = list( filter( lambda i_x: i_x[1]['name'] == name, enumerate(items) ) ) if idx_items: i, item_to_update = idx_items[0][0], idx_items[0][1] items[i] = {'name': name, 'price': price, 'quantity': quantity} else: raise mvc_exc.ItemNotStored( f"Can't update '{name}' because it's not stored")
def select_one_by_rank(mydb, item_rank, table_name): """Summary of select_one by rank. Args: mydb item_rank table_name Raises: mvc_exc: ItemNotStored """ table_name = scrub(table_name) table = mydb.table(table_name) item = table.search(where('rank') == item_rank) if item: return item[0] raise mvc_exc.ItemNotStored( 'Can\'t read "{}" because it\'s not stored in table "{}"'.format( item_rank, table_name))
def select_one(mydb, item_name, table_name): """Summary of select_one. Args: mydb item_name table_name Raises: mvc_exc: ItemNotStored """ table_name = scrub(table_name) table = mydb.table(table_name) if table_name == PLAYER: item = table.search((where('first_name') == item_name.split(' ')[0]) & (where('last_name') == item_name.split(' ')[1])) else: item = table.search(where('name') == item_name) if item: return item[0] raise mvc_exc.ItemNotStored( 'Can\'t read "{}" because it\'s not stored in table "{}"'.format( item_name, table_name))