Lines Matching refs:cx
147 def sql(cx, sql, *args):
148 cu = cx.cursor()
280 def _run_test(self, cx):
281 cx.execute(self.CREATE)
282 cx.set_trace_callback(lambda stmt: self.traced.append(stmt))
283 with cx:
284 cx.execute(self.INSERT)
287 with memory_database() as cx:
288 self._run_test(cx)
292 with memory_database(isolation_level="") as cx:
293 self._run_test(cx)
297 with memory_database(isolation_level="DEFERRED") as cx:
298 self._run_test(cx)
302 with memory_database(isolation_level="IMMEDIATE") as cx:
303 self._run_test(cx)
308 with memory_database(isolation_level="EXCLUSIVE") as cx:
309 self._run_test(cx)
314 with memory_database(isolation_level=None) as cx:
315 self._run_test(cx)
323 self.cx = sqlite.connect(":memory:")
324 self.cx.execute("create table t(t)")
326 self.cx.set_trace_callback(lambda stmt: self.traced.append(stmt))
329 self.cx.close()
332 with self.cx:
333 self.cx.execute(self.QUERY)
337 self.cx.isolation_level = ""
338 with self.cx:
339 self.cx.execute(self.QUERY)
343 self.cx.isolation_level = "DEFERRED"
344 with self.cx:
345 self.cx.execute(self.QUERY)
349 self.cx.isolation_level = "IMMEDIATE"
350 with self.cx:
351 self.cx.execute(self.QUERY)
356 self.cx.isolation_level = "EXCLUSIVE"
357 with self.cx:
358 self.cx.execute(self.QUERY)
363 self.cx.isolation_level = None
364 with self.cx:
365 self.cx.execute(self.QUERY)