| 12345678910111213141516 |
- -- 20260917 增加气象数据文件处理器 (aicoding/2026091708)
- -- 新增字典配置项: 场站编码-文件映射 (station_file_code_mapping)
- -- dict_value 为 JSON: key=气象文件名首段编码, value=config_station.station_code
- -- 可重复执行
- 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')),
- '场站编码-文件映射', 'station_file_code_mapping', '0', 'admin', now(), '气象数据文件名编码到场站编码(config_station.station_code)的映射, JSON格式'
- WHERE NOT EXISTS (SELECT 1 FROM sys_dict_type t WHERE t.dict_type = 'station_file_code_mapping');
- 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, '场站编码-文件映射', '{"JMJD01":"JMJD01","YUWEI":"YUWEI","ZHONGXIN":"ZHONGXIN"}', 'station_file_code_mapping', '', '', 'Y', '0', 'admin', now(), 'JSON对象: key=文件名首段编码, value=场站编码'
- WHERE NOT EXISTS (SELECT 1 FROM sys_dict_data t WHERE t.dict_type = 'station_file_code_mapping');
|
