| 12345678910111213141516171819202122232425 |
- -- ============================================================
- -- 任务 2026091801: 增加调用Gateway服务Util
- -- 新增字典配置项: 网关服务配置项 (gateway_app_config)
- -- dict_value 为 JSON:
- -- baseUrl 网关服务url前缀
- -- pointStateUrl 状态查询接口
- -- channelStateExpressions 通道状态判断表达式(SpEL, 变量 #iValue)
- -- channelOperationUrl 通道操作接口
- -- ============================================================
- ALTER TABLE "public"."sys_dict_data" ALTER COLUMN "dict_value" DROP DEFAULT,
- ALTER COLUMN "dict_value" TYPE character varying(1000) USING "dict_value"::character varying(1000),
- ALTER COLUMN "dict_value" SET DEFAULT '';
- INSERT INTO sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, remark)
- SELECT
- nextval(pg_get_serial_sequence('sys_dict_type', 'dict_id')),
- '网关服务配置项', 'gateway_app_config', '0', 'admin', now(), '网关服务(gatewayapp)地址与接口配置, JSON格式'
- WHERE NOT EXISTS (SELECT 1 FROM sys_dict_type t WHERE t.dict_type = 'gateway_app_config');
- INSERT INTO sys_dict_data (dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark)
- SELECT
- nextval(pg_get_serial_sequence('sys_dict_data', 'dict_code')),
- 1, '网关服务配置项', '{"baseUrl":"http://xxx","pointStateUrl":"/biz/point-state/real","channelStateExpressions":"#iValue != null and #iValue == 1","channelOperationUrl":"/biz/channel/control"}', 'gateway_app_config', '', '', 'Y', '0', 'admin', now(), 'JSON: baseUrl/pointStateUrl/channelStateExpressions/channelOperationUrl'
- WHERE NOT EXISTS (SELECT 1 FROM sys_dict_data t WHERE t.dict_type = 'gateway_app_config');
|
