X-Git-Url: https://apps.delaporte.us/gitweb/matrix-shop-bot.git/blobdiff_plain/8b639943d820c97787fed92731f0ec8d13e9ac7e..b988f8c87df51797f52d20ae91c14c739459b758:/matrix_shop_bot/db.py diff --git a/matrix_shop_bot/db.py b/matrix_shop_bot/db.py index 60339ee..278d4a1 100644 --- a/matrix_shop_bot/db.py +++ b/matrix_shop_bot/db.py @@ -183,13 +183,20 @@ class Data(): return results - def clear_list(self, store_id, clear_all=False): + def clear_list(self, store_name, clear_all=False): + results = [] with Session(self.engine) as session: - store = session.exec(_get_with_id(Store, store_id)).first() + store = session.exec(_get_with_name(Store, store_name)).first() + if not store: + return [f'Store {store_name} not found.'] + for item in store.shopping_list: if clear_all or item.purchase_date: session.delete(item) + session.commit() + results = store.get_pretty_shopping_list() + return results def get_stores(self): with Session(self.engine) as session: