Uses of Class
org.tmatesoft.svn.core.internal.db.SVNSqlJetStatement
Packages that use SVNSqlJetStatement
Package
Description
-
Uses of SVNSqlJetStatement in org.tmatesoft.svn.core.internal.db
Subclasses of SVNSqlJetStatement in org.tmatesoft.svn.core.internal.dbModifier and TypeClassDescriptionclassclassclassSVNSqlJetSelectFieldsStatement<E extends java.lang.Enum<E>>classclassclassclassFields in org.tmatesoft.svn.core.internal.db declared as SVNSqlJetStatementFields in org.tmatesoft.svn.core.internal.db with type parameters of type SVNSqlJetStatementModifier and TypeFieldDescriptionprivate java.util.EnumMap<SVNWCDbStatements,SVNSqlJetStatement> SVNSqlJetDb.statementsMethods in org.tmatesoft.svn.core.internal.db that return SVNSqlJetStatementModifier and TypeMethodDescriptionSVNSqlJetStatement.getJoinedStatement(java.lang.Enum<?> joinedTable) SVNSqlJetStatement.getJoinedStatement(java.lang.String joinedTable) SVNSqlJetDb.getStatement(SVNWCDbStatements statementIndex) private SVNSqlJetStatementSVNSqlJetDb.prepareStatement(SVNWCDbStatements statementIndex) Constructors in org.tmatesoft.svn.core.internal.db with parameters of type SVNSqlJetStatementModifierConstructorDescriptionSVNSqlJetUnionStatement(SVNSqlJetDb sDb, SVNSqlJetStatement... statements) -
Uses of SVNSqlJetStatement in org.tmatesoft.svn.core.internal.io.fs.revprop
Subclasses of SVNSqlJetStatement in org.tmatesoft.svn.core.internal.io.fs.revpropModifier and TypeClassDescriptionclassclassclass -
Uses of SVNSqlJetStatement in org.tmatesoft.svn.core.internal.wc17.db
Subclasses of SVNSqlJetStatement in org.tmatesoft.svn.core.internal.wc17.dbModifier and TypeClassDescriptionprivate static classprivate static classSELECT 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 = 0private static classINSERT OR REPLACE INTO externals ( wc_id, local_relpath, parent_relpath, presence, kind, def_local_relpath, repos_id, def_repos_relpath, def_operational_revision, def_revision) VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10)private static classprivate static classUPDATE 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 classUPDATE lock SET repos_id = ?2 WHERE repos_id = ?1Methods in org.tmatesoft.svn.core.internal.wc17.db that return SVNSqlJetStatementModifier and TypeMethodDescriptionstatic SVNSqlJetStatementSvnWcDbStatementUtil.bindf(SVNSqlJetStatement stmt, java.lang.String format, java.lang.Object... binds) private SVNSqlJetStatementSVNWCDb.getStatementForPath(java.io.File localAbsPath, SVNWCDbStatements statementIndex) Methods in org.tmatesoft.svn.core.internal.wc17.db with parameters of type SVNSqlJetStatementModifier and TypeMethodDescriptionprivate voidSVNWCDb.addChildren(java.util.Set<java.lang.String> children, SVNSqlJetStatement stmt) static SVNSqlJetStatementSvnWcDbStatementUtil.bindf(SVNSqlJetStatement stmt, java.lang.String format, java.lang.Object... binds) static byte[]SvnWcDbStatementUtil.getColumnBlob(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static booleanSvnWcDbStatementUtil.getColumnBoolean(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SvnChecksumSvnWcDbStatementUtil.getColumnChecksum(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SVNDateSvnWcDbStatementUtil.getColumnDate(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SVNDepthSvnWcDbStatementUtil.getColumnDepth(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SVNEventActionSvnWcDbStatementUtil.getColumnEventAction(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static java.util.List<Structure<StructureFields.InheritedProperties>>SvnWcDbStatementUtil.getColumnInheritedProperties(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static longSvnWcDbStatementUtil.getColumnInt64(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static ISVNWCDb.SVNWCDbKindSvnWcDbStatementUtil.getColumnKind(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SVNNodeKindSvnWcDbStatementUtil.getColumnNodeKind(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static java.io.FileSvnWcDbStatementUtil.getColumnPath(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static ISVNWCDb.SVNWCDbStatusSvnWcDbStatementUtil.getColumnPresence(SVNSqlJetStatement stmt) static ISVNWCDb.SVNWCDbStatusSvnWcDbStatementUtil.getColumnPresence(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SVNPropertiesSvnWcDbStatementUtil.getColumnProperties(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static longSvnWcDbStatementUtil.getColumnRevNum(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SVNStatusTypeSvnWcDbStatementUtil.getColumnStatusType(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static java.lang.StringSvnWcDbStatementUtil.getColumnText(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static <T extends java.lang.Enum<T>>
TSvnWcDbStatementUtil.getColumnToken(SVNSqlJetStatement stmt, java.lang.Enum<?> f, java.util.Map<java.lang.String, T> tokenMap) static ISVNWCDb.SVNWCDbLockSvnWcDbStatementUtil.getLockFromColumns(SVNSqlJetStatement stmt, java.lang.Enum<?> tokenField, java.lang.Enum<?> owner, java.lang.Enum<?> comment, java.lang.Enum<?> date) static longSvnWcDbStatementUtil.getTranslatedSize(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static booleanSvnWcDbStatementUtil.hasColumnProperties(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static booleanSvnWcDbStatementUtil.isColumnNull(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static voidSvnWcDbStatementUtil.reset(SVNSqlJetStatement stmt) -
Uses of SVNSqlJetStatement in org.tmatesoft.svn.core.internal.wc17.db.statement
Subclasses of SVNSqlJetStatement in org.tmatesoft.svn.core.internal.wc17.db.statementModifier and TypeClassDescriptionclassUPDATE nodes SET presence = ?3, revision = ?4, repos_path = ?5 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;classINSERT OR REPLACE INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, revision, presence, depth, kind, changed_revision, changed_date, changed_author, checksum, properties, dav_cache, symlink_target, file_external ) VALUES (?1, ?2, 0, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17);classUPDATE actual_node SET conflict_old = NULL, conflict_new = NULL, conflict_working = NULL WHERE wc_id = ?1 AND local_relpath = ?2;classUPDATE 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'))classUPDATE 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-- 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_depthclassUPDATE nodes SET moved_here = NULL WHERE wc_id = ?1 AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2)) AND op_depth = ?3classUPDATE nodes SET moved_to = NULL WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(moved_to, ?2)classUPDATE NODES SET moved_to = NULL WHERE wc_id = ?1 AND moved_to = ?2classclassUPDATE actual_node SET prop_reject = NULL WHERE wc_id = ?1 AND local_relpath = ?2;classUPDATE actual_node SET conflict_old = NULL, conflict_new = NULL, conflict_working = NULL WHERE wc_id = ?1 AND local_relpath = ?2;classclass-- 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 = ?3classprivate static classclassclassDELETE 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 NULLclassDELETE 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;classDELETE 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 classclassDELETE FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2;class-- 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-- 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-- 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))classDELETE FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2 AND tree_conflict_data IS NULL;class-- STMT_DELETE_ALL_LAYERS DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2classDELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0;classDELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;classDELETE 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 = 0classDELETE FROM externals WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2)classDELETE FROM externals WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2) AND kind != MAP_DIRclassDELETE FROM nodes WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2) AND op_depth = 0 AND file_external IS NOT NULLclassDELETE FROM lock WHERE repos_id = ?1 AND repos_relpath = ?2classDELETE 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)classclassDELETE 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';classDELETE FROM nodes WHERE wc_id = ?1 AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2)) AND op_depth = ?3classDELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2;classclassDELETE FROM nodes WHERE wc_id = ?1 AND (?2 = '' OR local_relpath = ?2 OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0')) AND op_depth >= ?3classclassDELETE FROM pristine WHERE checksum = ?1class-- STMT_DELETE_PRISTINE_IF_UNREFERENCED DELETE FROM pristine WHERE checksum = ?1 AND refcount = 0class-- 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')) *classDELETE FROM wc_lock WHERE wc_id = ?1 AND local_dir_relpath = ?2;classDELETE 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)classDELETE 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)classDELETE 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);classclassclassDELETE 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 > 0classDELETE FROM work_queue WHERE id = ?1;classSELECT 1 FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 LIMIT 1classSELECT local_dir_relpath FROM wc_lock WHERE wc_id = ?1 AND local_dir_relpath LIKE ?2 ESCAPE '#';classclassSELECT 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 1classclassINSERT INTO actual_node ( wc_id, local_relpath, conflict_data, parent_relpath) VALUES (?1, ?2, ?3, ?4);class-- STMT_INSERT_ACTUAL_EMPTIES INSERT OR IGNORE INTO actual_node ( wc_id, local_relpath, parent_relpath, properties, conflict_old, conflict_new, conflict_working, prop_reject, changelist, text_mod, tree_conflict_data ) SELECT wc_id, local_relpath, parent_relpath, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL FROM targets_listclass-- STMT_INSERT_ACTUAL_NODE INSERT OR REPLACE INTO actual_node ( wc_id, local_relpath, parent_relpath, properties, changelist, conflict_data) VALUES (?1, ?2, ?3, ?4, ?5, ?6)classINSERT INTO actual_node ( wc_id, local_relpath, prop_reject, parent_relpath) VALUES (?1, ?2, ?3, ?4)classINSERT INTO actual_node (wc_id, local_relpath, parent_relpath, properties) VALUES (?1, ?2, ?3, ?4);classINSERT INTO actual_node ( wc_id, local_relpath, conflict_old, conflict_new, conflict_working, parent_relpath) VALUES (?1, ?2, ?3, ?4, ?5, ?6);classINSERT INTO actual_node ( wc_id, local_relpath, tree_conflict_data, parent_relpath) VALUES (?1, ?2, ?3, ?4);classINSERT INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, presence, kind) SELECT wc_id, local_relpath, ?3 depth, parent_relpath, 'base-deleted', kind FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0classINSERT INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, presence, kind) SELECT wc_id, local_relpath, ?4 _op_depth_, parent_relpath, 'base-deleted', kind FROM nodes WHERE wc_id = ?1 AND (local_relpath = ?2 OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0')) AND op_depth = ?3 AND presence NOT IN ('base-deleted', 'not-present', 'excluded', 'absent') AND file_external IS NULLclassclass-- STMT_INSERT_EXTERNAL INSERT OR REPLACE INTO externals ( wc_id, local_relpath, parent_relpath, presence, kind, def_local_relpath, repos_id, def_repos_relpath, def_operational_revision, def_revision) VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10)class-- STMT_INSERT_EXTERNAL_UPGRADE INSERT OR REPLACE INTO externals ( wc_id, local_relpath, parent_relpath, presence, kind, def_local_relpath, repos_id, def_repos_relpath, def_operational_revision, def_revision) VALUES (?1, ?2, ?3, ?4, CASE WHEN (SELECT file_external FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0) IS NOT NULL THEN 'file' ELSE 'unknown' END, ?5, ?6, ?7, ?8, ?9)classINSERT INTO lock (repos_id, repos_relpath, lock_token, lock_owner, lock_comment, lock_date) VALUES (?1, ?2, ?3, ?4, ?5, ?6);classINSERT OR REPLACE INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, revision, presence, depth, kind, changed_revision, changed_date, changed_author, checksum, properties, translated_size, last_mod_time, dav_cache, symlink_target, file_external, moved_to, moved_here, inherited_props ) VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17, ?18, ?19, ?20, ?21, ?22, ?23);class-- STMT_INSERT_OR_IGNORE_PRISTINE INSERT OR IGNORE INTO pristine (checksum, md5_checksum, size, refcount) VALUES (?1, ?2, ?3, 0)classINSERT OR IGNORE INTO pristine (checksum, md5_checksum, size, refcount) VALUES (?1, ?2, ?3, 0);classINSERT INTO repository (root, uuid) VALUES (?1, ?2);classclassclassclassclassclassclassclassclassclassclassINSERT INTO wc_lock (wc_id, local_dir_relpath, locked_levels) VALUES (?1, ?2, ?3);classINSERT INTO wcroot (local_abspath) VALUES (?1);classprivate static classprivate static classclassINSERT OR REPLACE INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, presence, kind, checksum, changed_revision, changed_date, changed_author, depth, symlink_target, translated_size, last_mod_time, properties) SELECT wc_id, local_relpath, ?3 AS op_depth, parent_relpath, ?4 AS presence, kind, checksum, changed_revision, changed_date, changed_author, depth, symlink_target, translated_size, last_mod_time, properties FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;classINSERT INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, revision, presence, depth, kind, changed_revision, changed_date, changed_author, checksum, properties, translated_size, last_mod_time, symlink_target ) SELECT wc_id, local_relpath, ?3 AS op_depth, parent_relpath, repos_id, repos_path, revision, 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;classINSERT INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, revision, presence, depth, kind, changed_revision, changed_date, changed_author, checksum, properties, translated_size, last_mod_time, symlink_target ) SELECT wc_id, local_relpath, ?3 AS op_depth, parent_relpath, repos_id, repos_path, revision, ?4 AS 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;classINSERT INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, revision, presence, depth, kind, changed_revision, changed_date, changed_author, checksum, properties, translated_size, last_mod_time, symlink_target ) SELECT wc_id, local_relpath, ?3 AS op_depth, parent_relpath, repos_id, repos_path, revision, 'normal', 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;classINSERT INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, repos_id, repos_path, revision, presence, kind, changed_revision, changed_date, changed_author ) SELECT wc_id, local_relpath, ?3 as op_depth, parent_relpath, repos_id, repos_path, revision, 'not-present', kind, changed_revision, changed_date, changed_author FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;classINSERT INTO work_queue (work) VALUES (?1);classINSERT OR REPLACE INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, presence, kind) VALUES(?1, ?2, ?3, ?4, 'base-deleted', ?5)classSELECT id FROM work_queue LIMIT 1classSTMT_MARK_SKIPPED_CHANGELIST_DIRS INSERT INTO changelist_list (wc_id, local_relpath, notify, changelist) SELECT wc_id, local_relpath, 7, ?1 FROM targets_list WHERE kind = 'dir'classCREATE VIEW NODES_BASE AS SELECT * FROM nodes WHERE op_depth = 0;classCREATE 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);classclassclassclassprivate static classclassREPLACE INTO actual_node ( wc_id, local_relpath, parent_relpath, changelist) VALUES (?1, ?2, ?3, ?4);classSELECT local_relpath, tree_conflict_data FROM actual_node WHERE wc_id = ?1 AND parent_relpath = ?2 AND tree_conflict_data IS NOT NULL;classSELECT local_relpath, changelist, properties, conflict_data FROM actual_node WHERE wc_id = ?1 AND parent_relpath = ?2classSELECT 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))classselect prop_reject, changelist, conflict_old, conflict_new, conflict_working, tree_conflict_data, properties from actual_node where wc_id = ?1 and local_relpath = ?2;classselect properties from actual_node where wc_id = ?1 and local_relpath = ?2;classSELECT tree_conflict_data FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2 AND tree_conflict_data IS NOT NULL;class-- STMT_SELECT_ALL_FILES SELECT DISTINCT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND kind = 'file'class-- 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'classSELECT 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 DESCclassSELECT 1 FROM nodes WHERE checksum = ?1 OR checksum = ?2 UNION ALL SELECT 1 FROM actual_node WHERE older_checksum = ?1 OR older_checksum = ?2 OR left_checksum = ?1 OR left_checksum = ?2 OR right_checksum = ?1 OR right_checksum = ?2 LIMIT 1classclass-- STMT_SELECT_BASE_DAV_CACHE SELECT dav_cache FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0classSELECT 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;classSELECT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = 0;classprivate static classclassSELECT 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 classclassSELECT 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 DESCclassSELECT properties FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;classSTMT_SELECT_CHANGELIST_LIST SELECT wc_id, local_relpath, notify, changelist FROM changelist_list ORDER BY wc_id, local_relpathclassclassclassSELECT 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 classprivate static classprivate static classclassSELECT prop_reject, conflict_old, conflict_new, conflict_working, tree_conflict_data FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2;classclassSELECT 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 NULLprivate static classclassSELECT (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 1static classclassprivate static classclassSELECT 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 = ?3classSELECT 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)classSELECT 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'))classSELECT file_external FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;classclassSELECT 1 FROM nodes WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(parent_relpath, ?2) AND op_depth = 0 AND file_external IS NULLclassSELECT 1 FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = 0 AND kind != MAP_FILEclassclassSELECT local_relpath, repos_path FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0 AND (inherited_props not null)classclassclassSELECT 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 1classSELECT 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 = 0classprivate static classclassSELECT 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 >= ?3private static classclassSELECT 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 > 0private static classclassSELECT local_relpath, op_depth FROM nodes WHERE wc_id = ?1 AND moved_to = ?2 AND op_depth > 0classSELECT moved_to, local_relpath FROM nodes WHERE wc_id = ?1 AND op_depth > 0 AND IS_STRICT_DESCENDANT_OF(moved_to, ?2)classSELECT 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)classSELECT 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 NULLclassSELECT moved_to FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3classSELECT 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 = ?2private static classclassSELECT 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.classSELECT 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 DESCclassSELECT 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 DESCprivate static classclassSELECT properties, presence FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 ORDER BY op_depth DESC;class-- 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'classSELECT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = ?3;classclassSELECT md5_checksum FROM pristine WHERE checksum = ?1classSELECT id FROM repository WHERE root = ?1;classselect root, uuid from repository where id = ?1;classclassclassSELECT checksum FROM pristine WHERE md5_checksum = ?1classSELECT local_relpath FROM targets_list WHERE kind = 'file' AND wc_id = ?1class-- STMT_SELECT_UNREFERENCED_PRISTINES SELECT checksum FROM pristine WHERE refcount = 0classclassSELECT locked_levels FROM WC_LOCK WHERE wc_id = ?1 AND local_dir_relpath = ?2;classclassselect id from wcroot where local_abspath is null;classSELECT 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'))classSELECT 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;classSELECT 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'))classSELECT id, work FROM work_queue ORDER BY id LIMIT 1;classUPDATE actual_node SET changelist = ?3 WHERE wc_id = ?1 AND local_relpath = ?2classclassUPDATE actual_node SET conflict_data = ?3 WHERE wc_id = ?1 AND local_relpath = ?2;classUPDATE actual_node SET prop_reject = ?3 WHERE wc_id = ?1 AND local_relpath = ?2;classUPDATE actual_node SET properties = ?3 WHERE wc_id = ?1 AND local_relpath = ?2;classUPDATE actual_node SET conflict_old = ?3, conflict_new = ?4, conflict_working = ?5 WHERE wc_id = ?1 AND local_relpath = ?2;classUPDATE actual_node SET tree_conflict_data = ?3 WHERE wc_id = ?1 AND local_relpath = ?2;class-- STMT_UPDATE_BASE_NODE_DAV_CACHE UPDATE nodes SET dav_cache = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0classUPDATE nodes SET revision = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;classUPDATE 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);classclassUPDATE nodes SET moved_to = RELPATH_SKIP_JOIN(?2, ?3, moved_to) WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(moved_to, ?2)classUPDATE nodes SET moved_to = ?4 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3classUPDATE nodes SET depth = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;classUPDATE nodes SET presence = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;classUPDATE 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-- STMT_UPDATE_NODE_PROPS UPDATE nodes SET properties = ?4 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3classUPDATE 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);classclassclassFields in org.tmatesoft.svn.core.internal.wc17.db.statement declared as SVNSqlJetStatementModifier and TypeFieldDescriptionprivate SVNSqlJetStatementSVNWCDbSelectCopyPristines.joinedStatementprivate SVNSqlJetStatementSVNWCDbSelectMovedBack.joinedStatementFields in org.tmatesoft.svn.core.internal.wc17.db.statement with type parameters of type SVNSqlJetStatementModifier and TypeFieldDescriptionprivate java.lang.Class<? extends SVNSqlJetStatement>SVNWCDbStatements.statementClassMethods in org.tmatesoft.svn.core.internal.wc17.db.statement that return SVNSqlJetStatementModifier and TypeMethodDescriptionSVNWCDbSelectBaseNodeLockTokensRecursive.getJoinedStatement(java.lang.Enum<?> joinedTable) SVNWCDbSelectBaseNodeWithLock.getJoinedStatement(java.lang.String joinedTable) SVNWCDbSelectCopyPristines.getJoinedStatement(java.lang.String joinedTable) SVNWCDbSelectDeletionInfoScan.getJoinedStatement(java.lang.Enum<?> joinedTable) SVNWCDbSelectMovedBack.getJoinedStatement(java.lang.Enum<?> joinedTable) SVNWCDbSelectNodeChildrenInfo.getJoinedStatement(java.lang.String joinedTable) SVNWCDbSelectNodeInfoWithLock.getJoinedStatement(java.lang.String joinedTable) private static SVNSqlJetStatementSVNWCDbSelectAnyPristineReference.selectActual(SVNSqlJetDb sDb) private static SVNSqlJetStatementSVNWCDbSelectAnyPristineReference.selectNodes(SVNSqlJetDb sDb) Methods in org.tmatesoft.svn.core.internal.wc17.db.statement that return types with arguments of type SVNSqlJetStatementModifier and TypeMethodDescriptionjava.lang.Class<? extends SVNSqlJetStatement>SVNWCDbStatements.getStatementClass()Constructor parameters in org.tmatesoft.svn.core.internal.wc17.db.statement with type arguments of type SVNSqlJetStatementModifierConstructorDescriptionprivateSVNWCDbStatements(java.lang.Class<? extends SVNSqlJetStatement> statementClass) -
Uses of SVNSqlJetStatement in org.tmatesoft.svn.core.internal.wc17.db.statement17
Subclasses of SVNSqlJetStatement in org.tmatesoft.svn.core.internal.wc17.db.statement17Modifier and TypeClassDescriptionclassINSERT INFO actual_node (conflict_old, conflict_new, conflict_working, prop_reject, tree_conflict_data, parent_relpath) VALUES (?3, ?4, ?5, ?6, ?7, ?8) WHERE wc_id = ?1 AND local_relpath = ?2classclassclassclassclassclassclassUPDATE 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 SVNSqlJetStatement in org.tmatesoft.svn.core.internal.wc2.ng
Subclasses of SVNSqlJetStatement in org.tmatesoft.svn.core.internal.wc2.ngModifier and TypeClassDescriptionprivate static classprivate static class