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 |
