Package org.tmatesoft.svn.core.internal.wc17.db.statement

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

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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

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 class SVNSqlJetSelectStatement

Throws:

SVNException

hasMaxOpDepth

private boolean hasMaxOpDepth()
                       throws SVNException

Throws:

SVNException

getColumnProperties

public SVNProperties getColumnProperties(java.lang.String f)
                                  throws SVNException

Overrides:

getColumnProperties in class SVNSqlJetStatement

Throws:

SVNException

getWhere

protected java.lang.Object[] getWhere()
                               throws SVNException

Overrides:

getWhere in class SVNSqlJetSelectStatement

Throws:

SVNException

getPathScope

protected java.lang.String getPathScope()

Overrides:

getPathScope in class SVNSqlJetSelectStatement