wc-checks.h revision 269847 
1/* This file is automatically generated from wc-checks.sql and .dist_sandbox/subversion-1.8.10/subversion/libsvn_wc/token-map.h.
2 * Do not edit this file -- edit the source and rerun gen-make.py */
3
4#define STMT_VERIFICATION_TRIGGERS 0
5#define STMT_0_INFO {"STMT_VERIFICATION_TRIGGERS", NULL}
6#define STMT_0 \
7  "CREATE TEMPORARY TRIGGER no_repository_updates BEFORE UPDATE ON repository " \
8  "BEGIN " \
9  "  SELECT RAISE(FAIL, 'Updates to REPOSITORY are not allowed.'); " \
10  "END; " \
11  "CREATE TEMPORARY TRIGGER validation_01 BEFORE INSERT ON nodes " \
12  "WHEN NOT ((new.local_relpath = '' AND new.parent_relpath IS NULL) " \
13  "          OR (relpath_depth(new.local_relpath) " \
14  "              = relpath_depth(new.parent_relpath) + 1)) " \
15  "BEGIN " \
16  "  SELECT RAISE(FAIL, 'WC DB validity check 01 failed'); " \
17  "END; " \
18  "CREATE TEMPORARY TRIGGER validation_02 BEFORE INSERT ON nodes " \
19  "WHEN NOT new.op_depth <= relpath_depth(new.local_relpath) " \
20  "BEGIN " \
21  "  SELECT RAISE(FAIL, 'WC DB validity check 02 failed'); " \
22  "END; " \
23  "CREATE TEMPORARY TRIGGER validation_03 BEFORE INSERT ON nodes " \
24  "WHEN NOT ( " \
25  "    (new.op_depth = relpath_depth(new.local_relpath)) " \
26  "    OR " \
27  "    (EXISTS (SELECT 1 FROM nodes " \
28  "              WHERE wc_id = new.wc_id AND op_depth = new.op_depth " \
29  "                AND local_relpath = new.parent_relpath)) " \
30  "  ) " \
31  " AND NOT (new.file_external IS NOT NULL AND new.op_depth = 0) " \
32  "BEGIN " \
33  "  SELECT RAISE(FAIL, 'WC DB validity check 03 failed'); " \
34  "END; " \
35  "CREATE TEMPORARY TRIGGER validation_04 BEFORE INSERT ON actual_node " \
36  "WHEN NOT (new.local_relpath = '' " \
37  "          OR EXISTS (SELECT 1 FROM nodes " \
38  "                       WHERE wc_id = new.wc_id " \
39  "                         AND local_relpath = new.parent_relpath)) " \
40  "BEGIN " \
41  "  SELECT RAISE(FAIL, 'WC DB validity check 04 failed'); " \
42  "END; " \
43  ""
44
45#define WC_CHECKS_SQL_DECLARE_STATEMENTS(varname) \
46  static const char * const varname[] = { \
47    STMT_0, \
48    NULL \
49  }
50
51#define WC_CHECKS_SQL_DECLARE_STATEMENT_INFO(varname) \
52  static const char * const varname[][2] = { \
53    STMT_0_INFO, \
54    {NULL, NULL} \
55  }
56