protected boolean sql(CsvData data) { try { statistics.get(batch).startTimer(DataWriterStatisticConstants.DATABASEMILLIS); String script = data.getParsedData(CsvData.ROW_DATA)[0]; List<String> sqlStatements = getSqlStatements(script); long count = 0; for (String sql : sqlStatements) { sql = preprocessSqlStatement(sql); transaction.prepare(sql); if (log.isDebugEnabled()) { log.debug("About to run: {}", sql); } count += transaction.prepareAndExecute(sql); if (log.isDebugEnabled()) { log.debug("{} rows updated when running: {}", count, sql); } } statistics.get(batch).increment(DataWriterStatisticConstants.SQLCOUNT); statistics.get(batch).increment(DataWriterStatisticConstants.SQLROWSAFFECTEDCOUNT, count); return true; } finally { statistics.get(batch).stopTimer(DataWriterStatisticConstants.DATABASEMILLIS); } }
public void insertDataEvents(ISqlTransaction transaction, final List<DataEvent> events) { if (events.size() > 0) { transaction.prepare(getSql("insertIntoDataEventSql")); for (DataEvent dataEvent : events) { String routerId = dataEvent.getRouterId(); transaction.addRow( dataEvent, new Object[] { dataEvent.getDataId(), dataEvent.getBatchId(), StringUtils.isBlank(routerId) ? Constants.UNKNOWN_ROUTER_ID : routerId }, new int[] { Types.NUMERIC, Types.NUMERIC, Types.VARCHAR }); } transaction.flush(); } }
log.debug("Preparing dml: " + this.currentDmlStatement.getSql()); transaction.prepare(this.currentDmlStatement.getSql());
log.debug("Preparing dml: " + this.currentDmlStatement.getSql()); transaction.prepare(this.currentDmlStatement.getSql());
log.debug("Preparing dml: " + this.currentDmlStatement.getSql()); transaction.prepare(this.currentDmlStatement.getSql());