public long exec() throws SVNException { Map<String, Object> values = new HashMap<String, Object>(); values.put(SVNWCDbSchema.WORK_QUEUE__Fields.work.toString(), getBind(1)); try { return table.insertByFieldNames(values); } catch (SqlJetException e) { SVNSqlJetDb.createSqlJetError(e); return 0; } }
public long exec() throws SVNException { Map<String, Object> values = new HashMap<String, Object>(); values.put(SVNWCDbSchema.WC_LOCK__Fields.wc_id.toString(), getBind(1)); values.put(SVNWCDbSchema.WC_LOCK__Fields.local_dir_relpath.toString(), getBind(2)); values.put(SVNWCDbSchema.WC_LOCK__Fields.locked_levels.toString(), getBind(3)); try { return table.insertByFieldNames(values); } catch (SqlJetException e) { SVNSqlJetDb.createSqlJetError(e); return 0; } }
/** * DROP TRIGGER IF EXISTS trigger_changelist_list_actual_cl_insert; * CREATE TEMPORARY TRIGGER trigger_changelist_list_actual_cl_insert * BEFORE INSERT ON actual_node * BEGIN * INSERT INTO changelist_list(wc_id, local_relpath, notify, changelist) * VALUES (NEW.wc_id, NEW.local_relpath, 26, NEW.changelist); * END; */ public void beforeInsert(SqlJetConflictAction conflictAction, ISqlJetTable table, Map<String, Object> newValues) throws SqlJetException { ISqlJetTable clltable = db.getDb().getTemporaryDatabase().getTable(SVNWCDbSchema.CHANGELIST_LIST.toString()); Map<String, Object> rowValues = new HashMap<String, Object>(); rowValues.put(CHANGELIST_LIST__Fields.wc_id.toString(), newValues.get(ACTUAL_NODE__Fields.wc_id.toString())); rowValues.put(CHANGELIST_LIST__Fields.local_relpath.toString(), newValues.get(ACTUAL_NODE__Fields.local_relpath.toString())); rowValues.put(CHANGELIST_LIST__Fields.notify.toString(), 26); rowValues.put(CHANGELIST_LIST__Fields.changelist.toString(), newValues.get(ACTUAL_NODE__Fields.changelist.toString())); clltable.insertByFieldNames(rowValues); }
public long exec() throws SVNException { try { int n = 0; while (select.next()) { try { table.insertByFieldNames(getInsertValues()); n++; } catch (SqlJetException e) { SVNSqlJetDb.createSqlJetError(e); return -1; } } return n; } finally { select.reset(); } }
rowValues.put(CHANGELIST_LIST__Fields.changelist.toString(), cursor.getValue(ACTUAL_NODE__Fields.changelist.toString())); table.insertByFieldNames(rowValues); rowValues.put(CHANGELIST_LIST__Fields.changelist.toString(), newValues.get(ACTUAL_NODE__Fields.changelist.toString())); table.insertByFieldNames(rowValues);