From 3544607c8535ce60e3d85c35c4ca6015c19acab4 Mon Sep 17 00:00:00 2001
From: pansen <pansen626@sina.com>
Date: 星期四, 20 十二月 2018 16:15:46 +0800
Subject: [PATCH] change data
---
oldDataChange2NewData/data.json | 1
oldDataChange2NewData/yfd5x.db | 0
oldDataChange2NewData/main.cpp | 45 ++++++++++++++++++++++
oldDataChange2NewData/CMakeLists.txt | 25 ++++++++++++
4 files changed, 71 insertions(+), 0 deletions(-)
diff --git a/oldDataChange2NewData/CMakeLists.txt b/oldDataChange2NewData/CMakeLists.txt
new file mode 100644
index 0000000..880a9ff
--- /dev/null
+++ b/oldDataChange2NewData/CMakeLists.txt
@@ -0,0 +1,25 @@
+cmake_minimum_required(VERSION 3.13)
+project(oldDataChange2NewData)
+
+set(CMAKE_CXX_STANDARD 14)
+
+include_directories(
+
+ ../../BasicPlatForm/libs/jsoncpp/include
+)
+
+link_directories(
+
+ ../../BasicPlatForm/libs/jsoncpp/lib
+)
+
+add_executable(oldDataChange2NewData
+ main.cpp)
+
+
+target_link_libraries(
+ oldDataChange2NewData
+
+ jsoncpp
+ pthread
+)
\ No newline at end of file
diff --git a/oldDataChange2NewData/data.json b/oldDataChange2NewData/data.json
new file mode 100644
index 0000000..07a667a
--- /dev/null
+++ b/oldDataChange2NewData/data.json
@@ -0,0 +1 @@
+[{ "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"}]
\ No newline at end of file
diff --git a/oldDataChange2NewData/main.cpp b/oldDataChange2NewData/main.cpp
new file mode 100644
index 0000000..d1a8b4c
--- /dev/null
+++ b/oldDataChange2NewData/main.cpp
@@ -0,0 +1,45 @@
+#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;
+}
\ No newline at end of file
diff --git a/oldDataChange2NewData/yfd5x.db b/oldDataChange2NewData/yfd5x.db
new file mode 100644
index 0000000..8791b8f
--- /dev/null
+++ b/oldDataChange2NewData/yfd5x.db
Binary files differ
--
Gitblit v1.8.0