Uses of Class
org.tmatesoft.svn.core.internal.db.SVNSqlJetTableStatement
Packages that use SVNSqlJetTableStatement
Package
Description
-
Uses of SVNSqlJetTableStatement in org.tmatesoft.svn.core.internal.db
Subclasses of SVNSqlJetTableStatement in org.tmatesoft.svn.core.internal.dbModifier and TypeClassDescriptionclass
class
class
SVNSqlJetSelectFieldsStatement<E extends java.lang.Enum<E>>
class
class
-
Uses of SVNSqlJetTableStatement in org.tmatesoft.svn.core.internal.io.fs.revprop
Subclasses of SVNSqlJetTableStatement in org.tmatesoft.svn.core.internal.io.fs.revprop -
Uses of SVNSqlJetTableStatement in org.tmatesoft.svn.core.internal.wc17.db
Subclasses of SVNSqlJetTableStatement 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 = ?1 -
Uses of SVNSqlJetTableStatement in org.tmatesoft.svn.core.internal.wc17.db.statement
Subclasses of SVNSqlJetTableStatement 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 = ?3private static 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 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 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 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
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
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
-
Uses of SVNSqlJetTableStatement in org.tmatesoft.svn.core.internal.wc17.db.statement17
Modifier 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 SVNSqlJetTableStatement in org.tmatesoft.svn.core.internal.wc2.ng
Subclasses of SVNSqlJetTableStatement in org.tmatesoft.svn.core.internal.wc2.ngModifier and TypeClassDescriptionprivate static class
private static class