根据Binlog对象构建增量数据

1 准备工作

1.新建MySqlRowData

package com.imooc.ad.mysql.dto;

import com.imooc.ad.mysql.constant.OpType;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class MySqlRowData {

    private String tableName;

    private String level;

    private OpType opType;

    private List<Map<String,String>> filedValueMap = new ArrayList<>();
}

2.在OpType中实现方法EventType到OpType的转换

package com.imooc.ad.mysql.constant;

import com.github.shyiko.mysql.binlog.event.EventType;

public enum OpType {
    ADD,
    UPDATE,
    DELETE,
    OTHER;

    public static OpType to(EventType eventType){
        switch (eventType) {
            case EXT_WRITE_ROWS:
                return ADD;
            case EXT_UPDATE_ROWS:
                return UPDATE;
            case EXT_DELETE_ROWS:
                return DELETE;

            default:
                return OTHER;
        }
    }
}

3.创建Constant类

实现对表的定义以及定义表需要解析的各个列

package com.imooc.ad.mysql.constant;

import java.util.HashMap;
import java.util.Map;


public class Constant