aboutsummaryrefslogtreecommitdiff
path: root/gn3/db/datasets.py
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2022-02-18 14:17:29 +0300
committerFrederick Muriuki Muriithi2022-02-18 14:17:29 +0300
commit75dcfe295af57b16428c586cc11dbaa827a5feba (patch)
treef24fe87f97a278552f7d1d9ad4b998339a1affe8 /gn3/db/datasets.py
parent83a7aa7533f8f4ecac049dc0e93aff6429e6e5ae (diff)
downloadgenenetwork3-75dcfe295af57b16428c586cc11dbaa827a5feba.tar.gz
Remove code trying to query non-existent `TempFreeze` table
The code was migrated from GN1 with a faulty assumption that all trait types have a corresponding `*Freeze` table in the database. This assumption is not true for the `Temp` traits. This commit removes the buggy code.
Diffstat (limited to 'gn3/db/datasets.py')
-rw-r--r--gn3/db/datasets.py28
1 files changed, 1 insertions, 27 deletions
diff --git a/gn3/db/datasets.py b/gn3/db/datasets.py
index a41e228..1d6cdf8 100644
--- a/gn3/db/datasets.py
+++ b/gn3/db/datasets.py
@@ -82,30 +82,6 @@ def retrieve_geno_trait_dataset_name(
"dataset_shortname"],
cursor.fetchone()))
-def retrieve_temp_trait_dataset_name(
- threshold: int, name: str, connection: Any):
- """
- Get the ID, DataScale and various name formats for a `Temp` trait.
- """
- query = (
- "SELECT Id, Name, FullName, ShortName "
- "FROM TempFreeze "
- "WHERE "
- "public > %(threshold)s "
- "AND "
- "(Name = %(name)s OR FullName = %(name)s OR ShortName = %(name)s)")
- with connection.cursor() as cursor:
- cursor.execute(
- query,
- {
- "threshold": threshold,
- "name": name
- })
- return dict(zip(
- ["dataset_id", "dataset_name", "dataset_fullname",
- "dataset_shortname"],
- cursor.fetchone()))
-
def retrieve_dataset_name(
trait_type: str, threshold: int, trait_name: str, dataset_name: str,
conn: Any):
@@ -120,9 +96,7 @@ def retrieve_dataset_name(
"ProbeSet": retrieve_probeset_trait_dataset_name,
"Publish": retrieve_publish_trait_dataset_name,
"Geno": retrieve_geno_trait_dataset_name,
- "Temp": retrieve_temp_trait_dataset_name}
- if trait_type == "Temp":
- return retrieve_temp_trait_dataset_name(threshold, trait_name, conn)
+ "Temp": lambda threshold, dataset_name, conn: {}}
return fn_map[trait_type](threshold, dataset_name, conn)