Back to module index

Go to module by name

sqlite3 (package)


The sqlite3 extension module provides a DB-API 2.0 (PEP 249) compliant
interface to the SQLite library, and requires SQLite 3.7.15 or newer.

To use the module, start by creating a database Connection object:

    import sqlite3
    cx = sqlite3.connect("test.db")  # test.db will be created or opened

The special path name ":memory:" can be provided to connect to a transient
in-memory database:

    cx = sqlite3.connect(":memory:")  # connect to a database in RAM

Once a connection has been established, create a Cursor object and call
its execute() method to perform SQL queries:

    cu = cx.cursor()

    # create a table
    cu.execute("create table lang(name, first_appeared)")

    # insert values into a table
    cu.execute("insert into lang values (?, ?)", ("C", 1972))

    # execute a query and iterate over the result
    for row in cu.execute("select * from lang"):
        print(row)

    cx.close()

The sqlite3 module is written by Gerhard Häring <gh@ghaering.de>.

Classes

memoryview

Create a new memoryview object which references the given object.
cast(self, /, format, *, shape)

  Cast a memoryview to a new format or shape.
hex(...)

  Return the data in the buffer as a str of hexadecimal numbers.

    sep
      An optional single character or byte to separate hex bytes.
    bytes_per_sep
      How many bytes between separators.  Positive values count from the
      right, negative values count from the left.

  Example:
  >>> value = memoryview(b'\xb9\x01\xef')
  >>> value.hex()
  'b901ef'
  >>> value.hex(':')
  'b9:01:ef'
  >>> value.hex(':', 2)
  'b9:01ef'
  >>> value.hex(':', -2)
  'b901:ef'
release(self, /)

  Release the underlying buffer exposed by the memoryview object.
tobytes(self, /, order=None)

  Return the data in the buffer as a byte string. Order can be {'C', 'F', 'A'}.
  When order is 'C' or 'F', the data of the original array is converted to C or
  Fortran order. For contiguous views, 'A' returns an exact copy of the physical
  memory. In particular, in-memory Fortran order is preserved. For non-contiguous
  views, the data is converted to C first. order=None is the same as order='C'.
tolist(self, /)

  Return the data in the buffer as a list of elements.
toreadonly(self, /)

  Return a readonly version of the memoryview.
c_contiguous = <attribute 'c_contiguous' of 'memoryview' objects>
  A bool indicating whether the memory is C contiguous.
contiguous = <attribute 'contiguous' of 'memoryview' objects>
  A bool indicating whether the memory is contiguous.
f_contiguous = <attribute 'f_contiguous' of 'memoryview' objects>
  A bool indicating whether the memory is Fortran contiguous.
format = <attribute 'format' of 'memoryview' objects>
  A string containing the format (in struct module style)
   for each element in the view.
itemsize = <attribute 'itemsize' of 'memoryview' objects>
  The size in bytes of each element of the memoryview.
nbytes = <attribute 'nbytes' of 'memoryview' objects>
  The amount of space in bytes that the array would use in
   a contiguous representation.
ndim = <attribute 'ndim' of 'memoryview' objects>
  An integer indicating how many dimensions of a multi-dimensional
   array the memory represents.
obj = <attribute 'obj' of 'memoryview' objects>
  The underlying object of the memoryview.
readonly = <attribute 'readonly' of 'memoryview' objects>
  A bool indicating whether the memory is read only.
shape = <attribute 'shape' of 'memoryview' objects>
  A tuple of ndim integers giving the shape of the memory
   as an N-dimensional array.
strides = <attribute 'strides' of 'memoryview' objects>
  A tuple of ndim integers giving the size in bytes to access
   each element for each dimension of the array.
suboffsets = <attribute 'suboffsets' of 'memoryview' objects>
  A tuple of integers used internally for PIL-style arrays.

Connection

SQLite database connection object.
backup(...)

  Makes a backup of the database.
close(...)

  Closes the connection.
commit(...)

  Commit the current transaction.
create_aggregate(...)

  Creates a new aggregate.
create_collation(...)

  Creates a collation function.
create_function(...)

  Creates a new function.
cursor(...)

  Return a cursor for the connection.
enable_load_extension(...)

  Enable dynamic loading of SQLite extension modules.
execute(...)

  Executes an SQL statement.
executemany(...)

  Repeatedly executes an SQL statement.
executescript(...)

  Executes a multiple SQL statements at once.
interrupt(...)

  Abort any pending database operation.
iterdump(...)

  Returns iterator to the dump of the database in an SQL text format.
load_extension(...)

  Load SQLite extension module.
rollback(...)

  Roll back the current transaction.
set_authorizer(...)

  Sets authorizer callback.
set_progress_handler(...)

  Sets progress handler callback.
set_trace_callback(...)

  Sets a trace callback called for each SQL statement (passed as unicode).
DataError = <member 'DataError' of 'sqlite3.Connection' objects>
DatabaseError = <member 'DatabaseError' of 'sqlite3.Connection' objects>
Error = <member 'Error' of 'sqlite3.Connection' objects>
IntegrityError = <member 'IntegrityError' of 'sqlite3.Connection' objects>
InterfaceError = <member 'InterfaceError' of 'sqlite3.Connection' objects>
InternalError = <member 'InternalError' of 'sqlite3.Connection' objects>
NotSupportedError = <member 'NotSupportedError' of 'sqlite3.Connection' objects>
OperationalError = <member 'OperationalError' of 'sqlite3.Connection' objects>
ProgrammingError = <member 'ProgrammingError' of 'sqlite3.Connection' objects>
Warning = <member 'Warning' of 'sqlite3.Connection' objects>
in_transaction = <attribute 'in_transaction' of 'sqlite3.Connection' objects>
isolation_level = <attribute 'isolation_level' of 'sqlite3.Connection' objects>
row_factory = <member 'row_factory' of 'sqlite3.Connection' objects>
text_factory = <member 'text_factory' of 'sqlite3.Connection' objects>
total_changes = <attribute 'total_changes' of 'sqlite3.Connection' objects>

Cursor

SQLite database cursor class.
close(...)

  Closes the cursor.
execute(...)

  Executes an SQL statement.
executemany(...)

  Repeatedly executes an SQL statement.
executescript(...)

  Executes multiple SQL statements at once.
fetchall(...)

  Fetches all rows from the resultset.
fetchmany(...)

  Fetches several rows from the resultset.
fetchone(...)

  Fetches one row from the resultset.
setinputsizes(...)

  Required by DB-API. Does nothing in sqlite3.
setoutputsize(...)

  Required by DB-API. Does nothing in sqlite3.
arraysize = <member 'arraysize' of 'sqlite3.Cursor' objects>
connection = <member 'connection' of 'sqlite3.Cursor' objects>
description = <member 'description' of 'sqlite3.Cursor' objects>
lastrowid = <member 'lastrowid' of 'sqlite3.Cursor' objects>
row_factory = <member 'row_factory' of 'sqlite3.Cursor' objects>
rowcount = <member 'rowcount' of 'sqlite3.Cursor' objects>

DataError

with_traceback(...)

  Exception.with_traceback(tb) --
      set self.__traceback__ to tb and return self.
args = <attribute 'args' of 'BaseException' objects>

DatabaseError

with_traceback(...)

  Exception.with_traceback(tb) --
      set self.__traceback__ to tb and return self.
args = <attribute 'args' of 'BaseException' objects>

date

date(year, month, day) --> date object
ctime(...)

  Return ctime() style string.
fromisocalendar(...)

  int, int, int -> Construct a date from the ISO year, week number and weekday.

  This is the inverse of the date.isocalendar() function
fromisoformat(...)

  str -> Construct a date from the output of date.isoformat()
fromordinal(...)

  int -> date corresponding to a proleptic Gregorian ordinal.
fromtimestamp(timestamp, /)

  Create a date from a POSIX timestamp.

  The timestamp is a number, e.g. created via time.time(), that is interpreted
  as local time.
isocalendar(...)

  Return a named tuple containing ISO year, week number, and weekday.
isoformat(...)

  Return string in ISO 8601 format, YYYY-MM-DD.
isoweekday(...)

  Return the day of the week represented by the date.
  Monday == 1 ... Sunday == 7
replace(...)

  Return date with new specified fields.
strftime(...)

  format -> strftime() style string.
timetuple(...)

  Return time tuple, compatible with time.localtime().
today(...)

  Current date or datetime:  same as self.__class__.fromtimestamp(time.time()).
toordinal(...)

  Return proleptic Gregorian ordinal.  January 1 of year 1 is day 1.
weekday(...)

  Return the day of the week represented by the date.
  Monday == 0 ... Sunday == 6
day = <attribute 'day' of 'datetime.date' objects>
max = datetime.date(9999, 12, 31)
min = datetime.date(1, 1, 1)
month = <attribute 'month' of 'datetime.date' objects>
resolution = datetime.timedelta(days=1)
year = <attribute 'year' of 'datetime.date' objects>

Error

with_traceback(...)

  Exception.with_traceback(tb) --
      set self.__traceback__ to tb and return self.
args = <attribute 'args' of 'BaseException' objects>

IntegrityError

with_traceback(...)

  Exception.with_traceback(tb) --
      set self.__traceback__ to tb and return self.
args = <attribute 'args' of 'BaseException' objects>

InterfaceError

with_traceback(...)

  Exception.with_traceback(tb) --
      set self.__traceback__ to tb and return self.
args = <attribute 'args' of 'BaseException' objects>

InternalError

with_traceback(...)

  Exception.with_traceback(tb) --
      set self.__traceback__ to tb and return self.
args = <attribute 'args' of 'BaseException' objects>

NotSupportedError

with_traceback(...)

  Exception.with_traceback(tb) --
      set self.__traceback__ to tb and return self.
args = <attribute 'args' of 'BaseException' objects>

OperationalError

with_traceback(...)

  Exception.with_traceback(tb) --
      set self.__traceback__ to tb and return self.
args = <attribute 'args' of 'BaseException' objects>

str

str(object='') -> str
str(bytes_or_buffer[, encoding[, errors]]) -> str

Create a new string object from the given object. If encoding or
errors is specified, then the object must expose a data buffer
that will be decoded using the given encoding and error handler.
Otherwise, returns the result of object.__str__() (if defined)
or repr(object).
encoding defaults to sys.getdefaultencoding().
errors defaults to 'strict'.
capitalize(self, /)

  Return a capitalized version of the string.

  More specifically, make the first character have upper case and the rest lower
  case.
casefold(self, /)

  Return a version of the string suitable for caseless comparisons.
center(self, width, fillchar=' ', /)

  Return a centered string of length width.

  Padding is done using the specified fill character (default is a space).
count(...)

  S.count(sub[, start[, end]]) -> int

  Return the number of non-overlapping occurrences of substring sub in
  string S[start:end].  Optional arguments start and end are
  interpreted as in slice notation.
encode(self, /, encoding='utf-8', errors='strict')

  Encode the string using the codec registered for encoding.

    encoding
      The encoding in which to encode the string.
    errors
      The error handling scheme to use for encoding errors.
      The default is 'strict' meaning that encoding errors raise a
      UnicodeEncodeError.  Other possible values are 'ignore', 'replace' and
      'xmlcharrefreplace' as well as any other name registered with
      codecs.register_error that can handle UnicodeEncodeErrors.
endswith(...)

  S.endswith(suffix[, start[, end]]) -> bool

  Return True if S ends with the specified suffix, False otherwise.
  With optional start, test S beginning at that position.
  With optional end, stop comparing S at that position.
  suffix can also be a tuple of strings to try.
expandtabs(self, /, tabsize=8)

  Return a copy where all tab characters are expanded using spaces.

  If tabsize is not given, a tab size of 8 characters is assumed.
find(...)

  S.find(sub[, start[, end]]) -> int

  Return the lowest index in S where substring sub is found,
  such that sub is contained within S[start:end].  Optional
  arguments start and end are interpreted as in slice notation.

  Return -1 on failure.
format(...)

  S.format(*args, **kwargs) -> str

  Return a formatted version of S, using substitutions from args and kwargs.
  The substitutions are identified by braces ('{' and '}').
format_map(...)

  S.format_map(mapping) -> str

  Return a formatted version of S, using substitutions from mapping.
  The substitutions are identified by braces ('{' and '}').
index(...)

  S.index(sub[, start[, end]]) -> int

  Return the lowest index in S where substring sub is found,
  such that sub is contained within S[start:end].  Optional
  arguments start and end are interpreted as in slice notation.

  Raises ValueError when the substring is not found.
isalnum(self, /)

  Return True if the string is an alpha-numeric string, False otherwise.

  A string is alpha-numeric if all characters in the string are alpha-numeric and
  there is at least one character in the string.
isalpha(self, /)

  Return True if the string is an alphabetic string, False otherwise.

  A string is alphabetic if all characters in the string are alphabetic and there
  is at least one character in the string.
isascii(self, /)

  Return True if all characters in the string are ASCII, False otherwise.

  ASCII characters have code points in the range U+0000-U+007F.
  Empty string is ASCII too.
isdecimal(self, /)

  Return True if the string is a decimal string, False otherwise.

  A string is a decimal string if all characters in the string are decimal and
  there is at least one character in the string.
isdigit(self, /)

  Return True if the string is a digit string, False otherwise.

  A string is a digit string if all characters in the string are digits and there
  is at least one character in the string.
isidentifier(self, /)

  Return True if the string is a valid Python identifier, False otherwise.

  Call keyword.iskeyword(s) to test whether string s is a reserved identifier,
  such as "def" or "class".
islower(self, /)

  Return True if the string is a lowercase string, False otherwise.

  A string is lowercase if all cased characters in the string are lowercase and
  there is at least one cased character in the string.
isnumeric(self, /)

  Return True if the string is a numeric string, False otherwise.

  A string is numeric if all characters in the string are numeric and there is at
  least one character in the string.
isprintable(self, /)

  Return True if the string is printable, False otherwise.

  A string is printable if all of its characters are considered printable in
  repr() or if it is empty.
isspace(self, /)

  Return True if the string is a whitespace string, False otherwise.

  A string is whitespace if all characters in the string are whitespace and there
  is at least one character in the string.
istitle(self, /)

  Return True if the string is a title-cased string, False otherwise.

  In a title-cased string, upper- and title-case characters may only
  follow uncased characters and lowercase characters only cased ones.
isupper(self, /)

  Return True if the string is an uppercase string, False otherwise.

  A string is uppercase if all cased characters in the string are uppercase and
  there is at least one cased character in the string.
join(self, iterable, /)

  Concatenate any number of strings.

  The string whose method is called is inserted in between each given string.
  The result is returned as a new string.

  Example: '.'.join(['ab', 'pq', 'rs']) -> 'ab.pq.rs'
ljust(self, width, fillchar=' ', /)

  Return a left-justified string of length width.

  Padding is done using the specified fill character (default is a space).
lower(self, /)

  Return a copy of the string converted to lowercase.
lstrip(self, chars=None, /)

  Return a copy of the string with leading whitespace removed.

  If chars is given and not None, remove characters in chars instead.
maketrans(...)

  Return a translation table usable for str.translate().

  If there is only one argument, it must be a dictionary mapping Unicode
  ordinals (integers) or characters to Unicode ordinals, strings or None.
  Character keys will be then converted to ordinals.
  If there are two arguments, they must be strings of equal length, and
  in the resulting dictionary, each character in x will be mapped to the
  character at the same position in y. If there is a third argument, it
  must be a string, whose characters will be mapped to None in the result.
partition(self, sep, /)

  Partition the string into three parts using the given separator.

  This will search for the separator in the string.  If the separator is found,
  returns a 3-tuple containing the part before the separator, the separator
  itself, and the part after it.

  If the separator is not found, returns a 3-tuple containing the original string
  and two empty strings.
removeprefix(self, prefix, /)

  Return a str with the given prefix string removed if present.

  If the string starts with the prefix string, return string[len(prefix):].
  Otherwise, return a copy of the original string.
removesuffix(self, suffix, /)

  Return a str with the given suffix string removed if present.

  If the string ends with the suffix string and that suffix is not empty,
  return string[:-len(suffix)]. Otherwise, return a copy of the original
  string.
replace(self, old, new, count=-1, /)

  Return a copy with all occurrences of substring old replaced by new.

    count
      Maximum number of occurrences to replace.
      -1 (the default value) means replace all occurrences.

  If the optional argument count is given, only the first count occurrences are
  replaced.
rfind(...)

  S.rfind(sub[, start[, end]]) -> int

  Return the highest index in S where substring sub is found,
  such that sub is contained within S[start:end].  Optional
  arguments start and end are interpreted as in slice notation.

  Return -1 on failure.
rindex(...)

  S.rindex(sub[, start[, end]]) -> int

  Return the highest index in S where substring sub is found,
  such that sub is contained within S[start:end].  Optional
  arguments start and end are interpreted as in slice notation.

  Raises ValueError when the substring is not found.
rjust(self, width, fillchar=' ', /)

  Return a right-justified string of length width.

  Padding is done using the specified fill character (default is a space).
rpartition(self, sep, /)

  Partition the string into three parts using the given separator.

  This will search for the separator in the string, starting at the end. If
  the separator is found, returns a 3-tuple containing the part before the
  separator, the separator itself, and the part after it.

  If the separator is not found, returns a 3-tuple containing two empty strings
  and the original string.
rsplit(self, /, sep=None, maxsplit=-1)

  Return a list of the words in the string, using sep as the delimiter string.

    sep
      The delimiter according which to split the string.
      None (the default value) means split according to any whitespace,
      and discard empty strings from the result.
    maxsplit
      Maximum number of splits to do.
      -1 (the default value) means no limit.

  Splits are done starting at the end of the string and working to the front.
rstrip(self, chars=None, /)

  Return a copy of the string with trailing whitespace removed.

  If chars is given and not None, remove characters in chars instead.
split(self, /, sep=None, maxsplit=-1)

  Return a list of the words in the string, using sep as the delimiter string.

    sep
      The delimiter according which to split the string.
      None (the default value) means split according to any whitespace,
      and discard empty strings from the result.
    maxsplit
      Maximum number of splits to do.
      -1 (the default value) means no limit.
splitlines(self, /, keepends=False)

  Return a list of the lines in the string, breaking at line boundaries.

  Line breaks are not included in the resulting list unless keepends is given and
  true.
startswith(...)

  S.startswith(prefix[, start[, end]]) -> bool

  Return True if S starts with the specified prefix, False otherwise.
  With optional start, test S beginning at that position.
  With optional end, stop comparing S at that position.
  prefix can also be a tuple of strings to try.
strip(self, chars=None, /)

  Return a copy of the string with leading and trailing whitespace removed.

  If chars is given and not None, remove characters in chars instead.
swapcase(self, /)

  Convert uppercase characters to lowercase and lowercase characters to uppercase.
title(self, /)

  Return a version of the string where each word is titlecased.

  More specifically, words start with uppercased characters and all remaining
  cased characters have lower case.
translate(self, table, /)

  Replace each character in the string using the given translation table.

    table
      Translation table, which must be a mapping of Unicode ordinals to
      Unicode ordinals, strings, or None.

  The table must implement lookup/indexing via __getitem__, for instance a
  dictionary or list.  If this operation raises LookupError, the character is
  left untouched.  Characters mapped to None are deleted.
upper(self, /)

  Return a copy of the string converted to uppercase.
zfill(self, width, /)

  Pad a numeric string with zeros on the left, to fill a field of the given width.

  The string is never truncated.

PrepareProtocol

ProgrammingError

with_traceback(...)

  Exception.with_traceback(tb) --
      set self.__traceback__ to tb and return self.
args = <attribute 'args' of 'BaseException' objects>

Row

keys(...)

  Returns the keys of the row.

time

time([hour[, minute[, second[, microsecond[, tzinfo]]]]]) --> a time object

All arguments are optional. tzinfo may be None, or an instance of
a tzinfo subclass. The remaining arguments may be ints.

dst(...)

  Return self.tzinfo.dst(self).
fromisoformat(...)

  string -> time from time.isoformat() output
isoformat(...)

  Return string in ISO 8601 format, [HH[:MM[:SS[.mmm[uuu]]]]][+HH:MM].

  The optional argument timespec specifies the number of additional terms
  of the time to include. Valid options are 'auto', 'hours', 'minutes',
  'seconds', 'milliseconds' and 'microseconds'.

replace(...)

  Return time with new specified fields.
strftime(...)

  format -> strftime() style string.
tzname(...)

  Return self.tzinfo.tzname(self).
utcoffset(...)

  Return self.tzinfo.utcoffset(self).
fold = <attribute 'fold' of 'datetime.time' objects>
hour = <attribute 'hour' of 'datetime.time' objects>
max = datetime.time(23, 59, 59, 999999)
microsecond = <attribute 'microsecond' of 'datetime.time' objects>
min = datetime.time(0, 0)
minute = <attribute 'minute' of 'datetime.time' objects>
resolution = datetime.timedelta(microseconds=1)
second = <attribute 'second' of 'datetime.time' objects>
tzinfo = <attribute 'tzinfo' of 'datetime.time' objects>

datetime

datetime(year, month, day[, hour[, minute[, second[, microsecond[,tzinfo]]]]])

The year, month and day arguments are required. tzinfo may be None, or an
instance of a tzinfo subclass. The remaining arguments may be ints.

astimezone(...)

  tz -> convert to local time in new timezone tz

combine(...)

  date, time -> datetime with same date and time fields
ctime(...)

  Return ctime() style string.
date(...)

  Return date object with same year, month and day.
dst(...)

  Return self.tzinfo.dst(self).
fromisocalendar(...)

  int, int, int -> Construct a date from the ISO year, week number and weekday.

  This is the inverse of the date.isocalendar() function
fromisoformat(...)

  string -> datetime from datetime.isoformat() output
fromordinal(...)

  int -> date corresponding to a proleptic Gregorian ordinal.
fromtimestamp(...)

  timestamp[, tz] -> tz's local time from POSIX timestamp.
isocalendar(...)

  Return a named tuple containing ISO year, week number, and weekday.
isoformat(...)

  [sep] -> string in ISO 8601 format, YYYY-MM-DDT[HH[:MM[:SS[.mmm[uuu]]]]][+HH:MM].
  sep is used to separate the year from the time, and defaults to 'T'.
  The optional argument timespec specifies the number of additional terms
  of the time to include. Valid options are 'auto', 'hours', 'minutes',
  'seconds', 'milliseconds' and 'microseconds'.

isoweekday(...)

  Return the day of the week represented by the date.
  Monday == 1 ... Sunday == 7
now(tz=None)

  Returns new datetime object representing current time local to tz.

    tz
      Timezone object.

  If no tz is specified, uses local timezone.
replace(...)

  Return datetime with new specified fields.
strftime(...)

  format -> strftime() style string.
strptime(...)

  string, format -> new datetime parsed from a string (like time.strptime()).
time(...)

  Return time object with same time but with tzinfo=None.
timestamp(...)

  Return POSIX timestamp as float.
timetuple(...)

  Return time tuple, compatible with time.localtime().
timetz(...)

  Return time object with same time and tzinfo.
today(...)

  Current date or datetime:  same as self.__class__.fromtimestamp(time.time()).
toordinal(...)

  Return proleptic Gregorian ordinal.  January 1 of year 1 is day 1.
tzname(...)

  Return self.tzinfo.tzname(self).
utcfromtimestamp(...)

  Construct a naive UTC datetime from a POSIX timestamp.
utcnow(...)

  Return a new datetime representing UTC day and time.
utcoffset(...)

  Return self.tzinfo.utcoffset(self).
utctimetuple(...)

  Return UTC time tuple, compatible with time.localtime().
weekday(...)

  Return the day of the week represented by the date.
  Monday == 0 ... Sunday == 6
day = <attribute 'day' of 'datetime.date' objects>
fold = <attribute 'fold' of 'datetime.datetime' objects>
hour = <attribute 'hour' of 'datetime.datetime' objects>
max = datetime.datetime(9999, 12, 31, 23, 59, 59, 999999)
microsecond = <attribute 'microsecond' of 'datetime.datetime' objects>
min = datetime.datetime(1, 1, 1, 0, 0)
minute = <attribute 'minute' of 'datetime.datetime' objects>
month = <attribute 'month' of 'datetime.date' objects>
resolution = datetime.timedelta(microseconds=1)
second = <attribute 'second' of 'datetime.datetime' objects>
tzinfo = <attribute 'tzinfo' of 'datetime.datetime' objects>
year = <attribute 'year' of 'datetime.date' objects>

Warning

with_traceback(...)

  Exception.with_traceback(tb) --
      set self.__traceback__ to tb and return self.
args = <attribute 'args' of 'BaseException' objects>

Functions

DateFromTicks

DateFromTicks(ticks)

TimeFromTicks

TimeFromTicks(ticks)

TimestampFromTicks

TimestampFromTicks(ticks)

adapt

adapt(...)

  adapt(obj, protocol, alternate) -> adapt obj to given protocol.

complete_statement

complete_statement(...)

  complete_statement(sql)

  Checks if a string contains a complete SQL statement.

connect

connect(...)

  connect(database[, timeout, detect_types, isolation_level,
          check_same_thread, factory, cached_statements, uri])

  Opens a connection to the SQLite database file *database*. You can use
  ":memory:" to open a database connection to a database that resides in
  RAM instead of on disk.

enable_callback_tracebacks

enable_callback_tracebacks(...)

  enable_callback_tracebacks(flag)

  Enable or disable callback functions throwing errors to stderr.

enable_shared_cache

enable_shared_cache(...)

  enable_shared_cache(do_enable)

  Enable or disable shared cache mode for the calling thread.

register_adapter

register_adapter(...)

  register_adapter(type, callable)

  Registers an adapter with sqlite3's adapter registry.

register_converter

register_converter(...)

  register_converter(typename, callable)

  Registers a converter with sqlite3.

Other members

PARSE_COLNAMES = 2
PARSE_DECLTYPES = 1
SQLITE_ALTER_TABLE = 26
SQLITE_ANALYZE = 28
SQLITE_ATTACH = 24
SQLITE_CREATE_INDEX = 1
SQLITE_CREATE_TABLE = 2
SQLITE_CREATE_TEMP_INDEX = 3
SQLITE_CREATE_TEMP_TABLE = 4
SQLITE_CREATE_TEMP_TRIGGER = 5
SQLITE_CREATE_TEMP_VIEW = 6
SQLITE_CREATE_TRIGGER = 7
SQLITE_CREATE_VIEW = 8
SQLITE_CREATE_VTABLE = 29
SQLITE_DELETE = 9
SQLITE_DENY = 1
SQLITE_DETACH = 25
SQLITE_DONE = 101
SQLITE_DROP_INDEX = 10
SQLITE_DROP_TABLE = 11
SQLITE_DROP_TEMP_INDEX = 12
SQLITE_DROP_TEMP_TABLE = 13
SQLITE_DROP_TEMP_TRIGGER = 14
SQLITE_DROP_TEMP_VIEW = 15
SQLITE_DROP_TRIGGER = 16
SQLITE_DROP_VIEW = 17
SQLITE_DROP_VTABLE = 30
SQLITE_FUNCTION = 31
SQLITE_IGNORE = 2
SQLITE_INSERT = 18
SQLITE_OK = 0
SQLITE_PRAGMA = 19
SQLITE_READ = 20
SQLITE_RECURSIVE = 33
SQLITE_REINDEX = 27
SQLITE_SAVEPOINT = 32
SQLITE_SELECT = 21
SQLITE_TRANSACTION = 22
SQLITE_UPDATE = 23
adapters = {(<class 'datetime.date'>, <class 'sqlite3.PrepareProtocol'>): <function register_adapters_and_converters.<locals>.adapt_date at 0x7f92be1879d0>, (<class 'datetime.datetime'>, <class 'sqlite3.PrepareProtocol'>): <function register_adapters_and_converters.<locals>.adapt_datetime at 0x7f92be187a60>}
apilevel = '2.0'
converters = {'DATE': <function register_adapters_and_converters.<locals>.convert_date at 0x7f92be187af0>, 'TIMESTAMP': <function register_adapters_and_converters.<locals>.convert_timestamp at 0x7f92be187b80>}
paramstyle = 'qmark'
sqlite_version = '3.38.5'
sqlite_version_info = (3, 38, 5)
threadsafety = 1
version = '2.6.0'
version_info = (2, 6, 0)

Modules

collections

datetime

dbapi2

time