/*
* ====================================================================
* Copyright (c) 2004-2010 TMate Software Ltd. All rights reserved.
*
* This software is licensed as described in the file COPYING, which
* you should have received as part of this distribution. The terms
* are also available at http://svnkit.com/license.html.
* If newer versions of this license are posted there, you may use a
* newer version instead, at your option.
* ====================================================================
*/
package org.tmatesoft.svn.core.internal.wc17.db.statement;
import java.util.Map;
import org.tmatesoft.sqljet.core.SqlJetException;
import org.tmatesoft.sqljet.core.schema.SqlJetConflictAction;
import org.tmatesoft.svn.core.SVNException;
import org.tmatesoft.svn.core.internal.db.SVNSqlJetDb;
import org.tmatesoft.svn.core.internal.db.SVNSqlJetInsertStatement;
import org.tmatesoft.svn.core.internal.db.SVNSqlJetSelectStatement;
/**
* INSERT OR REPLACE INTO nodes ( wc_id, local_relpath, op_depth,
* parent_relpath, presence, kind, checksum, changed_revision, changed_date,
* changed_author, depth, symlink_target, translated_size, last_mod_time,
* properties) SELECT wc_id, local_relpath, ?3 AS op_depth, parent_relpath, ?4
* AS presence, kind, checksum, changed_revision, changed_date, changed_author,
* depth, symlink_target, translated_size, last_mod_time, properties FROM nodes
* WHERE wc_id = ?1 AND local_relpath = ?2 AND op_depth = 0;
*
* @version 1.4
* @author TMate Software Ltd.
*/
public class SVNWCDbInsertWorkingNodeFromBase extends SVNSqlJetInsertStatement {
private SVNSqlJetSelectStatement select;
public SVNWCDbInsertWorkingNodeFromBase(SVNSqlJetDb sDb) throws SVNException {
super(sDb, SVNWCDbSchema.NODES);
select = new SVNSqlJetSelectStatement(sDb, SVNWCDbSchema.NODES);
}
public long exec() throws SVNException {
select.bindf("isi", getBind(1), getBind(2), 0);
try {
int n = 0;
while (select.next()) {
try {
table.insertByFieldNamesOr(SqlJetConflictAction.REPLACE, getInsertValues());
n++;
} catch (SqlJetException e) {
SVNSqlJetDb.createSqlJetError(e);
return -1;
}
}
return n;
} finally {
select.reset();
}
}
protected Map<String, Object> getInsertValues() throws SVNException {
Map<String, Object> rowValues = select.getRowValues();
rowValues.put(SVNWCDbSchema.NODES__Fields.wc_id.toString(), select.getColumn(SVNWCDbSchema.NODES__Fields.wc_id));
rowValues.put(SVNWCDbSchema.NODES__Fields.local_relpath.toString(), select.getColumn(SVNWCDbSchema.NODES__Fields.local_relpath));
rowValues.put(SVNWCDbSchema.NODES__Fields.op_depth.toString(), getBind(3));
rowValues.put(SVNWCDbSchema.NODES__Fields.parent_relpath.toString(), select.getColumn(SVNWCDbSchema.NODES__Fields.parent_relpath));
rowValues.put(SVNWCDbSchema.NODES__Fields.presence.toString(), getBind(4));
rowValues.put(SVNWCDbSchema.NODES__Fields.kind.toString(), select.getColumn(SVNWCDbSchema.NODES__Fields.kind));
rowValues.put(SVNWCDbSchema.NODES__Fields.checksum.toString(), select.getColumn(SVNWCDbSchema.NODES__Fields.checksum));
rowValues.put(SVNWCDbSchema.NODES__Fields.changed_revision.toString(), select.getColumn(SVNWCDbSchema.NODES__Fields.changed_revision));
rowValues.put(SVNWCDbSchema.NODES__Fields.changed_date.toString(), select.getColumn(SVNWCDbSchema.NODES__Fields.changed_date));
rowValues.put(SVNWCDbSchema.NODES__Fields.changed_author.toString(), select.getColumn(SVNWCDbSchema.NODES__Fields.changed_author));
rowValues.put(SVNWCDbSchema.NODES__Fields.depth.toString(), select.getColumn(SVNWCDbSchema.NODES__Fields.depth));
rowValues.put(SVNWCDbSchema.NODES__Fields.symlink_target.toString(), select.getColumn(SVNWCDbSchema.NODES__Fields.symlink_target));
rowValues.put(SVNWCDbSchema.NODES__Fields.translated_size.toString(), select.getColumn(SVNWCDbSchema.NODES__Fields.translated_size));
rowValues.put(SVNWCDbSchema.NODES__Fields.last_mod_time.toString(), select.getColumn(SVNWCDbSchema.NODES__Fields.last_mod_time));
rowValues.put(SVNWCDbSchema.NODES__Fields.properties.toString(), select.getColumnBlob(SVNWCDbSchema.NODES__Fields.properties));
return rowValues;
}
}