Package | Description |
---|---|
org.tmatesoft.svn.core.internal.wc17.db.statement |
Modifier and Type | Class and Description |
---|---|
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;
|
Copyright © 2020. All rights reserved.