X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=platform-logic%2Fgeneric-resource-api%2Fsrc%2Fmain%2Fjson%2FGENERIC-RESOURCE-API_generate-unique-name.json;h=ee76ebced4530ca86c3540798774b53e61798ec8;hb=ae2694d30df3a7f62324ec7e617d23f187debcbb;hp=db31408ba8b307721107de4fe3ede6cc5956404b;hpb=f514c5cd6b4e5071b8f0340d83f9870eba273939;p=sdnc%2Foam.git diff --git a/platform-logic/generic-resource-api/src/main/json/GENERIC-RESOURCE-API_generate-unique-name.json b/platform-logic/generic-resource-api/src/main/json/GENERIC-RESOURCE-API_generate-unique-name.json index db31408b..ee76ebce 100755 --- a/platform-logic/generic-resource-api/src/main/json/GENERIC-RESOURCE-API_generate-unique-name.json +++ b/platform-logic/generic-resource-api/src/main/json/GENERIC-RESOURCE-API_generate-unique-name.json @@ -1 +1,3695 @@ -[{"id":"67de88fb.8c7938","type":"comment","name":"Validation of required data","info":"","comments":"","x":1057.142822265625,"y":515.5803684507098,"z":"90110745.0f08b8","wires":[]},{"id":"94850767.18cb88","type":"dgstart","name":"DGSTART","outputs":1,"x":102.17857578822532,"y":85.27079963684082,"z":"90110745.0f08b8","wires":[["9515dbaf.7cfdd8"]]},{"id":"9515dbaf.7cfdd8","type":"service-logic","name":"GENERIC-RESOURCE-API ${project.version}","module":"GENERIC-RESOURCE-API","version":"${project.version}","comments":"","xml":"","outputs":1,"x":217.46428680419922,"y":126.5089168548584,"z":"90110745.0f08b8","wires":[["e2f684c5.eb7ee8"]]},{"id":"e2f684c5.eb7ee8","type":"method","name":"method generate-unique-name","xml":"\n","comments":"","outputs":1,"x":173.5238800048828,"y":168.1874546323504,"z":"90110745.0f08b8","wires":[["68aae923.1b9ef8"]]},{"id":"2c60d5c7.2f6a4a","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.52343205043235,"y":32.85714340209961,"z":"90110745.0f08b8","wires":[]},{"id":"c38467.17e88b98","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":552.0595245361328,"y":1462.4405617032733,"z":"90110745.0f08b8","wires":[["e07193e1.224fa","db37eadb.3a3d08","f2d5b5.74cefa48","e4e1fe0e.7ce86","536fad15.81aec4","54f8ebb1.fbd3a4","56d20088.dca34","a0df1e14.0a77c","2db87246.6ac1ae","a9e87bf7.6d8b68","4e23a92d.e2e488"]]},{"id":"e07193e1.224fa","type":"switchNode","name":"switch generate-unique-name-input.index-table-name","xml":"\n","comments":"","outputs":1,"x":993.7262115478516,"y":561.1905063901629,"z":"90110745.0f08b8","wires":[["18433a18.3228e6"]]},{"id":"18433a18.3228e6","type":"outcome","name":"NULL","xml":"","comments":"","outputs":1,"x":1323.726131439209,"y":561.1904958997454,"z":"90110745.0f08b8","wires":[["631b8d51.8c1104"]]},{"id":"631b8d51.8c1104","type":"returnFailure","name":"return failure","xml":"\n\n","comments":"","x":1497.0594520568848,"y":561.1904873166766,"z":"90110745.0f08b8","wires":[]},{"id":"db37eadb.3a3d08","type":"switchNode","name":"switch generate-unique-name-input.index-table-prefix-column","xml":"\n","comments":"","outputs":1,"x":1018.7261810302734,"y":604.5238422666278,"z":"90110745.0f08b8","wires":[["1d937744.b083a9"]]},{"id":"1d937744.b083a9","type":"outcome","name":"NULL","xml":"","comments":"","outputs":1,"x":1322.0594444274902,"y":604.5238212857928,"z":"90110745.0f08b8","wires":[["545cc85f.e1dd58"]]},{"id":"545cc85f.e1dd58","type":"returnFailure","name":"return failure","xml":"\n\n","comments":"","x":1495.3927612304688,"y":604.8571647916522,"z":"90110745.0f08b8","wires":[]},{"id":"f2d5b5.74cefa48","type":"switchNode","name":"switch generate-unique-name-input.name-table-type","xml":"\n","comments":"","outputs":1,"x":989.726188659668,"y":649.5238346372332,"z":"90110745.0f08b8","wires":[["c3a054c.71adaa8"]]},{"id":"c3a054c.71adaa8","type":"outcome","name":"NULL","xml":"","comments":"","outputs":1,"x":1322.0593852996826,"y":649.5238441739764,"z":"90110745.0f08b8","wires":[["a9d236bd.19e0f8"]]},{"id":"a9d236bd.19e0f8","type":"returnFailure","name":"return failure","xml":"\n\n","comments":"","x":1493.726161956787,"y":649.8571476255145,"z":"90110745.0f08b8","wires":[]},{"id":"56d20088.dca34","type":"get-resource","name":"get-resource current name index","xml":"\n\n","comments":"","outputs":1,"x":921.3927917480469,"y":1090.2855362210955,"z":"90110745.0f08b8","wires":[["145a06ca.15e939","b91db4d1.5863b8","c98722cf.dc1a3"]]},{"id":"145a06ca.15e939","type":"failure","name":"failure","xml":"\n","comments":"","outputs":1,"x":1146.5832595825195,"y":1168.8094429288592,"z":"90110745.0f08b8","wires":[["5ade3940.140eb8"]]},{"id":"5ade3940.140eb8","type":"returnFailure","name":"return failure","xml":"\n \n","comments":"","x":1309.2023811340332,"y":1170.238171032497,"z":"90110745.0f08b8","wires":[]},{"id":"43b733f4.e9302c","type":"for","name":"for idx from current index to list-end","xml":"\n","comments":"","outputs":1,"x":1073.7261962890625,"y":1492.8571519851685,"z":"90110745.0f08b8","wires":[["91d927f9.353948"]]},{"id":"e4e1fe0e.7ce86","type":"block","name":"block","xml":"\n","atomic":"false","comments":"","outputs":1,"x":836.3451919555664,"y":1492.8571171079363,"z":"90110745.0f08b8","wires":[["43b733f4.e9302c","c322ca3a.666808"]]},{"id":"c322ca3a.666808","type":"returnSuccess","name":"CATCH BREAK","xml":"\n\n","comments":"","x":1024.6786041259766,"y":2067.857247761318,"z":"90110745.0f08b8","wires":[]},{"id":"536fad15.81aec4","type":"switchNode","name":"switch generate-unique-name-input.prefix","xml":"\n","comments":"","outputs":1,"x":955.3928298950195,"y":694.5238136563983,"z":"90110745.0f08b8","wires":[["82c1a7dd.32a6a8"]]},{"id":"82c1a7dd.32a6a8","type":"outcome","name":"NULL","xml":"","comments":"","outputs":1,"x":1322.7260189056396,"y":694.5238384519305,"z":"90110745.0f08b8","wires":[["db83eab5.1248c8"]]},{"id":"db83eab5.1248c8","type":"returnFailure","name":"return failure","xml":"\n\n","comments":"","x":1495.3927955627441,"y":694.8571419034686,"z":"90110745.0f08b8","wires":[]},{"id":"54f8ebb1.fbd3a4","type":"switchNode","name":"switch generate-unique-name-input.index-length","xml":"\n","comments":"","outputs":1,"x":978.7261962890625,"y":829.523755482265,"z":"90110745.0f08b8","wires":[["f7c6d6ff.541f78","ce184e71.86be8","4c11c2f5.d535ac","d88178cc.f88d98","febff3b8.f5c6e"]]},{"id":"f7c6d6ff.541f78","type":"outcome","name":"NULL","xml":"","comments":"","outputs":1,"x":1322.0595092773438,"y":737.8571419034686,"z":"90110745.0f08b8","wires":[["5b517f27.498b7"]]},{"id":"febff3b8.f5c6e","type":"other","name":"other","xml":"\n","comments":"","outputs":1,"x":1319.3928985595703,"y":914.5238022123065,"z":"90110745.0f08b8","wires":[["2531a549.b793aa"]]},{"id":"ce184e71.86be8","type":"outcome","name":"1","xml":"\n","comments":"","outputs":1,"x":1320.3928565979004,"y":782.8571819577899,"z":"90110745.0f08b8","wires":[["31a1c558.a77dba"]]},{"id":"4c11c2f5.d535ac","type":"outcome","name":"2","xml":"\n","comments":"","outputs":1,"x":1320.3928413391113,"y":827.8571724210467,"z":"90110745.0f08b8","wires":[["510f4c1a.709e14"]]},{"id":"d88178cc.f88d98","type":"outcome","name":"3","xml":"\n","comments":"","outputs":1,"x":1318.7261772155762,"y":871.1905082975115,"z":"90110745.0f08b8","wires":[["9efb14fc.5f68e8"]]},{"id":"31a1c558.a77dba","type":"set","name":"set list-end = 10","xml":"\n\n","comments":"","x":1503.0595932006836,"y":782.8571705136981,"z":"90110745.0f08b8","wires":[]},{"id":"510f4c1a.709e14","type":"set","name":"set list-end = 100","xml":"\n\n","comments":"","x":1506.392822265625,"y":827.8571724210467,"z":"90110745.0f08b8","wires":[]},{"id":"9efb14fc.5f68e8","type":"set","name":"set list-end = 1000","xml":"\n\n","comments":"","x":1508.392822265625,"y":871.190485409328,"z":"90110745.0f08b8","wires":[]},{"id":"2531a549.b793aa","type":"returnFailure","name":"return failure","xml":"\n\n","comments":"","x":1490.392822265625,"y":913.8571724210467,"z":"90110745.0f08b8","wires":[]},{"id":"70192d95.678c34","type":"set","name":"set new index number to 1","xml":"\n\n","comments":"","x":1481.8216018676758,"y":1113.4288276944842,"z":"90110745.0f08b8","wires":[]},{"id":"5b517f27.498b7","type":"set","name":"set list-end = 10000 (infinity basically)","xml":"\n\n","comments":"","x":1571.0594482421875,"y":738.190485409328,"z":"90110745.0f08b8","wires":[]},{"id":"314df997.3fe296","type":"switchNode","name":"switch generate-unique-name-input.index-length","xml":"\n","comments":"","outputs":1,"x":1635.3927764892578,"y":1419.5237907682147,"z":"90110745.0f08b8","wires":[["d05e660d.be4cd8","c3985438.571b88","b03a2186.83945","f88e445.6bd78b8"]]},{"id":"d05e660d.be4cd8","type":"outcome","name":"NULL","xml":"","comments":"","outputs":1,"x":1915.3927764892578,"y":1349.523851803371,"z":"90110745.0f08b8","wires":[["4bdac272.02882c"]]},{"id":"c3985438.571b88","type":"outcome","name":"1","xml":"\n","comments":"","outputs":1,"x":1913.7261238098145,"y":1394.5238918576922,"z":"90110745.0f08b8","wires":[["4bdac272.02882c"]]},{"id":"b03a2186.83945","type":"outcome","name":"2","xml":"\n","comments":"","outputs":1,"x":1913.7262115478516,"y":1447.8572391782488,"z":"90110745.0f08b8","wires":[["aa9d44e3.177b58"]]},{"id":"f88e445.6bd78b8","type":"outcome","name":"3","xml":"\n","comments":"","outputs":1,"x":1913.726089477539,"y":1544.5239719663348,"z":"90110745.0f08b8","wires":[["9cdd86f.ae52778"]]},{"id":"4bdac272.02882c","type":"set","name":"set index-string to idx","xml":"\n\n","comments":"","x":2100.392925262451,"y":1367.8571953092303,"z":"90110745.0f08b8","wires":[]},{"id":"aa9d44e3.177b58","type":"switchNode","name":"switch idx < 10","xml":"\n","comments":"","outputs":1,"x":2080.3928413391113,"y":1447.857137135097,"z":"90110745.0f08b8","wires":[["db28baee.042fe8","31a49c00.cbd4c4"]]},{"id":"db28baee.042fe8","type":"outcomeTrue","name":"true","xml":"\n","comments":"","outputs":1,"x":2242.0594749450684,"y":1421.1905102048602,"z":"90110745.0f08b8","wires":[["1f2e15a5.5c898a"]]},{"id":"31a49c00.cbd4c4","type":"outcomeFalse","name":"false","xml":"\n","comments":"","outputs":1,"x":2242.0594329833984,"y":1469.523846081325,"z":"90110745.0f08b8","wires":[["5fd3a71c.4e8c88"]]},{"id":"1f2e15a5.5c898a","type":"set","name":"set index-string to '0' + idx","xml":"\n\n","comments":"","x":2433.726234436035,"y":1420.523737362453,"z":"90110745.0f08b8","wires":[]},{"id":"5fd3a71c.4e8c88","type":"set","name":"set index-string to idx","xml":"\n\n","comments":"","x":2417.05948638916,"y":1469.1904529844012,"z":"90110745.0f08b8","wires":[]},{"id":"9cdd86f.ae52778","type":"switchNode","name":"switch idx < 10","xml":"\n","comments":"","outputs":1,"x":2082.059425354004,"y":1542.8570999417987,"z":"90110745.0f08b8","wires":[["4dff528e.5fe12c","e36c83c7.3522d"]]},{"id":"4dff528e.5fe12c","type":"outcomeTrue","name":"true","xml":"\n","comments":"","outputs":1,"x":2242.0594024658203,"y":1516.1904777799334,"z":"90110745.0f08b8","wires":[["3d8d515c.20155e"]]},{"id":"e36c83c7.3522d","type":"outcomeFalse","name":"false","xml":"\n","comments":"","outputs":1,"x":2243.726058959961,"y":1591.1904358182635,"z":"90110745.0f08b8","wires":[["5210620f.f035ac"]]},{"id":"3d8d515c.20155e","type":"set","name":"set index-string to '00' + idx","xml":"\n\n","comments":"","x":2437.0594940185547,"y":1516.1903686523438,"z":"90110745.0f08b8","wires":[]},{"id":"5210620f.f035ac","type":"switchNode","name":"switch idx < 100","xml":"\n","comments":"","outputs":1,"x":2400.059440612793,"y":1589.5237964902606,"z":"90110745.0f08b8","wires":[["bb2d2969.5be9a8","f8c44cdb.e372f"]]},{"id":"bb2d2969.5be9a8","type":"outcomeTrue","name":"true","xml":"\n","comments":"","outputs":1,"x":2557.0594177246094,"y":1562.8571743283953,"z":"90110745.0f08b8","wires":[["7621b36e.37c05c"]]},{"id":"f8c44cdb.e372f","type":"outcomeFalse","name":"false","xml":"\n","comments":"","outputs":1,"x":2557.0593757629395,"y":1611.1905102048602,"z":"90110745.0f08b8","wires":[["c1d12981.5578f8"]]},{"id":"7621b36e.37c05c","type":"set","name":"set index-string to '0' + idx","xml":"\n\n","comments":"","x":2749.726203918457,"y":1562.5238289151873,"z":"90110745.0f08b8","wires":[]},{"id":"c1d12981.5578f8","type":"set","name":"set index-string to idx","xml":"\n\n","comments":"","x":2733.726188659668,"y":1610.8571323667254,"z":"90110745.0f08b8","wires":[]},{"id":"630383d6.9584cc","type":"set","name":"set generated-name to prefix + index-string","xml":"\n\n","comments":"","x":1619.3928680419922,"y":1696.1904396329608,"z":"90110745.0f08b8","wires":[]},{"id":"e52dd26e.0f4e","type":"set","name":"increment index number","xml":"\n\n","comments":"","x":1473.7261962890625,"y":1023.4761659417834,"z":"90110745.0f08b8","wires":[]},{"id":"73c9dbdb.c05d54","type":"comment","name":"First check from the current index to the max index","info":"","comments":"","x":1037.0595397949219,"y":1431.1905206952777,"z":"90110745.0f08b8","wires":[]},{"id":"1b12fce7.736083","type":"comment","name":"check if we've used this name before","info":"","comments":"","x":1616.1073913574219,"y":1780.4765853881836,"z":"90110745.0f08b8","wires":[]},{"id":"60c15f95.e82e1","type":"failure","name":"failure","xml":"\n","comments":"","outputs":1,"x":1723.7261924743652,"y":1857.8573679242816,"z":"90110745.0f08b8","wires":[["d699e5de.1c2618"]]},{"id":"38122015.0cd4f","type":"set","name":"set generate-unique-name-output.error-message","xml":"\n\n","comments":"","x":2169.6784439086914,"y":1831.4287008558001,"z":"90110745.0f08b8","wires":[]},{"id":"9f978d91.b34da","type":"returnFailure","name":"BREAK","xml":"\n","comments":"","x":2034.916690826416,"y":1876.4287885938372,"z":"90110745.0f08b8","wires":[]},{"id":"48493fbe.6eb1a","type":"returnFailure","name":"BREAK","xml":"\n","comments":"","x":2037.7737121582031,"y":1971.33347933633,"z":"90110745.0f08b8","wires":[]},{"id":"ff71e11.cb7392","type":"comment","name":"found one we can use","info":"","comments":"","x":1855.6311683654785,"y":1902.3814014707293,"z":"90110745.0f08b8","wires":[]},{"id":"a0df1e14.0a77c","type":"switchNode","name":"switch generate-unique-name-output.error-message","xml":"\n","comments":"","outputs":1,"x":987.8928833007812,"y":2185.7143883023946,"z":"90110745.0f08b8","wires":[["47956a10.f7f354","822e2233.58978"]]},{"id":"47956a10.f7f354","type":"outcome","name":"NULL","xml":"","comments":"","outputs":1,"x":1261.2262916564941,"y":2159.0476402555196,"z":"90110745.0f08b8","wires":[["9fcbb9ed.6b3558"]]},{"id":"9fcbb9ed.6b3558","type":"block","name":"block","xml":"\n","atomic":"false","comments":"","outputs":1,"x":1396.2262916564941,"y":2159.0476402555196,"z":"90110745.0f08b8","wires":[[]]},{"id":"822e2233.58978","type":"other","name":"other","xml":"\n","comments":"","outputs":1,"x":1261.2262573242188,"y":2209.0476612363545,"z":"90110745.0f08b8","wires":[["d471ec21.e29e1"]]},{"id":"d471ec21.e29e1","type":"returnFailure","name":"return failure","xml":"\n","comments":"","x":1411.2262573242188,"y":2209.0476612363545,"z":"90110745.0f08b8","wires":[]},{"id":"2db87246.6ac1ae","type":"switchNode","name":"switch found-flag","xml":"\n","comments":"","outputs":1,"x":859.6071929931641,"y":2468.5715078626363,"z":"90110745.0f08b8","wires":[["1afe7988.3e2406","382ec618.a7ddba"]]},{"id":"1afe7988.3e2406","type":"outcome","name":"true","xml":"","comments":"","outputs":1,"x":1033.9405326843262,"y":2468.5715088163106,"z":"90110745.0f08b8","wires":[["3d2939f2.411d96"]]},{"id":"97761528.22f748","type":"set","name":"set generate-unique-name-output.generated-name","xml":"\n\n","comments":"","x":1504.6071472167969,"y":2313.5717949186055,"z":"90110745.0f08b8","wires":[]},{"id":"eda538a7.a89168","type":"returnSuccess","name":"return success","xml":"\n","comments":"","x":1386.6547164916992,"y":2650.952589443752,"z":"90110745.0f08b8","wires":[]},{"id":"3d2939f2.411d96","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":1185.607162475586,"y":2467.9049228940694,"z":"90110745.0f08b8","wires":[["97761528.22f748","8aabfd4d.0ee5a","b24cce42.caeba","eda538a7.a89168","76d2de9f.d1d72"]]},{"id":"77a666ae.651d38","type":"set","name":"set index-exists flag to false","xml":"\n\n","comments":"","x":1485.8689880371094,"y":1067.142887524196,"z":"90110745.0f08b8","wires":[]},{"id":"21842051.8fdc8","type":"set","name":"set index-exists flag to true","xml":"\n\n","comments":"","x":1482.0120010375977,"y":978.571439913341,"z":"90110745.0f08b8","wires":[]},{"id":"4cecef4a.45b81","type":"block","name":"block","xml":"\n","atomic":"false","comments":"","outputs":1,"x":1288.7262725830078,"y":1000.0000459466662,"z":"90110745.0f08b8","wires":[["21842051.8fdc8","e52dd26e.0f4e"]]},{"id":"8aabfd4d.0ee5a","type":"switchNode","name":"switch index-exists","xml":"\n","comments":"","outputs":1,"x":1400.369155883789,"y":2445.714796475002,"z":"90110745.0f08b8","wires":[["346f0424.17228c","2db882f9.07b2be"]]},{"id":"346f0424.17228c","type":"outcomeTrue","name":"true","xml":"\n","comments":"","outputs":1,"x":1578.9405212402344,"y":2421.429064205715,"z":"90110745.0f08b8","wires":[["46d7a7fe.5f3bf8"]]},{"id":"2db882f9.07b2be","type":"outcomeFalse","name":"false","xml":"\n","comments":"","outputs":1,"x":1578.9405364990234,"y":2468.571989468166,"z":"90110745.0f08b8","wires":[["a296a95c.85f908"]]},{"id":"783bc8f9.d13d28","type":"save","name":"save (update) name index","xml":"\n","comments":"","outputs":1,"x":1974.6548461914062,"y":2422.857480457851,"z":"90110745.0f08b8","wires":[["67762a25.ef1984"]]},{"id":"c608a7c.ab02058","type":"save","name":"save (insert) name index","xml":"\n","comments":"","outputs":1,"x":1967.5118255615234,"y":2517.1429485593526,"z":"90110745.0f08b8","wires":[["396de0c3.36e29"]]},{"id":"67762a25.ef1984","type":"failure","name":"failure","xml":"\n","comments":"","outputs":1,"x":2167.512046813965,"y":2422.8574995313375,"z":"90110745.0f08b8","wires":[["77e2ebe5.4aacd4"]]},{"id":"396de0c3.36e29","type":"failure","name":"failure","xml":"\n","comments":"","outputs":1,"x":2164.6546173095703,"y":2515.71446459634,"z":"90110745.0f08b8","wires":[["a64a1c5c.548e1"]]},{"id":"b24cce42.caeba","type":"save","name":"save (insert) generated name","xml":"\n","comments":"","outputs":1,"x":1434.797752380371,"y":2604.2857708249776,"z":"90110745.0f08b8","wires":[["6e840dcf.98d2c4"]]},{"id":"6e840dcf.98d2c4","type":"failure","name":"failure","xml":"\n","comments":"","outputs":1,"x":1644.7976837158203,"y":2604.2858223233907,"z":"90110745.0f08b8","wires":[["14711303.85363d"]]},{"id":"14711303.85363d","type":"returnFailure","name":"return failure","xml":"\n \n","comments":"","x":1799.0834999084473,"y":2604.285841396877,"z":"90110745.0f08b8","wires":[]},{"id":"a9e87bf7.6d8b68","type":"set","name":"set sql statement","xml":"\n\n","comments":"","x":877.2976760864258,"y":958.5715393338885,"z":"90110745.0f08b8","wires":[]},{"id":"91d927f9.353948","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":1315.8690567016602,"y":1491.428631237575,"z":"90110745.0f08b8","wires":[["314df997.3fe296","630383d6.9584cc","3e27b62f.f1d58a","880d7037.87ac9"]]},{"id":"d699e5de.1c2618","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":1876.1071891784668,"y":1857.3812870298113,"z":"90110745.0f08b8","wires":[["38122015.0cd4f","9f978d91.b34da"]]},{"id":"46d7a7fe.5f3bf8","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":1756.226333618164,"y":2398.5715927396504,"z":"90110745.0f08b8","wires":[["d44f050d.8c0008","783bc8f9.d13d28"]]},{"id":"a296a95c.85f908","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":1753.3691864013672,"y":2494.285911015102,"z":"90110745.0f08b8","wires":[["c608a7c.ab02058","462aa6c7.448d08"]]},{"id":"d44f050d.8c0008","type":"set","name":"set sql statement","xml":"\n\n","comments":"","x":1944.7976150512695,"y":2374.285564354488,"z":"90110745.0f08b8","wires":[]},{"id":"462aa6c7.448d08","type":"set","name":"set sql statement","xml":"\n\n\n","comments":"","x":1943.3691635131836,"y":2468.571381023952,"z":"90110745.0f08b8","wires":[]},{"id":"bbed7686.7c8a78","type":"not-found","name":"not-found","xml":"\n","comments":"","outputs":1,"x":1730.3929290771484,"y":1948.8097633634295,"z":"90110745.0f08b8","wires":[["193702b8.5c51ed"]]},{"id":"6d5c7c0e.2718a4","type":"for","name":"for idx from 1 to current index","xml":"\n","comments":"","outputs":1,"x":1580.1787033081055,"y":3060.5239128385274,"z":"90110745.0f08b8","wires":[["c87de081.2b7b6"]]},{"id":"1185013a.772fcf","type":"block","name":"block","xml":"\n","atomic":"false","comments":"","outputs":1,"x":1348.5119857788086,"y":3060.5239137922017,"z":"90110745.0f08b8","wires":[["6d5c7c0e.2718a4","bf365e0a.2dfca"]]},{"id":"bf365e0a.2dfca","type":"returnSuccess","name":"CATCH BREAK","xml":"\n\n","comments":"","x":1531.1310958862305,"y":3635.5240434919087,"z":"90110745.0f08b8","wires":[]},{"id":"9144f7d0.dfe548","type":"switchNode","name":"switch generate-unique-name-input.index-length","xml":"\n","comments":"","outputs":1,"x":2141.8452682495117,"y":2987.1905864988057,"z":"90110745.0f08b8","wires":[["644f5421.41381c","e5c0619b.7a065","e0c68335.db7ab","41de4558.401f8c"]]},{"id":"644f5421.41381c","type":"outcome","name":"NULL","xml":"","comments":"","outputs":1,"x":2421.8452682495117,"y":2917.190647533962,"z":"90110745.0f08b8","wires":[["fb2ee76c.834068"]]},{"id":"e5c0619b.7a065","type":"outcome","name":"1","xml":"\n","comments":"","outputs":1,"x":2420.1786155700684,"y":2962.1906875882833,"z":"90110745.0f08b8","wires":[["fb2ee76c.834068"]]},{"id":"e0c68335.db7ab","type":"outcome","name":"2","xml":"\n","comments":"","outputs":1,"x":2420.1787033081055,"y":3015.52403490884,"z":"90110745.0f08b8","wires":[["21e6c935.f093a6"]]},{"id":"41de4558.401f8c","type":"outcome","name":"3","xml":"\n","comments":"","outputs":1,"x":2420.178581237793,"y":3112.190767696926,"z":"90110745.0f08b8","wires":[["ae67a8d.0fd0d58"]]},{"id":"fb2ee76c.834068","type":"set","name":"set index-string to idx","xml":"\n\n","comments":"","x":2606.845417022705,"y":2935.5239910398213,"z":"90110745.0f08b8","wires":[]},{"id":"21e6c935.f093a6","type":"switchNode","name":"switch idx < 10","xml":"\n","comments":"","outputs":1,"x":2586.8453330993652,"y":3015.523932865688,"z":"90110745.0f08b8","wires":[["c00eb747.c971c8","7a0fee3a.c8155"]]},{"id":"c00eb747.c971c8","type":"outcomeTrue","name":"true","xml":"\n","comments":"","outputs":1,"x":2748.5119667053223,"y":2988.857305935451,"z":"90110745.0f08b8","wires":[["c515b54.3569d48"]]},{"id":"7a0fee3a.c8155","type":"outcomeFalse","name":"false","xml":"\n","comments":"","outputs":1,"x":2748.5119247436523,"y":3037.190641811916,"z":"90110745.0f08b8","wires":[["de2fc71d.e11088"]]},{"id":"c515b54.3569d48","type":"set","name":"set index-string to '0' + idx","xml":"\n\n","comments":"","x":2940.178726196289,"y":2988.190533093044,"z":"90110745.0f08b8","wires":[]},{"id":"de2fc71d.e11088","type":"set","name":"set index-string to idx","xml":"\n\n","comments":"","x":2923.511978149414,"y":3036.8572487149922,"z":"90110745.0f08b8","wires":[]},{"id":"ae67a8d.0fd0d58","type":"switchNode","name":"switch idx < 10","xml":"\n","comments":"","outputs":1,"x":2588.511917114258,"y":3110.5238956723897,"z":"90110745.0f08b8","wires":[["c8925f4d.077c6","12f4b493.683e8b"]]},{"id":"c8925f4d.077c6","type":"outcomeTrue","name":"true","xml":"\n","comments":"","outputs":1,"x":2748.511894226074,"y":3083.8572735105245,"z":"90110745.0f08b8","wires":[["c22d1aeb.d63b48"]]},{"id":"12f4b493.683e8b","type":"outcomeFalse","name":"false","xml":"\n","comments":"","outputs":1,"x":2750.178550720215,"y":3158.8572315488545,"z":"90110745.0f08b8","wires":[["90f5c134.3ca9"]]},{"id":"c22d1aeb.d63b48","type":"set","name":"set index-string to '00' + idx","xml":"\n\n","comments":"","x":2943.511978149414,"y":3083.8572487149922,"z":"90110745.0f08b8","wires":[]},{"id":"90f5c134.3ca9","type":"switchNode","name":"switch idx < 100","xml":"\n","comments":"","outputs":1,"x":2906.511932373047,"y":3157.1905922208516,"z":"90110745.0f08b8","wires":[["87f17e57.81d71","f8e50bff.aaa1f8"]]},{"id":"87f17e57.81d71","type":"outcomeTrue","name":"true","xml":"\n","comments":"","outputs":1,"x":3063.5119094848633,"y":3130.5239700589864,"z":"90110745.0f08b8","wires":[["caf5e13b.23238"]]},{"id":"f8e50bff.aaa1f8","type":"outcomeFalse","name":"false","xml":"\n","comments":"","outputs":1,"x":3063.5118675231934,"y":3178.857305935451,"z":"90110745.0f08b8","wires":[["2e72859.272837a"]]},{"id":"caf5e13b.23238","type":"set","name":"set index-string to '0' + idx","xml":"\n\n","comments":"","x":3256.178695678711,"y":3130.1906246457784,"z":"90110745.0f08b8","wires":[]},{"id":"2e72859.272837a","type":"set","name":"set index-string to idx","xml":"\n\n","comments":"","x":3240.178680419922,"y":3178.5239280973165,"z":"90110745.0f08b8","wires":[]},{"id":"9775d1bd.a31a5","type":"set","name":"set generated-name to prefix + index-string","xml":"\n\n","comments":"","x":2125.845359802246,"y":3263.857235363552,"z":"90110745.0f08b8","wires":[]},{"id":"35bc5497.2d892c","type":"comment","name":"Wrapping around - now check from 1 to the original index","info":"","comments":"","x":1553.5120162963867,"y":2946.000319889614,"z":"90110745.0f08b8","wires":[]},{"id":"ccb5f6ab.ef5478","type":"comment","name":"check if we've used this name before","info":"","comments":"","x":2112.5598068237305,"y":3378.8575090680806,"z":"90110745.0f08b8","wires":[]},{"id":"e74cf3af.ae8e8","type":"get-resource","name":"get-resource name","xml":"\n\n","comments":"","outputs":1,"x":2050.178623199463,"y":3519.571578979492,"z":"90110745.0f08b8","wires":[["2f478f3e.e0607","398f430e.7a743c"]]},{"id":"2f478f3e.e0607","type":"failure","name":"failure","xml":"\n","comments":"","outputs":1,"x":2228.5120162963867,"y":3473.8574156079976,"z":"90110745.0f08b8","wires":[["c9df5194.5868"]]},{"id":"9ffe2099.9294f","type":"set","name":"set generate-unique-name-output.error-message","xml":"\n\n","comments":"","x":2674.464267730713,"y":3447.428748539516,"z":"90110745.0f08b8","wires":[]},{"id":"745383f6.b6740c","type":"returnFailure","name":"BREAK","xml":"\n","comments":"","x":2539.7025146484375,"y":3492.4288362775533,"z":"90110745.0f08b8","wires":[]},{"id":"cd5abdec.20e31","type":"switchNode","name":"switch generate-unique-name-output.error-message","xml":"\n","comments":"","outputs":1,"x":1512.5595932006836,"y":3743.381119183132,"z":"90110745.0f08b8","wires":[["8a7bb59.e987548","ec85a0b6.70f26"]]},{"id":"8a7bb59.e987548","type":"outcome","name":"NULL","xml":"","comments":"","outputs":1,"x":1785.8930015563965,"y":3716.714371136257,"z":"90110745.0f08b8","wires":[["13932aab.cff7c5"]]},{"id":"13932aab.cff7c5","type":"block","name":"block","xml":"\n","atomic":"false","comments":"","outputs":1,"x":1920.8930015563965,"y":3716.714371136257,"z":"90110745.0f08b8","wires":[[]]},{"id":"ec85a0b6.70f26","type":"other","name":"other","xml":"\n","comments":"","outputs":1,"x":1785.892967224121,"y":3766.714392117092,"z":"90110745.0f08b8","wires":[["a496c9cc.3afe48"]]},{"id":"a496c9cc.3afe48","type":"returnFailure","name":"return failure","xml":"\n","comments":"","x":1935.892967224121,"y":3766.714392117092,"z":"90110745.0f08b8","wires":[]},{"id":"e38bddb.6889c2","type":"switchNode","name":"switch found-flag","xml":"\n","comments":"","outputs":1,"x":1394.2738723754883,"y":3922.905027798244,"z":"90110745.0f08b8","wires":[["d6f25ad7.1e9978"]]},{"id":"70380c05.64b0a4","type":"comment","name":"if db name is null we found an index we can use","info":"","comments":"","x":1560.9882125854492,"y":3872.428802898952,"z":"90110745.0f08b8","wires":[]},{"id":"d6f25ad7.1e9978","type":"outcome","name":"true","xml":"","comments":"","outputs":1,"x":1553.607192993164,"y":3922.9049848829,"z":"90110745.0f08b8","wires":[["e5da090c.731d68"]]},{"id":"feb55f31.73e7a","type":"set","name":"set generate-unique-name-output.generated-name","xml":"\n\n","comments":"","x":2029.2738571166992,"y":3871.238525799343,"z":"90110745.0f08b8","wires":[]},{"id":"89e6e738.067dc8","type":"returnSuccess","name":"return success","xml":"\n\n","comments":"","x":1912.7499084472656,"y":4210.047996929714,"z":"90110745.0f08b8","wires":[]},{"id":"e5da090c.731d68","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":1720.2738876342773,"y":3921.238203457424,"z":"90110745.0f08b8","wires":[["feb55f31.73e7a","4da56fe5.e07a7","e153c7a4.007a58","89e6e738.067dc8","9ece7ac0.84e2b8"]]},{"id":"4da56fe5.e07a7","type":"switchNode","name":"switch index-exists","xml":"\n","comments":"","outputs":1,"x":1925.0358657836914,"y":4003.3815273557393,"z":"90110745.0f08b8","wires":[["a21cdd7a.49ed","31ea122e.79dede"]]},{"id":"a21cdd7a.49ed","type":"outcomeTrue","name":"true","xml":"\n","comments":"","outputs":1,"x":2103.6072311401367,"y":3979.095795086452,"z":"90110745.0f08b8","wires":[["63c24c47.93cb44"]]},{"id":"31ea122e.79dede","type":"outcomeFalse","name":"false","xml":"\n","comments":"","outputs":1,"x":2103.607246398926,"y":4026.2387203489034,"z":"90110745.0f08b8","wires":[["a5ce5bde.1b0538"]]},{"id":"c6f53c8c.15009","type":"save","name":"save (update) name index","xml":"\n","comments":"","outputs":1,"x":2499.3215560913086,"y":3980.5242113385884,"z":"90110745.0f08b8","wires":[["5f753ea1.c860f"]]},{"id":"93519bfb.b8ef58","type":"save","name":"save (insert) name index","xml":"\n","comments":"","outputs":1,"x":2492.178535461426,"y":4074.80967944009,"z":"90110745.0f08b8","wires":[["cb6afb42.e26668"]]},{"id":"5f753ea1.c860f","type":"failure","name":"failure","xml":"\n","comments":"","outputs":1,"x":2692.178756713867,"y":3980.5242304120748,"z":"90110745.0f08b8","wires":[["87791e94.3a263"]]},{"id":"87791e94.3a263","type":"returnFailure","name":"return failure","xml":"\n \n","comments":"","x":2846.464572906494,"y":3980.524249485561,"z":"90110745.0f08b8","wires":[]},{"id":"cb6afb42.e26668","type":"failure","name":"failure","xml":"\n","comments":"","outputs":1,"x":2689.3213272094727,"y":4073.381195477077,"z":"90110745.0f08b8","wires":[["7e817d75.e13cb4"]]},{"id":"7e817d75.e13cb4","type":"returnFailure","name":"return failure","xml":"\n \n","comments":"","x":2843.6071434020996,"y":4073.3812145505635,"z":"90110745.0f08b8","wires":[]},{"id":"e153c7a4.007a58","type":"save","name":"save (insert) generated name","xml":"\n","comments":"","outputs":1,"x":1959.4644622802734,"y":4161.952501705715,"z":"90110745.0f08b8","wires":[["3737e1de.1f275e"]]},{"id":"3737e1de.1f275e","type":"failure","name":"failure","xml":"\n","comments":"","outputs":1,"x":2169.4643936157227,"y":4161.952553204128,"z":"90110745.0f08b8","wires":[["c41eb84f.1afce8"]]},{"id":"c41eb84f.1afce8","type":"returnFailure","name":"return failure","xml":"\n \n","comments":"","x":2323.7502098083496,"y":4161.952572277614,"z":"90110745.0f08b8","wires":[]},{"id":"c87de081.2b7b6","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":1822.321548461914,"y":3059.095426968166,"z":"90110745.0f08b8","wires":[["9144f7d0.dfe548","9775d1bd.a31a5","e74cf3af.ae8e8","49a5595e.684d18","30eb1a83.c57be6"]]},{"id":"c9df5194.5868","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":2380.8930130004883,"y":3473.3813347135274,"z":"90110745.0f08b8","wires":[["9ffe2099.9294f","745383f6.b6740c"]]},{"id":"63c24c47.93cb44","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":2280.8930435180664,"y":3956.2383236203877,"z":"90110745.0f08b8","wires":[["9f7397b5.b8e698","c6f53c8c.15009"]]},{"id":"a5ce5bde.1b0538","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":2278.0358963012695,"y":4051.9526418958394,"z":"90110745.0f08b8","wires":[["93519bfb.b8ef58","2396ee2e.6296a2"]]},{"id":"9f7397b5.b8e698","type":"set","name":"set sql statement","xml":"\n\n","comments":"","x":2469.464324951172,"y":3931.9522952352254,"z":"90110745.0f08b8","wires":[]},{"id":"2396ee2e.6296a2","type":"set","name":"set sql statement","xml":"\n\n\n","comments":"","x":2468.035873413086,"y":4026.2381119046895,"z":"90110745.0f08b8","wires":[]},{"id":"398f430e.7a743c","type":"not-found","name":"not-found","xml":"\n","comments":"","outputs":1,"x":2235.17875289917,"y":3564.8098110471456,"z":"90110745.0f08b8","wires":[["efb43154.90976"]]},{"id":"49a5595e.684d18","type":"set","name":"clear namedb.name","xml":"\n\n","comments":"","x":2050.892936706543,"y":3314.8097442899434,"z":"90110745.0f08b8","wires":[]},{"id":"4c9e63b6.428eec","type":"switchNode","name":"switch generate-unique-name-input.index-length","xml":"\n","comments":"","outputs":1,"x":1497.1786651611328,"y":2807.190584591457,"z":"90110745.0f08b8","wires":[["a88c76d2.c57508"]]},{"id":"a88c76d2.c57508","type":"outcome","name":"NULL","xml":"","comments":"","outputs":1,"x":1752.8929977416992,"y":2808.095493725368,"z":"90110745.0f08b8","wires":[["7d718b44.ba6f14"]]},{"id":"7d718b44.ba6f14","type":"returnFailure","name":"return failure","xml":"\n \n","comments":"","x":1910.0358810424805,"y":2808.095493725368,"z":"90110745.0f08b8","wires":[]},{"id":"15057783.9b13f8","type":"comment","name":"if we get here when there is no index length, then we have used up all 1000","info":"","comments":"","x":1628.6072616577148,"y":2763.8098081861226,"z":"90110745.0f08b8","wires":[]},{"id":"48f231a0.1295b","type":"returnFailure","name":"return failure","xml":"\n \n","comments":"","x":1388.6072807312012,"y":4323.095478466579,"z":"90110745.0f08b8","wires":[]},{"id":"4e23a92d.e2e488","type":"set","name":"set found-flag=false","xml":"\n\n","comments":"","x":883.0119400024414,"y":1234.2857422147479,"z":"90110745.0f08b8","wires":[]},{"id":"90ee10e.7fdccf","type":"set","name":"set found-flag=true","xml":"\n\n","comments":"","x":2074.6786308288574,"y":1923.0953316007342,"z":"90110745.0f08b8","wires":[]},{"id":"193702b8.5c51ed","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":1881.8214530944824,"y":1949.2382759366717,"z":"90110745.0f08b8","wires":[["90ee10e.7fdccf","48493fbe.6eb1a"]]},{"id":"e2c9737b.99e7f","type":"returnFailure","name":"BREAK","xml":"\n","comments":"","x":2540.035732269287,"y":3585.952526501247,"z":"90110745.0f08b8","wires":[]},{"id":"be7d48f6.6006d8","type":"comment","name":"found one we can use","info":"","comments":"","x":2357.8931884765625,"y":3517.0004486356465,"z":"90110745.0f08b8","wires":[]},{"id":"66fa06ee.f98f28","type":"set","name":"set found-flag=true","xml":"\n\n","comments":"","x":2576.9406509399414,"y":3537.7143787656514,"z":"90110745.0f08b8","wires":[]},{"id":"efb43154.90976","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":2384.0834732055664,"y":3563.857323101589,"z":"90110745.0f08b8","wires":[["66fa06ee.f98f28","e2c9737b.99e7f"]]},{"id":"583423a0.c77f8c","type":"switchNode","name":"switch generate-unique-name-input.supplied-name","xml":"\n","comments":"","outputs":1,"x":434.79754638671875,"y":340.7143215451922,"z":"90110745.0f08b8","wires":[["86bad139.04091","9dd1d0d8.1bd5f"]]},{"id":"86bad139.04091","type":"outcome","name":"NULL","xml":"","comments":"","outputs":1,"x":693.3690452575684,"y":367.85711710793635,"z":"90110745.0f08b8","wires":[["c38467.17e88b98"]]},{"id":"9dd1d0d8.1bd5f","type":"other","name":"other","xml":"\n","comments":"","outputs":1,"x":693.3690223693848,"y":310.7142872129168,"z":"90110745.0f08b8","wires":[["f19bef1d.3057b"]]},{"id":"1f92ba68.4441e6","type":"switchNode","name":"switch generate-unique-name-input.name-table-type","xml":"\n","comments":"","outputs":1,"x":1162.6546936035156,"y":246.42856829507014,"z":"90110745.0f08b8","wires":[["3cf36f75.3d9c6"]]},{"id":"3cf36f75.3d9c6","type":"outcome","name":"NULL","xml":"","comments":"","outputs":1,"x":1495.9878902435303,"y":246.4285778318133,"z":"90110745.0f08b8","wires":[["c20913bc.b8956"]]},{"id":"c20913bc.b8956","type":"returnFailure","name":"return failure","xml":"\n\n","comments":"","x":1667.6546669006348,"y":246.76188128335139,"z":"90110745.0f08b8","wires":[]},{"id":"f19bef1d.3057b","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":847.6547470092773,"y":309.28571741921564,"z":"90110745.0f08b8","wires":[["1f92ba68.4441e6","a5541836.ef0a18","f1e52879.fa9cb8"]]},{"id":"f1e52879.fa9cb8","type":"get-resource","name":"get-resource name","xml":"\n\n","comments":"","outputs":1,"x":1056.2261581420898,"y":339.2857326780047,"z":"90110745.0f08b8","wires":[["324fd762.c67938","5bbbc00e.34e41","85249bc8.1ea708"]]},{"id":"324fd762.c67938","type":"failure","name":"failure","xml":"\n","comments":"","outputs":1,"x":1238.8452072143555,"y":326.42862837655207,"z":"90110745.0f08b8","wires":[["bf63fff2.0717"]]},{"id":"a5541836.ef0a18","type":"set","name":"set sql statement","xml":"\n\n","comments":"","x":1049.7977104187012,"y":291.66675036294123,"z":"90110745.0f08b8","wires":[]},{"id":"5bbbc00e.34e41","type":"not-found","name":"not-found","xml":"\n","comments":"","outputs":1,"x":1246.9405632019043,"y":371.66673891884943,"z":"90110745.0f08b8","wires":[["2dce07c3.4cdde8"]]},{"id":"bf63fff2.0717","type":"returnFailure","name":"return failure","xml":"\n\n\n","comments":"","x":1394.7976303100586,"y":326.00003378731867,"z":"90110745.0f08b8","wires":[]},{"id":"85249bc8.1ea708","type":"other","name":"other","xml":"\n","comments":"","outputs":1,"x":1239.0833320617676,"y":413.57143252236506,"z":"90110745.0f08b8","wires":[["b470dc23.972cf"]]},{"id":"b470dc23.972cf","type":"returnFailure","name":"return failure","xml":"\n\n\n","comments":"","x":1394.7975692749023,"y":412.99999659402033,"z":"90110745.0f08b8","wires":[]},{"id":"beb8c925.e74138","type":"comment","name":"Caller supplied name - make sure it's not already used","info":"","comments":"","x":1192.5119018554688,"y":199.85713999611994,"z":"90110745.0f08b8","wires":[]},{"id":"2dce07c3.4cdde8","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":1396.2262573242188,"y":372.1428455625262,"z":"90110745.0f08b8","wires":[["8c2318a2.ecf138","2d4f1679.5fff5a"]]},{"id":"2d4f1679.5fff5a","type":"save","name":"save (insert) generated name","xml":"\n","comments":"","outputs":1,"x":1636.2262573242188,"y":396.42858164651057,"z":"90110745.0f08b8","wires":[["e58686f1.2a8ec8"]]},{"id":"e58686f1.2a8ec8","type":"failure","name":"failure","xml":"\n","comments":"","outputs":1,"x":1846.226188659668,"y":396.42863314492365,"z":"90110745.0f08b8","wires":[["c3a9c01e.0e1a8"]]},{"id":"c3a9c01e.0e1a8","type":"returnFailure","name":"return failure","xml":"\n\n","comments":"","x":2000.512004852295,"y":396.42865221841,"z":"90110745.0f08b8","wires":[]},{"id":"8c2318a2.ecf138","type":"set","name":"set sql statement","xml":"\n\n\n","comments":"","x":1596.226188659668,"y":346.4287590299334,"z":"90110745.0f08b8","wires":[]},{"id":"76d2de9f.d1d72","type":"set","name":"set sql statement","xml":"\n\n\n","comments":"","x":1396.2262115478516,"y":2557.8571314130513,"z":"90110745.0f08b8","wires":[]},{"id":"30eb1a83.c57be6","type":"set","name":"set sql statement","xml":"\n\n","comments":"","x":2044.3215103149414,"y":3430.238300732204,"z":"90110745.0f08b8","wires":[]},{"id":"9ece7ac0.84e2b8","type":"set","name":"set sql statement","xml":"\n\n\n","comments":"","x":1920.0357055664062,"y":4114.523828915188,"z":"90110745.0f08b8","wires":[]},{"id":"77e2ebe5.4aacd4","type":"returnFailure","name":"return failure","xml":"\n \n","comments":"","x":2319.083396911621,"y":2422.1428484235494,"z":"90110745.0f08b8","wires":[]},{"id":"a64a1c5c.548e1","type":"returnFailure","name":"return failure","xml":"\n \n","comments":"","x":2316.2260093688965,"y":2515.4286293302266,"z":"90110745.0f08b8","wires":[]},{"id":"382ec618.a7ddba","type":"outcomeFalse","name":"false","xml":"\n","comments":"","outputs":1,"x":1032.178508758545,"y":2752.8571705136983,"z":"90110745.0f08b8","wires":[["75ff300b.6f6dc"]]},{"id":"75ff300b.6f6dc","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":1183.0119171142578,"y":3364.523694447109,"z":"90110745.0f08b8","wires":[["4c9e63b6.428eec","1185013a.772fcf","cd5abdec.20e31","e38bddb.6889c2","48f231a0.1295b"]]},{"id":"c98722cf.dc1a3","type":"success","name":"success","xml":"\n","comments":"","outputs":1,"x":1149.65482711792,"y":999.2857116971697,"z":"90110745.0f08b8","wires":[["4cecef4a.45b81"]]},{"id":"b91db4d1.5863b8","type":"not-found","name":"not-found","xml":"\n","comments":"","outputs":1,"x":1156.2262916564941,"y":1088.4285854612078,"z":"90110745.0f08b8","wires":[["2195c896.9afd38"]]},{"id":"2195c896.9afd38","type":"block","name":"block","xml":"\n","atomic":"false","comments":"","outputs":1,"x":1287.654842376709,"y":1087.857191494533,"z":"90110745.0f08b8","wires":[["77a666ae.651d38","70192d95.678c34"]]},{"id":"880d7037.87ac9","type":"set","name":"set sql statement","xml":"\n\n","comments":"","x":1540.0000267028809,"y":1821.4285945892334,"z":"90110745.0f08b8","wires":[]},{"id":"3e27b62f.f1d58a","type":"get-resource","name":"get-resource name","xml":"\n\n","comments":"","outputs":1,"x":1541.4286346435547,"y":1908.571517944336,"z":"90110745.0f08b8","wires":[["60c15f95.e82e1","bbed7686.7c8a78"]]},{"id":"68aae923.1b9ef8","type":"block","name":"block : atomic","xml":"","atomic":"true","outputs":1,"x":133.75,"y":315.0000047683716,"z":"90110745.0f08b8","wires":[["583423a0.c77f8c","f553193.f9377e8"]]},{"id":"f553193.f9377e8","type":"set","name":"clear variables","xml":"\n\n\n","comments":"","x":322.50000381469727,"y":290.00000381469727,"z":"90110745.0f08b8","wires":[]}] +[ + { + "id": "15040625.d5f40a", + "type": "comment", + "name": "Validation of required data", + "info": "", + "comments": "", + "x": 1362.22216796875, + "y": 421.29468727111816, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "11c017ed.c4cc98", + "type": "dgstart", + "name": "DGSTART", + "outputs": 1, + "x": 432.9722709655762, + "y": 26.69937038421631, + "z": "f2af2445.16fe78", + "wires": [ + [ + "9f71976e.e5c5f8" + ] + ] + }, + { + "id": "4eedc095.04b8b", + "type": "method", + "name": "method generate-unique-name", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 565.8889999389648, + "y": 99.044602394104, + "z": "f2af2445.16fe78", + "wires": [ + [ + "360fc793.866bf8" + ] + ] + }, + { + "id": "23286af8.e7fb96", + "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": 1120.5314331054688, + "y": 20, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "d51fb171.df3c3", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 849.9960746765137, + "y": 1412.440560749599, + "z": "f2af2445.16fe78", + "wires": [ + [ + "aeb040b1.610fe", + "d5c2022c.eb55c", + "6937019b.7d45d", + "bcb4efa7.8fb4d", + "4d3aaea2.1682c", + "6c67d02f.17bf4", + "c51e026f.e6689", + "2d26f683.ab135a", + "f849cb78.2321f8", + "59510b56.12c9f4", + "3e63e2e.8d66c1e", + "c2125c33.cdb9e" + ] + ] + }, + { + "id": "aeb040b1.610fe", + "type": "switchNode", + "name": "switch generate-unique-name-input.index-table-name", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1298.8055572509766, + "y": 466.9048252105713, + "z": "f2af2445.16fe78", + "wires": [ + [ + "1286f8.7a830909" + ] + ] + }, + { + "id": "1286f8.7a830909", + "type": "outcome", + "name": "NULL", + "xml": "", + "comments": "", + "outputs": 1, + "x": 1628.805477142334, + "y": 466.9048147201538, + "z": "f2af2445.16fe78", + "wires": [ + [ + "c3b06eda.624f2" + ] + ] + }, + { + "id": "c3b06eda.624f2", + "type": "returnFailure", + "name": "return failure", + "xml": "\n\n", + "comments": "", + "x": 1802.1387977600098, + "y": 466.90480613708496, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "d5c2022c.eb55c", + "type": "switchNode", + "name": "switch generate-unique-name-input.index-table-prefix-column", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1323.8055267333984, + "y": 510.23816108703613, + "z": "f2af2445.16fe78", + "wires": [ + [ + "8b8a2d3c.650b5" + ] + ] + }, + { + "id": "8b8a2d3c.650b5", + "type": "outcome", + "name": "NULL", + "xml": "", + "comments": "", + "outputs": 1, + "x": 1627.1387901306152, + "y": 510.2381401062012, + "z": "f2af2445.16fe78", + "wires": [ + [ + "2fce40e3.dcb3a" + ] + ] + }, + { + "id": "2fce40e3.dcb3a", + "type": "returnFailure", + "name": "return failure", + "xml": "\n\n", + "comments": "", + "x": 1800.4721069335938, + "y": 510.57148361206055, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "6937019b.7d45d", + "type": "switchNode", + "name": "switch generate-unique-name-input.name-table-type", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1294.805534362793, + "y": 555.2381534576416, + "z": "f2af2445.16fe78", + "wires": [ + [ + "fe8ebb70.f12418" + ] + ] + }, + { + "id": "fe8ebb70.f12418", + "type": "outcome", + "name": "NULL", + "xml": "", + "comments": "", + "outputs": 1, + "x": 1627.1387310028076, + "y": 555.2381629943848, + "z": "f2af2445.16fe78", + "wires": [ + [ + "c450338.ed9f6d" + ] + ] + }, + { + "id": "c450338.ed9f6d", + "type": "returnFailure", + "name": "return failure", + "xml": "\n\n", + "comments": "", + "x": 1798.805507659912, + "y": 555.5714664459229, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "c51e026f.e6689", + "type": "get-resource", + "name": "get-resource current name index", + "xml": "\n\n", + "comments": "", + "outputs": 1, + "x": 1216.829387664795, + "y": 1114.0355405807495, + "z": "f2af2445.16fe78", + "wires": [ + [ + "2161e5d1.539e3a", + "b88e0290.6b67d", + "a98b0c69.c8ff5" + ] + ] + }, + { + "id": "2161e5d1.539e3a", + "type": "failure", + "name": "failure", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1444.5198192596436, + "y": 1200.0594501495361, + "z": "f2af2445.16fe78", + "wires": [ + [ + "d996887b.f8a558" + ] + ] + }, + { + "id": "d996887b.f8a558", + "type": "returnFailure", + "name": "return failure", + "xml": "\n \n", + "comments": "", + "x": 1607.1389408111572, + "y": 1201.4881782531738, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "b684649d.306688", + "type": "for", + "name": "for idx from current index to list-end", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1371.6627464294434, + "y": 1442.8571510314941, + "z": "f2af2445.16fe78", + "wires": [ + [ + "c4de9305.e3b5f" + ] + ] + }, + { + "id": "bcb4efa7.8fb4d", + "type": "block", + "name": "block", + "xml": "\n", + "atomic": "false", + "comments": "", + "outputs": 1, + "x": 1134.2817420959473, + "y": 1442.857116154262, + "z": "f2af2445.16fe78", + "wires": [ + [ + "b684649d.306688", + "a13f9156.7cff2", + "187251ba.f9a6ce" + ] + ] + }, + { + "id": "a13f9156.7cff2", + "type": "returnSuccess", + "name": "CATCH BREAK", + "xml": "\n\n", + "comments": "", + "x": 1327.472242627825, + "y": 2467.2858533859253, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "4d3aaea2.1682c", + "type": "switchNode", + "name": "switch generate-unique-name-input.prefix", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1260.4721755981445, + "y": 600.2381324768066, + "z": "f2af2445.16fe78", + "wires": [ + [ + "d42fa470.81ab78" + ] + ] + }, + { + "id": "d42fa470.81ab78", + "type": "outcome", + "name": "NULL", + "xml": "", + "comments": "", + "outputs": 1, + "x": 1627.8053646087646, + "y": 600.2381572723389, + "z": "f2af2445.16fe78", + "wires": [ + [ + "af0a5a6c.8f2da8" + ] + ] + }, + { + "id": "af0a5a6c.8f2da8", + "type": "returnFailure", + "name": "return failure", + "xml": "\n\n", + "comments": "", + "x": 1800.4721412658691, + "y": 600.571460723877, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "6c67d02f.17bf4", + "type": "switchNode", + "name": "switch generate-unique-name-input.index-length", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1283.8055419921875, + "y": 735.2380743026733, + "z": "f2af2445.16fe78", + "wires": [ + [ + "185b25b7.55418a", + "208a685c.353108", + "d9e7f7d8.523f68", + "7ee1530f.9a7ebc", + "157b96c3.7936e9", + "26eda43b.2c3b5c", + "59274ef2.cf994" + ] + ] + }, + { + "id": "185b25b7.55418a", + "type": "outcome", + "name": "NULL", + "xml": "", + "comments": "", + "outputs": 1, + "x": 1627.1388549804688, + "y": 643.571460723877, + "z": "f2af2445.16fe78", + "wires": [ + [ + "d94c4d3c.5f17d" + ] + ] + }, + { + "id": "157b96c3.7936e9", + "type": "other", + "name": "other", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1625.9007606506348, + "y": 918.809588432312, + "z": "f2af2445.16fe78", + "wires": [ + [ + "c70900c9.1665f" + ] + ] + }, + { + "id": "208a685c.353108", + "type": "outcome", + "name": "1", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1624.0436630249023, + "y": 734.2857999801636, + "z": "f2af2445.16fe78", + "wires": [ + [ + "923d6c6a.e4f8d" + ] + ] + }, + { + "id": "d9e7f7d8.523f68", + "type": "outcome", + "name": "2", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1624.0436477661133, + "y": 779.2857904434204, + "z": "f2af2445.16fe78", + "wires": [ + [ + "d39e047e.b0fc98" + ] + ] + }, + { + "id": "7ee1530f.9a7ebc", + "type": "outcome", + "name": "3", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1622.3769836425781, + "y": 822.6191263198853, + "z": "f2af2445.16fe78", + "wires": [ + [ + "70f9e263.445b3c" + ] + ] + }, + { + "id": "923d6c6a.e4f8d", + "type": "set", + "name": "set list-end = 10", + "xml": "\n\n", + "comments": "", + "x": 1806.7103996276855, + "y": 734.2857885360718, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "d39e047e.b0fc98", + "type": "set", + "name": "set list-end = 100", + "xml": "\n\n", + "comments": "", + "x": 1810.043628692627, + "y": 779.2857904434204, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "70f9e263.445b3c", + "type": "set", + "name": "set list-end = 1000", + "xml": "\n\n", + "comments": "", + "x": 1812.043628692627, + "y": 822.6191034317017, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "c70900c9.1665f", + "type": "returnFailure", + "name": "return failure", + "xml": "\n\n", + "comments": "", + "x": 1796.9006843566895, + "y": 918.1429586410522, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "80595c6f.d370b", + "type": "set", + "name": "set new index number to 1", + "xml": "\n\n", + "comments": "", + "x": 2311.0082054138184, + "y": 1163.4288799762726, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "d94c4d3c.5f17d", + "type": "set", + "name": "set list-end = 100000 (infinity basically)", + "xml": "\n\n", + "comments": "", + "x": 1876.1387939453125, + "y": 643.9048042297363, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "651d8bf.8378c74", + "type": "switchNode", + "name": "switch generate-unique-name-input.index-length", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1933.3293266296387, + "y": 1369.5237898145404, + "z": "f2af2445.16fe78", + "wires": [ + [ + "485a952f.4683ac", + "929353b9.9ddf2", + "fdae624e.d1e4d", + "f1fa6f3d.9cd86", + "c12d0b68.b45788" + ] + ] + }, + { + "id": "485a952f.4683ac", + "type": "outcome", + "name": "NULL", + "xml": "", + "comments": "", + "outputs": 1, + "x": 2217.6150703430176, + "y": 1220.9523973464966, + "z": "f2af2445.16fe78", + "wires": [ + [ + "93103f3e.f5587" + ] + ] + }, + { + "id": "929353b9.9ddf2", + "type": "outcome", + "name": "1", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2215.948417663574, + "y": 1265.9524374008179, + "z": "f2af2445.16fe78", + "wires": [ + [ + "93103f3e.f5587" + ] + ] + }, + { + "id": "fdae624e.d1e4d", + "type": "outcome", + "name": "2", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2215.948402404785, + "y": 1315.0000638961792, + "z": "f2af2445.16fe78", + "wires": [ + [ + "fe2daf39.916f2" + ] + ] + }, + { + "id": "f1fa6f3d.9cd86", + "type": "outcome", + "name": "3", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2217.3770751953125, + "y": 1417.381145477295, + "z": "f2af2445.16fe78", + "wires": [ + [ + "9b7d9fc5.77d19" + ] + ] + }, + { + "id": "93103f3e.f5587", + "type": "set", + "name": "set index-string to idx", + "xml": "\n\n", + "comments": "", + "x": 2402.615219116211, + "y": 1239.285740852356, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "fe2daf39.916f2", + "type": "switchNode", + "name": "switch idx < 10", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2382.615032196045, + "y": 1314.9999618530273, + "z": "f2af2445.16fe78", + "wires": [ + [ + "1e14c0e7.34b7bf", + "837fdec7.0a022" + ] + ] + }, + { + "id": "1e14c0e7.34b7bf", + "type": "outcomeTrue", + "name": "true", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2544.281665802002, + "y": 1288.3333349227905, + "z": "f2af2445.16fe78", + "wires": [ + [ + "3fe02145.d703be" + ] + ] + }, + { + "id": "837fdec7.0a022", + "type": "outcomeFalse", + "name": "false", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2544.281623840332, + "y": 1336.6666707992554, + "z": "f2af2445.16fe78", + "wires": [ + [ + "461425f5.d0f43c" + ] + ] + }, + { + "id": "3fe02145.d703be", + "type": "set", + "name": "set index-string to '0' + idx", + "xml": "\n\n", + "comments": "", + "x": 2735.9484252929688, + "y": 1287.6665620803833, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "461425f5.d0f43c", + "type": "set", + "name": "set index-string to idx", + "xml": "\n\n", + "comments": "", + "x": 2719.2816772460938, + "y": 1336.3332777023315, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "9b7d9fc5.77d19", + "type": "switchNode", + "name": "switch idx < 10", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2385.7104110717773, + "y": 1415.7142734527588, + "z": "f2af2445.16fe78", + "wires": [ + [ + "e219ec7e.fe57c", + "ad55e1a8.b6075" + ] + ] + }, + { + "id": "e219ec7e.fe57c", + "type": "outcomeTrue", + "name": "true", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2545.7103881835938, + "y": 1389.0476512908936, + "z": "f2af2445.16fe78", + "wires": [ + [ + "22b4d6dc.cf442a" + ] + ] + }, + { + "id": "ad55e1a8.b6075", + "type": "outcomeFalse", + "name": "false", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2550.2340087890625, + "y": 1465.4762334823608, + "z": "f2af2445.16fe78", + "wires": [ + [ + "dbe69aa8.33eda8" + ] + ] + }, + { + "id": "22b4d6dc.cf442a", + "type": "set", + "name": "set index-string to '00' + idx", + "xml": "\n\n", + "comments": "", + "x": 2740.710479736328, + "y": 1389.047542163304, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "dbe69aa8.33eda8", + "type": "switchNode", + "name": "switch idx < 100", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2706.5673904418945, + "y": 1463.809594154358, + "z": "f2af2445.16fe78", + "wires": [ + [ + "f7ffce1d.63fe1", + "67fc8e98.639b9" + ] + ] + }, + { + "id": "f7ffce1d.63fe1", + "type": "outcomeTrue", + "name": "true", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2863.567367553711, + "y": 1437.1429719924927, + "z": "f2af2445.16fe78", + "wires": [ + [ + "1c294f19.3865c1" + ] + ] + }, + { + "id": "67fc8e98.639b9", + "type": "outcomeFalse", + "name": "false", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2863.567325592041, + "y": 1485.4763078689575, + "z": "f2af2445.16fe78", + "wires": [ + [ + "3ab4c683.87c0fa" + ] + ] + }, + { + "id": "1c294f19.3865c1", + "type": "set", + "name": "set index-string to '0' + idx", + "xml": "\n\n", + "comments": "", + "x": 3056.2341537475586, + "y": 1436.8096265792847, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "3ab4c683.87c0fa", + "type": "set", + "name": "set index-string to idx", + "xml": "\n\n", + "comments": "", + "x": 3040.2341384887695, + "y": 1485.1429300308228, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "c81549dd.4990b8", + "type": "set", + "name": "set generated-name to prefix + index-string", + "xml": "\n\n", + "comments": "", + "x": 1917.329418182373, + "y": 1646.1904386792864, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "27f2f9ab.7e2c26", + "type": "comment", + "name": "First check from the current index to the max index", + "info": "", + "comments": "", + "x": 1334.9960899353027, + "y": 1381.1905197416033, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "4eb7a743.5209e8", + "type": "comment", + "name": "check if we've used this name before", + "info": "", + "comments": "", + "x": 1914.0439414978027, + "y": 1730.4765844345093, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "be62e7ae.90b8f8", + "type": "failure", + "name": "failure", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2021.662742614746, + "y": 1807.8573669706072, + "z": "f2af2445.16fe78", + "wires": [ + [ + "dfb2aa84.9b4598" + ] + ] + }, + { + "id": "1d6bb1a2.44855e", + "type": "set", + "name": "set generate-unique-name-output.error-message", + "xml": "\n\n", + "comments": "", + "x": 2467.6149940490723, + "y": 1781.4286999021258, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "a5f867db.9d9558", + "type": "returnFailure", + "name": "BREAK", + "xml": "\n", + "comments": "", + "x": 2332.853240966797, + "y": 1826.428787640163, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "ad173e2b.5c512", + "type": "returnFailure", + "name": "BREAK", + "xml": "\n", + "comments": "", + "x": 2335.710262298584, + "y": 1921.3334783826556, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "c15de393.a41e9", + "type": "comment", + "name": "found one we can use", + "info": "", + "comments": "", + "x": 2153.5677185058594, + "y": 1852.381400517055, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "2d26f683.ab135a", + "type": "switchNode", + "name": "switch generate-unique-name-output.error-message", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1209.5437147957937, + "y": 2679.2858324050903, + "z": "f2af2445.16fe78", + "wires": [ + [ + "77705736.9ef7c8", + "68085745.a74d48" + ] + ] + }, + { + "id": "77705736.9ef7c8", + "type": "outcome", + "name": "NULL", + "xml": "", + "comments": "", + "outputs": 1, + "x": 1482.8771231515066, + "y": 2652.6190843582153, + "z": "f2af2445.16fe78", + "wires": [ + [ + "bdffcfcf.9486c" + ] + ] + }, + { + "id": "bdffcfcf.9486c", + "type": "block", + "name": "block", + "xml": "\n", + "atomic": "false", + "comments": "", + "outputs": 1, + "x": 1617.8771231515066, + "y": 2652.6190843582153, + "z": "f2af2445.16fe78", + "wires": [ + [] + ] + }, + { + "id": "68085745.a74d48", + "type": "other", + "name": "other", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1482.8770888192312, + "y": 2702.6191053390503, + "z": "f2af2445.16fe78", + "wires": [ + [ + "2c4c0bf4.4ba724" + ] + ] + }, + { + "id": "2c4c0bf4.4ba724", + "type": "returnFailure", + "name": "return failure", + "xml": "\n", + "comments": "", + "x": 1632.8770888192312, + "y": 2702.6191053390503, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "f849cb78.2321f8", + "type": "switchNode", + "name": "switch found-flag", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1101.5437605721609, + "y": 3033.571455001831, + "z": "f2af2445.16fe78", + "wires": [ + [ + "f2e8b24d.e7494", + "c4268ba7.916128" + ] + ] + }, + { + "id": "f2e8b24d.e7494", + "type": "outcome", + "name": "true", + "xml": "", + "comments": "", + "outputs": 1, + "x": 1275.877100263323, + "y": 3033.5714559555054, + "z": "f2af2445.16fe78", + "wires": [ + [ + "db1278f8.147038" + ] + ] + }, + { + "id": "b4aa117c.62303", + "type": "set", + "name": "set generate-unique-name-output.generated-name", + "xml": "\n\n", + "comments": "", + "x": 1746.5437147957937, + "y": 2878.5717420578003, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "144ff8a5.06a137", + "type": "returnSuccess", + "name": "return success", + "xml": "\n", + "comments": "", + "x": 1628.591284070696, + "y": 3215.952536582947, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "db1278f8.147038", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 1427.5437300545827, + "y": 3032.904870033264, + "z": "f2af2445.16fe78", + "wires": [ + [ + "b4aa117c.62303", + "58767fb5.799f", + "7332878a.b6d298", + "144ff8a5.06a137", + "b3a55875.754e68" + ] + ] + }, + { + "id": "3d4b23e4.f03d2c", + "type": "set", + "name": "set index-exists flag to false", + "xml": "\n\n", + "comments": "", + "x": 1778.8055992126465, + "y": 1080.8929452896118, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "7b63453a.f976cc", + "type": "set", + "name": "set index-exists flag to true", + "xml": "\n\n", + "comments": "", + "x": 1777.448543548584, + "y": 984.8214712142944, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "f97c717e.aeece", + "type": "block", + "name": "block", + "xml": "\n", + "atomic": "false", + "comments": "", + "outputs": 1, + "x": 1584.1628150939941, + "y": 1006.2500772476196, + "z": "f2af2445.16fe78", + "wires": [ + [ + "7b63453a.f976cc", + "dc9a064f.20c918" + ] + ] + }, + { + "id": "58767fb5.799f", + "type": "switchNode", + "name": "switch index-exists", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1642.3057234627859, + "y": 3010.714743614197, + "z": "f2af2445.16fe78", + "wires": [ + [ + "6a0af996.974498", + "6c8e2cbe.78d944" + ] + ] + }, + { + "id": "6a0af996.974498", + "type": "outcomeTrue", + "name": "true", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1820.8770888192312, + "y": 2986.4290113449097, + "z": "f2af2445.16fe78", + "wires": [ + [ + "87bbd73a.280a98" + ] + ] + }, + { + "id": "6c8e2cbe.78d944", + "type": "outcomeFalse", + "name": "false", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1820.8771040780202, + "y": 3033.571936607361, + "z": "f2af2445.16fe78", + "wires": [ + [ + "784e1241.16399c" + ] + ] + }, + { + "id": "9bc6db3a.e853b8", + "type": "save", + "name": "save (update) name index", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2216.591413770403, + "y": 2987.857427597046, + "z": "f2af2445.16fe78", + "wires": [ + [ + "3aaf9849.6999f8" + ] + ] + }, + { + "id": "853b68e5.628e58", + "type": "save", + "name": "save (insert) name index", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2209.4483931405202, + "y": 3082.1428956985474, + "z": "f2af2445.16fe78", + "wires": [ + [ + "8c884666.ad49c8" + ] + ] + }, + { + "id": "3aaf9849.6999f8", + "type": "failure", + "name": "failure", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2409.4486143929616, + "y": 2987.857446670532, + "z": "f2af2445.16fe78", + "wires": [ + [ + "b2adf596.b14dc8" + ] + ] + }, + { + "id": "8c884666.ad49c8", + "type": "failure", + "name": "failure", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2406.591184888567, + "y": 3080.7144117355347, + "z": "f2af2445.16fe78", + "wires": [ + [ + "a521b607.e28cf8" + ] + ] + }, + { + "id": "7332878a.b6d298", + "type": "save", + "name": "save (insert) generated name", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1676.734319959368, + "y": 3169.2857179641724, + "z": "f2af2445.16fe78", + "wires": [ + [ + "ecbc8e26.1fa38" + ] + ] + }, + { + "id": "ecbc8e26.1fa38", + "type": "failure", + "name": "failure", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1886.734251294817, + "y": 3169.2857694625854, + "z": "f2af2445.16fe78", + "wires": [ + [ + "1f5bf102.8c12af" + ] + ] + }, + { + "id": "1f5bf102.8c12af", + "type": "returnFailure", + "name": "return failure", + "xml": "\n \n", + "comments": "", + "x": 2041.020067487444, + "y": 3169.285788536072, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "59510b56.12c9f4", + "type": "set", + "name": "set sql statement", + "xml": "\n\n", + "comments": "", + "x": 1172.734218597412, + "y": 964.8215706348419, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "c4de9305.e3b5f", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 1613.805606842041, + "y": 1442.4286302839007, + "z": "f2af2445.16fe78", + "wires": [ + [ + "651d8bf.8378c74", + "c81549dd.4990b8", + "5cfa637b.4338bc", + "a3abe6b2.a53fb8" + ] + ] + }, + { + "id": "dfb2aa84.9b4598", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 2174.0437393188477, + "y": 1807.381286076137, + "z": "f2af2445.16fe78", + "wires": [ + [ + "1d6bb1a2.44855e", + "a5f867db.9d9558" + ] + ] + }, + { + "id": "87bbd73a.280a98", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 1998.1629011971609, + "y": 2963.571539878845, + "z": "f2af2445.16fe78", + "wires": [ + [ + "5830bf50.31dae", + "9bc6db3a.e853b8" + ] + ] + }, + { + "id": "784e1241.16399c", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 1995.305753980364, + "y": 3059.285858154297, + "z": "f2af2445.16fe78", + "wires": [ + [ + "853b68e5.628e58", + "88572550.cad9b8" + ] + ] + }, + { + "id": "5830bf50.31dae", + "type": "set", + "name": "set sql statement", + "xml": "\n\n", + "comments": "", + "x": 2186.7341826302663, + "y": 2939.285511493683, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "88572550.cad9b8", + "type": "set", + "name": "set sql statement", + "xml": "\n\n\n", + "comments": "", + "x": 2185.3057310921804, + "y": 3033.571328163147, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "96f6c88d.8b7e38", + "type": "not-found", + "name": "not-found", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2028.3294792175293, + "y": 1898.8097624097552, + "z": "f2af2445.16fe78", + "wires": [ + [ + "41d904c1.515ddc" + ] + ] + }, + { + "id": "bf503344.2453a", + "type": "for", + "name": "for idx from 1 to current index", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1828.1153014046804, + "y": 3705.5238943099976, + "z": "f2af2445.16fe78", + "wires": [ + [ + "d892995.bb30f68" + ] + ] + }, + { + "id": "7c854eaa.cabde", + "type": "block", + "name": "block", + "xml": "\n", + "atomic": "false", + "comments": "", + "outputs": 1, + "x": 1614.4485479082377, + "y": 3705.523872920445, + "z": "f2af2445.16fe78", + "wires": [ + [ + "bf503344.2453a", + "9ffe82b8.b73ec" + ] + ] + }, + { + "id": "9ffe82b8.b73ec", + "type": "returnSuccess", + "name": "CATCH BREAK", + "xml": "\n\n", + "comments": "", + "x": 1779.0676939828054, + "y": 4280.524024963379, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "94f9f0ef.6fa0d", + "type": "switchNode", + "name": "switch generate-unique-name-input.index-length", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2375.781873975481, + "y": 3660.1906385421753, + "z": "f2af2445.16fe78", + "wires": [ + [ + "266ce65b.b0b66a", + "97bab24a.c840c", + "3d984119.5f033e", + "3e3c8d28.fe1a32" + ] + ] + }, + { + "id": "266ce65b.b0b66a", + "type": "outcome", + "name": "NULL", + "xml": "", + "comments": "", + "outputs": 1, + "x": 2655.781873975481, + "y": 3590.1906995773315, + "z": "f2af2445.16fe78", + "wires": [ + [ + "dfbbc1b8.5e5ce" + ] + ] + }, + { + "id": "97bab24a.c840c", + "type": "outcome", + "name": "1", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2654.115221296038, + "y": 3635.190739631653, + "z": "f2af2445.16fe78", + "wires": [ + [ + "dfbbc1b8.5e5ce" + ] + ] + }, + { + "id": "3d984119.5f033e", + "type": "outcome", + "name": "2", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2654.115309034075, + "y": 3688.5240869522095, + "z": "f2af2445.16fe78", + "wires": [ + [ + "deb2ba7e.8c5978" + ] + ] + }, + { + "id": "3e3c8d28.fe1a32", + "type": "outcome", + "name": "3", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2654.1151869637624, + "y": 3785.1908197402954, + "z": "f2af2445.16fe78", + "wires": [ + [ + "eb7b9bc3.3d21f8" + ] + ] + }, + { + "id": "dfbbc1b8.5e5ce", + "type": "set", + "name": "set index-string to idx", + "xml": "\n\n", + "comments": "", + "x": 2840.7820227486745, + "y": 3608.524043083191, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "deb2ba7e.8c5978", + "type": "switchNode", + "name": "switch idx < 10", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2820.7819388253347, + "y": 3688.5239849090576, + "z": "f2af2445.16fe78", + "wires": [ + [ + "937abb25.5405e8", + "5f465025.bda92" + ] + ] + }, + { + "id": "937abb25.5405e8", + "type": "outcomeTrue", + "name": "true", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2982.4485724312917, + "y": 3661.857357978821, + "z": "f2af2445.16fe78", + "wires": [ + [ + "b0abf2f9.7e53f" + ] + ] + }, + { + "id": "5f465025.bda92", + "type": "outcomeFalse", + "name": "false", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2982.448530469622, + "y": 3710.1906938552856, + "z": "f2af2445.16fe78", + "wires": [ + [ + "ba4422ab.99ab3" + ] + ] + }, + { + "id": "b0abf2f9.7e53f", + "type": "set", + "name": "set index-string to '0' + idx", + "xml": "\n\n", + "comments": "", + "x": 3174.1153319222585, + "y": 3661.1905851364136, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "ba4422ab.99ab3", + "type": "set", + "name": "set index-string to idx", + "xml": "\n\n", + "comments": "", + "x": 3157.4485838753835, + "y": 3709.857300758362, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "eb7b9bc3.3d21f8", + "type": "switchNode", + "name": "switch idx < 10", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2822.4485228402273, + "y": 3783.5239477157593, + "z": "f2af2445.16fe78", + "wires": [ + [ + "14d2288c.c6a057", + "d8edd84e.af3bc8" + ] + ] + }, + { + "id": "14d2288c.c6a057", + "type": "outcomeTrue", + "name": "true", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2982.4484999520437, + "y": 3756.857325553894, + "z": "f2af2445.16fe78", + "wires": [ + [ + "62627b5d.5978e4" + ] + ] + }, + { + "id": "d8edd84e.af3bc8", + "type": "outcomeFalse", + "name": "false", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2984.1151564461843, + "y": 3831.857283592224, + "z": "f2af2445.16fe78", + "wires": [ + [ + "30bfdb15.2f8ad4" + ] + ] + }, + { + "id": "62627b5d.5978e4", + "type": "set", + "name": "set index-string to '00' + idx", + "xml": "\n\n", + "comments": "", + "x": 3177.4485838753835, + "y": 3756.857300758362, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "30bfdb15.2f8ad4", + "type": "switchNode", + "name": "switch idx < 100", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 3140.4485380990163, + "y": 3830.190644264221, + "z": "f2af2445.16fe78", + "wires": [ + [ + "440bf02e.68e61", + "b8862f98.abf7a" + ] + ] + }, + { + "id": "440bf02e.68e61", + "type": "outcomeTrue", + "name": "true", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 3297.4485152108327, + "y": 3803.524022102356, + "z": "f2af2445.16fe78", + "wires": [ + [ + "ba35148d.b73588" + ] + ] + }, + { + "id": "b8862f98.abf7a", + "type": "outcomeFalse", + "name": "false", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 3297.448473249163, + "y": 3851.857357978821, + "z": "f2af2445.16fe78", + "wires": [ + [ + "e6bfcbc8.332388" + ] + ] + }, + { + "id": "ba35148d.b73588", + "type": "set", + "name": "set index-string to '0' + idx", + "xml": "\n\n", + "comments": "", + "x": 3490.1153014046804, + "y": 3803.190676689148, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "e6bfcbc8.332388", + "type": "set", + "name": "set index-string to idx", + "xml": "\n\n", + "comments": "", + "x": 3474.1152861458913, + "y": 3851.523980140686, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "360242d5.db658e", + "type": "set", + "name": "set generated-name to prefix + index-string", + "xml": "\n\n", + "comments": "", + "x": 2373.781957898821, + "y": 3908.857216835022, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "b69ff8cc.8d9308", + "type": "comment", + "name": "Wrapping around - now check from 1 to the original index", + "info": "", + "comments": "", + "x": 1805.4486220223562, + "y": 3635.0002088546753, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "47e5b18f.a8b23", + "type": "comment", + "name": "check if we've used this name before", + "info": "", + "comments": "", + "x": 2360.4964049203054, + "y": 4023.857490539551, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "ef79ae3c.17c5f", + "type": "get-resource", + "name": "get-resource name", + "xml": "\n\n", + "comments": "", + "outputs": 1, + "x": 2298.115221296038, + "y": 4164.571560450962, + "z": "f2af2445.16fe78", + "wires": [ + [ + "5a089be5.cf97a4", + "66a1cd31.360d64" + ] + ] + }, + { + "id": "5a089be5.cf97a4", + "type": "failure", + "name": "failure", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2476.4486143929616, + "y": 4118.857397079468, + "z": "f2af2445.16fe78", + "wires": [ + [ + "c2df42b8.3c5f6" + ] + ] + }, + { + "id": "abf5ee3d.5d0ca", + "type": "set", + "name": "set generate-unique-name-output.error-message", + "xml": "\n\n", + "comments": "", + "x": 2922.400865827288, + "y": 4092.4287300109863, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "ee79f6f.5d57b08", + "type": "returnFailure", + "name": "BREAK", + "xml": "\n", + "comments": "", + "x": 2787.6391127450124, + "y": 4137.428817749023, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "cbbbd754.515278", + "type": "switchNode", + "name": "switch generate-unique-name-output.error-message", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1760.4961912972585, + "y": 4388.381100654602, + "z": "f2af2445.16fe78", + "wires": [ + [ + "73a8a16e.756ef", + "4bea28c3.456028" + ] + ] + }, + { + "id": "73a8a16e.756ef", + "type": "outcome", + "name": "NULL", + "xml": "", + "comments": "", + "outputs": 1, + "x": 2033.8295996529714, + "y": 4361.714352607727, + "z": "f2af2445.16fe78", + "wires": [ + [ + "590a39c2.d91d98" + ] + ] + }, + { + "id": "590a39c2.d91d98", + "type": "block", + "name": "block", + "xml": "\n", + "atomic": "false", + "comments": "", + "outputs": 1, + "x": 2168.8295996529714, + "y": 4361.714352607727, + "z": "f2af2445.16fe78", + "wires": [ + [] + ] + }, + { + "id": "4bea28c3.456028", + "type": "other", + "name": "other", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2033.829565320696, + "y": 4411.714373588562, + "z": "f2af2445.16fe78", + "wires": [ + [ + "8722b32b.fe33e" + ] + ] + }, + { + "id": "8722b32b.fe33e", + "type": "returnFailure", + "name": "return failure", + "xml": "\n", + "comments": "", + "x": 2183.829565320696, + "y": 4411.714373588562, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "8da20e83.48444", + "type": "switchNode", + "name": "switch found-flag", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1642.2104704720632, + "y": 4567.905009269714, + "z": "f2af2445.16fe78", + "wires": [ + [ + "f9025718.d4df88" + ] + ] + }, + { + "id": "f8c693e4.938fc", + "type": "comment", + "name": "if db name is null we found an index we can use", + "info": "", + "comments": "", + "x": 1808.9248106820241, + "y": 4517.428784370422, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "f9025718.d4df88", + "type": "outcome", + "name": "true", + "xml": "", + "comments": "", + "outputs": 1, + "x": 1801.543791089739, + "y": 4567.90496635437, + "z": "f2af2445.16fe78", + "wires": [ + [ + "9c3c38a7.e59808" + ] + ] + }, + { + "id": "8210dd08.26216", + "type": "set", + "name": "set generate-unique-name-output.generated-name", + "xml": "\n\n", + "comments": "", + "x": 2277.210455213274, + "y": 4516.238507270813, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "4dec686e.afd348", + "type": "returnSuccess", + "name": "return success", + "xml": "\n\n", + "comments": "", + "x": 2160.6865065438406, + "y": 4855.047978401184, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "9c3c38a7.e59808", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 1968.2104857308523, + "y": 4566.238184928894, + "z": "f2af2445.16fe78", + "wires": [ + [ + "8210dd08.26216", + "9338bb2.be33d48", + "b455fb93.d28c68", + "4dec686e.afd348", + "144fc795.5db808" + ] + ] + }, + { + "id": "9338bb2.be33d48", + "type": "switchNode", + "name": "switch index-exists", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2172.9724638802663, + "y": 4648.3815088272095, + "z": "f2af2445.16fe78", + "wires": [ + [ + "530cf58c.b30b3c", + "997dbf86.ec5ba" + ] + ] + }, + { + "id": "530cf58c.b30b3c", + "type": "outcomeTrue", + "name": "true", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2351.5438292367116, + "y": 4624.095776557922, + "z": "f2af2445.16fe78", + "wires": [ + [ + "88dfc88f.8aa898" + ] + ] + }, + { + "id": "997dbf86.ec5ba", + "type": "outcomeFalse", + "name": "false", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2351.5438444955007, + "y": 4671.2387018203735, + "z": "f2af2445.16fe78", + "wires": [ + [ + "ae410bc8.d50898" + ] + ] + }, + { + "id": "66b73d5a.256d54", + "type": "save", + "name": "save (update) name index", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2747.2581541878835, + "y": 4625.524192810059, + "z": "f2af2445.16fe78", + "wires": [ + [ + "d51a3ac.e56a6c8" + ] + ] + }, + { + "id": "be1fac83.ec839", + "type": "save", + "name": "save (insert) name index", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2740.1151335580007, + "y": 4719.80966091156, + "z": "f2af2445.16fe78", + "wires": [ + [ + "414271a5.32692" + ] + ] + }, + { + "id": "d51a3ac.e56a6c8", + "type": "failure", + "name": "failure", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2940.115354810442, + "y": 4625.524211883545, + "z": "f2af2445.16fe78", + "wires": [ + [ + "9e2a4e5b.2a075" + ] + ] + }, + { + "id": "9e2a4e5b.2a075", + "type": "returnFailure", + "name": "return failure", + "xml": "\n \n", + "comments": "", + "x": 3094.401171003069, + "y": 4625.524230957031, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "414271a5.32692", + "type": "failure", + "name": "failure", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2937.2579253060476, + "y": 4718.381176948547, + "z": "f2af2445.16fe78", + "wires": [ + [ + "3cd4c5c8.3c566a" + ] + ] + }, + { + "id": "3cd4c5c8.3c566a", + "type": "returnFailure", + "name": "return failure", + "xml": "\n \n", + "comments": "", + "x": 3091.5437414986745, + "y": 4718.381196022034, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "b455fb93.d28c68", + "type": "save", + "name": "save (insert) generated name", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2207.4010603768484, + "y": 4806.952483177185, + "z": "f2af2445.16fe78", + "wires": [ + [ + "5344afb8.38666" + ] + ] + }, + { + "id": "5344afb8.38666", + "type": "failure", + "name": "failure", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2417.4009917122976, + "y": 4806.952534675598, + "z": "f2af2445.16fe78", + "wires": [ + [ + "94a9b8e7.dc94f8" + ] + ] + }, + { + "id": "94a9b8e7.dc94f8", + "type": "returnFailure", + "name": "return failure", + "xml": "\n \n", + "comments": "", + "x": 2571.6868079049245, + "y": 4806.9525537490845, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "d892995.bb30f68", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 2070.258146558489, + "y": 3704.0954084396362, + "z": "f2af2445.16fe78", + "wires": [ + [ + "94f9f0ef.6fa0d", + "360242d5.db658e", + "ef79ae3c.17c5f", + "72aa4efd.c0c88", + "6dd3f32a.b9635c" + ] + ] + }, + { + "id": "c2df42b8.3c5f6", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 2628.829611097063, + "y": 4118.381316184998, + "z": "f2af2445.16fe78", + "wires": [ + [ + "abf5ee3d.5d0ca", + "ee79f6f.5d57b08" + ] + ] + }, + { + "id": "88dfc88f.8aa898", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 2528.8296416146413, + "y": 4601.238305091858, + "z": "f2af2445.16fe78", + "wires": [ + [ + "947dd966.3194a8", + "66b73d5a.256d54" + ] + ] + }, + { + "id": "ae410bc8.d50898", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 2525.9724943978445, + "y": 4696.95262336731, + "z": "f2af2445.16fe78", + "wires": [ + [ + "be1fac83.ec839", + "6a923ca1.f35424" + ] + ] + }, + { + "id": "947dd966.3194a8", + "type": "set", + "name": "set sql statement", + "xml": "\n\n", + "comments": "", + "x": 2717.400923047747, + "y": 4576.952276706696, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "6a923ca1.f35424", + "type": "set", + "name": "set sql statement", + "xml": "\n\n\n", + "comments": "", + "x": 2715.972471509661, + "y": 4671.23809337616, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "66a1cd31.360d64", + "type": "not-found", + "name": "not-found", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2483.115350995745, + "y": 4209.809792518616, + "z": "f2af2445.16fe78", + "wires": [ + [ + "8688c71d.6f6348" + ] + ] + }, + { + "id": "72aa4efd.c0c88", + "type": "set", + "name": "clear namedb.name", + "xml": "\n\n", + "comments": "", + "x": 2298.829534803118, + "y": 3959.8097257614136, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "f36b5bce.ce38d8", + "type": "switchNode", + "name": "switch generate-unique-name-input.index-length", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1743.1152479989187, + "y": 3538.1906385421753, + "z": "f2af2445.16fe78", + "wires": [ + [ + "81e22e00.c515a" + ] + ] + }, + { + "id": "81e22e00.c515a", + "type": "outcome", + "name": "NULL", + "xml": "", + "comments": "", + "outputs": 1, + "x": 1998.829580579485, + "y": 3539.0955476760864, + "z": "f2af2445.16fe78", + "wires": [ + [ + "76724a0a.7f9af4" + ] + ] + }, + { + "id": "76724a0a.7f9af4", + "type": "returnFailure", + "name": "return failure", + "xml": "\n \n", + "comments": "", + "x": 2155.9724638802663, + "y": 3539.0955476760864, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "9b5b9cd9.fbaa6", + "type": "comment", + "name": "if we get here when there is no index length, then we have used up all 1000", + "info": "", + "comments": "", + "x": 1874.5438444955007, + "y": 3494.809862136841, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "8e750ec7.2ae83", + "type": "returnFailure", + "name": "return failure", + "xml": "\n \n", + "comments": "", + "x": 1636.543878827776, + "y": 4968.095459938049, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "3e63e2e.8d66c1e", + "type": "set", + "name": "set found-flag=false", + "xml": "\n\n", + "comments": "", + "x": 1178.4484672546387, + "y": 1258.0357694625854, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "2276b160.a9183e", + "type": "set", + "name": "set found-flag=true", + "xml": "\n\n", + "comments": "", + "x": 2372.6151809692383, + "y": 1873.0953306470599, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "41d904c1.515ddc", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 2179.7580032348633, + "y": 1899.2382749829974, + "z": "f2af2445.16fe78", + "wires": [ + [ + "2276b160.a9183e", + "ad173e2b.5c512" + ] + ] + }, + { + "id": "19972ef5.57be21", + "type": "returnFailure", + "name": "BREAK", + "xml": "\n", + "comments": "", + "x": 2787.972330365862, + "y": 4230.952507972717, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "e21c1774.c206a8", + "type": "comment", + "name": "found one we can use", + "info": "", + "comments": "", + "x": 2605.8297865731374, + "y": 4162.000430107117, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "eaee2222.dfde9", + "type": "set", + "name": "set found-flag=true", + "xml": "\n\n", + "comments": "", + "x": 2824.8772490365163, + "y": 4182.714360237122, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "8688c71d.6f6348", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 2632.0200713021413, + "y": 4208.857304573059, + "z": "f2af2445.16fe78", + "wires": [ + [ + "eaee2222.dfde9", + "19972ef5.57be21" + ] + ] + }, + { + "id": "3e4250a5.0ac4c", + "type": "switchNode", + "name": "switch generate-unique-name-input.supplied-name", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 732.7340965270996, + "y": 290.7143205915179, + "z": "f2af2445.16fe78", + "wires": [ + [ + "d25a80d5.4e3b8", + "b7f46cb8.21a18" + ] + ] + }, + { + "id": "d25a80d5.4e3b8", + "type": "outcome", + "name": "NULL", + "xml": "", + "comments": "", + "outputs": 1, + "x": 991.3055953979492, + "y": 317.85711615426203, + "z": "f2af2445.16fe78", + "wires": [ + [ + "d51fb171.df3c3" + ] + ] + }, + { + "id": "b7f46cb8.21a18", + "type": "other", + "name": "other", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 991.3055725097656, + "y": 259.7142862592425, + "z": "f2af2445.16fe78", + "wires": [ + [ + "12ab5681.ce04d9" + ] + ] + }, + { + "id": "130234ee.46d2ab", + "type": "switchNode", + "name": "switch generate-unique-name-input.name-table-type", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1460.5912437438965, + "y": 196.42856734139582, + "z": "f2af2445.16fe78", + "wires": [ + [ + "15992563.c8c55b" + ] + ] + }, + { + "id": "15992563.c8c55b", + "type": "outcome", + "name": "NULL", + "xml": "", + "comments": "", + "outputs": 1, + "x": 1793.9244403839111, + "y": 196.42857687813898, + "z": "f2af2445.16fe78", + "wires": [ + [ + "47420284.6ade7c" + ] + ] + }, + { + "id": "47420284.6ade7c", + "type": "returnFailure", + "name": "return failure", + "xml": "\n\n", + "comments": "", + "x": 1965.5912170410156, + "y": 196.76188032967707, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "12ab5681.ce04d9", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 1145.5912971496582, + "y": 259.2857164655413, + "z": "f2af2445.16fe78", + "wires": [ + [ + "130234ee.46d2ab", + "aabd4d90.16dd8", + "23a0ac.95990f54" + ] + ] + }, + { + "id": "23a0ac.95990f54", + "type": "get-resource", + "name": "get-resource name", + "xml": "\n\n", + "comments": "", + "outputs": 1, + "x": 1354.1627082824707, + "y": 289.2857317243304, + "z": "f2af2445.16fe78", + "wires": [ + [ + "6d7e1700.805508", + "5e3c9b34.a10a74", + "65ca162d.6df4c8" + ] + ] + }, + { + "id": "6d7e1700.805508", + "type": "failure", + "name": "failure", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1536.7817573547363, + "y": 276.42862742287775, + "z": "f2af2445.16fe78", + "wires": [ + [ + "2d9f6bb3.0fef44" + ] + ] + }, + { + "id": "aabd4d90.16dd8", + "type": "set", + "name": "set sql statement", + "xml": "\n\n", + "comments": "", + "x": 1347.734260559082, + "y": 241.6667494092669, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "5e3c9b34.a10a74", + "type": "not-found", + "name": "not-found", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1544.8771133422852, + "y": 321.6667379651751, + "z": "f2af2445.16fe78", + "wires": [ + [ + "ef3f7999.12f238" + ] + ] + }, + { + "id": "2d9f6bb3.0fef44", + "type": "returnFailure", + "name": "return failure", + "xml": "\n\n\n", + "comments": "", + "x": 1692.7341804504395, + "y": 276.00003283364435, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "65ca162d.6df4c8", + "type": "other", + "name": "other", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1537.0198822021484, + "y": 363.57143156869074, + "z": "f2af2445.16fe78", + "wires": [ + [ + "4d68280b.2d7b18" + ] + ] + }, + { + "id": "4d68280b.2d7b18", + "type": "returnFailure", + "name": "return failure", + "xml": "\n\n\n", + "comments": "", + "x": 1692.7341194152832, + "y": 362.999995640346, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "6ed6588d.7a0f78", + "type": "comment", + "name": "Caller supplied name - make sure it's not already used", + "info": "", + "comments": "", + "x": 1387.7699127197266, + "y": 154.1428575515747, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "ef3f7999.12f238", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 1694.1628074645996, + "y": 322.1428446088519, + "z": "f2af2445.16fe78", + "wires": [ + [ + "553234b3.8d5a7c", + "be029280.19e4b" + ] + ] + }, + { + "id": "be029280.19e4b", + "type": "save", + "name": "save (insert) generated name", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1934.1628074645996, + "y": 346.42858069283625, + "z": "f2af2445.16fe78", + "wires": [ + [ + "94aa6f8b.9aaf4" + ] + ] + }, + { + "id": "94aa6f8b.9aaf4", + "type": "failure", + "name": "failure", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2144.162738800049, + "y": 346.42863219124933, + "z": "f2af2445.16fe78", + "wires": [ + [ + "98e91b64.eafea8" + ] + ] + }, + { + "id": "98e91b64.eafea8", + "type": "returnFailure", + "name": "return failure", + "xml": "\n\n", + "comments": "", + "x": 2298.448554992676, + "y": 346.42865126473566, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "553234b3.8d5a7c", + "type": "set", + "name": "set sql statement", + "xml": "\n\n\n", + "comments": "", + "x": 1894.1627388000488, + "y": 296.4287580762591, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "b3a55875.754e68", + "type": "set", + "name": "set sql statement", + "xml": "\n\n\n", + "comments": "", + "x": 1638.1627791268484, + "y": 3122.857078552246, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "6dd3f32a.b9635c", + "type": "set", + "name": "set sql statement", + "xml": "\n\n", + "comments": "", + "x": 2292.2581084115163, + "y": 4075.2382822036743, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "144fc795.5db808", + "type": "set", + "name": "set sql statement", + "xml": "\n\n\n", + "comments": "", + "x": 2167.972303662981, + "y": 4759.523810386658, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "b2adf596.b14dc8", + "type": "returnFailure", + "name": "return failure", + "xml": "\n \n", + "comments": "", + "x": 2561.019964490618, + "y": 2987.142795562744, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "a521b607.e28cf8", + "type": "returnFailure", + "name": "return failure", + "xml": "\n \n", + "comments": "", + "x": 2558.1625769478933, + "y": 3080.4285764694214, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "c4268ba7.916128", + "type": "outcomeFalse", + "name": "false", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1280.1151068551198, + "y": 3397.8571519851685, + "z": "f2af2445.16fe78", + "wires": [ + [ + "59148c70.cdee34" + ] + ] + }, + { + "id": "59148c70.cdee34", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 1430.9485152108327, + "y": 4009.523675918579, + "z": "f2af2445.16fe78", + "wires": [ + [ + "f36b5bce.ce38d8", + "7c854eaa.cabde", + "cbbbd754.515278", + "8da20e83.48444", + "8e750ec7.2ae83", + "974e3eea.a57fc" + ] + ] + }, + { + "id": "a98b0c69.c8ff5", + "type": "success", + "name": "success", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1445.0913696289062, + "y": 1005.5357429981232, + "z": "f2af2445.16fe78", + "wires": [ + [ + "f97c717e.aeece" + ] + ] + }, + { + "id": "b88e0290.6b67d", + "type": "not-found", + "name": "not-found", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1451.6628875732422, + "y": 1112.1785898208618, + "z": "f2af2445.16fe78", + "wires": [ + [ + "4201eca6.c7d3f4" + ] + ] + }, + { + "id": "4201eca6.c7d3f4", + "type": "block", + "name": "block", + "xml": "\n", + "atomic": "false", + "comments": "", + "outputs": 1, + "x": 1583.091438293457, + "y": 1111.607195854187, + "z": "f2af2445.16fe78", + "wires": [ + [ + "3d4b23e4.f03d2c", + "e19f8c74.cb7de" + ] + ] + }, + { + "id": "a3abe6b2.a53fb8", + "type": "set", + "name": "set sql statement", + "xml": "\n\n", + "comments": "", + "x": 1837.9365768432617, + "y": 1771.428593635559, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "5cfa637b.4338bc", + "type": "get-resource", + "name": "get-resource name", + "xml": "\n\n", + "comments": "", + "outputs": 1, + "x": 1839.3651847839355, + "y": 1858.5715169906616, + "z": "f2af2445.16fe78", + "wires": [ + [ + "be62e7ae.90b8f8", + "96f6c88d.8b7e38" + ] + ] + }, + { + "id": "360fc793.866bf8", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 431.68655014038086, + "y": 265.00000381469727, + "z": "f2af2445.16fe78", + "wires": [ + [ + "3e4250a5.0ac4c", + "dcbeacf.6f2ab5" + ] + ] + }, + { + "id": "dcbeacf.6f2ab5", + "type": "set", + "name": "clear variables", + "xml": "\n\n\n", + "comments": "", + "x": 619.0079803466797, + "y": 242.8571424484253, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "26eda43b.2c3b5c", + "type": "outcome", + "name": "0", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1624.1148872375488, + "y": 690.3571691513062, + "z": "f2af2445.16fe78", + "wires": [ + [ + "e3969b91.7deb58" + ] + ] + }, + { + "id": "e3969b91.7deb58", + "type": "set", + "name": "set list-end = 0", + "xml": "\n\n", + "comments": "", + "x": 1813.7815322875977, + "y": 690.3571462631226, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "187251ba.f9a6ce", + "type": "switchNode", + "name": "switch tmp.gun.noindex-flag", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1388.6150038582937, + "y": 2054.000086784363, + "z": "f2af2445.16fe78", + "wires": [ + [ + "47d30b82.5fa434" + ] + ] + }, + { + "id": "dc9a064f.20c918", + "type": "switchNode", + "name": "switch generate-unique-name-input.index-length", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1844.9008140563965, + "y": 1030.4285879135132, + "z": "f2af2445.16fe78", + "wires": [ + [ + "35b6590.63450a8", + "7a0d894c.1efd48" + ] + ] + }, + { + "id": "35b6590.63450a8", + "type": "outcome", + "name": "0", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2111.1508140563965, + "y": 1058.6785898208618, + "z": "f2af2445.16fe78", + "wires": [ + [ + "ca199039.4ea94" + ] + ] + }, + { + "id": "7a0d894c.1efd48", + "type": "other", + "name": "other", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2112.650810241699, + "y": 998.6785879135132, + "z": "f2af2445.16fe78", + "wires": [ + [ + "5e88e850.5de788" + ] + ] + }, + { + "id": "5e88e850.5de788", + "type": "set", + "name": "increment index number", + "xml": "\n\n", + "comments": "", + "x": 2305.150810241699, + "y": 998.4285879135132, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "85418744.04a698", + "type": "set", + "name": "set index number to 0", + "xml": "\n\n", + "comments": "", + "x": 2449.1510581970215, + "y": 1060.4285879135132, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "e19f8c74.cb7de", + "type": "switchNode", + "name": "switch generate-unique-name-input.index-length", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1842.4008140563965, + "y": 1141.4285898208618, + "z": "f2af2445.16fe78", + "wires": [ + [ + "9925306e.7b5d6", + "4fb0aa57.8d75b4" + ] + ] + }, + { + "id": "4fb0aa57.8d75b4", + "type": "other", + "name": "other", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2112.400810241699, + "y": 1163.4285898208618, + "z": "f2af2445.16fe78", + "wires": [ + [ + "80595c6f.d370b" + ] + ] + }, + { + "id": "9925306e.7b5d6", + "type": "outcome", + "name": "0", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2112.400833129883, + "y": 1107.1785457134247, + "z": "f2af2445.16fe78", + "wires": [ + [ + "ca199039.4ea94" + ] + ] + }, + { + "id": "ca199039.4ea94", + "type": "block", + "name": "block", + "xml": "\n", + "atomic": "false", + "comments": "", + "outputs": 1, + "x": 2261.150806427002, + "y": 1085.9285879135132, + "z": "f2af2445.16fe78", + "wires": [ + [ + "85418744.04a698", + "c639252a.452078" + ] + ] + }, + { + "id": "c639252a.452078", + "type": "set", + "name": "set noindex-flag=true", + "xml": "\n\n", + "comments": "", + "x": 2448.650775909424, + "y": 1109.4285726547241, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "4139d69a.f19178", + "type": "set", + "name": "set generated-name to prefix", + "xml": "\n\n", + "comments": "", + "x": 1991.650854383196, + "y": 2105.428624153137, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "47d30b82.5fa434", + "type": "outcome", + "name": "true", + "xml": "", + "comments": "", + "outputs": 1, + "x": 1585.936540876116, + "y": 2054.000069618225, + "z": "f2af2445.16fe78", + "wires": [ + [ + "6400bec6.70c0b" + ] + ] + }, + { + "id": "6400bec6.70c0b", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 1737.3648970467702, + "y": 2054.0001916885376, + "z": "f2af2445.16fe78", + "wires": [ + [ + "1d2241eb.be7a9e", + "8c4f455f.ad7488", + "4139d69a.f19178", + "e298800b.28418" + ] + ] + }, + { + "id": "8c4f455f.ad7488", + "type": "set", + "name": "set sql statement", + "xml": "\n\n", + "comments": "", + "x": 1958.6389601571218, + "y": 2148.286027908325, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "1d2241eb.be7a9e", + "type": "get-resource", + "name": "get-resource name", + "xml": "\n\n", + "comments": "", + "outputs": 1, + "x": 1965.3533537728445, + "y": 2192.4287090301514, + "z": "f2af2445.16fe78", + "wires": [ + [ + "c3e26aa5.5a6ad8", + "f20ea659.abb5d8", + "ddda4cb5.69a3c" + ] + ] + }, + { + "id": "c3e26aa5.5a6ad8", + "type": "failure", + "name": "failure", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2157.6509650094167, + "y": 2191.7145656858174, + "z": "f2af2445.16fe78", + "wires": [ + [ + "e6b7e26f.94d48" + ] + ] + }, + { + "id": "f20ea659.abb5d8", + "type": "not-found", + "name": "not-found", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2164.3177016122, + "y": 2282.6669611249654, + "z": "f2af2445.16fe78", + "wires": [ + [ + "f1cf4980.556c18" + ] + ] + }, + { + "id": "f1cf4980.556c18", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 2347.1746297563823, + "y": 2282.0954637527466, + "z": "f2af2445.16fe78", + "wires": [ + [ + "825e78.6ae53188", + "caf8b992.a7b668" + ] + ] + }, + { + "id": "caf8b992.a7b668", + "type": "returnFailure", + "name": "BREAK", + "xml": "\n", + "comments": "", + "x": 2503.126888820103, + "y": 2304.190667152405, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "825e78.6ae53188", + "type": "set", + "name": "set found-flag=true", + "xml": "\n\n", + "comments": "", + "x": 2540.0318074907573, + "y": 2255.952519416809, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "63ab1b54.3f87f4", + "type": "returnFailure", + "name": "BREAK", + "xml": "\n", + "comments": "", + "x": 2468.8414633614675, + "y": 2210.285986355373, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "b2a157a3.5da4b8", + "type": "set", + "name": "set generate-unique-name-output.error-message", + "xml": "\n\n", + "comments": "", + "x": 2603.603216443743, + "y": 2165.285898617336, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "e6b7e26f.94d48", + "type": "block", + "name": "block : atomic", + "xml": "", + "atomic": "true", + "outputs": 1, + "x": 2310.0319617135183, + "y": 2191.238484791347, + "z": "f2af2445.16fe78", + "wires": [ + [ + "b2a157a3.5da4b8", + "63ab1b54.3f87f4" + ] + ] + }, + { + "id": "c261792d.2d6c28", + "type": "comment", + "name": "found one we can use", + "info": "", + "comments": "", + "x": 2320.9843450273784, + "y": 2235.238589286804, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "412400cc.a3efa", + "type": "comment", + "name": "NEW", + "info": "", + "comments": "", + "x": 1517.9363158089773, + "y": 697.1428834370204, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "9e0fc23a.f7e51", + "type": "comment", + "name": "NEW", + "info": "", + "comments": "", + "x": 1387.3651237487793, + "y": 2019.7142505645752, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "e7d53672.156128", + "type": "comment", + "name": "NEW", + "info": "", + "comments": "", + "x": 1987.9365043640137, + "y": 997.1428213119507, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "c8a8f3.23f8271", + "type": "comment", + "name": "NEW", + "info": "", + "comments": "", + "x": 1980.7937278747559, + "y": 1111.4285726547241, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "e298800b.28418", + "type": "set", + "name": "set index-string to 0", + "xml": "\n\n", + "comments": "", + "x": 1975.9364073617116, + "y": 2054.285785675049, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "974e3eea.a57fc", + "type": "switchNode", + "name": "switch tmp.gun.noindex-flag", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1679.3651259286062, + "y": 3421.2859582901, + "z": "f2af2445.16fe78", + "wires": [ + [ + "7a90c21f.11fb9c" + ] + ] + }, + { + "id": "7a90c21f.11fb9c", + "type": "outcome", + "name": "true", + "xml": "", + "comments": "", + "outputs": 1, + "x": 1885.0794051034109, + "y": 3421.285864830017, + "z": "f2af2445.16fe78", + "wires": [ + [ + "fde97220.7206d" + ] + ] + }, + { + "id": "fde97220.7206d", + "type": "returnFailure", + "name": "return failure", + "xml": "\n \n", + "comments": "", + "x": 2049.3652479989187, + "y": 3419.8571424484253, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "ddda4cb5.69a3c", + "type": "success", + "name": "success", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2159.8293882097514, + "y": 2338.14271068573, + "z": "f2af2445.16fe78", + "wires": [ + [ + "f1cf4980.556c18" + ] + ] + }, + { + "id": "59274ef2.cf994", + "type": "outcome", + "name": "4", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 1623.650779724121, + "y": 871.4285898208618, + "z": "f2af2445.16fe78", + "wires": [ + [ + "2c30bd52.6fca32" + ] + ] + }, + { + "id": "2c30bd52.6fca32", + "type": "set", + "name": "set list-end = 10000", + "xml": "\n\n", + "comments": "", + "x": 1813.31742477417, + "y": 871.4285669326782, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "c12d0b68.b45788", + "type": "outcome", + "name": "4", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2207.9363975524902, + "y": 1584.2856855392456, + "z": "f2af2445.16fe78", + "wires": [ + [ + "6a0e3f0e.bdf0d" + ] + ] + }, + { + "id": "6a0e3f0e.bdf0d", + "type": "switchNode", + "name": "switch idx < 10", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2376.269733428955, + "y": 1582.6188135147095, + "z": "f2af2445.16fe78", + "wires": [ + [ + "e077a096.c90b5", + "3ba27764.7bb978" + ] + ] + }, + { + "id": "e077a096.c90b5", + "type": "outcomeTrue", + "name": "true", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2544.8410606384277, + "y": 1535.5236520767212, + "z": "f2af2445.16fe78", + "wires": [ + [ + "6f52ffca.5f968" + ] + ] + }, + { + "id": "3ba27764.7bb978", + "type": "outcomeFalse", + "name": "false", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2557.936367034912, + "y": 1660.9521493911743, + "z": "f2af2445.16fe78", + "wires": [ + [ + "532853bc.fe84cc" + ] + ] + }, + { + "id": "c2125c33.cdb9e", + "type": "set", + "name": "set noindex-flag=false", + "xml": "\n\n", + "comments": "", + "x": 1190.7936058044434, + "y": 874.2857313156128, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "1a8e79c7.61ce76", + "type": "set", + "name": "set index-string to '00' + idx", + "xml": "\n\n", + "comments": "", + "x": 3100.793617248535, + "y": 1616.4285522188459, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "1afc6185.a5540e", + "type": "switchNode", + "name": "switch idx < 1000", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 3063.7935638427734, + "y": 1695.7619800567627, + "z": "f2af2445.16fe78", + "wires": [ + [ + "a4f34d49.5db71", + "751b1f96.b3bdc" + ] + ] + }, + { + "id": "a4f34d49.5db71", + "type": "outcomeTrue", + "name": "true", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 3220.79354095459, + "y": 1669.0953578948975, + "z": "f2af2445.16fe78", + "wires": [ + [ + "5d36ed1a.607764" + ] + ] + }, + { + "id": "751b1f96.b3bdc", + "type": "outcomeFalse", + "name": "false", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 3220.79349899292, + "y": 1717.4286937713623, + "z": "f2af2445.16fe78", + "wires": [ + [ + "d68323fd.8707c" + ] + ] + }, + { + "id": "5d36ed1a.607764", + "type": "set", + "name": "set index-string to '0' + idx", + "xml": "\n\n", + "comments": "", + "x": 3413.4603271484375, + "y": 1668.7620124816895, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "d68323fd.8707c", + "type": "set", + "name": "set index-string to idx", + "xml": "\n\n", + "comments": "", + "x": 3397.4603118896484, + "y": 1717.0953159332275, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "6f52ffca.5f968", + "type": "set", + "name": "set index-string to '000' + idx", + "xml": "\n\n", + "comments": "", + "x": 2752.2221069335938, + "y": 1535.142939567566, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "532853bc.fe84cc", + "type": "switchNode", + "name": "switch idx < 100", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2726.650703430176, + "y": 1660.9049066816058, + "z": "f2af2445.16fe78", + "wires": [ + [ + "26118820.193aa8", + "e9a76d39.5370a" + ] + ] + }, + { + "id": "26118820.193aa8", + "type": "outcomeTrue", + "name": "true", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2883.650680541992, + "y": 1616.2382845197405, + "z": "f2af2445.16fe78", + "wires": [ + [ + "1a8e79c7.61ce76" + ] + ] + }, + { + "id": "e9a76d39.5370a", + "type": "outcomeFalse", + "name": "false", + "xml": "\n", + "comments": "", + "outputs": 1, + "x": 2883.6506385803223, + "y": 1696.5716203962054, + "z": "f2af2445.16fe78", + "wires": [ + [ + "1afc6185.a5540e" + ] + ] + }, + { + "id": "909034be.bcdcb8", + "type": "comment", + "name": "Change History", + "info": "iTrack 10767\n- insert new column (index, prefix, info)\niTrack 11252\n- use tmp.gun.index-string as opposed to tmp.gun.idx as prefix for GENERIC_RESOURCE_NAME insert", + "comments": "", + "x": 463.65077209472656, + "y": 401.4285840988159, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "895c17e1.4d8998", + "type": "comment", + "name": "iTrack 10767", + "info": "", + "comments": "", + "x": 1766.507999420166, + "y": 3105.714337348938, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "a16f0f71.a4d2c", + "type": "set", + "name": "set tmp.gun.transient", + "xml": "\n\n", + "comments": "", + "x": 1112.2221374511719, + "y": 2779.999990940094, + "z": "f2af2445.16fe78", + "wires": [] + }, + { + "id": "9f71976e.e5c5f8", + "type": "service-logic", + "name": "GENERIC-RESOURCE-API ${project.version}", + "module": "GENERIC-RESOURCE-API", + "version": "${project.version}", + "comments": "", + "xml": "", + "outputs": 1, + "x": 720.8888549804688, + "y": 26.66666889190674, + "z": "f2af2445.16fe78", + "wires": [ + [ + "4eedc095.04b8b" + ] + ] + } +] \ No newline at end of file