X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=main.py;h=1c65e5644ca6ebbe855813da68bbef18ba995b16;hb=27bad39d3f2efcec0247b473627088149f462f79;hp=ee25182f24d54bd3326bd976d579c07c0ee896df;hpb=30700830b6c0aaaa59c148ebd8edb6931040ed13;p=perso%2FImmae%2FProjets%2FCryptomonnaies%2FCryptoportfolio%2FTrader.git diff --git a/main.py b/main.py index ee25182..1c65e56 100644 --- a/main.py +++ b/main.py @@ -71,9 +71,9 @@ def fetch_markets(user): cursor = dbs.psql.cursor() if user is None: - cursor.execute("SELECT id,config,user_id FROM market_configs") + cursor.execute("SELECT id,config,user_id FROM market_configs WHERE status='enabled'") else: - cursor.execute("SELECT id,config,user_id FROM market_configs WHERE user_id = %s", user) + cursor.execute("SELECT id,config,user_id FROM market_configs WHERE status='enabled' AND user_id = %s", user) for row in cursor: yield row