package com.szpg.db.test;
import com.szpg.db.dao.PgAssetInSpectionDao;
import com.szpg.db.dao.impl.PgAssetInSpectionImpl;
import com.szpg.task.ReadAssetInSpectionTask;
import org.junit.Test;
public class ReadAssetInSpectionTaskTest {
@Test
public void insertDB() {
String jsonStr="{\n" +
"\t\"total\": 333,\n" +
"\t\"totalRecords\": 3321,\n" +
"\t\"page\": 1,\n" +
"\t\"records\": 10,\n" +
"\t\"rows\": [{\n" +
"\t\t\"problems\": 1,\n" +
"\t\t\"finish\": 0,\n" +
"\t\t\"KEY_ID\": \"6B1BA2FD-A835-439E-9EC3-B268FB02DE06\",\n" +
"\t\t\"PLAN_ID\": \"a28285cd-c023-4caf-81e5-3d186fcf5898\",\n" +
"\t\t\"CREATE_DATE\": \"2018-03-05\",\n" +
"\t\t\"STATE\": null,\n" +
"\t\t\"CREATOR\": \"wangrui\",\n" +
"\t\t\"PLAN_NAME\": \"一标燃气舱巡检\",\n" +
"\t\t\"RECORD_NO\": \"XR_180305_888\",\n" +
"\t\t\"PLAN_NO\": null,\n" +
"\t\t\"RESPONSIBLE_DEPT\": null,\n" +
"\t\t\"INSPECTION_PERSON\": null,\n" +
"\t\t\"PATROL_MAN\": \"wangrui\",\n" +
"\t\t\"OPERATE_DATE\": \"2018-03-05\",\n" +
"\t\t\"REMARK\": null,\n" +
"\t\t\"BUILD_CABIN\": null,\n" +
"\t\t\"PROJECT\": null,\n" +
"\t\t\"START_PILE_NO\": null,\n" +
"\t\t\"END_PILE_NO\": null,\n" +
"\t\t\"INSPECTION_PRACE\": null,\n" +
"\t\t\"OTHER_PATROL_MAN\": null,\n" +
"\t\t\"rowNum\": 1\n" +
"\t}, {\n" +
"\t\t\"problems\": 0,\n" +
"\t\t\"finish\": 0,\n" +
"\t\t\"KEY_ID\": \"A5254143-BE91-4284-AB2A-1B8BD88EACE3\",\n" +
"\t\t\"PLAN_ID\": \"a28285cd-c023-4caf-81e5-3d186fcf5898\",\n" +
"\t\t\"CREATE_DATE\": \"2018-03-05\",\n" +
"\t\t\"STATE\": null,\n" +
"\t\t\"CREATOR\": \"sunchenglei\",\n" +
"\t\t\"PLAN_NAME\": \"一标燃气舱巡检\",\n" +
"\t\t\"RECORD_NO\": \"XR_180305_334\",\n" +
"\t\t\"PLAN_NO\": null,\n" +
"\t\t\"RESPONSIBLE_DEPT\": null,\n" +
"\t\t\"INSPECTION_PERSON\": null,\n" +
"\t\t\"PATROL_MAN\": \"wangrui\",\n" +
"\t\t\"OPERATE_DATE\": \"2018-03-05\",\n" +
"\t\t\"REMARK\": null,\n" +
"\t\t\"BUILD_CABIN\": null,\n" +
"\t\t\"PROJECT\": null,\n" +
"\t\t\"START_PILE_NO\": null,\n" +
"\t\t\"END_PILE_NO\": null,\n" +
"\t\t\"INSPECTION_PRACE\": null,\n" +
"\t\t\"OTHER_PATROL_MAN\": null,\n" +
"\t\t\"rowNum\": 2\n" +
"\t}, {\n" +
"\t\t\"problems\": 0,\n" +
"\t\t\"finish\": 0,\n" +
"\t\t\"KEY_ID\": \"ceb11e1c-6565-4423-ab80-3713f7a1813e\",\n" +
"\t\t\"PLAN_ID\": \"\",\n" +
"\t\t\"CREATE_DATE\": \"2018-06-15\",\n" +
"\t\t\"STATE\": 0,\n" +
"\t\t\"CREATOR\": \"admin\",\n" +
"\t\t\"PLAN_NAME\": null,\n" +
"\t\t\"RECORD_NO\": \"XR_180615_889\",\n" +
"\t\t\"PLAN_NO\": null,\n" +
"\t\t\"RESPONSIBLE_DEPT\": null,\n" +
"\t\t\"INSPECTION_PERSON\": null,\n" +
"\t\t\"PATROL_MAN\": \"zousheng\",\n" +
"\t\t\"OPERATE_DATE\": \"2018-06-15\",\n" +
"\t\t\"REMARK\": null,\n" +
"\t\t\"BUILD_CABIN\": \"R\",\n" +
"\t\t\"PROJECT\": null,\n" +
"\t\t\"START_PILE_NO\": null,\n" +
"\t\t\"END_PILE_NO\": null,\n" +
"\t\t\"INSPECTION_PRACE\": null,\n" +
"\t\t\"OTHER_PATROL_MAN\": null,\n" +
"\t\t\"rowNum\": 3\n" +
"\t}, {\n" +
"\t\t\"problems\": 0,\n" +
"\t\t\"finish\": 0,\n" +
"\t\t\"KEY_ID\": \"02D994A2-9466-4E77-8026-EAECFAB7DA4C\",\n" +
"\t\t\"PLAN_ID\": \"feea9e81-fe9a-4b73-b528-4b7a09381b68\",\n" +
"\t\t\"CREATE_DATE\": \"2018-07-29\",\n" +
"\t\t\"STATE\": 0,\n" +
"\t\t\"CREATOR\": \"system\",\n" +
"\t\t\"PLAN_NAME\": \"吴中太湖新城内部巡检计划-一期\",\n" +
"\t\t\"RECORD_NO\": \"XR_180729_004\",\n" +
"\t\t\"PLAN_NO\": null,\n" +
"\t\t\"RESPONSIBLE_DEPT\": null,\n" +
"\t\t\"INSPECTION_PERSON\": null,\n" +
"\t\t\"PATROL_MAN\": \"wudong\",\n" +
"\t\t\"OPERATE_DATE\": \"2018-07-29\",\n" +
"\t\t\"REMARK\": \"\",\n" +
"\t\t\"BUILD_CABIN\": \"\",\n" +
"\t\t\"PROJECT\": \"THXC\",\n" +
"\t\t\"START_PILE_NO\": null,\n" +
"\t\t\"END_PILE_NO\": null,\n" +
"\t\t\"INSPECTION_PRACE\": null,\n" +
"\t\t\"OTHER_PATROL_MAN\": \"wangshen-王申,\",\n" +
"\t\t\"rowNum\": 4\n" +
"\t}, {\n" +
"\t\t\"problems\": 0,\n" +
"\t\t\"finish\": 0,\n" +
"\t\t\"KEY_ID\": \"DB57F8D2-077C-4DC1-90E4-B8DF8F637CD4\",\n" +
"\t\t\"PLAN_ID\": \"feea9e81-fe9a-4b73-b528-4b7a09381b68\",\n" +
"\t\t\"CREATE_DATE\": \"2018-07-30\",\n" +
"\t\t\"STATE\": 0,\n" +
"\t\t\"CREATOR\": \"system\",\n" +
"\t\t\"PLAN_NAME\": \"吴中太湖新城内部巡检计划-一期\",\n" +
"\t\t\"RECORD_NO\": \"XR_180730_002\",\n" +
"\t\t\"PLAN_NO\": null,\n" +
"\t\t\"RESPONSIBLE_DEPT\": null,\n" +
"\t\t\"INSPECTION_PERSON\": null,\n" +
"\t\t\"PATROL_MAN\": \"liangqingsong\",\n" +
"\t\t\"OPERATE_DATE\": \"2018-07-30\",\n" +
"\t\t\"REMARK\": \"\",\n" +
"\t\t\"BUILD_CABIN\": \",D,R,Z\",\n" +
"\t\t\"PROJECT\": \"THXC\",\n" +
"\t\t\"START_PILE_NO\": null,\n" +
"\t\t\"END_PILE_NO\": null,\n" +
"\t\t\"INSPECTION_PRACE\": null,\n" +
"\t\t\"OTHER_PATROL_MAN\": \"tianyun-田云,\",\n" +
"\t\t\"rowNum\": 5\n" +
"\t}, {\n" +
"\t\t\"problems\": 0,\n" +
"\t\t\"finish\": 0,\n" +
"\t\t\"KEY_ID\": \"f1701fc9-9e7a-4155-bff3-cf6b106f484b\",\n" +
"\t\t\"PLAN_ID\": \"87daf7b1-336f-4b41-9684-b0d6436255df\",\n" +
"\t\t\"CREATE_DATE\": \"2018-06-15\",\n" +
"\t\t\"STATE\": 0,\n" +
"\t\t\"CREATOR\": \"sundoudou\",\n" +
"\t\t\"PLAN_NAME\": \"日常巡检\",\n" +
"\t\t\"RECORD_NO\": \"XR_180615_604\",\n" +
"\t\t\"PLAN_NO\": null,\n" +
"\t\t\"RESPONSIBLE_DEPT\": null,\n" +
"\t\t\"INSPECTION_PERSON\": null,\n" +
"\t\t\"PATROL_MAN\": \"zousheng\",\n" +
"\t\t\"OPERATE_DATE\": \"2018-06-15\",\n" +
"\t\t\"REMARK\": null,\n" +
"\t\t\"BUILD_CABIN\": \"R\",\n" +
"\t\t\"PROJECT\": null,\n" +
"\t\t\"START_PILE_NO\": null,\n" +
"\t\t\"END_PILE_NO\": null,\n" +
"\t\t\"INSPECTION_PRACE\": null,\n" +
"\t\t\"OTHER_PATROL_MAN\": null,\n" +
"\t\t\"rowNum\": 6\n" +
"\t}, {\n" +
"\t\t\"problems\": 0,\n" +
"\t\t\"finish\": 0,\n" +
"\t\t\"KEY_ID\": \"f793de99-c58d-4787-b489-863320e78924\",\n" +
"\t\t\"PLAN_ID\": \"054bce38-374a-45b6-ade3-cfc1e44846b7\",\n" +
"\t\t\"CREATE_DATE\": \"2018-05-24\",\n" +
"\t\t\"STATE\": 0,\n" +
"\t\t\"CREATOR\": \"admin\",\n" +
"\t\t\"PLAN_NAME\": \"风机启动数量点检\",\n" +
"\t\t\"RECORD_NO\": \"XR_180524_666\",\n" +
"\t\t\"PLAN_NO\": null,\n" +
"\t\t\"RESPONSIBLE_DEPT\": null,\n" +
"\t\t\"INSPECTION_PERSON\": null,\n" +
"\t\t\"PATROL_MAN\": \"baiwenzhong\",\n" +
"\t\t\"OPERATE_DATE\": \"2018-05-24\",\n" +
"\t\t\"REMARK\": null,\n" +
"\t\t\"BUILD_CABIN\": null,\n" +
"\t\t\"PROJECT\": null,\n" +
"\t\t\"START_PILE_NO\": null,\n" +
"\t\t\"END_PILE_NO\": null,\n" +
"\t\t\"INSPECTION_PRACE\": null,\n" +
"\t\t\"OTHER_PATROL_MAN\": null,\n" +
"\t\t\"rowNum\": 7\n" +
"\t}, {\n" +
"\t\t\"problems\": 2,\n" +
"\t\t\"finish\": 0,\n" +
"\t\t\"KEY_ID\": \"457C0017-5F6B-4026-96D3-9BA439723AA5\",\n" +
"\t\t\"PLAN_ID\": \"1d1800d5-0050-4d38-846e-67d81e337387\",\n" +
"\t\t\"CREATE_DATE\": \"2018-03-13\",\n" +
"\t\t\"STATE\": null,\n" +
"\t\t\"CREATOR\": \"wangrui\",\n" +
"\t\t\"PLAN_NAME\": \"四五标施工进度巡查\",\n" +
"\t\t\"RECORD_NO\": \"XR_180313_130\",\n" +
"\t\t\"PLAN_NO\": null,\n" +
"\t\t\"RESPONSIBLE_DEPT\": null,\n" +
"\t\t\"INSPECTION_PERSON\": null,\n" +
"\t\t\"PATROL_MAN\": \" dujiannan\",\n" +
"\t\t\"OPERATE_DATE\": \"2018-03-13\",\n" +
"\t\t\"REMARK\": null,\n" +
"\t\t\"BUILD_CABIN\": null,\n" +
"\t\t\"PROJECT\": null,\n" +
"\t\t\"START_PILE_NO\": null,\n" +
"\t\t\"END_PILE_NO\": null,\n" +
"\t\t\"INSPECTION_PRACE\": null,\n" +
"\t\t\"OTHER_PATROL_MAN\": null,\n" +
"\t\t\"rowNum\": 8\n" +
"\t}, {\n" +
"\t\t\"problems\": 0,\n" +
"\t\t\"finish\": 0,\n" +
"\t\t\"KEY_ID\": \"AA605983-6F73-41F0-B1FA-FDA2565F15F4\",\n" +
"\t\t\"PLAN_ID\": \"feea9e81-fe9a-4b73-b528-4b7a09381b68\",\n" +
"\t\t\"CREATE_DATE\": \"2018-07-27\",\n" +
"\t\t\"STATE\": 0,\n" +
"\t\t\"CREATOR\": \"system\",\n" +
"\t\t\"PLAN_NAME\": \"吴中太湖新城内部巡检计划-一期\",\n" +
"\t\t\"RECORD_NO\": \"XR_180727_005\",\n" +
"\t\t\"PLAN_NO\": null,\n" +
"\t\t\"RESPONSIBLE_DEPT\": null,\n" +
"\t\t\"INSPECTION_PERSON\": null,\n" +
"\t\t\"PATROL_MAN\": \"wudong\",\n" +
"\t\t\"OPERATE_DATE\": \"2018-07-27\",\n" +
"\t\t\"REMARK\": \"\",\n" +
"\t\t\"BUILD_CABIN\": \"\",\n" +
"\t\t\"PROJECT\": \"THXC\",\n" +
"\t\t\"START_PILE_NO\": null,\n" +
"\t\t\"END_PILE_NO\": null,\n" +
"\t\t\"INSPECTION_PRACE\": null,\n" +
"\t\t\"OTHER_PATROL_MAN\": \"luxingxing-陆杏兴, \",\n" +
"\t\t\"rowNum\": 9\n" +
"\t}, {\n" +
"\t\t\"problems\": 0,\n" +
"\t\t\"finish\": 0,\n" +
"\t\t\"KEY_ID\": \"AB88779D-02D6-4419-AD0A-147DEE3EC18F\",\n" +
"\t\t\"PLAN_ID\": \"feea9e81-fe9a-4b73-b528-4b7a09381b68\",\n" +
"\t\t\"CREATE_DATE\": \"2018-07-25\",\n" +
"\t\t\"STATE\": 0,\n" +
"\t\t\"CREATOR\": \"system\",\n" +
"\t\t\"PLAN_NAME\": \"吴中太湖新城内部巡检计划-一期\",\n" +
"\t\t\"RECORD_NO\": \"XR_180725_006\",\n" +
"\t\t\"PLAN_NO\": null,\n" +
"\t\t\"RESPONSIBLE_DEPT\": null,\n" +
"\t\t\"INSPECTION_PERSON\": null,\n" +
"\t\t\"PATROL_MAN\": \"caoshixiang\",\n" +
"\t\t\"OPERATE_DATE\": \"2018-07-25\",\n" +
"\t\t\"REMARK\": \"\",\n" +
"\t\t\"BUILD_CABIN\": \"\",\n" +
"\t\t\"PROJECT\": \"THXC\",\n" +
"\t\t\"START_PILE_NO\": null,\n" +
"\t\t\"END_PILE_NO\": null,\n" +
"\t\t\"INSPECTION_PRACE\": null,\n" +
"\t\t\"OTHER_PATROL_MAN\": \"liangcang-梁仓, \",\n" +
"\t\t\"rowNum\": 10\n" +
"\t}]\n" +
"}";
PgAssetInSpectionDao pgAssetInSpectionDao=new PgAssetInSpectionImpl();
new ReadAssetInSpectionTask().insertDB(pgAssetInSpectionDao,jsonStr);
}
}
