Updated: 2022/Sep/29

Please read Privacy Policy. It's for your privacy.


     sqlite3session_create - create a new session object

     #include <sqlite3.h>

     sqlite3session_create(sqlite3 *db, const char *zDb,
         sqlite3_session **ppSession);

     Create a new session object attached to database handle db.  If
     successful, a pointer to the new object is written to *ppSession and
     SQLITE_OK is returned.  If an error occurs, *ppSession is set to NULL and
     an SQLite error code (e.g. SQLITE_NOMEM) is returned.

     It is possible to create multiple session objects attached to a single
     database handle.

     Session objects created using this function should be deleted using the
     sqlite3session_delete() function before the database handle that they are
     attached to is itself closed.  If the database handle is closed before
     the session object is deleted, then the results of calling any session
     module function, including sqlite3session_delete() on the session object
     are undefined.

     Because the session module uses the sqlite3_preupdate_hook() API, it is
     not possible for an application to register a pre-update hook on a
     database handle that has one or more session objects attached.  Nor is it
     possible to create a session object attached to a database handle for
     which a pre-update hook is already defined.  The results of attempting
     either of these things are undefined.

     The session object will be used to create changesets for tables in
     database zDb, where zDb is either "main", or "temp", or the name of an
     attached database.  It is not an error if database zDb is not attached to
     the database when the session object is created.

     These declarations were extracted from the interface documentation at
     line 10824.

     SQLITE_API int sqlite3session_create(
       sqlite3 *db,                    /* Database handle */
       const char *zDb,                /* Name of db (e.g. "main") */
       sqlite3_session **ppSession     /* OUT: New session object */

     sqlite3_preupdate_hook(3), sqlite3session_delete(3)

NetBSD 10.99                    August 24, 2023                   NetBSD 10.99