diff options
author | Lei Yan | 2016-02-25 16:42:15 +0000 |
---|---|---|
committer | Lei Yan | 2016-02-25 16:42:15 +0000 |
commit | e55f38a72d47fbdf5f652a08e8da1db78f1dcdb5 (patch) | |
tree | 68161b76858cf72f7a7b5576de6384042e214d8e /wqflask/maintenance/dataset/utilities.py | |
parent | 7263c52a7d903a2dbdd5d05411821ec960961b4d (diff) | |
parent | ece60a2d25ed71980121ac1c1854c3ab3514f453 (diff) | |
download | genenetwork2-e55f38a72d47fbdf5f652a08e8da1db78f1dcdb5.tar.gz |
Merge /home/zas1024/gene
Diffstat (limited to 'wqflask/maintenance/dataset/utilities.py')
-rw-r--r-- | wqflask/maintenance/dataset/utilities.py | 89 |
1 files changed, 0 insertions, 89 deletions
diff --git a/wqflask/maintenance/dataset/utilities.py b/wqflask/maintenance/dataset/utilities.py deleted file mode 100644 index 787c9481..00000000 --- a/wqflask/maintenance/dataset/utilities.py +++ /dev/null @@ -1,89 +0,0 @@ -import MySQLdb -import re -import ConfigParser - -def get_cursor(): - host = 'localhost' - user = 'gn2' - passwd = 'UhHJuiS6gC8hj4a' - db = 'db_webqtl' - con = MySQLdb.Connect(db=db, host=host, user=user, passwd=passwd) - cursor = con.cursor() - return cursor, con - -def clearspaces(s, default=None): - if s: - s = re.sub('\s+', ' ', s) - s = s.strip() - return s - else: - return default - -def to_dic(keys, values): - dic = {} - for i in range(len(keys)): - key = keys[i] - value = values[i] - dic[key] = value - return dic - -def overlap(dic1, dic2): - keys = [] - values1 = [] - values2 = [] - for key in dic1.keys(): - if key in dic2: - value1 = dic1[key] - value2 = dic2[key] - if value1 and value2: - keys.append(key) - values1.append(value1) - values2.append(value2) - return keys, values1, values2 - -def to_db_string(s, default): - if s: - s = s.strip() - if len(s) == 0: - return default - elif s == 'x': - return default - else: - return s - else: - return default - -def to_db_float(s, default): - if s: - s = s.strip() - if len(s) == 0: - return default - elif s == 'x': - return default - else: - try: - return float(s) - except: - return default - else: - return default - -def to_db_int(s, default): - if s: - s = s.strip() - if len(s) == 0: - return default - elif s == 'x': - return default - else: - try: - return int(s) - except: - return default - else: - return default - -def get_config(configfile): - config = ConfigParser.ConfigParser() - config.read(configfile) - return config |