aboutsummaryrefslogtreecommitdiff
path: root/gn2/base/data_set/probably_unused.py
diff options
context:
space:
mode:
Diffstat (limited to 'gn2/base/data_set/probably_unused.py')
-rw-r--r--gn2/base/data_set/probably_unused.py35
1 files changed, 35 insertions, 0 deletions
diff --git a/gn2/base/data_set/probably_unused.py b/gn2/base/data_set/probably_unused.py
new file mode 100644
index 00000000..12be05a7
--- /dev/null
+++ b/gn2/base/data_set/probably_unused.py
@@ -0,0 +1,35 @@
+"Functions that are probably unused in the code"
+
+import pickle as pickle
+
+from gn2.wqflask.database import database_connection
+from gn2.utility.tools import get_setting
+
+def create_datasets_list():
+ if USE_REDIS:
+ key = "all_datasets"
+ result = redis_conn.get(key)
+
+ if result:
+ datasets = pickle.loads(result)
+
+ if result is None:
+ datasets = list()
+ type_dict = {'Publish': 'PublishFreeze',
+ 'ProbeSet': 'ProbeSetFreeze',
+ 'Geno': 'GenoFreeze'}
+
+ for dataset_type in type_dict:
+ with database_connection(get_setting("SQL_URI")) as conn, conn.cursor() as cursor:
+ cursor.execute("SELECT Name FROM %s",
+ (type_dict[dataset_type],))
+ results = cursor.fetchall(query)
+ if results:
+ for result in results:
+ datasets.append(
+ create_dataset(result.Name, dataset_type))
+ if USE_REDIS:
+ redis_conn.set(key, pickle.dumps(datasets, pickle.HIGHEST_PROTOCOL))
+ redis_conn.expire(key, 60 * 60)
+
+ return datasets