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