From 9c62cde38f7b99b004907ff3f249294fd20dcc4b Mon Sep 17 00:00:00 2001 From: Fabien Pinckaers Date: Sat, 18 Sep 2010 11:30:52 +0200 Subject: [IMP] improve debug for --log-level=debug_sql bzr revid: fp@tinyerp.com-20100918093052-nxapeqahzt4cpr2m --- bin/sql_db.py | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'bin/sql_db.py') diff --git a/bin/sql_db.py b/bin/sql_db.py index 193a709dd8d..6c2c17beeb3 100644 --- a/bin/sql_db.py +++ b/bin/sql_db.py @@ -113,8 +113,6 @@ class Cursor(object): self.__logger.warn(query) self.__logger.warn("SQL queries cannot contain %d or %f anymore. " "Use only %s") - if params: - query = query.replace('%d', '%s').replace('%f', '%s') if self.sql_log: now = mdt.now() @@ -167,6 +165,7 @@ class Cursor(object): sqllogitems = sqllogs[type].items() sqllogitems.sort(key=lambda k: k[1][1]) self.__logger.log(logging.DEBUG_SQL, "SQL LOG %s:", type) + sqllogitems.sort(lambda x,y: cmp(x[1][0], y[1][0])) for r in sqllogitems: delay = timedelta(microseconds=r[1][1]) self.__logger.log(logging.DEBUG_SQL, "table: %s: %s/%s", -- cgit v1.2.3