Flink CDC 自定义反序列化

最新推荐文章于 2023-09-24 23:51:52 发布

冷艳无情的小妈

最新推荐文章于 2023-09-24 23:51:52 发布

阅读量594

点赞数 3

文章标签： flink java kafka 数据库 mysql

本文链接：https://blog.csdn.net/wuhahaq/article/details/129998716

版权

该代码实现了一个自定义的DebeziumDeserializationSchema，从CDC源（基于MySQL和Debezium）读取数据，然后将数据封装成JSON对象。主要步骤包括解析SourceRecord，提取数据库名、表名、before和after状态以及操作类型，并将这些信息构建到一个JSON结构中。

摘要由CSDN通过智能技术生成

CDC读取Mysql数据封装成JSONObject

import com.alibaba.fastjson.JSONObject;
import com.alibaba.ververica.cdc.debezium.DebeziumDeserializationSchema;
import io.debezium.data.Envelope;
import org.apache.flink.api.common.typeinfo.BasicTypeInfo;
import org.apache.flink.api.common.typeinfo.TypeInformation;
import org.apache.flink.util.Collector;
import org.apache.kafka.connect.data.Field;
import org.apache.kafka.connect.data.Schema;
import org.apache.kafka.connect.data.Struct;
import org.apache.kafka.connect.source.SourceRecord;

import java.util.List;

public class CustomerDeserialization implements DebeziumDeserializationSchema<String> {


    /**
     * 封装的数据格式  JSON
     * {
     *     "database":"",
     *     "tableName":"",
     *     "type":"c u d",
     *     "before":"{"id":"","name":"","":""...}",
     *     "after":"{"id":"","name":"","":""...}",
     *     // "ts":156489196115616
     * }
     */
    @Override
    public void deserialize(SourceRecord sourceRecord, Collector<String> collector) throws Exception {
        //创建JSON对象用于存储最终数据
        JSONObject json = new JSONObject();

        //获取库名&表名
        String topic = sourceRecord.topic();
        String[] fields = topic.split("\\.");
        String databaes = fields[1];
        String tableName = fields[2];

        Struct value  = (Struct)sourceRecord.value();
        //获取before 数据
        Struct before = value.getStruct("before");
        JSONObject beforeJson = new JSONObject();
        Schema beforeSchema = before.schema();
        List<Field> beforeFields = beforeSchema.fields();
        if(before != null){
            for (Field field : beforeFields) {
                Object beforeValue = before.get(field);
                beforeJson.put(field.name(), beforeValue);
            }
        }

        //获取after 数据
        Struct after = value.getStruct("after");
        JSONObject afterJson = new JSONObject();
        Schema afterSchema = after.schema();
        List<Field> afterFields = afterSchema.fields();
        if(after != null){
            for (Field field : afterFields) {
                Object afterValue = after.get(field);
                afterJson.put(field.name(), afterValue);
            }
        }

        //获取操作类型
        Envelope.Operation operation = Envelope.operationFor(sourceRecord);
        System.out.println(operation);


        //将字段写入JSON对象
        json.put("database",databaes);
        json.put("tableName",tableName);
        json.put("before",beforeJson);
        json.put("after",afterJson);
        json.put("type",operation);

        //输出数据
        collector.collect(json.toJSONString());
    }

    @Override
    public TypeInformation<String> getProducedType() {
        return BasicTypeInfo.STRING_TYPE_INFO;
    }
}