Lines Matching refs:con
325 with memory_database() as con:
326 with con:
327 con.execute("create table t(t integer check(t > 0))")
330 con.execute("insert into t values(-1)")
1476 self.con = sqlite.connect(":memory:")
1477 self.cur = self.con.cursor()
1483 self.con.close()
1505 lambda: self.con.cursor(),
1506 lambda: self.con.commit(),
1507 lambda: self.con.rollback(),
1508 lambda: self.con.close(),
1509 lambda: self.con.set_trace_callback(None),
1510 lambda: self.con.set_authorizer(None),
1511 lambda: self.con.create_collation("foo", None),
1512 lambda: self.con.setlimit(sqlite.SQLITE_LIMIT_LENGTH, -1),
1513 lambda: self.con.getlimit(sqlite.SQLITE_LIMIT_LENGTH),
1514 lambda: self.con.blobopen("test", "b", 1),
1517 fns.append(lambda: self.con.serialize())
1518 fns.append(lambda: self.con.deserialize(b""))
1520 fns.append(lambda: self.con.create_window_function("foo", 0, None))
1540 def run(con, err):
1542 con.execute("select 1")
1546 con = sqlite.connect(":memory:", check_same_thread=False)
1548 t = threading.Thread(target=run, kwargs={"con": con, "err": err})
1578 con = sqlite.connect(":memory:")
1579 cur = con.cursor()
1591 con = sqlite.connect(":memory:")
1592 cur = con.cursor()
1597 con = sqlite.connect(":memory:")
1598 cur = con.cursor()
1603 con = sqlite.connect(":memory:")
1604 cur = con.cursor()
1609 con = sqlite.connect(":memory:")
1610 cur = con.cursor()
1618 con = sqlite.connect(":memory:")
1619 cur = con.cursor()
1634 con = sqlite.connect(":memory:")
1635 con.execute("begin")
1636 self.assertTrue(con.in_transaction)
1637 con.executescript("select 1")
1638 self.assertFalse(con.in_transaction)
1641 con = sqlite.connect(":memory:")
1642 result = con.execute("select 5").fetchone()[0]
1646 con = sqlite.connect(":memory:")
1647 con.execute("create table test(foo)")
1648 con.executemany("insert into test(foo) values (?)", [(3,), (4,)])
1649 result = con.execute("select foo from test order by foo").fetchall()
1654 con = sqlite.connect(":memory:")
1655 con.executescript("create table test(foo); insert into test(foo) values (5);")
1656 result = con.execute("select foo from test").fetchone()[0]
1661 con = sqlite.connect(":memory:")
1662 con.close()
1664 cur = con.cursor()
1667 con = sqlite.connect(":memory:")
1668 con.close()
1670 con.commit()
1673 con = sqlite.connect(":memory:")
1674 con.close()
1676 con.rollback()
1679 con = sqlite.connect(":memory:")
1680 cur = con.cursor()
1681 con.close()
1686 con = sqlite.connect(":memory:")
1687 con.close()
1690 con.create_function("foo", 1, f)
1693 con = sqlite.connect(":memory:")
1694 con.close()
1703 con.create_aggregate("foo", 1, Agg)
1706 con = sqlite.connect(":memory:")
1707 con.close()
1711 con.set_authorizer(authorizer)
1714 con = sqlite.connect(":memory:")
1715 con.close()
1718 con.set_progress_handler(progress, 100)
1721 con = sqlite.connect(":memory:")
1722 con.close()
1724 con()
1728 con = sqlite.connect(":memory:")
1729 cur = con.cursor()