X-Git-Url: https://apps.delaporte.us/gitweb/matrix-shop-bot.git/blobdiff_plain/4503755f5b9624a373db24ab8072532c2a97590a..6f1d87bb9904103ecb69847628f4d6696e455b0c:/matrix_shop_bot/db.py diff --git a/matrix_shop_bot/db.py b/matrix_shop_bot/db.py index 278d4a1..ce0d46e 100644 --- a/matrix_shop_bot/db.py +++ b/matrix_shop_bot/db.py @@ -150,7 +150,7 @@ class Data(): def list_purchases(self, store_name): with Session(self.engine) as session: - cmd = select(PurchaseRecord).where(PurchaseRecord.store == store_name) + cmd = select(PurchaseRecord).where(func.lower(PurchaseRecord.store) == func.lower(store_name)) records = session.exec(cmd).all() return records