and p.seq in ( ${plantSeqs} )
t_weather_2021
insert into t_pmsdata_${realtimeYear} (
plantSeq, pcsIdx, timetableSeq, inputDate, inputHour, inputMinute, chargePower, dischargePower, pvPower,
data1, data2, data3, data4, data5, data6, data7, data8, data9, data10,
data11, data12, data13, data14, data15, data16, data17, data18, data19, data20,
data21, data22, data23, data24, data25, data26, data27, data28, data29, data30,
data31, data32, data33,
data51, data52, data53, data54, data55, data56, data57, data58, data59, data60,
data61, data62, data63, data64, data65, data66, data67, data68, data69, data70,
createDateTime
) values (
#{plantSeq}, #{pcsIdx}, #{timetableSeq}, #{inputDate}, #{inputHour}, #{inputMinute}, #{chargePower}, #{dischargePower}, #{pvPower},
#{data1}, #{data2}, #{data3}, #{data4}, #{data5}, #{data6}, #{data7}, #{data8}, #{data9}, #{data10},
#{data11}, #{data12}, #{data13}, #{data14}, #{data15}, #{data16}, #{data17}, #{data18}, #{data19}, #{data20},
#{data21}, #{data22}, #{data23}, #{data24}, #{data25}, #{data26}, #{data27}, #{data28}, #{data29}, #{data30},
#{data31}, #{data32}, #{data33},
#{data51}, #{data52}, #{data53}, #{data54}, #{data55}, #{data56}, #{data57}, #{data58}, #{data59}, #{data60},
#{data61}, #{data62}, #{data63}, #{data64}, #{data65}, #{data66}, #{data67}, #{data68}, #{data69}, #{data70},
now()
)
update t_sequence set
currSeq = currSeq+1
where seq = #{seq}