platform-logic/generic-resource-api/src/main/xml/GENERIC-RESOURCE-API_port-mirror-rollback-capacity-db.xml

   1 <service-logic
   2     xmlns='http://www.onap.org/sdnc/svclogic'
   3     xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.onap.org/sdnc/svclogic ./svclogic.xsd' module='GENERIC-RESOURCE-API' version='${project.version}'>
   4     <method rpc='port-mirror-rollback-capacity-db' mode='sync'>
   5         <block>
   6             <for index='src-idx' start='0' end='`$pm.configuration-data.port-mirror-configuration-topology.port-mirror-configuration-assignments.source-to-dest-maps.source-to-dest-map_length`' >
   7                 <block atomic="true">
   8                     <get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
   9   key='select available_capacity
  10     from VNICS_CAPACITY
  11     where vnics_group_id = $pm.configuration-data.port-mirror-configuration-topology.port-mirror-configuration-assignments.vnics-group-id
  12     and vnic_port_name = $pm.configuration-data.port-mirror-configuration-topology.port-mirror-configuration-assignments.source-to-dest-maps.source-to-dest-map[$src-idx].dest-port-name'
  13   pfx='db.vnics-capacity'>
  14                         <outcome value='success'>
  15                             <block>
  16                                 <set>
  17                                     <parameter name='tmp.avail-capacity' value='`$db.vnics-capacity.available-capacity + $pm.configuration-data.port-mirror-configuration-topology.port-mirror-configuration-assignments.source-capacity`' />
  18                                 </set>
  19                                 <update plugin="org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource" resource="SQL"
  20 key="update VNICS_CAPACITY
  21      set available_capacity = $tmp.avail-capacity
  22      where vnics_group_id = $pm.configuration-data.port-mirror-configuration-topology.port-mirror-configuration-assignments.vnics-group-id
  23      and vnic_port_name = $pm.configuration-data.port-mirror-configuration-topology.port-mirror-configuration-assignments.source-to-dest-maps.source-to-dest-map[$src-idx].dest-port-name
  24 " ></update>
  25                             </block>
  26                         </outcome>
  27                     </get-resource>
  28                 </block>
  29             </for>
  30             <delete plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
  31   key='delete from VNICS_CONFIGURATION_ID
  32         where configuration_id = $tmp.configuration-id
  33     and vnics_group_id = $pm.configuration-data.port-mirror-configuration-topology.port-mirror-configuration-assignments.vnics-group-id' ></delete>
  34             <get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
  35   key='select configuration_id
  36     from VNICS_CONFIGURATION_ID
  37     where vnics_group_id = $pm.configuration-data.port-mirror-configuration-topology.port-mirror-configuration-assignments.vnics-group-id'
  38   pfx='db.vnics-confid'>
  39                 <outcome value='not-found'>
  40                     <block>
  41                         <delete plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
  42   key='delete from VNICS_CAPACITY
  43         where vnics_group_id = $pm.configuration-data.port-mirror-configuration-topology.port-mirror-configuration-assignments.vnics-group-id' ></delete>
  44                         <delete plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
  45   key='delete from VNICS_CAPACITY_GROUP
  46         where vnics_group_id = $pm.configuration-data.port-mirror-configuration-topology.port-mirror-configuration-assignments.vnics-group-id' ></delete>
  47                     </block>
  48                 </outcome>
  49             </get-resource>
  50         </block>
  51     </method>
  52 </service-logic>