Modifier and Type | Class and Description |
---|---|
class |
SVNSqlJetDeleteStatement |
class |
SVNSqlJetSelectFieldsStatement<E extends java.lang.Enum<E>> |
class |
SVNSqlJetUpdateStatement |
Modifier and Type | Class and Description |
---|---|
class |
SVNFSFSRevPropGet |
Modifier and Type | Class and Description |
---|---|
private static class |
SvnWcDbCopy.SelectNodeToCopy
SELECT wc_id, ?3 (local_relpath), ?4 (op_depth), ?5 (parent_relpath),
repos_id, repos_path, revision, ?6 (presence), depth,
kind, changed_revision, changed_date, changed_author, checksum, properties,
translated_size, last_mod_time, symlink_target
FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0
ORDER BY op_depth DESC
LIMIT 1
or for base:
FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0
|
private static class |
SvnWcDbProperties.SelectRowWithMaxOpDepth |
private static class |
SvnWcDbRelocate.RecursiveUpdateNodeRepo
UPDATE nodes SET repos_id = ?4, dav_cache = NULL
WHERE wc_id = ?1
AND repos_id = ?3
AND (?2 = ''
OR local_relpath = ?2
OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0'))
|
private static class |
SvnWcDbRelocate.UpdateLockReposId
UPDATE lock SET repos_id = ?2
WHERE repos_id = ?1
|
Modifier and Type | Class and Description |
---|---|
class |
SVNUpdateBaseNodePresenceRevnumAndReposPath
UPDATE nodes SET presence = ?3, revision = ?4, repos_path = ?5 WHERE wc_id =
?1 AND local_relpath = ?2 AND op_depth = 0;
|
class |
SVNWCDbClearActualNodeLeavingChangelist
UPDATE actual_node SET conflict_old = NULL, conflict_new = NULL,
conflict_working = NULL
WHERE wc_id = ?1 AND local_relpath = ?2;
|
class |
SVNWCDbClearActualNodeLeavingChangelistRecursive
UPDATE actual_node SET conflict_old = NULL, conflict_new = NULL,
conflict_working = NULL
WHERE wc_id = ?1
AND (?2 = ''
OR local_relpath = ?2
OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0'))
|
class |
SVNWCDbClearActualNodeLeavingConflict
UPDATE actual_node SET properties = NULL, text_mod = NULL, changelist = NULL,
tree_conflict_data = NULL, conflict_old = NULL, conflict_new = NULL,
conflict_working = NULL, prop_reject = NULL, older_checksum = NULL,
left_checksum = NULL, right_checksum = NULL WHERE wc_id = ?1 and
local_relpath = ?2;
|
class |
SVNWCDbClearDavCacheRecursive
-- STMT_CLEAR_BASE_NODE_RECURSIVE_DAV_CACHE
UPDATE nodes SET dav_cache = NULL
WHERE
dav_cache IS NOT NULL
AND wc_id = ?1
AND op_depth = 0
AND (?2 = ''
OR local_relpath = ?2
OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
primary index: wc_id, local_relpath, op_depth
|
class |
SVNWCDbClearMovedHereRecursive
UPDATE nodes SET moved_here = NULL
WHERE wc_id = ?1
AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
AND op_depth = ?3
|
class |
SVNWCDbClearMovedToDescendants
UPDATE nodes SET moved_to = NULL
WHERE wc_id = ?1
AND IS_STRICT_DESCENDANT_OF(moved_to, ?2)
|
class |
SVNWCDbClearMovedToFromDest
UPDATE NODES SET moved_to = NULL
WHERE wc_id = ?1
AND moved_to = ?2
|
class |
SVNWCDbClearMovedToRelPath |
class |
SVNWCDbClearPropsConflict
UPDATE actual_node SET prop_reject = NULL WHERE wc_id = ?1 AND local_relpath
= ?2;
|
class |
SVNWCDbClearTextConflict
UPDATE actual_node SET conflict_old = NULL, conflict_new = NULL,
conflict_working = NULL WHERE wc_id = ?1 AND local_relpath = ?2;
|
class |
SVNWCDbCollectTargets |
class |
SVNWCDbCommitDescendantToBase
-- STMT_COMMIT_DESCENDANT_TO_BASE
UPDATE NODES SET op_depth = 0, repos_id = ?4, repos_path = ?5, revision = ?6,
moved_here = NULL, moved_to = NULL, dav_cache = NULL,
presence = CASE presence WHEN 'normal' THEN 'normal'
WHEN 'excluded' THEN 'excluded'
ELSE 'not-present' END
WHERE wc_id = ?1 AND local_relpath = ?2 and op_depth = ?3
|
private static class |
SVNWCDbCopyMoveNode.InternalSelectStatement |
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))
|
private static class |
SVNWCDbDeleteActualForBaseRecursive.SelectFromNodesForPresence |
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;
|
class |
SVNWCDBDoesNodeExists
SELECT 1 FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2
LIMIT 1
|
class |
SVNWCDbFindWCLock
SELECT local_dir_relpath FROM wc_lock WHERE wc_id = ?1 AND local_dir_relpath
LIKE ?2 ESCAPE '#';
|
class |
SVNWCDbHasLayerBetween |
class |
SVNWCDbHasServerExcludedDescendants
SELECT local_relpath FROM nodes
WHERE wc_id = ?1
AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2)
AND op_depth = 0 AND presence = MAP_SERVER_EXCLUDED
LIMIT 1
|
class |
SVNWCDbHasServerExcludedNodes |
private static class |
SVNWCDbInsertWorkingNodeCopyFrom.InternalStatement1 |
private static class |
SVNWCDbInsertWorkingNodeCopyFrom.InternalStatement2 |
class |
SVNWCDbLookForWork
SELECT id FROM work_queue LIMIT 1
|
class |
SVNWCDbNodesBase
CREATE VIEW NODES_BASE AS
SELECT * FROM nodes
WHERE op_depth = 0;
|
class |
SVNWCDbNodesCurrent
CREATE VIEW NODES_CURRENT AS
SELECT * FROM nodes AS n
WHERE op_depth = (SELECT MAX(op_depth) FROM nodes AS n2
WHERE n2.wc_id = n.wc_id
AND n2.local_relpath = n.local_relpath);
|
class |
SVNWCDbNodesMaxOpDepth |
class |
SVNWCDbNodesMinOpDepth |
class |
SVNWCDbNodesStrictOpDepth |
private static class |
SVNWCDbReplaceWithBaseDeleted.InternalSelectStatement |
class |
SVNWCDbSelectActualChildrenConflict
SELECT local_relpath, tree_conflict_data FROM actual_node WHERE wc_id = ?1 AND
parent_relpath = ?2 AND tree_conflict_data IS NOT NULL;
|
class |
SVNWCDbSelectActualChildrenInfo
SELECT local_relpath, changelist, properties, conflict_data
FROM actual_node
WHERE wc_id = ?1 AND parent_relpath = ?2
|
class |
SVNWCDbSelectActualConflictVictims
SELECT local_relpath FROM actual_node WHERE wc_id = ?1 AND parent_relpath =
?2 AND NOT((prop_reject IS NULL) AND (conflict_old IS NULL) AND (conflict_new
IS NULL) AND (conflict_working IS NULL) AND (tree_conflict_data IS NULL))
|
class |
SVNWCDbSelectActualNode
select prop_reject, changelist, conflict_old, conflict_new,
conflict_working, tree_conflict_data, properties from actual_node
where wc_id = ?1 and local_relpath = ?2;
|
class |
SVNWCDbSelectActualProperties
select properties from actual_node where wc_id = ?1 and local_relpath = ?2;
|
class |
SVNWCDbSelectActualTreeConflict
SELECT tree_conflict_data FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2
AND tree_conflict_data IS NOT NULL;
|
class |
SVNWCDbSelectAllFiles
-- STMT_SELECT_ALL_FILES
SELECT DISTINCT local_relpath FROM nodes
WHERE wc_id = ?1 AND parent_relpath = ?2 AND kind = 'file'
|
class |
SVNWCDbSelectAllServerExcludedNodes
-- STMT_SELECT_ALL_SERVER_EXCLUDED_NODES
SELECT local_relpath FROM nodes
WHERE wc_id = ?1
AND (?2 = ''
OR local_relpath = ?2
OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
AND op_depth = 0
AND presence = 'absent'
|
class |
SVNWCDbSelectAncestorWCLocks
SELECT local_dir_relpath, locked_levels FROM wc_lock
WHERE wc_id = ?1
AND ((local_dir_relpath <= ?2 AND local_dir_relpath >= ?3)
OR local_dir_relpath = '')
ORDER BY local_dir_relpath DESC
|
class |
SVNWCDbSelectBaseChildrenInfo |
class |
SVNWCDbSelectBaseDavCache
-- STMT_SELECT_BASE_DAV_CACHE
SELECT dav_cache FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0
|
class |
SVNWCDbSelectBaseNode
SELECT repos_id, repos_path, presence, kind, revision, checksum,
translated_size, changed_revision, changed_date, changed_author, depth,
symlink_target, last_mod_time, properties FROM nodes WHERE wc_id = ?1 AND
local_relpath = ?2 AND op_depth = 0;
|
class |
SVNWCDbSelectBaseNodeChildren
SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND
op_depth = 0;
|
class |
SVNWCDbSelectBaseNodeLockTokensRecursive |
private static class |
SVNWCDbSelectBaseNodeLockTokensRecursive.JoinedStatement |
class |
SVNWCDbSelectBaseNodeWithLock
SELECT 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,
lock_comment, lock_date FROM nodes LEFT OUTER JOIN lock ON nodes.repos_id =
lock.repos_id AND nodes.repos_path = lock.repos_relpath WHERE wc_id = ?1 AND
local_relpath = ?2 AND op_depth = 0;
|
private static class |
SVNWCDbSelectBaseNodeWithLock.LockStatement |
class |
SVNWCDbSelectBasePresent
SELECT local_relpath, kind FROM nodes n
WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2)
AND op_depth = 0
AND presence in (MAP_NORMAL, MAP_INCOMPLETE)
AND NOT EXISTS(SELECT 1 FROM NODES w
WHERE w.wc_id = ?1 AND w.local_relpath = n.local_relpath
AND op_depth > 0)
ORDER BY local_relpath DESC
|
class |
SVNWCDbSelectBaseProperties
SELECT properties FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth = 0;
|
class |
SVNWCDbSelectChangelist
STMT_SELECT_CHANGELIST_LIST
SELECT wc_id, local_relpath, notify, changelist
FROM changelist_list
ORDER BY wc_id, local_relpath
|
class |
SVNWCDbSelectChildrenOpDepth |
class |
SVNWCDbSelectCommittableExternalsBelow |
class |
SVNWCDbSelectCommittableExternalsImmediatelyBelow
SELECT local_relpath, kind, def_repos_relpath,
(SELECT root FROM repository AS r WHERE r.id = e.repos_id)
FROM externals e
WHERE wc_id = ?1
AND IS_STRICT_DESCENDANT_OF(e.local_relpath, ?2)
AND parent_relpath = ?2
AND def_revision IS NULL
AND repos_id = (SELECT repos_id
FROM nodes AS n
WHERE n.wc_id = ?1
AND n.local_relpath = ''
AND n.op_depth = 0)
AND ((kind='dir')
OR EXISTS (SELECT 1 FROM nodes
WHERE nodes.wc_id = e.wc_id
AND nodes.local_relpath = e.parent_relpath))
|
private static class |
SVNWCDbSelectCommittableExternalsImmediatelyBelow.InternalStatement1 |
private static class |
SVNWCDbSelectCommittableExternalsImmediatelyBelow.InternalStatement2 |
private static class |
SVNWCDbSelectCommittableExternalsImmediatelyBelow.InternalStatement3 |
class |
SVNWCDbSelectConflictDetails
SELECT prop_reject, conflict_old, conflict_new, conflict_working, tree_conflict_data FROM
actual_node WHERE wc_id = ?1 AND local_relpath = ?2;
|
class |
SVNWCDbSelectConflictVictims |
class |
SVNWCDbSelectCopyPristines
SELECT n.checksum, md5_checksum, size
FROM nodes_current n
LEFT JOIN pristine p ON n.checksum = p.checksum
WHERE wc_id = ?1
AND n.local_relpath = ?2
AND n.checksum IS NOT NULL
UNION ALL
SELECT n.checksum, md5_checksum, size
FROM nodes n
LEFT JOIN pristine p ON n.checksum = p.checksum
WHERE wc_id = ?1
AND IS_STRICT_DESCENDANT_OF(n.local_relpath, ?2)
AND op_depth >=
(SELECT MAX(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2)
AND n.checksum IS NOT NULL
|
private static class |
SVNWCDbSelectCopyPristines.JoinedStatement |
class |
SVNWCDbSelectDeletionInfo
SELECT (SELECT b.presence FROM nodes AS b
WHERE b.wc_id = ?1 AND b.local_relpath = ?2 AND b.op_depth = 0),
work.presence, work.op_depth
FROM nodes_current AS work
WHERE work.wc_id = ?1 AND work.local_relpath = ?2 AND work.op_depth > 0
LIMIT 1
|
static class |
SVNWCDbSelectDeletionInfo.InternalSelect |
class |
SVNWCDbSelectDeletionInfoScan |
private static class |
SVNWCDbSelectDeletionInfoScan.JoinedStatement |
class |
SVNWCDbSelectDepthNode
SELECT repos_id, repos_path, presence, kind, revision, checksum,
translated_size, changed_revision, changed_date, changed_author, depth,
symlink_target, last_mod_time, properties
FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3
|
class |
SVNWCDBSelectExternalProperties
SELECT IFNULL((SELECT properties FROM actual_node a
WHERE a.wc_id = ?1 AND A.local_relpath = n.local_relpath),
properties),
local_relpath, depth
FROM nodes n
WHERE wc_id = ?1
AND (?2 = ''
OR local_relpath = ?2
OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0'))
AND kind = 'dir' AND presence='normal'
AND op_depth=(SELECT MAX(op_depth) FROM nodes o
WHERE o.wc_id = ?1 AND o.local_relpath = n.local_relpath)
|
class |
SVNWCDBSelectExternalsDefined
SELECT local_relpath, def_local_relpath
FROM externals
WHERE wc_id = ?1
AND (?2 = ''
OR def_local_relpath = ?2
OR (def_local_relpath > ?2 || '/' AND def_local_relpath < ?2 || '0'))
|
class |
SVNWCDBSelectFileExternal
SELECT file_external FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth = 0;
|
class |
SVNWCDbSelectGeOpDepthChildren |
class |
SVNWCDbSelectHasGrandChildren
SELECT 1 FROM nodes
WHERE wc_id = ?1
AND IS_STRICT_DESCENDANT_OF(parent_relpath, ?2)
AND op_depth = 0
AND file_external IS NULL
|
class |
SVNWCDbSelectHasNonFileChildren
SELECT 1 FROM nodes
WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = 0 AND kind != MAP_FILE
|
class |
SVNWCDbSelectHighestWorkingNode |
class |
SVNWCDbSelectIPropsNode
SELECT local_relpath, repos_path FROM nodes
WHERE wc_id = ?1
AND local_relpath = ?2
AND op_depth = 0
AND (inherited_props not null)
|
class |
SVNWCDbSelectLocalRelPathOpDepth |
class |
SVNWCDbSelectLock |
class |
SVNWCDbSelectLowestWorkingNode
SELECT op_depth, presence, kind, moved_to
FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > ?3
ORDER BY op_depth
LIMIT 1
|
class |
SVNWCDbSelectMinMaxRevisions
SELECT MIN(revision), MAX(revision),
MIN(changed_revision), MAX(changed_revision) FROM nodes
WHERE wc_id = ?1
AND (local_relpath = ?2
OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
AND presence IN (MAP_NORMAL, MAP_INCOMPLETE)
AND file_external IS NULL
AND op_depth = 0
|
class |
SVNWCDbSelectMovedBack |
private static class |
SVNWCDbSelectMovedBack.JoinedStatement |
class |
SVNWCDbSelectMovedForDelete
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
AND r.local_relpath = n.local_relpath
AND r.op_depth < n.op_depth
BY r.op_depth DESC LIMIT 1) AS moved_here_op_depth
FROM nodes n
WHERE wc_id = ?1
AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
AND moved_to IS NOT NULL
AND op_depth >= ?3
|
private static class |
SVNWCDbSelectMovedForDelete.InternalStatement |
class |
SVNWCDbSelectMovedFromForDelete
SELECT local_relpath, op_depth,
(SELECT CASE WHEN r.moved_here THEN r.op_depth END FROM nodes r
WHERE r.wc_id = ?1
AND r.local_relpath = n.local_relpath
AND r.op_depth < n.op_depth
ORDER BY r.op_depth DESC LIMIT 1) AS moved_here_op_depth
FROM nodes n
WHERE wc_id = ?1 AND moved_to = ?2 AND op_depth > 0
|
private static class |
SVNWCDbSelectMovedFromForDelete.InternalStatement |
class |
SVNWCDbSelectMovedFromRelPath
SELECT local_relpath, op_depth FROM nodes
WHERE wc_id = ?1 AND moved_to = ?2 AND op_depth > 0
|
class |
SVNWCDbSelectMovedHereChildren
SELECT moved_to, local_relpath FROM nodes
WHERE wc_id = ?1 AND op_depth > 0
AND IS_STRICT_DESCENDANT_OF(moved_to, ?2)
|
class |
SVNWCDbSelectMovedOutside
SELECT local_relpath, moved_to FROM nodes
WHERE wc_id = ?1
AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
AND op_depth >= ?3
AND moved_to IS NOT NULL
AND NOT IS_STRICT_DESCENDANT_OF(moved_to, ?2)
|
class |
SVNWCDbSelectMovedPair3
SELECT local_relpath, moved_to, op_depth, kind FROM nodes
WHERE wc_id = ?1
AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
AND op_depth > ?3
AND moved_to IS NOT NULL
|
class |
SVNWCDbSelectMovedTo
SELECT moved_to
FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3
|
class |
SVNWCDbSelectNodeChildrenInfo
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,
lock_comment, lock_date, local_relpath
FROM nodes
LEFT OUTER JOIN lock ON nodes.repos_id = lock.repos_id
AND nodes.repos_path = lock.repos_relpath
WHERE wc_id = ?1 AND parent_relpath = ?2
|
private static class |
SVNWCDbSelectNodeChildrenInfo.LockStatement |
class |
SVNWCDbSelectNodeChildrenWalkerInfo
SELECT local_relpath, op_depth, presence, kind
FROM nodes
WHERE wc_id = ?1 AND parent_relpath = ?2
GROUP BY local_relpath
ORDER BY op_depth DESC
We omit GROUP BY, it is not really needed, and ORDER BY is achieved by use of a reverse cursor.
|
class |
SVNWCDbSelectNodeInfo
SELECT op_depth, repos_id, repos_path, presence, kind, revision, checksum,
translated_size, changed_revision, changed_date, changed_author, depth,
symlink_target, last_mod_time, properties
FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2
ORDER BY op_depth DESC
|
class |
SVNWCDbSelectNodeInfoWithLock
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,
lock_comment, lock_date
FROM nodes
LEFT OUTER JOIN lock ON nodes.repos_id = lock.repos_id
AND nodes.repos_path = lock.repos_relpath
WHERE wc_id = ?1 AND local_relpath = ?2
ORDER BY op_depth DESC
|
private static class |
SVNWCDbSelectNodeInfoWithLock.LockStatement |
class |
SVNWCDbSelectNodeProps
SELECT properties, presence FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2
ORDER BY op_depth DESC;
|
class |
SVNWCDbSelectNotPresent
-- STMT_SELECT_NOT_PRESENT_DESCENDANTS
SELECT local_relpath FROM nodes
WHERE wc_id = ?1 AND op_depth = ?3
AND (parent_relpath = ?2
OR IS_STRICT_DESCENDANT_OF(parent_relpath, ?2))
AND presence == 'not-present'
|
class |
SVNWCDbSelectOpDepthChildren
SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND
op_depth = ?3;
|
class |
SVNWCDbSelectOpDepthMovedPair |
class |
SVNWCDbSelectPristineMD5Checksum
SELECT md5_checksum FROM pristine WHERE checksum = ?1
|
class |
SVNWCDbSelectRepository
SELECT id FROM repository WHERE root = ?1;
|
class |
SVNWCDbSelectRepositoryById
select root, uuid from repository where id = ?1;
|
class |
SVNWCDbSelectReposPathRevision |
class |
SVNWCDbSelectRevertListCopiedChildren |
class |
SVNWCDbSelectSHA1Checksum
SELECT checksum FROM pristine WHERE md5_checksum = ?1
|
class |
SVNWCDbSelectTargetslist
SELECT local_relpath FROM targets_list
WHERE kind = 'file' AND wc_id = ?1
|
class |
SVNWCDbSelectUnreferencedPristines
-- STMT_SELECT_UNREFERENCED_PRISTINES
SELECT checksum
FROM pristine
WHERE refcount = 0
|
class |
SVNWCDbSelectUpdateMoveList |
class |
SVNWCDbSelectWCLock
SELECT locked_levels FROM WC_LOCK WHERE wc_id = ?1 AND local_dir_relpath =
?2;
|
class |
SVNWCDbSelectWCRootNodes |
class |
SVNWCDbSelectWCRootNull
select id from wcroot where local_abspath is null;
|
class |
SVNWCDbSelectWorkingChildren
SELECT local_relpath FROM nodes
WHERE wc_id = ?1 AND parent_relpath = ?2
AND (op_depth > (SELECT MAX(op_depth) FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2)
OR
(op_depth = (SELECT MAX(op_depth) FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2)
AND presence != 'base-deleted'))
|
class |
SVNWCDbSelectWorkingNode
SELECT presence, kind, checksum, translated_size, changed_revision,
changed_date, changed_author, depth, symlink_target, repos_id, repos_path,
revision, moved_here, moved_to, last_mod_time, properties FROM nodes WHERE
wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0 ORDER BY op_depth DESC
LIMIT 1;
|
class |
SVNWCDbSelectWorkingNodeChildren
SELECT local_relpath FROM nodes
WHERE wc_id = ?1 AND parent_relpath = ?2
AND (op_depth > (SELECT MAX(op_depth) FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2)
OR
(op_depth = (SELECT MAX(op_depth) FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2)
AND presence != 'base-deleted'))
|
class |
SVNWCDbSelectWorkItem
SELECT id, work FROM work_queue ORDER BY id LIMIT 1;
|
class |
SVNWCDbUpdateActualChangelists
UPDATE actual_node SET changelist = ?3
WHERE wc_id = ?1 AND local_relpath = ?2
|
class |
SVNWCDbUpdateActualConflict |
class |
SVNWCDbUpdateActualConflictData
UPDATE actual_node SET conflict_data = ?3 WHERE wc_id = ?1 AND local_relpath
= ?2;
|
class |
SVNWCDbUpdateActualPropertyConflicts
UPDATE actual_node SET prop_reject = ?3 WHERE wc_id = ?1 AND local_relpath =
?2;
|
class |
SVNWCDbUpdateActualProps
UPDATE actual_node SET properties = ?3 WHERE wc_id = ?1 AND local_relpath =
?2;
|
class |
SVNWCDbUpdateActualTextConflicts
UPDATE actual_node SET conflict_old = ?3, conflict_new = ?4, conflict_working
= ?5 WHERE wc_id = ?1 AND local_relpath = ?2;
|
class |
SVNWCDbUpdateActualTreeConflicts
UPDATE actual_node SET tree_conflict_data = ?3 WHERE wc_id = ?1 AND
local_relpath = ?2;
|
class |
SVNWCDbUpdateBaseNodeDavCache
-- STMT_UPDATE_BASE_NODE_DAV_CACHE
UPDATE nodes SET dav_cache = ?3
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0
|
class |
SVNWCDbUpdateBaseRevision
UPDATE nodes SET revision = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth = 0;
|
class |
SVNWCDbUpdateCopyfrom
UPDATE nodes SET repos_id = ?3, repos_path = ?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 AND op_depth > 0);
|
class |
SVNWCDbUpdateIProps |
class |
SVNWCDbUpdateMovedToDescendants
UPDATE nodes SET moved_to = RELPATH_SKIP_JOIN(?2, ?3, moved_to)
WHERE wc_id = ?1
AND IS_STRICT_DESCENDANT_OF(moved_to, ?2)
|
class |
SVNWCDbUpdateMovedToRelPath
UPDATE nodes SET moved_to = ?4
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3
|
class |
SVNWCDbUpdateNodeBaseDepth
UPDATE nodes SET depth = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth = 0;
|
class |
SVNWCDbUpdateNodeBasePresence
UPDATE nodes SET presence = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth = 0;
|
class |
SVNWCDbUpdateNodeFileinfo
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);
|
class |
SVNWCDbUpdateNodeProperties
-- STMT_UPDATE_NODE_PROPS
UPDATE nodes SET properties = ?4
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3
|
class |
SVNWCDbUpdateNodeWorkingDepth
UPDATE nodes SET depth = ?3 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 |
SVNWCDbUpdateOpDepthIncreaseRecursive |
class |
SVNWCDbUpdateOpDepthRecursive |
class |
SVNWCDDBUpdateActualClearChangelist |
Modifier and Type | Field and Description |
---|---|
private SVNSqlJetSelectStatement |
SVNWCDbInsertTargetDepthImmediatesWithChangelist.actualNode |
private SVNSqlJetSelectStatement |
SVNWCDbInsertTargetWithChangelist.actualNode |
private SVNSqlJetSelectStatement |
SVNWCDbInsertTargetDepthInfinityWithChangelist.actualNode |
private SVNSqlJetSelectStatement |
SVNWCDbInsertTargetDepthFilesWithChangelist.actualNode |
private SVNSqlJetSelectStatement |
SVNWCDbInsertWorkingNodeCopyFrom.internalStatement1 |
private SVNSqlJetSelectStatement |
SVNWCDbInsertWorkingNodeCopyFrom.internalStatement2 |
private SVNSqlJetSelectStatement |
SVNWCDbInsertTargetDepthImmediatesWithChangelist.nodeCurrent |
private SVNSqlJetSelectStatement |
SVNWCDbInsertTargetWithChangelist.nodeCurrent |
private SVNSqlJetSelectStatement |
SVNWCDbInsertTargetDepthInfinityWithChangelist.nodeCurrent |
private SVNSqlJetSelectStatement |
SVNWCDbInsertTargetDepthFilesWithChangelist.nodeCurrent |
private SVNSqlJetSelectStatement |
SVNWCDBSelectExternalProperties.propertiesSelect |
protected SVNSqlJetSelectStatement |
SVNWCDbInsertWorkingNodeFromBaseCopy.select |
private SVNSqlJetSelectStatement |
SVNWCDbInsertActualEmpties.select |
private SVNSqlJetSelectStatement |
SVNWCDbInsertDeleteList.select |
private SVNSqlJetSelectStatement |
SVNWCDbInsertTargetDepthImmediates.select |
private SVNSqlJetSelectStatement |
SVNWCDbInstallWorkingNodeForDelete.select |
private SVNSqlJetSelectStatement |
SVNWCDbDeleteActualNodeLeavingChangelistRecursive.select |
(package private) SVNSqlJetSelectStatement |
SVNWCDbDeleteLockOrphanRecursive.select |
private SVNSqlJetSelectStatement |
SVNWCDbInsertTargetDepthFiles.select |
private SVNSqlJetSelectStatement |
SVNWCDbInsertOrIgnorePristine.select |
private SVNSqlJetSelectStatement |
SVNWCDbInsertWorkingNodeNotPresentFromBase.select |
private SVNSqlJetSelectStatement |
SVNWCDbInsertTarget2.select |
private SVNSqlJetSelectStatement |
SVNWCDbMarkSkippedChangelistDirs.select |
private SVNSqlJetSelectStatement |
SVNWCDbInsertTarget.select |
private SVNSqlJetSelectStatement |
SVNWCDbInsertWorkingNodeFromBase.select |
private SVNSqlJetSelectStatement |
SVNWCDbInsertWorkingNodeNormalFromBase.select |
private SVNSqlJetSelectStatement |
SVNWCDbInsertTargetDepthInfinity.select |
private SVNSqlJetSelectStatement |
SVNWCDbCollectTargets.selectChangelist |
Constructor and Description |
---|
SVNWCDbInsertTarget(SVNSqlJetDb sDb,
SVNSqlJetSelectStatement select) |
Modifier and Type | Class and Description |
---|---|
class |
SVNWCDbSelectActualChildrenConflict17 |
class |
SVNWCDbSelectActualChildrenInfo17 |
class |
SVNWCDbSelectActualConflictVictims17 |
class |
SVNWCDbSelectConflictVictims17 |
class |
SVNWCDbSelectMovedFromRelPath17 |
class |
SVNWCDbUpdateActualConflictData17
UPDATE actual_node SET conflict_old = ?3, conflict_new = ?4,
conflict_working = ?5, prop_reject = ?6, tree_conflict_data = ?7
WHERE wc_id = ?1 AND local_relpath = ?2
|
Modifier and Type | Class and Description |
---|---|
private static class |
SvnNgDowngrade.DowngradeConflictStatement |
private static class |
SvnNgDowngrade.SelectConflictsStatement |