diff options
Diffstat (limited to 'subversion/libsvn_wc/wc-queries.h')
| -rw-r--r-- | subversion/libsvn_wc/wc-queries.h | 1268 |
1 files changed, 650 insertions, 618 deletions
diff --git a/subversion/libsvn_wc/wc-queries.h b/subversion/libsvn_wc/wc-queries.h index b333e95ffdbe4..b6254e1a5bcad 100644 --- a/subversion/libsvn_wc/wc-queries.h +++ b/subversion/libsvn_wc/wc-queries.h @@ -1,4 +1,4 @@ -/* This file is automatically generated from wc-queries.sql and subversion/libsvn_wc/token-map.h. +/* This file is automatically generated from wc-queries.sql and token-map.h. * Do not edit this file -- edit the source and rerun gen-make.py */ #define STMT_SELECT_NODE_INFO 0 @@ -115,17 +115,31 @@ "LIMIT 1 " \ "" -#define STMT_SELECT_ACTUAL_NODE 10 -#define STMT_10_INFO {"STMT_SELECT_ACTUAL_NODE", NULL} +#define STMT_SELECT_PRESENT_HIGHEST_WORKING_NODES_BY_BASENAME_AND_KIND 10 +#define STMT_10_INFO {"STMT_SELECT_PRESENT_HIGHEST_WORKING_NODES_BY_BASENAME_AND_KIND", NULL} #define STMT_10 \ + "SELECT presence, local_relpath " \ + "FROM nodes n " \ + "WHERE wc_id = ?1 AND local_relpath = (CASE WHEN (parent_relpath) = '' THEN (?2) WHEN (?2) = '' THEN (parent_relpath) ELSE (parent_relpath) || '/' || (?2) END) " \ + " AND kind = ?3 " \ + " AND presence in ('normal', 'incomplete') " \ + " AND op_depth = (SELECT MAX(op_depth) " \ + " FROM NODES w " \ + " WHERE w.wc_id = ?1 " \ + " AND w.local_relpath = n.local_relpath) " \ + "" + +#define STMT_SELECT_ACTUAL_NODE 11 +#define STMT_11_INFO {"STMT_SELECT_ACTUAL_NODE", NULL} +#define STMT_11 \ "SELECT changelist, properties, conflict_data " \ "FROM actual_node " \ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ "" -#define STMT_SELECT_NODE_CHILDREN_INFO 11 -#define STMT_11_INFO {"STMT_SELECT_NODE_CHILDREN_INFO", NULL} -#define STMT_11 \ +#define STMT_SELECT_NODE_CHILDREN_INFO 12 +#define STMT_12_INFO {"STMT_SELECT_NODE_CHILDREN_INFO", NULL} +#define STMT_12 \ "SELECT op_depth, nodes.repos_id, nodes.repos_path, presence, kind, revision, " \ " checksum, translated_size, changed_revision, changed_date, changed_author, " \ " depth, symlink_target, last_mod_time, properties, lock_token, lock_owner, " \ @@ -137,9 +151,9 @@ "ORDER BY local_relpath DESC, op_depth DESC " \ "" -#define STMT_SELECT_BASE_NODE_CHILDREN_INFO 12 -#define STMT_12_INFO {"STMT_SELECT_BASE_NODE_CHILDREN_INFO", NULL} -#define STMT_12 \ +#define STMT_SELECT_BASE_NODE_CHILDREN_INFO 13 +#define STMT_13_INFO {"STMT_SELECT_BASE_NODE_CHILDREN_INFO", NULL} +#define STMT_13 \ "SELECT op_depth, nodes.repos_id, nodes.repos_path, presence, kind, revision, " \ " checksum, translated_size, changed_revision, changed_date, changed_author, " \ " depth, symlink_target, last_mod_time, properties, lock_token, lock_owner, " \ @@ -151,50 +165,50 @@ "ORDER BY local_relpath DESC " \ "" -#define STMT_SELECT_NODE_CHILDREN_WALKER_INFO 13 -#define STMT_13_INFO {"STMT_SELECT_NODE_CHILDREN_WALKER_INFO", NULL} -#define STMT_13 \ +#define STMT_SELECT_NODE_CHILDREN_WALKER_INFO 14 +#define STMT_14_INFO {"STMT_SELECT_NODE_CHILDREN_WALKER_INFO", NULL} +#define STMT_14 \ "SELECT local_relpath, op_depth, presence, kind " \ "FROM nodes_current " \ "WHERE wc_id = ?1 AND parent_relpath = ?2 " \ "ORDER BY local_relpath " \ "" -#define STMT_SELECT_ACTUAL_CHILDREN_INFO 14 -#define STMT_14_INFO {"STMT_SELECT_ACTUAL_CHILDREN_INFO", NULL} -#define STMT_14 \ +#define STMT_SELECT_ACTUAL_CHILDREN_INFO 15 +#define STMT_15_INFO {"STMT_SELECT_ACTUAL_CHILDREN_INFO", NULL} +#define STMT_15 \ "SELECT local_relpath, changelist, properties, conflict_data " \ "FROM actual_node " \ "WHERE wc_id = ?1 AND parent_relpath = ?2 " \ "" -#define STMT_SELECT_REPOSITORY_BY_ID 15 -#define STMT_15_INFO {"STMT_SELECT_REPOSITORY_BY_ID", NULL} -#define STMT_15 \ +#define STMT_SELECT_REPOSITORY_BY_ID 16 +#define STMT_16_INFO {"STMT_SELECT_REPOSITORY_BY_ID", NULL} +#define STMT_16 \ "SELECT root, uuid FROM repository WHERE id = ?1 " \ "" -#define STMT_SELECT_WCROOT_NULL 16 -#define STMT_16_INFO {"STMT_SELECT_WCROOT_NULL", NULL} -#define STMT_16 \ +#define STMT_SELECT_WCROOT_NULL 17 +#define STMT_17_INFO {"STMT_SELECT_WCROOT_NULL", NULL} +#define STMT_17 \ "SELECT id FROM wcroot WHERE local_abspath IS NULL " \ "" -#define STMT_SELECT_REPOSITORY 17 -#define STMT_17_INFO {"STMT_SELECT_REPOSITORY", NULL} -#define STMT_17 \ +#define STMT_SELECT_REPOSITORY 18 +#define STMT_18_INFO {"STMT_SELECT_REPOSITORY", NULL} +#define STMT_18 \ "SELECT id FROM repository WHERE root = ?1 " \ "" -#define STMT_INSERT_REPOSITORY 18 -#define STMT_18_INFO {"STMT_INSERT_REPOSITORY", NULL} -#define STMT_18 \ +#define STMT_INSERT_REPOSITORY 19 +#define STMT_19_INFO {"STMT_INSERT_REPOSITORY", NULL} +#define STMT_19 \ "INSERT INTO repository (root, uuid) VALUES (?1, ?2) " \ "" -#define STMT_INSERT_NODE 19 -#define STMT_19_INFO {"STMT_INSERT_NODE", NULL} -#define STMT_19 \ +#define STMT_INSERT_NODE 20 +#define STMT_20_INFO {"STMT_INSERT_NODE", NULL} +#define STMT_20 \ "INSERT OR REPLACE INTO nodes ( " \ " wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, " \ " revision, presence, depth, kind, changed_revision, changed_date, " \ @@ -205,9 +219,9 @@ " ?15, ?16, ?17, ?18, ?19, ?20, ?21, ?22, ?23) " \ "" -#define STMT_SELECT_WORKING_PRESENT 20 -#define STMT_20_INFO {"STMT_SELECT_WORKING_PRESENT", NULL} -#define STMT_20 \ +#define STMT_SELECT_WORKING_PRESENT 21 +#define STMT_21_INFO {"STMT_SELECT_WORKING_PRESENT", NULL} +#define STMT_21 \ "SELECT local_relpath, kind, checksum, translated_size, last_mod_time " \ "FROM nodes n " \ "WHERE wc_id = ?1 " \ @@ -220,25 +234,25 @@ "ORDER BY local_relpath DESC " \ "" -#define STMT_DELETE_NODE_RECURSIVE 21 -#define STMT_21_INFO {"STMT_DELETE_NODE_RECURSIVE", NULL} -#define STMT_21 \ +#define STMT_DELETE_NODE_RECURSIVE 22 +#define STMT_22_INFO {"STMT_DELETE_NODE_RECURSIVE", NULL} +#define STMT_22 \ "DELETE FROM NODES " \ "WHERE wc_id = ?1 " \ " AND (((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_NODE 22 -#define STMT_22_INFO {"STMT_DELETE_NODE", NULL} -#define STMT_22 \ +#define STMT_DELETE_NODE 23 +#define STMT_23_INFO {"STMT_DELETE_NODE", NULL} +#define STMT_23 \ "DELETE " \ "FROM NODES " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \ "" -#define STMT_DELETE_ACTUAL_FOR_BASE_RECURSIVE 23 -#define STMT_23_INFO {"STMT_DELETE_ACTUAL_FOR_BASE_RECURSIVE", NULL} -#define STMT_23 \ +#define STMT_DELETE_ACTUAL_FOR_BASE_RECURSIVE 24 +#define STMT_24_INFO {"STMT_DELETE_ACTUAL_FOR_BASE_RECURSIVE", NULL} +#define STMT_24 \ "DELETE FROM actual_node " \ "WHERE wc_id = ?1 AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ " AND EXISTS(SELECT 1 FROM NODES b " \ @@ -252,9 +266,9 @@ " AND presence in ('normal', 'incomplete', 'not-present')) " \ "" -#define STMT_DELETE_WORKING_BASE_DELETE 24 -#define STMT_24_INFO {"STMT_DELETE_WORKING_BASE_DELETE", NULL} -#define STMT_24 \ +#define STMT_DELETE_WORKING_BASE_DELETE 25 +#define STMT_25_INFO {"STMT_DELETE_WORKING_BASE_DELETE", NULL} +#define STMT_25 \ "DELETE FROM nodes " \ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ " AND presence = 'base-deleted' " \ @@ -265,9 +279,9 @@ " AND op_depth > ?3) " \ "" -#define STMT_DELETE_WORKING_BASE_DELETE_RECURSIVE 25 -#define STMT_25_INFO {"STMT_DELETE_WORKING_BASE_DELETE_RECURSIVE", NULL} -#define STMT_25 \ +#define STMT_DELETE_WORKING_BASE_DELETE_RECURSIVE 26 +#define STMT_26_INFO {"STMT_DELETE_WORKING_BASE_DELETE_RECURSIVE", NULL} +#define STMT_26 \ "DELETE FROM nodes " \ "WHERE wc_id = ?1 AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ " AND presence = 'base-deleted' " \ @@ -278,35 +292,35 @@ " AND op_depth > ?3) " \ "" -#define STMT_DELETE_WORKING_RECURSIVE 26 -#define STMT_26_INFO {"STMT_DELETE_WORKING_RECURSIVE", NULL} -#define STMT_26 \ +#define STMT_DELETE_WORKING_RECURSIVE 27 +#define STMT_27_INFO {"STMT_DELETE_WORKING_RECURSIVE", NULL} +#define STMT_27 \ "DELETE FROM nodes " \ "WHERE wc_id = ?1 AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ " AND op_depth > 0 " \ "" -#define STMT_DELETE_BASE_RECURSIVE 27 -#define STMT_27_INFO {"STMT_DELETE_BASE_RECURSIVE", NULL} -#define STMT_27 \ +#define STMT_DELETE_BASE_RECURSIVE 28 +#define STMT_28_INFO {"STMT_DELETE_BASE_RECURSIVE", NULL} +#define STMT_28 \ "DELETE FROM nodes " \ "WHERE wc_id = ?1 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))) " \ " AND op_depth = 0 " \ "" -#define STMT_DELETE_WORKING_OP_DEPTH 28 -#define STMT_28_INFO {"STMT_DELETE_WORKING_OP_DEPTH", NULL} -#define STMT_28 \ +#define STMT_DELETE_WORKING_OP_DEPTH 29 +#define STMT_29_INFO {"STMT_DELETE_WORKING_OP_DEPTH", NULL} +#define STMT_29 \ "DELETE FROM nodes " \ "WHERE wc_id = ?1 " \ " 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))) " \ " AND op_depth = ?3 " \ "" -#define STMT_SELECT_LAYER_FOR_REPLACE 29 -#define STMT_29_INFO {"STMT_SELECT_LAYER_FOR_REPLACE", NULL} -#define STMT_29 \ +#define STMT_SELECT_LAYER_FOR_REPLACE 30 +#define STMT_30_INFO {"STMT_SELECT_LAYER_FOR_REPLACE", NULL} +#define STMT_30 \ "SELECT s.local_relpath, s.kind, " \ " (CASE WHEN (?2) = '' THEN (CASE WHEN (?4) = '' THEN (s.local_relpath) WHEN (s.local_relpath) = '' THEN (?4) ELSE (?4) || '/' || (s.local_relpath) END) WHEN (?4) = '' THEN (CASE WHEN (?2) = '' THEN (s.local_relpath) WHEN SUBSTR((s.local_relpath), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(s.local_relpath) THEN '' WHEN SUBSTR((s.local_relpath), LENGTH(?2)+1, 1) = '/' THEN SUBSTR((s.local_relpath), LENGTH(?2)+2) END END) WHEN SUBSTR((s.local_relpath), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(s.local_relpath) THEN (?4) WHEN SUBSTR((s.local_relpath), LENGTH(?2)+1, 1) = '/' THEN (?4) || SUBSTR((s.local_relpath), LENGTH(?2)+1) END END) drp, 'normal' " \ "FROM nodes s " \ @@ -323,9 +337,9 @@ "ORDER BY s.local_relpath " \ "" -#define STMT_SELECT_DESCENDANTS_OP_DEPTH_RV 30 -#define STMT_30_INFO {"STMT_SELECT_DESCENDANTS_OP_DEPTH_RV", NULL} -#define STMT_30 \ +#define STMT_SELECT_DESCENDANTS_OP_DEPTH_RV 31 +#define STMT_31_INFO {"STMT_SELECT_DESCENDANTS_OP_DEPTH_RV", NULL} +#define STMT_31 \ "SELECT local_relpath, kind " \ "FROM nodes " \ "WHERE wc_id = ?1 " \ @@ -335,9 +349,9 @@ "ORDER BY local_relpath DESC " \ "" -#define STMT_COPY_NODE_MOVE 31 -#define STMT_31_INFO {"STMT_COPY_NODE_MOVE", NULL} -#define STMT_31 \ +#define STMT_COPY_NODE_MOVE 32 +#define STMT_32_INFO {"STMT_COPY_NODE_MOVE", NULL} +#define STMT_32 \ "INSERT OR REPLACE INTO nodes ( " \ " wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, " \ " revision, presence, depth, kind, changed_revision, changed_date, " \ @@ -356,9 +370,9 @@ "WHERE s.wc_id = ?1 AND s.local_relpath = ?2 AND s.op_depth = ?3 " \ "" -#define STMT_SELECT_NO_LONGER_MOVED_RV 32 -#define STMT_32_INFO {"STMT_SELECT_NO_LONGER_MOVED_RV", NULL} -#define STMT_32 \ +#define STMT_SELECT_NO_LONGER_MOVED_RV 33 +#define STMT_33_INFO {"STMT_SELECT_NO_LONGER_MOVED_RV", NULL} +#define STMT_33 \ "SELECT d.local_relpath, (CASE WHEN (?2) = '' THEN (CASE WHEN (?4) = '' THEN (d.local_relpath) WHEN (d.local_relpath) = '' THEN (?4) ELSE (?4) || '/' || (d.local_relpath) END) WHEN (?4) = '' THEN (CASE WHEN (?2) = '' THEN (d.local_relpath) WHEN SUBSTR((d.local_relpath), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(d.local_relpath) THEN '' WHEN SUBSTR((d.local_relpath), LENGTH(?2)+1, 1) = '/' THEN SUBSTR((d.local_relpath), LENGTH(?2)+2) END END) WHEN SUBSTR((d.local_relpath), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(d.local_relpath) THEN (?4) WHEN SUBSTR((d.local_relpath), LENGTH(?2)+1, 1) = '/' THEN (?4) || SUBSTR((d.local_relpath), LENGTH(?2)+1) END END) srp, " \ " b.presence, b.op_depth " \ "FROM nodes d " \ @@ -377,9 +391,9 @@ "ORDER BY d.local_relpath DESC " \ "" -#define STMT_SELECT_OP_DEPTH_CHILDREN 33 -#define STMT_33_INFO {"STMT_SELECT_OP_DEPTH_CHILDREN", NULL} -#define STMT_33 \ +#define STMT_SELECT_OP_DEPTH_CHILDREN 34 +#define STMT_34_INFO {"STMT_SELECT_OP_DEPTH_CHILDREN", NULL} +#define STMT_34 \ "SELECT local_relpath, kind FROM nodes " \ "WHERE wc_id = ?1 " \ " AND parent_relpath = ?2 " \ @@ -389,9 +403,9 @@ "ORDER BY local_relpath " \ "" -#define STMT_SELECT_OP_DEPTH_CHILDREN_EXISTS 34 -#define STMT_34_INFO {"STMT_SELECT_OP_DEPTH_CHILDREN_EXISTS", NULL} -#define STMT_34 \ +#define STMT_SELECT_OP_DEPTH_CHILDREN_EXISTS 35 +#define STMT_35_INFO {"STMT_SELECT_OP_DEPTH_CHILDREN_EXISTS", NULL} +#define STMT_35 \ "SELECT local_relpath, kind FROM nodes " \ "WHERE wc_id = ?1 " \ " AND parent_relpath = ?2 " \ @@ -400,9 +414,9 @@ "ORDER BY local_relpath " \ "" -#define STMT_SELECT_GE_OP_DEPTH_CHILDREN 35 -#define STMT_35_INFO {"STMT_SELECT_GE_OP_DEPTH_CHILDREN", NULL} -#define STMT_35 \ +#define STMT_SELECT_GE_OP_DEPTH_CHILDREN 36 +#define STMT_36_INFO {"STMT_SELECT_GE_OP_DEPTH_CHILDREN", NULL} +#define STMT_36 \ "SELECT 1 FROM nodes " \ "WHERE wc_id = ?1 AND parent_relpath = ?2 " \ " AND (op_depth > ?3 OR (op_depth = ?3 " \ @@ -414,9 +428,9 @@ " WHERE wc_id = ?1 AND n.local_relpath = a.local_relpath) " \ "" -#define STMT_DELETE_SHADOWED_RECURSIVE 36 -#define STMT_36_INFO {"STMT_DELETE_SHADOWED_RECURSIVE", NULL} -#define STMT_36 \ +#define STMT_DELETE_SHADOWED_RECURSIVE 37 +#define STMT_37_INFO {"STMT_DELETE_SHADOWED_RECURSIVE", NULL} +#define STMT_37 \ "DELETE FROM nodes " \ "WHERE wc_id = ?1 " \ " AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ @@ -424,26 +438,26 @@ " OR (op_depth = ?3 AND presence = 'base-deleted')) " \ "" -#define STMT_CLEAR_MOVED_TO_FROM_DEST 37 -#define STMT_37_INFO {"STMT_CLEAR_MOVED_TO_FROM_DEST", NULL} -#define STMT_37 \ +#define STMT_CLEAR_MOVED_TO_FROM_DEST 38 +#define STMT_38_INFO {"STMT_CLEAR_MOVED_TO_FROM_DEST", NULL} +#define STMT_38 \ "UPDATE NODES SET moved_to = NULL " \ "WHERE wc_id = ?1 " \ " AND moved_to = ?2 " \ "" -#define STMT_SELECT_NOT_PRESENT_DESCENDANTS 38 -#define STMT_38_INFO {"STMT_SELECT_NOT_PRESENT_DESCENDANTS", NULL} -#define STMT_38 \ +#define STMT_SELECT_NOT_PRESENT_DESCENDANTS 39 +#define STMT_39_INFO {"STMT_SELECT_NOT_PRESENT_DESCENDANTS", NULL} +#define STMT_39 \ "SELECT local_relpath FROM nodes " \ "WHERE wc_id = ?1 AND op_depth = ?3 " \ " AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ " AND presence = 'not-present' " \ "" -#define STMT_COMMIT_DESCENDANTS_TO_BASE 39 -#define STMT_39_INFO {"STMT_COMMIT_DESCENDANTS_TO_BASE", NULL} -#define STMT_39 \ +#define STMT_COMMIT_DESCENDANTS_TO_BASE 40 +#define STMT_40_INFO {"STMT_COMMIT_DESCENDANTS_TO_BASE", NULL} +#define STMT_40 \ "UPDATE NODES SET op_depth = 0, " \ " repos_id = ?4, " \ " repos_path = (CASE WHEN (?2) = '' THEN (CASE WHEN (?5) = '' THEN (local_relpath) WHEN (local_relpath) = '' THEN (?5) ELSE (?5) || '/' || (local_relpath) END) WHEN (?5) = '' THEN (CASE WHEN (?2) = '' THEN (local_relpath) WHEN SUBSTR((local_relpath), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(local_relpath) THEN '' WHEN SUBSTR((local_relpath), LENGTH(?2)+1, 1) = '/' THEN SUBSTR((local_relpath), LENGTH(?2)+2) END END) WHEN SUBSTR((local_relpath), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(local_relpath) THEN (?5) WHEN SUBSTR((local_relpath), LENGTH(?2)+1, 1) = '/' THEN (?5) || SUBSTR((local_relpath), LENGTH(?2)+1) END END), " \ @@ -461,17 +475,17 @@ " AND op_depth = ?3 " \ "" -#define STMT_SELECT_NODE_CHILDREN 40 -#define STMT_40_INFO {"STMT_SELECT_NODE_CHILDREN", NULL} -#define STMT_40 \ +#define STMT_SELECT_NODE_CHILDREN 41 +#define STMT_41_INFO {"STMT_SELECT_NODE_CHILDREN", NULL} +#define STMT_41 \ "SELECT DISTINCT local_relpath FROM nodes " \ "WHERE wc_id = ?1 AND parent_relpath = ?2 " \ "ORDER BY local_relpath " \ "" -#define STMT_SELECT_WORKING_CHILDREN 41 -#define STMT_41_INFO {"STMT_SELECT_WORKING_CHILDREN", NULL} -#define STMT_41 \ +#define STMT_SELECT_WORKING_CHILDREN 42 +#define STMT_42_INFO {"STMT_SELECT_WORKING_CHILDREN", NULL} +#define STMT_42 \ "SELECT DISTINCT local_relpath FROM nodes " \ "WHERE wc_id = ?1 AND parent_relpath = ?2 " \ " AND (op_depth > (SELECT MAX(op_depth) FROM nodes " \ @@ -483,56 +497,56 @@ "ORDER BY local_relpath " \ "" -#define STMT_SELECT_BASE_NOT_PRESENT_CHILDREN 42 -#define STMT_42_INFO {"STMT_SELECT_BASE_NOT_PRESENT_CHILDREN", NULL} -#define STMT_42 \ +#define STMT_SELECT_BASE_NOT_PRESENT_CHILDREN 43 +#define STMT_43_INFO {"STMT_SELECT_BASE_NOT_PRESENT_CHILDREN", NULL} +#define STMT_43 \ "SELECT local_relpath FROM nodes " \ "WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = 0 " \ " AND presence = 'not-present' " \ "ORDER BY local_relpath " \ "" -#define STMT_SELECT_NODE_PROPS 43 -#define STMT_43_INFO {"STMT_SELECT_NODE_PROPS", NULL} -#define STMT_43 \ +#define STMT_SELECT_NODE_PROPS 44 +#define STMT_44_INFO {"STMT_SELECT_NODE_PROPS", NULL} +#define STMT_44 \ "SELECT properties, presence FROM nodes " \ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ "ORDER BY op_depth DESC " \ "" -#define STMT_SELECT_ACTUAL_PROPS 44 -#define STMT_44_INFO {"STMT_SELECT_ACTUAL_PROPS", NULL} -#define STMT_44 \ +#define STMT_SELECT_ACTUAL_PROPS 45 +#define STMT_45_INFO {"STMT_SELECT_ACTUAL_PROPS", NULL} +#define STMT_45 \ "SELECT properties FROM actual_node " \ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ "" -#define STMT_UPDATE_ACTUAL_PROPS 45 -#define STMT_45_INFO {"STMT_UPDATE_ACTUAL_PROPS", NULL} -#define STMT_45 \ +#define STMT_UPDATE_ACTUAL_PROPS 46 +#define STMT_46_INFO {"STMT_UPDATE_ACTUAL_PROPS", NULL} +#define STMT_46 \ "UPDATE actual_node SET properties = ?3 " \ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ "" -#define STMT_INSERT_ACTUAL_PROPS 46 -#define STMT_46_INFO {"STMT_INSERT_ACTUAL_PROPS", NULL} -#define STMT_46 \ +#define STMT_INSERT_ACTUAL_PROPS 47 +#define STMT_47_INFO {"STMT_INSERT_ACTUAL_PROPS", NULL} +#define STMT_47 \ "INSERT INTO actual_node (wc_id, local_relpath, parent_relpath, properties) " \ "VALUES (?1, ?2, ?3, ?4) " \ "" -#define STMT_INSERT_LOCK 47 -#define STMT_47_INFO {"STMT_INSERT_LOCK", NULL} -#define STMT_47 \ +#define STMT_INSERT_LOCK 48 +#define STMT_48_INFO {"STMT_INSERT_LOCK", NULL} +#define STMT_48 \ "INSERT OR REPLACE INTO lock " \ "(repos_id, repos_relpath, lock_token, lock_owner, lock_comment, " \ " lock_date) " \ "VALUES (?1, ?2, ?3, ?4, ?5, ?6) " \ "" -#define STMT_SELECT_BASE_NODE_LOCK_TOKENS_RECURSIVE 48 -#define STMT_48_INFO {"STMT_SELECT_BASE_NODE_LOCK_TOKENS_RECURSIVE", NULL} -#define STMT_48 \ +#define STMT_SELECT_BASE_NODE_LOCK_TOKENS_RECURSIVE 49 +#define STMT_49_INFO {"STMT_SELECT_BASE_NODE_LOCK_TOKENS_RECURSIVE", NULL} +#define STMT_49 \ "SELECT nodes.repos_id, nodes.repos_path, lock_token " \ "FROM nodes " \ "LEFT JOIN lock ON nodes.repos_id = lock.repos_id " \ @@ -541,30 +555,30 @@ " AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ "" -#define STMT_INSERT_WCROOT 49 -#define STMT_49_INFO {"STMT_INSERT_WCROOT", NULL} -#define STMT_49 \ +#define STMT_INSERT_WCROOT 50 +#define STMT_50_INFO {"STMT_INSERT_WCROOT", NULL} +#define STMT_50 \ "INSERT INTO wcroot (local_abspath) " \ "VALUES (?1) " \ "" -#define STMT_UPDATE_BASE_NODE_DAV_CACHE 50 -#define STMT_50_INFO {"STMT_UPDATE_BASE_NODE_DAV_CACHE", NULL} -#define STMT_50 \ +#define STMT_UPDATE_BASE_NODE_DAV_CACHE 51 +#define STMT_51_INFO {"STMT_UPDATE_BASE_NODE_DAV_CACHE", NULL} +#define STMT_51 \ "UPDATE nodes SET dav_cache = ?3 " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \ "" -#define STMT_SELECT_BASE_DAV_CACHE 51 -#define STMT_51_INFO {"STMT_SELECT_BASE_DAV_CACHE", NULL} -#define STMT_51 \ +#define STMT_SELECT_BASE_DAV_CACHE 52 +#define STMT_52_INFO {"STMT_SELECT_BASE_DAV_CACHE", NULL} +#define STMT_52 \ "SELECT dav_cache FROM nodes " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \ "" -#define STMT_SELECT_DELETION_INFO 52 -#define STMT_52_INFO {"STMT_SELECT_DELETION_INFO", NULL} -#define STMT_52 \ +#define STMT_SELECT_DELETION_INFO 53 +#define STMT_53_INFO {"STMT_SELECT_DELETION_INFO", NULL} +#define STMT_53 \ "SELECT b.presence, w.presence, w.op_depth, w.moved_to " \ "FROM nodes w " \ "LEFT JOIN nodes b ON b.wc_id = ?1 AND b.local_relpath = ?2 AND b.op_depth = 0 " \ @@ -575,18 +589,18 @@ "LIMIT 1 " \ "" -#define STMT_SELECT_MOVED_TO_NODE 53 -#define STMT_53_INFO {"STMT_SELECT_MOVED_TO_NODE", NULL} -#define STMT_53 \ +#define STMT_SELECT_MOVED_TO_NODE 54 +#define STMT_54_INFO {"STMT_SELECT_MOVED_TO_NODE", NULL} +#define STMT_54 \ "SELECT op_depth, moved_to " \ "FROM nodes " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND moved_to IS NOT NULL " \ "ORDER BY op_depth DESC " \ "" -#define STMT_SELECT_OP_DEPTH_MOVED_TO 54 -#define STMT_54_INFO {"STMT_SELECT_OP_DEPTH_MOVED_TO", NULL} -#define STMT_54 \ +#define STMT_SELECT_OP_DEPTH_MOVED_TO 55 +#define STMT_55_INFO {"STMT_SELECT_OP_DEPTH_MOVED_TO", NULL} +#define STMT_55 \ "SELECT op_depth, moved_to " \ "FROM nodes " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > ?3 " \ @@ -597,17 +611,17 @@ "LIMIT 1 " \ "" -#define STMT_SELECT_MOVED_TO 55 -#define STMT_55_INFO {"STMT_SELECT_MOVED_TO", NULL} -#define STMT_55 \ +#define STMT_SELECT_MOVED_TO 56 +#define STMT_56_INFO {"STMT_SELECT_MOVED_TO", NULL} +#define STMT_56 \ "SELECT moved_to " \ "FROM nodes " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \ "" -#define STMT_SELECT_MOVED_BACK 56 -#define STMT_56_INFO {"STMT_SELECT_MOVED_BACK", NULL} -#define STMT_56 \ +#define STMT_SELECT_MOVED_BACK 57 +#define STMT_57_INFO {"STMT_SELECT_MOVED_BACK", NULL} +#define STMT_57 \ "SELECT u.local_relpath, " \ " u.presence, u.repos_id, u.repos_path, u.revision, " \ " l.presence, l.repos_id, l.repos_path, l.revision, " \ @@ -633,71 +647,71 @@ " AND u.op_depth = ?4 " \ "" -#define STMT_DELETE_LOCK 57 -#define STMT_57_INFO {"STMT_DELETE_LOCK", NULL} -#define STMT_57 \ +#define STMT_DELETE_LOCK 58 +#define STMT_58_INFO {"STMT_DELETE_LOCK", NULL} +#define STMT_58 \ "DELETE FROM lock " \ "WHERE repos_id = ?1 AND repos_relpath = ?2 " \ "" -#define STMT_DELETE_LOCK_RECURSIVELY 58 -#define STMT_58_INFO {"STMT_DELETE_LOCK_RECURSIVELY", NULL} -#define STMT_58 \ +#define STMT_DELETE_LOCK_RECURSIVELY 59 +#define STMT_59_INFO {"STMT_DELETE_LOCK_RECURSIVELY", NULL} +#define STMT_59 \ "DELETE FROM lock " \ "WHERE repos_id = ?1 AND (repos_relpath = ?2 OR (((repos_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((repos_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \ "" -#define STMT_CLEAR_BASE_NODE_RECURSIVE_DAV_CACHE 59 -#define STMT_59_INFO {"STMT_CLEAR_BASE_NODE_RECURSIVE_DAV_CACHE", NULL} -#define STMT_59 \ +#define STMT_CLEAR_BASE_NODE_RECURSIVE_DAV_CACHE 60 +#define STMT_60_INFO {"STMT_CLEAR_BASE_NODE_RECURSIVE_DAV_CACHE", NULL} +#define STMT_60 \ "UPDATE nodes SET dav_cache = NULL " \ "WHERE dav_cache IS NOT NULL AND wc_id = ?1 AND op_depth = 0 " \ " 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_RECURSIVE_UPDATE_NODE_REPO 60 -#define STMT_60_INFO {"STMT_RECURSIVE_UPDATE_NODE_REPO", NULL} -#define STMT_60 \ +#define STMT_RECURSIVE_UPDATE_NODE_REPO 61 +#define STMT_61_INFO {"STMT_RECURSIVE_UPDATE_NODE_REPO", NULL} +#define STMT_61 \ "UPDATE nodes SET repos_id = ?4, dav_cache = NULL " \ "WHERE (wc_id = ?1 AND local_relpath = ?2 AND repos_id = ?3) " \ " OR (wc_id = ?1 AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ " AND repos_id = ?3) " \ "" -#define STMT_UPDATE_LOCK_REPOS_ID 61 -#define STMT_61_INFO {"STMT_UPDATE_LOCK_REPOS_ID", NULL} -#define STMT_61 \ +#define STMT_UPDATE_LOCK_REPOS_ID 62 +#define STMT_62_INFO {"STMT_UPDATE_LOCK_REPOS_ID", NULL} +#define STMT_62 \ "UPDATE lock SET repos_id = ?2 " \ "WHERE repos_id = ?1 " \ "" -#define STMT_UPDATE_NODE_FILEINFO 62 -#define STMT_62_INFO {"STMT_UPDATE_NODE_FILEINFO", NULL} -#define STMT_62 \ +#define STMT_UPDATE_NODE_FILEINFO 63 +#define STMT_63_INFO {"STMT_UPDATE_NODE_FILEINFO", NULL} +#define STMT_63 \ "UPDATE nodes SET translated_size = ?3, last_mod_time = ?4 " \ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ " AND op_depth = (SELECT MAX(op_depth) FROM nodes " \ " WHERE wc_id = ?1 AND local_relpath = ?2) " \ "" -#define STMT_INSERT_ACTUAL_CONFLICT 63 -#define STMT_63_INFO {"STMT_INSERT_ACTUAL_CONFLICT", NULL} -#define STMT_63 \ +#define STMT_INSERT_ACTUAL_CONFLICT 64 +#define STMT_64_INFO {"STMT_INSERT_ACTUAL_CONFLICT", NULL} +#define STMT_64 \ "INSERT INTO actual_node (wc_id, local_relpath, conflict_data, parent_relpath) " \ "VALUES (?1, ?2, ?3, ?4) " \ "" -#define STMT_UPDATE_ACTUAL_CONFLICT 64 -#define STMT_64_INFO {"STMT_UPDATE_ACTUAL_CONFLICT", NULL} -#define STMT_64 \ +#define STMT_UPDATE_ACTUAL_CONFLICT 65 +#define STMT_65_INFO {"STMT_UPDATE_ACTUAL_CONFLICT", NULL} +#define STMT_65 \ "UPDATE actual_node SET conflict_data = ?3 " \ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ "" -#define STMT_UPDATE_ACTUAL_CHANGELISTS 65 -#define STMT_65_INFO {"STMT_UPDATE_ACTUAL_CHANGELISTS", NULL} -#define STMT_65 \ +#define STMT_UPDATE_ACTUAL_CHANGELISTS 66 +#define STMT_66_INFO {"STMT_UPDATE_ACTUAL_CHANGELISTS", NULL} +#define STMT_66 \ "UPDATE actual_node SET changelist = ?3 " \ "WHERE wc_id = ?1 " \ " 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))) " \ @@ -707,16 +721,16 @@ " AND kind = 'file') " \ "" -#define STMT_UPDATE_ACTUAL_CLEAR_CHANGELIST 66 -#define STMT_66_INFO {"STMT_UPDATE_ACTUAL_CLEAR_CHANGELIST", NULL} -#define STMT_66 \ +#define STMT_UPDATE_ACTUAL_CLEAR_CHANGELIST 67 +#define STMT_67_INFO {"STMT_UPDATE_ACTUAL_CLEAR_CHANGELIST", NULL} +#define STMT_67 \ "UPDATE actual_node SET changelist = NULL " \ " WHERE wc_id = ?1 AND local_relpath = ?2 " \ "" -#define STMT_MARK_SKIPPED_CHANGELIST_DIRS 67 -#define STMT_67_INFO {"STMT_MARK_SKIPPED_CHANGELIST_DIRS", NULL} -#define STMT_67 \ +#define STMT_MARK_SKIPPED_CHANGELIST_DIRS 68 +#define STMT_68_INFO {"STMT_MARK_SKIPPED_CHANGELIST_DIRS", NULL} +#define STMT_68 \ "INSERT INTO changelist_list (wc_id, local_relpath, notify, changelist) " \ "SELECT wc_id, local_relpath, 7, ?3 " \ "FROM targets_list " \ @@ -725,17 +739,17 @@ " AND kind = 'dir' " \ "" -#define STMT_RESET_ACTUAL_WITH_CHANGELIST 68 -#define STMT_68_INFO {"STMT_RESET_ACTUAL_WITH_CHANGELIST", NULL} -#define STMT_68 \ +#define STMT_RESET_ACTUAL_WITH_CHANGELIST 69 +#define STMT_69_INFO {"STMT_RESET_ACTUAL_WITH_CHANGELIST", NULL} +#define STMT_69 \ "REPLACE INTO actual_node ( " \ " wc_id, local_relpath, parent_relpath, changelist) " \ "VALUES (?1, ?2, ?3, ?4) " \ "" -#define STMT_CREATE_CHANGELIST_LIST 69 -#define STMT_69_INFO {"STMT_CREATE_CHANGELIST_LIST", NULL} -#define STMT_69 \ +#define STMT_CREATE_CHANGELIST_LIST 70 +#define STMT_70_INFO {"STMT_CREATE_CHANGELIST_LIST", NULL} +#define STMT_70 \ "DROP TABLE IF EXISTS changelist_list; " \ "CREATE TEMPORARY TABLE changelist_list ( " \ " wc_id INTEGER NOT NULL, " \ @@ -746,9 +760,9 @@ ") " \ "" -#define STMT_CREATE_CHANGELIST_TRIGGER 70 -#define STMT_70_INFO {"STMT_CREATE_CHANGELIST_TRIGGER", NULL} -#define STMT_70 \ +#define STMT_CREATE_CHANGELIST_TRIGGER 71 +#define STMT_71_INFO {"STMT_CREATE_CHANGELIST_TRIGGER", NULL} +#define STMT_71 \ "DROP TRIGGER IF EXISTS trigger_changelist_list_change; " \ "CREATE TEMPORARY TRIGGER trigger_changelist_list_change " \ "BEFORE UPDATE ON actual_node " \ @@ -763,25 +777,25 @@ "END " \ "" -#define STMT_FINALIZE_CHANGELIST 71 -#define STMT_71_INFO {"STMT_FINALIZE_CHANGELIST", NULL} -#define STMT_71 \ +#define STMT_FINALIZE_CHANGELIST 72 +#define STMT_72_INFO {"STMT_FINALIZE_CHANGELIST", NULL} +#define STMT_72 \ "DROP TRIGGER trigger_changelist_list_change; " \ "DROP TABLE changelist_list; " \ "DROP TABLE targets_list " \ "" -#define STMT_SELECT_CHANGELIST_LIST 72 -#define STMT_72_INFO {"STMT_SELECT_CHANGELIST_LIST", NULL} -#define STMT_72 \ +#define STMT_SELECT_CHANGELIST_LIST 73 +#define STMT_73_INFO {"STMT_SELECT_CHANGELIST_LIST", NULL} +#define STMT_73 \ "SELECT wc_id, local_relpath, notify, changelist " \ "FROM changelist_list " \ "ORDER BY wc_id, local_relpath ASC, notify DESC " \ "" -#define STMT_CREATE_TARGETS_LIST 73 -#define STMT_73_INFO {"STMT_CREATE_TARGETS_LIST", NULL} -#define STMT_73 \ +#define STMT_CREATE_TARGETS_LIST 74 +#define STMT_74_INFO {"STMT_CREATE_TARGETS_LIST", NULL} +#define STMT_74 \ "DROP TABLE IF EXISTS targets_list; " \ "CREATE TEMPORARY TABLE targets_list ( " \ " wc_id INTEGER NOT NULL, " \ @@ -792,15 +806,15 @@ " ); " \ "" -#define STMT_DROP_TARGETS_LIST 74 -#define STMT_74_INFO {"STMT_DROP_TARGETS_LIST", NULL} -#define STMT_74 \ +#define STMT_DROP_TARGETS_LIST 75 +#define STMT_75_INFO {"STMT_DROP_TARGETS_LIST", NULL} +#define STMT_75 \ "DROP TABLE targets_list " \ "" -#define STMT_INSERT_TARGET 75 -#define STMT_75_INFO {"STMT_INSERT_TARGET", NULL} -#define STMT_75 \ +#define STMT_INSERT_TARGET 76 +#define STMT_76_INFO {"STMT_INSERT_TARGET", NULL} +#define STMT_76 \ "INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \ "SELECT wc_id, local_relpath, parent_relpath, kind " \ "FROM nodes_current " \ @@ -808,9 +822,9 @@ " AND local_relpath = ?2 " \ "" -#define STMT_INSERT_TARGET_DEPTH_FILES 76 -#define STMT_76_INFO {"STMT_INSERT_TARGET_DEPTH_FILES", NULL} -#define STMT_76 \ +#define STMT_INSERT_TARGET_DEPTH_FILES 77 +#define STMT_77_INFO {"STMT_INSERT_TARGET_DEPTH_FILES", NULL} +#define STMT_77 \ "INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \ "SELECT wc_id, local_relpath, parent_relpath, kind " \ "FROM nodes_current " \ @@ -819,9 +833,9 @@ " AND kind = 'file' " \ "" -#define STMT_INSERT_TARGET_DEPTH_IMMEDIATES 77 -#define STMT_77_INFO {"STMT_INSERT_TARGET_DEPTH_IMMEDIATES", NULL} -#define STMT_77 \ +#define STMT_INSERT_TARGET_DEPTH_IMMEDIATES 78 +#define STMT_78_INFO {"STMT_INSERT_TARGET_DEPTH_IMMEDIATES", NULL} +#define STMT_78 \ "INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \ "SELECT wc_id, local_relpath, parent_relpath, kind " \ "FROM nodes_current " \ @@ -829,9 +843,9 @@ " AND parent_relpath = ?2 " \ "" -#define STMT_INSERT_TARGET_DEPTH_INFINITY 78 -#define STMT_78_INFO {"STMT_INSERT_TARGET_DEPTH_INFINITY", NULL} -#define STMT_78 \ +#define STMT_INSERT_TARGET_DEPTH_INFINITY 79 +#define STMT_79_INFO {"STMT_INSERT_TARGET_DEPTH_INFINITY", NULL} +#define STMT_79 \ "INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \ "SELECT wc_id, local_relpath, parent_relpath, kind " \ "FROM nodes_current " \ @@ -839,9 +853,9 @@ " AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ "" -#define STMT_INSERT_TARGET_WITH_CHANGELIST 79 -#define STMT_79_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST", NULL} -#define STMT_79 \ +#define STMT_INSERT_TARGET_WITH_CHANGELIST 80 +#define STMT_80_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST", NULL} +#define STMT_80 \ "INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \ "SELECT N.wc_id, N.local_relpath, N.parent_relpath, N.kind " \ " FROM actual_node AS A JOIN nodes_current AS N " \ @@ -851,9 +865,9 @@ " AND A.changelist = ?3 " \ "" -#define STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_FILES 80 -#define STMT_80_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_FILES", NULL} -#define STMT_80 \ +#define STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_FILES 81 +#define STMT_81_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_FILES", NULL} +#define STMT_81 \ "INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \ "SELECT N.wc_id, N.local_relpath, N.parent_relpath, N.kind " \ " FROM actual_node AS A JOIN nodes_current AS N " \ @@ -864,9 +878,9 @@ " AND A.changelist = ?3 " \ "" -#define STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_IMMEDIATES 81 -#define STMT_81_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_IMMEDIATES", NULL} -#define STMT_81 \ +#define STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_IMMEDIATES 82 +#define STMT_82_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_IMMEDIATES", NULL} +#define STMT_82 \ "INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \ "SELECT N.wc_id, N.local_relpath, N.parent_relpath, N.kind " \ " FROM actual_node AS A JOIN nodes_current AS N " \ @@ -876,9 +890,9 @@ " AND A.changelist = ?3 " \ "" -#define STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_INFINITY 82 -#define STMT_82_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_INFINITY", NULL} -#define STMT_82 \ +#define STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_INFINITY 83 +#define STMT_83_INFO {"STMT_INSERT_TARGET_WITH_CHANGELIST_DEPTH_INFINITY", NULL} +#define STMT_83 \ "INSERT INTO targets_list(wc_id, local_relpath, parent_relpath, kind) " \ "SELECT N.wc_id, N.local_relpath, N.parent_relpath, N.kind " \ " FROM actual_node AS A JOIN nodes_current AS N " \ @@ -888,18 +902,18 @@ " AND A.changelist = ?3 " \ "" -#define STMT_INSERT_ACTUAL_EMPTIES 83 -#define STMT_83_INFO {"STMT_INSERT_ACTUAL_EMPTIES", NULL} -#define STMT_83 \ +#define STMT_INSERT_ACTUAL_EMPTIES 84 +#define STMT_84_INFO {"STMT_INSERT_ACTUAL_EMPTIES", NULL} +#define STMT_84 \ "INSERT OR IGNORE INTO actual_node ( " \ " wc_id, local_relpath, parent_relpath) " \ "SELECT wc_id, local_relpath, parent_relpath " \ "FROM targets_list " \ "" -#define STMT_INSERT_ACTUAL_EMPTIES_FILES 84 -#define STMT_84_INFO {"STMT_INSERT_ACTUAL_EMPTIES_FILES", NULL} -#define STMT_84 \ +#define STMT_INSERT_ACTUAL_EMPTIES_FILES 85 +#define STMT_85_INFO {"STMT_INSERT_ACTUAL_EMPTIES_FILES", NULL} +#define STMT_85 \ "INSERT OR IGNORE INTO actual_node ( " \ " wc_id, local_relpath, parent_relpath) " \ "SELECT wc_id, local_relpath, parent_relpath " \ @@ -907,9 +921,9 @@ "WHERE kind='file' " \ "" -#define STMT_DELETE_ACTUAL_EMPTY 85 -#define STMT_85_INFO {"STMT_DELETE_ACTUAL_EMPTY", NULL} -#define STMT_85 \ +#define STMT_DELETE_ACTUAL_EMPTY 86 +#define STMT_86_INFO {"STMT_DELETE_ACTUAL_EMPTY", NULL} +#define STMT_86 \ "DELETE FROM actual_node " \ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ " AND properties IS NULL " \ @@ -921,9 +935,9 @@ " AND left_checksum IS NULL " \ "" -#define STMT_DELETE_ACTUAL_EMPTIES 86 -#define STMT_86_INFO {"STMT_DELETE_ACTUAL_EMPTIES", NULL} -#define STMT_86 \ +#define STMT_DELETE_ACTUAL_EMPTIES 87 +#define STMT_87_INFO {"STMT_DELETE_ACTUAL_EMPTIES", NULL} +#define STMT_87 \ "DELETE FROM actual_node " \ "WHERE wc_id = ?1 " \ " 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))) " \ @@ -936,25 +950,25 @@ " AND left_checksum IS NULL " \ "" -#define STMT_DELETE_BASE_NODE 87 -#define STMT_87_INFO {"STMT_DELETE_BASE_NODE", NULL} -#define STMT_87 \ +#define STMT_DELETE_BASE_NODE 88 +#define STMT_88_INFO {"STMT_DELETE_BASE_NODE", NULL} +#define STMT_88 \ "DELETE FROM nodes " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \ "" -#define STMT_DELETE_WORKING_NODE 88 -#define STMT_88_INFO {"STMT_DELETE_WORKING_NODE", NULL} -#define STMT_88 \ +#define STMT_DELETE_WORKING_NODE 89 +#define STMT_89_INFO {"STMT_DELETE_WORKING_NODE", NULL} +#define STMT_89 \ "DELETE FROM nodes " \ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ " AND op_depth = (SELECT MAX(op_depth) FROM nodes " \ " WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0) " \ "" -#define STMT_DELETE_LOWEST_WORKING_NODE 89 -#define STMT_89_INFO {"STMT_DELETE_LOWEST_WORKING_NODE", NULL} -#define STMT_89 \ +#define STMT_DELETE_LOWEST_WORKING_NODE 90 +#define STMT_90_INFO {"STMT_DELETE_LOWEST_WORKING_NODE", NULL} +#define STMT_90 \ "DELETE FROM nodes " \ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ " AND op_depth = (SELECT MIN(op_depth) FROM nodes " \ @@ -962,16 +976,16 @@ " AND presence = 'base-deleted' " \ "" -#define STMT_DELETE_NODE_ALL_LAYERS 90 -#define STMT_90_INFO {"STMT_DELETE_NODE_ALL_LAYERS", NULL} -#define STMT_90 \ +#define STMT_DELETE_NODE_ALL_LAYERS 91 +#define STMT_91_INFO {"STMT_DELETE_NODE_ALL_LAYERS", NULL} +#define STMT_91 \ "DELETE FROM nodes " \ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ "" -#define STMT_DELETE_NODES_ABOVE_DEPTH_RECURSIVE 91 -#define STMT_91_INFO {"STMT_DELETE_NODES_ABOVE_DEPTH_RECURSIVE", NULL} -#define STMT_91 \ +#define STMT_DELETE_NODES_ABOVE_DEPTH_RECURSIVE 92 +#define STMT_92_INFO {"STMT_DELETE_NODES_ABOVE_DEPTH_RECURSIVE", NULL} +#define STMT_92 \ "DELETE FROM nodes " \ "WHERE wc_id = ?1 " \ " AND (local_relpath = ?2 " \ @@ -979,25 +993,25 @@ " AND op_depth >= ?3 " \ "" -#define STMT_DELETE_ACTUAL_NODE 92 -#define STMT_92_INFO {"STMT_DELETE_ACTUAL_NODE", NULL} -#define STMT_92 \ +#define STMT_DELETE_ACTUAL_NODE 93 +#define STMT_93_INFO {"STMT_DELETE_ACTUAL_NODE", NULL} +#define STMT_93 \ "DELETE FROM actual_node " \ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ "" -#define STMT_DELETE_ACTUAL_NODE_RECURSIVE 93 -#define STMT_93_INFO {"STMT_DELETE_ACTUAL_NODE_RECURSIVE", NULL} -#define STMT_93 \ +#define STMT_DELETE_ACTUAL_NODE_RECURSIVE 94 +#define STMT_94_INFO {"STMT_DELETE_ACTUAL_NODE_RECURSIVE", NULL} +#define STMT_94 \ "DELETE FROM actual_node " \ "WHERE wc_id = ?1 " \ " 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_ACTUAL_NODE_LEAVING_CHANGELIST 94 -#define STMT_94_INFO {"STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST", NULL} -#define STMT_94 \ +#define STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST 95 +#define STMT_95_INFO {"STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST", NULL} +#define STMT_95 \ "DELETE FROM actual_node " \ "WHERE wc_id = ?1 " \ " AND local_relpath = ?2 " \ @@ -1007,9 +1021,9 @@ " AND c.kind = 'file')) " \ "" -#define STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE 95 -#define STMT_95_INFO {"STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE", NULL} -#define STMT_95 \ +#define STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE 96 +#define STMT_96_INFO {"STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE", NULL} +#define STMT_96 \ "DELETE FROM actual_node " \ "WHERE wc_id = ?1 " \ " AND (local_relpath = ?2 " \ @@ -1021,9 +1035,9 @@ " AND c.kind = 'file')) " \ "" -#define STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST 96 -#define STMT_96_INFO {"STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST", NULL} -#define STMT_96 \ +#define STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST 97 +#define STMT_97_INFO {"STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST", NULL} +#define STMT_97 \ "UPDATE actual_node " \ "SET properties = NULL, " \ " text_mod = NULL, " \ @@ -1035,9 +1049,9 @@ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ "" -#define STMT_CLEAR_ACTUAL_NODE_LEAVING_CONFLICT 97 -#define STMT_97_INFO {"STMT_CLEAR_ACTUAL_NODE_LEAVING_CONFLICT", NULL} -#define STMT_97 \ +#define STMT_CLEAR_ACTUAL_NODE_LEAVING_CONFLICT 98 +#define STMT_98_INFO {"STMT_CLEAR_ACTUAL_NODE_LEAVING_CONFLICT", NULL} +#define STMT_98 \ "UPDATE actual_node " \ "SET properties = NULL, " \ " text_mod = NULL, " \ @@ -1049,9 +1063,9 @@ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ "" -#define STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE 98 -#define STMT_98_INFO {"STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE", NULL} -#define STMT_98 \ +#define STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE 99 +#define STMT_99_INFO {"STMT_CLEAR_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE", NULL} +#define STMT_99 \ "UPDATE actual_node " \ "SET properties = NULL, " \ " text_mod = NULL, " \ @@ -1065,109 +1079,109 @@ " 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_UPDATE_NODE_BASE_DEPTH 99 -#define STMT_99_INFO {"STMT_UPDATE_NODE_BASE_DEPTH", NULL} -#define STMT_99 \ +#define STMT_UPDATE_NODE_BASE_DEPTH 100 +#define STMT_100_INFO {"STMT_UPDATE_NODE_BASE_DEPTH", NULL} +#define STMT_100 \ "UPDATE nodes SET depth = ?3 " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \ " AND kind='dir' " \ " AND presence IN ('normal', 'incomplete') " \ "" -#define STMT_UPDATE_NODE_BASE_PRESENCE 100 -#define STMT_100_INFO {"STMT_UPDATE_NODE_BASE_PRESENCE", NULL} -#define STMT_100 \ +#define STMT_UPDATE_NODE_BASE_PRESENCE 101 +#define STMT_101_INFO {"STMT_UPDATE_NODE_BASE_PRESENCE", NULL} +#define STMT_101 \ "UPDATE nodes SET presence = ?3 " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \ "" -#define STMT_UPDATE_BASE_NODE_PRESENCE_REVNUM_AND_REPOS_PATH 101 -#define STMT_101_INFO {"STMT_UPDATE_BASE_NODE_PRESENCE_REVNUM_AND_REPOS_PATH", NULL} -#define STMT_101 \ +#define STMT_UPDATE_BASE_NODE_PRESENCE_REVNUM_AND_REPOS_PATH 102 +#define STMT_102_INFO {"STMT_UPDATE_BASE_NODE_PRESENCE_REVNUM_AND_REPOS_PATH", NULL} +#define STMT_102 \ "UPDATE nodes SET presence = ?3, revision = ?4, repos_path = ?5 " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \ "" -#define STMT_LOOK_FOR_WORK 102 -#define STMT_102_INFO {"STMT_LOOK_FOR_WORK", NULL} -#define STMT_102 \ +#define STMT_LOOK_FOR_WORK 103 +#define STMT_103_INFO {"STMT_LOOK_FOR_WORK", NULL} +#define STMT_103 \ "SELECT id FROM work_queue LIMIT 1 " \ "" -#define STMT_INSERT_WORK_ITEM 103 -#define STMT_103_INFO {"STMT_INSERT_WORK_ITEM", NULL} -#define STMT_103 \ +#define STMT_INSERT_WORK_ITEM 104 +#define STMT_104_INFO {"STMT_INSERT_WORK_ITEM", NULL} +#define STMT_104 \ "INSERT INTO work_queue (work) VALUES (?1) " \ "" -#define STMT_SELECT_WORK_ITEM 104 -#define STMT_104_INFO {"STMT_SELECT_WORK_ITEM", NULL} -#define STMT_104 \ +#define STMT_SELECT_WORK_ITEM 105 +#define STMT_105_INFO {"STMT_SELECT_WORK_ITEM", NULL} +#define STMT_105 \ "SELECT id, work FROM work_queue ORDER BY id LIMIT 1 " \ "" -#define STMT_DELETE_WORK_ITEM 105 -#define STMT_105_INFO {"STMT_DELETE_WORK_ITEM", NULL} -#define STMT_105 \ +#define STMT_DELETE_WORK_ITEM 106 +#define STMT_106_INFO {"STMT_DELETE_WORK_ITEM", NULL} +#define STMT_106 \ "DELETE FROM work_queue WHERE id = ?1 " \ "" -#define STMT_INSERT_OR_IGNORE_PRISTINE 106 -#define STMT_106_INFO {"STMT_INSERT_OR_IGNORE_PRISTINE", NULL} -#define STMT_106 \ +#define STMT_INSERT_OR_IGNORE_PRISTINE 107 +#define STMT_107_INFO {"STMT_INSERT_OR_IGNORE_PRISTINE", NULL} +#define STMT_107 \ "INSERT OR IGNORE INTO pristine (checksum, md5_checksum, size, refcount) " \ "VALUES (?1, ?2, ?3, 0) " \ "" -#define STMT_INSERT_PRISTINE 107 -#define STMT_107_INFO {"STMT_INSERT_PRISTINE", NULL} -#define STMT_107 \ +#define STMT_INSERT_PRISTINE 108 +#define STMT_108_INFO {"STMT_INSERT_PRISTINE", NULL} +#define STMT_108 \ "INSERT INTO pristine (checksum, md5_checksum, size, refcount) " \ "VALUES (?1, ?2, ?3, 0) " \ "" -#define STMT_SELECT_PRISTINE 108 -#define STMT_108_INFO {"STMT_SELECT_PRISTINE", NULL} -#define STMT_108 \ +#define STMT_SELECT_PRISTINE 109 +#define STMT_109_INFO {"STMT_SELECT_PRISTINE", NULL} +#define STMT_109 \ "SELECT md5_checksum " \ "FROM pristine " \ "WHERE checksum = ?1 " \ "" -#define STMT_SELECT_PRISTINE_SIZE 109 -#define STMT_109_INFO {"STMT_SELECT_PRISTINE_SIZE", NULL} -#define STMT_109 \ +#define STMT_SELECT_PRISTINE_SIZE 110 +#define STMT_110_INFO {"STMT_SELECT_PRISTINE_SIZE", NULL} +#define STMT_110 \ "SELECT size " \ "FROM pristine " \ "WHERE checksum = ?1 LIMIT 1 " \ "" -#define STMT_SELECT_PRISTINE_BY_MD5 110 -#define STMT_110_INFO {"STMT_SELECT_PRISTINE_BY_MD5", NULL} -#define STMT_110 \ +#define STMT_SELECT_PRISTINE_BY_MD5 111 +#define STMT_111_INFO {"STMT_SELECT_PRISTINE_BY_MD5", NULL} +#define STMT_111 \ "SELECT checksum " \ "FROM pristine " \ "WHERE md5_checksum = ?1 " \ "" -#define STMT_SELECT_UNREFERENCED_PRISTINES 111 -#define STMT_111_INFO {"STMT_SELECT_UNREFERENCED_PRISTINES", NULL} -#define STMT_111 \ +#define STMT_SELECT_UNREFERENCED_PRISTINES 112 +#define STMT_112_INFO {"STMT_SELECT_UNREFERENCED_PRISTINES", NULL} +#define STMT_112 \ "SELECT checksum " \ "FROM pristine " \ "WHERE refcount = 0 " \ "" -#define STMT_DELETE_PRISTINE_IF_UNREFERENCED 112 -#define STMT_112_INFO {"STMT_DELETE_PRISTINE_IF_UNREFERENCED", NULL} -#define STMT_112 \ +#define STMT_DELETE_PRISTINE_IF_UNREFERENCED 113 +#define STMT_113_INFO {"STMT_DELETE_PRISTINE_IF_UNREFERENCED", NULL} +#define STMT_113 \ "DELETE FROM pristine " \ "WHERE checksum = ?1 AND refcount = 0 " \ "" -#define STMT_SELECT_COPY_PRISTINES 113 -#define STMT_113_INFO {"STMT_SELECT_COPY_PRISTINES", NULL} -#define STMT_113 \ +#define STMT_SELECT_COPY_PRISTINES 114 +#define STMT_114_INFO {"STMT_SELECT_COPY_PRISTINES", NULL} +#define STMT_114 \ "SELECT n.checksum, md5_checksum, size " \ "FROM nodes_current n " \ "LEFT JOIN pristine p ON n.checksum = p.checksum " \ @@ -1185,62 +1199,62 @@ " AND n.checksum IS NOT NULL " \ "" -#define STMT_VACUUM 114 -#define STMT_114_INFO {"STMT_VACUUM", NULL} -#define STMT_114 \ +#define STMT_VACUUM 115 +#define STMT_115_INFO {"STMT_VACUUM", NULL} +#define STMT_115 \ "VACUUM " \ "" -#define STMT_SELECT_CONFLICT_VICTIMS 115 -#define STMT_115_INFO {"STMT_SELECT_CONFLICT_VICTIMS", NULL} -#define STMT_115 \ +#define STMT_SELECT_CONFLICT_VICTIMS 116 +#define STMT_116_INFO {"STMT_SELECT_CONFLICT_VICTIMS", NULL} +#define STMT_116 \ "SELECT local_relpath, conflict_data " \ "FROM actual_node " \ "WHERE wc_id = ?1 AND parent_relpath = ?2 AND " \ " NOT (conflict_data IS NULL) " \ "" -#define STMT_INSERT_WC_LOCK 116 -#define STMT_116_INFO {"STMT_INSERT_WC_LOCK", NULL} -#define STMT_116 \ +#define STMT_INSERT_WC_LOCK 117 +#define STMT_117_INFO {"STMT_INSERT_WC_LOCK", NULL} +#define STMT_117 \ "INSERT INTO wc_lock (wc_id, local_dir_relpath, locked_levels) " \ "VALUES (?1, ?2, ?3) " \ "" -#define STMT_SELECT_WC_LOCK 117 -#define STMT_117_INFO {"STMT_SELECT_WC_LOCK", NULL} -#define STMT_117 \ +#define STMT_SELECT_WC_LOCK 118 +#define STMT_118_INFO {"STMT_SELECT_WC_LOCK", NULL} +#define STMT_118 \ "SELECT locked_levels FROM wc_lock " \ "WHERE wc_id = ?1 AND local_dir_relpath = ?2 " \ "" -#define STMT_SELECT_ANCESTOR_WCLOCKS 118 -#define STMT_118_INFO {"STMT_SELECT_ANCESTOR_WCLOCKS", NULL} -#define STMT_118 \ +#define STMT_SELECT_ANCESTOR_WCLOCKS 119 +#define STMT_119_INFO {"STMT_SELECT_ANCESTOR_WCLOCKS", NULL} +#define STMT_119 \ "SELECT local_dir_relpath, locked_levels FROM wc_lock " \ "WHERE wc_id = ?1 " \ " AND ((local_dir_relpath >= ?3 AND local_dir_relpath <= ?2) " \ " OR local_dir_relpath = '') " \ "" -#define STMT_DELETE_WC_LOCK 119 -#define STMT_119_INFO {"STMT_DELETE_WC_LOCK", NULL} -#define STMT_119 \ +#define STMT_DELETE_WC_LOCK 120 +#define STMT_120_INFO {"STMT_DELETE_WC_LOCK", NULL} +#define STMT_120 \ "DELETE FROM wc_lock " \ "WHERE wc_id = ?1 AND local_dir_relpath = ?2 " \ "" -#define STMT_FIND_WC_LOCK 120 -#define STMT_120_INFO {"STMT_FIND_WC_LOCK", NULL} -#define STMT_120 \ +#define STMT_FIND_WC_LOCK 121 +#define STMT_121_INFO {"STMT_FIND_WC_LOCK", NULL} +#define STMT_121 \ "SELECT local_dir_relpath FROM wc_lock " \ "WHERE wc_id = ?1 " \ " AND (((local_dir_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_dir_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ "" -#define STMT_FIND_CONFLICT_DESCENDANT 121 -#define STMT_121_INFO {"STMT_FIND_CONFLICT_DESCENDANT", NULL} -#define STMT_121 \ +#define STMT_FIND_CONFLICT_DESCENDANT 122 +#define STMT_122_INFO {"STMT_FIND_CONFLICT_DESCENDANT", NULL} +#define STMT_122 \ "SELECT 1 FROM actual_node " \ "WHERE wc_id = ?1 " \ " AND local_relpath > (?2 || '/') " \ @@ -1249,9 +1263,9 @@ "LIMIT 1 " \ "" -#define STMT_DELETE_WC_LOCK_ORPHAN 122 -#define STMT_122_INFO {"STMT_DELETE_WC_LOCK_ORPHAN", NULL} -#define STMT_122 \ +#define STMT_DELETE_WC_LOCK_ORPHAN 123 +#define STMT_123_INFO {"STMT_DELETE_WC_LOCK_ORPHAN", NULL} +#define STMT_123 \ "DELETE FROM wc_lock " \ "WHERE wc_id = ?1 AND local_dir_relpath = ?2 " \ "AND NOT EXISTS (SELECT 1 FROM nodes " \ @@ -1259,9 +1273,9 @@ " AND nodes.local_relpath = wc_lock.local_dir_relpath) " \ "" -#define STMT_DELETE_WC_LOCK_ORPHAN_RECURSIVE 123 -#define STMT_123_INFO {"STMT_DELETE_WC_LOCK_ORPHAN_RECURSIVE", NULL} -#define STMT_123 \ +#define STMT_DELETE_WC_LOCK_ORPHAN_RECURSIVE 124 +#define STMT_124_INFO {"STMT_DELETE_WC_LOCK_ORPHAN_RECURSIVE", NULL} +#define STMT_124 \ "DELETE FROM wc_lock " \ "WHERE wc_id = ?1 " \ " AND (local_dir_relpath = ?2 " \ @@ -1271,9 +1285,9 @@ " AND nodes.local_relpath = wc_lock.local_dir_relpath) " \ "" -#define STMT_APPLY_CHANGES_TO_BASE_NODE 124 -#define STMT_124_INFO {"STMT_APPLY_CHANGES_TO_BASE_NODE", NULL} -#define STMT_124 \ +#define STMT_APPLY_CHANGES_TO_BASE_NODE 125 +#define STMT_125_INFO {"STMT_APPLY_CHANGES_TO_BASE_NODE", NULL} +#define STMT_125 \ "INSERT OR REPLACE INTO nodes ( " \ " wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, " \ " revision, presence, depth, kind, changed_revision, changed_date, " \ @@ -1287,18 +1301,18 @@ " AND op_depth = 0)) " \ "" -#define STMT_INSTALL_WORKING_NODE_FOR_DELETE 125 -#define STMT_125_INFO {"STMT_INSTALL_WORKING_NODE_FOR_DELETE", NULL} -#define STMT_125 \ +#define STMT_INSTALL_WORKING_NODE_FOR_DELETE 126 +#define STMT_126_INFO {"STMT_INSTALL_WORKING_NODE_FOR_DELETE", NULL} +#define STMT_126 \ "INSERT INTO nodes ( " \ " wc_id, local_relpath, op_depth, " \ " parent_relpath, presence, kind) " \ "VALUES(?1, ?2, ?3, ?4, 'base-deleted', ?5) " \ "" -#define STMT_REPLACE_WITH_BASE_DELETED 126 -#define STMT_126_INFO {"STMT_REPLACE_WITH_BASE_DELETED", NULL} -#define STMT_126 \ +#define STMT_REPLACE_WITH_BASE_DELETED 127 +#define STMT_127_INFO {"STMT_REPLACE_WITH_BASE_DELETED", NULL} +#define STMT_127 \ "INSERT OR REPLACE INTO nodes (wc_id, local_relpath, op_depth, parent_relpath, " \ " kind, moved_to, presence) " \ "SELECT wc_id, local_relpath, op_depth, parent_relpath, " \ @@ -1309,9 +1323,9 @@ " AND op_depth = ?3 " \ "" -#define STMT_INSERT_DELETE_FROM_NODE_RECURSIVE 127 -#define STMT_127_INFO {"STMT_INSERT_DELETE_FROM_NODE_RECURSIVE", NULL} -#define STMT_127 \ +#define STMT_INSERT_DELETE_FROM_NODE_RECURSIVE 128 +#define STMT_128_INFO {"STMT_INSERT_DELETE_FROM_NODE_RECURSIVE", NULL} +#define STMT_128 \ "INSERT INTO nodes ( " \ " wc_id, local_relpath, op_depth, parent_relpath, presence, kind) " \ "SELECT wc_id, local_relpath, ?4 , parent_relpath, 'base-deleted', " \ @@ -1330,9 +1344,9 @@ "ORDER BY local_relpath " \ "" -#define STMT_INSERT_WORKING_NODE_FROM_BASE_COPY 128 -#define STMT_128_INFO {"STMT_INSERT_WORKING_NODE_FROM_BASE_COPY", NULL} -#define STMT_128 \ +#define STMT_INSERT_WORKING_NODE_FROM_BASE_COPY 129 +#define STMT_129_INFO {"STMT_INSERT_WORKING_NODE_FROM_BASE_COPY", NULL} +#define STMT_129 \ "INSERT OR REPLACE INTO nodes ( " \ " wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, " \ " revision, presence, depth, kind, changed_revision, changed_date, " \ @@ -1348,9 +1362,9 @@ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \ "" -#define STMT_INSERT_DELETE_FROM_BASE 129 -#define STMT_129_INFO {"STMT_INSERT_DELETE_FROM_BASE", NULL} -#define STMT_129 \ +#define STMT_INSERT_DELETE_FROM_BASE 130 +#define STMT_130_INFO {"STMT_INSERT_DELETE_FROM_BASE", NULL} +#define STMT_130 \ "INSERT INTO nodes ( " \ " wc_id, local_relpath, op_depth, parent_relpath, presence, kind) " \ "SELECT wc_id, local_relpath, ?3 , parent_relpath, " \ @@ -1359,18 +1373,18 @@ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \ "" -#define STMT_UPDATE_OP_DEPTH_INCREASE_RECURSIVE 130 -#define STMT_130_INFO {"STMT_UPDATE_OP_DEPTH_INCREASE_RECURSIVE", NULL} -#define STMT_130 \ +#define STMT_UPDATE_OP_DEPTH_INCREASE_RECURSIVE 131 +#define STMT_131_INFO {"STMT_UPDATE_OP_DEPTH_INCREASE_RECURSIVE", NULL} +#define STMT_131 \ "UPDATE nodes SET op_depth = ?3 + 1 " \ "WHERE wc_id = ?1 " \ " AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ " AND op_depth = ?3 " \ "" -#define STMT_COPY_OP_DEPTH_RECURSIVE 131 -#define STMT_131_INFO {"STMT_COPY_OP_DEPTH_RECURSIVE", NULL} -#define STMT_131 \ +#define STMT_COPY_OP_DEPTH_RECURSIVE 132 +#define STMT_132_INFO {"STMT_COPY_OP_DEPTH_RECURSIVE", NULL} +#define STMT_132 \ "INSERT INTO nodes ( " \ " wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, " \ " revision, presence, depth, kind, changed_revision, changed_date, " \ @@ -1395,16 +1409,16 @@ "ORDER BY local_relpath " \ "" -#define STMT_DOES_NODE_EXIST 132 -#define STMT_132_INFO {"STMT_DOES_NODE_EXIST", NULL} -#define STMT_132 \ +#define STMT_DOES_NODE_EXIST 133 +#define STMT_133_INFO {"STMT_DOES_NODE_EXIST", NULL} +#define STMT_133 \ "SELECT 1 FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 " \ "LIMIT 1 " \ "" -#define STMT_HAS_SERVER_EXCLUDED_DESCENDANTS 133 -#define STMT_133_INFO {"STMT_HAS_SERVER_EXCLUDED_DESCENDANTS", NULL} -#define STMT_133 \ +#define STMT_HAS_SERVER_EXCLUDED_DESCENDANTS 134 +#define STMT_134_INFO {"STMT_HAS_SERVER_EXCLUDED_DESCENDANTS", NULL} +#define STMT_134 \ "SELECT local_relpath FROM nodes " \ "WHERE wc_id = ?1 " \ " AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ @@ -1412,9 +1426,9 @@ "LIMIT 1 " \ "" -#define STMT_SELECT_ALL_EXCLUDED_DESCENDANTS 134 -#define STMT_134_INFO {"STMT_SELECT_ALL_EXCLUDED_DESCENDANTS", NULL} -#define STMT_134 \ +#define STMT_SELECT_ALL_EXCLUDED_DESCENDANTS 135 +#define STMT_135_INFO {"STMT_SELECT_ALL_EXCLUDED_DESCENDANTS", NULL} +#define STMT_135 \ "SELECT local_relpath FROM nodes " \ "WHERE wc_id = ?1 " \ " AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ @@ -1422,9 +1436,9 @@ " AND (presence = 'server-excluded' OR presence = 'excluded') " \ "" -#define STMT_INSERT_WORKING_NODE_COPY_FROM 135 -#define STMT_135_INFO {"STMT_INSERT_WORKING_NODE_COPY_FROM", NULL} -#define STMT_135 \ +#define STMT_INSERT_WORKING_NODE_COPY_FROM 136 +#define STMT_136_INFO {"STMT_INSERT_WORKING_NODE_COPY_FROM", NULL} +#define STMT_136 \ "INSERT OR REPLACE INTO nodes ( " \ " wc_id, local_relpath, op_depth, parent_relpath, repos_id, " \ " repos_path, revision, presence, depth, moved_here, kind, changed_revision, " \ @@ -1443,9 +1457,9 @@ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ "" -#define STMT_INSERT_WORKING_NODE_COPY_FROM_DEPTH 136 -#define STMT_136_INFO {"STMT_INSERT_WORKING_NODE_COPY_FROM_DEPTH", NULL} -#define STMT_136 \ +#define STMT_INSERT_WORKING_NODE_COPY_FROM_DEPTH 137 +#define STMT_137_INFO {"STMT_INSERT_WORKING_NODE_COPY_FROM_DEPTH", NULL} +#define STMT_137 \ "INSERT OR REPLACE INTO nodes ( " \ " wc_id, local_relpath, op_depth, parent_relpath, repos_id, " \ " repos_path, revision, presence, depth, moved_here, kind, changed_revision, " \ @@ -1464,49 +1478,49 @@ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?7 " \ "" -#define STMT_UPDATE_BASE_REVISION 137 -#define STMT_137_INFO {"STMT_UPDATE_BASE_REVISION", NULL} -#define STMT_137 \ +#define STMT_UPDATE_BASE_REVISION 138 +#define STMT_138_INFO {"STMT_UPDATE_BASE_REVISION", NULL} +#define STMT_138 \ "UPDATE nodes SET revision = ?3 " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \ "" -#define STMT_UPDATE_BASE_REPOS 138 -#define STMT_138_INFO {"STMT_UPDATE_BASE_REPOS", NULL} -#define STMT_138 \ +#define STMT_UPDATE_BASE_REPOS 139 +#define STMT_139_INFO {"STMT_UPDATE_BASE_REPOS", NULL} +#define STMT_139 \ "UPDATE nodes SET repos_id = ?3, repos_path = ?4 " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 " \ "" -#define STMT_ACTUAL_HAS_CHILDREN 139 -#define STMT_139_INFO {"STMT_ACTUAL_HAS_CHILDREN", NULL} -#define STMT_139 \ +#define STMT_ACTUAL_HAS_CHILDREN 140 +#define STMT_140_INFO {"STMT_ACTUAL_HAS_CHILDREN", NULL} +#define STMT_140 \ "SELECT 1 FROM actual_node " \ "WHERE wc_id = ?1 AND parent_relpath = ?2 " \ "LIMIT 1 " \ "" -#define STMT_INSERT_EXTERNAL 140 -#define STMT_140_INFO {"STMT_INSERT_EXTERNAL", NULL} -#define STMT_140 \ +#define STMT_INSERT_EXTERNAL 141 +#define STMT_141_INFO {"STMT_INSERT_EXTERNAL", NULL} +#define STMT_141 \ "INSERT OR REPLACE INTO externals ( " \ " wc_id, local_relpath, parent_relpath, presence, kind, def_local_relpath, " \ " repos_id, def_repos_relpath, def_operational_revision, def_revision) " \ "VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10) " \ "" -#define STMT_SELECT_EXTERNAL_INFO 141 -#define STMT_141_INFO {"STMT_SELECT_EXTERNAL_INFO", NULL} -#define STMT_141 \ +#define STMT_SELECT_EXTERNAL_INFO 142 +#define STMT_142_INFO {"STMT_SELECT_EXTERNAL_INFO", NULL} +#define STMT_142 \ "SELECT presence, kind, def_local_relpath, repos_id, " \ " def_repos_relpath, def_operational_revision, def_revision " \ "FROM externals WHERE wc_id = ?1 AND local_relpath = ?2 " \ "LIMIT 1 " \ "" -#define STMT_DELETE_FILE_EXTERNALS 142 -#define STMT_142_INFO {"STMT_DELETE_FILE_EXTERNALS", NULL} -#define STMT_142 \ +#define STMT_DELETE_FILE_EXTERNALS 143 +#define STMT_143_INFO {"STMT_DELETE_FILE_EXTERNALS", NULL} +#define STMT_143 \ "DELETE FROM nodes " \ "WHERE wc_id = ?1 " \ " AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ @@ -1514,26 +1528,26 @@ " AND file_external IS NOT NULL " \ "" -#define STMT_DELETE_FILE_EXTERNAL_REGISTATIONS 143 -#define STMT_143_INFO {"STMT_DELETE_FILE_EXTERNAL_REGISTATIONS", NULL} -#define STMT_143 \ +#define STMT_DELETE_FILE_EXTERNAL_REGISTATIONS 144 +#define STMT_144_INFO {"STMT_DELETE_FILE_EXTERNAL_REGISTATIONS", NULL} +#define STMT_144 \ "DELETE FROM externals " \ "WHERE wc_id = ?1 " \ " AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ " AND kind != 'dir' " \ "" -#define STMT_DELETE_EXTERNAL_REGISTATIONS 144 -#define STMT_144_INFO {"STMT_DELETE_EXTERNAL_REGISTATIONS", NULL} -#define STMT_144 \ +#define STMT_DELETE_EXTERNAL_REGISTATIONS 145 +#define STMT_145_INFO {"STMT_DELETE_EXTERNAL_REGISTATIONS", NULL} +#define STMT_145 \ "DELETE FROM externals " \ "WHERE wc_id = ?1 " \ " AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ "" -#define STMT_SELECT_COMMITTABLE_EXTERNALS_BELOW 145 -#define STMT_145_INFO {"STMT_SELECT_COMMITTABLE_EXTERNALS_BELOW", NULL} -#define STMT_145 \ +#define STMT_SELECT_COMMITTABLE_EXTERNALS_BELOW 146 +#define STMT_146_INFO {"STMT_SELECT_COMMITTABLE_EXTERNALS_BELOW", NULL} +#define STMT_146 \ "SELECT local_relpath, kind, def_repos_relpath, " \ " (SELECT root FROM repository AS r WHERE r.id = e.repos_id) " \ "FROM externals e " \ @@ -1551,9 +1565,9 @@ " AND nodes.local_relpath = e.parent_relpath)) " \ "" -#define STMT_SELECT_COMMITTABLE_EXTERNALS_IMMEDIATELY_BELOW 146 -#define STMT_146_INFO {"STMT_SELECT_COMMITTABLE_EXTERNALS_IMMEDIATELY_BELOW", NULL} -#define STMT_146 \ +#define STMT_SELECT_COMMITTABLE_EXTERNALS_IMMEDIATELY_BELOW 147 +#define STMT_147_INFO {"STMT_SELECT_COMMITTABLE_EXTERNALS_IMMEDIATELY_BELOW", NULL} +#define STMT_147 \ "SELECT local_relpath, kind, def_repos_relpath, " \ " (SELECT root FROM repository AS r WHERE r.id = e.repos_id) " \ "FROM externals e " \ @@ -1572,25 +1586,25 @@ " AND nodes.local_relpath = e.parent_relpath)) " \ "" -#define STMT_SELECT_EXTERNALS_DEFINED 147 -#define STMT_147_INFO {"STMT_SELECT_EXTERNALS_DEFINED", NULL} -#define STMT_147 \ +#define STMT_SELECT_EXTERNALS_DEFINED 148 +#define STMT_148_INFO {"STMT_SELECT_EXTERNALS_DEFINED", NULL} +#define STMT_148 \ "SELECT local_relpath, def_local_relpath " \ "FROM externals " \ "WHERE (wc_id = ?1 AND def_local_relpath = ?2) " \ " OR (wc_id = ?1 AND (((def_local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((def_local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \ "" -#define STMT_DELETE_EXTERNAL 148 -#define STMT_148_INFO {"STMT_DELETE_EXTERNAL", NULL} -#define STMT_148 \ +#define STMT_DELETE_EXTERNAL 149 +#define STMT_149_INFO {"STMT_DELETE_EXTERNAL", NULL} +#define STMT_149 \ "DELETE FROM externals " \ "WHERE wc_id = ?1 AND local_relpath = ?2 " \ "" -#define STMT_SELECT_EXTERNAL_PROPERTIES 149 -#define STMT_149_INFO {"STMT_SELECT_EXTERNAL_PROPERTIES", NULL} -#define STMT_149 \ +#define STMT_SELECT_EXTERNAL_PROPERTIES 150 +#define STMT_150_INFO {"STMT_SELECT_EXTERNAL_PROPERTIES", NULL} +#define STMT_150 \ "SELECT IFNULL((SELECT properties FROM actual_node a " \ " WHERE a.wc_id = ?1 AND A.local_relpath = n.local_relpath), " \ " properties), " \ @@ -1608,9 +1622,9 @@ " AND kind = 'dir' AND presence IN ('normal', 'incomplete') " \ "" -#define STMT_SELECT_CURRENT_PROPS_RECURSIVE 150 -#define STMT_150_INFO {"STMT_SELECT_CURRENT_PROPS_RECURSIVE", NULL} -#define STMT_150 \ +#define STMT_SELECT_CURRENT_PROPS_RECURSIVE 151 +#define STMT_151_INFO {"STMT_SELECT_CURRENT_PROPS_RECURSIVE", NULL} +#define STMT_151 \ "SELECT IFNULL((SELECT properties FROM actual_node a " \ " WHERE a.wc_id = ?1 AND A.local_relpath = n.local_relpath), " \ " properties), " \ @@ -1620,51 +1634,51 @@ " OR (wc_id = ?1 AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END))) " \ "" -#define STMT_PRAGMA_LOCKING_MODE 151 -#define STMT_151_INFO {"STMT_PRAGMA_LOCKING_MODE", NULL} -#define STMT_151 \ +#define STMT_PRAGMA_LOCKING_MODE 152 +#define STMT_152_INFO {"STMT_PRAGMA_LOCKING_MODE", NULL} +#define STMT_152 \ "PRAGMA locking_mode = exclusive; " \ "PRAGMA journal_mode = DELETE " \ "" -#define STMT_FIND_REPOS_PATH_IN_WC 152 -#define STMT_152_INFO {"STMT_FIND_REPOS_PATH_IN_WC", NULL} -#define STMT_152 \ +#define STMT_FIND_REPOS_PATH_IN_WC 153 +#define STMT_153_INFO {"STMT_FIND_REPOS_PATH_IN_WC", NULL} +#define STMT_153 \ "SELECT local_relpath FROM nodes_current " \ " WHERE wc_id = ?1 AND repos_path = ?2 " \ "" -#define STMT_INSERT_ACTUAL_NODE 153 -#define STMT_153_INFO {"STMT_INSERT_ACTUAL_NODE", NULL} -#define STMT_153 \ +#define STMT_INSERT_ACTUAL_NODE 154 +#define STMT_154_INFO {"STMT_INSERT_ACTUAL_NODE", NULL} +#define STMT_154 \ "INSERT OR REPLACE INTO actual_node ( " \ " wc_id, local_relpath, parent_relpath, properties, changelist, conflict_data) " \ "VALUES (?1, ?2, ?3, ?4, ?5, ?6) " \ "" -#define STMT_SELECT_ALL_FILES 154 -#define STMT_154_INFO {"STMT_SELECT_ALL_FILES", NULL} -#define STMT_154 \ +#define STMT_SELECT_ALL_FILES 155 +#define STMT_155_INFO {"STMT_SELECT_ALL_FILES", NULL} +#define STMT_155 \ "SELECT local_relpath FROM nodes_current " \ "WHERE wc_id = ?1 AND parent_relpath = ?2 AND kind = 'file' " \ "" -#define STMT_UPDATE_NODE_PROPS 155 -#define STMT_155_INFO {"STMT_UPDATE_NODE_PROPS", NULL} -#define STMT_155 \ +#define STMT_UPDATE_NODE_PROPS 156 +#define STMT_156_INFO {"STMT_UPDATE_NODE_PROPS", NULL} +#define STMT_156 \ "UPDATE nodes SET properties = ?4 " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \ "" -#define STMT_PRAGMA_TABLE_INFO_NODES 156 -#define STMT_156_INFO {"STMT_PRAGMA_TABLE_INFO_NODES", NULL} -#define STMT_156 \ +#define STMT_PRAGMA_TABLE_INFO_NODES 157 +#define STMT_157_INFO {"STMT_PRAGMA_TABLE_INFO_NODES", NULL} +#define STMT_157 \ "PRAGMA table_info(\"NODES\") " \ "" -#define STMT_CREATE_TARGET_PROP_CACHE 157 -#define STMT_157_INFO {"STMT_CREATE_TARGET_PROP_CACHE", NULL} -#define STMT_157 \ +#define STMT_CREATE_TARGET_PROP_CACHE 158 +#define STMT_158_INFO {"STMT_CREATE_TARGET_PROP_CACHE", NULL} +#define STMT_158 \ "DROP TABLE IF EXISTS target_prop_cache; " \ "CREATE TEMPORARY TABLE target_prop_cache ( " \ " local_relpath TEXT NOT NULL PRIMARY KEY, " \ @@ -1673,9 +1687,9 @@ "); " \ "" -#define STMT_CACHE_TARGET_PROPS 158 -#define STMT_158_INFO {"STMT_CACHE_TARGET_PROPS", NULL} -#define STMT_158 \ +#define STMT_CACHE_TARGET_PROPS 159 +#define STMT_159_INFO {"STMT_CACHE_TARGET_PROPS", NULL} +#define STMT_159 \ "INSERT INTO target_prop_cache(local_relpath, kind, properties) " \ " SELECT n.local_relpath, n.kind, " \ " IFNULL((SELECT properties FROM actual_node AS a " \ @@ -1694,9 +1708,9 @@ " ORDER BY t.local_relpath " \ "" -#define STMT_CACHE_TARGET_PRISTINE_PROPS 159 -#define STMT_159_INFO {"STMT_CACHE_TARGET_PRISTINE_PROPS", NULL} -#define STMT_159 \ +#define STMT_CACHE_TARGET_PRISTINE_PROPS 160 +#define STMT_160_INFO {"STMT_CACHE_TARGET_PRISTINE_PROPS", NULL} +#define STMT_160 \ "INSERT INTO target_prop_cache(local_relpath, kind, properties) " \ " SELECT n.local_relpath, n.kind, " \ " CASE n.presence " \ @@ -1721,22 +1735,22 @@ " ORDER BY t.local_relpath " \ "" -#define STMT_SELECT_ALL_TARGET_PROP_CACHE 160 -#define STMT_160_INFO {"STMT_SELECT_ALL_TARGET_PROP_CACHE", NULL} -#define STMT_160 \ +#define STMT_SELECT_ALL_TARGET_PROP_CACHE 161 +#define STMT_161_INFO {"STMT_SELECT_ALL_TARGET_PROP_CACHE", NULL} +#define STMT_161 \ "SELECT local_relpath, properties FROM target_prop_cache " \ "ORDER BY local_relpath " \ "" -#define STMT_DROP_TARGET_PROP_CACHE 161 -#define STMT_161_INFO {"STMT_DROP_TARGET_PROP_CACHE", NULL} -#define STMT_161 \ +#define STMT_DROP_TARGET_PROP_CACHE 162 +#define STMT_162_INFO {"STMT_DROP_TARGET_PROP_CACHE", NULL} +#define STMT_162 \ "DROP TABLE target_prop_cache; " \ "" -#define STMT_CREATE_REVERT_LIST 162 -#define STMT_162_INFO {"STMT_CREATE_REVERT_LIST", NULL} -#define STMT_162 \ +#define STMT_CREATE_REVERT_LIST 163 +#define STMT_163_INFO {"STMT_CREATE_REVERT_LIST", NULL} +#define STMT_163 \ "DROP TABLE IF EXISTS revert_list; " \ "CREATE TEMPORARY TABLE revert_list ( " \ " local_relpath TEXT NOT NULL, " \ @@ -1794,26 +1808,26 @@ "END " \ "" -#define STMT_DROP_REVERT_LIST_TRIGGERS 163 -#define STMT_163_INFO {"STMT_DROP_REVERT_LIST_TRIGGERS", NULL} -#define STMT_163 \ +#define STMT_DROP_REVERT_LIST_TRIGGERS 164 +#define STMT_164_INFO {"STMT_DROP_REVERT_LIST_TRIGGERS", NULL} +#define STMT_164 \ "DROP TRIGGER trigger_revert_list_nodes; " \ "DROP TRIGGER trigger_revert_list_actual_delete; " \ "DROP TRIGGER trigger_revert_list_actual_update " \ "" -#define STMT_SELECT_REVERT_LIST 164 -#define STMT_164_INFO {"STMT_SELECT_REVERT_LIST", NULL} -#define STMT_164 \ +#define STMT_SELECT_REVERT_LIST 165 +#define STMT_165_INFO {"STMT_SELECT_REVERT_LIST", NULL} +#define STMT_165 \ "SELECT actual, notify, kind, op_depth, repos_id, conflict_data " \ "FROM revert_list " \ "WHERE local_relpath = ?1 " \ "ORDER BY actual DESC " \ "" -#define STMT_SELECT_REVERT_LIST_COPIED_CHILDREN 165 -#define STMT_165_INFO {"STMT_SELECT_REVERT_LIST_COPIED_CHILDREN", NULL} -#define STMT_165 \ +#define STMT_SELECT_REVERT_LIST_COPIED_CHILDREN 166 +#define STMT_166_INFO {"STMT_SELECT_REVERT_LIST_COPIED_CHILDREN", NULL} +#define STMT_166 \ "SELECT local_relpath, kind " \ "FROM revert_list " \ "WHERE (((local_relpath) > (CASE (?1) WHEN '' THEN '' ELSE (?1) || '/' END)) AND ((local_relpath) < CASE (?1) WHEN '' THEN X'FFFF' ELSE (?1) || '0' END)) " \ @@ -1822,15 +1836,15 @@ "ORDER BY local_relpath " \ "" -#define STMT_DELETE_REVERT_LIST 166 -#define STMT_166_INFO {"STMT_DELETE_REVERT_LIST", NULL} -#define STMT_166 \ +#define STMT_DELETE_REVERT_LIST 167 +#define STMT_167_INFO {"STMT_DELETE_REVERT_LIST", NULL} +#define STMT_167 \ "DELETE FROM revert_list WHERE local_relpath = ?1 " \ "" -#define STMT_SELECT_REVERT_LIST_RECURSIVE 167 -#define STMT_167_INFO {"STMT_SELECT_REVERT_LIST_RECURSIVE", NULL} -#define STMT_167 \ +#define STMT_SELECT_REVERT_LIST_RECURSIVE 168 +#define STMT_168_INFO {"STMT_SELECT_REVERT_LIST_RECURSIVE", NULL} +#define STMT_168 \ "SELECT p.local_relpath, n.kind, a.notify, a.kind " \ "FROM (SELECT DISTINCT local_relpath " \ " FROM revert_list " \ @@ -1841,32 +1855,32 @@ "ORDER BY p.local_relpath " \ "" -#define STMT_DELETE_REVERT_LIST_RECURSIVE 168 -#define STMT_168_INFO {"STMT_DELETE_REVERT_LIST_RECURSIVE", NULL} -#define STMT_168 \ +#define STMT_DELETE_REVERT_LIST_RECURSIVE 169 +#define STMT_169_INFO {"STMT_DELETE_REVERT_LIST_RECURSIVE", NULL} +#define STMT_169 \ "DELETE FROM revert_list " \ "WHERE (local_relpath = ?1 " \ " OR (((local_relpath) > (CASE (?1) WHEN '' THEN '' ELSE (?1) || '/' END)) AND ((local_relpath) < CASE (?1) WHEN '' THEN X'FFFF' ELSE (?1) || '0' END))) " \ "" -#define STMT_DROP_REVERT_LIST 169 -#define STMT_169_INFO {"STMT_DROP_REVERT_LIST", NULL} -#define STMT_169 \ +#define STMT_DROP_REVERT_LIST 170 +#define STMT_170_INFO {"STMT_DROP_REVERT_LIST", NULL} +#define STMT_170 \ "DROP TABLE IF EXISTS revert_list " \ "" -#define STMT_CREATE_DELETE_LIST 170 -#define STMT_170_INFO {"STMT_CREATE_DELETE_LIST", NULL} -#define STMT_170 \ +#define STMT_CREATE_DELETE_LIST 171 +#define STMT_171_INFO {"STMT_CREATE_DELETE_LIST", NULL} +#define STMT_171 \ "DROP TABLE IF EXISTS delete_list; " \ "CREATE TEMPORARY TABLE delete_list ( " \ " local_relpath TEXT PRIMARY KEY NOT NULL UNIQUE " \ " ) " \ "" -#define STMT_INSERT_DELETE_LIST 171 -#define STMT_171_INFO {"STMT_INSERT_DELETE_LIST", NULL} -#define STMT_171 \ +#define STMT_INSERT_DELETE_LIST 172 +#define STMT_172_INFO {"STMT_INSERT_DELETE_LIST", NULL} +#define STMT_172 \ "INSERT INTO delete_list(local_relpath) " \ "SELECT ?2 " \ "UNION ALL " \ @@ -1882,22 +1896,22 @@ "ORDER by local_relpath " \ "" -#define STMT_SELECT_DELETE_LIST 172 -#define STMT_172_INFO {"STMT_SELECT_DELETE_LIST", NULL} -#define STMT_172 \ +#define STMT_SELECT_DELETE_LIST 173 +#define STMT_173_INFO {"STMT_SELECT_DELETE_LIST", NULL} +#define STMT_173 \ "SELECT local_relpath FROM delete_list " \ "ORDER BY local_relpath " \ "" -#define STMT_FINALIZE_DELETE 173 -#define STMT_173_INFO {"STMT_FINALIZE_DELETE", NULL} -#define STMT_173 \ +#define STMT_FINALIZE_DELETE 174 +#define STMT_174_INFO {"STMT_FINALIZE_DELETE", NULL} +#define STMT_174 \ "DROP TABLE IF EXISTS delete_list " \ "" -#define STMT_CREATE_UPDATE_MOVE_LIST 174 -#define STMT_174_INFO {"STMT_CREATE_UPDATE_MOVE_LIST", NULL} -#define STMT_174 \ +#define STMT_CREATE_UPDATE_MOVE_LIST 175 +#define STMT_175_INFO {"STMT_CREATE_UPDATE_MOVE_LIST", NULL} +#define STMT_175 \ "DROP TABLE IF EXISTS update_move_list; " \ "CREATE TEMPORARY TABLE update_move_list ( " \ " local_relpath TEXT PRIMARY KEY NOT NULL UNIQUE, " \ @@ -1908,39 +1922,39 @@ " ) " \ "" -#define STMT_INSERT_UPDATE_MOVE_LIST 175 -#define STMT_175_INFO {"STMT_INSERT_UPDATE_MOVE_LIST", NULL} -#define STMT_175 \ +#define STMT_INSERT_UPDATE_MOVE_LIST 176 +#define STMT_176_INFO {"STMT_INSERT_UPDATE_MOVE_LIST", NULL} +#define STMT_176 \ "INSERT INTO update_move_list(local_relpath, action, kind, content_state, " \ " prop_state) " \ "VALUES (?1, ?2, ?3, ?4, ?5) " \ "" -#define STMT_SELECT_UPDATE_MOVE_LIST 176 -#define STMT_176_INFO {"STMT_SELECT_UPDATE_MOVE_LIST", NULL} -#define STMT_176 \ +#define STMT_SELECT_UPDATE_MOVE_LIST 177 +#define STMT_177_INFO {"STMT_SELECT_UPDATE_MOVE_LIST", NULL} +#define STMT_177 \ "SELECT local_relpath, action, kind, content_state, prop_state " \ "FROM update_move_list " \ "ORDER BY local_relpath " \ "" -#define STMT_FINALIZE_UPDATE_MOVE 177 -#define STMT_177_INFO {"STMT_FINALIZE_UPDATE_MOVE", NULL} -#define STMT_177 \ +#define STMT_FINALIZE_UPDATE_MOVE 178 +#define STMT_178_INFO {"STMT_FINALIZE_UPDATE_MOVE", NULL} +#define STMT_178 \ "DROP TABLE IF EXISTS update_move_list " \ "" -#define STMT_MOVE_NOTIFY_TO_REVERT 178 -#define STMT_178_INFO {"STMT_MOVE_NOTIFY_TO_REVERT", NULL} -#define STMT_178 \ +#define STMT_MOVE_NOTIFY_TO_REVERT 179 +#define STMT_179_INFO {"STMT_MOVE_NOTIFY_TO_REVERT", NULL} +#define STMT_179 \ "INSERT INTO revert_list (local_relpath, notify, kind, actual) " \ " SELECT local_relpath, 2, kind, 1 FROM update_move_list; " \ "DROP TABLE update_move_list " \ "" -#define STMT_SELECT_MIN_MAX_REVISIONS 179 -#define STMT_179_INFO {"STMT_SELECT_MIN_MAX_REVISIONS", NULL} -#define STMT_179 \ +#define STMT_SELECT_MIN_MAX_REVISIONS 180 +#define STMT_180_INFO {"STMT_SELECT_MIN_MAX_REVISIONS", NULL} +#define STMT_180 \ "SELECT MIN(revision), MAX(revision), " \ " MIN(changed_revision), MAX(changed_revision) FROM nodes " \ " WHERE wc_id = ?1 " \ @@ -1951,9 +1965,9 @@ " AND op_depth = 0 " \ "" -#define STMT_HAS_SPARSE_NODES 180 -#define STMT_180_INFO {"STMT_HAS_SPARSE_NODES", NULL} -#define STMT_180 \ +#define STMT_HAS_SPARSE_NODES 181 +#define STMT_181_INFO {"STMT_HAS_SPARSE_NODES", NULL} +#define STMT_181 \ "SELECT 1 FROM nodes " \ "WHERE wc_id = ?1 " \ " AND (local_relpath = ?2 " \ @@ -1965,9 +1979,9 @@ "LIMIT 1 " \ "" -#define STMT_SUBTREE_HAS_TREE_MODIFICATIONS 181 -#define STMT_181_INFO {"STMT_SUBTREE_HAS_TREE_MODIFICATIONS", NULL} -#define STMT_181 \ +#define STMT_SUBTREE_HAS_TREE_MODIFICATIONS 182 +#define STMT_182_INFO {"STMT_SUBTREE_HAS_TREE_MODIFICATIONS", NULL} +#define STMT_182 \ "SELECT 1 FROM nodes " \ "WHERE wc_id = ?1 " \ " AND (local_relpath = ?2 " \ @@ -1976,9 +1990,9 @@ "LIMIT 1 " \ "" -#define STMT_SUBTREE_HAS_PROP_MODIFICATIONS 182 -#define STMT_182_INFO {"STMT_SUBTREE_HAS_PROP_MODIFICATIONS", NULL} -#define STMT_182 \ +#define STMT_SUBTREE_HAS_PROP_MODIFICATIONS 183 +#define STMT_183_INFO {"STMT_SUBTREE_HAS_PROP_MODIFICATIONS", NULL} +#define STMT_183 \ "SELECT 1 FROM actual_node " \ "WHERE wc_id = ?1 " \ " AND (local_relpath = ?2 " \ @@ -1987,9 +2001,9 @@ "LIMIT 1 " \ "" -#define STMT_HAS_SWITCHED 183 -#define STMT_183_INFO {"STMT_HAS_SWITCHED", NULL} -#define STMT_183 \ +#define STMT_HAS_SWITCHED 184 +#define STMT_184_INFO {"STMT_HAS_SWITCHED", NULL} +#define STMT_184 \ "SELECT 1 " \ "FROM nodes " \ "WHERE wc_id = ?1 " \ @@ -2001,47 +2015,47 @@ "LIMIT 1 " \ "" -#define STMT_SELECT_MOVED_FROM_RELPATH 184 -#define STMT_184_INFO {"STMT_SELECT_MOVED_FROM_RELPATH", NULL} -#define STMT_184 \ +#define STMT_SELECT_MOVED_FROM_RELPATH 185 +#define STMT_185_INFO {"STMT_SELECT_MOVED_FROM_RELPATH", NULL} +#define STMT_185 \ "SELECT local_relpath, op_depth FROM nodes " \ "WHERE wc_id = ?1 AND moved_to = ?2 AND op_depth > 0 " \ "" -#define STMT_UPDATE_MOVED_TO_RELPATH 185 -#define STMT_185_INFO {"STMT_UPDATE_MOVED_TO_RELPATH", NULL} -#define STMT_185 \ +#define STMT_UPDATE_MOVED_TO_RELPATH 186 +#define STMT_186_INFO {"STMT_UPDATE_MOVED_TO_RELPATH", NULL} +#define STMT_186 \ "UPDATE nodes SET moved_to = ?4 " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \ "" -#define STMT_CLEAR_MOVED_TO_RELPATH 186 -#define STMT_186_INFO {"STMT_CLEAR_MOVED_TO_RELPATH", NULL} -#define STMT_186 \ +#define STMT_CLEAR_MOVED_TO_RELPATH 187 +#define STMT_187_INFO {"STMT_CLEAR_MOVED_TO_RELPATH", NULL} +#define STMT_187 \ "UPDATE nodes SET moved_to = NULL " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3 " \ "" -#define STMT_CLEAR_MOVED_HERE_RECURSIVE 187 -#define STMT_187_INFO {"STMT_CLEAR_MOVED_HERE_RECURSIVE", NULL} -#define STMT_187 \ +#define STMT_CLEAR_MOVED_HERE_RECURSIVE 188 +#define STMT_188_INFO {"STMT_CLEAR_MOVED_HERE_RECURSIVE", NULL} +#define STMT_188 \ "UPDATE nodes SET moved_here = NULL " \ "WHERE wc_id = ?1 " \ " 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))) " \ " AND op_depth = ?3 " \ "" -#define STMT_SELECT_MOVED_HERE_CHILDREN 188 -#define STMT_188_INFO {"STMT_SELECT_MOVED_HERE_CHILDREN", NULL} -#define STMT_188 \ +#define STMT_SELECT_MOVED_HERE_CHILDREN 189 +#define STMT_189_INFO {"STMT_SELECT_MOVED_HERE_CHILDREN", NULL} +#define STMT_189 \ "SELECT moved_to, local_relpath FROM nodes " \ "WHERE wc_id = ?1 AND op_depth > 0 " \ " AND (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ "" -#define STMT_SELECT_MOVED_FOR_DELETE 189 -#define STMT_189_INFO {"STMT_SELECT_MOVED_FOR_DELETE", NULL} -#define STMT_189 \ +#define STMT_SELECT_MOVED_FOR_DELETE 190 +#define STMT_190_INFO {"STMT_SELECT_MOVED_FOR_DELETE", NULL} +#define STMT_190 \ "SELECT local_relpath, moved_to, op_depth, " \ " (SELECT CASE WHEN r.moved_here THEN r.op_depth END FROM nodes r " \ " WHERE r.wc_id = ?1 " \ @@ -2055,9 +2069,9 @@ " AND op_depth >= ?3 " \ "" -#define STMT_SELECT_MOVED_FROM_FOR_DELETE 190 -#define STMT_190_INFO {"STMT_SELECT_MOVED_FROM_FOR_DELETE", NULL} -#define STMT_190 \ +#define STMT_SELECT_MOVED_FROM_FOR_DELETE 191 +#define STMT_191_INFO {"STMT_SELECT_MOVED_FROM_FOR_DELETE", NULL} +#define STMT_191 \ "SELECT local_relpath, op_depth, " \ " (SELECT CASE WHEN r.moved_here THEN r.op_depth END FROM nodes r " \ " WHERE r.wc_id = ?1 " \ @@ -2068,25 +2082,25 @@ "WHERE wc_id = ?1 AND moved_to = ?2 AND op_depth > 0 " \ "" -#define STMT_UPDATE_MOVED_TO_DESCENDANTS 191 -#define STMT_191_INFO {"STMT_UPDATE_MOVED_TO_DESCENDANTS", NULL} -#define STMT_191 \ +#define STMT_UPDATE_MOVED_TO_DESCENDANTS 192 +#define STMT_192_INFO {"STMT_UPDATE_MOVED_TO_DESCENDANTS", NULL} +#define STMT_192 \ "UPDATE nodes SET moved_to = (CASE WHEN (?2) = '' THEN (CASE WHEN (?3) = '' THEN (moved_to) WHEN (moved_to) = '' THEN (?3) ELSE (?3) || '/' || (moved_to) END) WHEN (?3) = '' THEN (CASE WHEN (?2) = '' THEN (moved_to) WHEN SUBSTR((moved_to), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(moved_to) THEN '' WHEN SUBSTR((moved_to), LENGTH(?2)+1, 1) = '/' THEN SUBSTR((moved_to), LENGTH(?2)+2) END END) WHEN SUBSTR((moved_to), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(moved_to) THEN (?3) WHEN SUBSTR((moved_to), LENGTH(?2)+1, 1) = '/' THEN (?3) || SUBSTR((moved_to), LENGTH(?2)+1) END END) " \ " WHERE wc_id = ?1 " \ " AND (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ "" -#define STMT_CLEAR_MOVED_TO_DESCENDANTS 192 -#define STMT_192_INFO {"STMT_CLEAR_MOVED_TO_DESCENDANTS", NULL} -#define STMT_192 \ +#define STMT_CLEAR_MOVED_TO_DESCENDANTS 193 +#define STMT_193_INFO {"STMT_CLEAR_MOVED_TO_DESCENDANTS", NULL} +#define STMT_193 \ "UPDATE nodes SET moved_to = NULL " \ " WHERE wc_id = ?1 " \ " AND (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ "" -#define STMT_SELECT_MOVED_PAIR3 193 -#define STMT_193_INFO {"STMT_SELECT_MOVED_PAIR3", NULL} -#define STMT_193 \ +#define STMT_SELECT_MOVED_PAIR3 194 +#define STMT_194_INFO {"STMT_SELECT_MOVED_PAIR3", NULL} +#define STMT_194 \ "SELECT n.local_relpath, d.moved_to, d.op_depth, n.kind " \ "FROM nodes n " \ "JOIN nodes d ON d.wc_id = ?1 AND d.local_relpath = n.local_relpath " \ @@ -2112,9 +2126,9 @@ "ORDER BY n.local_relpath " \ "" -#define STMT_SELECT_MOVED_OUTSIDE 194 -#define STMT_194_INFO {"STMT_SELECT_MOVED_OUTSIDE", NULL} -#define STMT_194 \ +#define STMT_SELECT_MOVED_OUTSIDE 195 +#define STMT_195_INFO {"STMT_SELECT_MOVED_OUTSIDE", NULL} +#define STMT_195 \ "SELECT local_relpath, moved_to, op_depth FROM nodes " \ "WHERE wc_id = ?1 " \ " 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))) " \ @@ -2123,9 +2137,9 @@ " AND NOT (((moved_to) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((moved_to) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ "" -#define STMT_SELECT_MOVED_DESCENDANTS_SRC 195 -#define STMT_195_INFO {"STMT_SELECT_MOVED_DESCENDANTS_SRC", NULL} -#define STMT_195 \ +#define STMT_SELECT_MOVED_DESCENDANTS_SRC 196 +#define STMT_196_INFO {"STMT_SELECT_MOVED_DESCENDANTS_SRC", NULL} +#define STMT_196 \ "SELECT s.op_depth, n.local_relpath, n.kind, n.repos_path, s.moved_to " \ "FROM nodes n " \ "JOIN nodes s ON s.wc_id = n.wc_id AND s.local_relpath = n.local_relpath " \ @@ -2139,9 +2153,9 @@ " AND s.moved_to IS NOT NULL " \ "" -#define STMT_COMMIT_UPDATE_ORIGIN 196 -#define STMT_196_INFO {"STMT_COMMIT_UPDATE_ORIGIN", NULL} -#define STMT_196 \ +#define STMT_COMMIT_UPDATE_ORIGIN 197 +#define STMT_197_INFO {"STMT_COMMIT_UPDATE_ORIGIN", NULL} +#define STMT_197 \ "UPDATE nodes SET repos_id = ?4, " \ " repos_path = (CASE WHEN (?2) = '' THEN (CASE WHEN (?5) = '' THEN (local_relpath) WHEN (local_relpath) = '' THEN (?5) ELSE (?5) || '/' || (local_relpath) END) WHEN (?5) = '' THEN (CASE WHEN (?2) = '' THEN (local_relpath) WHEN SUBSTR((local_relpath), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(local_relpath) THEN '' WHEN SUBSTR((local_relpath), LENGTH(?2)+1, 1) = '/' THEN SUBSTR((local_relpath), LENGTH(?2)+2) END END) WHEN SUBSTR((local_relpath), 1, LENGTH(?2)) = (?2) THEN CASE WHEN LENGTH(?2) = LENGTH(local_relpath) THEN (?5) WHEN SUBSTR((local_relpath), LENGTH(?2)+1, 1) = '/' THEN (?5) || SUBSTR((local_relpath), LENGTH(?2)+1) END END), " \ " revision = ?6 " \ @@ -2151,16 +2165,16 @@ " AND op_depth = ?3 " \ "" -#define STMT_HAS_LAYER_BETWEEN 197 -#define STMT_197_INFO {"STMT_HAS_LAYER_BETWEEN", NULL} -#define STMT_197 \ +#define STMT_HAS_LAYER_BETWEEN 198 +#define STMT_198_INFO {"STMT_HAS_LAYER_BETWEEN", NULL} +#define STMT_198 \ "SELECT 1 FROM NODES " \ "WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > ?3 AND op_depth < ?4 " \ "" -#define STMT_SELECT_REPOS_PATH_REVISION 198 -#define STMT_198_INFO {"STMT_SELECT_REPOS_PATH_REVISION", NULL} -#define STMT_198 \ +#define STMT_SELECT_REPOS_PATH_REVISION 199 +#define STMT_199_INFO {"STMT_SELECT_REPOS_PATH_REVISION", NULL} +#define STMT_199 \ "SELECT local_relpath, repos_path, revision FROM nodes " \ "WHERE wc_id = ?1 " \ " AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ @@ -2168,17 +2182,17 @@ "ORDER BY local_relpath " \ "" -#define STMT_SELECT_HAS_NON_FILE_CHILDREN 199 -#define STMT_199_INFO {"STMT_SELECT_HAS_NON_FILE_CHILDREN", NULL} -#define STMT_199 \ +#define STMT_SELECT_HAS_NON_FILE_CHILDREN 200 +#define STMT_200_INFO {"STMT_SELECT_HAS_NON_FILE_CHILDREN", NULL} +#define STMT_200 \ "SELECT 1 FROM nodes " \ "WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = ?3 AND kind != 'file' " \ "LIMIT 1 " \ "" -#define STMT_SELECT_HAS_GRANDCHILDREN 200 -#define STMT_200_INFO {"STMT_SELECT_HAS_GRANDCHILDREN", NULL} -#define STMT_200 \ +#define STMT_SELECT_HAS_GRANDCHILDREN 201 +#define STMT_201_INFO {"STMT_SELECT_HAS_GRANDCHILDREN", NULL} +#define STMT_201 \ "SELECT 1 FROM nodes " \ "WHERE wc_id = ?1 " \ " AND (((parent_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((parent_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ @@ -2187,24 +2201,24 @@ "LIMIT 1 " \ "" -#define STMT_SELECT_ALL_NODES 201 -#define STMT_201_INFO {"STMT_SELECT_ALL_NODES", NULL} -#define STMT_201 \ +#define STMT_SELECT_ALL_NODES 202 +#define STMT_202_INFO {"STMT_SELECT_ALL_NODES", NULL} +#define STMT_202 \ "SELECT op_depth, local_relpath, parent_relpath, file_external FROM nodes " \ "WHERE wc_id = ?1 " \ "" -#define STMT_UPDATE_IPROP 202 -#define STMT_202_INFO {"STMT_UPDATE_IPROP", NULL} -#define STMT_202 \ +#define STMT_UPDATE_IPROP 203 +#define STMT_203_INFO {"STMT_UPDATE_IPROP", NULL} +#define STMT_203 \ "UPDATE nodes " \ "SET inherited_props = ?3 " \ "WHERE (wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0) " \ "" -#define STMT_SELECT_IPROPS_NODE 203 -#define STMT_203_INFO {"STMT_SELECT_IPROPS_NODE", NULL} -#define STMT_203 \ +#define STMT_SELECT_IPROPS_NODE 204 +#define STMT_204_INFO {"STMT_SELECT_IPROPS_NODE", NULL} +#define STMT_204 \ "SELECT local_relpath, repos_path FROM nodes " \ "WHERE wc_id = ?1 " \ " AND local_relpath = ?2 " \ @@ -2212,9 +2226,9 @@ " AND (inherited_props not null) " \ "" -#define STMT_SELECT_IPROPS_RECURSIVE 204 -#define STMT_204_INFO {"STMT_SELECT_IPROPS_RECURSIVE", NULL} -#define STMT_204 \ +#define STMT_SELECT_IPROPS_RECURSIVE 205 +#define STMT_205_INFO {"STMT_SELECT_IPROPS_RECURSIVE", NULL} +#define STMT_205 \ "SELECT local_relpath, repos_path FROM nodes " \ "WHERE wc_id = ?1 " \ " AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) " \ @@ -2222,9 +2236,9 @@ " AND (inherited_props not null) " \ "" -#define STMT_SELECT_IPROPS_CHILDREN 205 -#define STMT_205_INFO {"STMT_SELECT_IPROPS_CHILDREN", NULL} -#define STMT_205 \ +#define STMT_SELECT_IPROPS_CHILDREN 206 +#define STMT_206_INFO {"STMT_SELECT_IPROPS_CHILDREN", NULL} +#define STMT_206 \ "SELECT local_relpath, repos_path FROM nodes " \ "WHERE wc_id = ?1 " \ " AND parent_relpath = ?2 " \ @@ -2232,16 +2246,30 @@ " AND (inherited_props not null) " \ "" -#define STMT_HAVE_STAT1_TABLE 206 -#define STMT_206_INFO {"STMT_HAVE_STAT1_TABLE", NULL} -#define STMT_206 \ +#define STMT_HAVE_STAT1_TABLE 207 +#define STMT_207_INFO {"STMT_HAVE_STAT1_TABLE", NULL} +#define STMT_207 \ "SELECT 1 FROM sqlite_master WHERE name='sqlite_stat1' AND type='table' " \ "LIMIT 1 " \ "" -#define STMT_CREATE_SCHEMA 207 -#define STMT_207_INFO {"STMT_CREATE_SCHEMA", NULL} -#define STMT_207 \ +#define STMT_SELECT_COPIES_OF_REPOS_RELPATH 208 +#define STMT_208_INFO {"STMT_SELECT_COPIES_OF_REPOS_RELPATH", NULL} +#define STMT_208 \ + "SELECT local_relpath " \ + "FROM nodes n " \ + "WHERE wc_id = ?1 AND repos_path = ?2 AND kind = ?3 " \ + " AND presence = 'normal' " \ + " AND op_depth = (SELECT MAX(op_depth) " \ + " FROM NODES w " \ + " WHERE w.wc_id = ?1 " \ + " AND w.local_relpath = n.local_relpath) " \ + "ORDER BY local_relpath ASC " \ + "" + +#define STMT_CREATE_SCHEMA 209 +#define STMT_209_INFO {"STMT_CREATE_SCHEMA", NULL} +#define STMT_209 \ "CREATE TABLE REPOSITORY ( " \ " id INTEGER PRIMARY KEY AUTOINCREMENT, " \ " root TEXT UNIQUE NOT NULL, " \ @@ -2382,9 +2410,9 @@ "; " \ "" -#define STMT_INSTALL_SCHEMA_STATISTICS 208 -#define STMT_208_INFO {"STMT_INSTALL_SCHEMA_STATISTICS", NULL} -#define STMT_208 \ +#define STMT_INSTALL_SCHEMA_STATISTICS 210 +#define STMT_210_INFO {"STMT_INSTALL_SCHEMA_STATISTICS", NULL} +#define STMT_210 \ "ANALYZE sqlite_master; " \ "DELETE FROM sqlite_stat1 " \ "WHERE tbl in ('NODES', 'ACTUAL_NODE', 'LOCK', 'WC_LOCK', 'EXTERNALS'); " \ @@ -2409,9 +2437,9 @@ "ANALYZE sqlite_master; " \ "" -#define STMT_UPGRADE_TO_30 209 -#define STMT_209_INFO {"STMT_UPGRADE_TO_30", NULL} -#define STMT_209 \ +#define STMT_UPGRADE_TO_30 211 +#define STMT_211_INFO {"STMT_UPGRADE_TO_30", NULL} +#define STMT_211 \ "CREATE UNIQUE INDEX IF NOT EXISTS I_NODES_MOVED " \ "ON NODES (wc_id, moved_to, op_depth); " \ "CREATE INDEX IF NOT EXISTS I_PRISTINE_MD5 ON PRISTINE (md5_checksum); " \ @@ -2419,9 +2447,9 @@ "UPDATE nodes SET file_external=1 WHERE file_external IS NOT NULL; " \ "" -#define STMT_UPGRADE_30_SELECT_CONFLICT_SEPARATE 210 -#define STMT_210_INFO {"STMT_UPGRADE_30_SELECT_CONFLICT_SEPARATE", NULL} -#define STMT_210 \ +#define STMT_UPGRADE_30_SELECT_CONFLICT_SEPARATE 212 +#define STMT_212_INFO {"STMT_UPGRADE_30_SELECT_CONFLICT_SEPARATE", NULL} +#define STMT_212 \ "SELECT wc_id, local_relpath, " \ " conflict_old, conflict_working, conflict_new, prop_reject, tree_conflict_data " \ "FROM actual_node " \ @@ -2433,18 +2461,18 @@ "ORDER by wc_id, local_relpath " \ "" -#define STMT_UPGRADE_30_SET_CONFLICT 211 -#define STMT_211_INFO {"STMT_UPGRADE_30_SET_CONFLICT", NULL} -#define STMT_211 \ +#define STMT_UPGRADE_30_SET_CONFLICT 213 +#define STMT_213_INFO {"STMT_UPGRADE_30_SET_CONFLICT", NULL} +#define STMT_213 \ "UPDATE actual_node SET conflict_data = ?3, conflict_old = NULL, " \ " conflict_working = NULL, conflict_new = NULL, prop_reject = NULL, " \ " tree_conflict_data = NULL " \ "WHERE wc_id = ?1 and local_relpath = ?2 " \ "" -#define STMT_UPGRADE_TO_31 212 -#define STMT_212_INFO {"STMT_UPGRADE_TO_31", NULL} -#define STMT_212 \ +#define STMT_UPGRADE_TO_31 214 +#define STMT_214_INFO {"STMT_UPGRADE_TO_31", NULL} +#define STMT_214 \ "ALTER TABLE NODES ADD COLUMN inherited_props BLOB; " \ "DROP INDEX IF EXISTS I_ACTUAL_CHANGELIST; " \ "DROP INDEX IF EXISTS I_EXTERNALS_PARENT; " \ @@ -2457,9 +2485,9 @@ "PRAGMA user_version = 31; " \ "" -#define STMT_UPGRADE_31_SELECT_WCROOT_NODES 213 -#define STMT_213_INFO {"STMT_UPGRADE_31_SELECT_WCROOT_NODES", NULL} -#define STMT_213 \ +#define STMT_UPGRADE_31_SELECT_WCROOT_NODES 215 +#define STMT_215_INFO {"STMT_UPGRADE_31_SELECT_WCROOT_NODES", NULL} +#define STMT_215 \ "SELECT l.wc_id, l.local_relpath FROM nodes as l " \ "LEFT OUTER JOIN nodes as r " \ "ON l.wc_id = r.wc_id " \ @@ -2511,9 +2539,9 @@ "DROP TABLE ACTUAL_NODE_BACKUP; " \ "" -#define STMT_VERIFICATION_TRIGGERS 214 -#define STMT_214_INFO {"STMT_VERIFICATION_TRIGGERS", NULL} -#define STMT_214 \ +#define STMT_VERIFICATION_TRIGGERS 216 +#define STMT_216_INFO {"STMT_VERIFICATION_TRIGGERS", NULL} +#define STMT_216 \ "CREATE TEMPORARY TRIGGER no_repository_updates BEFORE UPDATE ON repository " \ "BEGIN " \ " SELECT RAISE(FAIL, 'Updates to REPOSITORY are not allowed.'); " \ @@ -2552,9 +2580,9 @@ "END; " \ "" -#define STMT_STATIC_VERIFY 215 -#define STMT_215_INFO {"STMT_STATIC_VERIFY", NULL} -#define STMT_215 \ +#define STMT_STATIC_VERIFY 217 +#define STMT_217_INFO {"STMT_STATIC_VERIFY", NULL} +#define STMT_217 \ "SELECT local_relpath, op_depth, 1, 'Invalid parent relpath set in NODES' " \ "FROM nodes n WHERE local_relpath != '' " \ " AND (parent_relpath IS NULL " \ @@ -2943,6 +2971,8 @@ STMT_213, \ STMT_214, \ STMT_215, \ + STMT_216, \ + STMT_217, \ NULL \ } @@ -3164,5 +3194,7 @@ STMT_213_INFO, \ STMT_214_INFO, \ STMT_215_INFO, \ + STMT_216_INFO, \ + STMT_217_INFO, \ {NULL, NULL} \ } |