1289166Speter/* This file is automatically generated from rep-cache-db.sql and .dist_sandbox/subversion-1.8.14/subversion/libsvn_fs_fs/token-map.h.
2251881Speter * Do not edit this file -- edit the source and rerun gen-make.py */
3251881Speter
4251881Speter#define STMT_CREATE_SCHEMA 0
5251881Speter#define STMT_0_INFO {"STMT_CREATE_SCHEMA", NULL}
6251881Speter#define STMT_0 \
7251881Speter  "CREATE TABLE rep_cache ( " \
8251881Speter  "  hash TEXT NOT NULL PRIMARY KEY, " \
9251881Speter  "  revision INTEGER NOT NULL, " \
10251881Speter  "  offset INTEGER NOT NULL, " \
11251881Speter  "  size INTEGER NOT NULL, " \
12251881Speter  "  expanded_size INTEGER NOT NULL " \
13251881Speter  "  ); " \
14251881Speter  "PRAGMA USER_VERSION = 1; " \
15251881Speter  ""
16251881Speter
17251881Speter#define STMT_GET_REP 1
18251881Speter#define STMT_1_INFO {"STMT_GET_REP", NULL}
19251881Speter#define STMT_1 \
20251881Speter  "SELECT revision, offset, size, expanded_size " \
21251881Speter  "FROM rep_cache " \
22251881Speter  "WHERE hash = ?1 " \
23251881Speter  ""
24251881Speter
25251881Speter#define STMT_SET_REP 2
26251881Speter#define STMT_2_INFO {"STMT_SET_REP", NULL}
27251881Speter#define STMT_2 \
28251881Speter  "INSERT OR FAIL INTO rep_cache (hash, revision, offset, size, expanded_size) " \
29251881Speter  "VALUES (?1, ?2, ?3, ?4, ?5) " \
30251881Speter  ""
31251881Speter
32251881Speter#define STMT_GET_REPS_FOR_RANGE 3
33251881Speter#define STMT_3_INFO {"STMT_GET_REPS_FOR_RANGE", NULL}
34251881Speter#define STMT_3 \
35251881Speter  "SELECT hash, revision, offset, size, expanded_size " \
36251881Speter  "FROM rep_cache " \
37251881Speter  "WHERE revision >= ?1 AND revision <= ?2 " \
38251881Speter  ""
39251881Speter
40251881Speter#define STMT_GET_MAX_REV 4
41251881Speter#define STMT_4_INFO {"STMT_GET_MAX_REV", NULL}
42251881Speter#define STMT_4 \
43251881Speter  "SELECT MAX(revision) " \
44251881Speter  "FROM rep_cache " \
45251881Speter  ""
46251881Speter
47251881Speter#define STMT_DEL_REPS_YOUNGER_THAN_REV 5
48251881Speter#define STMT_5_INFO {"STMT_DEL_REPS_YOUNGER_THAN_REV", NULL}
49251881Speter#define STMT_5 \
50251881Speter  "DELETE FROM rep_cache " \
51251881Speter  "WHERE revision > ?1 " \
52251881Speter  ""
53251881Speter
54251881Speter#define STMT_LOCK_REP 6
55251881Speter#define STMT_6_INFO {"STMT_LOCK_REP", NULL}
56251881Speter#define STMT_6 \
57251881Speter  "BEGIN TRANSACTION; " \
58251881Speter  "INSERT INTO rep_cache VALUES ('dummy', 0, 0, 0, 0) " \
59251881Speter  ""
60251881Speter
61251881Speter#define REP_CACHE_DB_SQL_DECLARE_STATEMENTS(varname) \
62251881Speter  static const char * const varname[] = { \
63251881Speter    STMT_0, \
64251881Speter    STMT_1, \
65251881Speter    STMT_2, \
66251881Speter    STMT_3, \
67251881Speter    STMT_4, \
68251881Speter    STMT_5, \
69251881Speter    STMT_6, \
70251881Speter    NULL \
71251881Speter  }
72251881Speter
73251881Speter#define REP_CACHE_DB_SQL_DECLARE_STATEMENT_INFO(varname) \
74251881Speter  static const char * const varname[][2] = { \
75251881Speter    STMT_0_INFO, \
76251881Speter    STMT_1_INFO, \
77251881Speter    STMT_2_INFO, \
78251881Speter    STMT_3_INFO, \
79251881Speter    STMT_4_INFO, \
80251881Speter    STMT_5_INFO, \
81251881Speter    STMT_6_INFO, \
82251881Speter    {NULL, NULL} \
83251881Speter  }
84