@Test
@Ignore
public void runCanalInstanceTest() {
ActionFactory<TableAction> actionFactory =
new SingleSchemaActionFactory<>(
Schemas.buildSchema("autoparts", TableAction.class)
.addTable(
Schemas.buildTable("db_goods_stock")
.action(
new AbstractTableAction(
new SingleThreadCurrentHandleTable<TableAction>()) {
@Override
public void onAction(List<? extends RowChangedData> changedData) {
System.out.println("currentTable: " + getCurrentTable());
System.out.println(changedData);
}
})
.columns("id", "goods_id", "goods_number")
.columnCondition(Schemas.DEFAULT_DELETE_COLUMN_CONDITION))
.create());
CANAL_EXECUTOR.addInstanceHandle(new TableSectionHandle(LOCAL_ADDRESS, "shop", actionFactory));
ActionFactory<EventTypeAction> eventTypeFactory =
new SingleSchemaActionFactory<>(
Schemas.buildSchema("autoparts", EventTypeAction.class)
.addTable(
Schemas.buildTable("db_goods")
.action(
new EventTypeAction() {
@Override
public void onUpdateAction(List<RowChangedData.Update> updatedData) {
System.out.println("db_goods.onUpdateAction: " + updatedData);
}
@Override
public void onInsertAction(List<RowChangedData.Insert> insertedData) {
System.out.println("db_goods.onInsertAction: " + insertedData);
}
@Override
public void onDeleteAction(List<RowChangedData.Delete> deletedData) {
System.out.println("db_goods.onDeleteAction: " + deletedData);
}
})
.columns("goods_id", "goods_name", "cat_id", "new_goods_sn")
.columnCondition(
Conditions.unmodifiableContainer()
.mustCondition(Conditions.equal("is_delete", false))
.mustCondition(Conditions.equal("seller_id", 1))
.create()))
.create());
CANAL_EXECUTOR.addInstanceHandle(
new EventTypeSectionHandle(LOCAL_ADDRESS, "shop_goods", eventTypeFactory));
CANAL_EXECUTOR.startAllInstance(0L);
try {
TimeUnit.MINUTES.sleep(100);
} catch (InterruptedException e) {
e.printStackTrace();
}
}
/** 添加{@link EventTypeSectionHandle} */
private void addEventTypeSectionCanalInstance() {
ActionFactory<EventTypeAction> actionFactory =
Schemas.<EventTypeAction>buildFactory()
// 添加legend表中的legend_shop和legend_shop_service_info表处理
.addSchema(
Schemas.buildSchema("legend", EventTypeAction.class)
.addTable(
Schemas.buildTable("legend_shop")
.action(
new EventTypeAction() {
// legend-shop表改动对应的处理
@Override
public void onUpdateAction(
List<RowChangedData.Update> updatedData) {
// do some work or call some function~~~
}
@Override
public void onInsertAction(
List<RowChangedData.Insert> insertedData) {
// do some work or call some function~~~
}
@Override
public void onDeleteAction(
List<RowChangedData.Delete> deletedData) {
// do some work or call some function~~~
}
})
.columns("id", "shop_id")
.columnCondition(Schemas.DEFAULT_DELETE_COLUMN_CONDITION))
.addTable(
Schemas.buildTable("legend_shop_service_info")
.action(
new EventTypeAction() {
// legend_shop_service_info表改动对应的处理
@Override
public void onUpdateAction(
List<RowChangedData.Update> updatedData) {
// do some work or call some function~~~
}
@Override
public void onInsertAction(
List<RowChangedData.Insert> insertedData) {
// do some work or call some function~~~
}
@Override
public void onDeleteAction(
List<RowChangedData.Delete> deletedData) {
// do some work or call some function~~~
}
})
.columnCondition(Schemas.DEFAULT_DELETE_COLUMN_CONDITION)))
// 添加dandelion表中的activity, member表处理
.addSchema(
Schemas.buildSchema("dandelion", EventTypeAction.class)
.addTable(
Schemas.buildTable("activity")
.action(
new EventTypeAction() {
// activity表改动对应的处理
@Override
public void onUpdateAction(
List<RowChangedData.Update> updatedData) {
// do some work or call some function~~~
}
@Override
public void onInsertAction(
List<RowChangedData.Insert> insertedData) {
// do some work or call some function~~~
}
@Override
public void onDeleteAction(
List<RowChangedData.Delete> deletedData) {
// do some work or call some function~~~
}
}))
.addTable(
Schemas.buildTable("member")
.action(
new EventTypeAction() {
// member表改动对应的处理
@Override
public void onUpdateAction(
List<RowChangedData.Update> updatedData) {
// do some work or call some function~~~
}
@Override
public void onInsertAction(
List<RowChangedData.Insert> insertedData) {
// do some work or call some function~~~
}
@Override
public void onDeleteAction(
List<RowChangedData.Delete> deletedData) {
// do some work or call some function~~~
}
// member表改动对应的处理
})))
.create();
// canal实例名称
String instanceName = "legend-event-type-section";
EventTypeSectionHandle eventTypeSectionHandle =
new EventTypeSectionHandle(LOCAL_ADDRESS, instanceName, actionFactory);
// 下面是异常处理以及canal连接的一些参数设置, 都有默认值, 需要设置之~~~
eventTypeSectionHandle.setExceptionHandleFunction(
new Function<HandleExceptionContext, Boolean>() {
@Override
public Boolean apply(HandleExceptionContext input) {
// do some exception handle
return false;
}
});
eventTypeSectionHandle.setUserLocalTableFilter(false);
eventTypeSectionHandle.setIgnoreHandleException(false);
eventTypeSectionHandle.setMessageBatchSize(1000);
eventTypeSectionHandle.setMessageTimeout(500L);
CANAL_EXECUTOR.addInstanceHandle(eventTypeSectionHandle);
}
/** 添加{@link TableSectionHandle} */
private void addTableSectionCanalInstance() {
List<Schema<TableAction>> schemas = new ArrayList<>();
List<Schemas.TableBuilder> tableList = new ArrayList<>();
// 添加legend表中的legend_shop和legend_shop_service_info表处理
tableList.add(
Schemas.buildTable("legend_shop")
.action(
new TableAction() {
@Override
public void onAction(List<? extends RowChangedData> changedData) {
// legend-shop表改动对应的处理
// do some work or call some function~~~
}
})
.columnCondition(Schemas.DEFAULT_DELETE_COLUMN_CONDITION));
tableList.add(
Schemas.buildTable("legend_shop_service_info")
.action(
new TableAction() {
@Override
public void onAction(List<? extends RowChangedData> changedData) {
// legend_shop_service_info表改动对应的处理
// do some work or call some function~~~
}
})
.columns("id", "is_deleted", "name", "service_sn") // 目前还不支持列过滤~~~不过很快了~~~
// id 取值返回在[10, 100], 并且is_deleted = 'N'
.columnCondition(
Conditions.unmodifiableContainer()
.mustCondition(Conditions.range("id", Integer.TYPE).ge(10).le(100).create())
.mustCondition(Schemas.NOT_DELETED_CONDITION)
.create()));
String schemaName = "legend";
schemas.add(Schemas.buildSchema(schemaName, TableAction.class).addTable(tableList).create());
// 添加dandelion表中的activity, member表处理
schemaName = "dandelion";
schemas.add(
Schemas.buildSchema(schemaName, TableAction.class)
.addTable(
Schemas.buildTable("activity")
.columnCondition(Schemas.DEFAULT_DELETE_COLUMN_CONDITION)
.action(
new TableAction() {
@Override
public void onAction(List<? extends RowChangedData> changedData) {
// activity表改动对应的处理
// do some work or call some function~~~
}
}),
Schemas.buildTable("member")
.columnCondition(Schemas.DEFAULT_DELETE_COLUMN_CONDITION)
.action(
new TableAction() {
@Override
public void onAction(List<? extends RowChangedData> changedData) {
// member表改动对应的处理
// do some work or call some function~~~
}
}))
.create());
// canal实例名称
String instanceName = "legend-table-section";
TableSectionHandle tableSectionHandle =
new TableSectionHandle(
LOCAL_ADDRESS, instanceName, new MultiSchemaActionFactory<>(schemas));
// 下面是异常处理以及canal连接的一些参数设置, 都有默认值, 需要设置之~~~
tableSectionHandle.setExceptionHandleFunction(
new Function<HandleExceptionContext, Boolean>() {
@Override
public Boolean apply(HandleExceptionContext input) {
// do some exception handle
return false;
}
});
tableSectionHandle.setUserLocalTableFilter(false);
tableSectionHandle.setIgnoreHandleException(false);
tableSectionHandle.setMessageBatchSize(1000);
tableSectionHandle.setMessageTimeout(500L);
CANAL_EXECUTOR.addInstanceHandle(tableSectionHandle);
}