aboutsummaryrefslogtreecommitdiff
path: root/wqflask/base/data_set/probably_unused.py
blob: 4e54bcffe447e3e3b40169cbe0edea78324c8f4c (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
"Functions that are probably unused in the code"

import pickle as pickle

from wqflask.database import database_connection

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() 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