Mercurial > hg > ZDBInterface
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 |