package com.szpg.db.test;
import com.szpg.db.dao.PgMaintanceDao;
import com.szpg.db.dao.impl.PgMaintanceDaoImpl;
import com.szpg.task.ReadMaintanceTask;
import org.junit.Test;
public class ReadMaintanceTaskTest {
@Test
public void insertDB() {
String jsonStr="{\n" +
"\t\"total\": 20,\n" +
"\t\"totalRecords\": 199,\n" +
"\t\"page\": 1,\n" +
"\t\"records\": 10,\n" +
"\t\"rows\": [{\n" +
"\t\t\"FINISH\": 0,\n" +
"\t\t\"KEY_ID\": \"0567B2C1-CEAC-4C3B-AD34-9A9BC61E5F80\",\n" +
"\t\t\"PLAN_KEY_ID\": \"afec56e0-8db7-4a78-a1c8-a255d2e10fbf\",\n" +
"\t\t\"PLAN_NAME\": \"EPS设备保养计划\",\n" +
"\t\t\"RECORD_NO\": \"WXBY-180911-101004-3945\",\n" +
"\t\t\"REOAIRMAN\": \"dujiannan\",\n" +
"\t\t\"MAINTENANCE_DATE\": \"2018-05-01\",\n" +
"\t\t\"BUILD_CABIN\": \",D,P,Q,R,S\",\n" +
"\t\t\"PROJECT\": \"CBL\",\n" +
"\t\t\"CREATEDATE\": \"2018-09-11\",\n" +
"\t\t\"CREATOR\": \"haojing\",\n" +
"\t\t\"rowNum\": 1\n" +
"\t}, {\n" +
"\t\t\"FINISH\": 0,\n" +
"\t\t\"KEY_ID\": \"07EE7B85-C868-481A-B446-EDD928C9A6EF\",\n" +
"\t\t\"PLAN_KEY_ID\": \"1725b07b-c467-4cc3-b0c9-f090aba0b38d\",\n" +
"\t\t\"PLAN_NAME\": \"火灾自动报警设备保养计划（月度）\",\n" +
"\t\t\"RECORD_NO\": \"WXBY-180911-102446-2491\",\n" +
"\t\t\"REOAIRMAN\": \"panshijin\",\n" +
"\t\t\"MAINTENANCE_DATE\": \"2018-08-01\",\n" +
"\t\t\"BUILD_CABIN\": \",Q\",\n" +
"\t\t\"PROJECT\": \"CBL\",\n" +
"\t\t\"CREATEDATE\": \"2018-09-11\",\n" +
"\t\t\"CREATOR\": \"haojing\",\n" +
"\t\t\"rowNum\": 2\n" +
"\t}, {\n" +
"\t\t\"FINISH\": 0,\n" +
"\t\t\"KEY_ID\": \"0863F267-51EC-451E-AC2F-B2964C81611A\",\n" +
"\t\t\"PLAN_KEY_ID\": \"9b0311c9-b5a5-402c-a888-f6e83f43ca01\",\n" +
"\t\t\"PLAN_NAME\": \"风管、通风口保养计划\",\n" +
"\t\t\"RECORD_NO\": \"WXBY-180910-152000-3389\",\n" +
"\t\t\"REOAIRMAN\": \"zhangronghua\",\n" +
"\t\t\"MAINTENANCE_DATE\": \"2018-08-01\",\n" +
"\t\t\"BUILD_CABIN\": \",D,P,Q,R,S\",\n" +
"\t\t\"PROJECT\": \"CBL\",\n" +
"\t\t\"CREATEDATE\": \"2018-09-10\",\n" +
"\t\t\"CREATOR\": \"wuping\",\n" +
"\t\t\"rowNum\": 3\n" +
"\t}, {\n" +
"\t\t\"FINISH\": 0,\n" +
"\t\t\"KEY_ID\": \"0B5A58EB-5A43-4DD7-B251-AFD8EE9EC7DC\",\n" +
"\t\t\"PLAN_KEY_ID\": \"1725b07b-c467-4cc3-b0c9-f090aba0b38d\",\n" +
"\t\t\"PLAN_NAME\": \"火灾自动报警设备保养计划（月度）\",\n" +
"\t\t\"RECORD_NO\": \"WXBY-180911-102543-9023\",\n" +
"\t\t\"REOAIRMAN\": \"dujiannan\",\n" +
"\t\t\"MAINTENANCE_DATE\": \"2018-09-01\",\n" +
"\t\t\"BUILD_CABIN\": \",D\",\n" +
"\t\t\"PROJECT\": \"CBL\",\n" +
"\t\t\"CREATEDATE\": \"2018-09-11\",\n" +
"\t\t\"CREATOR\": \"haojing\",\n" +
"\t\t\"rowNum\": 4\n" +
"\t}, {\n" +
"\t\t\"FINISH\": 0,\n" +
"\t\t\"KEY_ID\": \"147C5CE2-B1F7-48B9-B9B0-7A3549AB5088\",\n" +
"\t\t\"PLAN_KEY_ID\": \"4874f602-83a2-4e9c-a05f-da1cad9a0427\",\n" +
"\t\t\"PLAN_NAME\": \"弱电间保养计划\",\n" +
"\t\t\"RECORD_NO\": \"WXBY-181016-165641-5849\",\n" +
"\t\t\"REOAIRMAN\": \"邹盛\",\n" +
"\t\t\"MAINTENANCE_DATE\": \"2018-10-16\",\n" +
"\t\t\"BUILD_CABIN\": \",D\",\n" +
"\t\t\"PROJECT\": \"CBL\",\n" +
"\t\t\"CREATEDATE\": \"2018-10-01\",\n" +
"\t\t\"CREATOR\": \"system\",\n" +
"\t\t\"rowNum\": 5\n" +
"\t}, {\n" +
"\t\t\"FINISH\": 2,\n" +
"\t\t\"KEY_ID\": \"16D18621-B2B6-4726-8301-E4EC04E5B366\",\n" +
"\t\t\"PLAN_KEY_ID\": \"a09e5100-c45e-4e3e-8699-f3d420475357\",\n" +
"\t\t\"PLAN_NAME\": \"低压配电箱（柜）保养计划（季度）\",\n" +
"\t\t\"RECORD_NO\": null,\n" +
"\t\t\"REOAIRMAN\": null,\n" +
"\t\t\"MAINTENANCE_DATE\": null,\n" +
"\t\t\"BUILD_CABIN\": \"\",\n" +
"\t\t\"PROJECT\": \"CBL\",\n" +
"\t\t\"CREATEDATE\": \"2018-11-01\",\n" +
"\t\t\"CREATOR\": \"system\",\n" +
"\t\t\"rowNum\": 6\n" +
"\t}, {\n" +
"\t\t\"FINISH\": 0,\n" +
"\t\t\"KEY_ID\": \"1B763BDF-65AA-4F61-ACB8-1F9AAD8B94C7\",\n" +
"\t\t\"PLAN_KEY_ID\": \"3e8a6adb-2721-441a-8703-ce86e10bbe84\",\n" +
"\t\t\"PLAN_NAME\": \"水喷淋设备保养计划\",\n" +
"\t\t\"RECORD_NO\": \"WXBY-180910-151334-8577\",\n" +
"\t\t\"REOAIRMAN\": \"yuweihua\",\n" +
"\t\t\"MAINTENANCE_DATE\": \"2018-06-01\",\n" +
"\t\t\"BUILD_CABIN\": \",D,P,Q,R,S\",\n" +
"\t\t\"PROJECT\": \"CBL\",\n" +
"\t\t\"CREATEDATE\": \"2018-09-10\",\n" +
"\t\t\"CREATOR\": \"wuping\",\n" +
"\t\t\"rowNum\": 7\n" +
"\t}, {\n" +
"\t\t\"FINISH\": 1,\n" +
"\t\t\"KEY_ID\": \"20054191-2C9B-4134-B15B-672497761ECD\",\n" +
"\t\t\"PLAN_KEY_ID\": \"1725b07b-c467-4cc3-b0c9-f090aba0b38d\",\n" +
"\t\t\"PLAN_NAME\": \"火灾自动报警设备保养计划（月度）\",\n" +
"\t\t\"RECORD_NO\": null,\n" +
"\t\t\"REOAIRMAN\": null,\n" +
"\t\t\"MAINTENANCE_DATE\": null,\n" +
"\t\t\"BUILD_CABIN\": \",D,P,Q,R,S\",\n" +
"\t\t\"PROJECT\": \"CBL\",\n" +
"\t\t\"CREATEDATE\": \"2018-11-01\",\n" +
"\t\t\"CREATOR\": \"system\",\n" +
"\t\t\"rowNum\": 8\n" +
"\t}, {\n" +
"\t\t\"FINISH\": 0,\n" +
"\t\t\"KEY_ID\": \"200AE813-FB83-49E5-BED1-E18436ECB35A\",\n" +
"\t\t\"PLAN_KEY_ID\": \"4874f602-83a2-4e9c-a05f-da1cad9a0427\",\n" +
"\t\t\"PLAN_NAME\": \"弱电间保养计划\",\n" +
"\t\t\"RECORD_NO\": \"WXBY-181016-165809-3203\",\n" +
"\t\t\"REOAIRMAN\": \"杜建男\",\n" +
"\t\t\"MAINTENANCE_DATE\": \"2018-10-02\",\n" +
"\t\t\"BUILD_CABIN\": \",D\",\n" +
"\t\t\"PROJECT\": \"CBL\",\n" +
"\t\t\"CREATEDATE\": \"2018-10-11\",\n" +
"\t\t\"CREATOR\": \"system\",\n" +
"\t\t\"rowNum\": 9\n" +
"\t}, {\n" +
"\t\t\"FINISH\": 0,\n" +
"\t\t\"KEY_ID\": \"1EE38C22-7DD4-43B7-882E-F8A11118B839\",\n" +
"\t\t\"PLAN_KEY_ID\": \"57dadeeb-8e71-40ef-a2ba-f990771c40fd\",\n" +
"\t\t\"PLAN_NAME\": \"潜水泵及潜水泵控制柜\",\n" +
"\t\t\"RECORD_NO\": \"WXBY-180910-145450-4697\",\n" +
"\t\t\"REOAIRMAN\": \"zhangronghua\",\n" +
"\t\t\"MAINTENANCE_DATE\": \"2018-01-02\",\n" +
"\t\t\"BUILD_CABIN\": \",D,P,Q,R,S\",\n" +
"\t\t\"PROJECT\": \"CBL\",\n" +
"\t\t\"CREATEDATE\": \"2018-09-10\",\n" +
"\t\t\"CREATOR\": \"wuping\",\n" +
"\t\t\"rowNum\": 10\n" +
"\t}]\n" +
"}";
PgMaintanceDao pgMaintanceDao=new PgMaintanceDaoImpl();
new ReadMaintanceTask().insertDB(pgMaintanceDao,jsonStr);
}
}
