dan | 6700d02 | 2010-04-12 19:05:58 +0000 | [diff] [blame] | 1 | /* |
| 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 | |
drh | c438efd | 2010-04-26 00:19:45 +0000 | [diff] [blame] | 17 | #ifndef _WAL_H_ |
| 18 | #define _WAL_H_ |
dan | 6700d02 | 2010-04-12 19:05:58 +0000 | [diff] [blame] | 19 | |
| 20 | #include "sqliteInt.h" |
| 21 | |
dan | 0420b74 | 2011-12-30 10:54:24 +0000 | [diff] [blame] | 22 | /* 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 | |
dan | 5cf5353 | 2010-05-01 16:40:20 +0000 | [diff] [blame] | 28 | #ifdef SQLITE_OMIT_WAL |
dan | cdc1f04 | 2010-11-18 12:11:05 +0000 | [diff] [blame] | 29 | # define sqlite3WalOpen(x,y,z) 0 |
drh | 85a8375 | 2011-05-16 21:00:27 +0000 | [diff] [blame] | 30 | # define sqlite3WalLimit(x,y) |
dan | cdc1f04 | 2010-11-18 12:11:05 +0000 | [diff] [blame] | 31 | # define sqlite3WalClose(w,x,y,z) 0 |
| 32 | # define sqlite3WalBeginReadTransaction(y,z) 0 |
drh | 73b64e4 | 2010-05-30 19:55:15 +0000 | [diff] [blame] | 33 | # define sqlite3WalEndReadTransaction(z) |
dan | cdc1f04 | 2010-11-18 12:11:05 +0000 | [diff] [blame] | 34 | # 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 |
dan | 71d8991 | 2010-05-24 13:57:42 +0000 | [diff] [blame] | 39 | # define sqlite3WalSavepoint(y,z) |
dan | cdc1f04 | 2010-11-18 12:11:05 +0000 | [diff] [blame] | 40 | # 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 |
dan | b3bdc72 | 2012-02-23 15:35:49 +0000 | [diff] [blame] | 46 | # define sqlite3WalFramesize(z) 0 |
dan | 5cf5353 | 2010-05-01 16:40:20 +0000 | [diff] [blame] | 47 | #else |
| 48 | |
dan | 6e6bd56 | 2010-06-02 18:59:03 +0000 | [diff] [blame] | 49 | #define WAL_SAVEPOINT_NDATA 4 |
dan | 71d8991 | 2010-05-24 13:57:42 +0000 | [diff] [blame] | 50 | |
drh | 833bf96 | 2010-04-28 14:42:19 +0000 | [diff] [blame] | 51 | /* Connection to a write-ahead log (WAL) file. |
| 52 | ** There is one object of this type for each pager. |
| 53 | */ |
drh | 7ed91f2 | 2010-04-29 22:34:07 +0000 | [diff] [blame] | 54 | typedef struct Wal Wal; |
dan | 6700d02 | 2010-04-12 19:05:58 +0000 | [diff] [blame] | 55 | |
drh | 833bf96 | 2010-04-28 14:42:19 +0000 | [diff] [blame] | 56 | /* Open and close a connection to a write-ahead log. */ |
drh | 85a8375 | 2011-05-16 21:00:27 +0000 | [diff] [blame] | 57 | int sqlite3WalOpen(sqlite3_vfs*, sqlite3_file*, const char *, int, i64, Wal**); |
drh | d9e5c4f | 2010-05-12 18:01:39 +0000 | [diff] [blame] | 58 | int sqlite3WalClose(Wal *pWal, int sync_flags, int, u8 *); |
dan | 6700d02 | 2010-04-12 19:05:58 +0000 | [diff] [blame] | 59 | |
drh | 85a8375 | 2011-05-16 21:00:27 +0000 | [diff] [blame] | 60 | /* Set the limiting size of a WAL file. */ |
| 61 | void sqlite3WalLimit(Wal*, i64); |
| 62 | |
drh | 833bf96 | 2010-04-28 14:42:19 +0000 | [diff] [blame] | 63 | /* 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 | */ |
drh | 73b64e4 | 2010-05-30 19:55:15 +0000 | [diff] [blame] | 70 | int sqlite3WalBeginReadTransaction(Wal *pWal, int *); |
| 71 | void sqlite3WalEndReadTransaction(Wal *pWal); |
dan | 6700d02 | 2010-04-12 19:05:58 +0000 | [diff] [blame] | 72 | |
drh | 833bf96 | 2010-04-28 14:42:19 +0000 | [diff] [blame] | 73 | /* Read a page from the write-ahead log, if it is present. */ |
dan | b6e099a | 2010-05-04 14:47:39 +0000 | [diff] [blame] | 74 | int sqlite3WalRead(Wal *pWal, Pgno pgno, int *pInWal, int nOut, u8 *pOut); |
drh | 833bf96 | 2010-04-28 14:42:19 +0000 | [diff] [blame] | 75 | |
dan | 763afe6 | 2010-08-03 06:42:39 +0000 | [diff] [blame] | 76 | /* If the WAL is not empty, return the size of the database. */ |
| 77 | Pgno sqlite3WalDbsize(Wal *pWal); |
dan | 6700d02 | 2010-04-12 19:05:58 +0000 | [diff] [blame] | 78 | |
| 79 | /* Obtain or release the WRITER lock. */ |
drh | 73b64e4 | 2010-05-30 19:55:15 +0000 | [diff] [blame] | 80 | int sqlite3WalBeginWriteTransaction(Wal *pWal); |
| 81 | int sqlite3WalEndWriteTransaction(Wal *pWal); |
dan | 6700d02 | 2010-04-12 19:05:58 +0000 | [diff] [blame] | 82 | |
dan | 74d6cd8 | 2010-04-24 18:44:05 +0000 | [diff] [blame] | 83 | /* Undo any frames written (but not committed) to the log */ |
drh | 7ed91f2 | 2010-04-29 22:34:07 +0000 | [diff] [blame] | 84 | int sqlite3WalUndo(Wal *pWal, int (*xUndo)(void *, Pgno), void *pUndoCtx); |
dan | 74d6cd8 | 2010-04-24 18:44:05 +0000 | [diff] [blame] | 85 | |
drh | 833bf96 | 2010-04-28 14:42:19 +0000 | [diff] [blame] | 86 | /* Return an integer that records the current (uncommitted) write |
| 87 | ** position in the WAL */ |
dan | 71d8991 | 2010-05-24 13:57:42 +0000 | [diff] [blame] | 88 | void sqlite3WalSavepoint(Wal *pWal, u32 *aWalData); |
drh | 833bf96 | 2010-04-28 14:42:19 +0000 | [diff] [blame] | 89 | |
| 90 | /* Move the write position of the WAL back to iFrame. Called in |
| 91 | ** response to a ROLLBACK TO command. */ |
dan | 71d8991 | 2010-05-24 13:57:42 +0000 | [diff] [blame] | 92 | int sqlite3WalSavepointUndo(Wal *pWal, u32 *aWalData); |
dan | 4cd78b4 | 2010-04-26 16:57:10 +0000 | [diff] [blame] | 93 | |
dan | c511878 | 2010-04-17 17:34:41 +0000 | [diff] [blame] | 94 | /* Write a frame or frames to the log. */ |
drh | 7ed91f2 | 2010-04-29 22:34:07 +0000 | [diff] [blame] | 95 | int sqlite3WalFrames(Wal *pWal, int, PgHdr *, Pgno, int, int); |
dan | 6700d02 | 2010-04-12 19:05:58 +0000 | [diff] [blame] | 96 | |
| 97 | /* Copy pages from the log to the database file */ |
drh | c438efd | 2010-04-26 00:19:45 +0000 | [diff] [blame] | 98 | int sqlite3WalCheckpoint( |
drh | 7ed91f2 | 2010-04-29 22:34:07 +0000 | [diff] [blame] | 99 | Wal *pWal, /* Write-ahead log connection */ |
dan | cdc1f04 | 2010-11-18 12:11:05 +0000 | [diff] [blame] | 100 | int eMode, /* One of PASSIVE, FULL and RESTART */ |
dan | a58f26f | 2010-11-16 18:56:51 +0000 | [diff] [blame] | 101 | int (*xBusy)(void*), /* Function to call when busy */ |
| 102 | void *pBusyArg, /* Context argument for xBusyHandler */ |
dan | c511878 | 2010-04-17 17:34:41 +0000 | [diff] [blame] | 103 | int sync_flags, /* Flags to sync db file with (or 0) */ |
dan | b6e099a | 2010-05-04 14:47:39 +0000 | [diff] [blame] | 104 | int nBuf, /* Size of buffer nBuf */ |
dan | cdc1f04 | 2010-11-18 12:11:05 +0000 | [diff] [blame] | 105 | 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 */ |
dan | 6700d02 | 2010-04-12 19:05:58 +0000 | [diff] [blame] | 108 | ); |
| 109 | |
drh | 833bf96 | 2010-04-28 14:42:19 +0000 | [diff] [blame] | 110 | /* 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 | */ |
drh | 7ed91f2 | 2010-04-29 22:34:07 +0000 | [diff] [blame] | 115 | int sqlite3WalCallback(Wal *pWal); |
dan | 8d22a17 | 2010-04-19 18:03:51 +0000 | [diff] [blame] | 116 | |
dan | 5543759 | 2010-05-11 12:19:26 +0000 | [diff] [blame] | 117 | /* Tell the wal layer that an EXCLUSIVE lock has been obtained (or released) |
| 118 | ** by the pager layer on the database file. |
| 119 | */ |
| 120 | int sqlite3WalExclusiveMode(Wal *pWal, int op); |
| 121 | |
dan | 8c40800 | 2010-11-01 17:38:24 +0000 | [diff] [blame] | 122 | /* 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 | */ |
| 126 | int sqlite3WalHeapMemory(Wal *pWal); |
| 127 | |
drh | 7070860 | 2012-02-24 14:33:28 +0000 | [diff] [blame] | 128 | #ifdef SQLITE_ENABLE_ZIPVFS |
dan | b3bdc72 | 2012-02-23 15:35:49 +0000 | [diff] [blame] | 129 | /* 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 | */ |
| 132 | int sqlite3WalFramesize(Wal *pWal); |
drh | 7070860 | 2012-02-24 14:33:28 +0000 | [diff] [blame] | 133 | #endif |
dan | b3bdc72 | 2012-02-23 15:35:49 +0000 | [diff] [blame] | 134 | |
dan | 5cf5353 | 2010-05-01 16:40:20 +0000 | [diff] [blame] | 135 | #endif /* ifndef SQLITE_OMIT_WAL */ |
drh | c438efd | 2010-04-26 00:19:45 +0000 | [diff] [blame] | 136 | #endif /* _WAL_H_ */ |