方案过滤脚本

方案过滤脚本原创

丨Nick丨

3人赞赏了该文章 553次浏览编辑于2022年01月05日 11:41:19

1. 保存一个方案

2. 通过脚本 select * from t_bas_filterscheme where fschemename='123' and fformid='xjtest123' 查询方案

3. 导出方案数据为预插脚本 INSERT INTO `bos_branch_dev_new_sys`.`t_bas_filterscheme` (`FSCHEMEID`, `FFORMID`, `FSCHEMENAME`, `FUSERID`, `FISDEFAULT`, `FSCHEME`, `FISSHARE`, `FNEXTENTRYSCHEME`, `FSEQ`, `FENTRYENTITY`, `FISFIXED`) VALUES ('/X28AT0P/WHH', 'xjtest123', '123', '13648', '0', 'rO0ABXNyABNqYXZhLnV0aWwuQXJyYXlMaXN0eIHSHZnHYZ0DAAFJAARzaXpleHAAAAACdwQAAAACc3IAF2phdmEudXRpbC5MaW5rZWRIYXNoTWFwNMBOXBBswPsCAAFaAAthY2Nlc3NPcmRlcnhyABFqYXZhLnV0aWwuSGFzaE1hcAUH2sHDFmDRAwACRgAKbG9hZEZhY3RvckkACXRocmVzaG9sZHhwP0AAAAAAAAx3CAAAABAAAAADdAAJRmllbGROYW1lc3EAfgAAAAAAAXcEAAAAAXQACXRleHRmaWVsZHh0AAdDb21wYXJlc3EAfgAAAAAAAXcEAAAAAXQAAjY3eHQABVZhbHVlc3EAfgAAAAAAAXcEAAAAAXQAAzEyMXh4AHNxAH4AAj9AAAAAAAAMdwgAAAAQAAAAA3EAfgAFc3EAfgAAAAAAAXcEAAAAAXQACWRhdGVmaWVsZHhxAH4ACHNxAH4AAAAAAAF3BAAAAAF0AAIxM3hxAH4AC3NxAH4AAAAAAAF3BAAAAAF0AAB4eAB4', '0', '0', '0', 'xjtest123', '0');

注意修改脚本的FISFIXED字段为’1’, 修改FUSERID为’0’

INSERT INTO t_bas_filterscheme (FSCHEMEID, FFORMID, FSCHEMENAME, FUSERID, FISDEFAULT, FSCHEME, FISSHARE, FNEXTENTRYSCHEME, FSEQ, FENTRYENTITY, FISFIXED) VALUES ('/X28AT0P/WHH', 'xjtest123', '123', '0', '0', 'rO0ABXNyABNqYXZhLnV0aWwuQXJyYXlMaXN0eIHSHZnHYZ0DAAFJAARzaXpleHAAAAACdwQAAAACc3IAF2phdmEudXRpbC5MaW5rZWRIYXNoTWFwNMBOXBBswPsCAAFaAAthY2Nlc3NPcmRlcnhyABFqYXZhLnV0aWwuSGFzaE1hcAUH2sHDFmDRAwACRgAKbG9hZEZhY3RvckkACXRocmVzaG9sZHhwP0AAAAAAAAx3CAAAABAAAAADdAAJRmllbGROYW1lc3EAfgAAAAAAAXcEAAAAAXQACXRleHRmaWVsZHh0AAdDb21wYXJlc3EAfgAAAAAAAXcEAAAAAXQAAjY3eHQABVZhbHVlc3EAfgAAAAAAAXcEAAAAAXQAAzEyMXh4AHNxAH4AAj9AAAAAAAAMdwgAAAAQAAAAA3EAfgAFc3EAfgAAAAAAAXcEAAAAAXQACWRhdGVmaWVsZHhxAH4ACHNxAH4AAAAAAAF3BAAAAAF0AAIxM3hxAH4AC3NxAH4AAAAAAAF3BAAAAAF0AAB4eAB4', '0', '0', '0', 'xjtest123', '1');

用脚本 select * from t_bas_filterscheme_l where fid='/X28AT0P/WHH' 导出多语言表数据

INSERT INTO t_bas_filterscheme_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION) VALUES ('/X28AT0P/WHI', '/X28AT0P/WHH', 'en_US', '123', ' ');

INSERT INTO t_bas_filterscheme_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION) VALUES ('/X28AT0P/3W7', '/X28AT0P/WHH', 'zh_CN', '123', ' ');

INSERT INTO t_bas_filterscheme_l (FPKID, FID, FLOCALEID, FNAME, FDESCRIPTION) VALUES ('/X28AT0P/3W8', '/X28AT0P/WHH', 'zh_TW', '123', ' ');

4. 通过ksql工具校验上面的脚本