migrate to latest myscale

app.py

@@ -42,8 +42,11 @@ def init_db():
         meta_field: Meta field that records if an image is viewed 
         client:     Database connection object
     """
-    client = Client(
-        url=st.secrets["DB_URL"], user=st.secrets["USER"], password=st.secrets["PASSWD"])
+    r = parse("{http_pre}://{host}:{port}", st.secrets["DB_URL"])
+    client = get_client(
+        host=r['host'], port=r['port'], user=st.secrets["USER"], password=st.secrets["PASSWD"],
+        interface=r['http_pre'],
+    )
     # We can check if the connection is alive
     assert client.is_alive()
     meta_field = {}
@@ -126,7 +129,7 @@ def esm_search(model, sequnce, batch_converter,top_k=5):
     client = Client(
         url=st.secrets["DB_URL"], user=st.secrets["USER"], password=st.secrets["PASSWD"])
     
-    result = client.fetch("SELECT seq, distance('topK=500')(representations, " + str(token_list) + ')'+ "as dist FROM default.esm_protein_indexer_768")
+    result = client.fetch("SELECT seq, distance(representations, " + str(token_list) + ')'+ "as dist FROM default.esm_protein_indexer_768 ORDER BY dist LIMIT 500")
     
     result_temp_seq = []