git://git.onelab.eu
/
plcapi.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
- no need to pass auth struct, Peer now signs calls automatically
[plcapi.git]
/
PLC
/
Filter.py
diff --git
a/PLC/Filter.py
b/PLC/Filter.py
index
a7c14ce
..
458e14c
100644
(file)
--- a/
PLC/Filter.py
+++ b/
PLC/Filter.py
@@
-1,3
+1,5
@@
+from types import StringTypes
+
from PLC.Faults import *
from PLC.Parameter import Parameter, Mixed, python_type
from PLC.Faults import *
from PLC.Parameter import Parameter, Mixed, python_type
@@
-53,6
+55,12
@@
class Filter(Parameter, dict):
assert join_with in ("AND", "OR")
for field, value in self.iteritems():
assert join_with in ("AND", "OR")
for field, value in self.iteritems():
+ # provide for negation with a field starting with ~
+ negation=False
+ if field[0] == '~':
+ negation = True
+ field = field[1:]
+
if field not in self.fields:
raise PLCInvalidArgument, "Invalid filter field '%s'" % field
if field not in self.fields:
raise PLCInvalidArgument, "Invalid filter field '%s'" % field
@@
-68,10
+76,18
@@
class Filter(Parameter, dict):
if value is None:
operator = "IS"
value = "NULL"
if value is None:
operator = "IS"
value = "NULL"
- else:
+ elif isinstance(value, StringTypes) and \
+ (value.find("*") > -1 or value.find("%") > -1):
+ operator = "LIKE"
+ value = str(api.db.quote(value.replace("*", "%")))
+ else:
operator = "="
value = str(api.db.quote(value))
operator = "="
value = str(api.db.quote(value))
- conditionals.append("%s %s %s" % (field, operator, value))
+ clause = "%s %s %s" % (field, operator, value)
+ if negation:
+ clause = " ( NOT %s ) "%clause
+
+ conditionals.append(clause)
return (" %s " % join_with).join(conditionals)
return (" %s " % join_with).join(conditionals)