class |
SVNWCDbDeleteActualEmpties |
DELETE FROM actual_node
WHERE wc_id = ?1
AND properties IS NULL
AND conflict_old IS NULL
AND conflict_new IS NULL
AND prop_reject IS NULL
AND changelist IS NULL
AND text_mod IS NULL
AND tree_conflict_data IS NULL
AND older_checksum IS NULL
AND right_checksum IS NULL
AND left_checksum IS NULL
|
class |
SVNWCDbDeleteActualEmpty |
DELETE FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2 AND
properties IS NULL AND conflict_old IS NULL AND conflict_new IS NULL AND
prop_reject IS NULL AND changelist IS NULL AND text_mod IS NULL AND
tree_conflict_data IS NULL AND older_checksum IS NULL AND right_checksum IS
NULL AND left_checksum IS NULL;
|
class |
SVNWCDbDeleteActualForBaseRecursive |
DELETE FROM actual_node
WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2)
AND EXISTS(SELECT 1 FROM NODES b
WHERE b.wc_id = ?1
AND b.local_relpath = actual_node.local_relpath
AND op_depth = 0)
AND NOT EXISTS(SELECT 1 FROM NODES w
WHERE w.wc_id = ?1
AND w.local_relpath = actual_node.local_relpath
AND op_depth > 0
AND presence in (MAP_NORMAL, MAP_INCOMPLETE, MAP_NOT_PRESENT))
|
class |
SVNWCDbDeleteActualNode |
DELETE FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2;
|
class |
SVNWCDbDeleteActualNodeLeavingChangelist |
-- STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE
DELETE FROM actual_node
WHERE wc_id = ?1 AND local_relpaht = ?2
AND (changelist IS NULL
OR NOT EXISTS (SELECT 1 FROM nodes_current c
WHERE c.wc_id = ?1 AND c.local_relpath = local_relpath
AND kind = 'file'))
|
class |
SVNWCDbDeleteActualNodeLeavingChangelistRecursive |
-- STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE
DELETE FROM actual_node
WHERE wc_id = ?1
AND (?2 = ''
OR local_relpath = ?2
OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0'))
AND (changelist IS NULL
OR NOT EXISTS (SELECT 1 FROM nodes_current c
WHERE c.wc_id = ?1 AND c.local_relpath = local_relpath
AND kind = 'file'))
|
class |
SVNWCDbDeleteActualNodeRecursive |
-- STMT_DELETE_ACTUAL_NODE_RECURSIVE
DELETE FROM actual_node
WHERE wc_id = ?1
AND (?2 = ''
OR local_relpath = ?2
OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
|
class |
SVNWCDbDeleteActualNodeWithoutConflict |
DELETE FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2 AND
tree_conflict_data IS NULL;
|
class |
SVNWCDbDeleteAllLayers |
-- STMT_DELETE_ALL_LAYERS
DELETE FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2
|
class |
SVNWCDbDeleteAllWorkingNodes |
DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0;
|
class |
SVNWCDbDeleteBaseNode |
DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;
|
class |
SVNWCDbDeleteBaseRecursive |
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
|
class |
SVNWCDbDeleteExternalRegistrations |
DELETE FROM externals
WHERE wc_id = ?1
AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2)
|
class |
SVNWCDbDeleteFileExternalRegistrations |
DELETE FROM externals
WHERE wc_id = ?1
AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2)
AND kind != MAP_DIR
|
class |
SVNWCDbDeleteFileExternals |
DELETE FROM nodes
WHERE wc_id = ?1
AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2)
AND op_depth = 0
AND file_external IS NOT NULL
|
class |
SVNWCDbDeleteLock |
DELETE FROM lock
WHERE repos_id = ?1 AND repos_relpath = ?2
|
class |
SVNWCDbDeleteLockOrphanRecursive |
DELETE FROM wc_lock
WHERE wc_id = ?1
AND (?2 = ''
OR local_dir_relpath = ?2
OR (local_dir_relpath > ?2 || '/' AND local_dir_relpath < ?2 || '0'))
AND NOT EXISTS (SELECT 1 FROM nodes
WHERE nodes.wc_id = ?1
AND nodes.local_relpath = wc_lock.local_dir_relpath)
|
class |
SVNWCDbDeleteLockRecursively |
|
class |
SVNWCDbDeleteLowestWorkingNode |
DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth =
(SELECT MIN(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth > 0) AND presence = 'base-deleted';
|
class |
SVNWCDbDeleteMovedBack |
DELETE FROM nodes
WHERE wc_id = ?1
AND (local_relpath = ?2
OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
AND op_depth = ?3
|
class |
SVNWCDbDeleteNodes |
DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2;
|
class |
SVNWCDbDeleteNodesAboveDepthRecursive |
|
class |
SVNWCDbDeleteNodesRecursive |
DELETE FROM nodes
WHERE wc_id = ?1
AND (?2 = ''
OR local_relpath = ?2
OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0'))
AND op_depth >= ?3
|
class |
SVNWCDbDeleteNoLowerLayer |
|
class |
SVNWCDbDeletePristine |
DELETE FROM pristine WHERE checksum = ?1
|
class |
SVNWCDbDeletePristineIfUnreferenced |
-- STMT_DELETE_PRISTINE_IF_UNREFERENCED
DELETE FROM pristine
WHERE checksum = ?1 AND refcount = 0
|
class |
SVNWCDbDeleteShadowedRecursive |
-- STMT_DELETE_SHADOWED_RECURSIVE
DELETE FROM nodes
WHERE wc_id = ?1
AND (local_relpath = ?2
OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
AND (op_depth < ?3
OR (op_depth = ?3 AND presence = 'base-deleted')) *
|
class |
SVNWCDbDeleteWCLock |
DELETE FROM wc_lock WHERE wc_id = ?1 AND local_dir_relpath = ?2;
|
class |
SVNWCDbDeleteWCLockOrphan |
DELETE FROM wc_lock
WHERE wc_id = ?1 AND local_dir_relpath = ?2
AND NOT EXISTS (SELECT 1 FROM nodes
WHERE nodes.wc_id = ?1
AND nodes.local_relpath = wc_lock.local_dir_relpath)
|
class |
SVNWCDbDeleteWorkingBaseDelete |
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'
AND op_depth > 0
AND op_depth = (SELECT MIN(op_depth) FROM nodes n
WHERE n.wc_id = ?1
AND n.local_relpath = nodes.local_relpath
AND op_depth > 0)
|
class |
SVNWCDbDeleteWorkingNode |
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);
|
class |
SVNWCDbDeleteWorkingOpDepth |
|
class |
SVNWCDbDeleteWorkingOpDepthAbove |
|
class |
SVNWCDbDeleteWorkingRecursive |
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
|
class |
SVNWCDbDeleteWorkItem |
DELETE FROM work_queue WHERE id = ?1;
|