1 /* This file is automatically generated from rep-cache-db.sql and subversion/libsvn_fs_fs/token-map.h.
2 * Do not edit this file -- edit the source and rerun gen-make.py */
4 #define STMT_CREATE_SCHEMA_V1 0
5 #define STMT_0_INFO {"STMT_CREATE_SCHEMA_V1", NULL}
7 "CREATE TABLE rep_cache ( " \
8 " hash TEXT NOT NULL PRIMARY KEY, " \
9 " revision INTEGER NOT NULL, " \
10 " offset INTEGER NOT NULL, " \
11 " size INTEGER NOT NULL, " \
12 " expanded_size INTEGER NOT NULL " \
14 "PRAGMA USER_VERSION = 1; " \
17 #define STMT_CREATE_SCHEMA_V2 1
18 #define STMT_1_INFO {"STMT_CREATE_SCHEMA_V2", NULL}
20 "CREATE TABLE rep_cache ( " \
21 " hash TEXT NOT NULL PRIMARY KEY, " \
22 " revision INTEGER NOT NULL, " \
23 " offset INTEGER NOT NULL, " \
24 " size INTEGER NOT NULL, " \
25 " expanded_size INTEGER NOT NULL " \
26 " ) WITHOUT ROWID; " \
27 "PRAGMA USER_VERSION = 2; " \
30 #define STMT_GET_REP 2
31 #define STMT_2_INFO {"STMT_GET_REP", NULL}
33 "SELECT revision, offset, size, expanded_size " \
38 #define STMT_SET_REP 3
39 #define STMT_3_INFO {"STMT_SET_REP", NULL}
41 "INSERT OR FAIL INTO rep_cache (hash, revision, offset, size, expanded_size) " \
42 "VALUES (?1, ?2, ?3, ?4, ?5) " \
45 #define STMT_GET_REPS_FOR_RANGE 4
46 #define STMT_4_INFO {"STMT_GET_REPS_FOR_RANGE", NULL}
48 "SELECT hash, revision, offset, size, expanded_size " \
50 "WHERE revision >= ?1 AND revision <= ?2 " \
53 #define STMT_GET_MAX_REV 5
54 #define STMT_5_INFO {"STMT_GET_MAX_REV", NULL}
56 "SELECT MAX(revision) " \
60 #define STMT_DEL_REPS_YOUNGER_THAN_REV 6
61 #define STMT_6_INFO {"STMT_DEL_REPS_YOUNGER_THAN_REV", NULL}
63 "DELETE FROM rep_cache " \
64 "WHERE revision > ?1 " \
67 #define STMT_LOCK_REP 7
68 #define STMT_7_INFO {"STMT_LOCK_REP", NULL}
70 "BEGIN TRANSACTION; " \
71 "INSERT INTO rep_cache VALUES ('dummy', 0, 0, 0, 0) " \
74 #define STMT_UNLOCK_REP 8
75 #define STMT_8_INFO {"STMT_UNLOCK_REP", NULL}
77 "ROLLBACK TRANSACTION; " \
80 #define REP_CACHE_DB_SQL_DECLARE_STATEMENTS(varname) \
81 static const char * const varname[] = { \
94 #define REP_CACHE_DB_SQL_DECLARE_STATEMENT_INFO(varname) \
95 static const char * const varname[][2] = { \