Versions Compared

Old Version 5

changes.mady.by.user FREEMAN, BRIAN D

Saved on

compared with

New Version 6

changes.mady.by.user FREEMAN, BRIAN D

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleGENERIC-RESOURCE-API:service-topology-operation

[{"id":"d3b12978.a07958","type":"dgstart","name":"DGSTART","outputs":1,"x":155,"y":131.4136562347412,"z":"e8bc9b98.816858","wires":[["b7396d0e.8f0cc"]]},{"id":"b7396d0e.8f0cc","type":"service-logic","name":"GENERIC-RESOURCE-API 0.0.1","module":"GENERIC-RESOURCE-API","version":"0.0.1","comments":"","xml":"<service-logic xmlns='http://www.openecomp.org/sdnc/svclogic' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.openecomp.org/sdnc/svclogic ./svclogic.xsd' module='GENERIC-RESOURCE-API' version='0.0.1'>","outputs":1,"x":230.28570556640625,"y":171.6517677307129,"z":"e8bc9b98.816858","wires":[["9949b950.d0ee7"]]},{"id":"9949b950.d0ee7","type":"method","name":"method service-topology-operation","xml":"<method rpc='service-topology-operation' mode='sync'>\n","comments":"","outputs":1,"x":233.42862701416016,"y":211.4136505126953,"z":"e8bc9b98.816858","wires":[["f463b94c.1017b8"]]},{"id":"676a3420.723724","type":"comment","name":"service-topology-operation","info":"","comments":"","x":549.344856262207,"y":79,"z":"e8bc9b98.816858","wires":[]},{"id":"f463b94c.1017b8","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":229.5000457763672,"y":412.44050788879395,"z":"e8bc9b98.816858","wires":[["1e77fab1.a6aa75","825f49a.dfd4db8","2cafd6e.5e4402a","768022b2.920c34"]]},{"id":"1e77fab1.a6aa75","type":"returnSuccess","name":"return success","xml":"<return status='success'>\n<parameter name=\"ack-final-indicator\" value=\"Y\" />\n<parameter name=\"error-code\" value=\"200\" />\n<parameter name=\"error-message\" value=\"`$error-message`\" />\n","comments":"","x":513.3332977294922,"y":587.8426446914673,"z":"e8bc9b98.816858","wires":[]},{"id":"2cafd6e.5e4402a","type":"switchNode","name":"switch svc-action","xml":"<switch test='`$service-topology-operation-input.sdnc-request-header.svc-action`'>\n","comments":"","outputs":1,"x":520.0475387573242,"y":464.9374351501465,"z":"e8bc9b98.816858","wires":[["8afe9b00.96b448","bebf36ec.06d6a8","b6d909b3.c8e398","b20f571f.7a617"]]},{"id":"8afe9b00.96b448","type":"outcome","name":"assign","xml":"<outcome value='assign'>\n","comments":"","outputs":1,"x":730.8570785522461,"y":390.22325325012207,"z":"e8bc9b98.816858","wires":[["31220371.b6a3dc"]]},{"id":"bebf36ec.06d6a8","type":"outcome","name":"delete","xml":"<outcome value='delete'>\n","comments":"","outputs":1,"x":730.2380599975586,"y":484.747296333313,"z":"e8bc9b98.816858","wires":[["1cf1bc7b.a24e2c"]]},{"id":"b20f571f.7a617","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":729.2855987548828,"y":533.604061126709,"z":"e8bc9b98.816858","wires":[["d982d4e4.a1cbc8"]]},{"id":"825f49a.dfd4db8","type":"set","name":"copy input to service-data","xml":"<set>\n<parameter name='service-data.sdnc-request-header.' value='`$service-topology-operation-input.sdnc-request-header.`' />\n<parameter name='service-data.request-information.' value='`$service-topology-operation-input.request-information.`' />\n<parameter name='service-data.service-information.' value='`$service-topology-operation-input.service-information.`' />\n<parameter name='service-data.service-request-input.' value='`$service-topology-operation-input.service-request-input.`' />\n","comments":"","x":548.1547317504883,"y":332.63989543914795,"z":"e8bc9b98.816858","wires":[]},{"id":"d982d4e4.a1cbc8","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"`$service-topology-operation-input.sdnc-request-header.svc-action + ' is not a valid svc-action'`\" />\n","comments":"","x":905.4760437011719,"y":533.6041259765625,"z":"e8bc9b98.816858","wires":[]},{"id":"768022b2.920c34","type":"call","name":"call GENERIC-RESOURCE-API:validate-service-input","xml":"<call module='GENERIC-RESOURCE-API' rpc='validate-service-input' mode='sync' >\n","comments":"","outputs":1,"x":635.416633605957,"y":284.4613552093506,"z":"e8bc9b98.816858","wires":[[]]},{"id":"31220371.b6a3dc","type":"call","name":"call GENERIC-RESOURCE-API:service-topology-operation-assign","xml":"<call module='GENERIC-RESOURCE-API' rpc='service-topology-operation-assign' mode='sync' >\n","comments":"","outputs":1,"x":1071.9999313354492,"y":389.794713973999,"z":"e8bc9b98.816858","wires":[[]]},{"id":"3303275.e799858","type":"call","name":"call GENERIC-RESOURCE-API:service-topology-operation-deactivate","xml":"<call module='GENERIC-RESOURCE-API' rpc='service-topology-operation-deactivate' mode='sync' >\n","comments":"","outputs":1,"x":1084.999885559082,"y":436.7947082519531,"z":"e8bc9b98.816858","wires":[[]]},{"id":"1cf1bc7b.a24e2c","type":"call","name":"call GENERIC-RESOURCE-API:service-topology-operation-delete","xml":"<call module='GENERIC-RESOURCE-API' rpc='service-topology-operation-delete' mode='sync' >\n","comments":"","outputs":1,"x":1073.3331565856934,"y":485.46142768859863,"z":"e8bc9b98.816858","wires":[[]]},{"id":"b6d909b3.c8e398","type":"outcome","name":"deactivate","xml":"<outcome value='deactivate'>\n","comments":"","outputs":1,"x":741.6665267944336,"y":438.4613838195801,"z":"e8bc9b98.816858","wires":[["3303275.e799858"]]}]

Expand
titleGENERIC-RESOURCE-API:generate-unique-name

[{"id":"9c9c3e21.d56a6","type":"comment","name":"Validation of required data","info":"","comments":"","x":1056.88330078125,"y":613.7232250486102,"z":"815459fd.39651","wires":[]},{"id":"1a2b74f1.a32c9b","type":"dgstart","name":"DGSTART","outputs":1,"x":101.91905430385032,"y":183.4136562347412,"z":"815459fd.39651","wires":[["ad9cae41.b540d8"]]},{"id":"ad9cae41.b540d8","type":"service-logic","name":"GENERIC-RESOURCE-API 0.0.1","module":"GENERIC-RESOURCE-API","version":"0.0.1","comments":"","xml":"<service-logic xmlns='http://www.openecomp.org/sdnc/svclogic' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.openecomp.org/sdnc/svclogic ./svclogic.xsd' module='GENERIC-RESOURCE-API' version='0.0.1'>","outputs":1,"x":217.20476531982422,"y":224.6517734527588,"z":"815459fd.39651","wires":[["1aae3c3b.93e23c"]]},{"id":"1aae3c3b.93e23c","type":"method","name":"method generate-unique-name","xml":"<method rpc='generate-unique-name' mode='sync'>\n","comments":"","outputs":1,"x":173.2643585205078,"y":266.3303112302508,"z":"815459fd.39651","wires":[["be84dd11.a69268"]]},{"id":"4c99ddb7.73e334","type":"comment","name":"generate-unique-name","info":"Input arguments:\ngenerate-unique-name-input.index-table-name - name of INDEX table\ngenerate-unique-name-input.index-table-prefix-column - name of prefix column in above table\ngenerate-unique-name-input.name-table-name - name of table holding all generated names\ngenerate-unique-name-input.index-length - non-null digit if index should be fixed length\n\nOutput arguments:\ngenerate-unique-name-output.generated-name - generated name (null if error)\ngenerate-unique-name-output.error-message - error message (non-null if error)\n","comments":"","x":496.26391056605735,"y":131,"z":"815459fd.39651","wires":[]},{"id":"2bb7603f.2a5648","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":551.8000030517578,"y":1560.5834183011737,"z":"815459fd.39651","wires":[["d90c8046.641c58","f3b600f1.053738","5b526908.c19e1","31f4c41e.abe88c","31eb5844.7865e8","58d2ce6b.3b9048","41884cf2.29260c","ee4ab844.a42118","ef57f8e2.7c7d7","daa5fca3.255d2","abf49007.ade958"]]},{"id":"d90c8046.641c58","type":"switchNode","name":"switch generate-unique-name-input.index-table-name","xml":"<switch test='`$generate-unique-name-input.index-table-name`'>\n","comments":"","outputs":1,"x":993.4666900634766,"y":659.3333629880633,"z":"815459fd.39651","wires":[["8caf9197.8bb528"]]},{"id":"8caf9197.8bb528","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1323.466609954834,"y":659.3333524976458,"z":"815459fd.39651","wires":[["ade07c82.bdf0e8"]]},{"id":"ade07c82.bdf0e8","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.index-table-name not supplied' />\n","comments":"","x":1496.7999305725098,"y":659.333343914577,"z":"815459fd.39651","wires":[]},{"id":"f3b600f1.053738","type":"switchNode","name":"switch generate-unique-name-input.index-table-prefix-column","xml":"<switch test='`$generate-unique-name-input.index-table-prefix-column`'>\n","comments":"","outputs":1,"x":1018.4666595458984,"y":702.6666988645281,"z":"815459fd.39651","wires":[["3efc891.3f48576"]]},{"id":"3efc891.3f48576","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1321.7999229431152,"y":702.6666778836932,"z":"815459fd.39651","wires":[["9684f7fe.7a9ba"]]},{"id":"9684f7fe.7a9ba","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.index-table-prefix-column not supplied' />\n","comments":"","x":1495.1332397460938,"y":703.0000213895526,"z":"815459fd.39651","wires":[]},{"id":"5b526908.c19e1","type":"switchNode","name":"switch generate-unique-name-input.name-table-type","xml":"<switch test='`$generate-unique-name-input.name-table-type`'>\n","comments":"","outputs":1,"x":989.466667175293,"y":747.6666912351336,"z":"815459fd.39651","wires":[["d262123e.4ea1f8"]]},{"id":"d262123e.4ea1f8","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1321.7998638153076,"y":747.6667007718768,"z":"815459fd.39651","wires":[["f30d92b5.aedcd"]]},{"id":"f30d92b5.aedcd","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.name-table-type not supplied' />\n","comments":"","x":1493.466640472412,"y":748.0000042234149,"z":"815459fd.39651","wires":[]},{"id":"41884cf2.29260c","type":"get-resource","name":"get-resource current name index","xml":"<get-resource plugin='org.openecomp.sdnc.sli.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.prefixdb'>\n\n","comments":"","outputs":1,"x":921.1332702636719,"y":1188.428392818996,"z":"815459fd.39651","wires":[["79c4efc5.45a2e8","302b87aa.f8d91","14f2d9a0.55df8e"]]},{"id":"79c4efc5.45a2e8","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1146.3237380981445,"y":1266.9522995267596,"z":"815459fd.39651","wires":[["b0d87954.ac2c18"]]},{"id":"b0d87954.ac2c18","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Error reading the ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n","comments":"","x":1308.9428596496582,"y":1268.3810276303973,"z":"815459fd.39651","wires":[]},{"id":"3439b70a.51c228","type":"for","name":"for idx from current index to list-end","xml":"<for index='tmp.gun.idx' start='`$tmp.gun.index-number`' end='`$tmp.gun.list-end`' >\n","comments":"","outputs":1,"x":1073.4666748046875,"y":1591.0000085830688,"z":"815459fd.39651","wires":[["13f86661.e45112"]]},{"id":"31f4c41e.abe88c","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":836.0856704711914,"y":1590.9999737058367,"z":"815459fd.39651","wires":[["3439b70a.51c228","749952fe.f825bc"]]},{"id":"749952fe.f825bc","type":"returnSuccess","name":"CATCH BREAK","xml":"<return status='success'>\n\n","comments":"","x":1024.4190826416016,"y":2166.0001043592183,"z":"815459fd.39651","wires":[]},{"id":"31eb5844.7865e8","type":"switchNode","name":"switch generate-unique-name-input.prefix","xml":"<switch test='`$generate-unique-name-input.prefix`'>\n","comments":"","outputs":1,"x":955.1333084106445,"y":792.6666702542987,"z":"815459fd.39651","wires":[["3ccdcc9d.5093ec"]]},{"id":"3ccdcc9d.5093ec","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1322.4664974212646,"y":792.6666950498309,"z":"815459fd.39651","wires":[["e5203ace.1332"]]},{"id":"e5203ace.1332","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.prefix not supplied' />\n","comments":"","x":1495.1332740783691,"y":792.999998501369,"z":"815459fd.39651","wires":[]},{"id":"58d2ce6b.3b9048","type":"switchNode","name":"switch generate-unique-name-input.index-length","xml":"<switch test='`$generate-unique-name-input.index-length`'>\n","comments":"","outputs":1,"x":978.4666748046875,"y":927.6666120801654,"z":"815459fd.39651","wires":[["d829997c.7eec1","1f4a169e.20ea29","23c759c7.75726e","b452d05b.906ab8","28d2099f.32a4c6"]]},{"id":"d829997c.7eec1","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1321.7999877929688,"y":835.999998501369,"z":"815459fd.39651","wires":[["c26b3e39.74464"]]},{"id":"28d2099f.32a4c6","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":1319.1333770751953,"y":1012.6666588102069,"z":"815459fd.39651","wires":[["cd46a64b.182b58"]]},{"id":"1f4a169e.20ea29","type":"outcome","name":"1","xml":"<outcome value='1'>\n","comments":"","outputs":1,"x":1320.1333351135254,"y":881.0000385556903,"z":"815459fd.39651","wires":[["b6096d92.9495b"]]},{"id":"23c759c7.75726e","type":"outcome","name":"2","xml":"<outcome value='2'>\n","comments":"","outputs":1,"x":1320.1333198547363,"y":926.0000290189471,"z":"815459fd.39651","wires":[["31ef97e2.d79f58"]]},{"id":"b452d05b.906ab8","type":"outcome","name":"3","xml":"<outcome value='3'>\n","comments":"","outputs":1,"x":1318.4666557312012,"y":969.3333648954119,"z":"815459fd.39651","wires":[["10d523e0.83151c"]]},{"id":"b6096d92.9495b","type":"set","name":"set list-end = 10","xml":"<set>\n<parameter name='tmp.gun.list-end' value='10' />\n","comments":"","x":1502.8000717163086,"y":881.0000271115985,"z":"815459fd.39651","wires":[]},{"id":"31ef97e2.d79f58","type":"set","name":"set list-end = 100","xml":"<set>\n<parameter name='tmp.gun.list-end' value='100' />\n","comments":"","x":1506.13330078125,"y":926.0000290189471,"z":"815459fd.39651","wires":[]},{"id":"10d523e0.83151c","type":"set","name":"set list-end = 1000","xml":"<set>\n<parameter name='tmp.gun.list-end' value='1000' />\n","comments":"","x":1508.13330078125,"y":969.3333420072283,"z":"815459fd.39651","wires":[]},{"id":"cd46a64b.182b58","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.prefix not supplied' />\n","comments":"","x":1490.13330078125,"y":1012.0000290189471,"z":"815459fd.39651","wires":[]},{"id":"adc50be3.80b89","type":"set","name":"set new index number to 1","xml":"<set>\n<parameter name='tmp.gun.index-number' value='1' />\n","comments":"","x":1481.5620803833008,"y":1211.5716842923846,"z":"815459fd.39651","wires":[]},{"id":"c26b3e39.74464","type":"set","name":"set list-end = 10000 (infinity basically)","xml":"<set>\n<parameter name='tmp.gun.list-end' value='10000' />\n","comments":"","x":1570.7999267578125,"y":836.3333420072283,"z":"815459fd.39651","wires":[]},{"id":"a52ed35f.a619d","type":"switchNode","name":"switch generate-unique-name-input.index-length","xml":"<switch test='`$generate-unique-name-input.index-length`'>\n","comments":"","outputs":1,"x":1635.1332550048828,"y":1517.666647366115,"z":"815459fd.39651","wires":[["82fa14d.9b847e8","b2207f7b.dc1388","df3ec92d.7f2b1","eeade36e.4e62"]]},{"id":"82fa14d.9b847e8","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1915.1332550048828,"y":1447.6667084012713,"z":"815459fd.39651","wires":[["97c34052.dfceb"]]},{"id":"b2207f7b.dc1388","type":"outcome","name":"1","xml":"<outcome value='1'>\n","comments":"","outputs":1,"x":1913.4666023254395,"y":1492.6667484555926,"z":"815459fd.39651","wires":[["97c34052.dfceb"]]},{"id":"df3ec92d.7f2b1","type":"outcome","name":"2","xml":"<outcome value='2'>\n","comments":"","outputs":1,"x":1913.4666900634766,"y":1546.0000957761492,"z":"815459fd.39651","wires":[["40b75c28.7bace4"]]},{"id":"eeade36e.4e62","type":"outcome","name":"3","xml":"<outcome value='3'>\n","comments":"","outputs":1,"x":1913.466567993164,"y":1642.6668285642352,"z":"815459fd.39651","wires":[["2e943d4c.f74eb2"]]},{"id":"97c34052.dfceb","type":"set","name":"set index-string to idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n","comments":"","x":2100.133403778076,"y":1466.0000519071307,"z":"815459fd.39651","wires":[]},{"id":"40b75c28.7bace4","type":"switchNode","name":"switch idx < 10","xml":"<switch test='`$tmp.gun.idx &lt; 10`'>\n","comments":"","outputs":1,"x":2080.1333198547363,"y":1545.9999937329974,"z":"815459fd.39651","wires":[["8304e65a.4b4b4","2ce6a205.cb4ece"]]},{"id":"8304e65a.4b4b4","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":2241.7999534606934,"y":1519.3333668027606,"z":"815459fd.39651","wires":[["d99e4d51.ae11d"]]},{"id":"2ce6a205.cb4ece","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":2241.7999114990234,"y":1567.6667026792254,"z":"815459fd.39651","wires":[["b2113d97.bcb05"]]},{"id":"d99e4d51.ae11d","type":"set","name":"set index-string to '0' + idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n","comments":"","x":2433.46671295166,"y":1518.6665939603533,"z":"815459fd.39651","wires":[]},{"id":"b2113d97.bcb05","type":"set","name":"set index-string to idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n","comments":"","x":2416.799964904785,"y":1567.3333095823016,"z":"815459fd.39651","wires":[]},{"id":"2e943d4c.f74eb2","type":"switchNode","name":"switch idx < 10","xml":"<switch test='`$tmp.gun.idx &lt; 10`'>\n","comments":"","outputs":1,"x":2081.799903869629,"y":1640.999956539699,"z":"815459fd.39651","wires":[["ec7f858.347ae78","9979b662.4c54d"]]},{"id":"ec7f858.347ae78","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":2241.7998809814453,"y":1614.3333343778338,"z":"815459fd.39651","wires":[["aea9e66b.e585e8"]]},{"id":"9979b662.4c54d","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":2243.466537475586,"y":1689.3332924161639,"z":"815459fd.39651","wires":[["4612898e.25b698"]]},{"id":"aea9e66b.e585e8","type":"set","name":"set index-string to '00' + idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '00' + $tmp.gun.idx`\" />\n","comments":"","x":2436.7999725341797,"y":1614.3332252502441,"z":"815459fd.39651","wires":[]},{"id":"4612898e.25b698","type":"switchNode","name":"switch idx < 100","xml":"<switch test='`$tmp.gun.idx &lt; 100`'>\n","comments":"","outputs":1,"x":2399.799919128418,"y":1687.666653088161,"z":"815459fd.39651","wires":[["cb47dfbc.885b68","3880cbe0.99a1b4"]]},{"id":"cb47dfbc.885b68","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":2556.7998962402344,"y":1661.0000309262957,"z":"815459fd.39651","wires":[["88ab4486.8cf4c"]]},{"id":"3880cbe0.99a1b4","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":2556.7998542785645,"y":1709.3333668027606,"z":"815459fd.39651","wires":[["3cd1d056.0e4eb"]]},{"id":"88ab4486.8cf4c","type":"set","name":"set index-string to '0' + idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n","comments":"","x":2749.466682434082,"y":1660.6666855130877,"z":"815459fd.39651","wires":[]},{"id":"3cd1d056.0e4eb","type":"set","name":"set index-string to idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n","comments":"","x":2733.466667175293,"y":1708.9999889646258,"z":"815459fd.39651","wires":[]},{"id":"ede00228.67c58","type":"set","name":"set generated-name to prefix + index-string","xml":"<set>\n<parameter name='tmp.gun.generated-name' value='`$generate-unique-name-input.prefix + $tmp.gun.index-string`' />\n","comments":"","x":1619.1333465576172,"y":1794.3332962308612,"z":"815459fd.39651","wires":[]},{"id":"a20f8849.e271d8","type":"set","name":"increment index number","xml":"<set>\n<parameter name='tmp.gun.index-number' value='`$tmp.gun.prefixdb.index-number + 1`' />\n","comments":"","x":1473.4666748046875,"y":1121.6190225396838,"z":"815459fd.39651","wires":[]},{"id":"a7b80904.72e65","type":"comment","name":"First check from the current index to the max index","info":"","comments":"","x":1036.8000183105469,"y":1529.333377293178,"z":"815459fd.39651","wires":[]},{"id":"1f33f7de.a26d8","type":"comment","name":"check if we've used this name before","info":"","comments":"","x":1615.8478698730469,"y":1878.619441986084,"z":"815459fd.39651","wires":[]},{"id":"f1cdba00.3ba7b","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1723.4666709899902,"y":1956.000224522182,"z":"815459fd.39651","wires":[["c8e5bd88.33f2c"]]},{"id":"e2012ba9.7a3398","type":"set","name":"set generate-unique-name-output.error-message","xml":"<set>\n<parameter name='generate-unique-name-output.error-message' value=\"`'Error reading the GENERIC_RESOURCE_NAME table'`\" />\n","comments":"","x":2169.4189224243164,"y":1929.5715574537005,"z":"815459fd.39651","wires":[]},{"id":"ef751cba.ba39c","type":"returnFailure","name":"BREAK","xml":"<return status='failure'>\n","comments":"","x":2034.657169342041,"y":1974.5716451917376,"z":"815459fd.39651","wires":[]},{"id":"1aaa10fa.b84327","type":"returnFailure","name":"BREAK","xml":"<return status='failure'>\n","comments":"","x":2037.5141906738281,"y":2069.4763359342305,"z":"815459fd.39651","wires":[]},{"id":"7cd6c217.f307b4","type":"comment","name":"found one we can use","info":"","comments":"","x":1855.3716468811035,"y":2000.5242580686297,"z":"815459fd.39651","wires":[]},{"id":"ee4ab844.a42118","type":"switchNode","name":"switch generate-unique-name-output.error-message","xml":"<switch test='`$generate-unique-name-output.error-message`'>\n","comments":"","outputs":1,"x":987.6333618164062,"y":2283.857244900295,"z":"815459fd.39651","wires":[["867fce46.b695c","d0e39f9f.c2b31"]]},{"id":"867fce46.b695c","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1260.9667701721191,"y":2257.19049685342,"z":"815459fd.39651","wires":[["7571ec9c.5b8d1c"]]},{"id":"7571ec9c.5b8d1c","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1395.9667701721191,"y":2257.19049685342,"z":"815459fd.39651","wires":[[]]},{"id":"d0e39f9f.c2b31","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":1260.9667358398438,"y":2307.190517834255,"z":"815459fd.39651","wires":[["ae2f9429.00a2d"]]},{"id":"ae2f9429.00a2d","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n","comments":"","x":1410.9667358398438,"y":2307.190517834255,"z":"815459fd.39651","wires":[]},{"id":"ef57f8e2.7c7d7","type":"switchNode","name":"switch found-flag","xml":"<switch test='`$tmp.gun.found-flag`'>\n","comments":"","outputs":1,"x":859.3476715087891,"y":2566.7143644605367,"z":"815459fd.39651","wires":[["c14ca26.de4e86","a2c0f526.551af8"]]},{"id":"c14ca26.de4e86","type":"outcome","name":"true","xml":"<outcome value='true'>","comments":"","outputs":1,"x":1033.6810111999512,"y":2566.714365414211,"z":"815459fd.39651","wires":[["61435f31.cb022"]]},{"id":"8be111ce.28a5e8","type":"set","name":"set generate-unique-name-output.generated-name","xml":"<set>\n<parameter name='generate-unique-name-output.generated-name' value='`$tmp.gun.generated-name`' />\n","comments":"","x":1504.3476257324219,"y":2411.714651516506,"z":"815459fd.39651","wires":[]},{"id":"94df5fb4.706fb","type":"returnSuccess","name":"return success","xml":"<return status='success'>\n","comments":"","x":1386.3951950073242,"y":2749.0954460416524,"z":"815459fd.39651","wires":[]},{"id":"61435f31.cb022","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1185.347640991211,"y":2566.04777949197,"z":"815459fd.39651","wires":[["8be111ce.28a5e8","78663c74.7673a4","3451e34f.617e34","94df5fb4.706fb","b7b12523.204aa8"]]},{"id":"af0bf984.64fc58","type":"set","name":"set index-exists flag to false","xml":"<set>\n<parameter name='tmp.gun.index-exists' value='false' />\n","comments":"","x":1485.6094665527344,"y":1165.2857441220965,"z":"815459fd.39651","wires":[]},{"id":"f7e17554.31eec","type":"set","name":"set index-exists flag to true","xml":"<set>\n<parameter name='tmp.gun.index-exists' value='true' />\n","comments":"","x":1481.7524795532227,"y":1076.7142965112414,"z":"815459fd.39651","wires":[]},{"id":"b1142e6.2fc40d","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1288.4667510986328,"y":1098.1429025445666,"z":"815459fd.39651","wires":[["f7e17554.31eec","a20f8849.e271d8"]]},{"id":"78663c74.7673a4","type":"switchNode","name":"switch index-exists","xml":"<switch test='`$tmp.gun.index-exists`'>\n","comments":"","outputs":1,"x":1400.109634399414,"y":2543.8576530729024,"z":"815459fd.39651","wires":[["1fcd6a56.015186","7267f95c.67caf8"]]},{"id":"1fcd6a56.015186","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":1578.6809997558594,"y":2519.5719208036153,"z":"815459fd.39651","wires":[["5b9b847.579547c"]]},{"id":"7267f95c.67caf8","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":1578.6810150146484,"y":2566.7148460660665,"z":"815459fd.39651","wires":[["7027ae6b.f4b178"]]},{"id":"89c7c8c8.b5d17","type":"save","name":"save (update) name index","xml":"<save plugin='org.openecomp.sdnc.sli.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":1974.3953247070312,"y":2521.0003370557515,"z":"815459fd.39651","wires":[["c4bb1f67.2b8208"]]},{"id":"6b1a2c58.f6463c","type":"save","name":"save (insert) name index","xml":"<save plugin='org.openecomp.sdnc.sli.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":1967.2523040771484,"y":2615.285805157253,"z":"815459fd.39651","wires":[["2efbba48.fa9f46"]]},{"id":"c4bb1f67.2b8208","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2167.25252532959,"y":2521.000356129238,"z":"815459fd.39651","wires":[["de5804d8.43d0a"]]},{"id":"2efbba48.fa9f46","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2164.3950958251953,"y":2613.8573211942403,"z":"815459fd.39651","wires":[["1461e83f.8fcd2"]]},{"id":"3451e34f.617e34","type":"save","name":"save (insert) generated name","xml":"<save plugin='org.openecomp.sdnc.sli.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":1434.538230895996,"y":2702.428627422878,"z":"815459fd.39651","wires":[["38c79c2c.b4756c"]]},{"id":"38c79c2c.b4756c","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1644.5381622314453,"y":2702.428678921291,"z":"815459fd.39651","wires":[["ab33c5a7.dcc0b8"]]},{"id":"ab33c5a7.dcc0b8","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"Failed insert into GENERIC_RESOURCE_NAME table\" />\n","comments":"","x":1798.8239784240723,"y":2702.4286979947774,"z":"815459fd.39651","wires":[]},{"id":"daa5fca3.255d2","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from ' + $generate-unique-name-input.index-table-name\n+ ' WHERE ' + $generate-unique-name-input.index-table-prefix-column + ' = '\n+ '$generate-unique-name-input.prefix'`\" />\n","comments":"","x":877.0381546020508,"y":1056.7143959317889,"z":"815459fd.39651","wires":[]},{"id":"13f86661.e45112","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1315.6095352172852,"y":1589.5714878354754,"z":"815459fd.39651","wires":[["a52ed35f.a619d","ede00228.67c58","2f2db390.dd18b4","5e3d7ef1.ce61d"]]},{"id":"c8e5bd88.33f2c","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1875.8476676940918,"y":1955.5241436277117,"z":"815459fd.39651","wires":[["e2012ba9.7a3398","ef751cba.ba39c"]]},{"id":"5b9b847.579547c","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1755.966812133789,"y":2496.714449337551,"z":"815459fd.39651","wires":[["27cff0af.71a1a8","89c7c8c8.b5d17"]]},{"id":"7027ae6b.f4b178","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1753.1096649169922,"y":2592.4287676130025,"z":"815459fd.39651","wires":[["6b1a2c58.f6463c","efa8896f.d07148"]]},{"id":"27cff0af.71a1a8","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'update ' + $generate-unique-name-input.index-table-name\n+ ' set index_number = ' + $tmp.gun.index-string + ' where '\n+ $generate-unique-name-input.index-table-prefix-column\n+ ' = $generate-unique-name-input.prefix'`\" />\n","comments":"","x":1944.5380935668945,"y":2472.4284209523885,"z":"815459fd.39651","wires":[]},{"id":"efa8896f.d07148","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into ' + $generate-unique-name-input.index-table-name\n+ '(' + $generate-unique-name-input.index-table-prefix-column + ', index_number) values ('\n+ ' $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ')'`\" />\n\n","comments":"","x":1943.1096420288086,"y":2566.7142376218526,"z":"815459fd.39651","wires":[]},{"id":"6dccc1ef.da102","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":1730.1334075927734,"y":2046.95261996133,"z":"815459fd.39651","wires":[["e3aca01e.dacec"]]},{"id":"c78eb88f.146498","type":"for","name":"for idx from 1 to current index","xml":"<for index='tmp.gun.idx' start='1' end='`$tmp.gun.index-number`' >\n","comments":"","outputs":1,"x":1579.9191818237305,"y":3158.666769436428,"z":"815459fd.39651","wires":[["2219e93c.e8ff8e"]]},{"id":"51214751.d1fbc8","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1348.2524642944336,"y":3158.666770390102,"z":"815459fd.39651","wires":[["c78eb88f.146498","9ec3e778.91151"]]},{"id":"9ec3e778.91151","type":"returnSuccess","name":"CATCH BREAK","xml":"<return status='success'>\n\n","comments":"","x":1530.8715744018555,"y":3733.666900089809,"z":"815459fd.39651","wires":[]},{"id":"28764d7d.c7ac2a","type":"switchNode","name":"switch generate-unique-name-input.index-length","xml":"<switch test='`$generate-unique-name-input.index-length`'>\n","comments":"","outputs":1,"x":2141.5857467651367,"y":3085.333443096706,"z":"815459fd.39651","wires":[["4cc90e35.6869f8","e1c92d6d.bc2058","c2b50e5a.f02478","a85fdf7a.d2add8"]]},{"id":"4cc90e35.6869f8","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":2421.5857467651367,"y":3015.3335041318624,"z":"815459fd.39651","wires":[["37efe12d.5853c6"]]},{"id":"e1c92d6d.bc2058","type":"outcome","name":"1","xml":"<outcome value='1'>\n","comments":"","outputs":1,"x":2419.9190940856934,"y":3060.3335441861836,"z":"815459fd.39651","wires":[["37efe12d.5853c6"]]},{"id":"c2b50e5a.f02478","type":"outcome","name":"2","xml":"<outcome value='2'>\n","comments":"","outputs":1,"x":2419.9191818237305,"y":3113.6668915067403,"z":"815459fd.39651","wires":[["53bbce6e.e9ae08"]]},{"id":"a85fdf7a.d2add8","type":"outcome","name":"3","xml":"<outcome value='3'>\n","comments":"","outputs":1,"x":2419.919059753418,"y":3210.333624294826,"z":"815459fd.39651","wires":[["708c9f01.058a58"]]},{"id":"37efe12d.5853c6","type":"set","name":"set index-string to idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n","comments":"","x":2606.58589553833,"y":3033.6668476377217,"z":"815459fd.39651","wires":[]},{"id":"53bbce6e.e9ae08","type":"switchNode","name":"switch idx < 10","xml":"<switch test='`$tmp.gun.idx &lt; 10`'>\n","comments":"","outputs":1,"x":2586.5858116149902,"y":3113.6667894635884,"z":"815459fd.39651","wires":[["8575fd95.1a2cb8","faa37e9e.cbd588"]]},{"id":"8575fd95.1a2cb8","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":2748.2524452209473,"y":3087.0001625333516,"z":"815459fd.39651","wires":[["c9f6db90.ed3bf"]]},{"id":"faa37e9e.cbd588","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":2748.2524032592773,"y":3135.3334984098165,"z":"815459fd.39651","wires":[["ffe607ad.1291a"]]},{"id":"c9f6db90.ed3bf","type":"set","name":"set index-string to '0' + idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n","comments":"","x":2939.919204711914,"y":3086.3333896909444,"z":"815459fd.39651","wires":[]},{"id":"ffe607ad.1291a","type":"set","name":"set index-string to idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n","comments":"","x":2923.252456665039,"y":3135.0001053128926,"z":"815459fd.39651","wires":[]},{"id":"708c9f01.058a58","type":"switchNode","name":"switch idx < 10","xml":"<switch test='`$tmp.gun.idx &lt; 10`'>\n","comments":"","outputs":1,"x":2588.252395629883,"y":3208.66675227029,"z":"815459fd.39651","wires":[["97d62512.465b4","a56b7f05.7ee6d8"]]},{"id":"97d62512.465b4","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":2748.252372741699,"y":3182.000130108425,"z":"815459fd.39651","wires":[["9544c9f9.8b8d88"]]},{"id":"a56b7f05.7ee6d8","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":2749.91902923584,"y":3257.000088146755,"z":"815459fd.39651","wires":[["6af6f8d2.5bdff8"]]},{"id":"9544c9f9.8b8d88","type":"set","name":"set index-string to '00' + idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '00' + $tmp.gun.idx`\" />\n","comments":"","x":2943.252456665039,"y":3182.0001053128926,"z":"815459fd.39651","wires":[]},{"id":"6af6f8d2.5bdff8","type":"switchNode","name":"switch idx < 100","xml":"<switch test='`$tmp.gun.idx &lt; 100`'>\n","comments":"","outputs":1,"x":2906.252410888672,"y":3255.333448818752,"z":"815459fd.39651","wires":[["d2f6dac3.3067","f1aef370.1dca"]]},{"id":"d2f6dac3.3067","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":3063.2523880004883,"y":3228.6668266568868,"z":"815459fd.39651","wires":[["a3f93c09.b94c68"]]},{"id":"f1aef370.1dca","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":3063.2523460388184,"y":3277.0001625333516,"z":"815459fd.39651","wires":[["66b5ce47.00de2"]]},{"id":"a3f93c09.b94c68","type":"set","name":"set index-string to '0' + idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n","comments":"","x":3255.919174194336,"y":3228.3334812436788,"z":"815459fd.39651","wires":[]},{"id":"66b5ce47.00de2","type":"set","name":"set index-string to idx","xml":"<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n","comments":"","x":3239.919158935547,"y":3276.666784695217,"z":"815459fd.39651","wires":[]},{"id":"bdd6fd62.a7a3e8","type":"set","name":"set generated-name to prefix + index-string","xml":"<set>\n<parameter name='tmp.gun.generated-name' value='`$generate-unique-name-input.prefix + $tmp.gun.index-string`' />\n","comments":"","x":2125.585838317871,"y":3362.000091961452,"z":"815459fd.39651","wires":[]},{"id":"34bd9b51.b0f2c4","type":"comment","name":"Wrapping around - now check from 1 to the original index","info":"","comments":"","x":1553.2524948120117,"y":3044.143176487514,"z":"815459fd.39651","wires":[]},{"id":"e4c738b5.09d83","type":"comment","name":"check if we've used this name before","info":"","comments":"","x":2112.3002853393555,"y":3477.000365665981,"z":"815459fd.39651","wires":[]},{"id":"583c6a04.040e64","type":"get-resource","name":"get-resource name","xml":"<get-resource plugin='org.openecomp.sdnc.sli.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n","comments":"","outputs":1,"x":2049.919101715088,"y":3617.7144355773926,"z":"815459fd.39651","wires":[["89bf2160.dfb7b","baf26552.043b48"]]},{"id":"89bf2160.dfb7b","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2228.2524948120117,"y":3572.000272205898,"z":"815459fd.39651","wires":[["fb8fc079.1e77d8"]]},{"id":"2da0ea47.c121be","type":"set","name":"set generate-unique-name-output.error-message","xml":"<set>\n<parameter name='generate-unique-name-output.error-message' value=\"Error reading the GENERIC_RESOURCE_NAME table\" />\n","comments":"","x":2674.204746246338,"y":3545.5716051374166,"z":"815459fd.39651","wires":[]},{"id":"958fa098.04d968","type":"returnFailure","name":"BREAK","xml":"<return status='failure'>\n","comments":"","x":2539.4429931640625,"y":3590.5716928754537,"z":"815459fd.39651","wires":[]},{"id":"a607bdc.33f884","type":"switchNode","name":"switch generate-unique-name-output.error-message","xml":"<switch test='`$generate-unique-name-output.error-message`'>\n","comments":"","outputs":1,"x":1512.3000717163086,"y":3841.5239757810323,"z":"815459fd.39651","wires":[["fb21ca76.e6a0a8","cbee8463.5abd"]]},{"id":"fb21ca76.e6a0a8","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1785.6334800720215,"y":3814.8572277341573,"z":"815459fd.39651","wires":[["ae2192.db98be7"]]},{"id":"ae2192.db98be7","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1920.6334800720215,"y":3814.8572277341573,"z":"815459fd.39651","wires":[[]]},{"id":"cbee8463.5abd","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":1785.633445739746,"y":3864.8572487149922,"z":"815459fd.39651","wires":[["7488c39d.2fc9e4"]]},{"id":"7488c39d.2fc9e4","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n","comments":"","x":1935.633445739746,"y":3864.8572487149922,"z":"815459fd.39651","wires":[]},{"id":"968630d4.e3ba48","type":"switchNode","name":"switch found-flag","xml":"<switch test='`$tmp.gun.found-flag`'>\n","comments":"","outputs":1,"x":1394.0143508911133,"y":4021.0478843961446,"z":"815459fd.39651","wires":[["87fd4f0e.54aa38"]]},{"id":"d7f720b6.d1e378","type":"comment","name":"if db name is null we found an index we can use","info":"","comments":"","x":1560.7286911010742,"y":3970.5716594968526,"z":"815459fd.39651","wires":[]},{"id":"87fd4f0e.54aa38","type":"outcome","name":"true","xml":"<outcome value='true'>","comments":"","outputs":1,"x":1553.347671508789,"y":4021.0478414808003,"z":"815459fd.39651","wires":[["5b0ac020.1d8c"]]},{"id":"3b64abd.46fced4","type":"set","name":"set generate-unique-name-output.generated-name","xml":"<set>\n<parameter name='generate-unique-name-output.generated-name' value='`$tmp.gun.generated-name`' />\n","comments":"","x":2029.0143356323242,"y":3969.381382397243,"z":"815459fd.39651","wires":[]},{"id":"5157d8a.7aec1a8","type":"returnSuccess","name":"return success","xml":"<return status='success'>\n<parameter name='' value='' />\n","comments":"","x":1912.4903869628906,"y":4308.190853527614,"z":"815459fd.39651","wires":[]},{"id":"5b0ac020.1d8c","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1720.0143661499023,"y":4019.3810600553243,"z":"815459fd.39651","wires":[["3b64abd.46fced4","8ca17448.865688","18c7df12.c8f449","5157d8a.7aec1a8","30fee1b0.328f4e"]]},{"id":"8ca17448.865688","type":"switchNode","name":"switch index-exists","xml":"<switch test='`$tmp.gun.index-exists`'>\n","comments":"","outputs":1,"x":1924.7763442993164,"y":4101.52438395364,"z":"815459fd.39651","wires":[["faef6e.b983209","4fa5fc45.9536a4"]]},{"id":"faef6e.b983209","type":"outcomeTrue","name":"true","xml":"<outcome value='true'>\n","comments":"","outputs":1,"x":2103.3477096557617,"y":4077.2386516843526,"z":"815459fd.39651","wires":[["746a09f3.f97ea"]]},{"id":"4fa5fc45.9536a4","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":2103.347724914551,"y":4124.381576946804,"z":"815459fd.39651","wires":[["c45a5e4b.d362e"]]},{"id":"f7b6e1cf.1a20f8","type":"save","name":"save (update) name index","xml":"<save plugin='org.openecomp.sdnc.sli.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":2499.0620346069336,"y":4078.667067936489,"z":"815459fd.39651","wires":[["b4fa42a7.4de6f"]]},{"id":"9290ec28.871b68","type":"save","name":"save (insert) name index","xml":"<save plugin='org.openecomp.sdnc.sli.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":2491.919013977051,"y":4172.95253603799,"z":"815459fd.39651","wires":[["d67c7a4a.4b9318"]]},{"id":"b4fa42a7.4de6f","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2691.919235229492,"y":4078.667087009975,"z":"815459fd.39651","wires":[["36b7cb6f.1526e4"]]},{"id":"36b7cb6f.1526e4","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to update ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n","comments":"","x":2846.205051422119,"y":4078.6671060834615,"z":"815459fd.39651","wires":[]},{"id":"d67c7a4a.4b9318","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2689.0618057250977,"y":4171.524052074978,"z":"815459fd.39651","wires":[["781ae51.5db729c"]]},{"id":"781ae51.5db729c","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to insert record into ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n","comments":"","x":2843.3476219177246,"y":4171.524071148464,"z":"815459fd.39651","wires":[]},{"id":"18c7df12.c8f449","type":"save","name":"save (insert) generated name","xml":"<save plugin='org.openecomp.sdnc.sli.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":1959.2049407958984,"y":4260.095358303615,"z":"815459fd.39651","wires":[["28aac08f.ba9f6"]]},{"id":"28aac08f.ba9f6","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":2169.2048721313477,"y":4260.095409802028,"z":"815459fd.39651","wires":[["84a0c5c3.0e38f"]]},{"id":"84a0c5c3.0e38f","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"Failed insert into GENERIC_RESOURCE_NAME table\" />\n","comments":"","x":2323.4906883239746,"y":4260.095428875515,"z":"815459fd.39651","wires":[]},{"id":"2219e93c.e8ff8e","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1822.062026977539,"y":3157.2382835660665,"z":"815459fd.39651","wires":[["28764d7d.c7ac2a","bdd6fd62.a7a3e8","583c6a04.040e64","6a15e97a.43887","552d7ff7.e47298"]]},{"id":"fb8fc079.1e77d8","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":2380.6334915161133,"y":3571.524191311428,"z":"815459fd.39651","wires":[["2da0ea47.c121be","958fa098.04d968"]]},{"id":"746a09f3.f97ea","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":2280.6335220336914,"y":4054.381180218288,"z":"815459fd.39651","wires":[["5a80e34c.340e54","f7b6e1cf.1a20f8"]]},{"id":"c45a5e4b.d362e","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":2277.7763748168945,"y":4150.09549849374,"z":"815459fd.39651","wires":[["9290ec28.871b68","bf62ad1c.b880a8"]]},{"id":"5a80e34c.340e54","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'update ' + $generate-unique-name-input.index-table-name\n+ ' set index_number = ' + $tmp.gun.index-string + ' where '\n+ $generate-unique-name-input.index-table-prefix-column\n+ ' = $generate-unique-name-input.prefix'`\" />\n","comments":"","x":2469.204803466797,"y":4030.095151833126,"z":"815459fd.39651","wires":[]},{"id":"bf62ad1c.b880a8","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into ' + $generate-unique-name-input.index-table-name\n+ '(' + $generate-unique-name-input.index-table-prefix-column + ', index_number) values ('\n+ ' $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ')'`\" />\n\n","comments":"","x":2467.776351928711,"y":4124.38096850259,"z":"815459fd.39651","wires":[]},{"id":"baf26552.043b48","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":2234.919231414795,"y":3662.952667645046,"z":"815459fd.39651","wires":[["82b7f7fa.6672f8"]]},{"id":"6a15e97a.43887","type":"set","name":"clear namedb.name","xml":"<set>\n<parameter name='tmp.gun.namedb.name' value='' />\n","comments":"","x":2050.633415222168,"y":3412.952600887844,"z":"815459fd.39651","wires":[]},{"id":"7d855b7.633afa4","type":"switchNode","name":"switch generate-unique-name-input.index-length","xml":"<switch test='`$generate-unique-name-input.index-length`'>\n","comments":"","outputs":1,"x":1496.9191436767578,"y":2905.3334411893575,"z":"815459fd.39651","wires":[["ce923cd3.8e2308"]]},{"id":"ce923cd3.8e2308","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1752.6334762573242,"y":2906.2383503232686,"z":"815459fd.39651","wires":[["8b01f87b.613138"]]},{"id":"8b01f87b.613138","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"We have exhausted the naming index count\" />\n","comments":"","x":1909.7763595581055,"y":2906.2383503232686,"z":"815459fd.39651","wires":[]},{"id":"9932c6f0.d7be","type":"comment","name":"if we get here when there is no index length, then we have used up all 1000","info":"","comments":"","x":1628.3477401733398,"y":2861.952664784023,"z":"815459fd.39651","wires":[]},{"id":"cbd6ef5a.2c87a","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"We have exhausted the naming index count\" />\n","comments":"","x":1388.3477592468262,"y":4421.2383350644795,"z":"815459fd.39651","wires":[]},{"id":"abf49007.ade958","type":"set","name":"set found-flag=false","xml":"<set>\n<parameter name='tmp.gun.found-flag' value='false' />\n","comments":"","x":882.7524185180664,"y":1332.4285988126483,"z":"815459fd.39651","wires":[]},{"id":"8c5f82c3.b5999","type":"set","name":"set found-flag=true","xml":"<set>\n<parameter name='tmp.gun.found-flag' value='true' />\n","comments":"","x":2074.4191093444824,"y":2021.2381881986346,"z":"815459fd.39651","wires":[]},{"id":"e3aca01e.dacec","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1881.5619316101074,"y":2047.381132534572,"z":"815459fd.39651","wires":[["8c5f82c3.b5999","1aaa10fa.b84327"]]},{"id":"b800310c.fe9408","type":"returnFailure","name":"BREAK","xml":"<return status='failure'>\n","comments":"","x":2539.776210784912,"y":3684.0953830991475,"z":"815459fd.39651","wires":[]},{"id":"e67dd35f.a1d688","type":"comment","name":"found one we can use","info":"","comments":"","x":2357.6336669921875,"y":3615.143305233547,"z":"815459fd.39651","wires":[]},{"id":"ba42760b.fa2f38","type":"set","name":"set found-flag=true","xml":"<set>\n<parameter name='tmp.gun.found-flag' value='true' />\n","comments":"","x":2576.6811294555664,"y":3635.857235363552,"z":"815459fd.39651","wires":[]},{"id":"82b7f7fa.6672f8","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":2383.8239517211914,"y":3662.0001796994893,"z":"815459fd.39651","wires":[["ba42760b.fa2f38","b800310c.fe9408"]]},{"id":"be84dd11.a69268","type":"switchNode","name":"switch generate-unique-name-input.supplied-name","xml":"<switch test='`$generate-unique-name-input.supplied-name`'>\n","comments":"","outputs":1,"x":434.53802490234375,"y":438.8571781430926,"z":"815459fd.39651","wires":[["39b07652.28c332","f539c66d.3d3eb8"]]},{"id":"39b07652.28c332","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":693.1095237731934,"y":465.99997370583674,"z":"815459fd.39651","wires":[["2bb7603f.2a5648"]]},{"id":"f539c66d.3d3eb8","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":693.1095008850098,"y":408.8571438108172,"z":"815459fd.39651","wires":[["d59bbe20.5b5f7"]]},{"id":"9f23cd16.bec0f","type":"switchNode","name":"switch generate-unique-name-input.name-table-type","xml":"<switch test='`$generate-unique-name-input.name-table-type`'>\n","comments":"","outputs":1,"x":1162.3951721191406,"y":344.5714248929705,"z":"815459fd.39651","wires":[["b1fcadbe.cf554"]]},{"id":"b1fcadbe.cf554","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":1495.7283687591553,"y":344.5714344297137,"z":"815459fd.39651","wires":[["a63795d4.9a5d38"]]},{"id":"a63795d4.9a5d38","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.name-table-type not supplied' />\n","comments":"","x":1667.3951454162598,"y":344.9047378812518,"z":"815459fd.39651","wires":[]},{"id":"d59bbe20.5b5f7","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":847.3952255249023,"y":407.42857401711603,"z":"815459fd.39651","wires":[["9f23cd16.bec0f","49cbe0ea.56f328","476b8014.965948"]]},{"id":"476b8014.965948","type":"get-resource","name":"get-resource name","xml":"<get-resource plugin='org.openecomp.sdnc.sli.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n","comments":"","outputs":1,"x":1055.9666366577148,"y":437.4285892759051,"z":"815459fd.39651","wires":[["838c4e0d.2a9e48","ce7abeff.e6bf48","ac45ba28.706708"]]},{"id":"838c4e0d.2a9e48","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1238.5856857299805,"y":424.57148497445246,"z":"815459fd.39651","wires":[["fa29ea47.5c37a8"]]},{"id":"49cbe0ea.56f328","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $generate-unique-name-input.supplied-name'`\" />\n","comments":"","x":1049.5381889343262,"y":389.8096069608416,"z":"815459fd.39651","wires":[]},{"id":"ce7abeff.e6bf48","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":1246.6810417175293,"y":469.8095955167498,"z":"815459fd.39651","wires":[["ca6a32d3.655a2"]]},{"id":"fa29ea47.5c37a8","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value=\"`'Error reading the ' + $generate-unique-name-input.name-table-index + ' table'`\" />\n\n","comments":"","x":1394.5381088256836,"y":424.14289038521906,"z":"815459fd.39651","wires":[]},{"id":"ac45ba28.706708","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":1238.8238105773926,"y":511.71428912026545,"z":"815459fd.39651","wires":[["98eb6ae5.5954a8"]]},{"id":"98eb6ae5.5954a8","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value=\"`'The name ' + $generate-unique-name-input.supplied-name + ' has already been used'`\" />\n\n","comments":"","x":1394.5380477905273,"y":511.1428531919207,"z":"815459fd.39651","wires":[]},{"id":"f7a51204.bb90b8","type":"comment","name":"Caller supplied name - make sure it's not already used","info":"","comments":"","x":1192.2523803710938,"y":297.99999659402033,"z":"815459fd.39651","wires":[]},{"id":"ca6a32d3.655a2","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1395.9667358398438,"y":470.2857021604266,"z":"815459fd.39651","wires":[["34ca7b1d.d047b4","d6f052af.381de"]]},{"id":"d6f052af.381de","type":"save","name":"save (insert) generated name","xml":"<save plugin='org.openecomp.sdnc.sli.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n","comments":"","outputs":1,"x":1635.9667358398438,"y":494.57143824441096,"z":"815459fd.39651","wires":[["6e823b79.5cc254"]]},{"id":"6e823b79.5cc254","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1845.966667175293,"y":494.57148974282404,"z":"815459fd.39651","wires":[["de733429.fcb0b"]]},{"id":"de733429.fcb0b","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n<parameter name=\"generate-unique-name-output.error-message\" value=\"Failed insert into GENERIC_RESOURCE_NAME table\" />\n","comments":"","x":2000.25248336792,"y":494.57150881631037,"z":"815459fd.39651","wires":[]},{"id":"34ca7b1d.d047b4","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into GENERIC_RESOURCE_NAME values ( '\n+ ' $generate-unique-name-input.name-table-type , $generate-unique-name-input.supplied-name )'`\" />\n\n","comments":"","x":1595.966667175293,"y":444.5716156278338,"z":"815459fd.39651","wires":[]},{"id":"b7b12523.204aa8","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into GENERIC_RESOURCE_NAME values ( '\n+ ' $generate-unique-name-input.name-table-type , $tmp.gun.generated-name )'`\" />\n\n","comments":"","x":1395.9666900634766,"y":2655.9999880109517,"z":"815459fd.39651","wires":[]},{"id":"552d7ff7.e47298","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $tmp.gun.generated-name'`\" />\n","comments":"","x":2044.0619888305664,"y":3528.3811573301045,"z":"815459fd.39651","wires":[]},{"id":"30fee1b0.328f4e","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into GENERIC_RESOURCE_NAME values ( '\n+ ' $generate-unique-name-input.name-table-type , $tmp.gun.generated-name )'`\" />\n\n","comments":"","x":1919.7761840820312,"y":4212.666685513088,"z":"815459fd.39651","wires":[]},{"id":"de5804d8.43d0a","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to update ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n","comments":"","x":2318.823875427246,"y":2520.2857050214498,"z":"815459fd.39651","wires":[]},{"id":"1461e83f.8fcd2","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to insert record into ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n","comments":"","x":2315.9664878845215,"y":2613.571485928127,"z":"815459fd.39651","wires":[]},{"id":"a2c0f526.551af8","type":"outcomeFalse","name":"false","xml":"<outcome value='false'>\n","comments":"","outputs":1,"x":1031.91898727417,"y":2851.0000271115987,"z":"815459fd.39651","wires":[["2da320e7.a153c"]]},{"id":"2da320e7.a153c","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":1182.7523956298828,"y":3462.6665510450093,"z":"815459fd.39651","wires":[["7d855b7.633afa4","51214751.d1fbc8","a607bdc.33f884","968630d4.e3ba48","cbd6ef5a.2c87a"]]},{"id":"14f2d9a0.55df8e","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":1149.395305633545,"y":1097.4285682950701,"z":"815459fd.39651","wires":[["b1142e6.2fc40d"]]},{"id":"302b87aa.f8d91","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":1155.9667701721191,"y":1186.5714420591082,"z":"815459fd.39651","wires":[["ca8d8f3c.52dd98"]]},{"id":"ca8d8f3c.52dd98","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1287.395320892334,"y":1186.0000480924334,"z":"815459fd.39651","wires":[["af0bf984.64fc58","adc50be3.80b89"]]},{"id":"5e3d7ef1.ce61d","type":"set","name":"set sql statement","xml":"<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $tmp.gun.generated-name'`\" />\n","comments":"","x":1539.7405052185059,"y":1919.5714511871338,"z":"815459fd.39651","wires":[]},{"id":"2f2db390.dd18b4","type":"get-resource","name":"get-resource name","xml":"<get-resource plugin='org.openecomp.sdnc.sli.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n","comments":"","outputs":1,"x":1541.1691131591797,"y":2006.7143745422363,"z":"815459fd.39651","wires":[["f1cdba00.3ba7b","6dccc1ef.da102"]]}]

Expand
titleGENERCI-RESOURCE-API:service-topology-assign

[{"id":"78d12d0e.b112f4","type":"dgstart","name":"DGSTART","outputs":1,"x":174,"y":138.4136562347412,"z":"573bd44.832f22c","wires":[["d3f20878.e78588"]]},{"id":"d3f20878.e78588","type":"service-logic","name":"GENERIC-RESOURCE-API 0.0.1","module":"GENERIC-RESOURCE-API","version":"0.0.1","comments":"","xml":"<service-logic xmlns='http://www.openecomp.org/sdnc/svclogic' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.openecomp.org/sdnc/svclogic ./svclogic.xsd' module='GENERIC-RESOURCE-API' version='0.0.1'>","outputs":1,"x":249.28570556640625,"y":178.6517677307129,"z":"573bd44.832f22c","wires":[["dd896e2b.6b1c88"]]},{"id":"dd896e2b.6b1c88","type":"method","name":"method service-topology-operation-assign","xml":"<method rpc='service-topology-operation-assign' mode='sync'>\n","comments":"","outputs":1,"x":278.42862701416016,"y":218.4136562347412,"z":"573bd44.832f22c","wires":[["b53bfbb0.f9d8a8"]]},{"id":"8c7dd591.f5413","type":"comment","name":"service-topology-operation-assign","info":"","comments":"","x":568.344856262207,"y":86,"z":"573bd44.832f22c","wires":[]},{"id":"b53bfbb0.f9d8a8","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":290.8571243286133,"y":809.1756019592285,"z":"573bd44.832f22c","wires":[["eed4a4bb.4ff4c8","b5a07cf7.622aa8","7ddf70bc.04d968","19cb8a62.21245e","ff8f09db.fa31a8","d9bc037.5a8a28","808a05d8.77b83","1a5d5129.f380cf","8e1f0de6.26b1e"]]},{"id":"eed4a4bb.4ff4c8","type":"switchNode","name":"switch request-action","xml":"<switch test='`$service-topology-operation-input.request-information.request-action`'>\n","comments":"","outputs":1,"x":573.2381134033203,"y":320.127947807312,"z":"573bd44.832f22c","wires":[["160c429.fdbff3d","b16ff0b4.57f5"]]},{"id":"160c429.fdbff3d","type":"outcome","name":"CreateServiceInstance","xml":"<outcome value='CreateServiceInstance'>\n","comments":"","outputs":1,"x":810.3809280395508,"y":294.4136562347412,"z":"573bd44.832f22c","wires":[["bc5512a3.62569"]]},{"id":"b16ff0b4.57f5","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":760.3809509277344,"y":338.46129512786865,"z":"573bd44.832f22c","wires":[["351b9443.f5869c"]]},{"id":"bc5512a3.62569","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":988.9523849487305,"y":294.4136915206909,"z":"573bd44.832f22c","wires":[[]]},{"id":"351b9443.f5869c","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"If svc-action is 'assign' then request-action must be 'CreateServiceInstance'\" />\n","comments":"","x":967.7618980407715,"y":338.46130657196045,"z":"573bd44.832f22c","wires":[]},{"id":"a9478035.5f0fb","type":"get-resource","name":"get-resource SERVICE_MODEL","xml":"<get-resource plugin='org.openecomp.sdnc.sli.resource.sql.SqlResource' resource='SQL'\n  key='SELECT * from SERVICE_MODEL WHERE service_uuid = $service-topology-operation-input.service-information.ecomp-model-information.model-uuid'\n  pfx='db.service-model'>\n\n","comments":"","outputs":1,"x":609.7856292724609,"y":543.2232360839844,"z":"573bd44.832f22c","wires":[["ebfe18e9.9d4ed","a218a76b.7acc68"]]},{"id":"558753d6.22bd54","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"`'No model found for service UUID ' + $service-topology-operation-input.service-information.ecomp-model-information.model-uuid`\" />\n","comments":"","x":1024.0712966918945,"y":568.080286026001,"z":"573bd44.832f22c","wires":[]},{"id":"b5a07cf7.622aa8","type":"switchNode","name":"switch input service-instance-name","xml":"<switch test='`$service-topology-operation-input.service-request-input.service-instance-name`'>\n","comments":"","outputs":1,"x":617.1903610229492,"y":839.5326652526855,"z":"573bd44.832f22c","wires":[["fa26bb1c.fab59","6a2acb8b.f308d4"]]},{"id":"fa26bb1c.fab59","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":838.3569221496582,"y":764.8898096084595,"z":"573bd44.832f22c","wires":[["a1460fd3.88252"]]},{"id":"ca1b790f.25d6f8","type":"switchNode","name":"switch ecomp-naming","xml":"<switch test='`$db.service-model.ecomp-naming`'>\n","comments":"","outputs":1,"x":1217.6429824829102,"y":657.2708940505981,"z":"573bd44.832f22c","wires":[["6683f762.e027b","50f6496a.ffe23","40fd15fa.84da4c"]]},{"id":"a1460fd3.88252","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":984.0714225769043,"y":764.8899269104004,"z":"573bd44.832f22c","wires":[["9c81a56.0cea0d8","23c933b.2cfc14c","ca1b790f.25d6f8"]]},{"id":"50f6496a.ffe23","type":"outcome","name":"N","xml":"<outcome value='N'>","comments":"","outputs":1,"x":1466.9286422729492,"y":659.1756029129028,"z":"573bd44.832f22c","wires":[["89106143.b1a078"]]},{"id":"89106143.b1a078","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"No service-instance-name was received but ecomp-naming is not Y\" />\n","comments":"","x":1621.214427947998,"y":677.7470474243164,"z":"573bd44.832f22c","wires":[]},{"id":"6683f762.e027b","type":"outcome","name":"Y","xml":"<outcome value='Y'>","comments":"","outputs":1,"x":1466.9286079406738,"y":614.8899240493774,"z":"573bd44.832f22c","wires":[["a82712a1.8243d8"]]},{"id":"40fd15fa.84da4c","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":1466.9285697937012,"y":704.8899221420288,"z":"573bd44.832f22c","wires":[["89106143.b1a078"]]},{"id":"a82712a1.8243d8","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":1604.0715522766113,"y":614.8899240493774,"z":"573bd44.832f22c","wires":[[]]},{"id":"6a2acb8b.f308d4","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":840.9286041259766,"y":911.1755485534668,"z":"573bd44.832f22c","wires":[["3bcfb2c8.11039e"]]},{"id":"3b698a92.087b7e","type":"set","name":"set tmp.service-instance-name","xml":"<set>\n<parameter name='tmp.service-instance-name' value=\"`$service-topology-operation-input.service-request-input.service-instance-name`\" />\n","comments":"","x":1882.6428756713867,"y":958.6041946411133,"z":"573bd44.832f22c","wires":[]},{"id":"19cb8a62.21245e","type":"update","name":"update AAI service instance","xml":"<update plugin=\"org.openecomp.sdnc.sli.aai.AAIService\" \n\t\tresource=\"service-instance\" \n\t\tkey=\"customer.global-customer-id = $service-topology-operation-input.service-information.global-customer-id AND\n\t\t\tservice-subscription.service-type = $service-topology-operation-input.service-information.subscription-service-type AND\n\t\t\tservice-instance.service-instance-id = $service-topology-operation-input.service-information.service-instance-id\"\n        pfx='pfx' local-only='false' force='false'>\n\t<parameter name=\"service-instance-name\" value=\"`$tmp.service-instance-name`\" />\n\t<parameter name=\"selflink\" value=\"`$service-object-path`\" />\n","comments":"","outputs":1,"x":591.4524154663086,"y":1065.9374208450317,"z":"573bd44.832f22c","wires":[["a7941b57.780c48","212a10f.c55d27"]]},{"id":"a7941b57.780c48","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":803.214282989502,"y":1041.1755752563477,"z":"573bd44.832f22c","wires":[["db0cc330.28062"]]},{"id":"db0cc330.28062","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"AAI failed\" />\n","comments":"","x":953.2142486572266,"y":1041.1756534576416,"z":"573bd44.832f22c","wires":[]},{"id":"8e1f0de6.26b1e","type":"set","name":"set service-level-oper-status to Created","xml":"<set>\n<parameter name='service-data.service-level-oper-status.order-status' value='Created' />\n<parameter name='service-data.service-level-oper-status.last-rpc-action' value='assign' />\n<parameter name='service-data.service-level-oper-status.last-action' value='CreateServiceInstance' />\n","comments":"","x":626.7380981445312,"y":1314.6277723312378,"z":"573bd44.832f22c","wires":[]},{"id":"1a5d5129.f380cf","type":"set","name":"set service-object-path","xml":"<set>\n<parameter name='service-object-path'\n value=\"`'restconf/config/GENERIC-RESOURCE-API:services/service/'\n + $service-topology-operation-input.service-information.service-instance-id\n + '/service-data/service-topology/'`\"/>\n","comments":"","x":575.9760437011719,"y":1001.8897714614868,"z":"573bd44.832f22c","wires":[]},{"id":"7ddf70bc.04d968","type":"switchNode","name":"switch order-status","xml":"<switch test='`$service-data.service-level-oper-status.order-status`'>\n","comments":"","outputs":1,"x":566.3809089660645,"y":431.0804195404053,"z":"573bd44.832f22c","wires":[["ce4b4db7.fee0c","660a8480.99e1c4","6b5f29ae.188e98"]]},{"id":"ce4b4db7.fee0c","type":"outcome","name":"Created","xml":"<outcome value='Created'>\n","comments":"","outputs":1,"x":762.3333587646484,"y":430.74701595306396,"z":"573bd44.832f22c","wires":[["b51ba79c.316bf"]]},{"id":"b51ba79c.316bf","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"The requested service already exists\" />\n","comments":"","x":964.476188659668,"y":430.3185501098633,"z":"573bd44.832f22c","wires":[]},{"id":"ff8f09db.fa31a8","type":"set","name":"set service-topology identifiers","xml":"<set>\n<parameter name='service-data.service-topology.service-topology-identifier.service-instance-id'\n  value='`$service-topology-operation-input.service-information.service-instance-id`' />\n<parameter name='service-data.service-topology.service-topology-identifier.service-type'\n  value='`$service-topology-operation-input.service-information.subscription-service-type`' />\n<parameter name='service-data.service-topology.service-topology-identifier.service-instance-name'\n  value='`$tmp.service-instance-name`' />\n<parameter name='service-data.service-topology.service-topology-identifier.global-customer-id'\n  value='`$service-topology-operation-input.service-information.global-customer-id`' />\n","comments":"","x":602.7143249511719,"y":1134.2707147598267,"z":"573bd44.832f22c","wires":[]},{"id":"791f39fa.05ac68","type":"for","name":"for each service-input-parameters","xml":"<for index='idx' start='0' end='`$service-topology-operation-input.service-request-input.service-input-parameters.param_length`' >\n","comments":"","outputs":1,"x":1032.523754119873,"y":1272.366153717041,"z":"573bd44.832f22c","wires":[["8b8629f3.cdd878"]]},{"id":"8b8629f3.cdd878","type":"set","name":"set parameter name/value","xml":"<set>\n<parameter name='service-data.service-topology.service-parameters[$idx].service-parameter-name'\n  value='`$service-topology-operation-input.service-request-input.service-input-parameters.param[$idx].name`' />\n<parameter name='service-data.service-topology.service-parameters[$idx].service-parameter-value'\n  value='`$service-topology-operation-input.service-request-input.service-input-parameters.param[$idx].value`' />\n","comments":"","x":1313.9522171020508,"y":1272.3661003112793,"z":"573bd44.832f22c","wires":[]},{"id":"d9bc037.5a8a28","type":"switchNode","name":"switch input parameter length","xml":"<switch test='`$service-topology-operation-input.service-request-input.service-input-parameters.param_length`'>\n","comments":"","outputs":1,"x":595.3333282470703,"y":1244.7468738555908,"z":"573bd44.832f22c","wires":[["6a4426e0.aa51d","35f72c92.6d34cc"]]},{"id":"6a4426e0.aa51d","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":810.237907409668,"y":1220.9375076293945,"z":"573bd44.832f22c","wires":[["308e9af1.186aee"]]},{"id":"308e9af1.186aee","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":948.8092994689941,"y":1220.9374904632568,"z":"573bd44.832f22c","wires":[[]]},{"id":"35f72c92.6d34cc","type":"other","name":"other","xml":"<outcome value='Other'>\n","comments":"","outputs":1,"x":808.8093185424805,"y":1272.366096496582,"z":"573bd44.832f22c","wires":[["791f39fa.05ac68"]]},{"id":"808a05d8.77b83","type":"set","name":"set service-topology ecomp-model-information","xml":"<set>\n<parameter name='service-data.service-topology.ecomp-model-information.'\n  value='`$service-topology-operation-input.service-information.ecomp-model-information.`' />\n","comments":"","x":652.7143096923828,"y":1178.5562887191772,"z":"573bd44.832f22c","wires":[]},{"id":"212a10f.c55d27","type":"failure","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":809.5237121582031,"y":1089.7469930648804,"z":"573bd44.832f22c","wires":[["92e69062.b6227"]]},{"id":"92e69062.b6227","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"The service instance does not exist in AAI\" />\n","comments":"","x":952.8570098876953,"y":1088.0803670883179,"z":"573bd44.832f22c","wires":[]},{"id":"9c81a56.0cea0d8","type":"call","name":"call GENERIC-RESOURCE-API:generate-unique-name","xml":"<call module='GENERIC-RESOURCE-API' rpc='generate-unique-name' mode='sync' >\n","comments":"","outputs":1,"x":1323.1904754638672,"y":814.8898191452026,"z":"573bd44.832f22c","wires":[["26b42ec9.82f8ba","4e7d6be0.902e04"]]},{"id":"26b42ec9.82f8ba","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1663.1904487609863,"y":789.8898782730103,"z":"573bd44.832f22c","wires":[["21b353c8.d1d184"]]},{"id":"4e7d6be0.902e04","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":1666.5237986246743,"y":839.5565214157104,"z":"573bd44.832f22c","wires":[["c3c9c1c1.1901e8"]]},{"id":"23c933b.2cfc14c","type":"set","name":"set variables for generating unique name","xml":"<set>\n<parameter name='generate-unique-name-input.index-table-name' value='SERVICE_INSTANCE_NAME_INDEX' />\n<parameter name='generate-unique-name-input.index-table-prefix-column' value='service_instance_name_prefix' />\n<parameter name='generate-unique-name-input.name-table-type' value='SERVICE_INSTANCE' />\n<parameter name='generate-unique-name-input.prefix' value=\"`$db.service-model.service-instance-name-prefix + '_'`\" />\n","comments":"","x":1278.190559387207,"y":754.5566291809082,"z":"573bd44.832f22c","wires":[]},{"id":"c3c9c1c1.1901e8","type":"set","name":"set tmp.service-instance-name to generated name","xml":"<set>\n<parameter name='tmp.service-instance-name' value='`$generate-unique-name-output.generated-name`' />\n","comments":"","x":1950.5713500976562,"y":838.6041021347046,"z":"573bd44.832f22c","wires":[]},{"id":"21b353c8.d1d184","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"`$generate-unique-name-output.error-message`\" />\n","comments":"","x":1831.0475616455078,"y":789.3183898925781,"z":"573bd44.832f22c","wires":[]},{"id":"3bcfb2c8.11039e","type":"block","name":"block : atomic","xml":"<block atomic=\"true\">","atomic":"true","outputs":1,"x":988.8571319580078,"y":909.8422355651855,"z":"573bd44.832f22c","wires":[["78963995.6cc0a","be4997df.1f332"]]},{"id":"be4997df.1f332","type":"call","name":"call GENERIC-RESOURCE-API:generate-unique-name","xml":"<call module='GENERIC-RESOURCE-API' rpc='generate-unique-name' mode='sync' >\n","comments":"","outputs":1,"x":1319.857177734375,"y":957.5089111328125,"z":"573bd44.832f22c","wires":[["9f464d6b.aff938","ae91a50b.b8231"]]},{"id":"9f464d6b.aff938","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":1658.857105255127,"y":907.8422946929932,"z":"573bd44.832f22c","wires":[["52e3a7ce.0d766"]]},{"id":"ae91a50b.b8231","type":"success","name":"success","xml":"<outcome value='success'>\n","comments":"","outputs":1,"x":1662.190455118815,"y":959.5089378356934,"z":"573bd44.832f22c","wires":[["3b698a92.087b7e"]]},{"id":"78963995.6cc0a","type":"set","name":"set variables for generating unique name","xml":"<set>\n<parameter name='generate-unique-name-input.name-table-type' value='SERVICE_INSTANCE' />\n<parameter name='generate-unique-name-input.supplied-name' value='`$service-topology-operation-input.service-request-input.service-instance-name`' />\n","comments":"","x":1277.1905212402344,"y":886.1755924224854,"z":"573bd44.832f22c","wires":[]},{"id":"52e3a7ce.0d766","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"`$generate-unique-name-output.error-message`\" />\n","comments":"","x":1826.7142181396484,"y":907.270806312561,"z":"573bd44.832f22c","wires":[]},{"id":"ebfe18e9.9d4ed","type":"failure","name":"failure","xml":"<outcome value='failure'>\n","comments":"","outputs":1,"x":850.5713310241699,"y":524.6041011810303,"z":"573bd44.832f22c","wires":[["4098d552.aeef4c"]]},{"id":"a218a76b.7acc68","type":"not-found","name":"not-found","xml":"<outcome value='not-found'>\n","comments":"","outputs":1,"x":859.1427612304688,"y":567.889814376831,"z":"573bd44.832f22c","wires":[["558753d6.22bd54"]]},{"id":"4098d552.aeef4c","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"Error reading SERVICE_MODEL table\" />\n","comments":"","x":1023.4284973144531,"y":523.1755447387695,"z":"573bd44.832f22c","wires":[]},{"id":"660a8480.99e1c4","type":"outcome","name":"NULL","xml":"<outcome value=''>","comments":"","outputs":1,"x":760.3332824707031,"y":386.08033752441406,"z":"573bd44.832f22c","wires":[["334d5f6e.9e0ac"]]},{"id":"6b5f29ae.188e98","type":"other","name":"PendingDelete","xml":"<outcome value='PendingDelete'>\n","comments":"","outputs":1,"x":783.0000114440918,"y":474.7469959259033,"z":"573bd44.832f22c","wires":[["c4f908c4.ddc838"]]},{"id":"c4f908c4.ddc838","type":"returnFailure","name":"return failure","xml":"<return status='failure'>\n\t<parameter name='ack-final' value='Y'/>\n\t<parameter name=\"error-code\" value=\"500\" />\n    <parameter name=\"error-message\" value=\"The requested service is pending deletion\" />\n","comments":"","x":965.333309173584,"y":474.7470064163208,"z":"573bd44.832f22c","wires":[]},{"id":"334d5f6e.9e0ac","type":"block","name":"block","xml":"<block>\n","atomic":"false","comments":"","outputs":1,"x":946.9999923706055,"y":385.0803565979004,"z":"573bd44.832f22c","wires":[[]]},{"id":"7d9ead4a.c2484c","type":"comment","name":"SERVICE_MODEL not in sdnc yet","info":"","comments":"","x":608,"y":608,"z":"573bd44.832f22c","wires":[]}]

...