aboutsummaryrefslogtreecommitdiff
path: root/wqflask/maintenance/dataset/utilities.py
diff options
context:
space:
mode:
Diffstat (limited to 'wqflask/maintenance/dataset/utilities.py')
-rw-r--r--wqflask/maintenance/dataset/utilities.py89
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