gerrit.onap Code Review - so.git/blob

   1 -- MSO Catalog DB: table 'service-recipe' ----
   2 -- should update a row for create instance
   3 UPDATE mso_catalog.service_recipe
   4 SET ORCHESTRATION_URI = "/mso/async/services/CreateGenericALaCarteServiceInstance"
   5 WHERE SERVICE_ID = 4
   6   AND ACTION = 'createInstance';
   7
   8 -- should update a row for delete instance
   9 UPDATE mso_catalog.service_recipe
  10 SET ORCHESTRATION_URI = "/mso/async/services/DeleteGenericALaCarteServiceInstance"
  11 WHERE SERVICE_ID = 4
  12   AND ACTION = 'deleteInstance';
  13
  14 SET SQL_SAFE_UPDATES = 0;
  15
  16 -- 1 coordinate this change with Dmitry when updating labs
  17 UPDATE mso_catalog.service_recipe
  18 SET orchestration_uri = "/mso/async/services/CreateGenericMacroServiceNetworkVnf"
  19 WHERE orchestration_uri = "/mso/async/services/CreateViprAtmService";
  20
  21 UPDATE mso_catalog.service_recipe
  22 SET orchestration_uri = "/mso/async/services/DeleteGenericMacroServiceNetworkVnf"
  23 WHERE orchestration_uri = "/mso/async/services/DeleteViprAtmService";
  24
  25 -- 2 network_recipe
  26 UPDATE mso_catalog.network_recipe
  27 SET orchestration_uri = '/mso/async/services/UpdateNetworkInstance'
  28 WHERE network_type = 'VID_DEFAULT' AND action = 'updateInstance';
  29
  30 SET SQL_SAFE_UPDATES = 1;