Lines Matching full:database
215 ** CAPI3REF: Database Connection Handle
216 ** KEYWORDS: {database connection} {database connections}
218 ** Each open SQLite database is represented by a pointer to an instance of
267 ** CAPI3REF: Closing A Database Connection
276 ** sqlite3_close() is called on a [database connection] that still has
309 ** in the context of the [database connection] passed in as its 1st
346 ** SQL comments, then no SQL statements are evaluated and the database
353 ** is a valid and open [database connection].
354 ** <li> The application must not close [database connection] specified by
361 sqlite3*, /* An open database */
382 #define SQLITE_ERROR 1 /* SQL error or missing database */
386 #define SQLITE_BUSY 5 /* The database file is locked */
387 #define SQLITE_LOCKED 6 /* A table in the database is locked */
389 #define SQLITE_READONLY 8 /* Attempt to write a readonly database */
392 #define SQLITE_CORRUPT 11 /* The database disk image is malformed */
394 #define SQLITE_FULL 13 /* Insertion failed because database is full */
395 #define SQLITE_CANTOPEN 14 /* Unable to open the database file */
396 #define SQLITE_PROTOCOL 15 /* Database lock protocol error */
397 #define SQLITE_EMPTY 16 /* Database is empty */
398 #define SQLITE_SCHEMA 17 /* The database schema changed */
405 #define SQLITE_FORMAT 24 /* Auxiliary database format error */
407 #define SQLITE_NOTADB 26 /* File opened that is not a database file */
427 ** on a per database connection basis using the
611 ** The xCheckReservedLock() method checks whether any database connection,
666 ** database corruption.
708 ** layer a hint of how large the database file will grow to be during the
710 ** is often close. The underlying VFS might choose to preallocate database
711 ** file space based on this hint in order to help writes to the database
715 ** extends and truncates the database file in chunks of a size specified
718 ** for the nominated database. Allocating database file space in large
819 ** SQLITE_IOERR. Or the implementation might recognize that a database
1004 ** single thread. All open [database connections] must be closed and all
1092 ** CAPI3REF: Configure database connections
1095 ** changes to a [database connection]. The interface is similar to
1097 ** [database connection] (specified in the first argument). The
1099 ** the database connection is created using [sqlite3_open()],
1104 ** aspect of the [database connection] is being configured.
1223 ** mutexing on [database connection] and [prepared statement] objects.
1225 ** [database connections] and [prepared statements]. But other mutexes
1228 ** [database connection] at the same time. ^If SQLite is compiled with
1238 ** mutexes on [database connection] and [prepared statement] objects.
1241 ** to [database connections] and [prepared statements] so that the
1242 ** application is free to use the same [database connection] or the
1294 ** times the database page size. ^If SQLite needs needs additional
1300 ** the database page cache with the default page cache implemenation.
1305 ** The sz argument should be the size of the largest database page
1362 ** [database connection]. The first argument is the
1364 ** slots allocated to each database connection.)^ ^(This option sets the
1418 ** CAPI3REF: Database Connection Configuration Options
1433 ** [lookaside memory allocator] configuration for the [database connection].
1445 ** configuration for a database connection can only be changed when that
1478 ** successful [INSERT] into the database from the [database connection]
1480 ** have ever occurred on that database connection, zero is returned.
1504 ** database connection while the [sqlite3_last_insert_rowid()]
1515 ** ^This function returns the number of database rows that were changed
1517 ** on the [database connection] specified by the first parameter.
1560 ** If a separate thread makes changes on the same database connection
1570 ** [UPDATE] or [DELETE] statements since the [database connection] was opened.
1586 ** If a separate thread makes changes on the same database connection
1595 ** ^This function causes any pending database operation to abort and
1602 ** thread that is currently running the database operation. But it
1603 ** is not safe to call this routine with a [database connection] that
1616 ** SQL statements on [database connection] D complete. ^Any new SQL statements
1626 ** If the database connection closes while [sqlite3_interrupt()]
1671 ** an attempt is made to open a database table that another thread
1683 ** access the database and [SQLITE_BUSY] or [SQLITE_IOERR_BLOCKED] is returned.
1685 ** is made to open the database for reading and the cycle repeats.
1707 ** already hold a RESERVED lock on the database file, but it needs
1709 ** pages into the database file without harm to concurrent
1720 ** [database connection]. Setting a new busy handler clears any
1725 ** database connection that invoked the busy handler. Any such actions
1728 ** A busy handler must not close the database connection
1747 ** [database connection] any any given moment. If another busy handler
1826 sqlite3 *db, /* An open database */
2055 ** [database connection], supplied in the first argument.
2097 ** try to execute malicious statements that damage the database. For
2099 ** SQL queries for evaluation by a database. But the application does
2101 ** database. An authorizer could then be put in place while the
2107 ** and limiting database size using the [max_page_count] [PRAGMA]
2110 ** ^(Only a single authorizer can be in place on a database connection
2116 ** the database connection that invoked the authorizer callback.
2118 ** database connections for the meaning of "modify" in this paragraph.
2162 ** authorizer callback is the name of the database ("main", "temp",
2193 #define SQLITE_DETACH 25 /* Database Name NULL */
2194 #define SQLITE_ALTER_TABLE 26 /* Database Name Table Name */
2238 ** database connection D. An example use for this
2247 ** [database connection]; setting a new progress handler cancels the
2257 ** the database connection that invoked the progress handler.
2259 ** database connections for the meaning of "modify" in this paragraph.
2265 ** CAPI3REF: Opening A New Database Connection
2267 ** ^These routines open an SQLite database file whose name is given by the
2270 ** order for sqlite3_open16(). ^(A [database connection] handle is usually
2274 ** object.)^ ^(If the database is opened (and/or created) successfully, then
2280 ** ^The default encoding for the database will be UTF-8 if
2285 ** associated with the [database connection] handle should be released by
2290 ** over the new database connection. ^(The flags parameter to
2298 ** <dd>The database is opened in read-only mode. If the database does not
2302 ** <dd>The database is opened for reading and writing if possible, or reading
2304 ** case the database must already exist, otherwise an error is returned.</dd>)^
2307 ** <dd>The database is opened for reading and writing, and is creates it if
2318 ** ^If the [SQLITE_OPEN_NOMUTEX] flag is set, then the database connection
2321 ** [SQLITE_OPEN_FULLMUTEX] flag is set then the database connection opens
2324 ** ^The [SQLITE_OPEN_SHAREDCACHE] flag causes the database connection to be
2327 ** [SQLITE_OPEN_PRIVATECACHE] flag causes the database connection to not
2330 ** ^If the filename is ":memory:", then a private, temporary in-memory database
2331 ** is created for the connection. ^This in-memory database will vanish when
2332 ** the database connection is closed. Future versions of SQLite might
2334 ** It is recommended that when a database filename actually does begin with
2339 ** on-disk database will be created. ^This private database will be
2340 ** automatically deleted as soon as the database connection is closed.
2344 ** the new database connection should use. ^If the fourth parameter is
2354 const char *filename, /* Database filename (UTF-8) */
2358 const void *filename, /* Database filename (UTF-16) */
2362 const char *filename, /* Database filename (UTF-8) */
2373 ** associated with a [database connection]. If a prior API call failed
2392 ** this, each thread can obtain exclusive use of the [database connection] D
2437 ** [database connection] whose limit is to be set or queried. The
2457 ** both their own internal database and also databases that are controlled
2465 ** interface to further control untrusted SQL. The size of the database
2542 ** The first argument, "db", is a [database connection] obtained from a
2544 ** [sqlite3_open16()]. The database connection must not have been closed.
2587 ** ^If the database schema changes, instead of returning [SQLITE_SCHEMA] as it
2616 sqlite3 *db, /* Database handle */
2623 sqlite3 *db, /* Database handle */
2630 sqlite3 *db, /* Database handle */
2637 sqlite3 *db, /* Database handle */
2654 ** CAPI3REF: Determine If An SQL Statement Writes The Database
2672 ** that can be stored in a database table. SQLite uses dynamic typing
2925 ** ^These routines provide a means to determine the database, table, and
2928 ** ^The name of the database or table or column can be returned as
2930 ** the database name, the _table_ routines return the table name, and
2937 ** database, table, and column.
2947 ** occurs. ^Otherwise, they return the name of the attached database, table,
2983 ** ^(For example, given the database schema:
3024 ** ^[SQLITE_BUSY] means that the database engine was unable to acquire the
3025 ** database locks it needs to do its job. ^If the statement is a [COMMIT]
3054 ** be the case that the same database connection is being used by two or
3365 ** ^The first parameter is the [database connection] to which the SQL
3366 ** function is to be added. ^If an application uses more than one database
3368 ** to each database connection separately.
3412 ** overloaded or when the database connection closes.)^
3426 ** matches the database encoding is a better
3436 ** close the database connection nor finalize or reset the prepared
3617 ** CAPI3REF: Database Connection For Functions
3620 ** the pointer to the [database connection] (the 1st parameter)
3817 ** with the [database connection] specified as the first argument.
3879 ** [database connection] is closed using [sqlite3_close()].
3918 ** ^To avoid having to register all collation sequences before a database
3920 ** [database connection] to be invoked whenever an undefined collation
3931 ** sqlite3_collation_needed16(). The second argument is the database
3954 ** Specify the key for an encrypted database. This routine should be
3961 sqlite3 *db, /* Database to be rekeyed */
3966 ** Change the key on an open database. If the current database is not
3968 ** database is decrypted.
3974 sqlite3 *db, /* Database to be rekeyed */
3979 ** Specify the activation key for a SEE database. Unless
3989 ** Specify the activation key for a CEROD database. Unless
4028 ** if a [database connection] is being used at the same time in a separate
4052 ** zero if the given database connection is or is not in autocommit mode,
4064 ** If another thread changes the autocommit status of the database
4071 ** CAPI3REF: Find The Database Handle Of A Prepared Statement
4073 ** ^The sqlite3_db_handle interface returns the [database connection] handle
4074 ** to which a [prepared statement] belongs. ^The [database connection]
4075 ** returned by sqlite3_db_handle is the same [database connection]
4086 ** pStmt associated with the [database connection] pDb. ^If pStmt is NULL
4088 ** associated with the database connection pDb. ^If no prepared statement
4091 ** The [database connection] pointer D in a call to
4092 ** [sqlite3_next_stmt(D,S)] must refer to an open database
4103 ** for the same database connection is overridden.
4107 ** for the same database connection is overridden.
4114 ** on the same [database connection] D, or NULL for
4118 ** the database connection that invoked the callback. Any actions
4119 ** to modify the database connection must be deferred until after the
4123 ** database connections for the meaning of "modify" in this paragraph.
4137 ** automatically rolled back because the database connection is closed.
4148 ** with the [database connection] identified by the first argument
4151 ** for the same database connection is overridden.
4161 ** database and table name containing the affected row.
4176 ** the database connection that invoked the update hook. Any actions
4177 ** to modify the database connection must be deferred until after the
4180 ** database connections for the meaning of "modify" in this paragraph.
4184 ** on the same [database connection] D, or NULL for
4200 ** ^(This routine enables or disables the sharing of the database cache
4201 ** and schema data structures between [database connection | connections]
4202 ** to the same database. Sharing is enabled if the argument is true
4211 ** Existing database connections continue use the sharing mode
4230 ** held by the database library. Memory used to cache database
4306 ** database table accessible using the [database connection] handle
4310 ** this function. ^The second parameter is either the name of the database
4311 ** (i.e. "main", "temp", or an attached database) containing the specified
4313 ** for the table using the same algorithm used by the database engine to
4356 ** ^(This function may load one or more schemas from database files. If an
4359 ** in the [database connection] (to be retrieved using sqlite3_errmsg()).)^
4366 const char *zDbName, /* Database name or NULL */
4402 sqlite3 *db, /* Load the extension into this database connection */
4427 ** each new [database connection] that is created. The idea here is that
4429 ** that is to be automatically loaded into all new database connections.
4454 ** will be called more than once for each database connection that is opened.
4497 ** module or until the [database connection] closes. The content
4499 ** any database connection.
4633 ** ^The module name is registered on the [database connection] specified
4767 ** in row iRow, column zColumn, table zTable in database zDb;
4780 ** ^Note that the database name is not the filename that contains
4781 ** the database but rather the symbolic name of the database that
4782 ** appears after the AS keyword when the database is connected using [ATTACH].
4783 ** ^For the main database file, the database name is "main".
4784 ** ^For TEMP tables, the database name is "temp".
4789 ** ^This function sets the [database connection] error code and message
4833 ** to a different row of the same database table. ^The new row is identified
4835 ** changed. ^The database, table and column on which the blob handle is open
4849 ** ^This function sets the database
4860 ** database connection is in [autocommit mode].
5244 ** CAPI3REF: Retrieve the mutex for a database connection
5247 ** serializes access to the [database connection] given in the argument
5255 ** CAPI3REF: Low-Level Control Of Database Files
5259 ** with a particular database identified by the second argument. ^The
5260 ** name of the database is "main" for the main database or "temp" for the
5261 ** TEMP database, or the name that appears after the AS keyword for
5264 ** main database file.
5277 ** open database file, then SQLITE_ERROR is returned. ^This error
5458 ** CAPI3REF: Database Connection Status
5461 ** about a single [database connection]. ^The first argument is the
5462 ** database connection object to be interrogated. ^The second argument
5482 ** CAPI3REF: Status Parameters for database connections
5500 ** memory used by all pager caches associated with the database connection.)^
5508 ** schema memory is shared with other database connections due to
5515 ** the database connection.)^
5610 ** determine exactly which parts of a database file are cached and for
5647 ** SQLite will typically create one cache instance for each open database file,
5651 ** will the page size of the database file that is to be cached plus an
5654 ** database page on disk. The value of R depends
5658 ** be used to cache database pages of a file stored on disk, or
5659 ** false if it is used for an in-memory database. The cache implementation
5766 ** The backup API copies the content of one database into another.
5772 ** ^Exclusive access is required to the destination database for the
5773 ** duration of the operation. ^However the source database is only
5776 ** performed on a live source database without preventing other users from
5777 ** reading or writing to the source database while the backup is underway.
5794 ** [database connection] associated with the destination database
5795 ** and the database name, respectively.
5796 ** ^The database name is "main" for the main database, "temp" for the
5797 ** temporary database, or the name specified after the AS keyword in
5798 ** an [ATTACH] statement for an attached database.
5800 ** sqlite3_backup_init(D,N,S,M) identify the [database connection]
5801 ** and database name of the source database, respectively.
5802 ** ^The source and destination [database connections] (parameters S and D)
5808 ** destination [database connection] D.
5835 ** <li> the destination database was opened read-only, or
5836 ** <li> the destination database is using write-ahead-log journaling
5838 ** <li> The destination database is an in-memory database and the
5848 ** [database connection]
5849 ** is being used to write to the source database when sqlite3_backup_step()
5863 ** sqlite3_backup_step() obtains a [shared lock] on the source database that
5865 ** ^Because the source database is not locked between calls to
5866 ** sqlite3_backup_step(), the source database may be modified mid-way
5867 ** through the backup process. ^If the source database is modified by an
5868 ** external process or via a database connection other than the one being
5871 ** database is modified by the using the same database connection as is used
5872 ** by the backup operation, then the backup database is automatically
5883 ** active write-transaction on the destination database is rolled back.
5902 ** up and the total number of pages in the source database file.
5907 ** sqlite3_backup_step(). ^If the source database is modified during a backup
5909 ** pages that need to be updated or the size of the source database file
5912 ** <b>Concurrent Usage of Database Handles</b>
5914 ** ^The source [database connection] may be used by the application for other
5916 ** ^If SQLite is compiled and configured to support threadsafe database
5917 ** connections, then the source database connection may be used concurrently
5921 ** [database connection] is not passed to any other API (by any thread) after
5924 ** if the application incorrectly accesses the destination [database connection]
5926 ** nevertheless. Use of the destination database connection while a
5930 ** guarantee that the shared cache used by the destination database
5944 sqlite3 *pDest, /* Destination database handle */
5945 const char *zDestName, /* Destination database name */
5946 sqlite3 *pSource, /* Source database handle */
5947 const char *zSourceName /* Source database name */
5957 ** ^When running in shared-cache mode, a database operation may fail with
5968 ** ^Shared-cache locks are released when a database connection concludes
5973 ** identity of the database connection (the blocking connection) that
6025 ** related to the set of unblocked database connections.
6030 ** database waits for the callback to be issued before taking any further
6112 ** will be invoked each time a database connection commits data to a
6117 ** the associated write-lock on the database released, so the implementation
6118 ** may read, write or [checkpoint] the database as required.
6122 ** registering the callback. ^The second is a copy of the database handle.
6123 ** ^The third parameter is the name of the database that was written to -
6124 ** either "main" or the name of an [ATTACH]-ed database. ^The fourth parameter
6136 ** A single database handle may have at most a single write-ahead log callback
6153 ** [sqlite3_wal_hook()] that causes any database on [database connection] D
6168 ** ^Every new [database connection] defaults to having the auto-checkpoint
6176 ** CAPI3REF: Checkpoint a database
6178 ** ^The [sqlite3_wal_checkpoint(D,X)] interface causes database named X
6179 ** on [database connection] D to be [checkpointed]. ^If X is NULL or an
6181 ** connection D. ^If the database connection D is not in
