package org.tmatesoft.svn.core.internal.wc17.db.statement; import org.tmatesoft.svn.core.SVNException; import org.tmatesoft.svn.core.internal.db.SVNSqlJetDb; import org.tmatesoft.svn.core.internal.db.SVNSqlJetDeleteStatement; /** * DELETE FROM nodes * WHERE wc_id = ?1 AND (((local_relpath) > (CASE (?2) WHEN '' THEN '' ELSE (?2) || '/' END)) AND ((local_relpath) < CASE (?2) WHEN '' THEN X'FFFF' ELSE (?2) || '0' END)) * AND presence = 'base-deleted' * AND op_depth > 0 * AND op_depth = (SELECT MIN(op_depth) FROM nodes n * WHERE n.wc_id = ?1 * AND n.local_relpath = nodes.local_relpath * AND op_depth > 0) */ public class SVNWCDbDeleteWorkingBaseDelete extends SVNSqlJetDeleteStatement { private SVNWCDbNodesMinOpDepth minOpDepthSelect; private Long minOpDepth = null; public SVNWCDbDeleteWorkingBaseDelete(SVNSqlJetDb sDb) throws SVNException { super(sDb, SVNWCDbSchema.NODES); minOpDepthSelect = new SVNWCDbNodesMinOpDepth(sDb, 1); } @Override public void reset() throws SVNException { minOpDepth = null; super.reset(); } @Override protected boolean isFilterPassed() throws SVNException { String presenceString = getColumnString(SVNWCDbSchema.NODES__Fields.presence); long opDepth = getColumnLong(SVNWCDbSchema.NODES__Fields.op_depth); return "base-deleted".equals(presenceString) && opDepth > 0 && opDepth == minOpDepth; } @Override protected Object[] getWhere() throws SVNException { minOpDepth = minOpDepthSelect.getMinOpDepth((Long)getBind(1), getBind(2).toString()); return new Object[]{getBind(1)}; } @Override protected String getPathScope() { return getBind(2).toString(); } @Override protected boolean isStrictiDescendant() { return true; } }