platform-logic/datachange/src/main/xml/DataChange_esr-thirdparty-sdnc-discovery.xml

   1 <service-logic\r
   2         xmlns='http://www.onap.org/sdnc/svclogic'\r
   3         xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.onap.org/sdnc/svclogic ./svclogic.xsd' module='DataChange' version='${project.version}'>\r
   4     <method rpc='esr-thirdparty-sdnc-discovery' mode='sync'>\r
   5         <block atomic="true">\r
   6             <switch test="`$prop.sdncRestApi.vendor == 'ZTE'`">\r
   7                 <outcome value='false'>\r
   8                     <switch test="`$data-change-notification-input.aai-event-trigger`">\r
   9                         <outcome value='Update'>\r
  10                             <block>\r
  11                                 <switch test="`$prop.sdncRestApi.type`">\r
  12                                     <outcome value='WAN'>\r
  13                                         <block atomic="true">\r
  14                                             <execute plugin='org.onap.ccsdk.sli.plugins.prop.PropertiesNode' method='readProperties' >\r
  15                                                 <parameter name='fileName' value='%SDNC_CONFIG_DIR%/generic-resource-api-dg.properties' />\r
  16                                                 <parameter name='contextPrefix' value='prop' />\r
  17                                             </execute>\r
  18                                             <execute plugin='org.onap.ccsdk.sli.plugins.restapicall.RestapiCallNode' method='sendRequest' >\r
  19                                                 <parameter name="templateFileName" value="`$prop.restapi.templateDir + '/actokentemplate.json'`" />\r
  20                                                 <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/controller/v2/tokens'`" />\r
  21                                                 <parameter name="format" value="json"/>\r
  22                                                 <parameter name="httpMethod" value="post"/>\r
  23                                                 <parameter name="responsePrefix" value="token-result"/>\r
  24                                                 <!--<parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.jks"/>-->\r
  25                                                 <!--<parameter name="trustStorePassword" value="adminadmin"/>-->\r
  26                                                 <!--<parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>-->\r
  27                                                 <!--<parameter name="keyStorePassword" value="adminadmin"/>-->\r
  28                                                 <!--<parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.jks"/>-->\r
  29                                                 <!--<parameter name="trustStorePassword" value="adminadmin"/>-->\r
  30                                                 <!--<parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>-->\r
  31                                                 <!--<parameter name="keyStorePassword" value="adminadmin"/>-->\r
  32                                                 <parameter name="disableHostVerification" value="true"/>\r
  33                                                 <parameter name="ssl" value="false"/>\r
  34                                                 <outcome value='success'>\r
  35                                                     <set>\r
  36                                                         <parameter name='prop.sdncRestApi.token_id' value='`$token-result.data.token_id`' />\r
  37                                                     </set>\r
  38                                                 </outcome>\r
  39                                                 <outcome value='failure'>\r
  40                                                     <block></block>\r
  41                                                 </outcome>\r
  42                                             </execute>\r
  43                                             <switch test="`$prop.sdncRestApi.token_id`">\r
  44                                                 <outcome value=''>\r
  45                                                     <execute plugin='org.onap.ccsdk.sli.plugins.restapicall.RestapiCallNode' method='sendRequest' >\r
  46                                                         <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/restconf/data/ietf-network:networks'`" />\r
  47                                                         <parameter name="restapiUser" value="`$prop.sdncRestApi.thirdpartySdnc.user`" />\r
  48                                                         <parameter name="restapiPassword" value="`$prop.sdncRestApi.thirdpartySdnc.password`" />\r
  49                                                         <parameter name="format" value="json"/>\r
  50                                                         <parameter name="httpMethod" value="get"/>\r
  51                                                         <parameter name="responsePrefix" value="topology"/>\r
  52                                                         <!--<parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.jks"/>-->\r
  53                                                         <!--<parameter name="trustStorePassword" value="adminadmin"/>-->\r
  54                                                         <!--<parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>-->\r
  55                                                         <!--<parameter name="keyStorePassword" value="adminadmin"/>-->\r
  56                                                         <parameter name="disableHostVerification" value="true"/>\r
  57                                                         <parameter name="ssl" value="false"/>\r
  58                                                         <outcome value='failure'>\r
  59                                                             <return status='failure'>\r
  60                                                                 <parameter name='ack-final' value='Y'/>\r
  61                                                                 <parameter name="error-code" value="500" />\r
  62                                                                 <parameter name="error-message" value="Error executing Create vpn rest api" />\r
  63                                                             </return>\r
  64                                                         </outcome>\r
  65                                                         <outcome value='success'>\r
  66                                                             <block atomic="true">\r
  67                                                                 <for index='nidx' start='0' end='`$topology.networks.network_length`' >\r
  68                                                                     <block>\r
  69                                                                         <set>\r
  70                                                                             <parameter name='network.' value='' />\r
  71                                                                         </set>\r
  72                                                                         <set>\r
  73                                                                             <parameter name='network.' value='`$topology.networks.network[$nidx].`' />\r
  74                                                                         </set>\r
  75                                                                         <call module='DataChange' rpc='update-network-to-aai' mode='sync' ></call>\r
  76                                                                     </block>\r
  77                                                                 </for>\r
  78                                                                 <switch test='`$topology.networks.network_length >= 2`'>\r
  79                                                                     <outcome value='true'>\r
  80                                                                         <block atomic='true'>\r
  81                                                                             <for index='netidx' start='0' end='`$topology.networks.network_length`' >\r
  82                                                                                 <block>\r
  83                                                                                     <set>\r
  84                                                                                         <parameter name='network.' value='' />\r
  85                                                                                     </set>\r
  86                                                                                     <set>\r
  87                                                                                         <parameter name='network.' value='`$topology.networks.network[$netidx].`' />\r
  88                                                                                     </set>\r
  89                                                                                     <set>\r
  90                                                                                         <parameter name='tmpo.client-id' value='`$network.te-topology-identifier.client-id`' />\r
  91                                                                                         <parameter name='tmpo.te-topo-id' value='`$network.te-topology-identifier.topology-id`' />\r
  92                                                                                         <parameter name='tmpo.provider-id' value='`$network.te-topology-identifier.provider-id`' />\r
  93                                                                                     </set>\r
  94                                                                                     <switch test="`length($tmpo.client-id) == 0`">\r
  95                                                                                         <outcome value='true'>\r
  96                                                                                             <block>\r
  97                                                                                                 <set>\r
  98                                                                                                     <parameter name='tmpo.client-id' value='`$network.client-id`' />\r
  99                                                                                                 </set>\r
 100                                                                                             </block>\r
 101                                                                                         </outcome>\r
 102                                                                                     </switch>\r
 103                                                                                     <switch test="`length($tmpo.te-topo-id) == 0`">\r
 104                                                                                         <outcome value='true'>\r
 105                                                                                             <block>\r
 106                                                                                                 <set>\r
 107                                                                                                     <parameter name='tmpo.te-topo-id' value='`$network.te-topology-id`' />\r
 108                                                                                                 </set>\r
 109                                                                                             </block>\r
 110                                                                                         </outcome>\r
 111                                                                                     </switch>\r
 112                                                                                     <switch test="`length($tmpo.provider-id) == 0`">\r
 113                                                                                         <outcome value='true'>\r
 114                                                                                             <block>\r
 115                                                                                                 <set>\r
 116                                                                                                     <parameter name='tmpo.provider-id' value='`$network.provider-id`' />\r
 117                                                                                                 </set>\r
 118                                                                                             </block>\r
 119                                                                                         </outcome>\r
 120                                                                                     </switch>\r
 121                                                                                     <switch test='`$tmpo.te-topo-id`'>\r
 122                                                                                         <outcome value='1'>\r
 123                                                                                             <block>\r
 124                                                                                                 <set>\r
 125                                                                                                     <parameter name='network-otn.' value='`$topology.networks.network[$netidx].`' />\r
 126                                                                                                 </set>\r
 127                                                                                             </block>\r
 128                                                                                         </outcome>\r
 129                                                                                         <outcome value='2'>\r
 130                                                                                             <block>\r
 131                                                                                                 <set>\r
 132                                                                                                     <parameter name='network-eth.' value='`$topology.networks.network[$netidx].`' />\r
 133                                                                                                 </set>\r
 134                                                                                             </block>\r
 135                                                                                         </outcome>\r
 136                                                                                         <outcome value='11'>\r
 137                                                                                             <block>\r
 138                                                                                                 <set>\r
 139                                                                                                     <parameter name='network-otn.' value='`$topology.networks.network[$netidx].`' />\r
 140                                                                                                 </set>\r
 141                                                                                             </block>\r
 142                                                                                         </outcome>\r
 143                                                                                         <outcome value='33'>\r
 144                                                                                             <block>\r
 145                                                                                                 <set>\r
 146                                                                                                     <parameter name='network-eth.' value='`$topology.networks.network[$netidx].`' />\r
 147                                                                                                 </set>\r
 148                                                                                             </block>\r
 149                                                                                         </outcome>\r
 150                                                                                     </switch>\r
 151                                                                                 </block>\r
 152                                                                             </for>\r
 153                                                                             <call module='DataChange' rpc='update-tp-ttp-relationship' mode='sync' ></call>\r
 154                                                                         </block>\r
 155                                                                     </outcome>\r
 156                                                                 </switch>\r
 157                                                             </block>\r
 158                                                         </outcome>\r
 159                                                     </execute>\r
 160                                                 </outcome>\r
 161                                                 <outcome value='Other'>\r
 162                                                     <execute plugin='org.onap.ccsdk.sli.plugins.restapicall.RestapiCallNode' method='sendRequest' >\r
 163                                                         <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/restconf/data/ietf-network:networks'`" />\r
 164                                                         <parameter name="restapiUser" value="`$prop.sdncRestApi.thirdpartySdnc.user`" />\r
 165                                                         <parameter name="restapiPassword" value="`$prop.sdncRestApi.thirdpartySdnc.password`" />\r
 166                                                         <parameter name="format" value="json"/>\r
 167                                                         <parameter name="httpMethod" value="get"/>\r
 168                                                         <parameter name="responsePrefix" value="topology"/>\r
 169                                                         <!--<parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.jks"/>-->\r
 170                                                         <!--<parameter name="trustStorePassword" value="adminadmin"/>-->\r
 171                                                         <!--<parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>-->\r
 172                                                         <!--<parameter name="keyStorePassword" value="adminadmin"/>-->\r
 173                                                         <parameter name="disableHostVerification" value="true"/>\r
 174                                                         <parameter name="ssl" value="false"/>\r
 175                                                         <parameter name='customHttpHeaders' value="`'X-ACCESS-TOKEN=' + $prop.sdncRestApi.token_id`" />\r
 176                                                         <outcome value='failure'>\r
 177                                                             <return status='failure'>\r
 178                                                                 <parameter name='ack-final' value='Y'/>\r
 179                                                                 <parameter name="error-code" value="500" />\r
 180                                                                 <parameter name="error-message" value="Error executing Create vpn rest api" />\r
 181                                                             </return>\r
 182                                                         </outcome>\r
 183                                                         <outcome value='success'>\r
 184                                                             <block atomic="true">\r
 185                                                                 <for index='nidx' start='0' end='`$topology.networks.network_length`' >\r
 186                                                                     <block>\r
 187                                                                         <set>\r
 188                                                                             <parameter name='network.' value='' />\r
 189                                                                         </set>\r
 190                                                                         <set>\r
 191                                                                             <parameter name='network.' value='`$topology.networks.network[$nidx].`' />\r
 192                                                                         </set>\r
 193                                                                         <call module='DataChange' rpc='update-network-to-aai' mode='sync' ></call>\r
 194                                                                     </block>\r
 195                                                                 </for>\r
 196                                                                 <switch test='`$topology.networks.network_length >= 2`'>\r
 197                                                                     <outcome value='true'>\r
 198                                                                         <block atomic='true'>\r
 199                                                                             <for index='netidx' start='0' end='`$topology.networks.network_length`' >\r
 200                                                                                 <block>\r
 201                                                                                     <set>\r
 202                                                                                         <parameter name='network.' value='' />\r
 203                                                                                     </set>\r
 204                                                                                     <set>\r
 205                                                                                         <parameter name='network.' value='`$topology.networks.network[$netidx].`' />\r
 206                                                                                     </set>\r
 207                                                                                     <set>\r
 208                                                                                         <parameter name='tmpo.client-id' value='`$network.te-topology-identifier.client-id`' />\r
 209                                                                                         <parameter name='tmpo.te-topo-id' value='`$network.te-topology-identifier.topology-id`' />\r
 210                                                                                         <parameter name='tmpo.provider-id' value='`$network.te-topology-identifier.provider-id`' />\r
 211                                                                                     </set>\r
 212                                                                                     <switch test="`length($tmpo.client-id) == 0`">\r
 213                                                                                         <outcome value='true'>\r
 214                                                                                             <block>\r
 215                                                                                                 <set>\r
 216                                                                                                     <parameter name='tmpo.client-id' value='`$network.client-id`' />\r
 217                                                                                                 </set>\r
 218                                                                                             </block>\r
 219                                                                                         </outcome>\r
 220                                                                                     </switch>\r
 221                                                                                     <switch test="`length($tmpo.te-topo-id) == 0`">\r
 222                                                                                         <outcome value='true'>\r
 223                                                                                             <block>\r
 224                                                                                                 <set>\r
 225                                                                                                     <parameter name='tmpo.te-topo-id' value='`$network.te-topology-id`' />\r
 226                                                                                                 </set>\r
 227                                                                                             </block>\r
 228                                                                                         </outcome>\r
 229                                                                                     </switch>\r
 230                                                                                     <switch test="`length($tmpo.provider-id) == 0`">\r
 231                                                                                         <outcome value='true'>\r
 232                                                                                             <block>\r
 233                                                                                                 <set>\r
 234                                                                                                     <parameter name='tmpo.provider-id' value='`$network.provider-id`' />\r
 235                                                                                                 </set>\r
 236                                                                                             </block>\r
 237                                                                                         </outcome>\r
 238                                                                                     </switch>\r
 239                                                                                     <switch test='`$tmpo.te-topo-id`'>\r
 240                                                                                         <outcome value='1'>\r
 241                                                                                             <block>\r
 242                                                                                                 <set>\r
 243                                                                                                     <parameter name='network-otn.' value='`$topology.networks.network[$netidx].`' />\r
 244                                                                                                 </set>\r
 245                                                                                             </block>\r
 246                                                                                         </outcome>\r
 247                                                                                         <outcome value='2'>\r
 248                                                                                             <block>\r
 249                                                                                                 <set>\r
 250                                                                                                     <parameter name='network-eth.' value='`$topology.networks.network[$netidx].`' />\r
 251                                                                                                 </set>\r
 252                                                                                             </block>\r
 253                                                                                         </outcome>\r
 254                                                                                         <outcome value='11'>\r
 255                                                                                             <block>\r
 256                                                                                                 <set>\r
 257                                                                                                     <parameter name='network-otn.' value='`$topology.networks.network[$netidx].`' />\r
 258                                                                                                 </set>\r
 259                                                                                             </block>\r
 260                                                                                         </outcome>\r
 261                                                                                         <outcome value='33'>\r
 262                                                                                             <block>\r
 263                                                                                                 <set>\r
 264                                                                                                     <parameter name='network-eth.' value='`$topology.networks.network[$netidx].`' />\r
 265                                                                                                 </set>\r
 266                                                                                             </block>\r
 267                                                                                         </outcome>\r
 268                                                                                     </switch>\r
 269                                                                                 </block>\r
 270                                                                             </for>\r
 271                                                                             <call module='DataChange' rpc='update-tp-ttp-relationship' mode='sync' ></call>\r
 272                                                                         </block>\r
 273                                                                     </outcome>\r
 274                                                                 </switch>\r
 275                                                             </block>\r
 276                                                         </outcome>\r
 277                                                     </execute>\r
 278                                                 </outcome>\r
 279                                             </switch>\r
 280                                             <set>\r
 281                                                 <parameter name='input' value='ietf-subscribed-notifications:establish-subscription.input.' />\r
 282                                                 <parameter name="`$input + 'encoding'`" value="encode-json" />\r
 283                                             </set>\r
 284                                             <execute plugin='org.onap.ccsdk.sli.plugins.restconfdiscovery.RestconfDiscoveryNode' method='establishSubscription' >\r
 285                                                 <parameter name="subscriberId" value="sotn-controller" />\r
 286                                                 <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/restconf/operations/ietf-subscribed-notifications:establish-subscription'`" />\r
 287                                                 <parameter name="restapiUser" value="`$prop.sdncRestApi.thirdpartySdnc.user`" />\r
 288                                                 <parameter name="restapiPassword" value="`$prop.sdncRestApi.thirdpartySdnc.password`" />\r
 289                                                 <parameter name="sseConnectURL" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/restconf/streams/yang-push-json'`" />\r
 290                                                 <parameter name="dirPath" value="/opt/sdnc/restconfapi/yang/notification" />\r
 291                                                 <parameter name="format" value="json" />\r
 292                                                 <parameter name="httpMethod" value="post" />\r
 293                                                 <parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.jks"/>\r
 294                                                 <parameter name="trustStorePassword" value="adminadmin"/>\r
 295                                                 <parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>\r
 296                                                 <parameter name="keyStorePassword" value="adminadmin"/>\r
 297                                                 <parameter name='customHttpHeaders' value="`'X-ACCESS-TOKEN=' + $prop.sdncRestApi.token_id`" />\r
 298                                                 <parameter name="module" value="DataChange" />\r
 299                                                 <parameter name="rpc" value="sotn-notification-handler" />\r
 300                                                 <parameter name="mode" value="sync" />\r
 301                                             </execute>\r
 302                                         </block>\r
 303                                     </outcome>\r
 304                                     <outcome value='TAPI'>\r
 305                                         <block atomic="true">\r
 306                                             <execute plugin='org.onap.ccsdk.sli.plugins.restapicall.RestapiCallNode' method='sendRequest' >\r
 307                                                 <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/cxf/tapi/v2/topologies?topology-id-or-name=otn'`"/>\r
 308                                                 <parameter name="restapiUser" value="`$prop.sdncRestApi.thirdpartySdnc.user`"/>\r
 309                                                 <parameter name="restapiPassword" value="`$prop.sdncRestApi.thirdpartySdnc.password`"/>\r
 310                                                 <parameter name="format" value="json"/>\r
 311                                                 <parameter name="httpMethod" value="get"/>\r
 312                                                 <parameter name="responsePrefix" value="topologies"/>\r
 313                                                 <parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.tapi.jks"/>\r
 314                                                 <parameter name="trustStorePassword" value="adminadmin"/>\r
 315                                                 <parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>\r
 316                                                 <parameter name="keyStorePassword" value="adminadmin"/>\r
 317                                                 <outcome value='failure'>\r
 318                                                     <return status='failure'>\r
 319                                                         <parameter name='ack-final' value='Y'/>\r
 320                                                         <parameter name="error-code" value="500" />\r
 321                                                         <parameter name="error-message" value="Error executing get topology TAPI rest api" />\r
 322                                                     </return>\r
 323                                                 </outcome>\r
 324                                                 <outcome value='success'>\r
 325                                                     <block atomic="true">\r
 326                                                         <for index='tidx' start='0' end="`$topologies.topology_length`" >\r
 327                                                             <block>\r
 328                                                                 <set>\r
 329                                                                     <parameter name='topology.' value='`$topologies.topology[$tidx].`' />\r
 330                                                                 </set>\r
 331                                                                 <call module='DataChange' rpc='tapi-update-network-to-aai' mode='sync' ></call>\r
 332                                                             </block>\r
 333                                                         </for>\r
 334                                                     </block>\r
 335                                                 </outcome>\r
 336                                             </execute>\r
 337                                         </block>\r
 338                                     </outcome>\r
 339                                     <outcome value='MSA'>\r
 340                                         <block atomic="true">\r
 341                                             <execute plugin='org.onap.ccsdk.sli.plugins.restapicall.RestapiCallNode' method='sendRequest' >\r
 342                                                 <parameter name="restapiUrl" value="`$prop.sdncRestApi.thirdpartySdnc.url + '/cxf/openroadm/v2/networks/otn-topology'`"/>\r
 343                                                 <parameter name="restapiUser" value="`$prop.sdncRestApi.thirdpartySdnc.user`"/>\r
 344                                                 <parameter name="restapiPassword" value="`$prop.sdncRestApi.thirdpartySdnc.password`"/>\r
 345                                                 <parameter name="format" value="json"/>\r
 346                                                 <parameter name="httpMethod" value="get"/>\r
 347                                                 <parameter name="responsePrefix" value="networks"/>\r
 348                                                 <parameter name="trustStoreFileName" value="/opt/onap/sdnc/data/stores/truststore.onap.client.msa.jks"/>\r
 349                                                 <parameter name="trustStorePassword" value="adminadmin"/>\r
 350                                                 <parameter name="keyStoreFileName" value="/opt/onap/sdnc/data/stores/sdnc.p12"/>\r
 351                                                 <parameter name="keyStorePassword" value="adminadmin"/>\r
 352                                                 <outcome value='failure'>\r
 353                                                     <return status='failure'>\r
 354                                                         <parameter name='ack-final' value='Y'/>\r
 355                                                         <parameter name="error-code" value="500" />\r
 356                                                         <parameter name="error-message" value="Error executing get topology MSA rest api" />\r
 357                                                     </return>\r
 358                                                 </outcome>\r
 359                                                 <outcome value='success'>\r
 360                                                     <block atomic="true">\r
 361                                                         <call module='DataChange' rpc='msa-update-network-to-aai' mode='sync' ></call>\r
 362                                                     </block>\r
 363                                                 </outcome>\r
 364                                             </execute>\r
 365                                         </block>\r
 366                                     </outcome>\r
 367                                     <outcome value='Other'>\r
 368                                         <return status='failure'>\r
 369                                             <parameter name='ack-final' value='Y'/>\r
 370                                             <parameter name="error-code" value="500" />\r
 371                                             <parameter name="error-message" value="`'Unsupported type = ' + $prop.sdncRestApi.type`" />\r
 372                                         </return>\r
 373                                     </outcome>\r
 374                                 </switch>\r
 375                             </block>\r
 376                         </outcome>\r
 377                         <outcome value='Delete'>\r
 378                             <block atomic="true">\r
 379                                 <switch test="`$prop.sdncRestApi.type`">\r
 380                                     <outcome value='MSA'>\r
 381                                         <block atomic='true'>\r
 382                                             <set>\r
 383                                                 <parameter name='controllerid' value="`$prop.sdncRestApi.type + '_' + $prop.sdncRestApi.thirdpartySdnc.url + '_' + $prop.sdncRestApi.thirdpartySdnc.id`" />\r
 384                                             </set>\r
 385                                             <get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\r
 386                                                           key='SELECT controller_id\r
 387 from TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE\r
 388 WHERE controller_id = $controllerid'\r
 389                                                           pfx='dbcontrollerid'>\r
 390                                                 <outcome value='success'>\r
 391                                                     <delete plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource'\r
 392                                                             resource="SQL"\r
 393                                                             key="DELETE FROM TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE WHERE controller_id = $controllerid"></delete>\r
 394                                                 </outcome>\r
 395                                                 <outcome value='failure'>\r
 396                                                     <return status='failure'>\r
 397                                                         <parameter name='ack-final' value='Y'/>\r
 398                                                         <parameter name="error-code" value="500" />\r
 399                                                         <parameter name="error-message" value="Failure in getting controller-id from DB" />\r
 400                                                     </return>\r
 401                                                 </outcome>\r
 402                                                 <outcome value='not-found'>\r
 403                                                     <return status='failure'>\r
 404                                                         <parameter name='ack-final' value='Y'/>\r
 405                                                         <parameter name="error-code" value="500" />\r
 406                                                         <parameter name="error-message" value="controller-id could not be found in DB" />\r
 407                                                     </return>\r
 408                                                 </outcome>\r
 409                                             </get-resource>\r
 410                                         </block>\r
 411                                     </outcome>\r
 412                                     <outcome value='TAPI'>\r
 413                                         <block>\r
 414                                             <set>\r
 415                                                 <parameter name='controllerid' value="`$prop.sdncRestApi.type + '_' + $prop.sdncRestApi.thirdpartySdnc.url + '_' + $prop.sdncRestApi.thirdpartySdnc.id`" />\r
 416                                             </set>\r
 417                                             <get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\r
 418                                                           key='SELECT controller_id\r
 419 from TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE\r
 420 WHERE controller_id = $controllerid'\r
 421                                                           pfx='dbcontrollerid'>\r
 422                                                 <outcome value='success'>\r
 423                                                     <delete plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource'\r
 424                                                             resource="SQL"\r
 425                                                             key="DELETE FROM TOPOLOGY_LOGICAL_RELATION_TO_PINTERFACE WHERE controller_id = $controllerid"></delete>\r
 426                                                 </outcome>\r
 427                                                 <outcome value='failure'>\r
 428                                                     <return status='failure'>\r
 429                                                         <parameter name='ack-final' value='Y'/>\r
 430                                                         <parameter name="error-code" value="500" />\r
 431                                                         <parameter name="error-message" value="Failure in getting controller-id from DB" />\r
 432                                                     </return>\r
 433                                                 </outcome>\r
 434                                                 <outcome value='not-found'>\r
 435                                                     <return status='failure'>\r
 436                                                         <parameter name='ack-final' value='Y'/>\r
 437                                                         <parameter name="error-code" value="500" />\r
 438                                                         <parameter name="error-message" value="controller-id could not be found in DB" />\r
 439                                                     </return>\r
 440                                                 </outcome>\r
 441                                             </get-resource>\r
 442                                         </block>\r
 443                                     </outcome>\r
 444                                     <outcome value='Other'>\r
 445                                         <return status='failure'>\r
 446                                             <parameter name='ack-final' value='Y'/>\r
 447                                             <parameter name="error-code" value="500" />\r
 448                                             <parameter name="error-message" value="`'Unsupported type = ' + $prop.sdncRestApi.type`" />\r
 449                                         </return>\r
 450                                     </outcome>\r
 451                                 </switch>\r
 452                             </block>\r
 453                         </outcome>\r
 454                     </switch>\r
 455                 </outcome>\r
 456                 <outcome value='true'>\r
 457                     <call module='DataChange' rpc='esr-thirdparty-sdnc-of-zte' mode='sync' ></call>\r
 458                 </outcome>\r
 459             </switch>\r
 460         </block>\r
 461     </method>\r
 462 </service-logic>