- alive=LeaseFilter.quote(alive)
- return LeaseFilter.sql_time_in_range(alive,'t_from','t_until')
- elif isinstance (alive,tuple):
- (f,u)=alive
- f=LeaseFilter.quote(f)
- u=LeaseFilter.quote(u)
- return LeaseFilter.sql_time_intersect (f,u,'t_from','t_until')
- else: raise PLCInvalidArgument ("LeaseFilter: alive field %r"%alive)
-
- def sql_clip (self, clip):
- if isinstance (clip,int) or isinstance (clip, StringTypes):
- start=LeaseFilter.quote(clip)
- return LeaseFilter.sql_timeslot_after('t_from','t_until',start)
- elif isinstance (clip,tuple):
- (f,u)=clip
- f=LeaseFilter.quote(f)
- u=LeaseFilter.quote(u)
- return LeaseFilter.sql_time_intersect(f,u,'t_from','t_until')
- else: raise PLCInvalidArgument ("LeaseFilter: clip field %r"%clip)
-
-
- ## supersede the generic Filter 'sql' method
- def sql(self, api, join_with = "AND"):
+ alive = LeaseFilter.quote(alive)
+ return LeaseFilter.sql_time_in_range(alive, 't_from', 't_until')
+ elif isinstance(alive, tuple):
+ (f, u) = alive
+ f = LeaseFilter.quote(f)
+ u = LeaseFilter.quote(u)
+ return LeaseFilter.sql_time_intersect(f, u, 't_from', 't_until')
+ else:
+ raise PLCInvalidArgument("LeaseFilter: alive field {}"
+ .format(alive))
+
+ def sql_clip(self, clip):
+ if isinstance(clip, int) or isinstance(clip, StringTypes):
+ start = LeaseFilter.quote(clip)
+ return LeaseFilter.sql_timeslot_after('t_from', 't_until', start)
+ elif isinstance(clip, tuple):
+ (f, u) = clip
+ f = LeaseFilter.quote(f)
+ u = LeaseFilter.quote(u)
+ return LeaseFilter.sql_time_intersect(f, u, 't_from', 't_until')
+ else:
+ raise PLCInvalidArgument("LeaseFilter: clip field {}"
+ .format(clip))
+
+ # supersede the generic Filter 'sql' method
+ def sql(self, api, join_with="AND"):