| | |
| | | import com.whyc.pojo.db_ckpwrdev_data_rt.CKPowerDevRtSetLog; |
| | | import com.whyc.service.CKPowerDevRtSetLogService; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import java.util.Date; |
| | | import java.util.LinkedList; |
| | | import java.util.List; |
| | | |
| | | @RestController |
| | | @RequestMapping("ckPowerDevRtSetLog") |
| | | @Api("电源设备遥测量设置日志") |
| | | @Api(tags = "电源遥测量设置日志") |
| | | public class CKPowerDevRtSetLogController { |
| | | |
| | | @Autowired |
| | | private CKPowerDevRtSetLogService service; |
| | | |
| | | @PostMapping("getCounts") |
| | | public Response getCounts(@RequestBody List<String> countFields){ |
| | | return service.getCounts(countFields); |
| | | @ApiOperation("分页查询") |
| | | @PostMapping("getPage") |
| | | public Response getPage(@RequestBody CKPowerDevRtSetLog param){ |
| | | return service.getPage(param); |
| | | } |
| | | |
| | | @GetMapping |
| | | public Response testAdded(){ |
| | | CKPowerDevRtSetLog log = new CKPowerDevRtSetLog(); |
| | | log.setPowerDeviceId(0); |
| | | log.setAcIn1VolAFake(0f); |
| | | log.setAcIn1VolASt(0); |
| | | log.setAcIn1VolBFake(0f); |
| | | log.setAcIn1VolBSt(0); |
| | | log.setAcIn1VolCFake(0f); |
| | | log.setAcIn1VolCSt(0); |
| | | log.setAcIn1CurrAFake(0f); |
| | | log.setAcIn1CurrASt(0); |
| | | log.setAcIn1CurrBFake(0f); |
| | | log.setAcIn1CurrBSt(0); |
| | | log.setAcIn1CurrCFake(0f); |
| | | log.setAcIn1CurrCSt(0); |
| | | log.setAcIn2VolAFake(0f); |
| | | log.setAcIn2VolASt(0); |
| | | log.setAcIn2VolBFake(0f); |
| | | log.setAcIn2VolBSt(0); |
| | | log.setAcIn2VolCFake(0f); |
| | | log.setAcIn2VolCSt(0); |
| | | log.setAcIn2CurrAFake(0f); |
| | | log.setAcIn2CurrASt(0); |
| | | log.setAcIn2CurrBFake(0f); |
| | | log.setAcIn2CurrBSt(0); |
| | | log.setAcIn2CurrCFake(0f); |
| | | log.setAcIn2CurrCSt(0); |
| | | log.setAcCabinetTempFake(0f); |
| | | log.setAcCabinetTempSt(0); |
| | | log.setDcCabinetTempFake(0f); |
| | | log.setDcCabinetTempSt(0); |
| | | log.setHighFrqCabinetTempFake(0f); |
| | | log.setHighFrqCabinetTempSt(0); |
| | | log.setAcOutVolAFake(0f); |
| | | log.setAcOutVolASt(0); |
| | | log.setAcOutVolBFake(0f); |
| | | log.setAcOutVolBSt(0); |
| | | log.setAcOutVolCFake(0f); |
| | | log.setAcOutVolCSt(0); |
| | | log.setAcOutCurrAFake(0f); |
| | | log.setAcOutCurrASt(0); |
| | | log.setAcOutCurrBFake(0f); |
| | | log.setAcOutCurrBSt(0); |
| | | log.setAcOutCurrCFake(0f); |
| | | log.setAcOutCurrCSt(0); |
| | | log.setDcOutVolFake(0f); |
| | | log.setDcOutVolSt(0); |
| | | log.setLoadCurrFake(0f); |
| | | log.setLoadCurrSt(0); |
| | | log.setBattCharCurrFake(0f); |
| | | log.setBattCharCurrSt(0); |
| | | log.setDcIn1VolFake(0f); |
| | | log.setDcIn1VolSt(0); |
| | | log.setDcIn2VolFake(0f); |
| | | log.setDcIn2VolSt(0); |
| | | log.setDcOut1VolFake(0f); |
| | | log.setDcOut1VolSt(0); |
| | | log.setDcOut2VolFake(0f); |
| | | log.setDcOut2VolSt(0); |
| | | log.setDcOut1CurrFake(0f); |
| | | log.setDcOut1CurrSt(0); |
| | | log.setDcOut2CurrFake(0f); |
| | | log.setDcOut2CurrSt(0); |
| | | log.setBatt1GroupVolFake(0f); |
| | | log.setBatt1GroupVolSt(0); |
| | | log.setBatt2GroupVolFake(0f); |
| | | log.setBatt2GroupVolSt(0); |
| | | log.setM1OutCurrFake(0f); |
| | | log.setM1OutCurrSt(0); |
| | | log.setM2OutCurrFake(0f); |
| | | log.setM2OutCurrSt(0); |
| | | log.setM3OutCurrFake(0f); |
| | | log.setM3OutCurrSt(0); |
| | | log.setM4OutCurrFake(0f); |
| | | log.setM4OutCurrSt(0); |
| | | log.setM5OutCurrFake(0f); |
| | | log.setM5OutCurrSt(0); |
| | | log.setM6OutCurrFake(0f); |
| | | log.setM6OutCurrSt(0); |
| | | log.setM7OutCurrFake(0f); |
| | | log.setM7OutCurrSt(0); |
| | | log.setM8OutCurrFake(0f); |
| | | log.setM8OutCurrSt(0); |
| | | log.setM9OutCurrFake(0f); |
| | | log.setM9OutCurrSt(0); |
| | | log.setM10OutCurrFake(0f); |
| | | log.setM10OutCurrSt(0); |
| | | log.setM11OutCurrFake(0f); |
| | | log.setM11OutCurrSt(0); |
| | | log.setM12OutCurrFake(0f); |
| | | log.setM12OutCurrSt(0); |
| | | log.setM13OutCurrFake(0f); |
| | | log.setM13OutCurrSt(0); |
| | | log.setM14OutCurrFake(0f); |
| | | log.setM14OutCurrSt(0); |
| | | log.setM15OutCurrFake(0f); |
| | | log.setM15OutCurrSt(0); |
| | | log.setM16OutCurrFake(0f); |
| | | log.setM16OutCurrSt(0); |
| | | log.setM17OutCurrFake(0f); |
| | | log.setM17OutCurrSt(0); |
| | | log.setM18OutCurrFake(0f); |
| | | log.setM18OutCurrSt(0); |
| | | log.setM19OutCurrFake(0f); |
| | | log.setM19OutCurrSt(0); |
| | | log.setM20OutCurrFake(0f); |
| | | log.setM20OutCurrSt(0); |
| | | log.setM21OutCurrFake(0f); |
| | | log.setM21OutCurrSt(0); |
| | | log.setM22OutCurrFake(0f); |
| | | log.setM22OutCurrSt(0); |
| | | log.setM23OutCurrFake(0f); |
| | | log.setM23OutCurrSt(0); |
| | | log.setM24OutCurrFake(0f); |
| | | log.setM24OutCurrSt(0); |
| | | log.setM25OutCurrFake(0f); |
| | | log.setM25OutCurrSt(0); |
| | | log.setM26OutCurrFake(0f); |
| | | log.setM26OutCurrSt(0); |
| | | log.setM27OutCurrFake(0f); |
| | | log.setM27OutCurrSt(0); |
| | | log.setM28OutCurrFake(0f); |
| | | log.setM28OutCurrSt(0); |
| | | log.setM29OutCurrFake(0f); |
| | | log.setM29OutCurrSt(0); |
| | | log.setM30OutCurrFake(0f); |
| | | log.setM30OutCurrSt(0); |
| | | log.setM31OutCurrFake(0f); |
| | | log.setM31OutCurrSt(0); |
| | | log.setM32OutCurrFake(0f); |
| | | log.setM32OutCurrSt(0); |
| | | log.setAc1InVolAFake(0f); |
| | | log.setAc1InVolASt(0); |
| | | log.setAc1InVolBFake(0f); |
| | | log.setAc1InVolBSt(0); |
| | | log.setAc1InVolCFake(0f); |
| | | log.setAc1InVolCSt(0); |
| | | log.setAc2InVolAFake(0f); |
| | | log.setAc2InVolASt(0); |
| | | log.setAc2InVolBFake(0f); |
| | | log.setAc2InVolBSt(0); |
| | | log.setAc2InVolCFake(0f); |
| | | log.setAc2InVolCSt(0); |
| | | log.setCreateTime(new Date()); |
| | | |
| | | //插入50万条数据 |
| | | for (int i = 0; i < 5000; i++) { |
| | | List<CKPowerDevRtSetLog> logs = new LinkedList<>(); |
| | | for (int j = 0; j < 100; j++) { |
| | | logs.add(log); |
| | | } |
| | | service.addBatch(logs); |
| | | System.out.println(i); |
| | | } |
| | | |
| | | return new Response().set(1,"插入完成"); |
| | | |
| | | @ApiOperation("查询-按天") |
| | | @PostMapping("getList") |
| | | public Response getList(@RequestParam String param, @RequestParam String dayTime){ |
| | | return service.getList(param,dayTime); |
| | | } |
| | | |
| | | } |