Lines Matching refs:database
13 SQLite is a C library that provides a lightweight disk-based database that
14 doesn't require a separate server process and allows accessing the database
17 application using SQLite and then port the code to a larger database such as
25 represents the database. Here the data will be stored in the
32 database in RAM.
211 .. function:: connect(database[, timeout, detect_types, isolation_level, check_same_thread, factory…
213 Opens a connection to the SQLite database file *database*. By default returns a
216 *database* is a :term:`path-like object` giving the pathname (absolute or
217 relative to the current working directory) of the database file to be opened.
218 You can use ``":memory:"`` to open a database connection to a database that
221 When a database is accessed by multiple connections, and one of the processes
222 modifies the database, the SQLite database is locked until that transaction is
258 If *uri* is true, *database* is interpreted as a URI. This allows you
259 to specify options. For example, to open a database in read-only mode
262 db = sqlite3.connect('file:path/to/database?mode=ro', uri=True)
267 .. audit-event:: sqlite3.connect database sqlite3.connect
274 *database* can now also be a :term:`path-like object`, not only a string.
282 Registers a callable to convert a bytestring from the database into a custom
283 Python type. The callable will be invoked for all database values that are of
326 A SQLite database connection has the following attributes and methods:
351 other database connections. If you wonder why you don't see the data you've
352 written to the database, please check you didn't forget to call this method.
356 This method rolls back any changes to the database since the last call to
361 This closes the database connection. Note that this does not automatically
362 call :meth:`commit`. If you just close your database connection without
456 access a column of a table in the database. The callback should return
464 depending on the first argument. The 4th argument is the name of the database
500 database.
584 Returns the total number of database rows that have been modified, inserted, or
585 deleted since the database connection was opened.
590 Returns an iterator to dump the database in an SQL text format. Useful when
591 saving an in-memory database for later restoration. This function provides
609 This method makes a backup of a SQLite database even while it's being accessed
615 database is copied in a single step; otherwise the method performs a loop
623 The *name* argument specifies the database name that will be copied: it must be
625 database, ``"temp"`` to indicate the temporary database or the name specified
627 database.
633 Example 1, copy an existing database into another::
647 Example 2, copy an existing database into a transient copy::
755 attribute, the database engine's own support for the determination of "rows
797 This read-only attribute provides the SQLite database :class:`Connection`
889 Exception raised for errors that are related to the database.
893 Exception raised when the relational integrity of the database is affected,
904 Exception raised for errors that are related to the database's operation
911 Exception raised in case a method or database API was used which is not
912 supported by the database, e.g. calling the :meth:`~Connection.rollback`
964 store additional Python types in a SQLite database via object adaptation, and
1042 the database is actually a point. There are two ways of doing this:
1080 The default "timestamp" converter ignores UTC offsets in the database and
1093 ``autocommit`` mode means that statements that modify the database take effect