Class | Description |
---|---|
SVNUpdateBaseNodePresenceRevnumAndReposPath |
UPDATE nodes SET presence = ?3, revision = ?4, repos_path = ?5 WHERE wc_id =
?1 AND local_relpath = ?2 AND op_depth = 0;
|
SVNWCDbApplyChangesToBaseNode |
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);
|
SVNWCDbClearActualNodeLeavingChangelist |
UPDATE actual_node SET conflict_old = NULL, conflict_new = NULL,
conflict_working = NULL
WHERE wc_id = ?1 AND local_relpath = ?2;
|
SVNWCDbClearActualNodeLeavingChangelistRecursive |
UPDATE actual_node SET conflict_old = NULL, conflict_new = NULL,
conflict_working = NULL
WHERE wc_id = ?1
AND (?2 = ''
OR local_relpath = ?2
OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0'))
|
SVNWCDbClearActualNodeLeavingConflict |
UPDATE actual_node SET properties = NULL, text_mod = NULL, changelist = NULL,
tree_conflict_data = NULL, conflict_old = NULL, conflict_new = NULL,
conflict_working = NULL, prop_reject = NULL, older_checksum = NULL,
left_checksum = NULL, right_checksum = NULL WHERE wc_id = ?1 and
local_relpath = ?2;
|
SVNWCDbClearDavCacheRecursive |
-- STMT_CLEAR_BASE_NODE_RECURSIVE_DAV_CACHE
UPDATE nodes SET dav_cache = NULL
WHERE
dav_cache IS NOT NULL
AND wc_id = ?1
AND op_depth = 0
AND (?2 = ''
OR local_relpath = ?2
OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
primary index: wc_id, local_relpath, op_depth
|
SVNWCDbClearPropsConflict |
UPDATE actual_node SET prop_reject = NULL WHERE wc_id = ?1 AND local_relpath
= ?2;
|
SVNWCDbClearTextConflict |
UPDATE actual_node SET conflict_old = NULL, conflict_new = NULL,
conflict_working = NULL WHERE wc_id = ?1 AND local_relpath = ?2;
|
SVNWCDbCollectTargets | |
SVNWCDbCommitDescendantToBase |
-- STMT_COMMIT_DESCENDANT_TO_BASE
UPDATE NODES SET op_depth = 0, repos_id = ?4, repos_path = ?5, revision = ?6,
moved_here = NULL, moved_to = NULL, dav_cache = NULL,
presence = CASE presence WHEN 'normal' THEN 'normal'
WHEN 'excluded' THEN 'excluded'
ELSE 'not-present' END
WHERE wc_id = ?1 AND local_relpath = ?2 and op_depth = ?3
|
SVNWCDbCreateSchema | |
SVNWCDbCreateSchema.Statement | |
SVNWCDbDeleteActualEmpties |
DELETE FROM actual_node
WHERE wc_id = ?1
AND properties IS NULL
AND conflict_old IS NULL
AND conflict_new IS NULL
AND prop_reject IS NULL
AND changelist IS NULL
AND text_mod IS NULL
AND tree_conflict_data IS NULL
AND older_checksum IS NULL
AND right_checksum IS NULL
AND left_checksum IS NULL
|
SVNWCDbDeleteActualEmpty |
DELETE FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2 AND
properties IS NULL AND conflict_old IS NULL AND conflict_new IS NULL AND
prop_reject IS NULL AND changelist IS NULL AND text_mod IS NULL AND
tree_conflict_data IS NULL AND older_checksum IS NULL AND right_checksum IS
NULL AND left_checksum IS NULL;
|
SVNWCDbDeleteActualNode |
DELETE FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2;
|
SVNWCDbDeleteActualNodeLeavingChangelist |
-- STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE
DELETE FROM actual_node
WHERE wc_id = ?1 AND local_relpaht = ?2
AND (changelist IS NULL
OR NOT EXISTS (SELECT 1 FROM nodes_current c
WHERE c.wc_id = ?1 AND c.local_relpath = local_relpath
AND kind = 'file'))
|
SVNWCDbDeleteActualNodeLeavingChangelistRecursive |
-- STMT_DELETE_ACTUAL_NODE_LEAVING_CHANGELIST_RECURSIVE
DELETE FROM actual_node
WHERE wc_id = ?1
AND (?2 = ''
OR local_relpath = ?2
OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0'))
AND (changelist IS NULL
OR NOT EXISTS (SELECT 1 FROM nodes_current c
WHERE c.wc_id = ?1 AND c.local_relpath = local_relpath
AND kind = 'file'))
|
SVNWCDbDeleteActualNodeRecursive |
-- STMT_DELETE_ACTUAL_NODE_RECURSIVE
DELETE FROM actual_node
WHERE wc_id = ?1
AND (?2 = ''
OR local_relpath = ?2
OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
|
SVNWCDbDeleteActualNodeWithoutConflict |
DELETE FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2 AND
tree_conflict_data IS NULL;
|
SVNWCDbDeleteAllLayers |
-- STMT_DELETE_ALL_LAYERS
DELETE FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2
|
SVNWCDbDeleteAllWorkingNodes |
DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0;
|
SVNWCDbDeleteBaseNode |
DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;
|
SVNWCDbDeleteLock |
DELETE FROM lock
WHERE repos_id = ?1 AND repos_relpath = ?2
|
SVNWCDbDeleteLockOrphanRecursive |
DELETE FROM wc_lock
WHERE wc_id = ?1
AND (?2 = ''
OR local_dir_relpath = ?2
OR (local_dir_relpath > ?2 || '/' AND local_dir_relpath < ?2 || '0'))
AND NOT EXISTS (SELECT 1 FROM nodes
WHERE nodes.wc_id = ?1
AND nodes.local_relpath = wc_lock.local_dir_relpath)
|
SVNWCDbDeleteLowestWorkingNode |
DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth =
(SELECT MIN(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth > 0) AND presence = 'base-deleted';
|
SVNWCDbDeleteNodes |
DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2;
|
SVNWCDbDeleteNodesRecursive |
DELETE FROM nodes
WHERE wc_id = ?1
AND (?2 = ''
OR local_relpath = ?2
OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0'))
AND op_depth >= ?3
|
SVNWCDbDeletePristine |
DELETE FROM pristine WHERE checksum = ?1
|
SVNWCDbDeletePristineIfUnreferenced |
-- STMT_DELETE_PRISTINE_IF_UNREFERENCED
DELETE FROM pristine
WHERE checksum = ?1 AND refcount = 0
|
SVNWCDbDeleteShadowedRecursive |
-- STMT_DELETE_SHADOWED_RECURSIVE
DELETE FROM nodes
WHERE wc_id = ?1
AND (local_relpath = ?2
OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
AND (op_depth < ?3
OR (op_depth = ?3 AND presence = 'base-deleted')) *
|
SVNWCDbDeleteWCLock |
DELETE FROM wc_lock WHERE wc_id = ?1 AND local_dir_relpath = ?2;
|
SVNWCDbDeleteWCLockOrphan |
DELETE FROM wc_lock
WHERE wc_id = ?1 AND local_dir_relpath = ?2
AND NOT EXISTS (SELECT 1 FROM nodes
WHERE nodes.wc_id = ?1
AND nodes.local_relpath = wc_lock.local_dir_relpath)
|
SVNWCDbDeleteWorkingNode |
DELETE FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth =
(SELECT MAX(op_depth) FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth > 0);
|
SVNWCDbDeleteWorkItem |
DELETE FROM work_queue WHERE id = ?1;
|
SVNWCDBDoesNodeExists |
SELECT 1 FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2
LIMIT 1
|
SVNWCDbFindWCLock |
SELECT local_dir_relpath FROM wc_lock WHERE wc_id = ?1 AND local_dir_relpath
LIKE ?2 ESCAPE '#';
|
SVNWCDbHasServerExcludedNodes | |
SVNWCDbInsertActualConflictData |
INSERT INTO actual_node ( wc_id, local_relpath, conflict_data,
parent_relpath) VALUES (?1, ?2, ?3, ?4);
|
SVNWCDbInsertActualEmpties |
-- 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_list
|
SVNWCDbInsertActualNode |
-- STMT_INSERT_ACTUAL_NODE
INSERT OR REPLACE INTO actual_node (
wc_id, local_relpath, parent_relpath, properties, conflict_old,
conflict_new,
conflict_working, prop_reject, changelist, text_mod,
tree_conflict_data)
VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, NULL, ?10)
|
SVNWCDbInsertActualPropertiesConflicts |
INSERT INTO actual_node (
wc_id, local_relpath, prop_reject, parent_relpath)
VALUES (?1, ?2, ?3, ?4)
|
SVNWCDbInsertActualProps |
INSERT INTO actual_node (wc_id, local_relpath, parent_relpath, properties)
VALUES (?1, ?2, ?3, ?4);
|
SVNWCDbInsertActualTextConflicts |
INSERT INTO actual_node ( wc_id, local_relpath, conflict_old, conflict_new,
conflict_working, parent_relpath) VALUES (?1, ?2, ?3, ?4, ?5, ?6);
|
SVNWCDbInsertActualTreeConflicts |
INSERT INTO actual_node ( wc_id, local_relpath, tree_conflict_data,
parent_relpath) VALUES (?1, ?2, ?3, ?4);
|
SVNWCDbInsertDeleteFromBase |
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 = 0
|
SVNWCDbInsertDeleteFromNodeRecursive |
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')
|
SVNWCDbInsertDeleteList | |
SVNWCDbInsertExternal |
-- 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)
|
SVNWCDbInsertExternalUpgrade |
-- 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)
|
SVNWCDbInsertLock |
INSERT INTO lock (repos_id, repos_relpath, lock_token, lock_owner, lock_comment, lock_date) VALUES (?1, ?2,
?3, ?4, ?5, ?6);
|
SVNWCDbInsertNode |
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 ) VALUES (?1, ?2,
?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17, ?18,
?19);
|
SVNWCDbInsertOrIgnorePristine |
-- STMT_INSERT_OR_IGNORE_PRISTINE
INSERT OR IGNORE INTO pristine (checksum, md5_checksum, size, refcount)
VALUES (?1, ?2, ?3, 0)
|
SVNWCDbInsertPristine |
INSERT OR IGNORE INTO pristine (checksum, md5_checksum, size, refcount)
VALUES (?1, ?2, ?3, 0);
|
SVNWCDbInsertRepository |
INSERT INTO repository (root, uuid) VALUES (?1, ?2);
|
SVNWCDbInsertTarget | |
SVNWCDbInsertTarget2 | |
SVNWCDbInsertTargetDepthFiles | |
SVNWCDbInsertTargetDepthFilesWithChangelist | |
SVNWCDbInsertTargetDepthImmediates | |
SVNWCDbInsertTargetDepthImmediatesWithChangelist | |
SVNWCDbInsertTargetDepthInfinity | |
SVNWCDbInsertTargetDepthInfinityWithChangelist | |
SVNWCDbInsertTargetWithChangelist | |
SVNWCDbInsertWCLock |
INSERT INTO wc_lock (wc_id, local_dir_relpath, locked_levels) VALUES (?1, ?2,
?3);
|
SVNWCDbInsertWCRoot |
INSERT INTO wcroot (local_abspath) VALUES (?1);
|
SVNWCDbInsertWorkingNodeFromBase |
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;
|
SVNWCDbInsertWorkingNodeFromBaseCopy |
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;
|
SVNWCDbInsertWorkingNodeFromBaseCopyPresence |
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;
|
SVNWCDbInsertWorkingNodeNormalFromBase |
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;
|
SVNWCDbInsertWorkingNodeNotPresentFromBase |
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;
|
SVNWCDbInsertWorkItem |
INSERT INTO work_queue (work) VALUES (?1);
|
SVNWCDbInstallWorkingNodeForDelete |
INSERT OR REPLACE INTO nodes (
wc_id, local_relpath, op_depth,
parent_relpath, presence, kind)
SELECT wc_id, local_relpath, ?3 op_depth,
parent_relpath, ?4 presence, kind
FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0
|
SVNWCDbLookForWork |
SELECT id FROM work_queue LIMIT 1
|
SVNWCDbMarkSkippedChangelistDirs |
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'
|
SVNWCDbNodesBase |
CREATE VIEW NODES_BASE AS
SELECT * FROM nodes
WHERE op_depth = 0;
|
SVNWCDbNodesCurrent |
CREATE VIEW NODES_CURRENT AS
SELECT * FROM nodes AS n
WHERE op_depth = (SELECT MAX(op_depth) FROM nodes AS n2
WHERE n2.wc_id = n.wc_id
AND n2.local_relpath = n.local_relpath);
|
SVNWCDbNodesMaxOpDepth | |
SVNWCDbNodesMinOpDepth | |
SVNWCDbResetActualWithChangelist |
REPLACE INTO actual_node ( wc_id, local_relpath, parent_relpath, changelist)
VALUES (?1, ?2, ?3, ?4);
|
SVNWCDbSelectActualChildrenInfo |
SELECT prop_reject, changelist, conflict_old, conflict_new,
conflict_working, tree_conflict_data, properties, local_relpath,
conflict_data
FROM actual_node
WHERE wc_id = ?1 AND parent_relpath = ?2
|
SVNWCDbSelectActualChildrenTreeConflict |
SELECT local_relpath, tree_conflict_data FROM actual_node WHERE wc_id = ?1 AND
parent_relpath = ?2 AND tree_conflict_data IS NOT NULL;
|
SVNWCDbSelectActualConflictVictims |
SELECT local_relpath FROM actual_node WHERE wc_id = ?1 AND parent_relpath =
?2 AND NOT((prop_reject IS NULL) AND (conflict_old IS NULL) AND (conflict_new
IS NULL) AND (conflict_working IS NULL) AND (tree_conflict_data IS NULL))
|
SVNWCDbSelectActualNode |
select prop_reject, changelist, conflict_old, conflict_new,
conflict_working, tree_conflict_data, properties from actual_node
where wc_id = ?1 and local_relpath = ?2;
|
SVNWCDbSelectActualProperties |
select properties from actual_node where wc_id = ?1 and local_relpath = ?2;
|
SVNWCDbSelectActualTreeConflict |
SELECT tree_conflict_data FROM actual_node WHERE wc_id = ?1 AND local_relpath = ?2
AND tree_conflict_data IS NOT NULL;
|
SVNWCDbSelectAllFiles |
-- STMT_SELECT_ALL_FILES
SELECT DISTINCT local_relpath FROM nodes
WHERE wc_id = ?1 AND parent_relpath = ?2 AND kind = 'file'
|
SVNWCDbSelectAllServerExcludedNodes |
-- STMT_SELECT_ALL_SERVER_EXCLUDED_NODES
SELECT local_relpath FROM nodes
WHERE wc_id = ?1
AND (?2 = ''
OR local_relpath = ?2
OR IS_STRICT_DESCENDANT_OF(local_relpath, ?2))
AND op_depth = 0
AND presence = 'absent'
|
SVNWCDbSelectAncestorWCLocks |
SELECT local_dir_relpath, locked_levels FROM wc_lock
WHERE wc_id = ?1
AND ((local_dir_relpath <= ?2 AND local_dir_relpath >= ?3)
OR local_dir_relpath = '')
ORDER BY local_dir_relpath DESC
|
SVNWCDbSelectAnyPristineReference |
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 1
|
SVNWCDbSelectBaseDavCache |
-- STMT_SELECT_BASE_DAV_CACHE
SELECT dav_cache FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0
|
SVNWCDbSelectBaseNode |
SELECT repos_id, repos_path, presence, kind, revision, checksum,
translated_size, changed_revision, changed_date, changed_author, depth,
symlink_target, last_mod_time, properties FROM nodes WHERE wc_id = ?1 AND
local_relpath = ?2 AND op_depth = 0;
|
SVNWCDbSelectBaseNodeChildren |
SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND
op_depth = 0;
|
SVNWCDbSelectBaseNodeWithLock |
SELECT nodes.repos_id, nodes.repos_path, presence, kind, revision, checksum,
translated_size, changed_revision, changed_date, changed_author, depth,
symlink_target, last_mod_time, properties, lock_token, lock_owner,
lock_comment, lock_date FROM nodes LEFT OUTER JOIN lock ON nodes.repos_id =
lock.repos_id AND nodes.repos_path = lock.repos_relpath WHERE wc_id = ?1 AND
local_relpath = ?2 AND op_depth = 0;
|
SVNWCDbSelectBaseProperties |
SELECT properties FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth = 0;
|
SVNWCDbSelectChangelist |
STMT_SELECT_CHANGELIST_LIST
SELECT wc_id, local_relpath, notify, changelist
FROM changelist_list
ORDER BY wc_id, local_relpath
|
SVNWCDbSelectConflictDetails |
SELECT prop_reject, conflict_old, conflict_new, conflict_working, tree_conflict_data FROM
actual_node WHERE wc_id = ?1 AND local_relpath = ?2;
|
SVNWCDbSelectDeletionInfo |
SELECT nodes_base.presence, nodes_work.presence, nodes_work.moved_to FROM
nodes nodes_work LEFT OUTER JOIN nodes nodes_base ON nodes_base.wc_id =
nodes_work.wc_id AND nodes_base.local_relpath = nodes_work.local_relpath AND
nodes_base.op_depth = 0 WHERE nodes_work.wc_id = ?1 AND
nodes_work.local_relpath = ?2 AND nodes_work.op_depth = (SELECT MAX(op_depth)
FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0);
|
SVNWCDBSelectExternalProperties |
SELECT IFNULL((SELECT properties FROM actual_node a
WHERE a.wc_id = ?1 AND A.local_relpath = n.local_relpath),
properties),
local_relpath, depth
FROM nodes n
WHERE wc_id = ?1
AND (?2 = ''
OR local_relpath = ?2
OR (local_relpath > ?2 || '/' AND local_relpath < ?2 || '0'))
AND kind = 'dir' AND presence='normal'
AND op_depth=(SELECT MAX(op_depth) FROM nodes o
WHERE o.wc_id = ?1 AND o.local_relpath = n.local_relpath)
|
SVNWCDBSelectExternalsDefined |
SELECT local_relpath, def_local_relpath
FROM externals
WHERE wc_id = ?1
AND (?2 = ''
OR def_local_relpath = ?2
OR (def_local_relpath > ?2 || '/' AND def_local_relpath < ?2 || '0'))
|
SVNWCDBSelectFileExternal |
SELECT file_external FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth = 0;
|
SVNWCDbSelectGeOpDepthChildren | |
SVNWCDbSelectLock | |
SVNWCDbSelectLowestWorkingNode |
SELECT op_depth, presence FROM nodes WHERE wc_id = ?1 AND local_relpath = ?2
AND op_depth > 0 ORDER BY op_depth LIMIT 1;
|
SVNWCDbSelectNodeChildrenInfo |
SELECT op_depth, nodes.repos_id, nodes.repos_path, presence, kind, revision,
checksum, translated_size, changed_revision, changed_date, changed_author,
depth, symlink_target, last_mod_time, properties, lock_token, lock_owner,
lock_comment, lock_date, local_relpath
FROM nodes
LEFT OUTER JOIN lock ON nodes.repos_id = lock.repos_id
AND nodes.repos_path = lock.repos_relpath
WHERE wc_id = ?1 AND parent_relpath = ?2
|
SVNWCDbSelectNodeChildrenWalkerInfo |
SELECT local_relpath, op_depth, presence, kind
FROM nodes
WHERE wc_id = ?1 AND parent_relpath = ?2
GROUP BY local_relpath
ORDER BY op_depth DESC
We omit GROUP BY, it is not really needed, and ORDER BY is achieved by use of a reverse cursor.
|
SVNWCDbSelectNodeInfo |
SELECT op_depth, repos_id, repos_path, presence, kind, revision, checksum,
translated_size, changed_revision, changed_date, changed_author, depth,
symlink_target, last_mod_time, properties
FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2
ORDER BY op_depth DESC
|
SVNWCDbSelectNodeInfoWithLock |
SELECT op_depth, nodes.repos_id, nodes.repos_path, presence, kind, revision,
checksum, translated_size, changed_revision, changed_date, changed_author,
depth, symlink_target, last_mod_time, properties, lock_token, lock_owner,
lock_comment, lock_date
FROM nodes
LEFT OUTER JOIN lock ON nodes.repos_id = lock.repos_id
AND nodes.repos_path = lock.repos_relpath
WHERE wc_id = ?1 AND local_relpath = ?2
ORDER BY op_depth DESC
|
SVNWCDbSelectNodeProps |
SELECT properties, presence FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2
ORDER BY op_depth DESC;
|
SVNWCDbSelectNotPresent |
-- STMT_SELECT_NOT_PRESENT_DESCENDANTS
SELECT local_relpath FROM nodes
WHERE wc_id = ?1 AND op_depth = ?3
AND (parent_relpath = ?2
OR IS_STRICT_DESCENDANT_OF(parent_relpath, ?2))
AND presence == 'not-present'
|
SVNWCDbSelectOpDepthChildren |
SELECT local_relpath FROM nodes WHERE wc_id = ?1 AND parent_relpath = ?2 AND
op_depth = ?3;
|
SVNWCDbSelectPristineMD5Checksum |
SELECT md5_checksum FROM pristine WHERE checksum = ?1
|
SVNWCDbSelectRepository |
SELECT id FROM repository WHERE root = ?1;
|
SVNWCDbSelectRepositoryById |
select root, uuid from repository where id = ?1;
|
SVNWCDbSelectRevertListCopiedChildren | |
SVNWCDbSelectSHA1Checksum |
SELECT checksum FROM pristine WHERE md5_checksum = ?1
|
SVNWCDbSelectTargetslist |
SELECT local_relpath FROM targets_list
WHERE kind = 'file' AND wc_id = ?1
|
SVNWCDbSelectUnreferencedPristines |
-- STMT_SELECT_UNREFERENCED_PRISTINES
SELECT checksum
FROM pristine
WHERE refcount = 0
|
SVNWCDbSelectWCLock |
SELECT locked_levels FROM WC_LOCK WHERE wc_id = ?1 AND local_dir_relpath =
?2;
|
SVNWCDbSelectWCRootNull |
select id from wcroot where local_abspath is null;
|
SVNWCDbSelectWorkingChildren |
SELECT local_relpath FROM nodes
WHERE wc_id = ?1 AND parent_relpath = ?2
AND (op_depth > (SELECT MAX(op_depth) FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2)
OR
(op_depth = (SELECT MAX(op_depth) FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2)
AND presence != 'base-deleted'))
|
SVNWCDbSelectWorkingNode |
SELECT presence, kind, checksum, translated_size, changed_revision,
changed_date, changed_author, depth, symlink_target, repos_id, repos_path,
revision, moved_here, moved_to, last_mod_time, properties FROM nodes WHERE
wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0 ORDER BY op_depth DESC
LIMIT 1;
|
SVNWCDbSelectWorkingNodeChildren |
SELECT local_relpath FROM nodes
WHERE wc_id = ?1 AND parent_relpath = ?2
AND (op_depth > (SELECT MAX(op_depth) FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2)
OR
(op_depth = (SELECT MAX(op_depth) FROM nodes
WHERE wc_id = ?1 AND local_relpath = ?2)
AND presence != 'base-deleted'))
|
SVNWCDbSelectWorkItem |
SELECT id, work FROM work_queue ORDER BY id LIMIT 1;
|
SVNWCDbUpdateActualChangelists |
UPDATE actual_node SET changelist = ?3
WHERE wc_id = ?1 AND local_relpath = ?2
|
SVNWCDbUpdateActualConflictData |
UPDATE actual_node SET conflict_data = ?3 WHERE wc_id = ?1 AND local_relpath
= ?2;
|
SVNWCDbUpdateActualPropertyConflicts |
UPDATE actual_node SET prop_reject = ?3 WHERE wc_id = ?1 AND local_relpath =
?2;
|
SVNWCDbUpdateActualProps |
UPDATE actual_node SET properties = ?3 WHERE wc_id = ?1 AND local_relpath =
?2;
|
SVNWCDbUpdateActualTextConflicts |
UPDATE actual_node SET conflict_old = ?3, conflict_new = ?4, conflict_working
= ?5 WHERE wc_id = ?1 AND local_relpath = ?2;
|
SVNWCDbUpdateActualTreeConflicts |
UPDATE actual_node SET tree_conflict_data = ?3 WHERE wc_id = ?1 AND
local_relpath = ?2;
|
SVNWCDbUpdateBaseNodeDavCache |
-- STMT_UPDATE_BASE_NODE_DAV_CACHE
UPDATE nodes SET dav_cache = ?3
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0
|
SVNWCDbUpdateBaseRevision |
UPDATE nodes SET revision = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth = 0;
|
SVNWCDbUpdateCopyfrom |
UPDATE nodes SET repos_id = ?3, repos_path = ?4 WHERE wc_id = ?1 AND
local_relpath = ?2; AND op_depth = (SELECT MAX(op_depth) FROM nodes WHERE
wc_id = ?1 AND local_relpath = ?2 AND op_depth > 0);
|
SVNWCDbUpdateNodeBaseDepth |
UPDATE nodes SET depth = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth = 0;
|
SVNWCDbUpdateNodeBasePresence |
UPDATE nodes SET presence = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth = 0;
|
SVNWCDbUpdateNodeFileinfo |
UPDATE nodes SET translated_size = ?3, last_mod_time = ?4 WHERE wc_id = ?1
AND local_relpath = ?2 AND op_depth = (SELECT MAX(op_depth) FROM nodes WHERE
wc_id = ?1 AND local_relpath = ?2);
|
SVNWCDbUpdateNodeProperties |
-- STMT_UPDATE_NODE_PROPS
UPDATE nodes SET properties = ?4
WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = ?3
|
SVNWCDbUpdateNodeWorkingDepth |
UPDATE nodes SET depth = ?3 WHERE wc_id = ?1 AND local_relpath = ?2 AND
op_depth = (SELECT MAX(op_depth) FROM nodes WHERE wc_id = ?1 AND
local_relpath = ?2 AND op_depth > 0);
|
SVNWCDbUpdateOpDepthIncreaseRecursive | |
SVNWCDDBUpdateActualClearChangelist |
Copyright © 2004-2012 TMate Software Ltd. All Rights Reserved.