//steps to access ransim Database

docker exec -ti ran-mariadb bash
root@mariadb:/# mysql -uroot -p
use ransim_db;

//renaming as per the container name used in honeycomb setup
update gnbdufunction set gnbduname='110' where gnbduid=110;update gnbdufunction set gnbduname='220' where gnbduid=220;update gnbdufunction set gnbduname='330' where gnbduid=330;update gnbdufunction set gnbduname='440' where gnbduid=440;update gnbdufunction set gnbduname='550' where gnbduid=550;update gnbdufunction set gnbduname='660' where gnbduid=660;select * from gnbdufunction;


//view plmninfo data
select * from plmninfo;

//delete plmninfo data
delete from plmninfo;


///NOTE///
Currently ml-prediction-ms supports only PM data containing one slice data from one cucpserver only.


//while generating data for cucpserver1(slice1 or slice2)
INSERT INTO gnbcucpfunction(gnbcuname, gnbid, gnbidlength, nftype,plmnid,nearrtricid) VALUES('cucpserver1', 25, 25, 'CUCP', '310-410', 11);
delete from nrcellcu where  gnbcuname='cucpserver2';
delete from gnbcucpfunction where gnbcuname='cucpserver2';
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15289,'RRC Connected Users','cucpserver1');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15290,'RRC Connected Users','cucpserver1');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15296,'RRC Connected Users','cucpserver1');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15155,'RRC Connected Users','cucpserver1');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15174,'RRC Connected Users','cucpserver1');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15175,'RRC Connected Users','cucpserver1');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15176,'RRC Connected Users','cucpserver1');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15825,'RRC Connected Users','cucpserver1');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15826,'RRC Connected Users','cucpserver1');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(13999,'RRC Connected Users','cucpserver1');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(14000,'RRC Connected Users','cucpserver1');

//while generating data for cucpserver2(slice3 or slice4)
INSERT INTO gnbcucpfunction(gnbcuname, gnbid, gnbidlength, nftype,plmnid,nearrtricid) VALUES('cucpserver2', 25, 25, 'CUCP', '310-410',22);
delete from nrcellcu where  gnbcuname='cucpserver1';
delete from gnbcucpfunction where gnbcuname='cucpserver1';
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(11561,'RRC Connected Users','cucpserver2');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(11562,'RRC Connected Users','cucpserver2');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(11568,'RRC Connected Users','cucpserver2');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(11569,'RRC Connected Users','cucpserver2');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(10896,'RRC Connected Users','cucpserver2');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(10897,'RRC Connected Users','cucpserver2');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(14655,'RRC Connected Users','cucpserver2');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(14656,'RRC Connected Users','cucpserver2');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(13905,'RRC Connected Users','cucpserver2');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(13910,'RRC Connected Users','cucpserver2');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15360,'RRC Connected Users','cucpserver2');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15361,'RRC Connected Users','cucpserver2');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15548,'RRC Connected Users','cucpserver2');
INSERT INTO nrcellcu(celllocalId,resourcetype,gnbcuname) VALUES(15549,'RRC Connected Users','cucpserver2');



//steps to insert data

//slice1 data
delete from plmninfo;
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-B989BD','ACTIVE',NULL,NULL,15289,NULL,NULL,26400000,26880000,800,'2022-02-09 07:45:40');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-B989BD','ACTIVE',NULL,NULL,15290,NULL,NULL,26400000,26880000,800,'2022-02-09 07:45:41');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-B989BD','ACTIVE',NULL,NULL,15296,NULL,NULL,26400000,26880000,800,'2022-02-09 07:45:41');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-B989BD','ACTIVE',NULL,NULL,15155,NULL,NULL,26400000,26880000,800,'2022-02-09 07:45:47');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-B989BD','ACTIVE',NULL,NULL,15174,NULL,NULL,26400000,26880000,800,'2022-02-09 07:45:48');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-B989BD','ACTIVE',NULL,NULL,15175,NULL,NULL,26400000,26880000,800,'2022-02-09 07:45:48');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-B989BD','ACTIVE',NULL,NULL,15176,NULL,NULL,26400000,26880000,800,'2022-02-09 07:45:49');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-B989BD','ACTIVE',NULL,NULL,15825,NULL,NULL,26400000,26880000,800,'2022-02-09 07:45:55');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-B989BD','ACTIVE',NULL,NULL,15826,NULL,NULL,26400000,26880000,800,'2022-02-09 07:45:56');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-B989BD','ACTIVE',NULL,NULL,13999,NULL,NULL,26400000,26880000,800,'2022-02-09 07:45:56');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-B989BD','ACTIVE',NULL,NULL,14000,NULL,NULL,26400000,26880000,800,'2022-02-09 07:45:57');


//slice2 data
delete from plmninfo;
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-6C9724','ACTIVE',NULL,NULL,15289,NULL,NULL,24000000,25440000,800,'2022-02-09 08:03:37');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-6C9724','ACTIVE',NULL,NULL,15290,NULL,NULL,24000000,25440000,800,'2022-02-09 08:03:37');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-6C9724','ACTIVE',NULL,NULL,15296,NULL,NULL,24000000,25440000,800,'2022-02-09 08:03:38');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-6C9724','ACTIVE',NULL,NULL,15155,NULL,NULL,24000000,25440000,800,'2022-02-09 08:03:44');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-6C9724','ACTIVE',NULL,NULL,15174,NULL,NULL,24000000,25440000,800,'2022-02-09 08:03:45');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-6C9724','ACTIVE',NULL,NULL,15175,NULL,NULL,24000000,25440000,800,'2022-02-09 08:03:45');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-6C9724','ACTIVE',NULL,NULL,15176,NULL,NULL,24000000,25440000,800,'2022-02-09 08:03:46');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-6C9724','ACTIVE',NULL,NULL,15825,NULL,NULL,24000000,25440000,800,'2022-02-09 08:03:53');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-6C9724','ACTIVE',NULL,NULL,15826,NULL,NULL,24000000,25440000,800,'2022-02-09 08:03:53');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-6C9724','ACTIVE',NULL,NULL,13999,NULL,NULL,24000000,25440000,800,'2022-02-09 08:03:54');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-6C9724','ACTIVE',NULL,NULL,14000,NULL,NULL,24000000,25440000,800,'2022-02-09 08:03:54');



//slice3 data
delete from plmninfo;
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,11561,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:40');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,11562,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:41');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,11568,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:41');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,11569,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:42');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,10896,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:46');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,10897,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:47');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,13905,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:47');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,13910,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:48');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,15360,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:53');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,15361,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:53');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,15548,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:53');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,15549,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:54');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,14655,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:59');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-8C2B9A','ACTIVE',NULL,NULL,14656,NULL,NULL,9600000,9920000,800,'2022-02-08 11:42:59');

//slice4 data
delete from plmninfo;
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,11561,NULL,NULL,26400000,28800000,800,'2022-02-09 07:32:52');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,11562,NULL,NULL,26400000,28800000,800,'2022-02-09 07:32:53');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,11568,NULL,NULL,26400000,28800000,800,'2022-02-09 07:32:53');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,11569,NULL,NULL,26400000,28800000,800,'2022-02-09 07:32:54');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,10896,NULL,NULL,26400000,28800000,800,'2022-02-09 07:32:59');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,10897,NULL,NULL,26400000,28800000,800,'2022-02-09 07:32:59');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,13905,NULL,NULL,26400000,28800000,800,'2022-02-09 07:33:00');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,13910,NULL,NULL,26400000,28800000,800,'2022-02-09 07:33:00');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,15360,NULL,NULL,26400000,28800000,800,'2022-02-09 07:33:05');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,15361,NULL,NULL,26400000,28800000,800,'2022-02-09 07:33:06');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,15548,NULL,NULL,26400000,28800000,800,'2022-02-09 07:33:06');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,15549,NULL,NULL,26400000,28800000,800,'2022-02-09 07:33:06');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,14655,NULL,NULL,26400000,28800000,800,'2022-02-08 10:22:11');
INSERT INTO `plmninfo` VALUES ('39-00',NULL,'01-066EC4','ACTIVE',NULL,NULL,14656,NULL,NULL,26400000,28800000,800,'2022-02-08 10:22:12');