1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
|
/* This file is automatically generated from wc-test-queries.sql and subversion/tests/libsvn_wc/token-map.h.
* Do not edit this file -- edit the source and rerun gen-make.py */
#define STMT_SELECT_NODES_INFO 0
#define STMT_0_INFO {"STMT_SELECT_NODES_INFO", NULL}
#define STMT_0 \
"SELECT op_depth, n.presence, n.local_relpath, revision, " \
" repos_path, file_external, def_local_relpath, moved_to, moved_here, " \
" properties " \
"FROM nodes n " \
"LEFT OUTER JOIN externals e " \
" ON n.wc_id = e.wc_id " \
" AND n.local_relpath = e.local_relpath " \
"WHERE n.wc_id = ?1 " \
" AND (n.local_relpath = ?2 OR (((n.local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((n.local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
""
#define STMT_SELECT_ACTUAL_INFO 1
#define STMT_1_INFO {"STMT_SELECT_ACTUAL_INFO", NULL}
#define STMT_1 \
"SELECT local_relpath " \
"FROM actual_node " \
"WHERE wc_id = ?1 " \
" AND conflict_data is NOT NULL " \
" AND (local_relpath = ?2 OR (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \
""
#define STMT_DELETE_NODES 2
#define STMT_2_INFO {"STMT_DELETE_NODES", NULL}
#define STMT_2 \
"DELETE FROM nodes; " \
""
#define STMT_INSERT_NODE 3
#define STMT_3_INFO {"STMT_INSERT_NODE", NULL}
#define STMT_3 \
"INSERT INTO nodes (local_relpath, op_depth, presence, repos_path, " \
" revision, parent_relpath, moved_to, moved_here, " \
" properties, wc_id, repos_id, kind, " \
" depth) " \
" VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, 1, " \
" CASE WHEN ?3 != 'base-deleted' THEN 1 END, " \
" 'dir', " \
" CASE WHEN ?3 in ('normal', 'incomplete') " \
" THEN 'infinity' END) " \
""
#define STMT_DELETE_ACTUAL 4
#define STMT_4_INFO {"STMT_DELETE_ACTUAL", NULL}
#define STMT_4 \
"DELETE FROM actual_node; " \
""
#define STMT_INSERT_ACTUAL 5
#define STMT_5_INFO {"STMT_INSERT_ACTUAL", NULL}
#define STMT_5 \
"INSERT INTO actual_node (local_relpath, parent_relpath, changelist, wc_id) " \
" VALUES (?1, ?2, ?3, 1) " \
""
#define STMT_ENSURE_EMPTY_PRISTINE 6
#define STMT_6_INFO {"STMT_ENSURE_EMPTY_PRISTINE", NULL}
#define STMT_6 \
"INSERT OR IGNORE INTO pristine (checksum, md5_checksum, size, refcount) " \
" VALUES ('$sha1$da39a3ee5e6b4b0d3255bfef95601890afd80709', " \
" '$md5 $d41d8cd98f00b204e9800998ecf8427e', " \
" 0, 0) " \
""
#define STMT_NODES_SET_FILE 7
#define STMT_7_INFO {"STMT_NODES_SET_FILE", NULL}
#define STMT_7 \
"UPDATE nodes " \
" SET kind = 'file', " \
" checksum = '$sha1$da39a3ee5e6b4b0d3255bfef95601890afd80709', " \
" depth = NULL " \
"WHERE wc_id = 1 and local_relpath = ?1 " \
""
#define STMT_SELECT_ALL_ACTUAL 8
#define STMT_8_INFO {"STMT_SELECT_ALL_ACTUAL", NULL}
#define STMT_8 \
"SELECT local_relpath FROM actual_node WHERE wc_id = 1 " \
""
#define WC_TEST_QUERIES_SQL_DECLARE_STATEMENTS(varname) \
static const char * const varname[] = { \
STMT_0, \
STMT_1, \
STMT_2, \
STMT_3, \
STMT_4, \
STMT_5, \
STMT_6, \
STMT_7, \
STMT_8, \
NULL \
}
#define WC_TEST_QUERIES_SQL_DECLARE_STATEMENT_INFO(varname) \
static const char * const varname[][2] = { \
STMT_0_INFO, \
STMT_1_INFO, \
STMT_2_INFO, \
STMT_3_INFO, \
STMT_4_INFO, \
STMT_5_INFO, \
STMT_6_INFO, \
STMT_7_INFO, \
STMT_8_INFO, \
{NULL, NULL} \
}
|
