Ensure that sqlite3AuthRead() is only call for TK_COLUMN and TK_TRIGGER
[sqlite.git] / src / pager.h
blob730e366fbb09c01ec3c26a03c30f978174de1a2f
1 /*
2 ** 2001 September 15
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.
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.
17 #ifndef SQLITE_PAGER_H
18 #define SQLITE_PAGER_H
21 ** 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".
25 #ifndef SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT
26 #define SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT -1
27 #endif
30 ** 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".
33 typedef u32 Pgno;
36 ** Each open file is managed by a separate instance of the "Pager" structure.
38 typedef struct Pager Pager;
41 ** Handle type for pages.
43 typedef struct PgHdr DbPage;
46 ** 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.
53 #define PAGER_MJ_PGNO(x) ((Pgno)((PENDING_BYTE/((x)->pageSize))+1))
56 ** Allowed values for the flags parameter to sqlite3PagerOpen().
58 ** NOTE: These values must match the corresponding BTREE_ values in btree.h.
60 #define PAGER_OMIT_JOURNAL 0x0001 /* Do not use a rollback journal */
61 #define PAGER_MEMORY 0x0002 /* In-memory database */
64 ** Valid values for the second argument to sqlite3PagerLockingMode().
66 #define PAGER_LOCKINGMODE_QUERY -1
67 #define PAGER_LOCKINGMODE_NORMAL 0
68 #define PAGER_LOCKINGMODE_EXCLUSIVE 1
71 ** Numeric constants that encode the journalmode.
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.
77 #define PAGER_JOURNALMODE_QUERY (-1) /* Query the value of journalmode */
78 #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. */
81 #define PAGER_JOURNALMODE_TRUNCATE 3 /* Commit by truncating journal */
82 #define PAGER_JOURNALMODE_MEMORY 4 /* In-memory journal file */
83 #define PAGER_JOURNALMODE_WAL 5 /* Use write-ahead logging */
86 ** Flags that make up the mask passed to sqlite3PagerGet().
88 #define PAGER_GET_NOCONTENT 0x01 /* Do not load data from disk */
89 #define PAGER_GET_READONLY 0x02 /* Read-only page is acceptable */
92 ** Flags for sqlite3PagerSetFlags()
94 ** Value constraints (enforced via assert()):
95 ** PAGER_FULLFSYNC == SQLITE_FullFSync
96 ** PAGER_CKPT_FULLFSYNC == SQLITE_CkptFullFSync
97 ** PAGER_CACHE_SPILL == SQLITE_CacheSpill
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 */
102 #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 */
110 ** 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.
115 /* Open and close a Pager connection. */
116 int sqlite3PagerOpen(
117 sqlite3_vfs*,
118 Pager **ppPager,
119 const char*,
120 int,
121 int,
122 int,
123 void(*)(DbPage*)
125 int sqlite3PagerClose(Pager *pPager, sqlite3*);
126 int sqlite3PagerReadFileheader(Pager*, int, unsigned char*);
128 /* Functions used to configure a Pager object. */
129 void sqlite3PagerSetBusyHandler(Pager*, int(*)(void *), void *);
130 int sqlite3PagerSetPagesize(Pager*, u32*, int);
131 #ifdef SQLITE_HAS_CODEC
132 void sqlite3PagerAlignReserve(Pager*,Pager*);
133 #endif
134 int sqlite3PagerMaxPageCount(Pager*, int);
135 void sqlite3PagerSetCachesize(Pager*, int);
136 int sqlite3PagerSetSpillsize(Pager*, int);
137 void sqlite3PagerSetMmapLimit(Pager *, sqlite3_int64);
138 void sqlite3PagerShrink(Pager*);
139 void sqlite3PagerSetFlags(Pager*,unsigned);
140 int sqlite3PagerLockingMode(Pager *, int);
141 int sqlite3PagerSetJournalMode(Pager *, int);
142 int sqlite3PagerGetJournalMode(Pager*);
143 int sqlite3PagerOkToChangeJournalMode(Pager*);
144 i64 sqlite3PagerJournalSizeLimit(Pager *, i64);
145 sqlite3_backup **sqlite3PagerBackupPtr(Pager*);
146 int sqlite3PagerFlush(Pager*);
148 /* Functions used to obtain and release page references. */
149 int sqlite3PagerGet(Pager *pPager, Pgno pgno, DbPage **ppPage, int clrFlag);
150 DbPage *sqlite3PagerLookup(Pager *pPager, Pgno pgno);
151 void sqlite3PagerRef(DbPage*);
152 void sqlite3PagerUnref(DbPage*);
153 void sqlite3PagerUnrefNotNull(DbPage*);
154 void sqlite3PagerUnrefPageOne(DbPage*);
156 /* Operations on page references. */
157 int sqlite3PagerWrite(DbPage*);
158 void sqlite3PagerDontWrite(DbPage*);
159 int sqlite3PagerMovepage(Pager*,DbPage*,Pgno,int);
160 int sqlite3PagerPageRefcount(DbPage*);
161 void *sqlite3PagerGetData(DbPage *);
162 void *sqlite3PagerGetExtra(DbPage *);
164 /* Functions used to manage pager transactions and savepoints. */
165 void sqlite3PagerPagecount(Pager*, int*);
166 int sqlite3PagerBegin(Pager*, int exFlag, int);
167 int sqlite3PagerCommitPhaseOne(Pager*,const char *zMaster, int);
168 int sqlite3PagerExclusiveLock(Pager*);
169 int sqlite3PagerSync(Pager *pPager, const char *zMaster);
170 int sqlite3PagerCommitPhaseTwo(Pager*);
171 int sqlite3PagerRollback(Pager*);
172 int sqlite3PagerOpenSavepoint(Pager *pPager, int n);
173 int sqlite3PagerSavepoint(Pager *pPager, int op, int iSavepoint);
174 int sqlite3PagerSharedLock(Pager *pPager);
176 #ifndef SQLITE_OMIT_WAL
177 int sqlite3PagerCheckpoint(Pager *pPager, sqlite3*, int, int*, int*);
178 int sqlite3PagerWalSupported(Pager *pPager);
179 int sqlite3PagerWalCallback(Pager *pPager);
180 int sqlite3PagerOpenWal(Pager *pPager, int *pisOpen);
181 int sqlite3PagerCloseWal(Pager *pPager, sqlite3*);
182 # ifdef SQLITE_DIRECT_OVERFLOW_READ
183 int sqlite3PagerUseWal(Pager *pPager, Pgno);
184 # endif
185 # ifdef SQLITE_ENABLE_SNAPSHOT
186 int sqlite3PagerSnapshotGet(Pager *pPager, sqlite3_snapshot **ppSnapshot);
187 int sqlite3PagerSnapshotOpen(Pager *pPager, sqlite3_snapshot *pSnapshot);
188 int sqlite3PagerSnapshotRecover(Pager *pPager);
189 # endif
190 #else
191 # define sqlite3PagerUseWal(x,y) 0
192 #endif
194 #ifdef SQLITE_ENABLE_ZIPVFS
195 int sqlite3PagerWalFramesize(Pager *pPager);
196 #endif
198 /* Functions used to query pager state and configuration. */
199 u8 sqlite3PagerIsreadonly(Pager*);
200 u32 sqlite3PagerDataVersion(Pager*);
201 #ifdef SQLITE_DEBUG
202 int sqlite3PagerRefcount(Pager*);
203 #endif
204 int sqlite3PagerMemUsed(Pager*);
205 const char *sqlite3PagerFilename(Pager*, int);
206 sqlite3_vfs *sqlite3PagerVfs(Pager*);
207 sqlite3_file *sqlite3PagerFile(Pager*);
208 sqlite3_file *sqlite3PagerJrnlFile(Pager*);
209 const char *sqlite3PagerJournalname(Pager*);
210 void *sqlite3PagerTempSpace(Pager*);
211 int sqlite3PagerIsMemdb(Pager*);
212 void sqlite3PagerCacheStat(Pager *, int, int, int *);
213 void sqlite3PagerClearCache(Pager*);
214 int sqlite3SectorSize(sqlite3_file *);
215 #ifdef SQLITE_ENABLE_SETLK_TIMEOUT
216 void sqlite3PagerResetLockTimeout(Pager *pPager);
217 #else
218 # define sqlite3PagerResetLockTimeout(X)
219 #endif
221 /* Functions used to truncate the database file. */
222 void sqlite3PagerTruncateImage(Pager*,Pgno);
224 void sqlite3PagerRekey(DbPage*, Pgno, u16);
226 #if defined(SQLITE_HAS_CODEC) && !defined(SQLITE_OMIT_WAL)
227 void *sqlite3PagerCodec(DbPage *);
228 #endif
230 /* Functions to support testing and debugging. */
231 #if !defined(NDEBUG) || defined(SQLITE_TEST)
232 Pgno sqlite3PagerPagenumber(DbPage*);
233 int sqlite3PagerIswriteable(DbPage*);
234 #endif
235 #ifdef SQLITE_TEST
236 int *sqlite3PagerStats(Pager*);
237 void sqlite3PagerRefdump(Pager*);
238 void disable_simulated_io_errors(void);
239 void enable_simulated_io_errors(void);
240 #else
241 # define disable_simulated_io_errors()
242 # define enable_simulated_io_errors()
243 #endif
245 #endif /* SQLITE_PAGER_H */