From 24681c81c09022f584a57006f2534b5f74723414 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期二, 30 六月 2026 09:27:31 +0800
Subject: [PATCH] 初始化项目

---
 sql/tools/README.md |   28 +++++++++++++++++++++++++---
 1 files changed, 25 insertions(+), 3 deletions(-)

diff --git a/sql/tools/README.md b/sql/tools/README.md
index 94c5300..da1d3f9 100644
--- a/sql/tools/README.md
+++ b/sql/tools/README.md
@@ -57,9 +57,11 @@
 ```Bash
 docker compose up -d dm8
 # 娉ㄦ剰锛氬惎鍔ㄥ畬 dm 鍚庯紝闇�瑕佹墜鍔ㄥ啀鎵ц濡備笅鍛戒护锛屽洜涓� dm 涓嶆敮鎸佸垵濮嬪寲鑴氭湰
-docker compose exec dm8 bash -c '/opt/dmdbms/bin/disql SYSDBA/SYSDBA001 \`/tmp/schema.sql'
+docker compose exec dm8 bash -c 'printf "SET DEFINE OFF;\n" > /tmp/schema-with-define-off.sql && cat /tmp/schema.sql >> /tmp/schema-with-define-off.sql && /opt/dmdbms/bin/disql SYSDBA/SYSDBA001 \`/tmp/schema-with-define-off.sql'
 exit
 ```
+
+> 娉ㄦ剰锛氶」鐩� DM8 鑴氭湰浣跨敤 `varchar(n char)` 淇濇寔鍜� MySQL `varchar(n)` 涓�鑷寸殑瀛楃闀垮害璇箟锛屽缓璁垵濮嬪寲 DM8 鏃朵娇鐢� `PAGE_SIZE=16`銆乣UNICODE_FLAG=1`銆俙sql/tools/docker-compose.yaml` 宸叉寜璇ラ厤缃彁渚涚ず渚嬨�備娇鐢� `disql` 瀵煎叆鏃堕渶瑕佸厛鎵ц `SET DEFINE OFF;`锛岄伩鍏嶆暟鎹噷鐨� `&` 琚綋浣滃彉閲忔浛鎹€��
 
 ### 1.6 KingbaseES 浜哄ぇ閲戜粨
 
@@ -90,6 +92,25 @@
 docker compose exec opengauss bash -c '/usr/local/opengauss/bin/gsql -U $GS_USERNAME -W $GS_PASSWORD -d postgres -f /tmp/schema.sql'
 ```
 
+### 1.8 HighGo 鐎氶珮鏁版嵁搴�
+
+鈶� 涓嬭浇鐎氶珮瀹樻柟 Docker 闀滃儚锛屽苟鍔犺浇闀滃儚鏂囦欢銆傚姞杞藉悗锛屽皢闀滃儚鎵撴垚鏈湴鏍囩锛�
+
+```Bash
+docker load -i <highgo-image>.tar
+docker tag <image>:<tag> highgo:local
+```
+
+鈶� 鍦ㄩ」鐩� `sql/tools` 鐩綍涓嬭繍琛岋細
+
+```Bash
+docker compose up -d highgo
+```
+
+> 娉ㄦ剰锛氫笉鍚岀�氶珮闀滃儚鐨勬暟鎹洰褰曞彲鑳戒笉鍚岋紝濡傛灉瀹瑰櫒鏃犳硶鍚姩锛岃鎸夐暅鍍忓疄闄� `PGDATA` 淇敼 `docker-compose.yaml` 涓殑 `highgo` 鏁版嵁鍗锋寕杞界洰褰曘��
+
+鈶� 鍚姩瀹屾垚鍚庯紝闇�瑕佹墜鍔ㄥ鍏� Quartz 鍜岄」鐩� SQL銆傜�氶珮鍏煎 PostgreSQL锛屽叿浣撳鎴风鍛戒护浠ュ綋鍓嶉暅鍍忎负鍑嗭紝鍙娇鐢� `psql` 鎴栫�氶珮闀滃儚鍐呯疆鐨勫吋瀹瑰鎴风鎵ц `/tmp/quartz.sql`銆乣/tmp/schema.sql`銆�
+
 ## 1.X 瀹瑰櫒鐨勯攢姣侀噸寤�
 
 寮�鍙戞祴璇曡繃绋嬩腑锛屾湁鏃跺�欓渶瑕佸垱寤哄叏鏂板共鍑�鐨勬暟鎹簱銆傜敱浜庢祴璇曟暟鎹� Docker 瀹瑰櫒閲囩敤鏁版嵁鍗� Volume 鎸傝浇鏁版嵁搴撳疄渚嬬殑鏁版嵁鐩綍锛屽洜姝ら攢姣佹暟鎹渶瑕佸仠姝㈠鍣ㄥ悗锛屽垹闄ゆ暟鎹嵎锛岀劧鍚庡啀閲嶆柊鍒涘缓瀹瑰櫒銆�
@@ -103,7 +124,7 @@
 
 ## 2. MySQL 杞崲鍏跺畠鏁版嵁搴�
 
-椤圭洰鎻愪緵浜� `sql/tools/convertor.py` 鑴氭湰锛屾敮鎸佸皢 MySQL 杞崲涓� Oracle銆丳ostgreSQL銆丼QL Server銆佽揪姊︺�佷汉澶ч噾浠撱�丱penGauss 绛夋暟鎹簱鐨勮剼鏈��
+椤圭洰鎻愪緵浜� `sql/tools/convertor.py` 鑴氭湰锛屾敮鎸佸皢 MySQL 杞崲涓� Oracle銆丳ostgreSQL銆丼QL Server銆佽揪姊︺�佷汉澶ч噾浠撱�丱penGauss銆佺�氶珮绛夋暟鎹簱鐨勮剼鏈��
 
 ### 2.1 瀹炵幇鍘熺悊
 
@@ -118,11 +139,12 @@
 # pip3 install simple-ddl-parser
 ```
 
-鈶� 鍦� `sql/tools/` 鐩綍涓嬶紝鎵ц濡備笅鍛戒护鎵撳嵃鐢熸垚 postgres 鐨勮剼鏈唴瀹癸紝鍏朵粬鍙�夊弬鏁版湁锛歚oracle`銆乣sqlserver`銆乣dm8`銆乣kingbase`銆乣opengauss`锛�
+鈶� 鍦� `sql/tools/` 鐩綍涓嬶紝鎵ц濡備笅鍛戒护鎵撳嵃鐢熸垚 postgres 鐨勮剼鏈唴瀹癸紝鍏朵粬鍙�夊弬鏁版湁锛歚oracle`銆乣sqlserver`銆乣dm8`銆乣kingbase`銆乣opengauss`銆乣highgo`锛�
 
 ```Bash
 python3 convertor.py postgres
 # python3 convertor.py postgres > tmp.sql
+# python3 convertor.py highgo ../mysql/ruoyi-vue-pro.sql > ../highgo/ruoyi-vue-pro.sql
 ```
 
 绋嬪簭灏� SQL 鑴氭湰鎵撳嵃鍒扮粓绔紝鍙互閲嶅畾鍚戝埌涓存椂鏂囦欢 `tmp.sql`銆�

--
Gitblit v1.9.3