Mercurial > hg > ZDBInterface
comparison ZDBInterfaceFolder.py @ 14:9cea47dc6926
added _op_XXX=in operation
added version number
author | casties |
---|---|
date | Thu, 10 Nov 2011 19:59:59 +0100 |
parents | cf03ab908a2b |
children | 9fb0d4f24486 |
comparison
equal
deleted
inserted
replaced
13:cf03ab908a2b | 14:9cea47dc6926 |
---|---|
97 words = [] | 97 words = [] |
98 for word in val.split(" "): | 98 for word in val.split(" "): |
99 words.append(param + " ILIKE %s") | 99 words.append(param + " ILIKE %s") |
100 args.append("%" + word + "%") | 100 args.append("%" + word + "%") |
101 wheres.append("(" + " OR ".join(words) + ")") | 101 wheres.append("(" + " OR ".join(words) + ")") |
102 elif op == "in": | |
103 words = [] | |
104 for word in val.split(" "): | |
105 words.append("%s") | |
106 args.append(word) | |
107 wheres.append(param + " in (" + ", ".join(words) + ")") | |
102 else: | 108 else: |
103 logging.error("getSQLquery: unknown op=%s!"%op) | 109 logging.error("getSQLquery: unknown op=%s!"%op) |
104 | 110 |
105 return | 111 return |
106 | 112 |