Lines Matching refs:sqlite
25 import sqlite3 as sqlite
44 cx = sqlite.connect(":memory:", *args, **kwargs)
50 def cx_limit(cx, category=sqlite.SQLITE_LIMIT_SQL_LENGTH, limit=128):
60 self.assertEqual(sqlite.apilevel, "2.0",
61 "apilevel is %s, should be 2.0" % sqlite.apilevel)
64 self.assertIn(sqlite.threadsafety, {0, 1, 3},
66 sqlite.threadsafety)
69 self.assertEqual(sqlite.paramstyle, "qmark",
71 sqlite.paramstyle)
74 self.assertTrue(issubclass(sqlite.Warning, Exception),
78 self.assertTrue(issubclass(sqlite.Error, Exception),
82 self.assertTrue(issubclass(sqlite.InterfaceError, sqlite.Error),
86 self.assertTrue(issubclass(sqlite.DatabaseError, sqlite.Error),
90 self.assertTrue(issubclass(sqlite.DataError, sqlite.DatabaseError),
94 self.assertTrue(issubclass(sqlite.OperationalError, sqlite.DatabaseError),
98 self.assertTrue(issubclass(sqlite.IntegrityError, sqlite.DatabaseError),
102 self.assertTrue(issubclass(sqlite.InternalError, sqlite.DatabaseError),
106 self.assertTrue(issubclass(sqlite.ProgrammingError, sqlite.DatabaseError),
110 self.assertTrue(issubclass(sqlite.NotSupportedError,
111 sqlite.DatabaseError),
192 if sqlite.sqlite_version_info >= (3, 7, 17):
194 if sqlite.sqlite_version_info >= (3, 8, 3):
196 if sqlite.sqlite_version_info >= (3, 8, 7):
234 if sqlite.sqlite_version_info >= (3, 7, 16):
247 if sqlite.sqlite_version_info >= (3, 7, 17):
253 if sqlite.sqlite_version_info >= (3, 8, 0):
259 if sqlite.sqlite_version_info >= (3, 8, 1):
261 if sqlite.sqlite_version_info >= (3, 8, 2):
263 if sqlite.sqlite_version_info >= (3, 8, 3):
265 if sqlite.sqlite_version_info >= (3, 8, 7):
267 if sqlite.sqlite_version_info >= (3, 9, 0):
269 if sqlite.sqlite_version_info >= (3, 10, 0):
271 if sqlite.sqlite_version_info >= (3, 14, 1):
273 if sqlite.sqlite_version_info >= (3, 21, 0):
279 if sqlite.sqlite_version_info >= (3, 22, 0):
286 if sqlite.sqlite_version_info >= (3, 24, 0):
288 if sqlite.sqlite_version_info >= (3, 25, 0):
290 if sqlite.sqlite_version_info >= (3, 31, 0):
296 if sqlite.sqlite_version_info >= (3, 32, 0):
302 if sqlite.sqlite_version_info >= (3, 34, 0):
306 self.assertTrue(hasattr(sqlite, const))
311 err_code = sqlite.SQLITE_CANTOPEN_ISDIR
313 err_code = sqlite.SQLITE_CANTOPEN
316 with self.assertRaisesRegex(sqlite.Error, err_msg) as cm:
317 sqlite.connect(db)
322 @unittest.skipIf(sqlite.sqlite_version_info <= (3, 7, 16),
329 with self.assertRaisesRegex(sqlite.IntegrityError, errmsg) as cm:
333 sqlite.SQLITE_CONSTRAINT_CHECK)
342 sqlite.enable_shared_cache(enable)
346 cx = sqlite.connect(":memory:")
348 check_disallow_instantiation(self, sqlite.Blob)
351 self.assertFalse(sqlite.complete_statement("select t"))
352 self.assertTrue(sqlite.complete_statement("create table t(t);"))
358 self.cx = sqlite.connect(":memory:")
391 with self.assertRaises(sqlite.OperationalError):
392 sqlite.connect(YOU_CANNOT_OPEN_THIS)
402 self.assertRaises(sqlite.ProgrammingError, res.fetchall)
403 self.assertRaises(sqlite.ProgrammingError, cu.execute, sql)
404 self.assertRaises(sqlite.ProgrammingError, cu.executemany, sql, [])
405 self.assertRaises(sqlite.ProgrammingError, cu.executescript, sql)
406 self.assertRaises(sqlite.ProgrammingError, self.cx.execute, sql)
407 self.assertRaises(sqlite.ProgrammingError,
409 self.assertRaises(sqlite.ProgrammingError, self.cx.executescript, sql)
410 self.assertRaises(sqlite.ProgrammingError,
412 self.assertRaises(sqlite.ProgrammingError, self.cx.cursor)
413 with self.assertRaises(sqlite.ProgrammingError):
419 self.assertEqual(self.cx.Warning, sqlite.Warning)
420 self.assertEqual(self.cx.Error, sqlite.Error)
421 self.assertEqual(self.cx.InterfaceError, sqlite.InterfaceError)
422 self.assertEqual(self.cx.DatabaseError, sqlite.DatabaseError)
423 self.assertEqual(self.cx.DataError, sqlite.DataError)
424 self.assertEqual(self.cx.OperationalError, sqlite.OperationalError)
425 self.assertEqual(self.cx.IntegrityError, sqlite.IntegrityError)
426 self.assertEqual(self.cx.InternalError, sqlite.InternalError)
427 self.assertEqual(self.cx.ProgrammingError, sqlite.ProgrammingError)
428 self.assertEqual(self.cx.NotSupportedError, sqlite.NotSupportedError)
432 cx = sqlite.connect(":memory:")
467 self.assertIs(getattr(sqlite, exc), getattr(self.cx, exc))
470 cx = sqlite.connect(":memory:")
472 with self.assertRaises(sqlite.ProgrammingError):
484 category = sqlite.SQLITE_LIMIT_SQL_LENGTH
492 self.assertRaisesRegex(sqlite.DataError, msg,
500 self.assertRaisesRegex(sqlite.ProgrammingError, msg,
502 self.assertRaisesRegex(sqlite.ProgrammingError, msg,
542 cx = sqlite.connect(db)
544 cx.row_factory = sqlite.Row
552 self.assertTrue(all(isinstance(r, sqlite.Row) for r in rows))
562 self.assertTrue(all(isinstance(r, sqlite.Row) for r in rows))
566 cx = sqlite.connect(":memory:")
570 self.assertRaisesRegex(sqlite.OperationalError,
573 self.assertRaisesRegex(sqlite.ProgrammingError,
581 self.cx = sqlite.Connection.__new__(sqlite.Connection)
594 self.assertRaisesRegex(sqlite.ProgrammingError,
599 @unittest.skipUnless(hasattr(sqlite.Connection, "serialize"),
612 with self.assertRaisesRegex(sqlite.OperationalError, regex):
634 with self.assertRaisesRegex(sqlite.DatabaseError, regex):
657 with contextlib.closing(sqlite.connect(path)) as cx:
669 with contextlib.closing(sqlite.connect(path)) as cx:
678 with contextlib.closing(sqlite.connect(uri, uri=True)) as cx:
687 with contextlib.closing(sqlite.connect(uri, uri=True)) as cx:
697 with self.assertRaises(sqlite.OperationalError):
698 sqlite.connect(uri, uri=True)
700 sqlite.connect(path).close()
703 with contextlib.closing(sqlite.connect(uri, uri=True)) as cx:
704 with self.assertRaises(sqlite.OperationalError):
716 with contextlib.closing(sqlite.connect(uri, uri=True)) as cx:
724 return sqlite.Connection(":memory:", *args, **kwargs)
729 sqlite.connect(database, factory=factory).close()
733 with contextlib.closing(sqlite.connect(database=":memory:")) as cx:
734 self.assertEqual(type(cx), sqlite.Connection)
739 self.cx = sqlite.connect(":memory:")
755 with self.assertRaises(sqlite.OperationalError):
777 with self.assertRaisesRegex(sqlite.ProgrammingError, msg):
818 with self.assertRaises(sqlite.ProgrammingError) as cm:
824 with self.assertRaises(sqlite.ProgrammingError):
829 with self.assertRaises(sqlite.ProgrammingError):
834 with self.assertRaises(sqlite.ProgrammingError):
869 category = sqlite.SQLITE_LIMIT_VARIABLE_NUMBER
873 with self.assertRaisesRegex(sqlite.OperationalError, msg):
895 with self.assertRaises(sqlite.ProgrammingError):
900 with self.assertRaises(sqlite.ProgrammingError):
905 with self.assertRaises(sqlite.ProgrammingError):
932 @unittest.skipIf(sqlite.sqlite_version_info < (3, 35, 0),
1005 with self.assertRaises(sqlite.ProgrammingError):
1095 cur = sqlite.Cursor(foo)
1124 with self.assertRaises(sqlite.IntegrityError):
1153 self.cx = sqlite.connect(":memory:")
1164 self.assertIsInstance(self.blob, sqlite.Blob)
1221 with self.assertRaises(sqlite.OperationalError):
1254 with self.assertRaises(sqlite.OperationalError):
1259 with self.assertRaisesRegex(sqlite.OperationalError, "readonly"):
1273 with self.assertRaisesRegex(sqlite.OperationalError, regex):
1364 with self.assertRaises(sqlite.OperationalError):
1414 with self.assertRaisesRegex(sqlite.ProgrammingError, "closed blob"):
1433 with self.assertRaisesRegex(sqlite.ProgrammingError, msg):
1435 with self.assertRaisesRegex(sqlite.ProgrammingError, msg):
1437 with self.assertRaisesRegex(sqlite.ProgrammingError, msg):
1439 with self.assertRaisesRegex(sqlite.ProgrammingError, msg):
1441 with self.assertRaisesRegex(sqlite.ProgrammingError, msg):
1443 with self.assertRaisesRegex(sqlite.ProgrammingError, msg):
1445 with self.assertRaisesRegex(sqlite.ProgrammingError, msg):
1447 with self.assertRaisesRegex(sqlite.ProgrammingError, msg):
1449 with self.assertRaisesRegex(sqlite.ProgrammingError, msg):
1451 with self.assertRaisesRegex(sqlite.ProgrammingError, msg):
1460 self.assertRaisesRegex(sqlite.ProgrammingError,
1476 self.con = sqlite.connect(":memory:")
1491 except sqlite.ProgrammingError:
1512 lambda: self.con.setlimit(sqlite.SQLITE_LIMIT_LENGTH, -1),
1513 lambda: self.con.getlimit(sqlite.SQLITE_LIMIT_LENGTH),
1516 if hasattr(sqlite.Connection, "serialize"):
1519 if sqlite.sqlite_version_info >= (3, 25, 0):
1543 except sqlite.Error:
1546 con = sqlite.connect(":memory:", check_same_thread=False)
1556 d = sqlite.Date(2004, 10, 28)
1559 t = sqlite.Time(12, 39, 35)
1562 ts = sqlite.Timestamp(2004, 10, 28, 12, 39, 35)
1565 d = sqlite.DateFromTicks(42)
1568 t = sqlite.TimeFromTicks(42)
1571 ts = sqlite.TimestampFromTicks(42)
1574 b = sqlite.Binary(b"\0'")
1578 con = sqlite.connect(":memory:")
1591 con = sqlite.connect(":memory:")
1593 with self.assertRaises(sqlite.OperationalError):
1597 con = sqlite.connect(":memory:")
1599 with self.assertRaises(sqlite.OperationalError):
1603 con = sqlite.connect(":memory:")
1609 con = sqlite.connect(":memory:")
1618 con = sqlite.connect(":memory:")
1630 with self.assertRaisesRegex(sqlite.DataError, msg):
1634 con = sqlite.connect(":memory:")
1641 con = sqlite.connect(":memory:")
1646 con = sqlite.connect(":memory:")
1654 con = sqlite.connect(":memory:")
1661 con = sqlite.connect(":memory:")
1663 with self.assertRaises(sqlite.ProgrammingError):
1667 con = sqlite.connect(":memory:")
1669 with self.assertRaises(sqlite.ProgrammingError):
1673 con = sqlite.connect(":memory:")
1675 with self.assertRaises(sqlite.ProgrammingError):
1679 con = sqlite.connect(":memory:")
1682 with self.assertRaises(sqlite.ProgrammingError):
1686 con = sqlite.connect(":memory:")
1689 with self.assertRaises(sqlite.ProgrammingError):
1693 con = sqlite.connect(":memory:")
1702 with self.assertRaises(sqlite.ProgrammingError):
1706 con = sqlite.connect(":memory:")
1709 return sqlite.DENY
1710 with self.assertRaises(sqlite.ProgrammingError):
1714 con = sqlite.connect(":memory:")
1717 with self.assertRaises(sqlite.ProgrammingError):
1721 con = sqlite.connect(":memory:")
1723 with self.assertRaises(sqlite.ProgrammingError):
1728 con = sqlite.connect(":memory:")
1740 with self.assertRaises(sqlite.ProgrammingError):
1749 See https://www.sqlite.org/lang_conflict.html for details.
1753 self.cx = sqlite.connect(":memory:")
1772 with self.assertRaises(sqlite.IntegrityError):
1789 with self.assertRaises(sqlite.IntegrityError):
1800 with self.assertRaises(sqlite.IntegrityError):
1811 with self.assertRaises(sqlite.IntegrityError):
1819 with self.assertRaises(sqlite.IntegrityError):
1888 cx = sqlite.connect(TESTFN, timeout=self.CONNECTION_TIMEOUT)
1892 except sqlite.OperationalError as exc: