制造假数据全部
SET @start_id = 11;
SET @start_time = '2023-06-16 15:30:00';
SET @ne_name = '1';
INSERT INTO
pm_gnodeb (id, time_key, `ne_name`,prb_assn_rate_ul,prb_assn_rate_dl,wireless_call_completion_rate,wireless_call_drop_rate)
VALUES (@start_id, @start_time,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)));
SET @start_id = 11;
SET @start_time = '2023-06-16 15:30:00';
SET @ne_name = '1';
SET @s_nssai_id = '2';
INSERT INTO
pm_upfns (id, time_key, `ne_name`,n3_inc_oct_rate_ns,n3_og_oct_rate_ns,s_nssai_id)
VALUES (@start_id, @start_time,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id);
SET @start_id = 11;
SET @start_time = '2023-06-16 15:30:00';
SET @ne_name = '1';
SET @s_nssai_id = '1';
INSERT INTO
pm_smfns(id, time_key, `ne_name`,succ_create_pdu_rate_ns,s_nssai_id)
VALUES (@start_id, @start_time,@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id);
SET @start_id = 10;
SET @start_time = '2023-12-12 15:30:00'; -- 时间往后增加
SET @ne_name = 'APP-HBWHUPFm017EHW-0004EHW011';
SET @s_nssai_id = '2';
INSERT INTO
pm_upf (id, time_key, `ne_name`,upf_throughput_rate,mean_me_load,n6_inc_oct,n6_og_oct)
VALUES (@start_id, @start_time,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3)));
SET @start_id = 20;
SET @start_time = '2023-11-17 15:30:00';
SET @s_nssai_id = '128-448088';
SET @ne_name = 'APP-HBWHUPFm017EHW-0004EHW011';
INSERT INTO
pm_amfns (id, time_key, `s_nssai_id`,ne_name,reg_sub_ns,amf_reg_sub_ns,me_mean_me_load)
VALUES(@start_id, @start_time,@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
(@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)));