.Dd January 24, 2024
.Dt SQLITE_TXN_NONE 3
.Os
.Sh NAME
.Nm SQLITE_TXN_NONE ,
.Nm SQLITE_TXN_READ ,
.Nm SQLITE_TXN_WRITE
.Nd allowed return values from sqlite3_txn_state()
.Sh SYNOPSIS
.In sqlite3.h
.Fd #define SQLITE_TXN_NONE
.Fd #define SQLITE_TXN_READ
.Fd #define SQLITE_TXN_WRITE
.Sh DESCRIPTION
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.
.Bl -tag -width Ds
.It SQLITE_TXN_NONE
The SQLITE_TXN_NONE state means that no transaction is currently pending.
.It SQLITE_TXN_READ
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 COMMIT.
.It SQLITE_TXN_WRITE
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.
.Sh IMPLEMENTATION NOTES
These declarations were extracted from the
interface documentation at line 6673.
.Bd -literal
#define SQLITE_TXN_NONE  0
#define SQLITE_TXN_READ  1
#define SQLITE_TXN_WRITE 2
.Ed
.Sh SEE ALSO
.Xr sqlite3 3