Package | Description |
---|---|
org.tmatesoft.svn.core.internal.wc17.db.statement | |
org.tmatesoft.svn.core.internal.wc17.db.statement17 |
Modifier and Type | Class and Description |
---|---|
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;
|
Modifier and Type | Field and Description |
---|---|
protected SVNSqlJetSelectFieldsStatement<SVNWCDbSchema.NODES__Fields> |
SVNWCDbInsertDeleteFromBase.select |
protected SVNSqlJetSelectFieldsStatement<SVNWCDbSchema.NODES__Fields> |
SVNWCDbInsertDeleteFromNodeRecursive.select |
Modifier and Type | Class and Description |
---|---|
class |
SVNWCDbSelectActualChildrenConflict17 |
class |
SVNWCDbSelectActualChildrenInfo17 |
class |
SVNWCDbSelectActualConflictVictims17 |
class |
SVNWCDbSelectConflictVictims17 |
Copyright © 2019. All rights reserved.