Updated: 2022/Sep/29

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

SQLITE_CHANGESETAPPLY_NOSAVEPOINT(3)                  Library Functions Manual

NAME
     SQLITE_CHANGESETAPPLY_NOSAVEPOINT, SQLITE_CHANGESETAPPLY_INVERT,
     SQLITE_CHANGESETAPPLY_IGNORENOOP - flags for sqlite3changeset_apply_v2

SYNOPSIS
     #include <sqlite3.h>

     #define SQLITE_CHANGESETAPPLY_NOSAVEPOINT
     #define SQLITE_CHANGESETAPPLY_INVERT
     #define SQLITE_CHANGESETAPPLY_IGNORENOOP

DESCRIPTION
     The following flags may passed via the 9th parameter to
     sqlite3changeset_apply_v2 and sqlite3changeset_apply_v2_strm:

     SQLITE_CHANGESETAPPLY_NOSAVEPOINT
             Usually, the sessions module encloses all operations performed by
             a single call to apply_v2() or apply_v2_strm() in a SAVEPOINT.
             The SAVEPOINT is committed if the changeset or patchset is
             successfully applied, or rolled back if an error occurs.
             Specifying this flag causes the sessions module to omit this
             savepoint.  In this case, if the caller has an open transaction
             or savepoint when apply_v2() is called, it may revert the
             partially applied changeset by rolling it back.

     SQLITE_CHANGESETAPPLY_INVERT
             Invert the changeset before applying it.  This is equivalent to
             inverting a changeset using sqlite3changeset_invert() before
             applying it.  It is an error to specify this flag with a
             patchset.

     SQLITE_CHANGESETAPPLY_IGNORENOOP
             Do not invoke the conflict handler callback for any changes that
             would not actually modify the database even if they were applied.
             Specifically, this means that the conflict handler is not invoked
             for:

             ⊕   a delete change if the row being deleted cannot be found,

             ⊕   an update change if the modified fields are already set to
                 their new values in the conflicting row, or

             ⊕   an insert change if all fields of the conflicting row match
                 the row being inserted.

IMPLEMENTATION NOTES
     These declarations were extracted from the interface documentation at
     line 12033.

     #define SQLITE_CHANGESETAPPLY_NOSAVEPOINT   0x0001
     #define SQLITE_CHANGESETAPPLY_INVERT        0x0002
     #define SQLITE_CHANGESETAPPLY_IGNORENOOP    0x0004

SEE ALSO
     sqlite3changeset_apply(3), sqlite3changeset_apply_strm(3)

NetBSD 10.99                    August 24, 2023                   NetBSD 10.99