////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
//update customer details to match data in AAI(if not already updated using script)
update snssai set globalsubscriberid='5GCustomer',subscriptionservicetype='5G' where snssai_id=1;
update snssai set globalsubscriberid='5GCustomer',subscriptionservicetype='5G' where snssai_id=9;
update snssai set globalsubscriberid='5GCustomer',subscriptionservicetype='5G' where snssai_id=19;




///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