Uses of Class
org.tmatesoft.svn.core.internal.db.SVNSqlJetSelectStatement

Packages that use SVNSqlJetSelectStatement

Package	Description
org.tmatesoft.svn.core.internal.db
org.tmatesoft.svn.core.internal.io.fs.revprop
org.tmatesoft.svn.core.internal.wc17.db
org.tmatesoft.svn.core.internal.wc17.db.statement
org.tmatesoft.svn.core.internal.wc17.db.statement17
org.tmatesoft.svn.core.internal.wc2.ng

Uses of SVNSqlJetSelectStatement in org.tmatesoft.svn.core.internal.db

Subclasses of SVNSqlJetSelectStatement in org.tmatesoft.svn.core.internal.db

Modifier and Type	Class	Description
class	SVNSqlJetDeleteStatement
class	SVNSqlJetSelectFieldsStatement<E extends java.lang.Enum<E>>
class	SVNSqlJetUpdateStatement

Uses of SVNSqlJetSelectStatement in org.tmatesoft.svn.core.internal.io.fs.revprop

Subclasses of SVNSqlJetSelectStatement in org.tmatesoft.svn.core.internal.io.fs.revprop

Modifier and Type	Class	Description
class	SVNFSFSRevPropGet

Uses of SVNSqlJetSelectStatement in org.tmatesoft.svn.core.internal.wc17.db

Subclasses of SVNSqlJetSelectStatement in org.tmatesoft.svn.core.internal.wc17.db

Modifier and Type	Class	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

Uses of SVNSqlJetSelectStatement in org.tmatesoft.svn.core.internal.wc17.db.statement

Subclasses of SVNSqlJetSelectStatement in org.tmatesoft.svn.core.internal.wc17.db.statement

Modifier and Type	Class	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

Fields in org.tmatesoft.svn.core.internal.wc17.db.statement declared as SVNSqlJetSelectStatement

Modifier and Type	Field	Description
private SVNSqlJetSelectStatement	SVNWCDbInsertTargetDepthFilesWithChangelist.actualNode
private SVNSqlJetSelectStatement	SVNWCDbInsertTargetDepthImmediatesWithChangelist.actualNode
private SVNSqlJetSelectStatement	SVNWCDbInsertTargetDepthInfinityWithChangelist.actualNode
private SVNSqlJetSelectStatement	SVNWCDbInsertTargetWithChangelist.actualNode
private SVNSqlJetSelectStatement	SVNWCDbInsertWorkingNodeCopyFrom.internalStatement1
private SVNSqlJetSelectStatement	SVNWCDbInsertWorkingNodeCopyFrom.internalStatement2
private SVNSqlJetSelectStatement	SVNWCDbInsertTargetDepthFilesWithChangelist.nodeCurrent
private SVNSqlJetSelectStatement	SVNWCDbInsertTargetDepthImmediatesWithChangelist.nodeCurrent
private SVNSqlJetSelectStatement	SVNWCDbInsertTargetDepthInfinityWithChangelist.nodeCurrent
private SVNSqlJetSelectStatement	SVNWCDbInsertTargetWithChangelist.nodeCurrent
private SVNSqlJetSelectStatement	SVNWCDBSelectExternalProperties.propertiesSelect
private SVNSqlJetSelectStatement	SVNWCDbDeleteActualNodeLeavingChangelistRecursive.select
(package private) SVNSqlJetSelectStatement	SVNWCDbDeleteLockOrphanRecursive.select
private SVNSqlJetSelectStatement	SVNWCDbInsertActualEmpties.select
private SVNSqlJetSelectStatement	SVNWCDbInsertDeleteList.select
private SVNSqlJetSelectStatement	SVNWCDbInsertOrIgnorePristine.select
private SVNSqlJetSelectStatement	SVNWCDbInsertTarget.select
private SVNSqlJetSelectStatement	SVNWCDbInsertTarget2.select
private SVNSqlJetSelectStatement	SVNWCDbInsertTargetDepthFiles.select
private SVNSqlJetSelectStatement	SVNWCDbInsertTargetDepthImmediates.select
private SVNSqlJetSelectStatement	SVNWCDbInsertTargetDepthInfinity.select
private SVNSqlJetSelectStatement	SVNWCDbInsertWorkingNodeFromBase.select
protected SVNSqlJetSelectStatement	SVNWCDbInsertWorkingNodeFromBaseCopy.select
private SVNSqlJetSelectStatement	SVNWCDbInsertWorkingNodeNormalFromBase.select
private SVNSqlJetSelectStatement	SVNWCDbInsertWorkingNodeNotPresentFromBase.select
private SVNSqlJetSelectStatement	SVNWCDbInstallWorkingNodeForDelete.select
private SVNSqlJetSelectStatement	SVNWCDbMarkSkippedChangelistDirs.select
private SVNSqlJetSelectStatement	SVNWCDbCollectTargets.selectChangelist

Constructors in org.tmatesoft.svn.core.internal.wc17.db.statement with parameters of type SVNSqlJetSelectStatement

Modifier	Constructor	Description
	SVNWCDbInsertTarget(SVNSqlJetDb sDb, SVNSqlJetSelectStatement select)

Uses of SVNSqlJetSelectStatement in org.tmatesoft.svn.core.internal.wc17.db.statement17

Subclasses of SVNSqlJetSelectStatement in org.tmatesoft.svn.core.internal.wc17.db.statement17

Modifier and Type	Class	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

Uses of SVNSqlJetSelectStatement in org.tmatesoft.svn.core.internal.wc2.ng

Subclasses of SVNSqlJetSelectStatement in org.tmatesoft.svn.core.internal.wc2.ng

Modifier and Type	Class	Description
private static class	SvnNgDowngrade.DowngradeConflictStatement
private static class	SvnNgDowngrade.SelectConflictsStatement