rep-cache-db.h revision 362181 
1/* This file is automatically generated from rep-cache-db.sql and token-map.h.
2 * Do not edit this file -- edit the source and rerun gen-make.py */
3
4#define STMT_CREATE_SCHEMA_V1 0
5#define STMT_0_INFO {"STMT_CREATE_SCHEMA_V1", NULL}
6#define STMT_0 \
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 " \
13  "  ); " \
14  "PRAGMA USER_VERSION = 1; " \
15  ""
16
17#define STMT_CREATE_SCHEMA_V2 1
18#define STMT_1_INFO {"STMT_CREATE_SCHEMA_V2", NULL}
19#define STMT_1 \
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; " \
28  ""
29
30#define STMT_GET_REP 2
31#define STMT_2_INFO {"STMT_GET_REP", NULL}
32#define STMT_2 \
33  "SELECT revision, offset, size, expanded_size " \
34  "FROM rep_cache " \
35  "WHERE hash = ?1 " \
36  ""
37
38#define STMT_SET_REP 3
39#define STMT_3_INFO {"STMT_SET_REP", NULL}
40#define STMT_3 \
41  "INSERT OR IGNORE INTO rep_cache (hash, revision, offset, size, expanded_size) " \
42  "VALUES (?1, ?2, ?3, ?4, ?5) " \
43  ""
44
45#define STMT_GET_REPS_FOR_RANGE 4
46#define STMT_4_INFO {"STMT_GET_REPS_FOR_RANGE", NULL}
47#define STMT_4 \
48  "SELECT hash, revision, offset, size, expanded_size " \
49  "FROM rep_cache " \
50  "WHERE revision >= ?1 AND revision <= ?2 " \
51  ""
52
53#define STMT_GET_MAX_REV 5
54#define STMT_5_INFO {"STMT_GET_MAX_REV", NULL}
55#define STMT_5 \
56  "SELECT MAX(revision) " \
57  "FROM rep_cache " \
58  ""
59
60#define STMT_DEL_REPS_YOUNGER_THAN_REV 6
61#define STMT_6_INFO {"STMT_DEL_REPS_YOUNGER_THAN_REV", NULL}
62#define STMT_6 \
63  "DELETE FROM rep_cache " \
64  "WHERE revision > ?1 " \
65  ""
66
67#define STMT_LOCK_REP 7
68#define STMT_7_INFO {"STMT_LOCK_REP", NULL}
69#define STMT_7 \
70  "BEGIN TRANSACTION; " \
71  "INSERT INTO rep_cache VALUES ('dummy', 0, 0, 0, 0) " \
72  ""
73
74#define STMT_UNLOCK_REP 8
75#define STMT_8_INFO {"STMT_UNLOCK_REP", NULL}
76#define STMT_8 \
77  "ROLLBACK TRANSACTION; " \
78  ""
79
80#define REP_CACHE_DB_SQL_DECLARE_STATEMENTS(varname) \
81  static const char * const varname[] = { \
82    STMT_0, \
83    STMT_1, \
84    STMT_2, \
85    STMT_3, \
86    STMT_4, \
87    STMT_5, \
88    STMT_6, \
89    STMT_7, \
90    STMT_8, \
91    NULL \
92  }
93
94#define REP_CACHE_DB_SQL_DECLARE_STATEMENT_INFO(varname) \
95  static const char * const varname[][2] = { \
96    STMT_0_INFO, \
97    STMT_1_INFO, \
98    STMT_2_INFO, \
99    STMT_3_INFO, \
100    STMT_4_INFO, \
101    STMT_5_INFO, \
102    STMT_6_INFO, \
103    STMT_7_INFO, \
104    STMT_8_INFO, \
105    {NULL, NULL} \
106  }
107