From 3a6015853789a60b71185f9d73bb8e7f2bbe3d6c Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期一, 18 三月 2024 13:27:50 +0800
Subject: [PATCH] 移除无关文件
---
/dev/null | 298 -----------------------------------------------------------
1 files changed, 0 insertions(+), 298 deletions(-)
diff --git a/src/main/resources/mapper/UpsPowerDataHistoryMapper.xml b/src/main/resources/mapper/UpsPowerDataHistoryMapper.xml
deleted file mode 100644
index 6704cc2..0000000
--- a/src/main/resources/mapper/UpsPowerDataHistoryMapper.xml
+++ /dev/null
@@ -1,298 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="com.whyc.mapper.UpsPowerDataHistoryMapper" >
-
- <insert id="createTable4UpsDataHistory">
- CREATE TABLE `db_upspwrdev_data_history`.${tableName} (
- `num` bigint(20) NOT NULL AUTO_INCREMENT,
- `power_device_id` int(11) NOT NULL DEFAULT '0',
- `record_time` datetime NOT NULL DEFAULT '2005-01-01 00:00:00',
- `acin_vola` float NOT NULL DEFAULT '0' COMMENT 'A鐩歌緭鍏ョ數鍘�',
- `acin_volb` float NOT NULL DEFAULT '0' COMMENT 'B鐩歌緭鍏ョ數鍘�',
- `acin_volc` float NOT NULL DEFAULT '0' COMMENT 'C鐩歌緭鍏ョ數鍘�',
- `acout_vola` float NOT NULL DEFAULT '0' COMMENT 'A鐩歌緭鍑虹數鍘�',
- `acout_volb` float NOT NULL DEFAULT '0' COMMENT 'B鐩歌緭鍑虹數鍘�',
- `acout_volc` float NOT NULL DEFAULT '0' COMMENT 'C鐩歌緭鍑虹數鍘�',
- `acout_curra` float NOT NULL DEFAULT '0' COMMENT 'A鐩歌緭鍑虹數娴�',
- `acout_currb` float NOT NULL DEFAULT '0' COMMENT 'B鐩歌緭鍑虹數娴�',
- `acout_currc` float NOT NULL DEFAULT '0' COMMENT 'C鐩歌緭鍑虹數娴�',
- `dcin_vol` float NOT NULL DEFAULT '0' COMMENT '鐩存祦杈撳叆鐢靛帇[鐢垫睜缁�1鐢垫睜鐢靛帇]',
- `out_freq` float NOT NULL DEFAULT '0' COMMENT '杈撳嚭棰戠巼',
- `abin_vol` float NOT NULL DEFAULT '0' COMMENT 'AB绾胯緭鍏ョ數鍘�',
- `bcin_vol` float NOT NULL DEFAULT '0' COMMENT 'BC绾胯緭鍏ョ數鍘�',
- `cain_vol` float NOT NULL DEFAULT '0' COMMENT 'CA绾胯緭鍏ョ數鍘�',
- `acin_curra` float NOT NULL DEFAULT '0' COMMENT 'A鐩歌緭鍏ョ數娴�',
- `acin_currb` float NOT NULL DEFAULT '0' COMMENT 'B鐩歌緭鍏ョ數娴�',
- `acin_currc` float NOT NULL DEFAULT '0' COMMENT 'C鐩歌緭鍏ョ數娴�',
- `in_freq` float NOT NULL DEFAULT '0' COMMENT '杈撳叆棰戠巼',
- `in_powerfactor_a` float NOT NULL DEFAULT '0' COMMENT 'A鐩歌緭鍏ュ姛鐜囧洜鏁�',
- `in_powerfactor_b` float NOT NULL DEFAULT '0' COMMENT 'B鐩歌緭鍏ュ姛鐜囧洜鏁�',
- `in_powerfactor_c` float NOT NULL DEFAULT '0' COMMENT 'C鐩歌緭鍏ュ姛鐜囧洜鏁�',
- `pass_vola` float NOT NULL DEFAULT '0' COMMENT 'A鐩告梺璺數鍘�',
- `pass_volb` float NOT NULL DEFAULT '0' COMMENT 'B鐩告梺璺數鍘�',
- `pass_volc` float NOT NULL DEFAULT '0' COMMENT 'C鐩告梺璺數鍘�',
- `pass_freq` float NOT NULL DEFAULT '0' COMMENT '鏃佽矾棰戠巼',
- `about_vol` float NOT NULL DEFAULT '0' COMMENT 'AB绾胯緭鍑虹數鍘�',
- `bcout_vol` float unsigned NOT NULL DEFAULT '0' COMMENT 'BC绾胯緭鍑虹數鍘�',
- `caout_vol` float NOT NULL DEFAULT '0' COMMENT 'CA绾胯緭鍑虹數鍘�',
- `abpass_vol` float NOT NULL DEFAULT '0' COMMENT 'AB绾挎梺璺數鍘�',
- `bcpass_vol` float NOT NULL DEFAULT '0' COMMENT 'BC绾挎梺璺數鍘�',
- `capass_vol` float NOT NULL DEFAULT '0' COMMENT 'CA绾挎梺璺數鍘�',
- `out_powerfactor_a` float NOT NULL DEFAULT '0' COMMENT 'A鐩歌緭鍑哄姛鐜囧洜鏁�',
- `out_powerfactor_b` float NOT NULL DEFAULT '0' COMMENT 'B鐩歌緭鍑哄姛鐜囧洜鏁�',
- `out_powerfactor_c` float NOT NULL DEFAULT '0' COMMENT 'C鐩歌緭鍑哄姛鐜囧洜鏁�',
- `out_peakratio_a` float NOT NULL DEFAULT '0' COMMENT 'A鐩歌緭鍑哄嘲鍊兼瘮',
- `out_peakratio_b` float NOT NULL DEFAULT '0' COMMENT 'B鐩歌緭鍑哄嘲鍊兼瘮',
- `out_peakratio_c` float NOT NULL DEFAULT '0' COMMENT 'C鐩歌緭鍑哄嘲鍊兼瘮',
- `out_actpower_a` float NOT NULL DEFAULT '0' COMMENT 'A鐩歌緭鍑烘湁鍔熷姛鐜�',
- `out_actpower_b` float NOT NULL DEFAULT '0' COMMENT 'B鐩歌緭鍑烘湁鍔熷姛鐜�',
- `out_actpower_c` float NOT NULL DEFAULT '0' COMMENT 'C鐩歌緭鍑烘湁鍔熷姛鐜�',
- `out_reapower_a` float NOT NULL DEFAULT '0' COMMENT 'A鐩歌緭鍑烘棤鍔熷姛鐜�',
- `out_reapower_b` float NOT NULL DEFAULT '0' COMMENT 'B鐩歌緭鍑烘棤鍔熷姛鐜�',
- `out_reapower_c` float NOT NULL DEFAULT '0' COMMENT 'C鐩歌緭鍑烘棤鍔熷姛鐜�',
- `out_apppower_a` float NOT NULL DEFAULT '0' COMMENT 'A鐩歌緭鍑鸿鍦ㄥ姛鐜�',
- `out_apppower_b` float NOT NULL DEFAULT '0' COMMENT 'B鐩歌緭鍑鸿鍦ㄥ姛鐜�',
- `out_apppower_c` float NOT NULL DEFAULT '0' COMMENT 'C鐩歌緭鍑鸿鍦ㄥ姛鐜�',
- `out_loadpercent_a` float NOT NULL DEFAULT '0' COMMENT 'A鐩歌緭鍑鸿礋杞界櫨鍒嗘瘮',
- `out_loadpercent_b` float NOT NULL DEFAULT '0' COMMENT 'B鐩歌緭鍑鸿礋杞界櫨鍒嗘瘮',
- `out_loadpercent_c` float NOT NULL DEFAULT '0' COMMENT 'C鐩歌緭鍑鸿礋杞界櫨鍒嗘瘮',
- `sysout_actpower_a` float NOT NULL DEFAULT '0' COMMENT '绯荤粺A鐩歌緭鍑烘湁鍔熷姛鐜�',
- `sysout_actpower_b` float NOT NULL DEFAULT '0' COMMENT '绯荤粺B鐩歌緭鍑烘湁鍔熷姛鐜�',
- `sysout_actpower_c` float NOT NULL DEFAULT '0' COMMENT '绯荤粺C鐩歌緭鍑烘湁鍔熷姛鐜�',
- `sysout_apppower_a` float NOT NULL DEFAULT '0' COMMENT '绯荤粺A鐩歌緭鍑鸿鍦ㄥ姛鐜�',
- `sysout_apppower_b` float NOT NULL DEFAULT '0' COMMENT '绯荤粺B鐩歌緭鍑鸿鍦ㄥ姛鐜�',
- `sysout_apppower_c` float NOT NULL DEFAULT '0' COMMENT '绯荤粺C鐩歌緭鍑鸿鍦ㄥ姛鐜�',
- `sysout_reapower_a` float NOT NULL DEFAULT '0' COMMENT '绯荤粺A鐩歌緭鍑烘棤鍔熷姛鐜�',
- `sysout_reapower_b` float NOT NULL DEFAULT '0' COMMENT '绯荤粺B鐩歌緭鍑烘棤鍔熷姛鐜�',
- `sysout_reapower_c` float NOT NULL DEFAULT '0' COMMENT '绯荤粺C鐩歌緭鍑烘棤鍔熷姛鐜�',
- `dev_envir_temp` float NOT NULL DEFAULT '0' COMMENT '鏁存満鐜娓╁害',
- `batt_backup_time` float NOT NULL DEFAULT '0' COMMENT '鐢垫睜鍚庡鏃堕棿',
- `batt_posivol` float NOT NULL DEFAULT '0' COMMENT '姝ｇ數姹犵數鍘�',
- `batt_posicurr` float NOT NULL DEFAULT '0' COMMENT '姝ｇ數姹犵數娴�',
- `batt_negavol` float NOT NULL DEFAULT '0' COMMENT '璐熺數姹犵數鍘�',
- `batt_negacurr` float NOT NULL DEFAULT '0' COMMENT '璐熺數姹犵數娴�',
- `batt_agecoefficient` float NOT NULL DEFAULT '0' COMMENT '鐢垫睜鑰佸寲绯绘暟',
- `batt_temp` float NULL COMMENT '鐢垫睜娓╁害',
- `envir_temp` float NULL COMMENT '鐜娓╁害',
- `power_supply_state` int(11) NOT NULL DEFAULT '0' COMMENT 'bit0锛氶�嗗彉渚涚數;bit1:鏃佽矾渚涚數',
- `batt_state` int(11) NOT NULL DEFAULT '0' COMMENT 'bit0:鐢垫睜鑷涓� bit1:鐢垫睜娴厖 bit2锛氱數姹犲潎鍏�',
- `inverter_on` int(11) NOT NULL DEFAULT '0' COMMENT '閫嗗彉鍣ㄥ紑鏈�',
- `rectifier_power_supply` int(11) NOT NULL DEFAULT '0' COMMENT '鏁存祦鍣ㄤ緵鐢电姸鎬侊細bit0:涓婚�嗗彉渚涚數 bit:鐢垫睜閫嗗彉渚涚數',
- `dynamo_access` int(11) NOT NULL DEFAULT '0' COMMENT '鍙戠數鏈烘帴鍏�',
- `input_switch_state` int(11) NOT NULL DEFAULT '0' COMMENT '杈撳叆绌哄紑 bit0锛氳緭鍏ョ┖寮�鏂紑 bit1:杈撳叆绌哄紑涓嶆敮鎸�',
- `repire_switch_state` int(11) NOT NULL DEFAULT '0' COMMENT '缁翠慨绌哄紑 bit0锛氱┖寮�鏂紑 bit1:绌哄紑涓嶆敮鎸�',
- `pass_switch_state` int(11) NOT NULL DEFAULT '0' COMMENT '鏃佽矾绌哄紑 bit0: 鏃佽矾绌哄紑鏂紑 bit1锛氭梺璺┖寮�涓嶆敮鎸�',
- `output_switch_state` int(11) NOT NULL DEFAULT '0' COMMENT '杈撳嚭绌哄紑 bit0:杈撳嚭绌哄紑鏂紑 bit1锛氳緭鍑虹┖寮�涓嶆敮鎸�',
- `machine_work_mode` int(11) NOT NULL DEFAULT '0' COMMENT '鏁存満宸ヤ綔妯″紡锛歜it0:姝ｅ父妯″紡 bit1:鍙橀鍣ㄦā寮� bit2:鏅鸿兘骞舵満妯″紡 bit3:鏅鸿兘骞舵満婕旂ず妯″紡 bit4:ECO妯″紡 bit5:鏅鸿兘ECO妯″紡 bit6:鏅鸿兘ECO婕旂ず妯″紡',
- `parallelsys_powerstate` int(11) NOT NULL DEFAULT '0' COMMENT '骞舵満绯荤粺渚涚數鐘舵�� bit0-鏃佽矾渚涚數 bit1-涓昏矾閫嗗彉渚涚數 bit2-鐢垫睜閫嗗彉渚涚數',
- `model_online` int(11) NOT NULL DEFAULT '0' COMMENT '妯″潡鍦ㄧ嚎 bit0:妯″潡1鍦ㄧ嚎 bit1:妯″潡2鍦ㄧ嚎 bit2锛氭ā鍧�3鍦ㄧ嚎 ... bit11:妯″潡12鍦ㄧ嚎 ',
- `batt_inswitch_open` int(11) NOT NULL DEFAULT '0' COMMENT '鍐呯疆鐢垫睜绌哄紑鏂紑',
- `bcb1_state` int(11) NOT NULL DEFAULT '0' COMMENT 'BCB1鐘舵�� bit0:BCB1鏈帴鍏� bit1锛欱CB1:闂悎',
- `bcb2_state` int(11) NOT NULL DEFAULT '0' COMMENT 'BCB2鐘舵�� bit0:BCB2鏈帴鍏� bit1锛欱CB2:闂悎',
- `bcb3_state` int(11) NOT NULL DEFAULT '0' COMMENT 'BCB3鐘舵�� bit0:BCB3鏈帴鍏� bit1锛欱CB3:闂悎',
- `bcb4_state` int(11) NOT NULL DEFAULT '0' COMMENT 'BCB4鐘舵�� bit0:BCB4鏈帴鍏� bit1锛欱CB4:闂悎',
- `ups_alm1` int(11) NOT NULL DEFAULT '0' COMMENT 'ups鍛婅1 bit0:閫嗗彉鍣ㄤ笉鍚屾 bit1:涓昏矾鐢靛帇寮傚父 bit2:鏁存祦鍣ㄥ紓甯� bit3:閫嗗彉鍣ㄥ紓甯� bit4:鏃佽矾寮傚父 bit5:鐢垫睜鐢靛帇浣庝簬涓嬮檺 bit6:鐢垫睜鐢靛帇杩囬珮 bit7:鐢垫睜鏈帴鍏� bit8:鐢垫睜鐢靛帇浣庝簬鍛婅 bit9:鐢垫睜鎺ュ弽 bit10:ParaMonCAN閫氳寮傚父 bit11:PowerCAN閫氳寮傚父 bit12:鏁存祦DSP绋嬪簭閿欒 bit13:鏁存祦FPGA绋嬪簭閿欒 bit14:閫嗗彉DSP绋嬪簭閿欒 bit15:閫嗗彉FPGA绋嬪簭閿欒 bit16:鏃佽矾DSP绋嬪簭閿欒 bit17:鏃佽矾FPGA绋嬪簭閿欒 bit18:鏈烘灦鍐呯鏁ｆ�荤嚎閫氳寮傚父 bit19:鏈烘灦闂寸鏁ｆ�荤嚎閫氳寮傚父 bit20:涓绘帶妯″潡璁剧疆涓嶅尮閰� bit21:LBS寮傚父 bit22:绱ф�ュ叧鏈� bit23:鏃佽矾鏅堕椄绠℃晠闅� bit24:鏃佽矾鐩稿簭鍙�',
- `ups_alm2` int(11) NOT NULL DEFAULT '0' COMMENT 'ups鍛婅2 bit0鏃佽矾杩囨祦 bit1鏃佽矾寮傚父鍏虫満 bit2鍒囨崲娆℃暟闄愬埗 bit3ECO鍒囨崲娆℃暟闄愬埗 bit4ParaPowerCan閫氳寮傚父 bit5鐢垫睜鏀剧數闄愭祦 bit6鏀剧數鍣ㄦ晠闅� bit7鍏呯數鍣ㄦ晠闅� bit8LBS杩炴帴绾垮紓甯� bit9鐢垫睜闇�缁存姢 bit10鐢垫睜杩囨俯 bit11鐢垫睜鎺ュ湴鏁呴殰 bit12涓昏矾棰戠巼寮傚父 bit13妯″潡杩囨俯 bit14浠庢帶妯″潡璁剧疆涓嶅尮閰� bit15鎺ュ彛妯″潡璁剧疆涓嶅尮閰� bit16鍧囧厖瓒呮椂 bit17杈呭姪鐢垫簮鎺夌數 bit18涓昏矾鐩稿簭鍙� bit19鏁存祦鍣ㄨ蒋鍚姩澶辫触 bit20鐢ㄦ埛鎿嶄綔閿欒 bit21杈撳嚭鐔斾笣鏂� bit22杈撳嚭杩囪浇 bit23绯荤粺杩囪浇 bit24杈撳嚭杩囪浇瓒呮椂',
- `ups_alm3` int(11) NOT NULL DEFAULT '0' COMMENT 'ups鍛婅3 bit0璐熻浇鍐插嚮杞梺璺� bit1骞舵満鍧囨祦寮傚父 bit2姣嶇嚎寮傚父鍏虫満 bit3涓存満璇锋眰杞梺璺� bit4鐩存祦姣嶇嚎杩囧帇 bit5MonCAN閫氳寮傚父 bit6杈撳叆缂洪浂鏁呴殰 bit7閫嗗彉缁х數鍣ㄦ晠闅� bit8涓昏矾鍙嶇亴 bit9杈撳叆鐢垫祦寮傚父 bit10杈撳嚭鐢靛帇寮傚父 bit11杈撳叆鐢垫祦瓒呴檺 bit12鏃佽矾杩囨俯 bit13閭绘満鏃佽矾鏅堕椄绠℃晠闅� bit14骞舵満杩炴帴绾垮紓甯� bit15鍏呯數鍣ㄨ繃娓� bit16鐢垫睜绔彛鐭矾 bit17鐢垫睜鎴跨幆澧冨紓甯� bit18椋庢墖寮傚父 bit19鏃佽矾缂洪浂鏁呴殰 bit20鏃佽矾鎺ョ bit21BCB1 鐘舵�佸紓甯� bit22BCB2 鐘舵�佸紓甯� bit23BCB3 鐘舵�佸紓甯� bit24BCB4 鐘舵�佸紓甯�',
- `ups_alm4` int(11) NOT NULL DEFAULT '0' COMMENT 'ups鍛婅4 bit0鏃佽矾SCR椋庢墖寮傚父 bit1骞宠 鐢佃矾鏁呴殰 bit2骞宠 鐢佃矾杩囨祦 bit3骞宠 鐢佃矾杩囨俯 bit4澶卞幓鍐椾綑 bit5瀹归噺杩囪浇 bit6鍔熺巼鏉胯缃笉鍖归厤 bit7鏃佽矾璁剧疆涓嶅尮閰� bit8涓婃娊椋庨鎵囧紓甯� bit9绯荤粺A鐩歌緭鍑虹啍涓濇柇 bit10绯荤粺B鐩歌緭鍑虹啍涓濇柇 bit11绯荤粺C鐩歌緭鍑虹啍涓濇柇 bit12鏃佽矾鏃犳晥 bit13鏁存祦鍣ㄨ繃娴� bit14鏃佽矾杩囨祦瓒呮椂 bit15杈撳嚭闆跺湴杩囧帇 bit16杈撳叆鐔斾笣鏂� bit17鏃佽矾鐔斾笣鏂�',
- `ups_conn_err` int(11) NOT NULL DEFAULT '0' COMMENT '鍗忚浆涓嶶PS閫氫俊鏁呴殰',
- PRIMARY KEY (`num`),
- KEY `index_powerdeviceid` (`power_device_id`) USING BTREE,
- KEY `index_record_time` (`record_time`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='UPS鍘嗗彶瀹炴椂鏁版嵁璁板綍琛�'
- </insert>
- <insert id="insert">
- insert into `db_upspwrdev_data_history`.${tableName}
- (`power_device_id`,
- `record_time`,
- `acin_vola`,
- `acin_volb`,
- `acin_volc`,
- `acout_vola`,
- `acout_volb`,
- `acout_volc`,
- `acout_curra`,
- `acout_currb`,
- `acout_currc`,
- `dcin_vol`,
- `out_freq`,
- `abin_vol`,
- `bcin_vol`,
- `cain_vol`,
- `acin_curra`,
- `acin_currb`,
- `acin_currc`,
- `in_freq`,
- `in_powerfactor_a`,
- `in_powerfactor_b`,
- `in_powerfactor_c`,
- `pass_vola`,
- `pass_volb`,
- `pass_volc`,
- `pass_freq`,
- `about_vol`,
- `bcout_vol`,
- `caout_vol`,
- `abpass_vol`,
- `bcpass_vol`,
- `capass_vol`,
- `out_powerfactor_a`,
- `out_powerfactor_b`,
- `out_powerfactor_c`,
- `out_peakratio_a`,
- `out_peakratio_b`,
- `out_peakratio_c`,
- `out_actpower_a`,
- `out_actpower_b`,
- `out_actpower_c`,
- `out_reapower_a`,
- `out_reapower_b`,
- `out_reapower_c`,
- `out_apppower_a`,
- `out_apppower_b`,
- `out_apppower_c`,
- `out_loadpercent_a`,
- `out_loadpercent_b`,
- `out_loadpercent_c`,
- `sysout_actpower_a`,
- `sysout_actpower_b`,
- `sysout_actpower_c`,
- `sysout_apppower_a`,
- `sysout_apppower_b`,
- `sysout_apppower_c`,
- `sysout_reapower_a`,
- `sysout_reapower_b`,
- `sysout_reapower_c`,
- `dev_envir_temp`,
- `batt_backup_time`,
- `batt_posivol`,
- `batt_posicurr`,
- `batt_negavol`,
- `batt_negacurr`,
- `batt_agecoefficient`,
- `batt_temp`,
- `envir_temp`,
- `power_supply_state`,
- `batt_state`,
- `inverter_on`,
- `rectifier_power_supply`,
- `dynamo_access`,
- `input_switch_state`,
- `repire_switch_state`,
- `pass_switch_state`,
- `output_switch_state`,
- `machine_work_mode`,
- `parallelsys_powerstate`,
- `model_online`,
- `batt_inswitch_open`,
- `bcb1_state`,
- `bcb2_state`,
- `bcb3_state`,
- `bcb4_state`,
- `ups_alm1`,
- `ups_alm2`,
- `ups_alm3`,
- `ups_alm4`,
- `ups_conn_err`) values (
- #{dataHistory.powerDeviceId},
- #{dataHistory.recordTime},
- #{dataHistory.acinVola},
- #{dataHistory.acinVolb},
- #{dataHistory.acinVolc},
- #{dataHistory.acoutVola},
- #{dataHistory.acoutVolb},
- #{dataHistory.acoutVolc},
- #{dataHistory.acoutCurra},
- #{dataHistory.acoutCurrb},
- #{dataHistory.acoutCurrc},
- #{dataHistory.dcinVol},
- #{dataHistory.outFreq},
- #{dataHistory.abinVol},
- #{dataHistory.bcinVol},
- #{dataHistory.cainVol},
- #{dataHistory.acinCurra},
- #{dataHistory.acinCurrb},
- #{dataHistory.acinCurrc},
- #{dataHistory.inFreq},
- #{dataHistory.inPowerfactorA},
- #{dataHistory.inPowerfactorB},
- #{dataHistory.inPowerfactorC},
- #{dataHistory.passVola},
- #{dataHistory.passVolb},
- #{dataHistory.passVolc},
- #{dataHistory.passFreq},
- #{dataHistory.aboutVol},
- #{dataHistory.bcoutVol},
- #{dataHistory.caoutVol},
- #{dataHistory.abpassVol},
- #{dataHistory.bcpassVol},
- #{dataHistory.capassVol},
- #{dataHistory.outPowerfactorA},
- #{dataHistory.outPowerfactorB},
- #{dataHistory.outPowerfactorC},
- #{dataHistory.outPeakratioA},
- #{dataHistory.outPeakratioB},
- #{dataHistory.outPeakratioC},
- #{dataHistory.outActpowerA},
- #{dataHistory.outActpowerB},
- #{dataHistory.outActpowerC},
- #{dataHistory.outReapowerA},
- #{dataHistory.outReapowerB},
- #{dataHistory.outReapowerC},
- #{dataHistory.outApppowerA},
- #{dataHistory.outApppowerB},
- #{dataHistory.outApppowerC},
- #{dataHistory.outLoadpercentA},
- #{dataHistory.outLoadpercentB},
- #{dataHistory.outLoadpercentC},
- #{dataHistory.sysoutActpowerA},
- #{dataHistory.sysoutActpowerB},
- #{dataHistory.sysoutActpowerC},
- #{dataHistory.sysoutApppowerA},
- #{dataHistory.sysoutApppowerB},
- #{dataHistory.sysoutApppowerC},
- #{dataHistory.sysoutReapowerA},
- #{dataHistory.sysoutReapowerB},
- #{dataHistory.sysoutReapowerC},
- #{dataHistory.devEnvirTemp},
- #{dataHistory.battBackupTime},
- #{dataHistory.battPosivol},
- #{dataHistory.battPosicurr},
- #{dataHistory.battNegavol},
- #{dataHistory.battNegacurr},
- #{dataHistory.battAgecoefficient},
- #{dataHistory.battTemp},
- #{dataHistory.envirTemp},
- #{dataHistory.powerSupplyState},
- #{dataHistory.battState},
- #{dataHistory.inverterOn},
- #{dataHistory.rectifierPowerSupply},
- #{dataHistory.dynamoAccess},
- #{dataHistory.inputSwitchState},
- #{dataHistory.repireSwitchState},
- #{dataHistory.passSwitchState},
- #{dataHistory.outputSwitchState},
- #{dataHistory.machineWorkMode},
- #{dataHistory.parallelsysPowerstate},
- #{dataHistory.modelOnline},
- #{dataHistory.battInswitchOpen},
- #{dataHistory.bcb1State},
- #{dataHistory.bcb2State},
- #{dataHistory.bcb3State},
- #{dataHistory.bcb4State},
- #{dataHistory.upsAlm1},
- #{dataHistory.upsAlm2},
- #{dataHistory.upsAlm3},
- #{dataHistory.upsAlm4},
- #{dataHistory.upsConnErr}
- )
-
- </insert>
- <delete id="deleteTableList">
- drop table
- <foreach collection="list" separator="," item="item">
- db_upspwrdev_data_history.${item}
- </foreach>
- </delete>
-
-</mapper>
\ No newline at end of file
--
Gitblit v1.9.1