X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=PLC%2FLeases.py;h=9da3d3b0f173c9929a46c77245fd62da9079aa3c;hb=ae8b10f8363f7a1df02e77cbd820904c4ded10b8;hp=5e99129b454187c3e72c3e6f4aed46d363106793;hpb=4e770b3cf4e6b16150fd479ace9854eaee3399b6;p=plcapi.git diff --git a/PLC/Leases.py b/PLC/Leases.py index 5e99129..9da3d3b 100644 --- a/PLC/Leases.py +++ b/PLC/Leases.py @@ -50,18 +50,19 @@ class Lease(Row): # retrieve configured granularity granularity = self.api.config.PLC_RESERVATION_GRANULARITY # the trick for rounding up rather than down - if round_up: timestamp += (granularity-1) + if round_up: + timestamp += (granularity-1) # round down - timestamp = (timestamp/granularity) * granularity + timestamp = (timestamp // granularity) * granularity # return a SQL string return Timestamp.sql_validate_utc(timestamp) # round UP - def validate_t_from(self,timestamp): - return self.validate_time (timestamp, round_up=True) + def validate_t_from(self, timestamp): + return self.validate_time(timestamp, round_up=True) # round DOWN def validate_t_until (self, timestamp): - return self.validate_time (timestamp, round_up=False) + return self.validate_time(timestamp, round_up=False) class Leases(Table): """ @@ -74,16 +75,16 @@ class Leases(Table): # the view that we're selecting upon: start with view_leases view = "view_leases" - sql = "SELECT %s FROM %s WHERE true" % (", ".join(self.columns.keys()),view) + sql = "SELECT %s FROM %s WHERE true" % (", ".join(list(self.columns.keys())),view) if lease_filter is not None: - if isinstance(lease_filter, (list, tuple, set, int, long)): + if isinstance(lease_filter, (list, tuple, set, int)): lease_filter = Filter(Lease.fields, {'lease_id': lease_filter}) elif isinstance(lease_filter, dict): lease_filter = LeaseFilter(Lease.fields, lease_filter) else: - raise PLCInvalidArgument, "Wrong lease filter %r"%lease_filter + raise PLCInvalidArgument("Wrong lease filter %r"%lease_filter) sql += " AND (%s) %s" % lease_filter.sql(api) self.selectall(sql)