#include <iostream>
#include <unistd.h>
#include <sys/time.h>
//#include <ofstream>

#include <jsoncpp/json/json.h>
#include <fstream>

using std::string;
using std::ofstream;

int main() {
    std::cout << "Hello, World!" << std::endl;

    string str_json = "[{ \"uuid\":\"019214b7-8598-5617-b3a4-ef2ab9f0e8d4\",\"tableName\":\"教职工\",\"idcard\":\"步兵\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb2aAFO_AAC3-zq6Hikw524.jpg\"},{ \"uuid\":\"057eb8fe-79da-5326-a8d0-fe8abcf138c2\",\"tableName\":\"教职工\",\"idcard\":\"刘丽\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3WAU9geAC9JcCYMf14783.jpg\"},{ \"uuid\":\"0f4743f3-b928-598a-86e2-c75171c3fc86\",\"tableName\":\"教职工\",\"idcard\":\"马春红\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb3mAX2HCAC5Vs2yTxc8396.jpg\"},{ \"uuid\":\"141e442e-4f1e-5c23-a8d9-668abfb5b3a8\",\"tableName\":\"教职工\",\"idcard\":\"肖凤英\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4CAW2gVADYei0kHzg8393.jpg\"},{ \"uuid\":\"1608b07f-b329-54c3-9c36-cf7ed594f3fa\",\"tableName\":\"教职工\",\"idcard\":\"刘冬梅\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3WAcHXbAC87HduLi18525.jpg\"},{ \"uuid\":\"1644e49e-d515-577c-91f3-4a6b04448c7c\",\"tableName\":\"教职工\",\"idcard\":\"孙燕\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb3uALDBtACyQ0Rt8i90344.jpg\"},{ \"uuid\":\"17a6ec84-6945-5922-8670-51fb3a3be926\",\"tableName\":\"教职工\",\"idcard\":\"赵虹\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4eAVkC5ACtQ6MTm-W4012.jpg\"},{ \"uuid\":\"17d96be0-c006-56bb-b5cd-c399cc30df37\",\"tableName\":\"教职工\",\"idcard\":\"刘颖红\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3aAXy7TACvaS-qotcE467.jpg\"},{ \"uuid\":\"1ba1e56c-0c8b-5e45-9d26-0950cd830690\",\"tableName\":\"教职工\",\"idcard\":\"马惠青\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb3qANlVmAC4CPQd9dyw520.jpg\"},{ \"uuid\":\"1baae7de-b586-5af8-a833-c8e6cc5375c7\",\"tableName\":\"教职工\",\"idcard\":\"蔡颢\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb2eAWjuPAChVbR69_xs534.jpg\"},{ \"uuid\":\"20a1f4d0-1597-58d3-84e7-2b338b3d47af\",\"tableName\":\"教职工\",\"idcard\":\"栾早霞\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3eAPE22ACyS1orEk8I609.jpg\"},{ \"uuid\":\"20b411ae-7cd8-5308-90f2-945a4fe1308f\",\"tableName\":\"教职工\",\"idcard\":\"李微\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3KADFbSAC0DqYBlp5E161.jpg\"},{ \"uuid\":\"2593b8ae-5b53-5e48-9566-68edb102b446\",\"tableName\":\"教职工\",\"idcard\":\"马旭霞\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb3qAT_R0ADBzGC80Ej0096.jpg\"},{ \"uuid\":\"2d77948c-5059-57cd-9cea-de06ad5aacad\",\"tableName\":\"教职工\",\"idcard\":\"李文强\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3OAaoLqAC2dkDZ5-08912.jpg\"},{ \"uuid\":\"2f6b2ac1-4acf-58c9-a5d1-47bbde9795fa\",\"tableName\":\"教职工\",\"idcard\":\"王冬未\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb3yAK_NVAClDWYippug021.jpg\"},{ \"uuid\":\"2f6f1bd1-1069-56fd-9a67-2bb1ad78c881\",\"tableName\":\"教职工\",\"idcard\":\"许伟\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4GASwTCAChzomgA788141.jpg\"},{ \"uuid\":\"35a3cf8b-f699-53c2-9866-c5241e89fc6a\",\"tableName\":\"教职工\",\"idcard\":\"高琳\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb2yAB4mIACqHrPiF-ao294.jpg\"},{ \"uuid\":\"371fd812-6ba5-5a42-8076-cfb568503385\",\"tableName\":\"教职工\",\"idcard\":\"王利辉\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb3yAfmsgAC9qGDwy0m8630.jpg\"},{ \"uuid\":\"3f635a73-6838-5b54-8e3f-4a11033b8127\",\"tableName\":\"教职工\",\"idcard\":\"田春梅\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb3uAOOoGACqMBflR8Yw973.jpg\"},{ \"uuid\":\"3f75f507-72eb-5212-89cc-877bb343b0ea\",\"tableName\":\"教职工\",\"idcard\":\"李慧欣\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3KAXN91AC0fcrW_aQY758.jpg\"},{ \"uuid\":\"45eafe29-8652-5a6f-afa0-095136e120de\",\"tableName\":\"教职工\",\"idcard\":\"张玮\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4aAPuS7ACobPgSltik724.jpg\"},{ \"uuid\":\"465e7af0-9490-5093-b03a-cf8ea85b33d9\",\"tableName\":\"教职工\",\"idcard\":\"张蕊\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4WAD6Q0ACr0AD-IATk995.jpg\"},{ \"uuid\":\"465fd4c2-f124-5959-8cdc-f32ad80ff988\",\"tableName\":\"教职工\",\"idcard\":\"张天华\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4aAO3Z6AClA8wxdjbc456.jpg\"},{ \"uuid\":\"4a9badc4-64da-535c-9b98-61690f1c86cf\",\"tableName\":\"教职工\",\"idcard\":\"付永清\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb2qATk-bACxfHoEvRdk822.jpg\"},{ \"uuid\":\"4d901c3f-e7c1-5f2b-abc8-4fc30f96ecba\",\"tableName\":\"教职工\",\"idcard\":\"高亚胜\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb2yAaazxAChh8BWBjTA046.jpg\"},{ \"uuid\":\"5b5b86cd-beb4-55dc-9937-b17f8c1da22f\",\"tableName\":\"教职工\",\"idcard\":\"樊京晶\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb2qAQ6-cADqDRJYvo10137.jpg\"},{ \"uuid\":\"5e2cba3e-ccf4-5948-8627-70d889b6075e\",\"tableName\":\"教职工\",\"idcard\":\"周春\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQcvyAWZpNACpTCtyx7k4115.jpg\"},{ \"uuid\":\"65e27065-33ae-5fb4-aa6e-33dd5a4f059d\",\"tableName\":\"教职工\",\"idcard\":\"赵丽梅\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4iAJxzsACv9QaMY2lk615.jpg\"},{ \"uuid\":\"728f95fa-eeae-58ab-8676-00c0cccc8be2\",\"tableName\":\"教职工\",\"idcard\":\"瓮越红\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb3-AalphAC5vr-TPkfQ780.jpg\"},{ \"uuid\":\"73e883d7-8b0c-5f00-ab29-87850754f5b4\",\"tableName\":\"教职工\",\"idcard\":\"吕崑\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3eATRGgAChP0r38aOw357.jpg\"},{ \"uuid\":\"7ce76414-da91-5aef-bf61-4402c7a89fcb\",\"tableName\":\"教职工\",\"idcard\":\"黄银晶\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb2-AY3xXACl0z_VxCe8861.jpg\"},{ \"uuid\":\"8813b473-f977-5f5e-a095-544f5a123636\",\"tableName\":\"教职工\",\"idcard\":\"吕琳\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3iABujXACvQj_TsVQI574.jpg\"},{ \"uuid\":\"8d66b791-b307-5f51-99c0-c6c656707ae3\",\"tableName\":\"教职工\",\"idcard\":\"陈颜\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb2eAahjgAC7AULKXFqM124.jpg\"},{ \"uuid\":\"8d8a11dc-73ea-5e1e-b61c-ce44c1493a3f\",\"tableName\":\"教职工\",\"idcard\":\"张继红\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4WAV6dwACz1BCse8f8456.jpg\"},{ \"uuid\":\"92cbb7c2-ab32-5033-9ddf-9badba09f938\",\"tableName\":\"教职工\",\"idcard\":\"杨眉\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4SARKxwACkHeF8FIy4856.jpg\"},{ \"uuid\":\"965e7e7d-7cd9-5624-8c35-e1ea894fd7ff\",\"tableName\":\"教职工\",\"idcard\":\"吕迎\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3iAZKDqADLmjGoObss417.jpg\"},{ \"uuid\":\"974f89ee-3645-51df-8273-9ac746223fe8\",\"tableName\":\"教职工\",\"idcard\":\"严淑敏\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4OACwbuAC8FMm2RnLk775.jpg\"},{ \"uuid\":\"991e199e-9848-5b3d-84dc-cba7f26e6491\",\"tableName\":\"教职工\",\"idcard\":\"肖爱萍\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4CADKauACxobp3809Y351.jpg\"},{ \"uuid\":\"99276d4c-9c88-59b2-be56-6d1d44128cbd\",\"tableName\":\"教职工\",\"idcard\":\"韩建业\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb26ALwh5ACn00TaAsKM327.jpg\"},{ \"uuid\":\"996fb7c6-3735-58d2-9e60-3f34796fef73\",\"tableName\":\"教职工\",\"idcard\":\"韩静\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb26AGp4PAC4b6NjqwhQ476.jpg\"},{ \"uuid\":\"9b3b8b08-5173-5f72-8d4c-76529d6ee96c\",\"tableName\":\"教职工\",\"idcard\":\"张妍\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4eAMpaEAC1hThzq00c192.jpg\"},{ \"uuid\":\"9e74d885-7bbe-54fc-b798-b635387c7c16\",\"tableName\":\"教职工\",\"idcard\":\"刘冬\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3SAErs6ACrwF7dOuHI617.jpg\"},{ \"uuid\":\"a2130dfc-0425-5665-942c-a4f5781ad53e\",\"tableName\":\"教职工\",\"idcard\":\"傅龙\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb2uAaPoWADf0eGwC_ds201.jpg\"},{ \"uuid\":\"a529873b-e0a9-5b9f-9a59-4c581fa1f037\",\"tableName\":\"教职工\",\"idcard\":\"闫峰\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4KAUYpcAC118CPcQuw408.jpg\"},{ \"uuid\":\"a953cf74-7302-5e47-b80a-6440fb2abea2\",\"tableName\":\"教职工\",\"idcard\":\"魏海凤\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb36Acd7LACjkNyNneDU100.jpg\"},{ \"uuid\":\"ac88fef8-00b4-55d2-adde-15b67f655d58\",\"tableName\":\"教职工\",\"idcard\":\"尹丽莉\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4SAeyBHADKcfCe7gm0417.jpg\"},{ \"uuid\":\"c30eac93-e357-551a-8718-c890fa309010\",\"tableName\":\"教职工\",\"idcard\":\"王月山\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb32AOOE2ADcDKAqeBBg887.jpg\"},{ \"uuid\":\"cab891a1-f701-526f-aa60-2a67e9310bb6\",\"tableName\":\"教职工\",\"idcard\":\"梁静\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3OAaj5qACy-XfZRGNw416.jpg\"},{ \"uuid\":\"cac30278-c08d-5374-b976-35ff463d6be9\",\"tableName\":\"教职工\",\"idcard\":\"边蕊\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb12AbwG_ACdYOES1C5c267.jpg\"},{ \"uuid\":\"d2ea3b37-4b6f-5fdc-b1e9-3a3e003fbc7e\",\"tableName\":\"教职工\",\"idcard\":\"边玉梅\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb2WAP9l4ACfUpa5h5RQ338.jpg\"},{ \"uuid\":\"d5c195b8-6c6f-5033-8f1c-263ec0ddef95\",\"tableName\":\"教职工\",\"idcard\":\"高燕萍\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb22AQbX8AC2bfoRZCyk586.jpg\"},{ \"uuid\":\"dbadadda-6081-5b1f-8721-eccab4b9a9b9\",\"tableName\":\"教职工\",\"idcard\":\"程立\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb2mAJqJ0ADBzs5ykRI8329.jpg\"},{ \"uuid\":\"dfa128b7-a021-504d-9846-4bc050a76ce6\",\"tableName\":\"教职工\",\"idcard\":\"路淼\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3eAZG73AC0ESHlwEE0013.jpg\"},{ \"uuid\":\"e7d628e3-84f8-5249-97ea-91d792c1b4f7\",\"tableName\":\"教职工\",\"idcard\":\"张晓琛\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4aAexOeACgD-f4Xui4796.jpg\"},{ \"uuid\":\"ea5ac956-2004-550a-9fd4-30aa8168cd37\",\"tableName\":\"教职工\",\"idcard\":\"程京丽\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb2iAHhLzACsB89k4ozo322.jpg\"},{ \"uuid\":\"f1c1e977-13d2-5436-9f4d-9f36f135cf3a\",\"tableName\":\"教职工\",\"idcard\":\"金建勇\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb2-ANA6lACkuaqS0IfA627.jpg\"},{ \"uuid\":\"f3c9ed06-d538-5e91-8499-154c326596d8\",\"tableName\":\"教职工\",\"idcard\":\"闫丽琳\",\"imgUrl\":\"group1/M00/00/06/rBAy9FwQb4KATS8_ADtNHv2T4WI835.jpg\"},{ \"uuid\":\"f927b68f-deb8-5ae9-bf14-af7abeb03889\",\"tableName\":\"教职工\",\"idcard\":\"李会平\",\"imgUrl\":\"group1/M00/00/05/rBAy9FwQb3CAfDyZADAs7G04OxQ682.jpg\"}]";

    Json::Value t_json;
    Json::Reader reader;

    if (!reader.parse(str_json, t_json)) {
//        ERR("json format error :: " << str_json);
        return -1;
    }

    ofstream out("out.txt");
    for (auto &item : t_json) {

        string struuid = item["uuid"].asString();
        string faceUrlT = item["imgUrl"].asString();
        string nameT = item["idcard"].asString();

        string stringSql =
            "update \"0cd82a8b-5285-5737-ab19-8c07247c797e_fea\" set uuid    = '" + struuid + "',    faceUrl = '" +
            faceUrlT + "' where uuid = (select a.uuid from \"0cd82a8b-5285-5737-ab19-8c07247c797e\" as a "
                       "left join \"0cd82a8b-5285-5737-ab19-8c07247c797e_fea\" as b on a.uuid = b.uuid"
                       " where a.idCard = '" + nameT +
            "'); update \"0cd82a8b-5285-5737-ab19-8c07247c797e\" set uuid='" +
            struuid + "' where idCard = '" + nameT + "';";
        out << stringSql << "\n";
    }
    out.close();


    return 0;
}