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 TypeClassDescriptionclass
class
class
SVNSqlJetSelectFieldsStatement<E extends java.lang.Enum<E>>
class
class
class
class
Fields 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.statements
Methods 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 SVNSqlJetStatement
SVNSqlJetDb.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 TypeClassDescriptionclass
class
class
-
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 class
private static class
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 = 0private static class
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)private static class
private static class
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
UPDATE lock SET repos_id = ?2 WHERE repos_id = ?1Methods in org.tmatesoft.svn.core.internal.wc17.db that return SVNSqlJetStatementModifier and TypeMethodDescriptionstatic SVNSqlJetStatement
SvnWcDbStatementUtil.bindf
(SVNSqlJetStatement stmt, java.lang.String format, java.lang.Object... binds) private SVNSqlJetStatement
SVNWCDb.getStatementForPath
(java.io.File localAbsPath, SVNWCDbStatements statementIndex) Methods in org.tmatesoft.svn.core.internal.wc17.db with parameters of type SVNSqlJetStatementModifier and TypeMethodDescriptionprivate void
SVNWCDb.addChildren
(java.util.Set<java.lang.String> children, SVNSqlJetStatement stmt) static SVNSqlJetStatement
SvnWcDbStatementUtil.bindf
(SVNSqlJetStatement stmt, java.lang.String format, java.lang.Object... binds) static byte[]
SvnWcDbStatementUtil.getColumnBlob
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static boolean
SvnWcDbStatementUtil.getColumnBoolean
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SvnChecksum
SvnWcDbStatementUtil.getColumnChecksum
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SVNDate
SvnWcDbStatementUtil.getColumnDate
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SVNDepth
SvnWcDbStatementUtil.getColumnDepth
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SVNEventAction
SvnWcDbStatementUtil.getColumnEventAction
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static java.util.List<Structure<StructureFields.InheritedProperties>>
SvnWcDbStatementUtil.getColumnInheritedProperties
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static long
SvnWcDbStatementUtil.getColumnInt64
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static ISVNWCDb.SVNWCDbKind
SvnWcDbStatementUtil.getColumnKind
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SVNNodeKind
SvnWcDbStatementUtil.getColumnNodeKind
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static java.io.File
SvnWcDbStatementUtil.getColumnPath
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static ISVNWCDb.SVNWCDbStatus
SvnWcDbStatementUtil.getColumnPresence
(SVNSqlJetStatement stmt) static ISVNWCDb.SVNWCDbStatus
SvnWcDbStatementUtil.getColumnPresence
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SVNProperties
SvnWcDbStatementUtil.getColumnProperties
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static long
SvnWcDbStatementUtil.getColumnRevNum
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static SVNStatusType
SvnWcDbStatementUtil.getColumnStatusType
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static java.lang.String
SvnWcDbStatementUtil.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.SVNWCDbLock
SvnWcDbStatementUtil.getLockFromColumns
(SVNSqlJetStatement stmt, java.lang.Enum<?> tokenField, java.lang.Enum<?> owner, java.lang.Enum<?> comment, java.lang.Enum<?> date) static long
SvnWcDbStatementUtil.getTranslatedSize
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static boolean
SvnWcDbStatementUtil.hasColumnProperties
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static boolean
SvnWcDbStatementUtil.isColumnNull
(SVNSqlJetStatement stmt, java.lang.Enum<?> f) static void
SvnWcDbStatementUtil.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 TypeClassDescriptionclass
UPDATE nodes SET presence = ?3, revision = ?4, repos_path = ?5 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;class
INSERT 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);class
UPDATE actual_node SET conflict_old = NULL, conflict_new = NULL, conflict_working = NULL WHERE wc_id = ?1 AND local_relpath = ?2;class
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
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
-- 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_depthclass
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 = ?3class
UPDATE nodes SET moved_to = NULL WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(moved_to, ?2)class
UPDATE NODES SET moved_to = NULL WHERE wc_id = ?1 AND moved_to = ?2class
class
UPDATE actual_node SET prop_reject = NULL WHERE wc_id = ?1 AND local_relpath = ?2;class
UPDATE actual_node SET conflict_old = NULL, conflict_new = NULL, conflict_working = NULL WHERE wc_id = ?1 AND local_relpath = ?2;class
class
-- 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 = ?3class
private static class
class
class
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 NULLclass
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
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
class
DELETE 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))class
DELETE 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 = ?2class
DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0;class
DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;class
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 = 0class
DELETE FROM externals WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2)class
DELETE FROM externals WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2) AND kind != MAP_DIRclass
DELETE FROM nodes WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(local_relpath, ?2) AND op_depth = 0 AND file_external IS NOT NULLclass
DELETE FROM lock WHERE repos_id = ?1 AND repos_relpath = ?2class
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
class
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
DELETE FROM nodes WHERE wc_id = ?1 AND (local_relpath = ?2 OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2)) AND op_depth = ?3class
DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2;class
class
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 >= ?3class
class
DELETE 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')) *class
DELETE FROM wc_lock WHERE wc_id = ?1 AND local_dir_relpath = ?2;class
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
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
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
class
class
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 > 0class
DELETE FROM work_queue WHERE id = ?1;class
SELECT 1 FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 LIMIT 1class
SELECT local_dir_relpath FROM wc_lock WHERE wc_id = ?1 AND local_dir_relpath LIKE ?2 ESCAPE '#';class
class
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 1class
class
INSERT 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)class
INSERT INTO actual_node ( wc_id, local_relpath, prop_reject, parent_relpath) VALUES (?1, ?2, ?3, ?4)class
INSERT INTO actual_node (wc_id, local_relpath, parent_relpath, properties) VALUES (?1, ?2, ?3, ?4);class
INSERT INTO actual_node ( wc_id, local_relpath, conflict_old, conflict_new, conflict_working, parent_relpath) VALUES (?1, ?2, ?3, ?4, ?5, ?6);class
INSERT INTO actual_node ( wc_id, local_relpath, tree_conflict_data, parent_relpath) VALUES (?1, ?2, ?3, ?4);class
INSERT 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 = 0class
INSERT 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 NULLclass
class
-- 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)class
INSERT INTO lock (repos_id, repos_relpath, lock_token, lock_owner, lock_comment, lock_date) VALUES (?1, ?2, ?3, ?4, ?5, ?6);class
INSERT 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)class
INSERT OR IGNORE INTO pristine (checksum, md5_checksum, size, refcount) VALUES (?1, ?2, ?3, 0);class
INSERT INTO repository (root, uuid) VALUES (?1, ?2);class
class
class
class
class
class
class
class
class
class
class
INSERT INTO wc_lock (wc_id, local_dir_relpath, locked_levels) VALUES (?1, ?2, ?3);class
INSERT INTO wcroot (local_abspath) VALUES (?1);class
private static class
private static class
class
INSERT 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;class
INSERT 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;class
INSERT 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;class
INSERT 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;class
INSERT 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;class
INSERT INTO work_queue (work) VALUES (?1);class
INSERT OR REPLACE INTO nodes ( wc_id, local_relpath, op_depth, parent_relpath, presence, kind) VALUES(?1, ?2, ?3, ?4, 'base-deleted', ?5)class
SELECT id FROM work_queue LIMIT 1class
STMT_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'class
CREATE VIEW NODES_BASE AS SELECT * FROM nodes WHERE op_depth = 0;class
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
class
class
class
private static class
class
REPLACE INTO actual_node ( wc_id, local_relpath, parent_relpath, changelist) VALUES (?1, ?2, ?3, ?4);class
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
SELECT local_relpath, changelist, properties, conflict_data FROM actual_node WHERE wc_id = ?1 AND parent_relpath = ?2class
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
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
select properties from actual_node where wc_id = ?1 and local_relpath = ?2;class
SELECT 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'class
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 DESCclass
SELECT 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 1class
class
-- STMT_SELECT_BASE_DAV_CACHE SELECT dav_cache FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0class
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
SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = 0;class
private static class
class
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
class
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 DESCclass
SELECT properties FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;class
STMT_SELECT_CHANGELIST_LIST SELECT wc_id, local_relpath, notify, changelist FROM changelist_list ORDER BY wc_id, local_relpathclass
class
class
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
private static class
private static class
class
SELECT prop_reject, conflict_old, conflict_new, conflict_working, tree_conflict_data FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2;class
class
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 NULLprivate static class
class
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 1static class
class
private static class
class
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 = ?3class
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
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
SELECT file_external FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;class
class
SELECT 1 FROM nodes WHERE wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(parent_relpath, ?2) AND op_depth = 0 AND file_external IS NULLclass
SELECT 1 FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = 0 AND kind != MAP_FILEclass
class
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
class
class
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 1class
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 = 0class
private static class
class
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 >= ?3private static class
class
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 > 0private static class
class
SELECT local_relpath, op_depth FROM nodes WHERE wc_id = ?1 AND moved_to = ?2 AND op_depth > 0class
SELECT moved_to, local_relpath FROM nodes WHERE wc_id = ?1 AND op_depth > 0 AND IS_STRICT_DESCENDANT_OF(moved_to, ?2)class
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
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 NULLclass
SELECT moved_to FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3class
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 = ?2private static class
class
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
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 DESCclass
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 DESCprivate static class
class
SELECT 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'class
SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND op_depth = ?3;class
class
SELECT md5_checksum FROM pristine WHERE checksum = ?1class
SELECT id FROM repository WHERE root = ?1;class
select root, uuid from repository where id = ?1;class
class
class
SELECT checksum FROM pristine WHERE md5_checksum = ?1class
SELECT local_relpath FROM targets_list WHERE kind = 'file' AND wc_id = ?1class
-- STMT_SELECT_UNREFERENCED_PRISTINES SELECT checksum FROM pristine WHERE refcount = 0class
class
SELECT locked_levels FROM WC_LOCK WHERE wc_id = ?1 AND local_dir_relpath = ?2;class
class
select id from wcroot where local_abspath is null;class
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
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
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
SELECT id, work FROM work_queue ORDER BY id LIMIT 1;class
UPDATE actual_node SET changelist = ?3 WHERE wc_id = ?1 AND local_relpath = ?2class
class
UPDATE actual_node SET conflict_data = ?3 WHERE wc_id = ?1 AND local_relpath = ?2;class
UPDATE actual_node SET prop_reject = ?3 WHERE wc_id = ?1 AND local_relpath = ?2;class
UPDATE actual_node SET properties = ?3 WHERE wc_id = ?1 AND local_relpath = ?2;class
UPDATE actual_node SET conflict_old = ?3, conflict_new = ?4, conflict_working = ?5 WHERE wc_id = ?1 AND local_relpath = ?2;class
UPDATE 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 = 0class
UPDATE nodes SET revision = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;class
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
class
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
UPDATE nodes SET moved_to = ?4 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3class
UPDATE nodes SET depth = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;class
UPDATE nodes SET presence = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;class
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
-- STMT_UPDATE_NODE_PROPS UPDATE nodes SET properties = ?4 WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3class
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
class
class
Fields in org.tmatesoft.svn.core.internal.wc17.db.statement declared as SVNSqlJetStatementModifier and TypeFieldDescriptionprivate SVNSqlJetStatement
SVNWCDbSelectCopyPristines.joinedStatement
private SVNSqlJetStatement
SVNWCDbSelectMovedBack.joinedStatement
Fields in org.tmatesoft.svn.core.internal.wc17.db.statement with type parameters of type SVNSqlJetStatementModifier and TypeFieldDescriptionprivate java.lang.Class<? extends SVNSqlJetStatement>
SVNWCDbStatements.statementClass
Methods 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 SVNSqlJetStatement
SVNWCDbSelectAnyPristineReference.selectActual
(SVNSqlJetDb sDb) private static SVNSqlJetStatement
SVNWCDbSelectAnyPristineReference.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 SVNSqlJetStatementModifierConstructorDescriptionprivate
SVNWCDbStatements
(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 TypeClassDescriptionclass
INSERT 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 = ?2class
class
class
class
class
class
class
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 SVNSqlJetStatement in org.tmatesoft.svn.core.internal.wc2.ng
Subclasses of SVNSqlJetStatement in org.tmatesoft.svn.core.internal.wc2.ngModifier and TypeClassDescriptionprivate static class
private static class