Update calls to `database_connection` function

Pass in the database URI at call time.

1 files changed, 4 insertions, 2 deletions

diff --git a/wqflask/db/webqtlDatabaseFunction.py b/wqflask/db/webqtlDatabaseFunction.py
index 878792b4..b09cf377 100644
--- a/wqflask/db/webqtlDatabaseFunction.py
+++ b/wqflask/db/webqtlDatabaseFunction.py
@@ -22,12 +22,14 @@
 
 from wqflask.database import database_connection
 
+from utility.tools import get_setting
+
 
 def retrieve_species(group):
     """Get the species of a group (e.g. returns string "mouse" on "BXD"
 
     """
-    with database_connection() as conn, conn.cursor() as cursor:
+    with database_connection(get_setting("SQL_URI")) as conn, conn.cursor() as cursor:
         cursor.execute(
             "SELECT Species.Name FROM Species, InbredSet WHERE InbredSet.Name = %s AND InbredSet.SpeciesId = Species.Id",
             (group,))
@@ -37,7 +39,7 @@ def retrieve_species(group):
 
 
 def retrieve_species_id(group):
-    with database_connection() as conn, conn.cursor() as cursor:
+    with database_connection(get_setting("SQL_URI")) as conn, conn.cursor() as cursor:
         cursor.execute("SELECT SpeciesId FROM InbredSet WHERE Name = %s",
                        (group,))
         return cursor.fetchone()[0]