开发进度

最后更新:2024-07-10 09:03:59 | 状态:未完成

多表关联更新
读取默认值识别内置变量
PG查询列时检测表名大小写
自定义SQL拆分忽略部分条件
查询条件中点位符

ConfigStore 生成SQL,生成查询条件注意between等多值条件

CompareAdapter

多表查询 检测查询条件
JSON_CONTAINS

TableBuilder生成union union all

流式查询

Point(Point.class)
LineString( Line.class)
Polygon(Polygon.class)
MultiPoint(MultiPoint.class)
MultiLineString( MultiLine.class)
MultiPolygon(MultiPolygon.class)
GeometryCollection(GeometryCollection.class)
rename(Table/Column/Procedure/Trigger...)
DDInterceptor

DMInterceptor


UPDATE TAB_A AS A SET
TOTAL_WEIGHT = B.TOTAL_WEIGHT
, TOTAL_QTY = B.TOTAL_QTY 
FROM TAB_B AS B
WHERE A.ID = F.ID AND A.Y = ?


UPDATE TAB_A AS A SET
TOTAL_WEIGHT = B.TOTAL_WEIGHT
, TOTAL_QTY = B.TOTAL_QTY 
FROM TAB_B AS B , TAB_C AS C
WHERE A.ID = F.ID AND A.Y = ?


UPDATE TAB_A AS A SET
TOTAL_WEIGHT = B.TOTAL_WEIGHT
, TOTAL_QTY = B.TOTAL_QTY 
FROM TAB_B AS B LEFT JOIN  TAB_C AS C ON B.ID = C.ID
WHERE A.ID = F.ID AND A.Y = ?

首页 最近更新 搜索 提交