private String[] getInsertSql(ColumnTypeHelper helper, WriteRowsEvent event, ITableReplicator rep)
throws UnsupportedEncodingException {
RDBSchnauzer table = (RDBSchnauzer) rep;
if (rep.isMergeTable() && slaveDb.isMySQL()) {
return getInsertUpdateSql(helper, event, table);
} else if (rep.isMergeTable() && slaveDb.isSQLServer()) {
return getInsUpSqlSql(helper, event, table);
} else if (this.slaveDb.isSQLServer2000()) {
return getSql2000Sql(helper, event, table);
} else {
return getCommInsertSql(helper, event, table);
}
}
@Override
public boolean doDelete(ColumnTypeHelper helper, DeleteRowsEvent event) {
boolean need = false;
String[] sqls = null;
int index = 0;
doBeforeDelete(helper, event);
for (int i = 0; i < tables.size(); i++) {
RDBSchnauzer rep = (RDBSchnauzer) tables.get(i);
if (notEqualS(helper.databaseName, masterDb.dbname)) continue;
if (notEqualS(helper.tableName, rep.getMasterTableName())) continue;
List<Row> rows = event.getRows();
for (int j = 0; j < rows.size(); j++) {
Row row = rows.get(j);
List<Column> columns = row.getColumns();
if (sqls == null) {
sqls = new String[rows.size() * tables.size() + 1];
sqls[0] = getStatusUpdateSql(helper);
}
need = true;
try {
sqls[++index] = rep.getDelete() + getWhereStr(rep, columns, helper);
} catch (Exception e) {
mailAndLog(Infos.Create + Infos.DoDelete + Infos.Failed, e.getMessage());
return false;
}
}
}
String[] errInfo = new String[1];
if (!need || !logSql(sqls)) {
autoSetPosition(helper);
return true;
}
if (dbhelper.excuteSqlByTransaction(sqls, errInfo)) {
slaveDb.binlog = this.getBinLogName(helper);
slaveDb.pos = helper.position;
slaveDb.tablepos = helper.tableMapPos;
LOGGER.info(Infos.DoDelete + Infos.OK);
return true;
}
String sInfo = getWarning(sqls, errInfo);
mailAndLog(Infos.DoDelete + Infos.Failed, sInfo);
rollBackToTableEvent(helper);
return false;
}
private void getTheLastBinlogAndPos() {
try {
MySQLDbHelper mhelper = new MySQLDbHelper(masterDb);
ResultSet rs = mhelper.getRS("show master logs");
String binlog = "";
Long pos = 0L;
while (rs.next()) {
binlog = rs.getString("log_name");
}
rs.close();
rs = mhelper.getRS("show binlog events in '" + binlog + "'");
while (rs.next()) {
pos = rs.getLong("pos");
}
rs.close();
masterDb.binlog = binlog;
masterDb.pos = pos;
slaveDb.binlog = binlog;
slaveDb.pos = pos;
} catch (Exception e) {
ErrorHelper.errExit("Get binlog filename " + Infos.Failed + ": " + e.getMessage());
}
}