diff options
| author | Arun Isaac | 2023-12-29 18:55:37 +0000 |
|---|---|---|
| committer | Arun Isaac | 2023-12-29 19:01:46 +0000 |
| commit | 204a308be0f741726b9a620d88fbc22b22124c81 (patch) | |
| tree | b3cf66906674020b530c844c2bb4982c8a0e2d39 /wqflask/db | |
| parent | 83062c75442160427b50420161bfcae2c5c34c84 (diff) | |
| download | genenetwork2-204a308be0f741726b9a620d88fbc22b22124c81.tar.gz | |
Namespace all modules under gn2.
We move all modules under a gn2 directory. This is important for
"correct" packaging and deployment as a Guix service.
Diffstat (limited to 'wqflask/db')
| -rw-r--r-- | wqflask/db/__init__.py | 0 | ||||
| -rw-r--r-- | wqflask/db/webqtlDatabaseFunction.py | 45 |
2 files changed, 0 insertions, 45 deletions
diff --git a/wqflask/db/__init__.py b/wqflask/db/__init__.py deleted file mode 100644 index e69de29b..00000000 --- a/wqflask/db/__init__.py +++ /dev/null diff --git a/wqflask/db/webqtlDatabaseFunction.py b/wqflask/db/webqtlDatabaseFunction.py deleted file mode 100644 index b09cf377..00000000 --- a/wqflask/db/webqtlDatabaseFunction.py +++ /dev/null @@ -1,45 +0,0 @@ -# Copyright (C) University of Tennessee Health Science Center, Memphis, TN. -# -# This program is free software: you can redistribute it and/or modify it -# under the terms of the GNU Affero General Public License -# as published by the Free Software Foundation, either version 3 of the -# License, or (at your option) any later version. -# -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. -# See the GNU Affero General Public License for more details. -# -# This program is available from Source Forge: at GeneNetwork Project -# (sourceforge.net/projects/genenetwork/). -# -# Contact Drs. Robert W. Williams and Xiaodong Zhou (2010) -# at rwilliams@uthsc.edu and xzhou15@uthsc.edu -# -# -# -# This module is used by GeneNetwork project (www.genenetwork.org) - -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(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,)) - results = cursor.fetchone() - if results and results[0]: - return results[0] - - -def retrieve_species_id(group): - 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] |