comparison DBInterface.py @ 11:22c16a632909

add single-quote to ignored characters in sqlName.
author casties
date Thu, 23 Jun 2011 11:16:19 +0200
parents 17b19345d011
children 5b99c04c567c
comparison
equal deleted inserted replaced
10:283c01ebe96e 11:22c16a632909
57 def sqlName(s, lc=True, more=''): 57 def sqlName(s, lc=True, more=''):
58 """returns restricted ASCII-only version of string""" 58 """returns restricted ASCII-only version of string"""
59 if s is None: 59 if s is None:
60 return "" 60 return ""
61 61
62 # remove '
63 s = s.replace("'","")
62 # all else -> "_" 64 # all else -> "_"
63 s = re.sub('[^A-Za-z0-9_'+more+']','_',s) 65 s = re.sub('[^A-Za-z0-9_'+more+']','_',s)
64 if lc: 66 if lc:
65 return s.lower() 67 return s.lower()
66 68