Class SVNWCDBSelectExternalProperties
java.lang.Object
org.tmatesoft.svn.core.internal.db.SVNSqlJetStatement
org.tmatesoft.svn.core.internal.db.SVNSqlJetTableStatement
org.tmatesoft.svn.core.internal.db.SVNSqlJetSelectStatement
org.tmatesoft.svn.core.internal.wc17.db.statement.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)
-
Field Summary
FieldsFields inherited from class org.tmatesoft.svn.core.internal.db.SVNSqlJetTableStatement
table, tableName
Fields inherited from class org.tmatesoft.svn.core.internal.db.SVNSqlJetStatement
binds, sDb, transactionMode
-
Constructor Summary
Constructors -
Method Summary
Methods inherited from class org.tmatesoft.svn.core.internal.db.SVNSqlJetSelectStatement
eof, getColumn, getColumnBlob, getColumnLong, getColumnString, getIndexName, getRowPath, getRowPathField, getRowValues, getRowValues2, isColumnNull, isPathScopeInIndex, isStrictDescendantOf, isStrictiDescendant, next, openCursor, reset, setIndexName
Methods inherited from class org.tmatesoft.svn.core.internal.db.SVNSqlJetTableStatement
addTrigger, getTable, getTableName, getTriggers, statementCompleted, statementStarted
Methods inherited from class org.tmatesoft.svn.core.internal.db.SVNSqlJetStatement
bindBlob, bindChecksum, bindf, bindIProperties, bindLong, bindNull, bindProperties, bindRevision, bindString, count, done, exec, getBind, getBinds, getColumn, getColumnBlob, getColumnBoolean, getColumnInheritedProperties, getColumnInheritedProperties, getColumnLong, getColumnProperties, getColumnRevnum, getColumnString, getCursor, getJoinedStatement, getJoinedStatement, hasColumnInheritedProperties, hasColumnInheritedProperties, hasColumnProperties, hasColumnProperties, insert, isColumnNull, isNeedsReset, nextRow, parseInheritedProperties, parseProperties, setCursor
-
Field Details
-
maxOpDepthSelect
-
propertiesSelect
-
-
Constructor Details
-
SVNWCDBSelectExternalProperties
- Throws:
SVNException
-
-
Method Details
-
isFilterPassed
- Overrides:
isFilterPassed
in classSVNSqlJetSelectStatement
- Throws:
SVNException
-
hasMaxOpDepth
- Throws:
SVNException
-
getColumnProperties
- Overrides:
getColumnProperties
in classSVNSqlJetStatement
- Throws:
SVNException
-
getWhere
- Overrides:
getWhere
in classSVNSqlJetSelectStatement
- Throws:
SVNException
-
getPathScope
- Overrides:
getPathScope
in classSVNSqlJetSelectStatement
-