源代码：ZGLanguage 解析SQL数据血缘 之 显示 UPDATE SQL 结构图
# SQL代码如下所示 :
UPDATE MA_F_LOAN TT
SET TT.LAST_REPRICE_DATE = AL.ORIGINATION_DATE,
FROM NYBDP.O_SS_CL_LOAN_ACCT_STATIS CL
LEFT JOIN NYBDP.O_CWWS_ACCT_LOAN AL
ON 1=1
WHERE CL.MATURITY_DATE <= P_AS_OF_DATE
AND CL.CUR_BOOK_BAL <> 0
;
# 通过 ZGLanguage + Python 将以上SQL转换成 Echarts 的树结构数据：
[
{
"name": "test.code",
"children": [
{
"name": "MA_F_LOAN",
"children": [
{
"name": "O_SS_CL_LOAN_ACCT_STATIS",
"children": []
},
{
"name": "O_CWWS_ACCT_LOAN",
"children": []
}
]
}
]
}
]
# 使用 Echarts 的展示 ：
下载地址：https://download.csdn.net/download/zgl_20053779/92565353?spm=1001.2101.3001.9500
2026-01-22 19:02:29 | 数据血缘测试帐号 | 技术 & 提问 | 阅读134次