<insert id="syncSameData">
INSERT INTO
<foreach collection="sourceData" item="item" separator=" ">
battery_${item.batteryId}
USING my_battery_info TAGS (
#{item.batteryId}
) (
ts,
battery_id,
battery_voltage,
battery_current,
battery_soc,
battery_hard_version,
battery_soft_version,
battery_work_mode,
battery_protect_code,
battery_error_code,
battery_temperature_max,
battery_temperature_min,
battery_voltage_max,
battery_voltage_min,
mos_status,
mos_temp,
battery_cycle_times,
steady_status,
cell_voltage,
model,
manufacture,
imei,
imsi,
iccid,
tracker_hardware_version,
tracker_software_version,
csq,
network_type,
location_mode,
longitude,
longitude_direction,
latitude,
latitude_direction,
gps_speed,
gps_signal,
satellite_num,
accuracy,
flag,
client_id,
topic,
product_key,
handled,
todo_now,
needack,
businessmode,
create_time,
update_time,
payload,
project_id,
sn,
soh,
battery_temperature_avg,
charge_mode,
low_battery_warn,
charge_current_max,
discharge_current_max,
charge_current_avg,
discharge_current_avg,
gps_cog,
total_charge_energy,
charge_cycles_history,
charge_capacity_history,
discharge_capacity_history,
ntc1,
ntc2,
ntc3,
ntc4,
tracker_communication_status,
battery_kind,
dsoc,
correction_rate,
tsoc,
bsoc,
fcc,
actual_soh,
charging_sop,
discharging_sop,
task_max_delay_1ms,
task_max_delay_10ms,
task_max_delay_100ms,
task_max_delay_500ms,
task_max_time_1ms,
task_max_time_10ms,
task_max_time_100ms,
task_max_time_500ms,
empty_count
) VALUES
<foreach collection="item" item="item.records" separator=",">
(
#{item.ts},
#{item.batteryId},
#{item.batteryVoltage},
#{item.batteryCurrent},
#{item.batterySoc},
#{item.batteryHardVersion},
#{item.batterySoftVersion},
#{item.batteryWorkMode},
#{item.batteryProtectCode},
#{item.batteryErrorCode},
#{item.batteryTemperatureMax},
#{item.batteryTemperatureMin},
#{item.batteryVoltageMax},
#{item.batteryVoltageMin},
#{item.mosStatus},
#{item.mosTemp},
#{item.batteryCycleTimes},
#{item.steadyStatus},
#{item.cellVoltage},
#{item.model},
#{item.manufacture},
#{item.imei},
#{item.imsi},
#{item.iccid},
#{item.trackerHardwareVersion},
#{item.trackerSoftwareVersion},
#{item.csq},
#{item.networkType},
#{item.locationMode},
#{item.longitude},
#{item.longitudeDirection},
#{item.latitude},
#{item.latitudeDirection},
#{item.gpsSpeed},
#{item.gpsSignal},
#{item.satelliteNum},
#{item.accuracy},
#{item.flag},
#{item.clientId},
#{item.topic},
#{item.productKey},
#{item.handled},
#{item.todoNow},
#{item.needAck},
#{item.businessMode},
#{item.createTime},
#{item.updateTime},
#{item.payload},
#{item.projectId},
#{item.sn},
#{item.soh},
#{item.batteryTemperatureAvg},
#{item.chargeMode},
#{item.lowBatteryWarn},
#{item.chargeCurrentMax},
#{item.dischargeCurrentMax},
#{item.chargeCurrentAvg},
#{item.dischargeCurrentAvg},
#{item.gpsCog},
#{item.totalChargeEnergy},
#{item.chargeCyclesHistory},
#{item.chargeCapacityHistory},
#{item.dischargeCapacityHistory},
#{item.ntc1},
#{item.ntc2},
#{item.ntc3},
#{item.ntc4},
#{item.trackerCommunicationStatus},
#{item.batteryKind},
#{item.dsoc},
#{item.correctionRate},
#{item.tsoc},
#{item.bsoc},
#{item.fcc},
#{item.actualSoh},
#{item.chargingSop},
#{item.dischargingSop},
#{item.taskMaxDelay1ms},
#{item.taskMaxDelay10ms},
#{item.taskMaxDelay100ms},
#{item.taskMaxDelay500ms},
#{item.taskMaxTime1ms},
#{item.taskMaxTime10ms},
#{item.taskMaxTime100ms},
#{item.taskMaxTime500ms},
#{item.emptyCount}
)
</foreach>
</insert>
这样写是否正确