<block atomic="true"><switch test='`$network-model.is-bound-to-vpn`'>
<outcome value='Y'>
<block atomic="true">
-<get-resource plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key='SELECT * from VPN_BINDINGS WHERE network_customization_uuid = $network-topology-operation-input.network-information.onap-model-information.model-customization-uuid'
pfx='vpn-bindings[]'>
<parameter name="target" value="$role"/>
<parameter name="replacement" value="`$network-model.network-role`"/>
-</execute><get-resource plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</execute><get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key='SELECT * from NETWORK_INSTANCE_NAME_INDEX WHERE network_instance_name_prefix
= $tmp.network-name-prefix'
pfx='db.network-name-prefix'>
<outcome value='Other'>
<block atomic="true"><set>
<parameter name='tmp.index-number' value='`$db.network-name-prefix.index-number+1`' />
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key="update NETWORK_INSTANCE_NAME_INDEX
set index_number = $tmp.index-number
where network_instance_name_prefix = $db.network-name-prefix.network-instance-name-prefix "
<parameter name="error-message" value="Failed to update SERVICE_INSTANCE_NAME_INDEX table" />
</return></outcome></save></block></outcome><outcome value=''><block atomic="true"><set>
<parameter name='tmp.index-number' value='1' />
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key="insert into NETWORK_INSTANCE_NAME_INDEX values ( $tmp.network-name-prefix , 1)"
force='false' pfx='pfx'>
<outcome value='failure'>
<parameter name="target" value="$role"/>
<parameter name="replacement" value="`$network-model.network-role`"/>
-</execute><get-resource plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</execute><get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key='SELECT * from NETWORK_INSTANCE_NAME_INDEX WHERE network_instance_name_prefix
= $tmp.network-name-prefix'
pfx='db.network-name-prefix'>
<outcome value='Other'>
<block atomic="true"><set>
<parameter name='tmp.index-number' value='`$db.network-name-prefix.index-number+1`' />
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key="update NETWORK_INSTANCE_NAME_INDEX
set index_number = $tmp.index-number
where network_instance_name_prefix = $db.network-name-prefix.network-instance-name-prefix "
<parameter name="error-message" value="Failed to update SERVICE_INSTANCE_NAME_INDEX table" />
</return></outcome></save></block></outcome><outcome value=''><block atomic="true"><set>
<parameter name='tmp.index-number' value='1' />
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key="insert into NETWORK_INSTANCE_NAME_INDEX values ( $tmp.network-name-prefix , 1)"
force='false' pfx='pfx'>
<outcome value='failure'>
<parameter name="target" value="$role"/>
<parameter name="replacement" value="`$network-model.network-role`"/>
-</execute><get-resource plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</execute><get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key='SELECT * from NETWORK_INSTANCE_NAME_INDEX WHERE network_instance_name_prefix
= $tmp.network-name-prefix'
pfx='db.network-name-prefix'>
<outcome value='Other'>
<block atomic="true"><set>
<parameter name='tmp.index-number' value='`$db.network-name-prefix.index-number+1`' />
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key="update NETWORK_INSTANCE_NAME_INDEX
set index_number = $tmp.index-number
where network_instance_name_prefix = $db.network-name-prefix.network-instance-name-prefix "
<parameter name="error-message" value="Failed to update SERVICE_INSTANCE_NAME_INDEX table" />
</return></outcome></save></block></outcome><outcome value=''><block atomic="true"><set>
<parameter name='tmp.index-number' value='1' />
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key="insert into NETWORK_INSTANCE_NAME_INDEX values ( $tmp.network-name-prefix , 1)"
force='false' pfx='pfx'>
<outcome value='failure'>
<parameter name="target" value="$role"/>
<parameter name="replacement" value="`$network-model.network-role`"/>
-</execute><get-resource plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</execute><get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key='SELECT * from NETWORK_INSTANCE_NAME_INDEX WHERE network_instance_name_prefix
= $tmp.network-name-prefix'
pfx='db.network-name-prefix'>
<outcome value='Other'>
<block atomic="true"><set>
<parameter name='tmp.index-number' value='`$db.network-name-prefix.index-number+1`' />
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key="update NETWORK_INSTANCE_NAME_INDEX
set index_number = $tmp.index-number
where network_instance_name_prefix = $db.network-name-prefix.network-instance-name-prefix "
<parameter name="error-message" value="Failed to update SERVICE_INSTANCE_NAME_INDEX table" />
</return></outcome></save></block></outcome><outcome value=''><block atomic="true"><set>
<parameter name='tmp.index-number' value='1' />
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key="insert into NETWORK_INSTANCE_NAME_INDEX values ( $tmp.network-name-prefix , 1)"
force='false' pfx='pfx'>
<outcome value='failure'>
<parameter name="target" value="$role"/>
<parameter name="replacement" value="`$network-model.network-role`"/>
-</execute><get-resource plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</execute><get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key='SELECT * from NETWORK_INSTANCE_NAME_INDEX WHERE network_instance_name_prefix
= $tmp.network-name-prefix'
pfx='db.network-name-prefix'>
<outcome value='Other'>
<block atomic="true"><set>
<parameter name='tmp.index-number' value='`$db.network-name-prefix.index-number+1`' />
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key="update NETWORK_INSTANCE_NAME_INDEX
set index_number = $tmp.index-number
where network_instance_name_prefix = $db.network-name-prefix.network-instance-name-prefix "
<parameter name="error-message" value="Failed to update SERVICE_INSTANCE_NAME_INDEX table" />
</return></outcome></save></block></outcome><outcome value=''><block atomic="true"><set>
<parameter name='tmp.index-number' value='1' />
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'
key="insert into NETWORK_INSTANCE_NAME_INDEX values ( $tmp.network-name-prefix , 1)"
force='false' pfx='pfx'>
<outcome value='failure'>