blob: a848de15276d525c3f062b0ad5f75f43e16e0d3e [file] [log] [blame]
dan6700d022010-04-12 19:05:58 +00001/*
2** 2010 February 1
3**
4** The author disclaims copyright to this source code. In place of
5** a legal notice, here is a blessing:
6**
7** May you do good and not evil.
8** May you find forgiveness for yourself and forgive others.
9** May you share freely, never taking more than you give.
10**
11*************************************************************************
12** This header file defines the interface to the write-ahead logging
13** system. Refer to the comments below and the header comment attached to
14** the implementation of each function in log.c for further details.
15*/
16
drhc438efd2010-04-26 00:19:45 +000017#ifndef _WAL_H_
18#define _WAL_H_
dan6700d022010-04-12 19:05:58 +000019
20#include "sqliteInt.h"
21
dan0420b742011-12-30 10:54:24 +000022/* Additional values that can be added to the sync_flags argument of
23** sqlite3WalFrames():
24*/
25#define WAL_SYNC_TRANSACTIONS 0x20 /* Sync at the end of each transaction */
26#define SQLITE_SYNC_MASK 0x13 /* Mask off the SQLITE_SYNC_* values */
27
dan5cf53532010-05-01 16:40:20 +000028#ifdef SQLITE_OMIT_WAL
dancdc1f042010-11-18 12:11:05 +000029# define sqlite3WalOpen(x,y,z) 0
drh85a83752011-05-16 21:00:27 +000030# define sqlite3WalLimit(x,y)
dancdc1f042010-11-18 12:11:05 +000031# define sqlite3WalClose(w,x,y,z) 0
32# define sqlite3WalBeginReadTransaction(y,z) 0
drh73b64e42010-05-30 19:55:15 +000033# define sqlite3WalEndReadTransaction(z)
dancdc1f042010-11-18 12:11:05 +000034# define sqlite3WalRead(v,w,x,y,z) 0
35# define sqlite3WalDbsize(y) 0
36# define sqlite3WalBeginWriteTransaction(y) 0
37# define sqlite3WalEndWriteTransaction(x) 0
38# define sqlite3WalUndo(x,y,z) 0
dan71d89912010-05-24 13:57:42 +000039# define sqlite3WalSavepoint(y,z)
dancdc1f042010-11-18 12:11:05 +000040# define sqlite3WalSavepointUndo(y,z) 0
41# define sqlite3WalFrames(u,v,w,x,y,z) 0
42# define sqlite3WalCheckpoint(r,s,t,u,v,w,x,y,z) 0
43# define sqlite3WalCallback(z) 0
44# define sqlite3WalExclusiveMode(y,z) 0
45# define sqlite3WalHeapMemory(z) 0
danb3bdc722012-02-23 15:35:49 +000046# define sqlite3WalFramesize(z) 0
dan5cf53532010-05-01 16:40:20 +000047#else
48
dan6e6bd562010-06-02 18:59:03 +000049#define WAL_SAVEPOINT_NDATA 4
dan71d89912010-05-24 13:57:42 +000050
drh833bf962010-04-28 14:42:19 +000051/* Connection to a write-ahead log (WAL) file.
52** There is one object of this type for each pager.
53*/
drh7ed91f22010-04-29 22:34:07 +000054typedef struct Wal Wal;
dan6700d022010-04-12 19:05:58 +000055
drh833bf962010-04-28 14:42:19 +000056/* Open and close a connection to a write-ahead log. */
drh85a83752011-05-16 21:00:27 +000057int sqlite3WalOpen(sqlite3_vfs*, sqlite3_file*, const char *, int, i64, Wal**);
drhd9e5c4f2010-05-12 18:01:39 +000058int sqlite3WalClose(Wal *pWal, int sync_flags, int, u8 *);
dan6700d022010-04-12 19:05:58 +000059
drh85a83752011-05-16 21:00:27 +000060/* Set the limiting size of a WAL file. */
61void sqlite3WalLimit(Wal*, i64);
62
drh833bf962010-04-28 14:42:19 +000063/* Used by readers to open (lock) and close (unlock) a snapshot. A
64** snapshot is like a read-transaction. It is the state of the database
65** at an instant in time. sqlite3WalOpenSnapshot gets a read lock and
66** preserves the current state even if the other threads or processes
67** write to or checkpoint the WAL. sqlite3WalCloseSnapshot() closes the
68** transaction and releases the lock.
69*/
drh73b64e42010-05-30 19:55:15 +000070int sqlite3WalBeginReadTransaction(Wal *pWal, int *);
71void sqlite3WalEndReadTransaction(Wal *pWal);
dan6700d022010-04-12 19:05:58 +000072
drh833bf962010-04-28 14:42:19 +000073/* Read a page from the write-ahead log, if it is present. */
danb6e099a2010-05-04 14:47:39 +000074int sqlite3WalRead(Wal *pWal, Pgno pgno, int *pInWal, int nOut, u8 *pOut);
drh833bf962010-04-28 14:42:19 +000075
dan763afe62010-08-03 06:42:39 +000076/* If the WAL is not empty, return the size of the database. */
77Pgno sqlite3WalDbsize(Wal *pWal);
dan6700d022010-04-12 19:05:58 +000078
79/* Obtain or release the WRITER lock. */
drh73b64e42010-05-30 19:55:15 +000080int sqlite3WalBeginWriteTransaction(Wal *pWal);
81int sqlite3WalEndWriteTransaction(Wal *pWal);
dan6700d022010-04-12 19:05:58 +000082
dan74d6cd82010-04-24 18:44:05 +000083/* Undo any frames written (but not committed) to the log */
drh7ed91f22010-04-29 22:34:07 +000084int sqlite3WalUndo(Wal *pWal, int (*xUndo)(void *, Pgno), void *pUndoCtx);
dan74d6cd82010-04-24 18:44:05 +000085
drh833bf962010-04-28 14:42:19 +000086/* Return an integer that records the current (uncommitted) write
87** position in the WAL */
dan71d89912010-05-24 13:57:42 +000088void sqlite3WalSavepoint(Wal *pWal, u32 *aWalData);
drh833bf962010-04-28 14:42:19 +000089
90/* Move the write position of the WAL back to iFrame. Called in
91** response to a ROLLBACK TO command. */
dan71d89912010-05-24 13:57:42 +000092int sqlite3WalSavepointUndo(Wal *pWal, u32 *aWalData);
dan4cd78b42010-04-26 16:57:10 +000093
danc5118782010-04-17 17:34:41 +000094/* Write a frame or frames to the log. */
drh7ed91f22010-04-29 22:34:07 +000095int sqlite3WalFrames(Wal *pWal, int, PgHdr *, Pgno, int, int);
dan6700d022010-04-12 19:05:58 +000096
97/* Copy pages from the log to the database file */
drhc438efd2010-04-26 00:19:45 +000098int sqlite3WalCheckpoint(
drh7ed91f22010-04-29 22:34:07 +000099 Wal *pWal, /* Write-ahead log connection */
dancdc1f042010-11-18 12:11:05 +0000100 int eMode, /* One of PASSIVE, FULL and RESTART */
dana58f26f2010-11-16 18:56:51 +0000101 int (*xBusy)(void*), /* Function to call when busy */
102 void *pBusyArg, /* Context argument for xBusyHandler */
danc5118782010-04-17 17:34:41 +0000103 int sync_flags, /* Flags to sync db file with (or 0) */
danb6e099a2010-05-04 14:47:39 +0000104 int nBuf, /* Size of buffer nBuf */
dancdc1f042010-11-18 12:11:05 +0000105 u8 *zBuf, /* Temporary buffer to use */
106 int *pnLog, /* OUT: Number of frames in WAL */
107 int *pnCkpt /* OUT: Number of backfilled frames in WAL */
dan6700d022010-04-12 19:05:58 +0000108);
109
drh833bf962010-04-28 14:42:19 +0000110/* Return the value to pass to a sqlite3_wal_hook callback, the
111** number of frames in the WAL at the point of the last commit since
112** sqlite3WalCallback() was called. If no commits have occurred since
113** the last call, then return 0.
114*/
drh7ed91f22010-04-29 22:34:07 +0000115int sqlite3WalCallback(Wal *pWal);
dan8d22a172010-04-19 18:03:51 +0000116
dan55437592010-05-11 12:19:26 +0000117/* Tell the wal layer that an EXCLUSIVE lock has been obtained (or released)
118** by the pager layer on the database file.
119*/
120int sqlite3WalExclusiveMode(Wal *pWal, int op);
121
dan8c408002010-11-01 17:38:24 +0000122/* Return true if the argument is non-NULL and the WAL module is using
123** heap-memory for the wal-index. Otherwise, if the argument is NULL or the
124** WAL module is using shared-memory, return false.
125*/
126int sqlite3WalHeapMemory(Wal *pWal);
127
drh70708602012-02-24 14:33:28 +0000128#ifdef SQLITE_ENABLE_ZIPVFS
danb3bdc722012-02-23 15:35:49 +0000129/* If the WAL file is not empty, return the number of bytes of content
130** stored in each frame (i.e. the db page-size when the WAL was created).
131*/
132int sqlite3WalFramesize(Wal *pWal);
drh70708602012-02-24 14:33:28 +0000133#endif
danb3bdc722012-02-23 15:35:49 +0000134
dan5cf53532010-05-01 16:40:20 +0000135#endif /* ifndef SQLITE_OMIT_WAL */
drhc438efd2010-04-26 00:19:45 +0000136#endif /* _WAL_H_ */