Lines Matching refs:con
140 self.con = sqlite.connect(":memory:")
142 self.con.create_function("returntext", 0, func_returntext)
143 self.con.create_function("returntextwithnull", 0, func_returntextwithnull)
144 self.con.create_function("returnunicode", 0, func_returnunicode)
145 self.con.create_function("returnint", 0, func_returnint)
146 self.con.create_function("returnfloat", 0, func_returnfloat)
147 self.con.create_function("returnnull", 0, func_returnnull)
148 self.con.create_function("returnblob", 0, func_returnblob)
149 self.con.create_function("returnlonglong", 0, func_returnlonglong)
150 self.con.create_function("returnnan", 0, lambda: float("nan"))
151 self.con.create_function("returntoolargeint", 0, lambda: 1 << 65)
152 self.con.create_function("raiseexception", 0, func_raiseexception)
154 self.con.create_function("isblob", 1, lambda x: isinstance(x, bytes))
155 self.con.create_function("isnone", 1, lambda x: x is None)
156 self.con.create_function("spam", -1, lambda *x: len(x))
157 self.con.execute("create table test(t text)")
160 self.con.close()
164 self.con.create_function("bla", -100, lambda x: 2*x)
174 self.con.create_function("reftest", 0, f)
175 cur = self.con.cursor()
179 cur = self.con.cursor()
186 cur = self.con.cursor()
192 cur = self.con.cursor()
199 cur = self.con.cursor()
206 cur = self.con.cursor()
214 cur = self.con.cursor()
221 cur = self.con.cursor()
228 cur = self.con.cursor()
234 cur = self.con.cursor()
239 cur = self.con.cursor()
241 self.con.execute("select returntoolargeint()")
244 cur = self.con.cursor()
251 cur = self.con.cursor()
257 cur = self.con.execute("select isblob(x'')")
261 cur = self.con.execute("select isnone(?)", (float("nan"),))
267 self.assertRaisesRegex(OverflowError, err, self.con.execute,
272 self.con.execute, "select spam(?)",
277 self.con.execute, "select spam(?)",
284 self.con.create_function("test_params", 1, append_result)
302 cur = self.con.execute("select test_params(?)", (val,))
316 self.con.create_function("nondeterministic", 0, mock, deterministic=False)
318 self.con.execute("select nondeterministic() = nondeterministic()")
322 self.con.execute("create index t on test(t) where nondeterministic() is not null")
327 self.con.create_function("deterministic", 0, mock, deterministic=True)
329 self.con.execute("select deterministic() = deterministic()")
333 self.con.execute("create index t on test(t) where deterministic() is not null")
340 self.con.create_function("deterministic", 0, int, deterministic=True)
344 self.con.create_function("deterministic", 0, int, True)
365 self.con = sqlite.connect(":memory:")
366 cur = self.con.cursor()
379 self.con.create_aggregate("nostep", 1, AggrNoStep)
380 self.con.create_aggregate("nofinalize", 1, AggrNoFinalize)
381 self.con.create_aggregate("excInit", 1, AggrExceptionInInit)
382 self.con.create_aggregate("excStep", 1, AggrExceptionInStep)
383 self.con.create_aggregate("excFinalize", 1, AggrExceptionInFinalize)
384 self.con.create_aggregate("checkType", 2, AggrCheckType)
385 self.con.create_aggregate("checkTypes", -1, AggrCheckTypes)
386 self.con.create_aggregate("mysum", 1, AggrSum)
387 self.con.create_aggregate("aggtxt", 1, AggrText)
396 self.con.create_function("bla", -100, AggrSum)
399 cur = self.con.cursor()
405 cur = self.con.cursor()
412 cur = self.con.cursor()
419 cur = self.con.cursor()
426 cur = self.con.cursor()
433 cur = self.con.cursor()
439 cur = self.con.cursor()
445 cur = self.con.cursor()
451 cur = self.con.cursor()
457 cur = self.con.cursor()
463 cur = self.con.cursor()
469 cur = self.con.cursor()
477 cur = self.con.execute("select mysum(i) from (select 1 as i) where i == 0")
482 cur = self.con.cursor()
500 self.con = sqlite.connect(":memory:")
501 self.con.executescript("""
509 self.con.execute("select c2 from t2")
511 self.con.set_authorizer(self.authorizer_cb)
518 self.con.execute("select * from t2")
523 self.con.execute("select c2 from t1")