help - show this help
add - add an item to shop for
add-store - add a store
- assign STORE_ID ITEM_ID - plan to shop for at store for item
+ assign ITEM_ID STORE_ID - plan to shop for at store for item
buy - mark item as purchased
clear STORE_ID - clear all purchased items for STORE_ID from database
clear-all STORE_ID - clear **all** items for STORE_ID from database
list STORE_ID - list all items assigned to store
list-stores - list all stores
- list-unsorted - list all items not assigned to any store
- remove ITEM_ID - remove a shopping item from the datatbase
+ unsorted - list all items not assigned to any store
+ remove-item ITEM_ID - remove a shopping item from the datatbase
remove-store STORE_ID - remove a store from the datatbase (requires clearing the list first)
setup - run one time database setup
'''
return [f'Store added with id {result}']
if match.command('assign'):
- store_id = int(match.args()[1])
- item_id = int(match.args()[2])
- Data().assign_store(store_id, item_id)
+ item_id = int(match.args()[1])
+ store_id = int(match.args()[2])
+
+ if not isinstance(store_id, int):
+ store_id = None
+
+ Data().assign_store(item_id, store_id)
# Now print the list for the assigned store
items = Data().get_shopping_list(store_id)
return ['Success']
if match.command('list'):
- store_id = ' '.join(match.args()[1:])
- if len(store_id) == 0:
- store_id = None
+ store_id_str = ' '.join(match.args()[1])
+ store_id = int(store_id_str) if store_id_str else None
items = Data().get_shopping_list(store_id)
+
results = ['Shopping List']
for item in items:
results.append(str(item))
if match.command('unsorted'):
- items = Data().list_unsorted()
+ items = Data().get_unsorted_list()
+ results = ['Items assigned to no store']
for item in items:
results.append(str(item))
return results
await bot.api.send_text_message(
room.room_id, str(line))
except Exception as ex:
- for line in ['You have:', ' no tea']:
+ for line in ['You have:', ' no tea', str(ex)]:
await bot.api.send_text_message(
room.room_id, str(line))
def add_item(self, name):
item_id = self._add_with_name(Item, name)
- if self.last_store_id:
+ if isinstance(self.last_store_id, int):
with Session(self.engine) as session:
store_id = self.last_store_id
store = session.exec(_get_with_id(Store, store_id)).first()
return items
def get_shopping_list(self, store_id=None) -> List[str]:
- if not store_id:
+ if isinstance(store_id, int):
+ self.last_store_id = store_id
+ else:
store_id = self.last_store_id
results = []