//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 conating one slice data from one cucpserver.


//while generating data for cucpserver2(slice1 data)
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

//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');