From 0f9d929c1bc55ed1231596881bbf00fd6e03d42c Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Thu, 29 Feb 2024 11:04:16 +0800
Subject: [PATCH] 数据格式解析修改,新增同步的表
---
src/main/java/org/springblade/binlog/listener/TourBinLogListener.java | 3 ++-
src/main/resources/application-prod.yml | 2 +-
2 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/src/main/java/org/springblade/binlog/listener/TourBinLogListener.java b/src/main/java/org/springblade/binlog/listener/TourBinLogListener.java
index 28139c3..4434f25 100644
--- a/src/main/java/org/springblade/binlog/listener/TourBinLogListener.java
+++ b/src/main/java/org/springblade/binlog/listener/TourBinLogListener.java
@@ -104,7 +104,8 @@
value.getDataType().equals("char")) {
valueList.add("'" + data.get(key).toString() + "'");
}else if(value.dataType.equals("text") ||
- value.dataType.equals("mediumtext")) {
+ value.dataType.equals("mediumtext") ||
+ value.dataType.equals("longblob")) {
byte[] bytes = (byte[])data.get(key);
valueList.add("'" + new String(bytes) + "'");
}else if(value.dataType.equals("date") ||
diff --git a/src/main/resources/application-prod.yml b/src/main/resources/application-prod.yml
index fa96910..71b0796 100644
--- a/src/main/resources/application-prod.yml
+++ b/src/main/resources/application-prod.yml
@@ -47,7 +47,7 @@
username: root
password: 1qaz@WSX3edc
db: jczz # 监听数据库
- table: jczz_house,jczz_household,jczz_house_rental,jczz_user_house_label,jczz_label,jczz_place,jczz_place_check,jczz_place_ext,jczz_place_poi_label,jczz_place_practitioner,jczz_police_affairs_grid,jczz_task_label_reporting_event,jczz_patrol_group,jczz_patrol_group_item,jczz_patrol_record,blade_attach_data,jczz_category,jczz_grid
+ table: jczz_house,jczz_household,jczz_house_rental,jczz_user_house_label,jczz_label,jczz_place,jczz_place_check,jczz_place_door,jczz_place_ext,jczz_place_poi_label,jczz_place_practitioner,jczz_police_affairs_grid,jczz_task_label_reporting_event,jczz_patrol_group,jczz_patrol_group_item,jczz_patrol_record,blade_attach_data,jczz_category,jczz_grid
# table: blade_attach_data
enabled: true
# 目标数据库
--
Gitblit v1.9.3