////ransim-db

//renaming as per the container name used in the demo
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;

//updating data for 01-3C5C90
delete from plmninfo;
INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15289,11,3,5,3000,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15290,11,3,5,3000,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15296,11,3,5,3000,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15687,11,3,5,3000,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15689,11,3,5,3000,'2020-11-20 07:56:49');

INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15155,11,3,5,3000,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15174,11,3,5,3000,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15175,11,3,5,3000,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15176,11,3,5,3000,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15825,11,3,5,3000,'2020-11-20 07:56:49');

INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15425,11,3,5,3000,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15426,11,3,5,3000,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,15826,11,3,5,3000,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,14000,11,3,5,3000,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` VALUES ('39-00','5GCustomer','01-3C5C90','ACTIVE','5G',NULL,NULL,13999,11,3,5,3000,'2020-11-20 07:56:49');
select * from plmninfo;





////configdb

//updating data for 01-3C5C90 in config db
INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00',NULL,NULL,13999,11,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00',NULL,NULL,15290,11,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00',NULL,NULL,15296,11,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00',NULL,NULL,15687,11,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00',NULL,NULL,15689,11,'2020-11-20 07:56:49');

INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00',NULL,NULL,15155,11,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00',NULL,NULL,15174,11,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00',NULL,NULL,15175,11,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00',NULL,NULL,15176,11,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00',NULL,NULL,15825,11,'2020-11-20 07:56:49');

INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00', NULL,NULL,15425,11'2020-11-20 07:56:49');
INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00', NULL,NULL,15426,11,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00', NULL,NULL,15826,11,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00', NULL,NULL,14000,11,'2020-11-20 07:56:49');
INSERT INTO `plmninfo` (plmnid,gnbcuupid,nrcellcu_celllocalid, nrcelldu_celllocalid, nearrtricid, lastupdatedts) VALUES ('39-00', NULL,NULL,13999,11,'2020-11-20 07:56:49');
select * from plmninfo;


insert into snssai values ('1','5GCustomer', '01-3C5C90','ACTIVE','5G',1);
insert into snssai values ('2','5GCustomer', '01-3C5C90','ACTIVE','5G',2);
insert into snssai values ('3','5GCustomer', '01-3C5C90','ACTIVE','5G',3);
insert into snssai values ('4','5GCustomer', '01-3C5C90','ACTIVE','5G',4);
insert into snssai values ('5','5GCustomer', '01-3C5C90','ACTIVE','5G',5);
insert into snssai values ('6','5GCustomer', '01-3C5C90','ACTIVE','5G',6);
insert into snssai values ('7','5GCustomer', '01-3C5C90','ACTIVE','5G',7);
insert into snssai values ('8','5GCustomer', '01-3C5C90','ACTIVE','5G',8);
insert into snssai values ('9','5GCustomer', '01-3C5C90','ACTIVE','5G',9);
insert into snssai values ('10','5GCustomer', '01-3C5C90','ACTIVE','5G',10);
insert into snssai values ('11','5GCustomer', '01-3C5C90','ACTIVE','5G',11);



//update customer details to match data in AAI
curl -k -X PUT http://<configDBIP>:8086/api/sdnc-config-db/v4/nearRTRIC -H "Content-Type:application/json" --data '{
   "nearRTRICId":11,
   "gNBId":25,
   "trackingArea":[
      "Kingston"
   ],
   "resourceType":"NearRTRIC",
   "ranNFNSSIList":[
      "11",
      "22"
   ],
   "pLMNInfoList":[
      {
         "pLMNId":"39-00",
         "sNSSAI":[
            {
               "sNSSAI":"01-3C5C90",
               "status":"ACTIVE",
               "globalSubscriberId":"5GCustomer",
               "subscriptionServiceType":"5G",
               "configData":[
                  {
                     "dLThptPerSlice":27,
                     "uLThptPerSlice":30,
                     "maxNumberOfConns":3000
                  }
               ]
            }
         ]
      }
   ]
}' -i

curl -k -X PUT http://<configDBIP>:8086/api/sdnc-config-db/v4/ranslice-details -H "Content-Type:application/json" --data '{
   "ranNFNSSIId":"f002d241-6244-49ec-a656-d68725ca218b",
   "ranNSSIList":[
       "ran4"
   ],
   "nsiList":[
       "nsi1","nsi2"
   ],
   "nSSAIList":[
       "01-3C5C90"
   ],

   "sliceProfilesList":[
       {

           "sliceProfileId": "97e4c177-bc69-4daa-8271-c2b137320bc5",

           "dLThptPerSlice": 54,

           "uLThptPerSlice": 60,

           "maxNumberofConns":3000,

           "sNSSAI":"01-3C5C90",

           "pLMNIdList":"39-00"

       }

   ],

   "trackingAreaList":"Kingston" ,

   "subnetStatus":"ACTIVE",

   "nsstId":"NSSTID1",

   "sliceType":"eMBB",

   "isShareable":"true"
}' -i





///AAI
//Request to create Create customer id in AAI : 

curl --user AAI:AAI -X PUT -H "X-FromAppId:AAI" -H  "X-TransactionId:get_aai_subscr" -H "Accept:application/json" -H "Content-Type:application/json" -k -d '{ 
"global-customer-id":"5GCustomer", 
"subscriber-name":"5GCustomer", 
"subscriber-type":"INFRA",
"resource-version": "1613712919114"
}' -k https://<IPAddress>:30233/aai/v21/business/customers/customer/5GCustomer  -i

//Create service type:

curl --user AAI:AAI -X PUT -H "X-FromAppId:AAI" -H  "X-TransactionId:get_aai_subscr" -H "Accept:application/json" -H "Content-Type:application/json" -k https://<IPAddress>:30233/aai/v21/business/customers/customer/5GCustomer/service-subscriptions/service-subscription/5G 


//Request to create service in AAI

curl --user AAI:AAI -X PUT -H "X-FromAppId:AAI" -H  "X-TransactionId:get_aai_subscr" -H "Accept:application/json" -H "Content-Type:application/json" -k https://<IPAddress>:30233/aai/v21/business/customers/customer/5GCustomer/service-subscriptions/service-subscription/5G/service-instances/service-instance/f002d241-6244-49ec-a656-d68725ca218b -d '{
        "service-instance-id": "f002d241-6244-49ec-a656-d68725ca218b",
        "service-instance-name": "an_sp_1",
        "service-type": "00-000",
        "service-role": "slice-profile-instance",
        "workload-context": "AN-NF",
        "environment-context": "01-3C5C90",
        "service-instance-location-id": "[\"460-00\",\"460-01\"]",
        "orchestration-status": "deactivated",
        "slice-profiles": {
                "slice-profile": [{
                        "profile-id": "878f32c0-3677-4dbd-95a3-1f01d6c763c1",
                        "latency": 30,
                        "max-number-of-UEs": 200,
                        "exp-data-rate-UL": 40,
                        "exp-data-rate-DL": 50,
                        "coverage-area-TA-list": "[1, 2, 3, 4]",
                        "resource-sharing-level": "non-shared",
                        "max-number-of-conns:": 3000


                }]
        }
}' -i