Small. Fast. Reliable.
Choose any three.
#define SQLITE_TXN_NONE 0
#define SQLITE_TXN_READ 1
#define SQLITE_TXN_WRITE 2
These constants define the current transaction state of a database file.
The sqlite3_txn_state(D,S) interface returns one of these
constants in order to describe the transaction state of schema S
in database connection D.
- The SQLITE_TXN_NONE state means that no transaction is currently
- The SQLITE_TXN_READ state means that the database is currently
in a read transaction. Content has been read from the database file
but nothing in the database file has changed. The transaction state
will advanced to SQLITE_TXN_WRITE if any changes occur and there are
no other conflicting concurrent write transactions. The transaction
state will revert to SQLITE_TXN_NONE following a ROLLBACK or
- The SQLITE_TXN_WRITE state means that the database is currently
in a write transaction. Content has been written to the database file
but has not yet committed. The transaction state will change to
to SQLITE_TXN_NONE at the next ROLLBACK or COMMIT.
See also lists of