From 4dd7cf29c42d177ea1ecff059af1837969903e2f Mon Sep 17 00:00:00 2001 From: Tony Mack Date: Fri, 9 Feb 2007 19:26:56 +0000 Subject: [PATCH] - changed how Slices formats 'expires' variable in the sql string. This seems to make psycopg happy and solves some database exceptions we were seeing when tyring to use wildcard searches in slice_filter. --- PLC/Slices.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/PLC/Slices.py b/PLC/Slices.py index a41e88d3..c8f6e812 100644 --- a/PLC/Slices.py +++ b/PLC/Slices.py @@ -137,10 +137,10 @@ class Slices(Table): if expires is not None: if expires >= 0: - sql += " AND expires > %(expires)d" + sql += " AND expires > %d" % expires else: expires = -expires - sql += " AND expires < %(expires)d" + sql += " AND expires < %d" % expires if slice_filter is not None: if isinstance(slice_filter, (list, tuple, set)): @@ -153,4 +153,4 @@ class Slices(Table): slice_filter = Filter(Slice.fields, slice_filter) sql += " AND (%s)" % slice_filter.sql(api, "AND") - self.selectall(sql, locals()) + self.selectall(sql) -- 2.47.0