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
-
public class SVNWCDBSelectExternalProperties extends SVNSqlJetSelectStatement
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
Fields Modifier and Type Field Description private SVNWCDbNodesMaxOpDepth
maxOpDepthSelect
private SVNSqlJetSelectStatement
propertiesSelect
-
Fields 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 Constructor Description SVNWCDBSelectExternalProperties(SVNSqlJetDb sDb)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description SVNProperties
getColumnProperties(java.lang.String f)
protected java.lang.String
getPathScope()
protected java.lang.Object[]
getWhere()
private boolean
hasMaxOpDepth()
protected boolean
isFilterPassed()
-
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 Detail
-
maxOpDepthSelect
private SVNWCDbNodesMaxOpDepth maxOpDepthSelect
-
propertiesSelect
private SVNSqlJetSelectStatement propertiesSelect
-
-
Constructor Detail
-
SVNWCDBSelectExternalProperties
public SVNWCDBSelectExternalProperties(SVNSqlJetDb sDb) throws SVNException
- Throws:
SVNException
-
-
Method Detail
-
isFilterPassed
protected boolean isFilterPassed() throws SVNException
- Overrides:
isFilterPassed
in classSVNSqlJetSelectStatement
- Throws:
SVNException
-
hasMaxOpDepth
private boolean hasMaxOpDepth() throws SVNException
- Throws:
SVNException
-
getColumnProperties
public SVNProperties getColumnProperties(java.lang.String f) throws SVNException
- Overrides:
getColumnProperties
in classSVNSqlJetStatement
- Throws:
SVNException
-
getWhere
protected java.lang.Object[] getWhere() throws SVNException
- Overrides:
getWhere
in classSVNSqlJetSelectStatement
- Throws:
SVNException
-
getPathScope
protected java.lang.String getPathScope()
- Overrides:
getPathScope
in classSVNSqlJetSelectStatement
-
-