blob: 6033d7b42defcf0bb954ccdc79fc355444fc5acf (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
import MySQLdb
import re
def get_cursor():
host = 'localhost'
user = 'webqtl'
passwd = 'webqtl'
db = 'db_webqtl'
con = MySQLdb.Connect(db=db, host=host, user=user, passwd=passwd)
cursor = con.cursor()
return cursor
def clearspaces(s, default=None):
if s:
s = re.sub('\s+', ' ', s)
s = s.strip()
return s
else:
return default
|
