From 34981c30a78e8bbd7791131059a9210f9928b62c Mon Sep 17 00:00:00 2001
From: 刘光辉 <347230014@qq.com>
Date: 星期四, 17 九月 2026 09:24:09 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master' into master
---
docker/postgres/migration/assemble-sql-onsite.sh | 68 ++++++++++++++++++++++++++++++++++
1 files changed, 68 insertions(+), 0 deletions(-)
diff --git a/docker/postgres/migration/assemble-sql-onsite.sh b/docker/postgres/migration/assemble-sql-onsite.sh
new file mode 100644
index 0000000..15057a3
--- /dev/null
+++ b/docker/postgres/migration/assemble-sql-onsite.sh
@@ -0,0 +1,68 @@
+#!/usr/bin/env bash
+# 鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�
+# 鐜板満缁勮 sql/锛坓it 鎷夌爜閮ㄧ讲璺嚎涓撶敤锛涚绾垮寘璺嚎鐨勫寘鍐� sql/ 宸茬敱鏋勫缓鏈虹粍瑁呭ソ锛屼笉鐢ㄦ湰鑴氭湰锛�
+#
+# 瀹樻柟鍒濆鍖� SQL锛歴ql-seed/*.sql.gz 瑙ｅ帇锛堝叆搴撶殑 gzip 绉嶅瓙锛宩npf_dbnull_init 鍘熸枃浠�
+# 101MB 瓒� GitHub 鍗曟枃浠朵笂闄愶紝鏁呬互 gz 褰㈡�佸叆搴擄級
+# 鑷缓 DDL/妯℃澘 锛歞ocs/pg-migration-ddl/ 鐩存帴鎷疯礉锛坓it 宸茶窡韪級
+#
+# 鐢ㄦ硶锛堜粨搴撲换鎰忎綅缃墽琛屽潎鍙紝骞傜瓑鍙噸璺戯級锛�
+# ./docker/postgres/migration/assemble-sql-onsite.sh
+# 涔嬪悗鐓у父锛�./install.sh && ./create-app-roles.sh
+# 鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�鈹�
+set -euo pipefail
+
+SCRIPT_DIR="$(cd "$(dirname "${BASH_SOURCE[0]}")" && pwd)"
+REPO_ROOT="$(cd "$SCRIPT_DIR/../../.." && pwd)"
+DDL_DIR="$REPO_ROOT/docs/pg-migration-ddl"
+SEED_DIR="$SCRIPT_DIR/sql-seed"
+OUT="$SCRIPT_DIR/sql"
+
+log() { printf '\033[1;32m[assemble]\033[0m %s\n' "$*"; }
+die() { printf '\033[1;31m[assemble][err]\033[0m %s\n' "$*" >&2; exit 1; }
+
+[ -d "$SEED_DIR" ] || die "缂� ${SEED_DIR}锛坓it pull 鎷挎渶鏂颁唬鐮侊級"
+[ -d "$DDL_DIR" ] || die "缂� ${DDL_DIR}"
+mkdir -p "$OUT"
+
+log "瑙ｅ帇瀹樻柟鍒濆鍖� SQL锛坰ql-seed 鈫� sql/锛夆��"
+for gz in "$SEED_DIR"/*.sql.gz; do
+ base="$(basename "$gz" .gz)"
+ gunzip -c "$gz" > "$OUT/$base"
+ log " + ${base} ($(du -h "$OUT/$base" | cut -f1))"
+done
+
+log "鎷疯礉鑷缓 DDL / pgloader 妯℃澘锛坉ocs/pg-migration-ddl 鈫� sql/锛夆��"
+for f in self_built_tables_pg.sql update_lims_huanjing_20260717.sql \
+ update_lims_sxt_wendingxing_20260717.sql update_lims_sxt_wendingxing_20260720.sql \
+ update_lims_sxt_flow_biz_status_20260719.sql update_lims_sxt_quyang_zhongzhi_shenqing_biz_status_20260723.sql \
+ update_lims_sxt_quyang_zhongzhi_shenqing_qingyandan_link_20260723.sql \
+ update_lims_sxt_plan_status_20260720.sql \
+ update_lims_wendingxing_biangeng_20260720.sql \
+ create_lims_sxt_quyang_jihua_renwu_20260724.sql \
+ alter_lims_sxt_quyang_jihua_renwu_jianyan_xiang_kuaizhao_20260724.sql \
+ create_audit_events_ext_20260724.sql \
+ create_audit_events_20260724.sql \
+ update_audit_events_title_entry_20260810.sql \
+ update_audit_events_ingest_merge_20260818.sql \
+ repair_audit_events_integrity_20260824.sql \
+ create_dms_permission_v2_2_20260815.sql \
+ upgrade_dms_permission_v2_2_to_v2_3_20260817.sql \
+ create_dms_file_objects_20260817.sql \
+ upgrade_dms_file_properties_20260820.sql \
+ update_audit_events_target_timeline_index_20260823.sql \
+ data_interface_pg_fixes.sql \
+ nacos_config_pg.sql rowcount_check.sh \
+ pgloader_jnpf_init.load.tpl pgloader_jnpf_init_bigtable.load.tpl pgloader_jnpf_flow.load.tpl; do
+ [ -f "$DDL_DIR/$f" ] || die "缂� ${DDL_DIR}/${f}"
+ cp -f "$DDL_DIR/$f" "$OUT/"
+ log " + ${f}"
+done
+chmod +x "$OUT/rowcount_check.sh"
+
+# 瀹屾暣鎬х粓妫�锛歩nstall.sh / migrate-data.sh 娑堣垂鐨勫叧閿枃浠堕�愪竴鍦ㄤ綅
+for f in jnpf_dbnull_init.sql Update_PostgreSQL_1127.sql jnpf_flow_init.sql jnpf_xxljob_init.sql \
+ self_built_tables_pg.sql nacos_config_pg.sql; do
+ [ -f "$OUT/$f" ] || die "缁勮鍚庝粛缂� ${f}"
+done
+log "sql/ 缁勮瀹屾垚 鉁擄紙$(command ls "$OUT" | wc -l | tr -d ' ') 涓枃浠讹紝$(du -sh "$OUT" | cut -f1)锛�"
--
Gitblit v1.8.0