dml.sql 2.7 KB

123456789101112131415161718192021222324252627282930313233
  1. update "public"."sys_menu" set icon = 'OLDetection' where menu_name = '测点监测';
  2. update "public"."sys_menu" set icon = 'OLDetection' where menu_name = '实时监控';
  3. update "public"."sys_menu" set icon = 'OLDeviceManagement' where menu_name = '设备管理';
  4. update "public"."sys_menu" set icon = 'OLMeteorologicalResources' where menu_name = '气象资源';
  5. update "public"."sys_menu" set icon = 'OLPowerForecasting' where menu_name = '功率预测';
  6. -- 字典类型: 算法配置(测光法系数)
  7. INSERT INTO sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, remark)
  8. SELECT
  9. nextval(pg_get_serial_sequence('sys_dict_type', 'dict_id')),
  10. '算法配置', 'algorithm_config', '0', 'admin', now(), '理论功率-算法配置'
  11. WHERE NOT EXISTS (SELECT 1 FROM sys_dict_type t WHERE t.dict_type = 'algorithm_config');
  12. -- 算法配置字典数据(先删后插,保证幂等)
  13. DELETE FROM sys_dict_data WHERE dict_type = 'algorithm_config';
  14. 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)
  15. VALUES (nextval(pg_get_serial_sequence('sys_dict_data', 'dict_code')), 1, '测光法配置', '{"a1": 0.0, "a2": 0.0}', 'algorithm_config', '', '', 'N', '0', 'admin', now(), '测光法 P=n*(a1*G+a2*T);a1/a2 初始为 0 占位,需运维替换为真实系数');
  16. -- 字典类型: 理论功率配置项(校核阈值)
  17. INSERT INTO sys_dict_type (dict_id, dict_name, dict_type, status, create_by, create_time, remark)
  18. SELECT
  19. nextval(pg_get_serial_sequence('sys_dict_type', 'dict_id')),
  20. '理论功率配置项', 'theoretical_power_config', '0', 'admin', now(), '理论功率-校核阈值'
  21. WHERE NOT EXISTS (SELECT 1 FROM sys_dict_type t WHERE t.dict_type = 'theoretical_power_config');
  22. -- 理论功率配置项字典数据(先删后插,保证幂等)
  23. DELETE FROM sys_dict_data WHERE dict_type = 'theoretical_power_config';
  24. 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)
  25. VALUES (nextval(pg_get_serial_sequence('sys_dict_data', 'dict_code')), 1, '理论功率配置项', '{"installed2TheoreticalPercent": 99.99, "theoretical2AvailablePercent": 99.99, "available2ActualPercent": 95.00}', 'theoretical_power_config', '', '', 'N', '0', 'admin', now(), '校核阈值,比值≥阈值判合格');
  26. -- config_station 逆变器数量初值(按 station_code 定值更新,天然幂等)
  27. UPDATE config_station SET inverter_quantity = 19 WHERE station_code = 'JMJD01';
  28. UPDATE config_station SET inverter_quantity = 10 WHERE station_code IN ('YUWEI', 'ZHONGXIN', 'YMPV03', 'GBPV04');