Lines Matching refs:con
36 self.con = sqlite.connect(":memory:")
39 self.con.close()
43 cur = self.con.cursor()
48 con = sqlite.connect(":memory:", detect_types=sqlite.PARSE_COLNAMES)
50 cur = self.con.cursor()
54 con.close()
60 con = sqlite.connect(":memory:", cached_statements=5)
61 cursors = [con.cursor() for x in range(5)]
69 con.rollback()
72 cur = self.con.cursor()
84 con = sqlite.connect(":memory:")
88 cur = con.cursor()
91 con.close()
94 con = sqlite.connect(":memory:")
95 con.execute("create table foo(x, unique(x) on conflict rollback)")
96 con.execute("insert into foo(x) values (1)")
98 con.execute("insert into foo(x) values (1)")
101 con.execute("insert into foo(x) values (2)")
103 con.commit()
112 self.con.execute("create table foo(bar)")
113 self.con.execute("drop table foo")
114 self.con.execute("create table foo(bar)")
121 self.con.execute("")
129 con = sqlite.connect(":memory:",detect_types=sqlite.PARSE_DECLTYPES)
130 cur = con.cursor()
146 con = sqlite.connect(":memory:",detect_types=sqlite.PARSE_DECLTYPES)
147 con.execute("create table foo(bar X, baz integer)")
150 con.execute("insert into foo(bar, baz) values (?, ?)", parameters)
156 self.con.execute("select 'xxx' || ? || 'yyy' colname",
173 con.isolation_level = ""
175 con = sqlite.connect(":memory:")
176 con.isolation_level = None
179 con.isolation_level = level
180 con.isolation_level = level.lower()
181 con.isolation_level = level.capitalize()
182 con.isolation_level = CustomStr(level)
185 con.isolation_level = None
186 con.isolation_level = "DEFERRED"
194 con.isolation_level = value
195 self.assertEqual(con.isolation_level, "DEFERRED")
203 def __init__(self, con):
206 con = sqlite.connect(":memory:")
207 cur = Cursor(con)
219 self.con.execute("select ?", (MyStr("abc"),))
230 con = Connection(":memory:")
232 cur = con.cursor()
240 con = sqlite.connect(":memory:", isolation_level=None)
247 cur = self.con.cursor()
259 self.assertRaises(TypeError, self.con, b"select 1")
264 self.assertRaises(UnicodeEncodeError, self.con.create_collation,
275 con = sqlite.connect(":memory:")
277 cur = con.cursor()
297 con = sqlite.connect(":memory:", detect_types=sqlite.PARSE_DECLTYPES)
298 cur = con.cursor()
323 cur = self.con.cursor()
328 self.con.execute, query)
334 con = sqlite.connect(":memory:")
335 self.assertRaises(UnicodeEncodeError, con, "select '\ud8ff'")
336 self.assertRaises(UnicodeEncodeError, con, "select '\udcff'")
337 cur = con.cursor()
360 con = sqlite.connect(":memory:")
361 con.executescript("""
369 self.assertEqual(con.isolation_level, "")
372 for i, row in enumerate(con.execute("select c from t")):
374 con.execute("insert into t2(c) values (?)", (i,))
375 con.commit()
392 con = sqlite.connect(":memory:")
393 cur = sqlite.Cursor(con)
395 cur.__init__(con)
403 del self.con.isolation_level
410 for method in [self.con.set_trace_callback,
411 functools.partial(self.con.set_progress_handler, n=1),
412 self.con.set_authorizer]:
416 self.con.execute("select 1") # trigger seg fault
420 cur = self.con.execute("select X''")
425 with memory_database() as con:
426 cur = con.cursor()
430 con.commit()
433 con.commit()
436 with memory_database() as con:
437 con.execute("create table t(t)")
438 con.executemany("insert into t values(?)",
440 con.commit()
441 cur = con.execute("select t from t")
443 con.execute("drop table t")
444 con.commit()
447 with memory_database() as con:
448 con.execute("create table t(t)")
449 con.executemany("insert into t values(?)",
451 con.commit()
453 con.execute("insert into t values(?)", (v,))
455 con.create_function("dup", 1, dup)
456 cur = con.execute("select dup(t) from t")
458 con.execute("drop table t")
459 con.commit()
462 with memory_database() as con:
464 with con:
465 con.execute("create table t(t)")
466 con.executemany("insert into t values(?)", values)
468 con.create_function("step", 1, lambda x: steps.append((x,)))
469 con.executescript("select step(t) from t")
480 with memory_database() as con:
481 cur = con.cursor(MyCursor)
490 self.con = sqlite.connect(":memory:",
492 self.cur = self.con.cursor()
499 self.con.close()
502 conv = lambda x: self.cur.__init__(self.con)