blob: 585ef2949794f910fdd15dcbb966b292147fa12a [file] [log] [blame]
drh960e8c62001-04-03 16:53:21 +00001/*
drhb19a2bc2001-09-16 00:13:26 +00002** 2001 September 15
drh960e8c62001-04-03 16:53:21 +00003**
drhb19a2bc2001-09-16 00:13:26 +00004** The author disclaims copyright to this source code. In place of
5** a legal notice, here is a blessing:
drh960e8c62001-04-03 16:53:21 +00006**
drhb19a2bc2001-09-16 00:13:26 +00007** 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.
drh960e8c62001-04-03 16:53:21 +000010**
11*************************************************************************
12** This header file defines the interface that the sqlite page cache
13** subsystem. The page cache subsystem reads and writes a file a page
14** at a time and provides a journal for rollback.
drh960e8c62001-04-03 16:53:21 +000015*/
drh960e8c62001-04-03 16:53:21 +000016
drh43f58d62016-07-09 16:14:45 +000017#ifndef SQLITE_PAGER_H
18#define SQLITE_PAGER_H
danielk197713f72992005-12-18 08:51:22 +000019
drh960e8c62001-04-03 16:53:21 +000020/*
danielk1977bea2a942009-01-20 17:06:27 +000021** Default maximum size for persistent journal files. A negative
22** value means no limit. This value may be overridden using the
23** sqlite3PagerJournalSizeLimit() API. See also "PRAGMA journal_size_limit".
danielk1977b53e4962008-06-04 06:45:59 +000024*/
25#ifndef SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT
26 #define SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT -1
27#endif
28
29/*
drh960e8c62001-04-03 16:53:21 +000030** The type used to represent a page number. The first page in a file
31** is called page 1. 0 is used to represent "not a page".
32*/
shane3615b532008-05-27 18:11:44 +000033typedef u32 Pgno;
drh960e8c62001-04-03 16:53:21 +000034
35/*
36** Each open file is managed by a separate instance of the "Pager" structure.
37*/
38typedef struct Pager Pager;
39
drh7bec5052005-02-06 02:45:41 +000040/*
danielk19773b8a05f2007-03-19 17:44:26 +000041** Handle type for pages.
42*/
43typedef struct PgHdr DbPage;
44
45/*
danielk1977bea2a942009-01-20 17:06:27 +000046** Page number PAGER_MJ_PGNO is never used in an SQLite database (it is
47** reserved for working around a windows/posix incompatibility). It is
48** used in the journal to signify that the remainder of the journal file
49** is devoted to storing a master journal name - there are no more pages to
50** roll back. See comments for function writeMasterJournal() in pager.c
51** for details.
52*/
53#define PAGER_MJ_PGNO(x) ((Pgno)((PENDING_BYTE/((x)->pageSize))+1))
54
55/*
danielk19773b8a05f2007-03-19 17:44:26 +000056** Allowed values for the flags parameter to sqlite3PagerOpen().
drh7bec5052005-02-06 02:45:41 +000057**
danielk1977bea2a942009-01-20 17:06:27 +000058** NOTE: These values must match the corresponding BTREE_ values in btree.h.
drh7bec5052005-02-06 02:45:41 +000059*/
60#define PAGER_OMIT_JOURNAL 0x0001 /* Do not use a rollback journal */
drh33f111d2012-01-17 15:29:14 +000061#define PAGER_MEMORY 0x0002 /* In-memory database */
drh7bec5052005-02-06 02:45:41 +000062
danielk197741483462007-03-24 16:45:04 +000063/*
64** Valid values for the second argument to sqlite3PagerLockingMode().
65*/
66#define PAGER_LOCKINGMODE_QUERY -1
67#define PAGER_LOCKINGMODE_NORMAL 0
68#define PAGER_LOCKINGMODE_EXCLUSIVE 1
drh90f5ecb2004-07-22 01:19:35 +000069
drh6446c4d2001-12-15 14:22:18 +000070/*
drh49711602016-04-14 16:40:13 +000071** Numeric constants that encode the journalmode.
72**
73** The numeric values encoded here (other than PAGER_JOURNALMODE_QUERY)
74** are exposed in the API via the "PRAGMA journal_mode" command and
75** therefore cannot be changed without a compatibility break.
drh3b020132008-04-17 17:02:01 +000076*/
drh0b9b4302010-06-11 17:01:24 +000077#define PAGER_JOURNALMODE_QUERY (-1) /* Query the value of journalmode */
drh3b020132008-04-17 17:02:01 +000078#define PAGER_JOURNALMODE_DELETE 0 /* Commit by deleting journal file */
79#define PAGER_JOURNALMODE_PERSIST 1 /* Commit by zeroing journal header */
80#define PAGER_JOURNALMODE_OFF 2 /* Journal omitted. */
drh04335882008-09-26 21:08:08 +000081#define PAGER_JOURNALMODE_TRUNCATE 3 /* Commit by truncating journal */
danielk1977b3175382008-10-17 18:51:52 +000082#define PAGER_JOURNALMODE_MEMORY 4 /* In-memory journal file */
dan7c246102010-04-12 19:00:29 +000083#define PAGER_JOURNALMODE_WAL 5 /* Use write-ahead logging */
drh3b020132008-04-17 17:02:01 +000084
85/*
drh9584f582015-11-04 20:22:37 +000086** Flags that make up the mask passed to sqlite3PagerGet().
dan11dcd112013-03-15 18:29:18 +000087*/
drhb00fc3b2013-08-21 23:42:32 +000088#define PAGER_GET_NOCONTENT 0x01 /* Do not load data from disk */
89#define PAGER_GET_READONLY 0x02 /* Read-only page is acceptable */
dan11dcd112013-03-15 18:29:18 +000090
91/*
drh40c39412013-08-16 20:42:20 +000092** Flags for sqlite3PagerSetFlags()
drh49711602016-04-14 16:40:13 +000093**
94** Value constraints (enforced via assert()):
95** PAGER_FULLFSYNC == SQLITE_FullFSync
96** PAGER_CKPT_FULLFSYNC == SQLITE_CkptFullFSync
97** PAGER_CACHE_SPILL == SQLITE_CacheSpill
drh40c39412013-08-16 20:42:20 +000098*/
99#define PAGER_SYNCHRONOUS_OFF 0x01 /* PRAGMA synchronous=OFF */
100#define PAGER_SYNCHRONOUS_NORMAL 0x02 /* PRAGMA synchronous=NORMAL */
101#define PAGER_SYNCHRONOUS_FULL 0x03 /* PRAGMA synchronous=FULL */
drh6841b1c2016-02-03 19:20:15 +0000102#define PAGER_SYNCHRONOUS_EXTRA 0x04 /* PRAGMA synchronous=EXTRA */
103#define PAGER_SYNCHRONOUS_MASK 0x07 /* Mask for four values above */
104#define PAGER_FULLFSYNC 0x08 /* PRAGMA fullfsync=ON */
105#define PAGER_CKPT_FULLFSYNC 0x10 /* PRAGMA checkpoint_fullfsync=ON */
106#define PAGER_CACHESPILL 0x20 /* PRAGMA cache_spill=ON */
107#define PAGER_FLAGS_MASK 0x38 /* All above except SYNCHRONOUS */
drh40c39412013-08-16 20:42:20 +0000108
109/*
danielk1977bea2a942009-01-20 17:06:27 +0000110** The remainder of this file contains the declarations of the functions
111** that make up the Pager sub-system API. See source code comments for
112** a detailed description of each routine.
drh6446c4d2001-12-15 14:22:18 +0000113*/
danielk1977bea2a942009-01-20 17:06:27 +0000114
115/* Open and close a Pager connection. */
drh4775ecd2009-07-24 19:01:19 +0000116int sqlite3PagerOpen(
117 sqlite3_vfs*,
118 Pager **ppPager,
119 const char*,
120 int,
121 int,
122 int,
123 void(*)(DbPage*)
124);
dan7fb89902016-08-12 16:21:15 +0000125int sqlite3PagerClose(Pager *pPager, sqlite3*);
danielk1977e1fd5082009-01-23 16:45:00 +0000126int sqlite3PagerReadFileheader(Pager*, int, unsigned char*);
danielk1977bea2a942009-01-20 17:06:27 +0000127
128/* Functions used to configure a Pager object. */
danielk19771ceedd32008-11-19 10:22:33 +0000129void sqlite3PagerSetBusyhandler(Pager*, int(*)(void *), void *);
drhb2eced52010-08-12 02:41:12 +0000130int sqlite3PagerSetPagesize(Pager*, u32*, int);
drh58cb6db2015-09-23 19:17:23 +0000131#ifdef SQLITE_HAS_CODEC
132void sqlite3PagerAlignReserve(Pager*,Pager*);
133#endif
drhf8e632b2007-05-08 14:51:36 +0000134int sqlite3PagerMaxPageCount(Pager*, int);
danielk19773b8a05f2007-03-19 17:44:26 +0000135void sqlite3PagerSetCachesize(Pager*, int);
drh9b0cf342015-11-12 14:57:19 +0000136int sqlite3PagerSetSpillsize(Pager*, int);
drh0d0614b2013-03-25 23:09:28 +0000137void sqlite3PagerSetMmapLimit(Pager *, sqlite3_int64);
drh09419b42011-11-16 19:29:17 +0000138void sqlite3PagerShrink(Pager*);
drh40c39412013-08-16 20:42:20 +0000139void sqlite3PagerSetFlags(Pager*,unsigned);
danielk1977bea2a942009-01-20 17:06:27 +0000140int sqlite3PagerLockingMode(Pager *, int);
drh0b9b4302010-06-11 17:01:24 +0000141int sqlite3PagerSetJournalMode(Pager *, int);
142int sqlite3PagerGetJournalMode(Pager*);
143int sqlite3PagerOkToChangeJournalMode(Pager*);
danielk1977bea2a942009-01-20 17:06:27 +0000144i64 sqlite3PagerJournalSizeLimit(Pager *, i64);
danielk197704103022009-02-03 16:51:24 +0000145sqlite3_backup **sqlite3PagerBackupPtr(Pager*);
dan6fa255f2015-10-28 19:46:57 +0000146int sqlite3PagerFlush(Pager*);
danielk1977bea2a942009-01-20 17:06:27 +0000147
148/* Functions used to obtain and release page references. */
drh9584f582015-11-04 20:22:37 +0000149int sqlite3PagerGet(Pager *pPager, Pgno pgno, DbPage **ppPage, int clrFlag);
danielk19773b8a05f2007-03-19 17:44:26 +0000150DbPage *sqlite3PagerLookup(Pager *pPager, Pgno pgno);
danielk1977bea2a942009-01-20 17:06:27 +0000151void sqlite3PagerRef(DbPage*);
152void sqlite3PagerUnref(DbPage*);
drhda8a3302013-12-13 19:35:21 +0000153void sqlite3PagerUnrefNotNull(DbPage*);
danielk1977bea2a942009-01-20 17:06:27 +0000154
155/* Operations on page references. */
danielk197745d68822009-01-16 16:23:38 +0000156int sqlite3PagerWrite(DbPage*);
danielk1977bea2a942009-01-20 17:06:27 +0000157void sqlite3PagerDontWrite(DbPage*);
158int sqlite3PagerMovepage(Pager*,DbPage*,Pgno,int);
159int sqlite3PagerPageRefcount(DbPage*);
160void *sqlite3PagerGetData(DbPage *);
161void *sqlite3PagerGetExtra(DbPage *);
162
163/* Functions used to manage pager transactions and savepoints. */
drh8fb8b532010-08-14 17:12:04 +0000164void sqlite3PagerPagecount(Pager*, int*);
danielk1977d8293352009-04-30 09:10:37 +0000165int sqlite3PagerBegin(Pager*, int exFlag, int);
drh49b9d332009-01-02 18:10:42 +0000166int sqlite3PagerCommitPhaseOne(Pager*,const char *zMaster, int);
drhabfb62f2010-07-30 11:20:35 +0000167int sqlite3PagerExclusiveLock(Pager*);
dan999cd082013-12-09 20:42:03 +0000168int sqlite3PagerSync(Pager *pPager, const char *zMaster);
drh80e35f42007-03-30 14:06:34 +0000169int sqlite3PagerCommitPhaseTwo(Pager*);
danielk19773b8a05f2007-03-19 17:44:26 +0000170int sqlite3PagerRollback(Pager*);
danielk1977bea2a942009-01-20 17:06:27 +0000171int sqlite3PagerOpenSavepoint(Pager *pPager, int n);
172int sqlite3PagerSavepoint(Pager *pPager, int op, int iSavepoint);
danielk197789bc4bc2009-07-21 19:25:24 +0000173int sqlite3PagerSharedLock(Pager *pPager);
dan8d22a172010-04-19 18:03:51 +0000174
dan06a2d822012-10-10 09:46:29 +0000175#ifndef SQLITE_OMIT_WAL
dan7fb89902016-08-12 16:21:15 +0000176 int sqlite3PagerCheckpoint(Pager *pPager, sqlite3*, int, int*, int*);
dan06a2d822012-10-10 09:46:29 +0000177 int sqlite3PagerWalSupported(Pager *pPager);
178 int sqlite3PagerWalCallback(Pager *pPager);
179 int sqlite3PagerOpenWal(Pager *pPager, int *pisOpen);
dan7fb89902016-08-12 16:21:15 +0000180 int sqlite3PagerCloseWal(Pager *pPager, sqlite3*);
drhd930b5c2017-01-26 02:26:02 +0000181# ifdef SQLITE_DIRECT_OVERFLOW_READ
182 int sqlite3PagerUseWal(Pager *pPager, Pgno);
183# endif
danfc1acf32015-12-05 20:51:54 +0000184# ifdef SQLITE_ENABLE_SNAPSHOT
185 int sqlite3PagerSnapshotGet(Pager *pPager, sqlite3_snapshot **ppSnapshot);
186 int sqlite3PagerSnapshotOpen(Pager *pPager, sqlite3_snapshot *pSnapshot);
dan11584982016-11-18 20:49:43 +0000187 int sqlite3PagerSnapshotRecover(Pager *pPager);
danfc1acf32015-12-05 20:51:54 +0000188# endif
dane24452e2016-10-21 10:49:39 +0000189#else
drhd930b5c2017-01-26 02:26:02 +0000190# define sqlite3PagerUseWal(x,y) 0
dan06a2d822012-10-10 09:46:29 +0000191#endif
192
drh70708602012-02-24 14:33:28 +0000193#ifdef SQLITE_ENABLE_ZIPVFS
194 int sqlite3PagerWalFramesize(Pager *pPager);
195#endif
danb3bdc722012-02-23 15:35:49 +0000196
danielk1977bea2a942009-01-20 17:06:27 +0000197/* Functions used to query pager state and configuration. */
drhf49661a2008-12-10 16:45:50 +0000198u8 sqlite3PagerIsreadonly(Pager*);
drh91618562014-12-19 19:28:02 +0000199u32 sqlite3PagerDataVersion(Pager*);
drhe05b3f82015-07-01 17:53:49 +0000200#ifdef SQLITE_DEBUG
201 int sqlite3PagerRefcount(Pager*);
202#endif
drh63da0892010-03-10 21:42:07 +0000203int sqlite3PagerMemUsed(Pager*);
drhd4e0bb02012-05-27 01:19:04 +0000204const char *sqlite3PagerFilename(Pager*, int);
drh790f2872015-11-28 18:06:36 +0000205sqlite3_vfs *sqlite3PagerVfs(Pager*);
drhcc6bb3e2007-08-31 16:11:35 +0000206sqlite3_file *sqlite3PagerFile(Pager*);
drh21d61852016-01-08 02:27:01 +0000207sqlite3_file *sqlite3PagerJrnlFile(Pager*);
danielk19773b8a05f2007-03-19 17:44:26 +0000208const char *sqlite3PagerJournalname(Pager*);
drh26b79942007-11-28 16:19:56 +0000209void *sqlite3PagerTempSpace(Pager*);
danielk197704103022009-02-03 16:51:24 +0000210int sqlite3PagerIsMemdb(Pager*);
dan58ca31c2011-09-22 14:41:16 +0000211void sqlite3PagerCacheStat(Pager *, int, int, int *);
dan43c1ce32016-08-05 16:16:26 +0000212void sqlite3PagerClearCache(Pager*);
danc9a53262012-10-01 06:50:55 +0000213int sqlite3SectorSize(sqlite3_file *);
drhdd793422001-06-28 01:54:48 +0000214
danielk197764beba42009-01-31 14:54:06 +0000215/* Functions used to truncate the database file. */
216void sqlite3PagerTruncateImage(Pager*,Pgno);
dan99bd1092013-03-22 18:20:14 +0000217
dane6593d82014-10-24 16:40:49 +0000218void sqlite3PagerRekey(DbPage*, Pgno, u16);
dan33ea4862014-10-09 19:35:37 +0000219
dan47ee3862010-06-22 15:18:44 +0000220#if defined(SQLITE_HAS_CODEC) && !defined(SQLITE_OMIT_WAL)
221void *sqlite3PagerCodec(DbPage *);
dan47ee3862010-06-22 15:18:44 +0000222#endif
223
danielk1977bea2a942009-01-20 17:06:27 +0000224/* Functions to support testing and debugging. */
drh87cc3b32007-05-08 21:45:27 +0000225#if !defined(NDEBUG) || defined(SQLITE_TEST)
226 Pgno sqlite3PagerPagenumber(DbPage*);
227 int sqlite3PagerIswriteable(DbPage*);
228#endif
drhdd793422001-06-28 01:54:48 +0000229#ifdef SQLITE_TEST
drh87cc3b32007-05-08 21:45:27 +0000230 int *sqlite3PagerStats(Pager*);
231 void sqlite3PagerRefdump(Pager*);
danielk1977bea2a942009-01-20 17:06:27 +0000232 void disable_simulated_io_errors(void);
233 void enable_simulated_io_errors(void);
danielk1977979f38e2007-03-27 16:19:51 +0000234#else
235# define disable_simulated_io_errors()
236# define enable_simulated_io_errors()
237#endif
238
drh43f58d62016-07-09 16:14:45 +0000239#endif /* SQLITE_PAGER_H */