Canner / WrenAI

πŸš€ Open-source SQL AI Agent for Text-to-SQL. Make Text2SQL Easy! πŸ™Œ
https://getwren.ai/oss
GNU Affero General Public License v3.0
1.73k stars 155 forks source link

feat(wren-ui): Support schema change phase 2 #442

Closed fredalai closed 3 months ago

fredalai commented 3 months ago

Description

Solution idea

The change column of the database is used to save data that is different from the source. The basic three changes of schema change can be known by comparing the change column data with the Model and Model columns data.

As we know, both Calculated fields and Relationships are created by selecting the column of the Model, and are related to the Column. Therefore, the phase 2 we want to support will be affected or have calculated fields and relationships that use the changed Column listed.

Tasks

UI

ζˆͺεœ– 2024-06-26 δΈ‹εˆ2 15 57 ζˆͺεœ– 2024-06-26 δΈ‹εˆ2 23 59

Source Table Delete

ζˆͺεœ– 2024-06-26 δΈ‹εˆ2 28 03

Source Column Delete

ζˆͺεœ– 2024-06-26 δΈ‹εˆ2 28 25

Column Type Change

ζˆͺεœ– 2024-06-26 δΈ‹εˆ2 32 19

ζˆͺεœ– 2024-06-26 δΈ‹εˆ2 32 42