X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=main.py;h=ab523bec068fa4c00e08de16a1bf54ea7ef378ae;hb=51bc7cdec15d093272c259e793a9c691775b5194;hp=ee25182f24d54bd3326bd976d579c07c0ee896df;hpb=56c3a6078a2740d43072dfe30f07b17b442e3cc2;p=perso%2FImmae%2FProjets%2FCryptomonnaies%2FCryptoportfolio%2FTrader.git

diff --git a/main.py b/main.py
index ee25182..ab523be 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