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 |
SVNWCDbLookForWork |
SELECT id FROM work_queue LIMIT 1
|
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 |
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 |
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;
|
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 |
SVNWCDbSelectChildrenOpDepth |
|
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 |
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 |
|
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 |
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 |
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 |
SVNWCDbSelectLocalRelPathOpDepth |
|
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 |
SVNWCDbSelectMovedBack |
|
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
|
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
|
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 |
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
|
class |
SVNWCDbSelectNodeProps |
SELECT properties, presence FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2
ORDER BY op_depth DESC;
|
class |
SVNWCDbSelectOpDepthChildren |
SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND
op_depth = ?3;
|
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 |
SVNWCDbSelectTargetslist |
SELECT local_relpath FROM targets_list
WHERE kind = 'file' AND wc_id = ?1
|
class |
SVNWCDbSelectUpdateMoveList |
|
class |
SVNWCDbSelectWCLock |
SELECT locked_levels FROM WC_LOCK WHERE wc_id = ?1 AND local_dir_relpath =
?2;
|
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;
|