@Override
public boolean onRowData(String dataNode, byte[] rowData) {
RowDataPacket rowDataPkgold = ResultSetUtil.parseRowData(rowData, bfields);
// 获取Id字段，
String id = ByteUtil.getString(rowDataPkgold.fieldValues.get(joinR));
// 查找ID对应的A表的记录
byte[] arow = getRow(id, joinL); // arows.remove(id);
while (arow != null) {
RowDataPacket rowDataPkg = ResultSetUtil.parseRowData(arow, afields); // ctx.getAllFields());
for (int i = 1; i < rowDataPkgold.fieldCount; i++) {
// 设置b.name 字段
byte[] bname = rowDataPkgold.fieldValues.get(i);
rowDataPkg.add(bname);
rowDataPkg.addFieldCount(1);
}
// RowData(rowDataPkg);
ctx.writeRow(rowDataPkg);
arow = getRow(id, joinL);
}
return false;
}
public static void execute(ManagerConnection c) {
ByteBuffer buffer = c.allocate();
buffer = header.write(buffer, c, true);
for (FieldPacket field : fields) {
buffer = field.write(buffer, c, true);
}
buffer = eof.write(buffer, c, true);
byte packetId = eof.packetId;
String charset = c.getCharset();
for (NIOProcessor p : MycatServer.getInstance().getProcessors()) {
for (BackendConnection bc : p.getBackends().values()) {
if (bc != null) {
RowDataPacket row = getRow(bc, charset);
row.packetId = ++packetId;
buffer = row.write(buffer, c, true);
}
}
}
EOFPacket lastEof = new EOFPacket();
lastEof.packetId = ++packetId;
buffer = lastEof.write(buffer, c, true);
c.write(buffer);
}
private static RowDataPacket getRow(BackendConnection c, String charset) {
RowDataPacket row = new RowDataPacket(FIELD_COUNT);
if (c instanceof BackendAIOConnection) {
row.add(((BackendAIOConnection) c).getProcessor().getName().getBytes());
} else if (c instanceof JDBCConnection) {
row.add(((JDBCConnection) c).getProcessor().getName().getBytes());
} else {
row.add("N/A".getBytes());
}
row.add(LongUtil.toBytes(c.getId()));
long threadId = 0;
if (c instanceof MySQLConnection) {
threadId = ((MySQLConnection) c).getThreadId();
}
row.add(LongUtil.toBytes(threadId));
row.add(StringUtil.encode(c.getHost(), charset));
row.add(IntegerUtil.toBytes(c.getPort()));
row.add(IntegerUtil.toBytes(c.getLocalPort()));
row.add(LongUtil.toBytes(c.getNetInBytes()));
row.add(LongUtil.toBytes(c.getNetOutBytes()));
row.add(LongUtil.toBytes((TimeUtil.currentTimeMillis() - c.getStartupTime()) / 1000L));
row.add(c.isClosed() ? "true".getBytes() : "false".getBytes());
// boolean isRunning = c.isRunning();
// row.add(isRunning ? "true".getBytes() : "false".getBytes());
boolean isBorrowed = c.isBorrowed();
row.add(isBorrowed ? "true".getBytes() : "false".getBytes());
int writeQueueSize = 0;
String schema = "";
String charsetInf = "";
String txLevel = "";
String txAutommit = "";
if (c instanceof MySQLConnection) {
MySQLConnection mysqlC = (MySQLConnection) c;
writeQueueSize = mysqlC.getWriteQueue().size();
schema = mysqlC.getSchema();
charsetInf = mysqlC.getCharset() + ":" + mysqlC.getCharsetIndex();
txLevel = mysqlC.getTxIsolation() + "";
txAutommit = mysqlC.isAutocommit() + "";
}
row.add(IntegerUtil.toBytes(writeQueueSize));
row.add(schema.getBytes());
row.add(charsetInf.getBytes());
row.add(txLevel.getBytes());
row.add(txAutommit.getBytes());
return row;
}