adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V3.8__UnassignFabricConfigurationData.sql

   1 use catalogdb;
   2
   3 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
   4 VALUES
   5 ('UnassignFabricConfigurationBB', 'CONFIGURATION', 'UNASSIGN');
   6
   7 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
   8 VALUES
   9 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
  10 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
  11 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
  12 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
  13 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
  14 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
  15 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
  16 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
  17 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
  18
  19 UPDATE orchestration_flow_reference
  20 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
  21
  22 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
  23 VALUES
  24 ('Service-Macro-Delete', '1', 'DeactivateFabricConfigurationBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete')),
  25 ('Service-Macro-Delete', '2', 'UnassignFabricConfigurationBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete'));
  26
  27 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
  28 VALUES
  29 ('UnassignFabricConfigurationBB', '*', '*', '*', '*' , 'Retry');
  30
  31