Class and Description |
---|
SVNWCDbStatements |
Class and Description |
---|
SVNWCDbSelectDeletionInfo
SELECT (SELECT b.presence FROM nodes AS b
WHERE b.wc_id = ?1 AND b.local_relpath = ?2 AND b.op_depth = 0),
work.presence, work.op_depth
FROM nodes_current AS work
WHERE work.wc_id = ?1 AND work.local_relpath = ?2 AND work.op_depth > 0
LIMIT 1
|
Class and Description |
---|
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'))
|
SVNWCDbCreateSchema.Statement |
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'))
|
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)
|
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;
|
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);
|
SVNWCDbSchema |
SVNWCDbSchema.ACTUAL_NODE__Fields |
SVNWCDbSchema.ACTUAL_NODE__Indices |
SVNWCDbSchema.BASE_NODE__Fields |
SVNWCDbSchema.CHANGELIST_LIST__Fields |
SVNWCDbSchema.DELETE_LIST__Fields |
SVNWCDbSchema.Empty |
SVNWCDbSchema.EXTERNALS__Fields |
SVNWCDbSchema.LOCK__Fields |
SVNWCDbSchema.NODE_PROPS_CACHE__Fields |
SVNWCDbSchema.NODES__Fields |
SVNWCDbSchema.NODES__Indices |
SVNWCDbSchema.PRISTINE__Fields |
SVNWCDbSchema.REPOSITORY__Fields |
SVNWCDbSchema.REPOSITORY__Indices |
SVNWCDbSchema.REVERT_LIST__Fields |
SVNWCDbSchema.REVPROP__Fields |
SVNWCDbSchema.TARGETS_LIST__Fields |
SVNWCDbSchema.TARGETS_LIST__Indices |
SVNWCDbSchema.UPDATE_MOVE_LIST__Fields |
SVNWCDbSchema.WC_LOCK__Fields |
SVNWCDbSchema.WCROOT__Fields |
SVNWCDbSchema.WCROOT__Indices |
SVNWCDbSchema.WORK_QUEUE__Fields |
SVNWCDbSchema.WORKING_NODE__Fields |
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;
|
SVNWCDbSelectCommittableExternalsImmediatelyBelow
SELECT local_relpath, kind, def_repos_relpath,
(SELECT root FROM repository AS r WHERE r.id = e.repos_id)
FROM externals e
WHERE wc_id = ?1
AND IS_STRICT_DESCENDANT_OF(e.local_relpath, ?2)
AND parent_relpath = ?2
AND def_revision IS NULL
AND repos_id = (SELECT repos_id
FROM nodes AS n
WHERE n.wc_id = ?1
AND n.local_relpath = ''
AND n.op_depth = 0)
AND ((kind='dir')
OR EXISTS (SELECT 1 FROM nodes
WHERE nodes.wc_id = e.wc_id
AND nodes.local_relpath = e.parent_relpath))
|
SVNWCDbSelectDeletionInfo
SELECT (SELECT b.presence FROM nodes AS b
WHERE b.wc_id = ?1 AND b.local_relpath = ?2 AND b.op_depth = 0),
work.presence, work.op_depth
FROM nodes_current AS work
WHERE work.wc_id = ?1 AND work.local_relpath = ?2 AND work.op_depth > 0
LIMIT 1
|
SVNWCDbSelectDeletionInfo.InternalSelect |
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
|
SVNWCDbStatements |
Copyright © 2023. All rights reserved.