mysql-cdc反序列化器

  • <mysql-cdc.version>1.4.0</mysql-cdc.version>
package com.bigdata.flink.cdc.debezium;

import cn.hutool.core.lang.Snowflake;
import cn.hutool.core.util.IdUtil;
import com.alibaba.fastjson.JSONObject;
import com.alibaba.ververica.cdc.debezium.DebeziumDeserializationSchema;
import com.bigdata.flink.cdc.tool.IdTool;
import com.bigdata.flink.cdc.tool.MDCTool;
import io.debezium.time.Timestamp;
import lombok.extern.slf4j.Slf4j;
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.time.LocalDateTime;
import java.time.temporal.ChronoUnit;
import java.util.List;


@Slf4j
public class FastjonDeserializationSchema implements DebeziumDeserializationSchema<String> {

    Snowflake snowflake = IdUtil.getSnowflake(1, 1);

    @Override
    public void deserialize(SourceRecord record, Collector<String> out) throws Exception {
        String simpleUUID = IdTool.simpleUUID();
        MDCTool.putTraceId(simpleUUID);
        log.info("deserialize.开始时间:" + LocalDateTime.now());
        Struct dataRecord  =  (Struct)record.value();
        /**
         * 1、同时存在 beforeStruct 跟 afterStruct数据的话,就代表是update的数据
         * 2、只存在 beforeStruct 就是delete数据
         * 3、只存在 afterStruct数据 就是insert数据
         */

        JSONObject fastJson = new JSONObject();
        List<Field> fieldList = null;
        Struct beforeStruct = dataRecord.getStruct("before");
        if(beforeStruct != null){
            JSONObject beforeJson = new JSONObject();
            fieldList = beforeStruct.schema().fields();
            for (Field field : fieldList) {
                Schema schema = field.schema();
                String fieldName = field.name();
                Object fieldValue = beforeStruct.get(fieldName);
                if(Timestamp.SCHEMA_NAME.equals(schema.name()) && fieldValue != null){
                    long epochMillis = Timestamp.toEpochMillis(fieldValue, temporal -> temporal.minus(8, ChronoUnit.HOURS));
                    if(String.valueOf(epochMillis).equals(String.valueOf(fieldValue))){
                        epochMillis = epochMillis - 8*60*60*1000;
                    }
                    beforeJson.put(fieldName, epochMillis);
                } else {
                    beforeJson.put(fieldName, fieldValue);
                }
            }
            fastJson.put("before", beforeJson);
        }
        Struct afterStruct = dataRecord.getStruct("after");
   
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值