这是一组数据,你主要看编码和id的对应关系(A表):17 一次风机A primary_air_fan_A
18 一次风机B primary_air_fan_B
19 主汽轮机 main_steam_turbine
20 凝结水泵A condensate_pump_A
21 凝结水泵B condensate_pump_B
22 引风机A induced_draft_fan_A
23 引风机B induced_draft_fan_B
24 磨煤机A coal_mill_A
25 磨煤机B coal_mill_B
26 磨煤机C coal_mill_C
27 磨煤D coal_mill_D
28 磨煤机E coal_mill_E
29 磨煤机F coal_mill_F
30 给水泵A feed_pump_turbine_A
31 给水泵B feed_pump_turbine_B
32 送风机A forced_draught_blower_A
33 送风机B forced_draught_blower_B下面这个你需要看两个id之间的对应关系(B表,前面一个是新id,后面的是上面的id):148 32
217 18
218 19
219 20
220 21
221 22
222 17
223 23
224 24
225 25
226 26
227 27
228 28
229 29
230 30
231 31
232 33。下面是目标表C的SQL:CREATE TABLE "JNPF_INIT"."BIZ_MEASURE_POINT"
(
"ID" BIGINT IDENTITY(21, 1) NOT NULL,
"MEASURE_POINT_NAME" VARCHAR(100) NOT NULL,
"MEASURE_POINT_KEY" VARCHAR(50) NOT NULL,
"SID" BIGINT NOT NULL,
"ATTRIBUTE_TYPE_ID" VARCHAR(50),
"MEASURE_POINT_TYPE_ID" VARCHAR(50),
"UNIT_NAME" VARCHAR(10),
"LIMIT_TYPE" INT DEFAULT 0 NOT NULL,
"UPPER_LIMIT" REAL,
"LOWER_LIMIT" REAL,
"FIELD_NAME" VARCHAR(50),
"CREATED_AT" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL,
"UPDATED_AT" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL,
"DELETED_AT" TIMESTAMP(0),
"F_TENANT_ID" VARCHAR(50) NOT NULL,
"F_FLOW_ID" VARCHAR(50),
"F_FLOW_TASK_ID" VARCHAR(50),
NOT CLUSTER PRIMARY KEY("ID"),
CONSTRAINT "MEASURE_POINT_KEY" UNIQUE("MEASURE_POINT_KEY"),
CHECK("SID" >= 0)) STORAGE(ON "MAIN", CLUSTERBTR);。最后是要导入的数据:{"primary_air_fan_A": ["w3_unit1_10hlb30cf001", "w3_unit1_10hla30cp001", "w3_unit1_10hlv30m02ai01", "w3_unit1_10hlv30m01ai01", "w3_unit1_10hlb30m01ai01", "w3_unit1_10hlb30cy012", "w3_unit1_10hlb30cy011", "w3_unit1_10hlb30ct066", "w3_unit1_10hlb30ct065", "w3_unit1_10hlb30ct064", "w3_unit1_10hlb30ct063", "w3_unit1_10hlb30ct062", "w3_unit1_10hlb30ct061", "w3_unit1_10hlb30ct052", "w3_unit1_10hlb30ct051", "w3_unit1_10hlb30ct043", "w3_unit1_10hlb30ct042", "w3_unit1_10hlb30ct041", "w3_unit1_10hlb30ct033", "w3_unit1_10hlb30ct032", "w3_unit1_10hlb30ct031", "w3_unit1_10hlb30ct023", "w3_unit1_10hlb30ct022", "w3_unit1_10hlb30ct021", "w3_unit1_10hlb30ct013", "w3_unit1_10hlb30ct012", "w3_unit1_10hlb30ct011", "w3_unit1_10hla30ct003", "w3_unit1_10hla30ct002", "w3_unit1_10hla30ct001"], "primary_air_fan_B": ["w3_unit1_10hlb40cf001", "w3_unit1_10hla40ct003", "w3_unit1_10hla40ct002", "w3_unit1_10hla40ct001", "w3_unit1_10hla40cp001", "w3_unit1_10hlv40m02ai01", "w3_unit1_10hlv40m01ai01", "w3_unit1_10hlb40m01ai01", "w3_unit1_10hlb40cy012", "w3_unit1_10hlb40cy011", "w3_unit1_10hlb40ct066", "w3_unit1_10hlb40ct065", "w3_unit1_10hlb40ct064", "w3_unit1_10hlb40ct063", "w3_unit1_10hlb40ct062", "w3_unit1_10hlb40ct061", "w3_unit1_10hlb40ct052", "w3_unit1_10hlb40ct051", "w3_unit1_10hlb40ct043", "w3_unit1_10hlb40ct042", "w3_unit1_10hlb40ct041", "w3_unit1_10hlb40ct033", "w3_unit1_10hlb40ct032", "w3_unit1_10hlb40ct031", "w3_unit1_10hlb40ct023", "w3_unit1_10hlb40ct022", "w3_unit1_10hlb40ct021", "w3_unit1_10hlb40ct013", "w3_unit1_10hlb40ct012", "w3_unit1_10hlb40ct011"], "main_steam_turbine": ["w3_unit1_10qjdzj10ct001", "w3_unit1_10qjdzj10cq001", "w3_unit1_10mav74ct032", "w3_unit1_10mav74ct031", "w3_unit1_10max22ct001", "w3_unit1_10max21ct001", "w3_unit1_10max17ct001", "w3_unit1_10mav74ct011", "w3_unit1_10mav74cp038", "w3_unit1_10mav60ct010", "w3_unit1_10mav50ct010", "w3_unit1_10mav40ct010", "w3_unit1_10mav30ct010", "w3_unit1_10mav20ct010", "w3_unit1_10mav10ct010", "w3_unit1_10mav10cp010", "w3_unit1_10mav00ct020", "w3_unit1_10mav00ct010", "w3_unit1_10maa50ct004", "w3_unit1_10maa50ct003", "w3_unit1_10maa50ct002", "w3_unit1_10maa50ct001", "w3_unit1_10cjj31001cra00r", "w3_unit1_10max12m01ai01", "w3_unit1_10mav74m02ai01", "w3_unit1_10mav73m03ai01", "w3_unit1_10xav10m03ai01", "w3_unit1_10xav10m02ai01", "w3_unit1_10max16m02ai01", "w3_unit1_10max16m01ai01", "w3_unit1_10max11m01ai01", "w3_unit1_10mav74m01ai01", "w3_unit1_10mav73m02ai01", "w3_unit1_10mav73m01ai01", "w3_unit1_10mav73ct011", "w3_unit1_10mav73cl001", "w3_unit1_10mav74ct021", "w3_unit1_10mac50ct004", "w3_unit1_10mac50ct003", "w3_unit1_10mac50ct002", "w3_unit1_10mac50ct001"], "condensate_pump_A": ["w3_unit1_10xac20cy042", "w3_unit1_10xac20cy041", "w3_unit1_10lcb11ct014", "w3_unit1_10lcb11ct013", "w3_unit1_10lcb11ct012", "w3_unit1_10lcb11ct011", "w3_unit1_10lcb11ct010", "w3_unit1_10lcp13m01ai01", "w3_unit1_10lcb11m01ai01", "w3_unit1_10lcb11ct009", "w3_unit1_10lcb11ct008", "w3_unit1_10lcb11ct007", "w3_unit1_10lcb11ct006", "w3_unit1_10lcb11ct005", "w3_unit1_10lcb11ct004", "w3_unit1_10lcb11ct003", "w3_unit1_10lcb11ct002", "w3_unit1_10lcb11ct001", "w3_unit1_10lca11cp001", "w3_unit1_10lca20cp001", "w3_unit1_10lca20ct002"], "condensate_pump_B": ["w3_unit1_10xac20cy052", "w3_unit1_10xac20cy051", "w3_unit1_10lcb12ct014", "w3_unit1_10lcb12ct013", "w3_unit1_10lcb12ct012", "w3_unit1_10lcb12ct011", "w3_unit1_10lcb12ct010", "w3_unit1_10lcp12m01ai01", "w3_unit1_10lcb12m01ai01", "w3_unit1_10lcb12ct009", "w3_unit1_10lcb12ct008", "w3_unit1_10lcb12ct007", "w3_unit1_10lcb12ct006", "w3_unit1_10lcb12ct005", "w3_unit1_10lcb12ct004", "w3_unit1_10lcb12ct003", "w3_unit1_10lcb12ct002", "w3_unit1_10lcb12ct001", "w3_unit1_10lca10cp001", "w3_unit1_10lca20cp001", "w3_unit1_10lca20ct002"], "induced_draft_fan_A": ["w3_unit1_10hnc10ct163", "w3_unit1_10hnc10ct162", "w3_unit1_10hnc10ct161", "w3_unit1_10hnv10cp101", "w3_unit1_10hnc10ct102", "w3_unit1_10hnc10ct101", "w3_unit1_10hnc10ct100", "w3_unit1_10hnc10cf001", "w3_unit1_10hna10ct004", "w3_unit1_10hna10cp003", "w3_unit1_10hna10cp002", "w3_unit1_10hnc10m01ai01", "w3_unit1_10hnc10ct017", "w3_unit1_10hnc10ct016", "w3_unit1_10hnc10ct015", "w3_unit1_10hnc10ct014", "w3_unit1_10hnc10ct013", "w3_unit1_10hnc10ct012", "w3_unit1_10hnc10ct011", "w3_unit1_10hnc10ct010", "w3_unit1_10hnc10ct009", "w3_unit1_10hnc10ct008", "w3_unit1_10hnc10ct007", "w3_unit1_10hnc10ct006", "w3_unit1_10hnc10ct005", "w3_unit1_10hnc10ct004", "w3_unit1_10hnc10ct003", "w3_unit1_10hnc10ct002", "w3_unit1_10hnc10ct001", "w3_unit1_10hnc10cg002", "w3_unit1_10hnc10cg001"], "induced_draft_fan_B": ["w3_unit1_10hnc20ct163", "w3_unit1_10hnc20ct162", "w3_unit1_10hnc20ct161", "w3_unit1_10hnc20cp101", "w3_unit1_10hnc20ct102", "w3_unit1_10hnc20ct101", "w3_unit1_10hnc20ct100", "w3_unit1_10hnc20cf001", "w3_unit1_10hna20ct004", "w3_unit1_10hna20cp003", "w3_unit1_10hna20cp002", "w3_unit1_10hnc20m01ai01", "w3_unit1_10hnc20ct017", "w3_unit1_10hnc20ct016", "w3_unit1_10hnc20ct015", "w3_unit1_10hnc20ct014", "w3_unit1_10hnc20ct013", "w3_unit1_10hnc20ct012", "w3_unit1_10hnc20ct011", "w3_unit1_10hnc20ct010", "w3_unit1_10hnc20ct009", "w3_unit1_10hnc20ct008", "w3_unit1_10hnc20ct007", "w3_unit1_10hnc20ct006", "w3_unit1_10hnc20ct005", "w3_unit1_10hnc20ct004", "w3_unit1_10hnc20ct003", "w3_unit1_10hnc20ct002", "w3_unit1_10hnc20ct001", "w3_unit1_10hnc20cg002", "w3_unit1_10hnc20cg001"], "coal_mill_A": ["w3_unit1_10hfc12ct016", "w3_unit1_10hfc10ct022", "w3_unit1_10hfc10ct021", "w3_unit1_10hfc10cp011", "w3_unit1_10hfc10cp001", "w3_unit1_10hfv12ct011", "w3_unit1_10hfv12cp011", "w3_unit1_10hfv11ct001", "w3_unit1_10hfe10cp002", "w3_unit1_10hfc12ct015", "w3_unit1_10hfc12ct014", "w3_unit1_10hfc12ct013", "w3_unit1_10hfc12ct012", "w3_unit1_10hfc12ct011", "w3_unit1_10hfc10ct036", "w3_unit1_10hfc10ct035", "w3_unit1_10hfc10ct034", "w3_unit1_10hfc10ct033", "w3_unit1_10hfc10ct032", "w3_unit1_10hfc10ct031", "w3_unit1_pri_flow_a", "w3_unit1_10hfe10ct001", "w3_unit1_10hfe10cp001", "w3_unit1_10hfc10ct013", "w3_unit1_10hfc10ct012", "w3_unit1_10hfc10ct011"], "coal_mill_B": ["w3_unit1_10hfc22ct016", "w3_unit1_10hfc20ct022", "w3_unit1_10hfc20ct021", "w3_unit1_10hfc20cp011", "w3_unit1_10hfc20cp001", "w3_unit1_10hfv22ct011", "w3_unit1_10hfv22cp011", "w3_unit1_10hfe20cp002", "w3_unit1_10hfc22ct015", "w3_unit1_10hfc22ct014", "w3_unit1_10hfc22ct013", "w3_unit1_10hfc22ct012", "w3_unit1_10hfc22ct011", "w3_unit1_10hfc20ct036", "w3_unit1_10hfc20ct035", "w3_unit1_10hfc20ct034", "w3_unit1_10hfc20ct033", "w3_unit1_10hfc20ct032", "w3_unit1_10hfc20ct031", "w3_unit1_pri_flow_b", "w3_unit1_10hfe20ct001", "w3_unit1_10hfe20cp001", "w3_unit1_10hfc20ct013", "w3_unit1_10hfc20ct012", "w3_unit1_10hfc20ct011"], "coal_mill_C": ["w3_unit1_10hfc32ct016", "w3_unit1_10hfc30ct022", "w3_unit1_10hfc30ct021", "w3_unit1_10hfc30cp011", "w3_unit1_10hfc30cp001", "w3_unit1_10hfv32ct011", "w3_unit1_10hfv32cp011", "w3_unit1_10hfe30cp002", "w3_unit1_10hfc32ct015", "w3_unit1_10hfc32ct014", "w3_unit1_10hfc32ct013", "w3_unit1_10hfc32ct012", "w3_unit1_10hfc32ct011", "w3_unit1_10hfc30ct036", "w3_unit1_10hfc30ct035", "w3_unit1_10hfc30ct034", "w3_unit1_10hfc30ct033", "w3_unit1_10hfc30ct032", "w3_unit1_10hfc30ct031", "w3_unit1_pri_flow_c", "w3_unit1_10hfe30ct001", "w3_unit1_10hfe30cp001", "w3_unit1_10hfc30ct013", "w3_unit1_10hfc30ct012", "w3_unit1_10hfc30ct011"], "coal_mill_D": ["w3_unit1_10hfc42ct016", "w3_unit1_10hfc40ct022", "w3_unit1_10hfc40ct021", "w3_unit1_10hfc40cp011", "w3_unit1_10hfc40cp001", "w3_unit1_10hfv42ct011", "w3_unit1_10hfv42cp011", "w3_unit1_10hfe40cp002", "w3_unit1_10hfc42ct015", "w3_unit1_10hfc42ct014", "w3_unit1_10hfc42ct013", "w3_unit1_10hfc42ct012", "w3_unit1_10hfc42ct011", "w3_unit1_10hfc40ct036", "w3_unit1_10hfc40ct035", "w3_unit1_10hfc40ct034", "w3_unit1_10hfc40ct033", "w3_unit1_10hfc40ct032", "w3_unit1_10hfc40ct031", "w3_unit1_pri_flow_d", "w3_unit1_10hfe40ct001", "w3_unit1_10hfe40cp001", "w3_unit1_10hfc40ct013", "w3_unit1_10hfc40ct012", "w3_unit1_10hfc40ct011"], "coal_mill_E": ["w3_unit1_10hfc50ct022", "w3_unit1_10hfc50ct021", "w3_unit1_10hfc50cp011", "w3_unit1_10hfc50cp001", "w3_unit1_10hfv52ct011", "w3_unit1_10hfv52cp011", "w3_unit1_10hfe50cp002", "w3_unit1_10hfc52ct015", "w3_unit1_10hfc52ct014", "w3_unit1_10hfc52ct013", "w3_unit1_10hfc52ct012", "w3_unit1_10hfc52ct011", "w3_unit1_10hfc50ct036", "w3_unit1_10hfc50ct035", "w3_unit1_10hfc50ct034", "w3_unit1_10hfc50ct033", "w3_unit1_10hfc50ct032", "w3_unit1_10hfc50ct031", "w3_unit1_pri_flow_e", "w3_unit1_10hfe50ct001", "w3_unit1_10hfe50cp001", "w3_unit1_10hfc50ct013", "w3_unit1_10hfc50ct012", "w3_unit1_10hfc50ct011", "w3_unit1_10hfc40ct011"], "coal_mill_F": ["w3_unit1_10hfc62ct016", "w3_unit1_10hfc60ct022", "w3_unit1_10hfc60ct021", "w3_unit1_10hfc60cp011", "w3_unit1_10hfc60cp001", "w3_unit1_10hfv62ct011", "w3_unit1_10hfv62cp011", "w3_unit1_10hfe60cp002", "w3_unit1_10hfc62ct015", "w3_unit1_10hfc62ct014", "w3_unit1_10hfc62ct013", "w3_unit1_10hfc62ct012", "w3_unit1_10hfc62ct011", "w3_unit1_10hfc60ct036", "w3_unit1_10hfc60ct035", "w3_unit1_10hfc60ct034", "w3_unit1_10hfc60ct033", "w3_unit1_10hfc60ct032", "w3_unit1_10hfc60ct031", "w3_unit1_pri_flow_f", "w3_unit1_10hfe60ct001", "w3_unit1_10hfe60cp001", "w3_unit1_10hfc60ct013", "w3_unit1_10hfc60ct012", "w3_unit1_10hfc60ct011"], "feed_pump_turbine_A": ["w3_unit1_10xac10ct094", "w3_unit1_10xac10ct093", "w3_unit1_10xac10ct092", "w3_unit1_10xac10ct091", "w3_unit1_10xac10cp001", "w3_unit1_10xaa13cp001", "w3_unit1_10xaa12cp011", "w3_unit1_10xaa12cp001", "w3_unit1_10lbr11cp001", "w3_unit1_10xac10ct081", "w3_unit1_10xac10ct008", "w3_unit1_10xac10ct007", "w3_unit1_10xac10ct006", "w3_unit1_10xac10ct005", "w3_unit1_10xac10ct004", "w3_unit1_10xac10ct003", "w3_unit1_10xac10ct002", "w3_unit1_10xac10ct001", "w3_unit1_10xaa11ct201", "w3_unit1_10xaa11cp001", "w3_unit1_10xaa11ct135", "w3_unit1_load"], "feed_pump_turbine_B": ["w3_unit1_10xac20ct094", "w3_unit1_10xac20ct093", "w3_unit1_10xac20ct092", "w3_unit1_10xac20ct091", "w3_unit1_10xac20cp001", "w3_unit1_10xaa23cp001", "w3_unit1_10xaa22cp011", "w3_unit1_10xaa22cp001", "w3_unit1_10lbr12cp001", "w3_unit1_10xac20ct081", "w3_unit1_10xac20ct008", "w3_unit1_10xac20ct007", "w3_unit1_10xac20ct006", "w3_unit1_10xac20ct005", "w3_unit1_10xac20ct004", "w3_unit1_10xac20ct003", "w3_unit1_10xac20ct002", "w3_unit1_10xac20ct001", "w3_unit1_10xaa21ct201", "w3_unit1_10xaa21cp001", "w3_unit1_10xaa21ct135", "w3_unit1_load"], "forced_draught_blower_A": ["w3_unit1_10hla10cp001", "w3_unit1_10hlv10m01ai01", "w3_unit1_10hlb10m01ai01", "w3_unit1_10hlb10cy012", "w3_unit1_10hlb10cy011", "w3_unit1_10hlb10ct066", "w3_unit1_10hlb10ct065", "w3_unit1_10hlb10ct064", "w3_unit1_10hlb10ct063", "w3_unit1_10hlb10ct062", "w3_unit1_10hlb10ct061", "w3_unit1_10hlb10ct042", "w3_unit1_10hlb10ct041", "w3_unit1_10hlb10ct033", "w3_unit1_10hlb10ct032", "w3_unit1_10hlb10ct031", "w3_unit1_10hlb10ct023", "w3_unit1_10hlb10ct022", "w3_unit1_10hlb10ct021", "w3_unit1_10hlb10ct013", "w3_unit1_10hlb10ct012", "w3_unit1_10hlb10ct011", "w3_unit1_10hla10ct003", "w3_unit1_10hla10ct002", "w3_unit1_10hla10ct001", "w3_unit1_10hlb10cf003", "w3_unit1_10hlb10cf002", "w3_unit1_10hlb10cf001"], "forced_draught_blower_B": ["w3_unit1_10hla20cp001", "w3_unit1_10hlv20m02ai01", "w3_unit1_10hlb20m01ai01", "w3_unit1_10hlb20cy012", "w3_unit1_10hlb20cy011", "w3_unit1_10hlb20ct066", "w3_unit1_10hlb20ct065", "w3_unit1_10hlb20ct064", "w3_unit1_10hlb20ct063", "w3_unit1_10hlb20ct062", "w3_unit1_10hlb20ct061", "w3_unit1_10hlb20ct042", "w3_unit1_10hlb20ct041", "w3_unit1_10hlb20ct033", "w3_unit1_10hlb20ct032", "w3_unit1_10hlb20ct031", "w3_unit1_10hlb20ct023", "w3_unit1_10hlb20ct022", "w3_unit1_10hlb20ct021", "w3_unit1_10hlb20ct013", "w3_unit1_10hlb20ct012", "w3_unit1_10hlb20ct011", "w3_unit1_10hla20ct003", "w3_unit1_10hla20ct002", "w3_unit1_10hla20ct001", "w3_unit1_10hlb20cf003", "w3_unit1_10hlb20cf002", "w3_unit1_10hlb20cf001"]}。你需要做的是编写表C的插入SQL。这个插入SQL中MEASURE_POINT_NAME字段采用表A中的中文,但是是加一个序号比如说:一次风机B1、一次风机B2。MEASURE_POINT_KEY字段则是去上面的数据中匹配,这个里面有多少条数据就表示这个要插入多少条:"primary_air_fan_B": ["w3_unit1_10hlb40cf001", "w3_unit1_10hla40ct003", "w3_unit1_10hla40ct002", "w3_unit1_10hla40ct001", "w3_unit1_10hla40cp001", "w3_unit1_10hlv40m02ai01", "w3_unit1_10hlv40m01ai01", "w3_unit1_10hlb40m01ai01", "w3_unit1_10hlb40cy012", "w3_unit1_10hlb40cy011", "w3_unit1_10hlb40ct066", "w3_unit1_10hlb40ct065", "w3_unit1_10hlb40ct064", "w3_unit1_10hlb40ct063", "w3_unit1_10hlb40ct062", "w3_unit1_10hlb40ct061", "w3_unit1_10hlb40ct052", "w3_unit1_10hlb40ct051", "w3_unit1_10hlb40ct043", "w3_unit1_10hlb40ct042", "w3_unit1_10hlb40ct041", "w3_unit1_10hlb40ct033", "w3_unit1_10hlb40ct032", "w3_unit1_10hlb40ct031", "w3_unit1_10hlb40ct023", "w3_unit1_10hlb40ct022", "w3_unit1_10hlb40ct021", "w3_unit1_10hlb40ct013", "w3_unit1_10hlb40ct012", "w3_unit1_10hlb40ct011"], SID字段的匹配方式根据表A和表B的数据来,比如说表A是18 一次风机B primary_air_fan_B,这个数据就对应表B的217 18。那么SID就是18。也就是说所有的primary_air_fan_B的SID都是18。剩下的字段"ATTRIBUTE_TYPE_ID" VARCHAR(50),
"MEASURE_POINT_TYPE_ID" VARCHAR(50),
"UNIT_NAME" VARCHAR(10),
"LIMIT_TYPE" INT DEFAULT 0 NOT NULL,
"UPPER_LIMIT" REAL,
"LOWER_LIMIT" REAL,
字段全部固定值:714801548705677637 714801636857364805 ℃ 1 100 60。最后说一遍,你需要把我给你的json字符串中的数据变成这个C表的插入SQL。我使用的达梦数据库。请将他们一一匹配好。