Lines Matching refs:con
32 self.con = sqlite.connect(":memory:")
35 self.con.close()
39 cur = self.con.cursor()
44 con = sqlite.connect(":memory:", detect_types=sqlite.PARSE_COLNAMES)
46 cur = self.con.cursor()
50 con.close()
56 con = sqlite.connect(":memory:", cached_statements=5)
57 cursors = [con.cursor() for x in range(5)]
65 con.rollback()
68 cur = self.con.cursor()
80 con = sqlite.connect(":memory:")
84 cur = con.cursor()
87 con.close()
90 con = sqlite.connect(":memory:")
91 con.execute("create table foo(x, unique(x) on conflict rollback)")
92 con.execute("insert into foo(x) values (1)")
94 con.execute("insert into foo(x) values (1)")
97 con.execute("insert into foo(x) values (2)")
99 con.commit()
108 self.con.execute("create table foo(bar)")
109 self.con.execute("drop table foo")
110 self.con.execute("create table foo(bar)")
117 self.con.execute("")
125 con = sqlite.connect(":memory:",detect_types=sqlite.PARSE_DECLTYPES)
126 con.execute("create table foo(bar timestamp)")
127 con.execute("insert into foo(bar) values (?)", (datetime.datetime.now(),))
128 con.execute(SELECT).close()
129 con.execute("drop table foo")
130 con.execute("create table foo(bar integer)")
131 con.execute("insert into foo(bar) values (5)")
132 con.execute(SELECT).close()
141 con = sqlite.connect(":memory:",detect_types=sqlite.PARSE_DECLTYPES)
142 con.execute("create table foo(bar X, baz integer)")
145 con.execute("insert into foo(bar, baz) values (?, ?)", parameters)
151 self.con.execute("select 'xxx' || ? || 'yyy' colname",
168 con.isolation_level = ""
170 con = sqlite.connect(":memory:")
171 con.isolation_level = None
174 con.isolation_level = level
175 con.isolation_level = level.lower()
176 con.isolation_level = level.capitalize()
177 con.isolation_level = CustomStr(level)
180 con.isolation_level = None
181 con.isolation_level = "DEFERRED"
189 con.isolation_level = value
190 self.assertEqual(con.isolation_level, "DEFERRED")
198 def __init__(self, con): argument
201 con = sqlite.connect(":memory:")
202 cur = Cursor(con)
214 self.con.execute("select ?", (MyStr("abc"),))
225 con = Connection(":memory:")
227 cur = con.cursor()
239 def __init__(self, con): argument
240 sqlite.Cursor.__init__(self, con)
242 con = Connection(":memory:")
243 cur = con.cursor()
247 con.rollback()
257 con = sqlite.connect(":memory:", isolation_level=None)
264 cur = self.con.cursor()
276 self.assertRaises(TypeError, self.con, 1)
281 self.assertRaises(sqlite.ProgrammingError, self.con.create_collation,
292 con = sqlite.connect(":memory:")
294 cur = con.cursor()
314 con = sqlite.connect(":memory:", detect_types=sqlite.PARSE_DECLTYPES)
315 cur = con.cursor()
340 con = sqlite.connect(":memory:")
341 self.assertRaises(ValueError, con, "\0select 1")
342 self.assertRaises(ValueError, con, "select 1\0")
343 cur = con.cursor()
353 con = sqlite.connect(":memory:")
354 con.executescript("""
362 self.assertEqual(con.isolation_level, "")
365 for i, row in enumerate(con.execute("select c from t")):
367 con.execute("insert into t2(c) values (?)", (i,))
368 con.commit()
385 con = sqlite.connect(":memory:")
386 cur = sqlite.Cursor(con)
388 cur.__init__(con)
396 del self.con.isolation_level
403 for method in [self.con.set_trace_callback,
404 functools.partial(self.con.set_progress_handler, n=1),
405 self.con.set_authorizer]:
409 self.con.execute("select 1") # trigger seg fault
413 cur = self.con.execute("select X''")