Skip to content

v1.3.0

Choose a tag to compare

View all tags
@lawrence8358 lawrence8358 released this 25 May 16:09
· 24 commits to main since this release
v1.3.0
25af227
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

Release v1.3.0

發布日期 (Date): 2026-05-26

主要亮點 (Highlights):

  • 新增外鍵（Foreign Key）完整管理能力，支援自動偵測、比對與安全部署
  • EN: Full foreign key management support with automatic detection, comparison, and safe deployment

🌟 What's New / 主要更新

🚀 Features / 新功能

  • 新增外鍵差異比對與自動同步

    • 自動偵測新增的外鍵、刪除的外鍵、以及定義變更的外鍵
    • 支援外鍵約束名稱、欄位清單、被參照表、ON DELETE/ON UPDATE 動作的完整比對
    • 在部署計劃中清晰呈現外鍵變更，包含風險警告

    EN:

    • Auto-detects new, dropped, and modified foreign keys
    • Full comparison including constraint names, columns, referenced table, and referential actions (ON DELETE/ON UPDATE)
    • Clear deployment plan visualization with caution messages for data consistency risks

  • 外鍵定義與內省

    • 支援從 SQL 定義檔解析 FOREIGN KEY 約束（含 ON DELETE/ON UPDATE）
    • 支援從資料庫內省現有外鍵約束結構

    EN:

    • Parse FOREIGN KEY constraints from SQL files with referential action support
    • Query existing foreign keys from PostgreSQL information schema

  • 改進 CLI 顯示

    • 部署計劃中新增外鍵變更的視覺標籤：[+FK]（新增）、[-FK]（刪除）、[~FK]（重建）

    EN:

    • Visual indicators in deployment plan: [+FK] for additions, [-FK] for drops, [~FK] for recreations

🛠 Refactoring & Improvements / 重構與效能優化

  • 新增本地化資源：外鍵變更訊息（中英雙語）

    • 包含詳細的風險警告，提醒使用者外鍵變更對資料完整性的影響

    EN: Added localized messages for foreign key changes with data consistency warnings in both English and Traditional Chinese

  • 擴充 TableSchema 模型

    • 新增 ForeignKeys 集合，與現有的 Indexes 並行管理

    EN: Extended TableSchema with ForeignKeys collection to parallel index management

🐛 Bug Fixes / 問題修復

  • 無 / None

⚠️ Breaking Changes / 重大變更

  • 無 / None
Assets 4
Loading