X-Git-Url: https://us-delaporte.pagekite.me/gitweb/matrix-shop-bot.git/blobdiff_plain/4503755f5b9624a373db24ab8072532c2a97590a..771e4921c60966b96f2b0f47ed20b7c31fb2813a:/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