{
    "mode": "pydoc",
    "parameter": "sqlite3",
    "section": "",
    "url": "https://www.chedong.com/phpMan.php/pydoc/sqlite3/json",
    "generated": "2026-06-02T13:18:25Z",
    "sections": {
        "NAME": {
            "content": "sqlite3\n",
            "subsections": []
        },
        "MODULE REFERENCE": {
            "content": "https://docs.python.org/3.10/library/sqlite3.html\n\nThe following documentation is automatically generated from the Python\nsource files.  It may be incomplete, incorrect or include features that\nare considered implementation detail and may vary between Python\nimplementations.  When in doubt, consult the module reference at the\nlocation listed above.\n",
            "subsections": []
        },
        "DESCRIPTION": {
            "content": "The sqlite3 extension module provides a DB-API 2.0 (PEP 249) compliant\ninterface to the SQLite library, and requires SQLite 3.7.15 or newer.\n\nTo use the module, start by creating a database Connection object:\n\nimport sqlite3\ncx = sqlite3.connect(\"test.db\")  # test.db will be created or opened\n\nThe special path name \":memory:\" can be provided to connect to a transient\nin-memory database:\n\ncx = sqlite3.connect(\":memory:\")  # connect to a database in RAM\n\nOnce a connection has been established, create a Cursor object and call\nits execute() method to perform SQL queries:\n\ncu = cx.cursor()\n\n# create a table\ncu.execute(\"create table lang(name, firstappeared)\")\n\n# insert values into a table\ncu.execute(\"insert into lang values (?, ?)\", (\"C\", 1972))\n\n# execute a query and iterate over the result\nfor row in cu.execute(\"select * from lang\"):\nprint(row)\n\ncx.close()\n\nThe sqlite3 module is written by Gerhard Häring <gh@ghaering.de>.\n",
            "subsections": []
        },
        "PACKAGE CONTENTS": {
            "content": "dbapi2\ndump\n",
            "subsections": []
        },
        "CLASSES": {
            "content": "builtins.Exception(builtins.BaseException)\nError\nDatabaseError\nDataError\nIntegrityError\nInternalError\nNotSupportedError\nOperationalError\nProgrammingError\nInterfaceError\nWarning\nbuiltins.object\nConnection\nCursor\nPrepareProtocol\nRow\n",
            "subsections": [
                {
                    "name": "class Connection",
                    "content": "|  SQLite database connection object.\n|\n|  Methods defined here:\n|\n|  call(self, /, *args, kwargs)\n|      Call self as a function.\n|\n|  enter(self, /)\n|      Called when the connection is used as a context manager.\n|\n|      Returns itself as a convenience to the caller.\n|\n|  exit(self, type, value, traceback, /)\n|      Called when the connection is used as a context manager.\n|\n|      If there was any exception, a rollback takes place; otherwise we commit.\n|\n|  init(self, /, *args, kwargs)\n|      Initialize self.  See help(type(self)) for accurate signature.\n|\n|  backup(self, /, target, *, pages=-1, progress=None, name='main', sleep=0.25)\n|      Makes a backup of the database.\n|\n|  close(self, /)\n|      Close the database connection.\n|\n|      Any pending transaction is not committed implicitly.\n|\n|  commit(self, /)\n|      Commit any pending transaction to the database.\n|\n|      If there is no open transaction, this method is a no-op.\n|\n|  createaggregate(self, /, name, narg, aggregateclass)\n|      Creates a new aggregate.\n|\n|  createcollation(self, name, callback, /)\n|      Creates a collation function.\n|\n|  createfunction(self, /, name, narg, func, *, deterministic=False)\n|      Creates a new function.\n|\n|  cursor(...)\n|      Return a cursor for the connection.\n|\n|  enableloadextension(self, enable, /)\n|      Enable dynamic loading of SQLite extension modules.\n|\n|  execute(...)\n|      Executes an SQL statement.\n|\n|  executemany(self, sql, parameters, /)\n|      Repeatedly executes an SQL statement.\n|\n|  executescript(self, sqlscript, /)\n|      Executes multiple SQL statements at once.\n|\n|  interrupt(self, /)\n|      Abort any pending database operation.\n|\n|  iterdump(self, /)\n|      Returns iterator to the dump of the database in an SQL text format.\n|\n|  loadextension(self, name, /)\n|      Load SQLite extension module.\n|\n|  rollback(self, /)\n|      Roll back to the start of any pending transaction.\n|\n|      If there is no open transaction, this method is a no-op.\n|\n|  setauthorizer(self, /, authorizercallback)\n|      Sets authorizer callback.\n|\n|  setprogresshandler(self, /, progresshandler, n)\n|      Sets progress handler callback.\n|\n|  settracecallback(self, /, tracecallback)\n|      Sets a trace callback called for each SQL statement (passed as unicode).\n|\n|  ----------------------------------------------------------------------\n|  Data descriptors defined here:\n|\n|  DataError\n|\n|  DatabaseError\n|\n|  Error\n|\n|  IntegrityError\n|\n|  InterfaceError\n|\n|  InternalError\n|\n|  NotSupportedError\n|\n|  OperationalError\n|\n|  ProgrammingError\n|\n|  Warning\n|\n|  intransaction\n|\n|  isolationlevel\n|\n|  rowfactory\n|\n|  textfactory\n|\n|  totalchanges\n"
                },
                {
                    "name": "class Cursor",
                    "content": "|  SQLite database cursor class.\n|\n|  Methods defined here:\n|\n|  init(self, /, *args, kwargs)\n|      Initialize self.  See help(type(self)) for accurate signature.\n|\n|  iter(self, /)\n|      Implement iter(self).\n|\n|  next(self, /)\n|      Implement next(self).\n|\n|  close(self, /)\n|      Closes the cursor.\n|\n|  execute(self, sql, parameters=(), /)\n|      Executes an SQL statement.\n|\n|  executemany(self, sql, seqofparameters, /)\n|      Repeatedly executes an SQL statement.\n|\n|  executescript(self, sqlscript, /)\n|      Executes multiple SQL statements at once.\n|\n|  fetchall(self, /)\n|      Fetches all rows from the resultset.\n|\n|  fetchmany(self, /, size=1)\n|      Fetches several rows from the resultset.\n|\n|      size\n|        The default value is set by the Cursor.arraysize attribute.\n|\n|  fetchone(self, /)\n|      Fetches one row from the resultset.\n|\n|  setinputsizes(self, sizes, /)\n|      Required by DB-API. Does nothing in sqlite3.\n|\n|  setoutputsize(self, size, column=None, /)\n|      Required by DB-API. Does nothing in sqlite3.\n|\n|  ----------------------------------------------------------------------\n|  Data descriptors defined here:\n|\n|  arraysize\n|\n|  connection\n|\n|  description\n|\n|  lastrowid\n|\n|  rowfactory\n|\n|  rowcount\n"
                },
                {
                    "name": "class DataError",
                    "content": "|  Method resolution order:\n|      DataError\n|      DatabaseError\n|      Error\n|      builtins.Exception\n|      builtins.BaseException\n|      builtins.object\n|\n|  Data descriptors inherited from Error:\n|\n|  weakref\n|      list of weak references to the object (if defined)\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.Exception:\n|\n|  init(self, /, *args, kwargs)\n|      Initialize self.  See help(type(self)) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Static methods inherited from builtins.Exception:\n|\n|  new(*args, kwargs) from builtins.type\n|      Create and return a new object.  See help(type) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.BaseException:\n|\n|  delattr(self, name, /)\n|      Implement delattr(self, name).\n|\n|  getattribute(self, name, /)\n|      Return getattr(self, name).\n|\n|  reduce(...)\n|      Helper for pickle.\n|\n|  repr(self, /)\n|      Return repr(self).\n|\n|  setattr(self, name, value, /)\n|      Implement setattr(self, name, value).\n|\n|  setstate(...)\n|\n|  str(self, /)\n|      Return str(self).\n|\n|  withtraceback(...)\n|      Exception.withtraceback(tb) --\n|      set self.traceback to tb and return self.\n|\n|  ----------------------------------------------------------------------\n|  Data descriptors inherited from builtins.BaseException:\n|\n|  cause\n|      exception cause\n|\n|  context\n|      exception context\n|\n|  dict\n|\n|  suppresscontext\n|\n|  traceback\n|\n|  args\n"
                },
                {
                    "name": "class DatabaseError",
                    "content": "|  Method resolution order:\n|      DatabaseError\n|      Error\n|      builtins.Exception\n|      builtins.BaseException\n|      builtins.object\n|\n|  Data descriptors inherited from Error:\n|\n|  weakref\n|      list of weak references to the object (if defined)\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.Exception:\n|\n|  init(self, /, *args, kwargs)\n|      Initialize self.  See help(type(self)) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Static methods inherited from builtins.Exception:\n|\n|  new(*args, kwargs) from builtins.type\n|      Create and return a new object.  See help(type) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.BaseException:\n|\n|  delattr(self, name, /)\n|      Implement delattr(self, name).\n|\n|  getattribute(self, name, /)\n|      Return getattr(self, name).\n|\n|  reduce(...)\n|      Helper for pickle.\n|\n|  repr(self, /)\n|      Return repr(self).\n|\n|  setattr(self, name, value, /)\n|      Implement setattr(self, name, value).\n|\n|  setstate(...)\n|\n|  str(self, /)\n|      Return str(self).\n|\n|  withtraceback(...)\n|      Exception.withtraceback(tb) --\n|      set self.traceback to tb and return self.\n|\n|  ----------------------------------------------------------------------\n|  Data descriptors inherited from builtins.BaseException:\n|\n|  cause\n|      exception cause\n|\n|  context\n|      exception context\n|\n|  dict\n|\n|  suppresscontext\n|\n|  traceback\n|\n|  args\n"
                },
                {
                    "name": "class Error",
                    "content": "|  Method resolution order:\n|      Error\n|      builtins.Exception\n|      builtins.BaseException\n|      builtins.object\n|\n|  Data descriptors defined here:\n|\n|  weakref\n|      list of weak references to the object (if defined)\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.Exception:\n|\n|  init(self, /, *args, kwargs)\n|      Initialize self.  See help(type(self)) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Static methods inherited from builtins.Exception:\n|\n|  new(*args, kwargs) from builtins.type\n|      Create and return a new object.  See help(type) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.BaseException:\n|\n|  delattr(self, name, /)\n|      Implement delattr(self, name).\n|\n|  getattribute(self, name, /)\n|      Return getattr(self, name).\n|\n|  reduce(...)\n|      Helper for pickle.\n|\n|  repr(self, /)\n|      Return repr(self).\n|\n|  setattr(self, name, value, /)\n|      Implement setattr(self, name, value).\n|\n|  setstate(...)\n|\n|  str(self, /)\n|      Return str(self).\n|\n|  withtraceback(...)\n|      Exception.withtraceback(tb) --\n|      set self.traceback to tb and return self.\n|\n|  ----------------------------------------------------------------------\n|  Data descriptors inherited from builtins.BaseException:\n|\n|  cause\n|      exception cause\n|\n|  context\n|      exception context\n|\n|  dict\n|\n|  suppresscontext\n|\n|  traceback\n|\n|  args\n"
                },
                {
                    "name": "class IntegrityError",
                    "content": "|  Method resolution order:\n|      IntegrityError\n|      DatabaseError\n|      Error\n|      builtins.Exception\n|      builtins.BaseException\n|      builtins.object\n|\n|  Data descriptors inherited from Error:\n|\n|  weakref\n|      list of weak references to the object (if defined)\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.Exception:\n|\n|  init(self, /, *args, kwargs)\n|      Initialize self.  See help(type(self)) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Static methods inherited from builtins.Exception:\n|\n|  new(*args, kwargs) from builtins.type\n|      Create and return a new object.  See help(type) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.BaseException:\n|\n|  delattr(self, name, /)\n|      Implement delattr(self, name).\n|\n|  getattribute(self, name, /)\n|      Return getattr(self, name).\n|\n|  reduce(...)\n|      Helper for pickle.\n|\n|  repr(self, /)\n|      Return repr(self).\n|\n|  setattr(self, name, value, /)\n|      Implement setattr(self, name, value).\n|\n|  setstate(...)\n|\n|  str(self, /)\n|      Return str(self).\n|\n|  withtraceback(...)\n|      Exception.withtraceback(tb) --\n|      set self.traceback to tb and return self.\n|\n|  ----------------------------------------------------------------------\n|  Data descriptors inherited from builtins.BaseException:\n|\n|  cause\n|      exception cause\n|\n|  context\n|      exception context\n|\n|  dict\n|\n|  suppresscontext\n|\n|  traceback\n|\n|  args\n"
                },
                {
                    "name": "class InterfaceError",
                    "content": "|  Method resolution order:\n|      InterfaceError\n|      Error\n|      builtins.Exception\n|      builtins.BaseException\n|      builtins.object\n|\n|  Data descriptors inherited from Error:\n|\n|  weakref\n|      list of weak references to the object (if defined)\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.Exception:\n|\n|  init(self, /, *args, kwargs)\n|      Initialize self.  See help(type(self)) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Static methods inherited from builtins.Exception:\n|\n|  new(*args, kwargs) from builtins.type\n|      Create and return a new object.  See help(type) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.BaseException:\n|\n|  delattr(self, name, /)\n|      Implement delattr(self, name).\n|\n|  getattribute(self, name, /)\n|      Return getattr(self, name).\n|\n|  reduce(...)\n|      Helper for pickle.\n|\n|  repr(self, /)\n|      Return repr(self).\n|\n|  setattr(self, name, value, /)\n|      Implement setattr(self, name, value).\n|\n|  setstate(...)\n|\n|  str(self, /)\n|      Return str(self).\n|\n|  withtraceback(...)\n|      Exception.withtraceback(tb) --\n|      set self.traceback to tb and return self.\n|\n|  ----------------------------------------------------------------------\n|  Data descriptors inherited from builtins.BaseException:\n|\n|  cause\n|      exception cause\n|\n|  context\n|      exception context\n|\n|  dict\n|\n|  suppresscontext\n|\n|  traceback\n|\n|  args\n"
                },
                {
                    "name": "class InternalError",
                    "content": "|  Method resolution order:\n|      InternalError\n|      DatabaseError\n|      Error\n|      builtins.Exception\n|      builtins.BaseException\n|      builtins.object\n|\n|  Data descriptors inherited from Error:\n|\n|  weakref\n|      list of weak references to the object (if defined)\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.Exception:\n|\n|  init(self, /, *args, kwargs)\n|      Initialize self.  See help(type(self)) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Static methods inherited from builtins.Exception:\n|\n|  new(*args, kwargs) from builtins.type\n|      Create and return a new object.  See help(type) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.BaseException:\n|\n|  delattr(self, name, /)\n|      Implement delattr(self, name).\n|\n|  getattribute(self, name, /)\n|      Return getattr(self, name).\n|\n|  reduce(...)\n|      Helper for pickle.\n|\n|  repr(self, /)\n|      Return repr(self).\n|\n|  setattr(self, name, value, /)\n|      Implement setattr(self, name, value).\n|\n|  setstate(...)\n|\n|  str(self, /)\n|      Return str(self).\n|\n|  withtraceback(...)\n|      Exception.withtraceback(tb) --\n|      set self.traceback to tb and return self.\n|\n|  ----------------------------------------------------------------------\n|  Data descriptors inherited from builtins.BaseException:\n|\n|  cause\n|      exception cause\n|\n|  context\n|      exception context\n|\n|  dict\n|\n|  suppresscontext\n|\n|  traceback\n|\n|  args\n"
                },
                {
                    "name": "class NotSupportedError",
                    "content": "|  Method resolution order:\n|      NotSupportedError\n|      DatabaseError\n|      Error\n|      builtins.Exception\n|      builtins.BaseException\n|      builtins.object\n|\n|  Data descriptors inherited from Error:\n|\n|  weakref\n|      list of weak references to the object (if defined)\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.Exception:\n|\n|  init(self, /, *args, kwargs)\n|      Initialize self.  See help(type(self)) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Static methods inherited from builtins.Exception:\n|\n|  new(*args, kwargs) from builtins.type\n|      Create and return a new object.  See help(type) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.BaseException:\n|\n|  delattr(self, name, /)\n|      Implement delattr(self, name).\n|\n|  getattribute(self, name, /)\n|      Return getattr(self, name).\n|\n|  reduce(...)\n|      Helper for pickle.\n|\n|  repr(self, /)\n|      Return repr(self).\n|\n|  setattr(self, name, value, /)\n|      Implement setattr(self, name, value).\n|\n|  setstate(...)\n|\n|  str(self, /)\n|      Return str(self).\n|\n|  withtraceback(...)\n|      Exception.withtraceback(tb) --\n|      set self.traceback to tb and return self.\n|\n|  ----------------------------------------------------------------------\n|  Data descriptors inherited from builtins.BaseException:\n|\n|  cause\n|      exception cause\n|\n|  context\n|      exception context\n|\n|  dict\n|\n|  suppresscontext\n|\n|  traceback\n|\n|  args\n"
                },
                {
                    "name": "class OperationalError",
                    "content": "|  Method resolution order:\n|      OperationalError\n|      DatabaseError\n|      Error\n|      builtins.Exception\n|      builtins.BaseException\n|      builtins.object\n|\n|  Data descriptors inherited from Error:\n|\n|  weakref\n|      list of weak references to the object (if defined)\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.Exception:\n|\n|  init(self, /, *args, kwargs)\n|      Initialize self.  See help(type(self)) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Static methods inherited from builtins.Exception:\n|\n|  new(*args, kwargs) from builtins.type\n|      Create and return a new object.  See help(type) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.BaseException:\n|\n|  delattr(self, name, /)\n|      Implement delattr(self, name).\n|\n|  getattribute(self, name, /)\n|      Return getattr(self, name).\n|\n|  reduce(...)\n|      Helper for pickle.\n|\n|  repr(self, /)\n|      Return repr(self).\n|\n|  setattr(self, name, value, /)\n|      Implement setattr(self, name, value).\n|\n|  setstate(...)\n|\n|  str(self, /)\n|      Return str(self).\n|\n|  withtraceback(...)\n|      Exception.withtraceback(tb) --\n|      set self.traceback to tb and return self.\n|\n|  ----------------------------------------------------------------------\n|  Data descriptors inherited from builtins.BaseException:\n|\n|  cause\n|      exception cause\n|\n|  context\n|      exception context\n|\n|  dict\n|\n|  suppresscontext\n|\n|  traceback\n|\n|  args\n"
                },
                {
                    "name": "class PrepareProtocol",
                    "content": "|  PEP 246 style object adaption protocol type.\n|\n|  Methods defined here:\n|\n|  init(self, /, *args, kwargs)\n|      Initialize self.  See help(type(self)) for accurate signature.\n"
                },
                {
                    "name": "class ProgrammingError",
                    "content": "|  Method resolution order:\n|      ProgrammingError\n|      DatabaseError\n|      Error\n|      builtins.Exception\n|      builtins.BaseException\n|      builtins.object\n|\n|  Data descriptors inherited from Error:\n|\n|  weakref\n|      list of weak references to the object (if defined)\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.Exception:\n|\n|  init(self, /, *args, kwargs)\n|      Initialize self.  See help(type(self)) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Static methods inherited from builtins.Exception:\n|\n|  new(*args, kwargs) from builtins.type\n|      Create and return a new object.  See help(type) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.BaseException:\n|\n|  delattr(self, name, /)\n|      Implement delattr(self, name).\n|\n|  getattribute(self, name, /)\n|      Return getattr(self, name).\n|\n|  reduce(...)\n|      Helper for pickle.\n|\n|  repr(self, /)\n|      Return repr(self).\n|\n|  setattr(self, name, value, /)\n|      Implement setattr(self, name, value).\n|\n|  setstate(...)\n|\n|  str(self, /)\n|      Return str(self).\n|\n|  withtraceback(...)\n|      Exception.withtraceback(tb) --\n|      set self.traceback to tb and return self.\n|\n|  ----------------------------------------------------------------------\n|  Data descriptors inherited from builtins.BaseException:\n|\n|  cause\n|      exception cause\n|\n|  context\n|      exception context\n|\n|  dict\n|\n|  suppresscontext\n|\n|  traceback\n|\n|  args\n"
                },
                {
                    "name": "class Row",
                    "content": "|  Methods defined here:\n|\n|  eq(self, value, /)\n|      Return self==value.\n|\n|  ge(self, value, /)\n|      Return self>=value.\n|\n|  getitem(self, key, /)\n|      Return self[key].\n|\n|  gt(self, value, /)\n|      Return self>value.\n|\n|  hash(self, /)\n|      Return hash(self).\n|\n|  iter(self, /)\n|      Implement iter(self).\n|\n|  le(self, value, /)\n|      Return self<=value.\n|\n|  len(self, /)\n|      Return len(self).\n|\n|  lt(self, value, /)\n|      Return self<value.\n|\n|  ne(self, value, /)\n|      Return self!=value.\n|\n|  keys(self, /)\n|      Returns the keys of the row.\n|\n|  ----------------------------------------------------------------------\n|  Static methods defined here:\n|\n|  new(*args, kwargs) from builtins.type\n|      Create and return a new object.  See help(type) for accurate signature.\n"
                },
                {
                    "name": "class Warning",
                    "content": "|  Method resolution order:\n|      Warning\n|      builtins.Exception\n|      builtins.BaseException\n|      builtins.object\n|\n|  Data descriptors defined here:\n|\n|  weakref\n|      list of weak references to the object (if defined)\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.Exception:\n|\n|  init(self, /, *args, kwargs)\n|      Initialize self.  See help(type(self)) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Static methods inherited from builtins.Exception:\n|\n|  new(*args, kwargs) from builtins.type\n|      Create and return a new object.  See help(type) for accurate signature.\n|\n|  ----------------------------------------------------------------------\n|  Methods inherited from builtins.BaseException:\n|\n|  delattr(self, name, /)\n|      Implement delattr(self, name).\n|\n|  getattribute(self, name, /)\n|      Return getattr(self, name).\n|\n|  reduce(...)\n|      Helper for pickle.\n|\n|  repr(self, /)\n|      Return repr(self).\n|\n|  setattr(self, name, value, /)\n|      Implement setattr(self, name, value).\n|\n|  setstate(...)\n|\n|  str(self, /)\n|      Return str(self).\n|\n|  withtraceback(...)\n|      Exception.withtraceback(tb) --\n|      set self.traceback to tb and return self.\n|\n|  ----------------------------------------------------------------------\n|  Data descriptors inherited from builtins.BaseException:\n|\n|  cause\n|      exception cause\n|\n|  context\n|      exception context\n|\n|  dict\n|\n|  suppresscontext\n|\n|  traceback\n|\n|  args\n"
                }
            ]
        },
        "FUNCTIONS": {
            "content": "getattr(name)\n# bpo-42264: OptimizedUnicode was deprecated in Python 3.10.  It's scheduled\n# for removal in Python 3.12.\n",
            "subsections": [
                {
                    "name": "adapt",
                    "content": "Adapt given object to given protocol.\n"
                },
                {
                    "name": "complete_statement",
                    "content": "Checks if a string contains a complete SQL statement.\n"
                },
                {
                    "name": "connect",
                    "content": "connect(database[, timeout, detecttypes, isolationlevel,\nchecksamethread, factory, cachedstatements, uri])\n\nOpens a connection to the SQLite database file *database*. You can use\n\":memory:\" to open a database connection to a database that resides in\nRAM instead of on disk.\n"
                },
                {
                    "name": "enable_callback_tracebacks",
                    "content": "Enable or disable callback functions throwing errors to stderr.\n"
                },
                {
                    "name": "register_adapter",
                    "content": "Register a function to adapt Python objects to SQLite values.\n"
                },
                {
                    "name": "register_converter",
                    "content": "Register a function to convert SQLite values to Python objects.\n"
                }
            ]
        },
        "DATA": {
            "content": "PARSECOLNAMES = 2\nPARSEDECLTYPES = 1\nSQLITEALTERTABLE = 26\nSQLITEANALYZE = 28\nSQLITEATTACH = 24\nSQLITECREATEINDEX = 1\nSQLITECREATETABLE = 2\nSQLITECREATETEMPINDEX = 3\nSQLITECREATETEMPTABLE = 4\nSQLITECREATETEMPTRIGGER = 5\nSQLITECREATETEMPVIEW = 6\nSQLITECREATETRIGGER = 7\nSQLITECREATEVIEW = 8\nSQLITECREATEVTABLE = 29\nSQLITEDELETE = 9\nSQLITEDENY = 1\nSQLITEDETACH = 25\nSQLITEDONE = 101\nSQLITEDROPINDEX = 10\nSQLITEDROPTABLE = 11\nSQLITEDROPTEMPINDEX = 12\nSQLITEDROPTEMPTABLE = 13\nSQLITEDROPTEMPTRIGGER = 14\nSQLITEDROPTEMPVIEW = 15\nSQLITEDROPTRIGGER = 16\nSQLITEDROPVIEW = 17\nSQLITEDROPVTABLE = 30\nSQLITEFUNCTION = 31\nSQLITEIGNORE = 2\nSQLITEINSERT = 18\nSQLITEOK = 0\nSQLITEPRAGMA = 19\nSQLITEREAD = 20\nSQLITERECURSIVE = 33\nSQLITEREINDEX = 27\nSQLITESAVEPOINT = 32\nSQLITESELECT = 21\nSQLITETRANSACTION = 22\nSQLITEUPDATE = 23\nadapters = {(<class 'datetime.date'>, <class 'sqlite3.PrepareProtocol'...\napilevel = '2.0'\nconverters = {'DATE': <function registeradaptersandconverters.<loca...\nparamstyle = 'qmark'\nsqliteversion = '3.37.2'\nsqliteversioninfo = (3, 37, 2)\nthreadsafety = 1\nversion = '2.6.0'\nversioninfo = (2, 6, 0)\n",
            "subsections": []
        },
        "FILE": {
            "content": "/usr/lib/python3.10/sqlite3/init.py\n\n",
            "subsections": []
        }
    },
    "summary": "sqlite3",
    "flags": [],
    "examples": [],
    "see_also": [],
    "tldr": {
        "source": "official",
        "description": "Interface to SQLite 3, which is a self-contained file-based embedded SQL engine.",
        "examples": [
            {
                "description": "Start an interactive shell with a new database",
                "command": "sqlite3"
            },
            {
                "description": "Open an interactive shell against an existing database",
                "command": "sqlite3 {{path/to/database.sqlite3}}"
            },
            {
                "description": "Execute an SQL statement against a database and then exit",
                "command": "sqlite3 {{path/to/database.sqlite3}} '{{SELECT * FROM some_table;}}'"
            }
        ]
    }
}