You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@subversion.apache.org by ph...@apache.org on 2010/12/09 18:13:50 UTC
svn commit: r1044040 - /subversion/trunk/subversion/libsvn_wc/wc-queries.sql
Author: philip
Date: Thu Dec 9 17:13:50 2010
New Revision: 1044040
URL: http://svn.apache.org/viewvc?rev=1044040&view=rev
Log:
* subversion/libsvn_wc/wc-queries.sql
(STMT_COPY_NODES_ROW, STMT_COPY_NODES_AT_SAME_OP_DEPTH,
STMT_COPY_NODES_AT_GREATER_OP_DEPTH, STMT_COPY_ACTUAL_NODE_ROWS,
STMT_DELETE_ACTUAL_NODE_WITHOUT_CHANGELIST,
STMT_UPDATE_NODE_BASE_PRESENCE_KIND): Remove unused queries.
Modified:
subversion/trunk/subversion/libsvn_wc/wc-queries.sql
Modified: subversion/trunk/subversion/libsvn_wc/wc-queries.sql
URL: http://svn.apache.org/viewvc/subversion/trunk/subversion/libsvn_wc/wc-queries.sql?rev=1044040&r1=1044039&r2=1044040&view=diff
==============================================================================
--- subversion/trunk/subversion/libsvn_wc/wc-queries.sql (original)
+++ subversion/trunk/subversion/libsvn_wc/wc-queries.sql Thu Dec 9 17:13:50 2010
@@ -320,11 +320,6 @@ WHERE wc_id = ?1 AND local_relpath = ?2;
DELETE FROM actual_node
WHERE wc_id = ?1 AND local_relpath = ?2;
--- STMT_DELETE_ACTUAL_NODE_WITHOUT_CHANGELIST
-DELETE FROM actual_node
-WHERE wc_id = ?1 AND local_relpath = ?2
- AND changelist IS NULL;
-
-- STMT_DELETE_ACTUAL_NODE_WITHOUT_CONFLICT
DELETE FROM actual_node
WHERE wc_id = ?1 AND local_relpath = ?2
@@ -387,10 +382,6 @@ WHERE wc_id = ?1 AND local_relpath = ?2
UPDATE nodes SET presence = ?3
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;
--- STMT_UPDATE_NODE_BASE_PRESENCE_KIND
-UPDATE nodes SET presence = ?3, kind = ?4
-WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;
-
-- STMT_UPDATE_NODE_WORKING_PRESENCE
UPDATE nodes SET presence = ?3
WHERE wc_id = ?1 AND local_relpath = ?2
@@ -598,75 +589,6 @@ SELECT 1 FROM nodes WHERE wc_id = ?1 AND
AND op_depth = (SELECT MAX(op_depth) FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0);
-
--- STMT_COPY_NODES_ROW
-INSERT OR REPLACE INTO nodes (
- wc_id, local_relpath, op_depth, parent_relpath,
- repos_id, repos_path, revision, presence, /* moved_here, moved_to, */
- kind, properties, depth, checksum, symlink_target,
- changed_revision, changed_date, changed_author,
- translated_size, last_mod_time /* dav_cache, file_external */ )
-SELECT wc_id,
- ?4 /*dst_relpath*/,
- ?6 /*dst_op_depth*/,
- ?5 /*dst_parent_*/,
- repos_id, repos_path, revision, presence, /* moved_here, moved_to, */
- kind, properties, depth, checksum, symlink_target,
- changed_revision, changed_date, changed_author,
- translated_size, last_mod_time /* dav_cache, file_external */
-FROM nodes
-WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3;
-
--- STMT_COPY_NODES_AT_SAME_OP_DEPTH
-INSERT OR REPLACE INTO nodes (
- wc_id, local_relpath, op_depth, parent_relpath,
- repos_id, repos_path, revision, presence, /* moved_here, moved_to, */
- kind, properties, depth, checksum, symlink_target,
- changed_revision, changed_date, changed_author,
- translated_size, last_mod_time /* dav_cache, file_external */ )
-SELECT wc_id,
- ?4 /*dst_relpath*/ || SUBSTR(local_relpath, ?6 /*LEN(src_relpath)+1*/),
- ?5 /*dst_depth*/,
- ?4 /*dst_relpath*/ || SUBSTR(parent_relpath, ?6 /*LEN(src_relpath)+1*/),
- repos_id, repos_path, revision, presence, /* moved_here, moved_to, */
- kind, properties, depth, checksum, symlink_target,
- changed_revision, changed_date, changed_author,
- translated_size, last_mod_time /* dav_cache, file_external */
-FROM nodes
-WHERE wc_id = ?1 AND local_relpath LIKE ?2 ESCAPE '#' AND op_depth = ?3;
-
--- STMT_COPY_NODES_AT_GREATER_OP_DEPTH
-INSERT OR REPLACE INTO nodes (
- wc_id, local_relpath, op_depth, parent_relpath,
- repos_id, repos_path, revision, presence, /* moved_here, moved_to, */
- kind, properties, depth, checksum, symlink_target,
- changed_revision, changed_date, changed_author,
- translated_size, last_mod_time /* dav_cache, file_external */ )
-SELECT wc_id,
- ?4 /*dst_relpath*/ || SUBSTR(local_relpath, ?6 /*LEN(src_relpath)+1*/),
- op_depth + ?5 /*dst_depth*/ - ?3 /*src_depth*/,
- ?4 /*dst_relpath*/ || SUBSTR(parent_relpath, ?6 /*LEN(src_relpath)+1*/),
- repos_id, repos_path, revision, presence, /* moved_here, moved_to, */
- kind, properties, depth, checksum, symlink_target,
- changed_revision, changed_date, changed_author,
- translated_size, last_mod_time /* dav_cache, file_external */
-FROM nodes
-WHERE wc_id = ?1 AND local_relpath LIKE ?2 ESCAPE '#' AND op_depth > ?3;
-
--- STMT_COPY_ACTUAL_NODE_ROWS
-INSERT OR REPLACE INTO actual_node (
- wc_id, local_relpath, parent_relpath, properties,
- conflict_old, conflict_new, conflict_working,
- prop_reject, changelist, text_mod, tree_conflict_data )
-SELECT wc_id,
- ?4 /*dst_relpath*/ || SUBSTR(local_relpath, ?6 /*LEN(src_relpath)+1*/),
- ?5 /*dst_parent_*/ || SUBSTR(parent_relpath, ?7 /*LEN(src_parent_)+1*/),
- properties,
- conflict_old, conflict_new, conflict_working,
- prop_reject, changelist, text_mod, tree_conflict_data
-FROM actual_node
-WHERE wc_id = ?1 AND (local_relpath = ?2 OR local_relpath LIKE ?3 ESCAPE '#');
-
-- STMT_SELECT_ABSENT_NODES
SELECT local_relpath FROM nodes
WHERE wc_id = ?1 AND (local_relpath = ?2 OR local_relpath LIKE ?3 ESCAPE '#')