2026-05-31 10:29
把控制台的语句,拷贝到到sql客户端执行,能正常执行
SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT id AS "id", name AS "name", age AS "age", birth_date AS "birth_date", interest AS "interest", editor AS "editor", editor_dept AS "editor_dept", edit_at AS "edit_at", tenant_id AS "tenant_id", create_user AS "create_user", create_time AS "create_time", create_dept AS "create_dept", update_user AS "update_user", update_time AS "update_time", is_deleted AS "is_deleted", editor_id AS "editor_id", edit_dept_id AS "edit_dept_id" FROM lowcode_zexample_single_table tbl WHERE (is_deleted = 0) AND tbl.tenant_id = 1 ORDER BY id DESC ) TMP WHERE ROWNUM <=10) WHERE ROW_ID > 0
2026-05-27 10:22
研究了一下navicate的结构对比和数据对比
结构对比,有差异化脚本
数据对比,没有差异化脚本,应该只能直接部署。
基于JeeLowCode平台,一般是对master库进行结构化对比,frame库进行数据对比。但是这样就有几个问题,
1.可能开发库和生产库不能在一个网络里同时访问。
2.frame库的数据差异化不能直接整理出脚本,因为开发库可能存在不上线的功能。
基于上面的问题,我们想了一个办法,就是开发人员手工去整理差异化脚本,就是我们这些版本升级,做了表单开发,在线表单,在线流程做了调整(比如新增了流程,修改了流程)。你们能把产生了数据变化的表梳理出来吗?我们开发人员进行脚本整理?