changeset:   69124:ce37570768f5
user:        Antoine Pitrou <solipsis@pitrou.net>
date:        Mon Apr 04 01:50:50 2011 +0200
files:       Lib/sqlite3/test/hooks.py
description:
Fix TraceCallbackTests to not use bound parameters (followup to issue #11688)


diff -r 44fc5f94bc90 -r ce37570768f5 Lib/sqlite3/test/hooks.py
--- a/Lib/sqlite3/test/hooks.py	Mon Apr 04 01:22:06 2011 +0200
+++ b/Lib/sqlite3/test/hooks.py	Mon Apr 04 01:50:50 2011 +0200
@@ -213,7 +213,10 @@
             traced_statements.append(statement)
         con.set_trace_callback(trace)
         con.execute("create table foo(x)")
-        con.execute("insert into foo(x) values (?)", (unicode_value,))
+        # Can't execute bound parameters as their values don't appear
+        # in traced statements before SQLite 3.6.21
+        # (cf. http://www.sqlite.org/draft/releaselog/3_6_21.html)
+        con.execute('insert into foo(x) values ("%s")' % unicode_value)
         con.commit()
         self.assertTrue(any(unicode_value in stmt for stmt in traced_statements),
                         "Unicode data %s garbled in trace callback: %s"