Fix reuse InstanceName when re-creating a service
[sdnc/oam.git] / platform-logic / generic-resource-api / src / main / json / GENERIC-RESOURCE-API_generate-unique-name.json
1 [\r
2     {\r
3         "id": "15040625.d5f40a",\r
4         "type": "comment",\r
5         "name": "Validation of required data",\r
6         "info": "",\r
7         "comments": "",\r
8         "x": 1362.22216796875,\r
9         "y": 421.29468727111816,\r
10         "z": "f2af2445.16fe78",\r
11         "wires": []\r
12     },\r
13     {\r
14         "id": "11c017ed.c4cc98",\r
15         "type": "dgstart",\r
16         "name": "DGSTART",\r
17         "outputs": 1,\r
18         "x": 432.9722709655762,\r
19         "y": 26.69937038421631,\r
20         "z": "f2af2445.16fe78",\r
21         "wires": [\r
22             [\r
23                 "9f71976e.e5c5f8"\r
24             ]\r
25         ]\r
26     },\r
27     {\r
28         "id": "4eedc095.04b8b",\r
29         "type": "method",\r
30         "name": "method generate-unique-name",\r
31         "xml": "<method rpc='generate-unique-name' mode='sync'>\n",\r
32         "comments": "",\r
33         "outputs": 1,\r
34         "x": 565.8889999389648,\r
35         "y": 99.044602394104,\r
36         "z": "f2af2445.16fe78",\r
37         "wires": [\r
38             [\r
39                 "360fc793.866bf8"\r
40             ]\r
41         ]\r
42     },\r
43     {\r
44         "id": "23286af8.e7fb96",\r
45         "type": "comment",\r
46         "name": "generate-unique-name",\r
47         "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",\r
48         "comments": "",\r
49         "x": 1120.5314331054688,\r
50         "y": 20,\r
51         "z": "f2af2445.16fe78",\r
52         "wires": []\r
53     },\r
54     {\r
55         "id": "d51fb171.df3c3",\r
56         "type": "block",\r
57         "name": "block : atomic",\r
58         "xml": "<block atomic=\"true\">",\r
59         "atomic": "true",\r
60         "outputs": 1,\r
61         "x": 849.9960746765137,\r
62         "y": 1412.440560749599,\r
63         "z": "f2af2445.16fe78",\r
64         "wires": [\r
65             [\r
66                 "aeb040b1.610fe",\r
67                 "d5c2022c.eb55c",\r
68                 "6937019b.7d45d",\r
69                 "bcb4efa7.8fb4d",\r
70                 "4d3aaea2.1682c",\r
71                 "6c67d02f.17bf4",\r
72                 "c51e026f.e6689",\r
73                 "2d26f683.ab135a",\r
74                 "f849cb78.2321f8",\r
75                 "59510b56.12c9f4",\r
76                 "3e63e2e.8d66c1e",\r
77                 "c2125c33.cdb9e"\r
78             ]\r
79         ]\r
80     },\r
81     {\r
82         "id": "aeb040b1.610fe",\r
83         "type": "switchNode",\r
84         "name": "switch generate-unique-name-input.index-table-name",\r
85         "xml": "<switch test='`$generate-unique-name-input.index-table-name`'>\n",\r
86         "comments": "",\r
87         "outputs": 1,\r
88         "x": 1298.8055572509766,\r
89         "y": 466.9048252105713,\r
90         "z": "f2af2445.16fe78",\r
91         "wires": [\r
92             [\r
93                 "1286f8.7a830909"\r
94             ]\r
95         ]\r
96     },\r
97     {\r
98         "id": "1286f8.7a830909",\r
99         "type": "outcome",\r
100         "name": "NULL",\r
101         "xml": "<outcome value=''>",\r
102         "comments": "",\r
103         "outputs": 1,\r
104         "x": 1628.805477142334,\r
105         "y": 466.9048147201538,\r
106         "z": "f2af2445.16fe78",\r
107         "wires": [\r
108             [\r
109                 "c3b06eda.624f2"\r
110             ]\r
111         ]\r
112     },\r
113     {\r
114         "id": "c3b06eda.624f2",\r
115         "type": "returnFailure",\r
116         "name": "return failure",\r
117         "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.index-table-name not supplied' />\n",\r
118         "comments": "",\r
119         "x": 1802.1387977600098,\r
120         "y": 466.90480613708496,\r
121         "z": "f2af2445.16fe78",\r
122         "wires": []\r
123     },\r
124     {\r
125         "id": "d5c2022c.eb55c",\r
126         "type": "switchNode",\r
127         "name": "switch generate-unique-name-input.index-table-prefix-column",\r
128         "xml": "<switch test='`$generate-unique-name-input.index-table-prefix-column`'>\n",\r
129         "comments": "",\r
130         "outputs": 1,\r
131         "x": 1323.8055267333984,\r
132         "y": 510.23816108703613,\r
133         "z": "f2af2445.16fe78",\r
134         "wires": [\r
135             [\r
136                 "8b8a2d3c.650b5"\r
137             ]\r
138         ]\r
139     },\r
140     {\r
141         "id": "8b8a2d3c.650b5",\r
142         "type": "outcome",\r
143         "name": "NULL",\r
144         "xml": "<outcome value=''>",\r
145         "comments": "",\r
146         "outputs": 1,\r
147         "x": 1627.1387901306152,\r
148         "y": 510.2381401062012,\r
149         "z": "f2af2445.16fe78",\r
150         "wires": [\r
151             [\r
152                 "2fce40e3.dcb3a"\r
153             ]\r
154         ]\r
155     },\r
156     {\r
157         "id": "2fce40e3.dcb3a",\r
158         "type": "returnFailure",\r
159         "name": "return failure",\r
160         "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.index-table-prefix-column not supplied' />\n",\r
161         "comments": "",\r
162         "x": 1800.4721069335938,\r
163         "y": 510.57148361206055,\r
164         "z": "f2af2445.16fe78",\r
165         "wires": []\r
166     },\r
167     {\r
168         "id": "6937019b.7d45d",\r
169         "type": "switchNode",\r
170         "name": "switch generate-unique-name-input.name-table-type",\r
171         "xml": "<switch test='`$generate-unique-name-input.name-table-type`'>\n",\r
172         "comments": "",\r
173         "outputs": 1,\r
174         "x": 1294.805534362793,\r
175         "y": 555.2381534576416,\r
176         "z": "f2af2445.16fe78",\r
177         "wires": [\r
178             [\r
179                 "fe8ebb70.f12418"\r
180             ]\r
181         ]\r
182     },\r
183     {\r
184         "id": "fe8ebb70.f12418",\r
185         "type": "outcome",\r
186         "name": "NULL",\r
187         "xml": "<outcome value=''>",\r
188         "comments": "",\r
189         "outputs": 1,\r
190         "x": 1627.1387310028076,\r
191         "y": 555.2381629943848,\r
192         "z": "f2af2445.16fe78",\r
193         "wires": [\r
194             [\r
195                 "c450338.ed9f6d"\r
196             ]\r
197         ]\r
198     },\r
199     {\r
200         "id": "c450338.ed9f6d",\r
201         "type": "returnFailure",\r
202         "name": "return failure",\r
203         "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.name-table-type not supplied' />\n",\r
204         "comments": "",\r
205         "x": 1798.805507659912,\r
206         "y": 555.5714664459229,\r
207         "z": "f2af2445.16fe78",\r
208         "wires": []\r
209     },\r
210     {\r
211         "id": "c51e026f.e6689",\r
212         "type": "get-resource",\r
213         "name": "get-resource current name index",\r
214         "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.prefixdb'>\n\n",\r
215         "comments": "",\r
216         "outputs": 1,\r
217         "x": 1216.829387664795,\r
218         "y": 1114.0355405807495,\r
219         "z": "f2af2445.16fe78",\r
220         "wires": [\r
221             [\r
222                 "2161e5d1.539e3a",\r
223                 "b88e0290.6b67d",\r
224                 "a98b0c69.c8ff5"\r
225             ]\r
226         ]\r
227     },\r
228     {\r
229         "id": "2161e5d1.539e3a",\r
230         "type": "failure",\r
231         "name": "failure",\r
232         "xml": "<outcome value='failure'>\n",\r
233         "comments": "",\r
234         "outputs": 1,\r
235         "x": 1444.5198192596436,\r
236         "y": 1200.0594501495361,\r
237         "z": "f2af2445.16fe78",\r
238         "wires": [\r
239             [\r
240                 "d996887b.f8a558"\r
241             ]\r
242         ]\r
243     },\r
244     {\r
245         "id": "d996887b.f8a558",\r
246         "type": "returnFailure",\r
247         "name": "return failure",\r
248         "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Error reading the ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n",\r
249         "comments": "",\r
250         "x": 1607.1389408111572,\r
251         "y": 1201.4881782531738,\r
252         "z": "f2af2445.16fe78",\r
253         "wires": []\r
254     },\r
255     {\r
256         "id": "b684649d.306688",\r
257         "type": "for",\r
258         "name": "for idx from current index to list-end",\r
259         "xml": "<for index='tmp.gun.idx' start='`$tmp.gun.index-number`' end='`$tmp.gun.list-end`' >\n",\r
260         "comments": "",\r
261         "outputs": 1,\r
262         "x": 1371.6627464294434,\r
263         "y": 1442.8571510314941,\r
264         "z": "f2af2445.16fe78",\r
265         "wires": [\r
266             [\r
267                 "c4de9305.e3b5f"\r
268             ]\r
269         ]\r
270     },\r
271     {\r
272         "id": "bcb4efa7.8fb4d",\r
273         "type": "block",\r
274         "name": "block",\r
275         "xml": "<block>\n",\r
276         "atomic": "false",\r
277         "comments": "",\r
278         "outputs": 1,\r
279         "x": 1134.2817420959473,\r
280         "y": 1442.857116154262,\r
281         "z": "f2af2445.16fe78",\r
282         "wires": [\r
283             [\r
284                 "b684649d.306688",\r
285                 "a13f9156.7cff2",\r
286                 "187251ba.f9a6ce"\r
287             ]\r
288         ]\r
289     },\r
290     {\r
291         "id": "a13f9156.7cff2",\r
292         "type": "returnSuccess",\r
293         "name": "CATCH BREAK",\r
294         "xml": "<return status='success'>\n\n",\r
295         "comments": "",\r
296         "x": 1327.472242627825,\r
297         "y": 2467.2858533859253,\r
298         "z": "f2af2445.16fe78",\r
299         "wires": []\r
300     },\r
301     {\r
302         "id": "4d3aaea2.1682c",\r
303         "type": "switchNode",\r
304         "name": "switch generate-unique-name-input.prefix",\r
305         "xml": "<switch test='`$generate-unique-name-input.prefix`'>\n",\r
306         "comments": "",\r
307         "outputs": 1,\r
308         "x": 1260.4721755981445,\r
309         "y": 600.2381324768066,\r
310         "z": "f2af2445.16fe78",\r
311         "wires": [\r
312             [\r
313                 "d42fa470.81ab78"\r
314             ]\r
315         ]\r
316     },\r
317     {\r
318         "id": "d42fa470.81ab78",\r
319         "type": "outcome",\r
320         "name": "NULL",\r
321         "xml": "<outcome value=''>",\r
322         "comments": "",\r
323         "outputs": 1,\r
324         "x": 1627.8053646087646,\r
325         "y": 600.2381572723389,\r
326         "z": "f2af2445.16fe78",\r
327         "wires": [\r
328             [\r
329                 "af0a5a6c.8f2da8"\r
330             ]\r
331         ]\r
332     },\r
333     {\r
334         "id": "af0a5a6c.8f2da8",\r
335         "type": "returnFailure",\r
336         "name": "return failure",\r
337         "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.prefix not supplied' />\n",\r
338         "comments": "",\r
339         "x": 1800.4721412658691,\r
340         "y": 600.571460723877,\r
341         "z": "f2af2445.16fe78",\r
342         "wires": []\r
343     },\r
344     {\r
345         "id": "6c67d02f.17bf4",\r
346         "type": "switchNode",\r
347         "name": "switch generate-unique-name-input.index-length",\r
348         "xml": "<switch test='`$generate-unique-name-input.index-length`'>\n",\r
349         "comments": "",\r
350         "outputs": 1,\r
351         "x": 1283.8055419921875,\r
352         "y": 735.2380743026733,\r
353         "z": "f2af2445.16fe78",\r
354         "wires": [\r
355             [\r
356                 "185b25b7.55418a",\r
357                 "208a685c.353108",\r
358                 "d9e7f7d8.523f68",\r
359                 "7ee1530f.9a7ebc",\r
360                 "157b96c3.7936e9",\r
361                 "26eda43b.2c3b5c",\r
362                 "59274ef2.cf994"\r
363             ]\r
364         ]\r
365     },\r
366     {\r
367         "id": "185b25b7.55418a",\r
368         "type": "outcome",\r
369         "name": "NULL",\r
370         "xml": "<outcome value=''>",\r
371         "comments": "",\r
372         "outputs": 1,\r
373         "x": 1627.1388549804688,\r
374         "y": 643.571460723877,\r
375         "z": "f2af2445.16fe78",\r
376         "wires": [\r
377             [\r
378                 "d94c4d3c.5f17d"\r
379             ]\r
380         ]\r
381     },\r
382     {\r
383         "id": "157b96c3.7936e9",\r
384         "type": "other",\r
385         "name": "other",\r
386         "xml": "<outcome value='Other'>\n",\r
387         "comments": "",\r
388         "outputs": 1,\r
389         "x": 1625.9007606506348,\r
390         "y": 918.809588432312,\r
391         "z": "f2af2445.16fe78",\r
392         "wires": [\r
393             [\r
394                 "c70900c9.1665f"\r
395             ]\r
396         ]\r
397     },\r
398     {\r
399         "id": "208a685c.353108",\r
400         "type": "outcome",\r
401         "name": "1",\r
402         "xml": "<outcome value='1'>\n",\r
403         "comments": "",\r
404         "outputs": 1,\r
405         "x": 1624.0436630249023,\r
406         "y": 734.2857999801636,\r
407         "z": "f2af2445.16fe78",\r
408         "wires": [\r
409             [\r
410                 "923d6c6a.e4f8d"\r
411             ]\r
412         ]\r
413     },\r
414     {\r
415         "id": "d9e7f7d8.523f68",\r
416         "type": "outcome",\r
417         "name": "2",\r
418         "xml": "<outcome value='2'>\n",\r
419         "comments": "",\r
420         "outputs": 1,\r
421         "x": 1624.0436477661133,\r
422         "y": 779.2857904434204,\r
423         "z": "f2af2445.16fe78",\r
424         "wires": [\r
425             [\r
426                 "d39e047e.b0fc98"\r
427             ]\r
428         ]\r
429     },\r
430     {\r
431         "id": "7ee1530f.9a7ebc",\r
432         "type": "outcome",\r
433         "name": "3",\r
434         "xml": "<outcome value='3'>\n",\r
435         "comments": "",\r
436         "outputs": 1,\r
437         "x": 1622.3769836425781,\r
438         "y": 822.6191263198853,\r
439         "z": "f2af2445.16fe78",\r
440         "wires": [\r
441             [\r
442                 "70f9e263.445b3c"\r
443             ]\r
444         ]\r
445     },\r
446     {\r
447         "id": "923d6c6a.e4f8d",\r
448         "type": "set",\r
449         "name": "set list-end = 10",\r
450         "xml": "<set>\n<parameter name='tmp.gun.list-end' value='10' />\n",\r
451         "comments": "",\r
452         "x": 1806.7103996276855,\r
453         "y": 734.2857885360718,\r
454         "z": "f2af2445.16fe78",\r
455         "wires": []\r
456     },\r
457     {\r
458         "id": "d39e047e.b0fc98",\r
459         "type": "set",\r
460         "name": "set list-end = 100",\r
461         "xml": "<set>\n<parameter name='tmp.gun.list-end' value='100' />\n",\r
462         "comments": "",\r
463         "x": 1810.043628692627,\r
464         "y": 779.2857904434204,\r
465         "z": "f2af2445.16fe78",\r
466         "wires": []\r
467     },\r
468     {\r
469         "id": "70f9e263.445b3c",\r
470         "type": "set",\r
471         "name": "set list-end = 1000",\r
472         "xml": "<set>\n<parameter name='tmp.gun.list-end' value='1000' />\n",\r
473         "comments": "",\r
474         "x": 1812.043628692627,\r
475         "y": 822.6191034317017,\r
476         "z": "f2af2445.16fe78",\r
477         "wires": []\r
478     },\r
479     {\r
480         "id": "c70900c9.1665f",\r
481         "type": "returnFailure",\r
482         "name": "return failure",\r
483         "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.prefix not supplied' />\n",\r
484         "comments": "",\r
485         "x": 1796.9006843566895,\r
486         "y": 918.1429586410522,\r
487         "z": "f2af2445.16fe78",\r
488         "wires": []\r
489     },\r
490     {\r
491         "id": "80595c6f.d370b",\r
492         "type": "set",\r
493         "name": "set new index number to 1",\r
494         "xml": "<set>\n<parameter name='tmp.gun.index-number' value='1' />\n",\r
495         "comments": "",\r
496         "x": 2311.0082054138184,\r
497         "y": 1163.4288799762726,\r
498         "z": "f2af2445.16fe78",\r
499         "wires": []\r
500     },\r
501     {\r
502         "id": "d94c4d3c.5f17d",\r
503         "type": "set",\r
504         "name": "set list-end = 100000 (infinity basically)",\r
505         "xml": "<set>\n<parameter name='tmp.gun.list-end' value='100000' />\n",\r
506         "comments": "",\r
507         "x": 1876.1387939453125,\r
508         "y": 643.9048042297363,\r
509         "z": "f2af2445.16fe78",\r
510         "wires": []\r
511     },\r
512     {\r
513         "id": "651d8bf.8378c74",\r
514         "type": "switchNode",\r
515         "name": "switch generate-unique-name-input.index-length",\r
516         "xml": "<switch test='`$generate-unique-name-input.index-length`'>\n",\r
517         "comments": "",\r
518         "outputs": 1,\r
519         "x": 1933.3293266296387,\r
520         "y": 1369.5237898145404,\r
521         "z": "f2af2445.16fe78",\r
522         "wires": [\r
523             [\r
524                 "485a952f.4683ac",\r
525                 "929353b9.9ddf2",\r
526                 "fdae624e.d1e4d",\r
527                 "f1fa6f3d.9cd86",\r
528                 "c12d0b68.b45788"\r
529             ]\r
530         ]\r
531     },\r
532     {\r
533         "id": "485a952f.4683ac",\r
534         "type": "outcome",\r
535         "name": "NULL",\r
536         "xml": "<outcome value=''>",\r
537         "comments": "",\r
538         "outputs": 1,\r
539         "x": 2217.6150703430176,\r
540         "y": 1220.9523973464966,\r
541         "z": "f2af2445.16fe78",\r
542         "wires": [\r
543             [\r
544                 "93103f3e.f5587"\r
545             ]\r
546         ]\r
547     },\r
548     {\r
549         "id": "929353b9.9ddf2",\r
550         "type": "outcome",\r
551         "name": "1",\r
552         "xml": "<outcome value='1'>\n",\r
553         "comments": "",\r
554         "outputs": 1,\r
555         "x": 2215.948417663574,\r
556         "y": 1265.9524374008179,\r
557         "z": "f2af2445.16fe78",\r
558         "wires": [\r
559             [\r
560                 "93103f3e.f5587"\r
561             ]\r
562         ]\r
563     },\r
564     {\r
565         "id": "fdae624e.d1e4d",\r
566         "type": "outcome",\r
567         "name": "2",\r
568         "xml": "<outcome value='2'>\n",\r
569         "comments": "",\r
570         "outputs": 1,\r
571         "x": 2215.948402404785,\r
572         "y": 1315.0000638961792,\r
573         "z": "f2af2445.16fe78",\r
574         "wires": [\r
575             [\r
576                 "fe2daf39.916f2"\r
577             ]\r
578         ]\r
579     },\r
580     {\r
581         "id": "f1fa6f3d.9cd86",\r
582         "type": "outcome",\r
583         "name": "3",\r
584         "xml": "<outcome value='3'>\n",\r
585         "comments": "",\r
586         "outputs": 1,\r
587         "x": 2217.3770751953125,\r
588         "y": 1417.381145477295,\r
589         "z": "f2af2445.16fe78",\r
590         "wires": [\r
591             [\r
592                 "9b7d9fc5.77d19"\r
593             ]\r
594         ]\r
595     },\r
596     {\r
597         "id": "93103f3e.f5587",\r
598         "type": "set",\r
599         "name": "set index-string to idx",\r
600         "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
601         "comments": "",\r
602         "x": 2402.615219116211,\r
603         "y": 1239.285740852356,\r
604         "z": "f2af2445.16fe78",\r
605         "wires": []\r
606     },\r
607     {\r
608         "id": "fe2daf39.916f2",\r
609         "type": "switchNode",\r
610         "name": "switch idx < 10",\r
611         "xml": "<switch test='`$tmp.gun.idx &lt; 10`'>\n",\r
612         "comments": "",\r
613         "outputs": 1,\r
614         "x": 2382.615032196045,\r
615         "y": 1314.9999618530273,\r
616         "z": "f2af2445.16fe78",\r
617         "wires": [\r
618             [\r
619                 "1e14c0e7.34b7bf",\r
620                 "837fdec7.0a022"\r
621             ]\r
622         ]\r
623     },\r
624     {\r
625         "id": "1e14c0e7.34b7bf",\r
626         "type": "outcomeTrue",\r
627         "name": "true",\r
628         "xml": "<outcome value='true'>\n",\r
629         "comments": "",\r
630         "outputs": 1,\r
631         "x": 2544.281665802002,\r
632         "y": 1288.3333349227905,\r
633         "z": "f2af2445.16fe78",\r
634         "wires": [\r
635             [\r
636                 "3fe02145.d703be"\r
637             ]\r
638         ]\r
639     },\r
640     {\r
641         "id": "837fdec7.0a022",\r
642         "type": "outcomeFalse",\r
643         "name": "false",\r
644         "xml": "<outcome value='false'>\n",\r
645         "comments": "",\r
646         "outputs": 1,\r
647         "x": 2544.281623840332,\r
648         "y": 1336.6666707992554,\r
649         "z": "f2af2445.16fe78",\r
650         "wires": [\r
651             [\r
652                 "461425f5.d0f43c"\r
653             ]\r
654         ]\r
655     },\r
656     {\r
657         "id": "3fe02145.d703be",\r
658         "type": "set",\r
659         "name": "set index-string to '0' + idx",\r
660         "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n",\r
661         "comments": "",\r
662         "x": 2735.9484252929688,\r
663         "y": 1287.6665620803833,\r
664         "z": "f2af2445.16fe78",\r
665         "wires": []\r
666     },\r
667     {\r
668         "id": "461425f5.d0f43c",\r
669         "type": "set",\r
670         "name": "set index-string to idx",\r
671         "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
672         "comments": "",\r
673         "x": 2719.2816772460938,\r
674         "y": 1336.3332777023315,\r
675         "z": "f2af2445.16fe78",\r
676         "wires": []\r
677     },\r
678     {\r
679         "id": "9b7d9fc5.77d19",\r
680         "type": "switchNode",\r
681         "name": "switch idx < 10",\r
682         "xml": "<switch test='`$tmp.gun.idx &lt; 10`'>\n",\r
683         "comments": "",\r
684         "outputs": 1,\r
685         "x": 2385.7104110717773,\r
686         "y": 1415.7142734527588,\r
687         "z": "f2af2445.16fe78",\r
688         "wires": [\r
689             [\r
690                 "e219ec7e.fe57c",\r
691                 "ad55e1a8.b6075"\r
692             ]\r
693         ]\r
694     },\r
695     {\r
696         "id": "e219ec7e.fe57c",\r
697         "type": "outcomeTrue",\r
698         "name": "true",\r
699         "xml": "<outcome value='true'>\n",\r
700         "comments": "",\r
701         "outputs": 1,\r
702         "x": 2545.7103881835938,\r
703         "y": 1389.0476512908936,\r
704         "z": "f2af2445.16fe78",\r
705         "wires": [\r
706             [\r
707                 "22b4d6dc.cf442a"\r
708             ]\r
709         ]\r
710     },\r
711     {\r
712         "id": "ad55e1a8.b6075",\r
713         "type": "outcomeFalse",\r
714         "name": "false",\r
715         "xml": "<outcome value='false'>\n",\r
716         "comments": "",\r
717         "outputs": 1,\r
718         "x": 2550.2340087890625,\r
719         "y": 1465.4762334823608,\r
720         "z": "f2af2445.16fe78",\r
721         "wires": [\r
722             [\r
723                 "dbe69aa8.33eda8"\r
724             ]\r
725         ]\r
726     },\r
727     {\r
728         "id": "22b4d6dc.cf442a",\r
729         "type": "set",\r
730         "name": "set index-string to '00' + idx",\r
731         "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '00' + $tmp.gun.idx`\" />\n",\r
732         "comments": "",\r
733         "x": 2740.710479736328,\r
734         "y": 1389.047542163304,\r
735         "z": "f2af2445.16fe78",\r
736         "wires": []\r
737     },\r
738     {\r
739         "id": "dbe69aa8.33eda8",\r
740         "type": "switchNode",\r
741         "name": "switch idx < 100",\r
742         "xml": "<switch test='`$tmp.gun.idx &lt; 100`'>\n",\r
743         "comments": "",\r
744         "outputs": 1,\r
745         "x": 2706.5673904418945,\r
746         "y": 1463.809594154358,\r
747         "z": "f2af2445.16fe78",\r
748         "wires": [\r
749             [\r
750                 "f7ffce1d.63fe1",\r
751                 "67fc8e98.639b9"\r
752             ]\r
753         ]\r
754     },\r
755     {\r
756         "id": "f7ffce1d.63fe1",\r
757         "type": "outcomeTrue",\r
758         "name": "true",\r
759         "xml": "<outcome value='true'>\n",\r
760         "comments": "",\r
761         "outputs": 1,\r
762         "x": 2863.567367553711,\r
763         "y": 1437.1429719924927,\r
764         "z": "f2af2445.16fe78",\r
765         "wires": [\r
766             [\r
767                 "1c294f19.3865c1"\r
768             ]\r
769         ]\r
770     },\r
771     {\r
772         "id": "67fc8e98.639b9",\r
773         "type": "outcomeFalse",\r
774         "name": "false",\r
775         "xml": "<outcome value='false'>\n",\r
776         "comments": "",\r
777         "outputs": 1,\r
778         "x": 2863.567325592041,\r
779         "y": 1485.4763078689575,\r
780         "z": "f2af2445.16fe78",\r
781         "wires": [\r
782             [\r
783                 "3ab4c683.87c0fa"\r
784             ]\r
785         ]\r
786     },\r
787     {\r
788         "id": "1c294f19.3865c1",\r
789         "type": "set",\r
790         "name": "set index-string to '0' + idx",\r
791         "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n",\r
792         "comments": "",\r
793         "x": 3056.2341537475586,\r
794         "y": 1436.8096265792847,\r
795         "z": "f2af2445.16fe78",\r
796         "wires": []\r
797     },\r
798     {\r
799         "id": "3ab4c683.87c0fa",\r
800         "type": "set",\r
801         "name": "set index-string to idx",\r
802         "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
803         "comments": "",\r
804         "x": 3040.2341384887695,\r
805         "y": 1485.1429300308228,\r
806         "z": "f2af2445.16fe78",\r
807         "wires": []\r
808     },\r
809     {\r
810         "id": "c81549dd.4990b8",\r
811         "type": "set",\r
812         "name": "set generated-name to prefix + index-string",\r
813         "xml": "<set>\n<parameter name='tmp.gun.generated-name' value='`$generate-unique-name-input.prefix + $tmp.gun.index-string`' />\n",\r
814         "comments": "",\r
815         "x": 1917.329418182373,\r
816         "y": 1646.1904386792864,\r
817         "z": "f2af2445.16fe78",\r
818         "wires": []\r
819     },\r
820     {\r
821         "id": "27f2f9ab.7e2c26",\r
822         "type": "comment",\r
823         "name": "First check from the current index to the max index",\r
824         "info": "",\r
825         "comments": "",\r
826         "x": 1334.9960899353027,\r
827         "y": 1381.1905197416033,\r
828         "z": "f2af2445.16fe78",\r
829         "wires": []\r
830     },\r
831     {\r
832         "id": "4eb7a743.5209e8",\r
833         "type": "comment",\r
834         "name": "check if we've used this name before",\r
835         "info": "",\r
836         "comments": "",\r
837         "x": 1914.0439414978027,\r
838         "y": 1730.4765844345093,\r
839         "z": "f2af2445.16fe78",\r
840         "wires": []\r
841     },\r
842     {\r
843         "id": "be62e7ae.90b8f8",\r
844         "type": "failure",\r
845         "name": "failure",\r
846         "xml": "<outcome value='failure'>\n",\r
847         "comments": "",\r
848         "outputs": 1,\r
849         "x": 2021.662742614746,\r
850         "y": 1807.8573669706072,\r
851         "z": "f2af2445.16fe78",\r
852         "wires": [\r
853             [\r
854                 "dfb2aa84.9b4598"\r
855             ]\r
856         ]\r
857     },\r
858     {\r
859         "id": "1d6bb1a2.44855e",\r
860         "type": "set",\r
861         "name": "set generate-unique-name-output.error-message",\r
862         "xml": "<set>\n<parameter name='generate-unique-name-output.error-message' value=\"`'Error reading the GENERIC_RESOURCE_NAME table'`\" />\n",\r
863         "comments": "",\r
864         "x": 2467.6149940490723,\r
865         "y": 1781.4286999021258,\r
866         "z": "f2af2445.16fe78",\r
867         "wires": []\r
868     },\r
869     {\r
870         "id": "a5f867db.9d9558",\r
871         "type": "returnFailure",\r
872         "name": "BREAK",\r
873         "xml": "<return status='failure'>\n",\r
874         "comments": "",\r
875         "x": 2332.853240966797,\r
876         "y": 1826.428787640163,\r
877         "z": "f2af2445.16fe78",\r
878         "wires": []\r
879     },\r
880     {\r
881         "id": "ad173e2b.5c512",\r
882         "type": "returnFailure",\r
883         "name": "BREAK",\r
884         "xml": "<return status='failure'>\n",\r
885         "comments": "",\r
886         "x": 2335.710262298584,\r
887         "y": 1921.3334783826556,\r
888         "z": "f2af2445.16fe78",\r
889         "wires": []\r
890     },\r
891     {\r
892         "id": "c15de393.a41e9",\r
893         "type": "comment",\r
894         "name": "found one we can use",\r
895         "info": "",\r
896         "comments": "",\r
897         "x": 2153.5677185058594,\r
898         "y": 1852.381400517055,\r
899         "z": "f2af2445.16fe78",\r
900         "wires": []\r
901     },\r
902     {\r
903         "id": "2d26f683.ab135a",\r
904         "type": "switchNode",\r
905         "name": "switch generate-unique-name-output.error-message",\r
906         "xml": "<switch test='`$generate-unique-name-output.error-message`'>\n",\r
907         "comments": "",\r
908         "outputs": 1,\r
909         "x": 1209.5437147957937,\r
910         "y": 2679.2858324050903,\r
911         "z": "f2af2445.16fe78",\r
912         "wires": [\r
913             [\r
914                 "77705736.9ef7c8",\r
915                 "68085745.a74d48"\r
916             ]\r
917         ]\r
918     },\r
919     {\r
920         "id": "77705736.9ef7c8",\r
921         "type": "outcome",\r
922         "name": "NULL",\r
923         "xml": "<outcome value=''>",\r
924         "comments": "",\r
925         "outputs": 1,\r
926         "x": 1482.8771231515066,\r
927         "y": 2652.6190843582153,\r
928         "z": "f2af2445.16fe78",\r
929         "wires": [\r
930             [\r
931                 "bdffcfcf.9486c"\r
932             ]\r
933         ]\r
934     },\r
935     {\r
936         "id": "bdffcfcf.9486c",\r
937         "type": "block",\r
938         "name": "block",\r
939         "xml": "<block>\n",\r
940         "atomic": "false",\r
941         "comments": "",\r
942         "outputs": 1,\r
943         "x": 1617.8771231515066,\r
944         "y": 2652.6190843582153,\r
945         "z": "f2af2445.16fe78",\r
946         "wires": [\r
947             []\r
948         ]\r
949     },\r
950     {\r
951         "id": "68085745.a74d48",\r
952         "type": "other",\r
953         "name": "other",\r
954         "xml": "<outcome value='Other'>\n",\r
955         "comments": "",\r
956         "outputs": 1,\r
957         "x": 1482.8770888192312,\r
958         "y": 2702.6191053390503,\r
959         "z": "f2af2445.16fe78",\r
960         "wires": [\r
961             [\r
962                 "2c4c0bf4.4ba724"\r
963             ]\r
964         ]\r
965     },\r
966     {\r
967         "id": "2c4c0bf4.4ba724",\r
968         "type": "returnFailure",\r
969         "name": "return failure",\r
970         "xml": "<return status='failure'>\n",\r
971         "comments": "",\r
972         "x": 1632.8770888192312,\r
973         "y": 2702.6191053390503,\r
974         "z": "f2af2445.16fe78",\r
975         "wires": []\r
976     },\r
977     {\r
978         "id": "f849cb78.2321f8",\r
979         "type": "switchNode",\r
980         "name": "switch found-flag",\r
981         "xml": "<switch test='`$tmp.gun.found-flag`'>\n",\r
982         "comments": "",\r
983         "outputs": 1,\r
984         "x": 1101.5437605721609,\r
985         "y": 3033.571455001831,\r
986         "z": "f2af2445.16fe78",\r
987         "wires": [\r
988             [\r
989                 "f2e8b24d.e7494",\r
990                 "c4268ba7.916128"\r
991             ]\r
992         ]\r
993     },\r
994     {\r
995         "id": "f2e8b24d.e7494",\r
996         "type": "outcome",\r
997         "name": "true",\r
998         "xml": "<outcome value='true'>",\r
999         "comments": "",\r
1000         "outputs": 1,\r
1001         "x": 1275.877100263323,\r
1002         "y": 3033.5714559555054,\r
1003         "z": "f2af2445.16fe78",\r
1004         "wires": [\r
1005             [\r
1006                 "db1278f8.147038"\r
1007             ]\r
1008         ]\r
1009     },\r
1010     {\r
1011         "id": "b4aa117c.62303",\r
1012         "type": "set",\r
1013         "name": "set generate-unique-name-output.generated-name",\r
1014         "xml": "<set>\n<parameter name='generate-unique-name-output.generated-name' value='`$tmp.gun.generated-name`' />\n",\r
1015         "comments": "",\r
1016         "x": 1746.5437147957937,\r
1017         "y": 2878.5717420578003,\r
1018         "z": "f2af2445.16fe78",\r
1019         "wires": []\r
1020     },\r
1021     {\r
1022         "id": "144ff8a5.06a137",\r
1023         "type": "returnSuccess",\r
1024         "name": "return success",\r
1025         "xml": "<return status='success'>\n",\r
1026         "comments": "",\r
1027         "x": 1628.591284070696,\r
1028         "y": 3215.952536582947,\r
1029         "z": "f2af2445.16fe78",\r
1030         "wires": []\r
1031     },\r
1032     {\r
1033         "id": "db1278f8.147038",\r
1034         "type": "block",\r
1035         "name": "block : atomic",\r
1036         "xml": "<block atomic=\"true\">",\r
1037         "atomic": "true",\r
1038         "outputs": 1,\r
1039         "x": 1427.5437300545827,\r
1040         "y": 3032.904870033264,\r
1041         "z": "f2af2445.16fe78",\r
1042         "wires": [\r
1043             [\r
1044                 "b4aa117c.62303",\r
1045                 "58767fb5.799f",\r
1046                 "7332878a.b6d298",\r
1047                 "144ff8a5.06a137",\r
1048                 "b3a55875.754e68"\r
1049             ]\r
1050         ]\r
1051     },\r
1052     {\r
1053         "id": "3d4b23e4.f03d2c",\r
1054         "type": "set",\r
1055         "name": "set index-exists flag to false",\r
1056         "xml": "<set>\n<parameter name='tmp.gun.index-exists' value='false' />\n",\r
1057         "comments": "",\r
1058         "x": 1778.8055992126465,\r
1059         "y": 1080.8929452896118,\r
1060         "z": "f2af2445.16fe78",\r
1061         "wires": []\r
1062     },\r
1063     {\r
1064         "id": "7b63453a.f976cc",\r
1065         "type": "set",\r
1066         "name": "set index-exists flag to true",\r
1067         "xml": "<set>\n<parameter name='tmp.gun.index-exists' value='true' />\n",\r
1068         "comments": "",\r
1069         "x": 1777.448543548584,\r
1070         "y": 984.8214712142944,\r
1071         "z": "f2af2445.16fe78",\r
1072         "wires": []\r
1073     },\r
1074     {\r
1075         "id": "f97c717e.aeece",\r
1076         "type": "block",\r
1077         "name": "block",\r
1078         "xml": "<block>\n",\r
1079         "atomic": "false",\r
1080         "comments": "",\r
1081         "outputs": 1,\r
1082         "x": 1584.1628150939941,\r
1083         "y": 1006.2500772476196,\r
1084         "z": "f2af2445.16fe78",\r
1085         "wires": [\r
1086             [\r
1087                 "7b63453a.f976cc",\r
1088                 "dc9a064f.20c918"\r
1089             ]\r
1090         ]\r
1091     },\r
1092     {\r
1093         "id": "58767fb5.799f",\r
1094         "type": "switchNode",\r
1095         "name": "switch index-exists",\r
1096         "xml": "<switch test='`$tmp.gun.index-exists`'>\n",\r
1097         "comments": "",\r
1098         "outputs": 1,\r
1099         "x": 1642.3057234627859,\r
1100         "y": 3010.714743614197,\r
1101         "z": "f2af2445.16fe78",\r
1102         "wires": [\r
1103             [\r
1104                 "6a0af996.974498",\r
1105                 "6c8e2cbe.78d944"\r
1106             ]\r
1107         ]\r
1108     },\r
1109     {\r
1110         "id": "6a0af996.974498",\r
1111         "type": "outcomeTrue",\r
1112         "name": "true",\r
1113         "xml": "<outcome value='true'>\n",\r
1114         "comments": "",\r
1115         "outputs": 1,\r
1116         "x": 1820.8770888192312,\r
1117         "y": 2986.4290113449097,\r
1118         "z": "f2af2445.16fe78",\r
1119         "wires": [\r
1120             [\r
1121                 "87bbd73a.280a98"\r
1122             ]\r
1123         ]\r
1124     },\r
1125     {\r
1126         "id": "6c8e2cbe.78d944",\r
1127         "type": "outcomeFalse",\r
1128         "name": "false",\r
1129         "xml": "<outcome value='false'>\n",\r
1130         "comments": "",\r
1131         "outputs": 1,\r
1132         "x": 1820.8771040780202,\r
1133         "y": 3033.571936607361,\r
1134         "z": "f2af2445.16fe78",\r
1135         "wires": [\r
1136             [\r
1137                 "784e1241.16399c"\r
1138             ]\r
1139         ]\r
1140     },\r
1141     {\r
1142         "id": "9bc6db3a.e853b8",\r
1143         "type": "save",\r
1144         "name": "save (update) name index",\r
1145         "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
1146         "comments": "",\r
1147         "outputs": 1,\r
1148         "x": 2216.591413770403,\r
1149         "y": 2987.857427597046,\r
1150         "z": "f2af2445.16fe78",\r
1151         "wires": [\r
1152             [\r
1153                 "3aaf9849.6999f8"\r
1154             ]\r
1155         ]\r
1156     },\r
1157     {\r
1158         "id": "853b68e5.628e58",\r
1159         "type": "save",\r
1160         "name": "save (insert) name index",\r
1161         "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
1162         "comments": "",\r
1163         "outputs": 1,\r
1164         "x": 2209.4483931405202,\r
1165         "y": 3082.1428956985474,\r
1166         "z": "f2af2445.16fe78",\r
1167         "wires": [\r
1168             [\r
1169                 "8c884666.ad49c8"\r
1170             ]\r
1171         ]\r
1172     },\r
1173     {\r
1174         "id": "3aaf9849.6999f8",\r
1175         "type": "failure",\r
1176         "name": "failure",\r
1177         "xml": "<outcome value='failure'>\n",\r
1178         "comments": "",\r
1179         "outputs": 1,\r
1180         "x": 2409.4486143929616,\r
1181         "y": 2987.857446670532,\r
1182         "z": "f2af2445.16fe78",\r
1183         "wires": [\r
1184             [\r
1185                 "b2adf596.b14dc8"\r
1186             ]\r
1187         ]\r
1188     },\r
1189     {\r
1190         "id": "8c884666.ad49c8",\r
1191         "type": "failure",\r
1192         "name": "failure",\r
1193         "xml": "<outcome value='failure'>\n",\r
1194         "comments": "",\r
1195         "outputs": 1,\r
1196         "x": 2406.591184888567,\r
1197         "y": 3080.7144117355347,\r
1198         "z": "f2af2445.16fe78",\r
1199         "wires": [\r
1200             [\r
1201                 "a521b607.e28cf8"\r
1202             ]\r
1203         ]\r
1204     },\r
1205     {\r
1206         "id": "7332878a.b6d298",\r
1207         "type": "save",\r
1208         "name": "save (insert) generated name",\r
1209         "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
1210         "comments": "",\r
1211         "outputs": 1,\r
1212         "x": 1676.734319959368,\r
1213         "y": 3169.2857179641724,\r
1214         "z": "f2af2445.16fe78",\r
1215         "wires": [\r
1216             [\r
1217                 "ecbc8e26.1fa38"\r
1218             ]\r
1219         ]\r
1220     },\r
1221     {\r
1222         "id": "ecbc8e26.1fa38",\r
1223         "type": "failure",\r
1224         "name": "failure",\r
1225         "xml": "<outcome value='failure'>\n",\r
1226         "comments": "",\r
1227         "outputs": 1,\r
1228         "x": 1886.734251294817,\r
1229         "y": 3169.2857694625854,\r
1230         "z": "f2af2445.16fe78",\r
1231         "wires": [\r
1232             [\r
1233                 "1f5bf102.8c12af"\r
1234             ]\r
1235         ]\r
1236     },\r
1237     {\r
1238         "id": "1f5bf102.8c12af",\r
1239         "type": "returnFailure",\r
1240         "name": "return failure",\r
1241         "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"Failed insert into GENERIC_RESOURCE_NAME table\" />\n",\r
1242         "comments": "",\r
1243         "x": 2041.020067487444,\r
1244         "y": 3169.285788536072,\r
1245         "z": "f2af2445.16fe78",\r
1246         "wires": []\r
1247     },\r
1248     {\r
1249         "id": "59510b56.12c9f4",\r
1250         "type": "set",\r
1251         "name": "set sql statement",\r
1252         "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from ' + $generate-unique-name-input.index-table-name\n+ ' WHERE ' + $generate-unique-name-input.index-table-prefix-column + ' = '\n+ '$generate-unique-name-input.prefix'`\" />\n",\r
1253         "comments": "",\r
1254         "x": 1172.734218597412,\r
1255         "y": 964.8215706348419,\r
1256         "z": "f2af2445.16fe78",\r
1257         "wires": []\r
1258     },\r
1259     {\r
1260         "id": "c4de9305.e3b5f",\r
1261         "type": "block",\r
1262         "name": "block : atomic",\r
1263         "xml": "<block atomic=\"true\">",\r
1264         "atomic": "true",\r
1265         "outputs": 1,\r
1266         "x": 1613.805606842041,\r
1267         "y": 1442.4286302839007,\r
1268         "z": "f2af2445.16fe78",\r
1269         "wires": [\r
1270             [\r
1271                 "651d8bf.8378c74",\r
1272                 "c81549dd.4990b8",\r
1273                 "5cfa637b.4338bc",\r
1274                 "a3abe6b2.a53fb8"\r
1275             ]\r
1276         ]\r
1277     },\r
1278     {\r
1279         "id": "dfb2aa84.9b4598",\r
1280         "type": "block",\r
1281         "name": "block : atomic",\r
1282         "xml": "<block atomic=\"true\">",\r
1283         "atomic": "true",\r
1284         "outputs": 1,\r
1285         "x": 2174.0437393188477,\r
1286         "y": 1807.381286076137,\r
1287         "z": "f2af2445.16fe78",\r
1288         "wires": [\r
1289             [\r
1290                 "1d6bb1a2.44855e",\r
1291                 "a5f867db.9d9558"\r
1292             ]\r
1293         ]\r
1294     },\r
1295     {\r
1296         "id": "87bbd73a.280a98",\r
1297         "type": "block",\r
1298         "name": "block : atomic",\r
1299         "xml": "<block atomic=\"true\">",\r
1300         "atomic": "true",\r
1301         "outputs": 1,\r
1302         "x": 1998.1629011971609,\r
1303         "y": 2963.571539878845,\r
1304         "z": "f2af2445.16fe78",\r
1305         "wires": [\r
1306             [\r
1307                 "5830bf50.31dae",\r
1308                 "9bc6db3a.e853b8"\r
1309             ]\r
1310         ]\r
1311     },\r
1312     {\r
1313         "id": "784e1241.16399c",\r
1314         "type": "block",\r
1315         "name": "block : atomic",\r
1316         "xml": "<block atomic=\"true\">",\r
1317         "atomic": "true",\r
1318         "outputs": 1,\r
1319         "x": 1995.305753980364,\r
1320         "y": 3059.285858154297,\r
1321         "z": "f2af2445.16fe78",\r
1322         "wires": [\r
1323             [\r
1324                 "853b68e5.628e58",\r
1325                 "88572550.cad9b8"\r
1326             ]\r
1327         ]\r
1328     },\r
1329     {\r
1330         "id": "5830bf50.31dae",\r
1331         "type": "set",\r
1332         "name": "set sql statement",\r
1333         "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'update ' + $generate-unique-name-input.index-table-name\n+ ' set index_number = ' + $tmp.gun.index-string + ' where '\n+ $generate-unique-name-input.index-table-prefix-column\n+ ' = $generate-unique-name-input.prefix'`\" />\n",\r
1334         "comments": "",\r
1335         "x": 2186.7341826302663,\r
1336         "y": 2939.285511493683,\r
1337         "z": "f2af2445.16fe78",\r
1338         "wires": []\r
1339     },\r
1340     {\r
1341         "id": "88572550.cad9b8",\r
1342         "type": "set",\r
1343         "name": "set sql statement",\r
1344         "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into ' + $generate-unique-name-input.index-table-name\n+ '(' + $generate-unique-name-input.index-table-prefix-column + ', index_number) values ('\n+ ' $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ')'`\" />\n\n",\r
1345         "comments": "",\r
1346         "x": 2185.3057310921804,\r
1347         "y": 3033.571328163147,\r
1348         "z": "f2af2445.16fe78",\r
1349         "wires": []\r
1350     },\r
1351     {\r
1352         "id": "96f6c88d.8b7e38",\r
1353         "type": "not-found",\r
1354         "name": "not-found",\r
1355         "xml": "<outcome value='not-found'>\n",\r
1356         "comments": "",\r
1357         "outputs": 1,\r
1358         "x": 2028.3294792175293,\r
1359         "y": 1898.8097624097552,\r
1360         "z": "f2af2445.16fe78",\r
1361         "wires": [\r
1362             [\r
1363                 "41d904c1.515ddc"\r
1364             ]\r
1365         ]\r
1366     },\r
1367     {\r
1368         "id": "bf503344.2453a",\r
1369         "type": "for",\r
1370         "name": "for idx from 1 to current index",\r
1371         "xml": "<for index='tmp.gun.idx' start='1' end='`$tmp.gun.index-number`' >\n",\r
1372         "comments": "",\r
1373         "outputs": 1,\r
1374         "x": 1828.1153014046804,\r
1375         "y": 3705.5238943099976,\r
1376         "z": "f2af2445.16fe78",\r
1377         "wires": [\r
1378             [\r
1379                 "d892995.bb30f68"\r
1380             ]\r
1381         ]\r
1382     },\r
1383     {\r
1384         "id": "7c854eaa.cabde",\r
1385         "type": "block",\r
1386         "name": "block",\r
1387         "xml": "<block>\n",\r
1388         "atomic": "false",\r
1389         "comments": "",\r
1390         "outputs": 1,\r
1391         "x": 1614.4485479082377,\r
1392         "y": 3705.523872920445,\r
1393         "z": "f2af2445.16fe78",\r
1394         "wires": [\r
1395             [\r
1396                 "bf503344.2453a",\r
1397                 "9ffe82b8.b73ec"\r
1398             ]\r
1399         ]\r
1400     },\r
1401     {\r
1402         "id": "9ffe82b8.b73ec",\r
1403         "type": "returnSuccess",\r
1404         "name": "CATCH BREAK",\r
1405         "xml": "<return status='success'>\n\n",\r
1406         "comments": "",\r
1407         "x": 1779.0676939828054,\r
1408         "y": 4280.524024963379,\r
1409         "z": "f2af2445.16fe78",\r
1410         "wires": []\r
1411     },\r
1412     {\r
1413         "id": "94f9f0ef.6fa0d",\r
1414         "type": "switchNode",\r
1415         "name": "switch generate-unique-name-input.index-length",\r
1416         "xml": "<switch test='`$generate-unique-name-input.index-length`'>\n",\r
1417         "comments": "",\r
1418         "outputs": 1,\r
1419         "x": 2375.781873975481,\r
1420         "y": 3660.1906385421753,\r
1421         "z": "f2af2445.16fe78",\r
1422         "wires": [\r
1423             [\r
1424                 "266ce65b.b0b66a",\r
1425                 "97bab24a.c840c",\r
1426                 "3d984119.5f033e",\r
1427                 "3e3c8d28.fe1a32"\r
1428             ]\r
1429         ]\r
1430     },\r
1431     {\r
1432         "id": "266ce65b.b0b66a",\r
1433         "type": "outcome",\r
1434         "name": "NULL",\r
1435         "xml": "<outcome value=''>",\r
1436         "comments": "",\r
1437         "outputs": 1,\r
1438         "x": 2655.781873975481,\r
1439         "y": 3590.1906995773315,\r
1440         "z": "f2af2445.16fe78",\r
1441         "wires": [\r
1442             [\r
1443                 "dfbbc1b8.5e5ce"\r
1444             ]\r
1445         ]\r
1446     },\r
1447     {\r
1448         "id": "97bab24a.c840c",\r
1449         "type": "outcome",\r
1450         "name": "1",\r
1451         "xml": "<outcome value='1'>\n",\r
1452         "comments": "",\r
1453         "outputs": 1,\r
1454         "x": 2654.115221296038,\r
1455         "y": 3635.190739631653,\r
1456         "z": "f2af2445.16fe78",\r
1457         "wires": [\r
1458             [\r
1459                 "dfbbc1b8.5e5ce"\r
1460             ]\r
1461         ]\r
1462     },\r
1463     {\r
1464         "id": "3d984119.5f033e",\r
1465         "type": "outcome",\r
1466         "name": "2",\r
1467         "xml": "<outcome value='2'>\n",\r
1468         "comments": "",\r
1469         "outputs": 1,\r
1470         "x": 2654.115309034075,\r
1471         "y": 3688.5240869522095,\r
1472         "z": "f2af2445.16fe78",\r
1473         "wires": [\r
1474             [\r
1475                 "deb2ba7e.8c5978"\r
1476             ]\r
1477         ]\r
1478     },\r
1479     {\r
1480         "id": "3e3c8d28.fe1a32",\r
1481         "type": "outcome",\r
1482         "name": "3",\r
1483         "xml": "<outcome value='3'>\n",\r
1484         "comments": "",\r
1485         "outputs": 1,\r
1486         "x": 2654.1151869637624,\r
1487         "y": 3785.1908197402954,\r
1488         "z": "f2af2445.16fe78",\r
1489         "wires": [\r
1490             [\r
1491                 "eb7b9bc3.3d21f8"\r
1492             ]\r
1493         ]\r
1494     },\r
1495     {\r
1496         "id": "dfbbc1b8.5e5ce",\r
1497         "type": "set",\r
1498         "name": "set index-string to idx",\r
1499         "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
1500         "comments": "",\r
1501         "x": 2840.7820227486745,\r
1502         "y": 3608.524043083191,\r
1503         "z": "f2af2445.16fe78",\r
1504         "wires": []\r
1505     },\r
1506     {\r
1507         "id": "deb2ba7e.8c5978",\r
1508         "type": "switchNode",\r
1509         "name": "switch idx < 10",\r
1510         "xml": "<switch test='`$tmp.gun.idx &lt; 10`'>\n",\r
1511         "comments": "",\r
1512         "outputs": 1,\r
1513         "x": 2820.7819388253347,\r
1514         "y": 3688.5239849090576,\r
1515         "z": "f2af2445.16fe78",\r
1516         "wires": [\r
1517             [\r
1518                 "937abb25.5405e8",\r
1519                 "5f465025.bda92"\r
1520             ]\r
1521         ]\r
1522     },\r
1523     {\r
1524         "id": "937abb25.5405e8",\r
1525         "type": "outcomeTrue",\r
1526         "name": "true",\r
1527         "xml": "<outcome value='true'>\n",\r
1528         "comments": "",\r
1529         "outputs": 1,\r
1530         "x": 2982.4485724312917,\r
1531         "y": 3661.857357978821,\r
1532         "z": "f2af2445.16fe78",\r
1533         "wires": [\r
1534             [\r
1535                 "b0abf2f9.7e53f"\r
1536             ]\r
1537         ]\r
1538     },\r
1539     {\r
1540         "id": "5f465025.bda92",\r
1541         "type": "outcomeFalse",\r
1542         "name": "false",\r
1543         "xml": "<outcome value='false'>\n",\r
1544         "comments": "",\r
1545         "outputs": 1,\r
1546         "x": 2982.448530469622,\r
1547         "y": 3710.1906938552856,\r
1548         "z": "f2af2445.16fe78",\r
1549         "wires": [\r
1550             [\r
1551                 "ba4422ab.99ab3"\r
1552             ]\r
1553         ]\r
1554     },\r
1555     {\r
1556         "id": "b0abf2f9.7e53f",\r
1557         "type": "set",\r
1558         "name": "set index-string to '0' + idx",\r
1559         "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n",\r
1560         "comments": "",\r
1561         "x": 3174.1153319222585,\r
1562         "y": 3661.1905851364136,\r
1563         "z": "f2af2445.16fe78",\r
1564         "wires": []\r
1565     },\r
1566     {\r
1567         "id": "ba4422ab.99ab3",\r
1568         "type": "set",\r
1569         "name": "set index-string to idx",\r
1570         "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
1571         "comments": "",\r
1572         "x": 3157.4485838753835,\r
1573         "y": 3709.857300758362,\r
1574         "z": "f2af2445.16fe78",\r
1575         "wires": []\r
1576     },\r
1577     {\r
1578         "id": "eb7b9bc3.3d21f8",\r
1579         "type": "switchNode",\r
1580         "name": "switch idx < 10",\r
1581         "xml": "<switch test='`$tmp.gun.idx &lt; 10`'>\n",\r
1582         "comments": "",\r
1583         "outputs": 1,\r
1584         "x": 2822.4485228402273,\r
1585         "y": 3783.5239477157593,\r
1586         "z": "f2af2445.16fe78",\r
1587         "wires": [\r
1588             [\r
1589                 "14d2288c.c6a057",\r
1590                 "d8edd84e.af3bc8"\r
1591             ]\r
1592         ]\r
1593     },\r
1594     {\r
1595         "id": "14d2288c.c6a057",\r
1596         "type": "outcomeTrue",\r
1597         "name": "true",\r
1598         "xml": "<outcome value='true'>\n",\r
1599         "comments": "",\r
1600         "outputs": 1,\r
1601         "x": 2982.4484999520437,\r
1602         "y": 3756.857325553894,\r
1603         "z": "f2af2445.16fe78",\r
1604         "wires": [\r
1605             [\r
1606                 "62627b5d.5978e4"\r
1607             ]\r
1608         ]\r
1609     },\r
1610     {\r
1611         "id": "d8edd84e.af3bc8",\r
1612         "type": "outcomeFalse",\r
1613         "name": "false",\r
1614         "xml": "<outcome value='false'>\n",\r
1615         "comments": "",\r
1616         "outputs": 1,\r
1617         "x": 2984.1151564461843,\r
1618         "y": 3831.857283592224,\r
1619         "z": "f2af2445.16fe78",\r
1620         "wires": [\r
1621             [\r
1622                 "30bfdb15.2f8ad4"\r
1623             ]\r
1624         ]\r
1625     },\r
1626     {\r
1627         "id": "62627b5d.5978e4",\r
1628         "type": "set",\r
1629         "name": "set index-string to '00' + idx",\r
1630         "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '00' + $tmp.gun.idx`\" />\n",\r
1631         "comments": "",\r
1632         "x": 3177.4485838753835,\r
1633         "y": 3756.857300758362,\r
1634         "z": "f2af2445.16fe78",\r
1635         "wires": []\r
1636     },\r
1637     {\r
1638         "id": "30bfdb15.2f8ad4",\r
1639         "type": "switchNode",\r
1640         "name": "switch idx < 100",\r
1641         "xml": "<switch test='`$tmp.gun.idx &lt; 100`'>\n",\r
1642         "comments": "",\r
1643         "outputs": 1,\r
1644         "x": 3140.4485380990163,\r
1645         "y": 3830.190644264221,\r
1646         "z": "f2af2445.16fe78",\r
1647         "wires": [\r
1648             [\r
1649                 "440bf02e.68e61",\r
1650                 "b8862f98.abf7a"\r
1651             ]\r
1652         ]\r
1653     },\r
1654     {\r
1655         "id": "440bf02e.68e61",\r
1656         "type": "outcomeTrue",\r
1657         "name": "true",\r
1658         "xml": "<outcome value='true'>\n",\r
1659         "comments": "",\r
1660         "outputs": 1,\r
1661         "x": 3297.4485152108327,\r
1662         "y": 3803.524022102356,\r
1663         "z": "f2af2445.16fe78",\r
1664         "wires": [\r
1665             [\r
1666                 "ba35148d.b73588"\r
1667             ]\r
1668         ]\r
1669     },\r
1670     {\r
1671         "id": "b8862f98.abf7a",\r
1672         "type": "outcomeFalse",\r
1673         "name": "false",\r
1674         "xml": "<outcome value='false'>\n",\r
1675         "comments": "",\r
1676         "outputs": 1,\r
1677         "x": 3297.448473249163,\r
1678         "y": 3851.857357978821,\r
1679         "z": "f2af2445.16fe78",\r
1680         "wires": [\r
1681             [\r
1682                 "e6bfcbc8.332388"\r
1683             ]\r
1684         ]\r
1685     },\r
1686     {\r
1687         "id": "ba35148d.b73588",\r
1688         "type": "set",\r
1689         "name": "set index-string to '0' + idx",\r
1690         "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n",\r
1691         "comments": "",\r
1692         "x": 3490.1153014046804,\r
1693         "y": 3803.190676689148,\r
1694         "z": "f2af2445.16fe78",\r
1695         "wires": []\r
1696     },\r
1697     {\r
1698         "id": "e6bfcbc8.332388",\r
1699         "type": "set",\r
1700         "name": "set index-string to idx",\r
1701         "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
1702         "comments": "",\r
1703         "x": 3474.1152861458913,\r
1704         "y": 3851.523980140686,\r
1705         "z": "f2af2445.16fe78",\r
1706         "wires": []\r
1707     },\r
1708     {\r
1709         "id": "360242d5.db658e",\r
1710         "type": "set",\r
1711         "name": "set generated-name to prefix + index-string",\r
1712         "xml": "<set>\n<parameter name='tmp.gun.generated-name' value='`$generate-unique-name-input.prefix + $tmp.gun.index-string`' />\n",\r
1713         "comments": "",\r
1714         "x": 2373.781957898821,\r
1715         "y": 3908.857216835022,\r
1716         "z": "f2af2445.16fe78",\r
1717         "wires": []\r
1718     },\r
1719     {\r
1720         "id": "b69ff8cc.8d9308",\r
1721         "type": "comment",\r
1722         "name": "Wrapping around - now check from 1 to the original index",\r
1723         "info": "",\r
1724         "comments": "",\r
1725         "x": 1805.4486220223562,\r
1726         "y": 3635.0002088546753,\r
1727         "z": "f2af2445.16fe78",\r
1728         "wires": []\r
1729     },\r
1730     {\r
1731         "id": "47e5b18f.a8b23",\r
1732         "type": "comment",\r
1733         "name": "check if we've used this name before",\r
1734         "info": "",\r
1735         "comments": "",\r
1736         "x": 2360.4964049203054,\r
1737         "y": 4023.857490539551,\r
1738         "z": "f2af2445.16fe78",\r
1739         "wires": []\r
1740     },\r
1741     {\r
1742         "id": "ef79ae3c.17c5f",\r
1743         "type": "get-resource",\r
1744         "name": "get-resource name",\r
1745         "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n",\r
1746         "comments": "",\r
1747         "outputs": 1,\r
1748         "x": 2298.115221296038,\r
1749         "y": 4164.571560450962,\r
1750         "z": "f2af2445.16fe78",\r
1751         "wires": [\r
1752             [\r
1753                 "5a089be5.cf97a4",\r
1754                 "66a1cd31.360d64"\r
1755             ]\r
1756         ]\r
1757     },\r
1758     {\r
1759         "id": "5a089be5.cf97a4",\r
1760         "type": "failure",\r
1761         "name": "failure",\r
1762         "xml": "<outcome value='failure'>\n",\r
1763         "comments": "",\r
1764         "outputs": 1,\r
1765         "x": 2476.4486143929616,\r
1766         "y": 4118.857397079468,\r
1767         "z": "f2af2445.16fe78",\r
1768         "wires": [\r
1769             [\r
1770                 "c2df42b8.3c5f6"\r
1771             ]\r
1772         ]\r
1773     },\r
1774     {\r
1775         "id": "abf5ee3d.5d0ca",\r
1776         "type": "set",\r
1777         "name": "set generate-unique-name-output.error-message",\r
1778         "xml": "<set>\n<parameter name='generate-unique-name-output.error-message' value=\"Error reading the GENERIC_RESOURCE_NAME table\" />\n",\r
1779         "comments": "",\r
1780         "x": 2922.400865827288,\r
1781         "y": 4092.4287300109863,\r
1782         "z": "f2af2445.16fe78",\r
1783         "wires": []\r
1784     },\r
1785     {\r
1786         "id": "ee79f6f.5d57b08",\r
1787         "type": "returnFailure",\r
1788         "name": "BREAK",\r
1789         "xml": "<return status='failure'>\n",\r
1790         "comments": "",\r
1791         "x": 2787.6391127450124,\r
1792         "y": 4137.428817749023,\r
1793         "z": "f2af2445.16fe78",\r
1794         "wires": []\r
1795     },\r
1796     {\r
1797         "id": "cbbbd754.515278",\r
1798         "type": "switchNode",\r
1799         "name": "switch generate-unique-name-output.error-message",\r
1800         "xml": "<switch test='`$generate-unique-name-output.error-message`'>\n",\r
1801         "comments": "",\r
1802         "outputs": 1,\r
1803         "x": 1760.4961912972585,\r
1804         "y": 4388.381100654602,\r
1805         "z": "f2af2445.16fe78",\r
1806         "wires": [\r
1807             [\r
1808                 "73a8a16e.756ef",\r
1809                 "4bea28c3.456028"\r
1810             ]\r
1811         ]\r
1812     },\r
1813     {\r
1814         "id": "73a8a16e.756ef",\r
1815         "type": "outcome",\r
1816         "name": "NULL",\r
1817         "xml": "<outcome value=''>",\r
1818         "comments": "",\r
1819         "outputs": 1,\r
1820         "x": 2033.8295996529714,\r
1821         "y": 4361.714352607727,\r
1822         "z": "f2af2445.16fe78",\r
1823         "wires": [\r
1824             [\r
1825                 "590a39c2.d91d98"\r
1826             ]\r
1827         ]\r
1828     },\r
1829     {\r
1830         "id": "590a39c2.d91d98",\r
1831         "type": "block",\r
1832         "name": "block",\r
1833         "xml": "<block>\n",\r
1834         "atomic": "false",\r
1835         "comments": "",\r
1836         "outputs": 1,\r
1837         "x": 2168.8295996529714,\r
1838         "y": 4361.714352607727,\r
1839         "z": "f2af2445.16fe78",\r
1840         "wires": [\r
1841             []\r
1842         ]\r
1843     },\r
1844     {\r
1845         "id": "4bea28c3.456028",\r
1846         "type": "other",\r
1847         "name": "other",\r
1848         "xml": "<outcome value='Other'>\n",\r
1849         "comments": "",\r
1850         "outputs": 1,\r
1851         "x": 2033.829565320696,\r
1852         "y": 4411.714373588562,\r
1853         "z": "f2af2445.16fe78",\r
1854         "wires": [\r
1855             [\r
1856                 "8722b32b.fe33e"\r
1857             ]\r
1858         ]\r
1859     },\r
1860     {\r
1861         "id": "8722b32b.fe33e",\r
1862         "type": "returnFailure",\r
1863         "name": "return failure",\r
1864         "xml": "<return status='failure'>\n",\r
1865         "comments": "",\r
1866         "x": 2183.829565320696,\r
1867         "y": 4411.714373588562,\r
1868         "z": "f2af2445.16fe78",\r
1869         "wires": []\r
1870     },\r
1871     {\r
1872         "id": "8da20e83.48444",\r
1873         "type": "switchNode",\r
1874         "name": "switch found-flag",\r
1875         "xml": "<switch test='`$tmp.gun.found-flag`'>\n",\r
1876         "comments": "",\r
1877         "outputs": 1,\r
1878         "x": 1642.2104704720632,\r
1879         "y": 4567.905009269714,\r
1880         "z": "f2af2445.16fe78",\r
1881         "wires": [\r
1882             [\r
1883                 "f9025718.d4df88"\r
1884             ]\r
1885         ]\r
1886     },\r
1887     {\r
1888         "id": "f8c693e4.938fc",\r
1889         "type": "comment",\r
1890         "name": "if db name is null we found an index we can use",\r
1891         "info": "",\r
1892         "comments": "",\r
1893         "x": 1808.9248106820241,\r
1894         "y": 4517.428784370422,\r
1895         "z": "f2af2445.16fe78",\r
1896         "wires": []\r
1897     },\r
1898     {\r
1899         "id": "f9025718.d4df88",\r
1900         "type": "outcome",\r
1901         "name": "true",\r
1902         "xml": "<outcome value='true'>",\r
1903         "comments": "",\r
1904         "outputs": 1,\r
1905         "x": 1801.543791089739,\r
1906         "y": 4567.90496635437,\r
1907         "z": "f2af2445.16fe78",\r
1908         "wires": [\r
1909             [\r
1910                 "9c3c38a7.e59808"\r
1911             ]\r
1912         ]\r
1913     },\r
1914     {\r
1915         "id": "8210dd08.26216",\r
1916         "type": "set",\r
1917         "name": "set generate-unique-name-output.generated-name",\r
1918         "xml": "<set>\n<parameter name='generate-unique-name-output.generated-name' value='`$tmp.gun.generated-name`' />\n",\r
1919         "comments": "",\r
1920         "x": 2277.210455213274,\r
1921         "y": 4516.238507270813,\r
1922         "z": "f2af2445.16fe78",\r
1923         "wires": []\r
1924     },\r
1925     {\r
1926         "id": "4dec686e.afd348",\r
1927         "type": "returnSuccess",\r
1928         "name": "return success",\r
1929         "xml": "<return status='success'>\n\n",\r
1930         "comments": "",\r
1931         "x": 2160.6865065438406,\r
1932         "y": 4855.047978401184,\r
1933         "z": "f2af2445.16fe78",\r
1934         "wires": []\r
1935     },\r
1936     {\r
1937         "id": "9c3c38a7.e59808",\r
1938         "type": "block",\r
1939         "name": "block : atomic",\r
1940         "xml": "<block atomic=\"true\">",\r
1941         "atomic": "true",\r
1942         "outputs": 1,\r
1943         "x": 1968.2104857308523,\r
1944         "y": 4566.238184928894,\r
1945         "z": "f2af2445.16fe78",\r
1946         "wires": [\r
1947             [\r
1948                 "8210dd08.26216",\r
1949                 "9338bb2.be33d48",\r
1950                 "b455fb93.d28c68",\r
1951                 "4dec686e.afd348",\r
1952                 "144fc795.5db808"\r
1953             ]\r
1954         ]\r
1955     },\r
1956     {\r
1957         "id": "9338bb2.be33d48",\r
1958         "type": "switchNode",\r
1959         "name": "switch index-exists",\r
1960         "xml": "<switch test='`$tmp.gun.index-exists`'>\n",\r
1961         "comments": "",\r
1962         "outputs": 1,\r
1963         "x": 2172.9724638802663,\r
1964         "y": 4648.3815088272095,\r
1965         "z": "f2af2445.16fe78",\r
1966         "wires": [\r
1967             [\r
1968                 "530cf58c.b30b3c",\r
1969                 "997dbf86.ec5ba"\r
1970             ]\r
1971         ]\r
1972     },\r
1973     {\r
1974         "id": "530cf58c.b30b3c",\r
1975         "type": "outcomeTrue",\r
1976         "name": "true",\r
1977         "xml": "<outcome value='true'>\n",\r
1978         "comments": "",\r
1979         "outputs": 1,\r
1980         "x": 2351.5438292367116,\r
1981         "y": 4624.095776557922,\r
1982         "z": "f2af2445.16fe78",\r
1983         "wires": [\r
1984             [\r
1985                 "88dfc88f.8aa898"\r
1986             ]\r
1987         ]\r
1988     },\r
1989     {\r
1990         "id": "997dbf86.ec5ba",\r
1991         "type": "outcomeFalse",\r
1992         "name": "false",\r
1993         "xml": "<outcome value='false'>\n",\r
1994         "comments": "",\r
1995         "outputs": 1,\r
1996         "x": 2351.5438444955007,\r
1997         "y": 4671.2387018203735,\r
1998         "z": "f2af2445.16fe78",\r
1999         "wires": [\r
2000             [\r
2001                 "ae410bc8.d50898"\r
2002             ]\r
2003         ]\r
2004     },\r
2005     {\r
2006         "id": "66b73d5a.256d54",\r
2007         "type": "save",\r
2008         "name": "save (update) name index",\r
2009         "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
2010         "comments": "",\r
2011         "outputs": 1,\r
2012         "x": 2747.2581541878835,\r
2013         "y": 4625.524192810059,\r
2014         "z": "f2af2445.16fe78",\r
2015         "wires": [\r
2016             [\r
2017                 "d51a3ac.e56a6c8"\r
2018             ]\r
2019         ]\r
2020     },\r
2021     {\r
2022         "id": "be1fac83.ec839",\r
2023         "type": "save",\r
2024         "name": "save (insert) name index",\r
2025         "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
2026         "comments": "",\r
2027         "outputs": 1,\r
2028         "x": 2740.1151335580007,\r
2029         "y": 4719.80966091156,\r
2030         "z": "f2af2445.16fe78",\r
2031         "wires": [\r
2032             [\r
2033                 "414271a5.32692"\r
2034             ]\r
2035         ]\r
2036     },\r
2037     {\r
2038         "id": "d51a3ac.e56a6c8",\r
2039         "type": "failure",\r
2040         "name": "failure",\r
2041         "xml": "<outcome value='failure'>\n",\r
2042         "comments": "",\r
2043         "outputs": 1,\r
2044         "x": 2940.115354810442,\r
2045         "y": 4625.524211883545,\r
2046         "z": "f2af2445.16fe78",\r
2047         "wires": [\r
2048             [\r
2049                 "9e2a4e5b.2a075"\r
2050             ]\r
2051         ]\r
2052     },\r
2053     {\r
2054         "id": "9e2a4e5b.2a075",\r
2055         "type": "returnFailure",\r
2056         "name": "return failure",\r
2057         "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to update ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n",\r
2058         "comments": "",\r
2059         "x": 3094.401171003069,\r
2060         "y": 4625.524230957031,\r
2061         "z": "f2af2445.16fe78",\r
2062         "wires": []\r
2063     },\r
2064     {\r
2065         "id": "414271a5.32692",\r
2066         "type": "failure",\r
2067         "name": "failure",\r
2068         "xml": "<outcome value='failure'>\n",\r
2069         "comments": "",\r
2070         "outputs": 1,\r
2071         "x": 2937.2579253060476,\r
2072         "y": 4718.381176948547,\r
2073         "z": "f2af2445.16fe78",\r
2074         "wires": [\r
2075             [\r
2076                 "3cd4c5c8.3c566a"\r
2077             ]\r
2078         ]\r
2079     },\r
2080     {\r
2081         "id": "3cd4c5c8.3c566a",\r
2082         "type": "returnFailure",\r
2083         "name": "return failure",\r
2084         "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to insert record into ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n",\r
2085         "comments": "",\r
2086         "x": 3091.5437414986745,\r
2087         "y": 4718.381196022034,\r
2088         "z": "f2af2445.16fe78",\r
2089         "wires": []\r
2090     },\r
2091     {\r
2092         "id": "b455fb93.d28c68",\r
2093         "type": "save",\r
2094         "name": "save (insert) generated name",\r
2095         "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
2096         "comments": "",\r
2097         "outputs": 1,\r
2098         "x": 2207.4010603768484,\r
2099         "y": 4806.952483177185,\r
2100         "z": "f2af2445.16fe78",\r
2101         "wires": [\r
2102             [\r
2103                 "5344afb8.38666"\r
2104             ]\r
2105         ]\r
2106     },\r
2107     {\r
2108         "id": "5344afb8.38666",\r
2109         "type": "failure",\r
2110         "name": "failure",\r
2111         "xml": "<outcome value='failure'>\n",\r
2112         "comments": "",\r
2113         "outputs": 1,\r
2114         "x": 2417.4009917122976,\r
2115         "y": 4806.952534675598,\r
2116         "z": "f2af2445.16fe78",\r
2117         "wires": [\r
2118             [\r
2119                 "94a9b8e7.dc94f8"\r
2120             ]\r
2121         ]\r
2122     },\r
2123     {\r
2124         "id": "94a9b8e7.dc94f8",\r
2125         "type": "returnFailure",\r
2126         "name": "return failure",\r
2127         "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"Failed insert into GENERIC_RESOURCE_NAME table\" />\n",\r
2128         "comments": "",\r
2129         "x": 2571.6868079049245,\r
2130         "y": 4806.9525537490845,\r
2131         "z": "f2af2445.16fe78",\r
2132         "wires": []\r
2133     },\r
2134     {\r
2135         "id": "d892995.bb30f68",\r
2136         "type": "block",\r
2137         "name": "block : atomic",\r
2138         "xml": "<block atomic=\"true\">",\r
2139         "atomic": "true",\r
2140         "outputs": 1,\r
2141         "x": 2070.258146558489,\r
2142         "y": 3704.0954084396362,\r
2143         "z": "f2af2445.16fe78",\r
2144         "wires": [\r
2145             [\r
2146                 "94f9f0ef.6fa0d",\r
2147                 "360242d5.db658e",\r
2148                 "ef79ae3c.17c5f",\r
2149                 "72aa4efd.c0c88",\r
2150                 "6dd3f32a.b9635c"\r
2151             ]\r
2152         ]\r
2153     },\r
2154     {\r
2155         "id": "c2df42b8.3c5f6",\r
2156         "type": "block",\r
2157         "name": "block : atomic",\r
2158         "xml": "<block atomic=\"true\">",\r
2159         "atomic": "true",\r
2160         "outputs": 1,\r
2161         "x": 2628.829611097063,\r
2162         "y": 4118.381316184998,\r
2163         "z": "f2af2445.16fe78",\r
2164         "wires": [\r
2165             [\r
2166                 "abf5ee3d.5d0ca",\r
2167                 "ee79f6f.5d57b08"\r
2168             ]\r
2169         ]\r
2170     },\r
2171     {\r
2172         "id": "88dfc88f.8aa898",\r
2173         "type": "block",\r
2174         "name": "block : atomic",\r
2175         "xml": "<block atomic=\"true\">",\r
2176         "atomic": "true",\r
2177         "outputs": 1,\r
2178         "x": 2528.8296416146413,\r
2179         "y": 4601.238305091858,\r
2180         "z": "f2af2445.16fe78",\r
2181         "wires": [\r
2182             [\r
2183                 "947dd966.3194a8",\r
2184                 "66b73d5a.256d54"\r
2185             ]\r
2186         ]\r
2187     },\r
2188     {\r
2189         "id": "ae410bc8.d50898",\r
2190         "type": "block",\r
2191         "name": "block : atomic",\r
2192         "xml": "<block atomic=\"true\">",\r
2193         "atomic": "true",\r
2194         "outputs": 1,\r
2195         "x": 2525.9724943978445,\r
2196         "y": 4696.95262336731,\r
2197         "z": "f2af2445.16fe78",\r
2198         "wires": [\r
2199             [\r
2200                 "be1fac83.ec839",\r
2201                 "6a923ca1.f35424"\r
2202             ]\r
2203         ]\r
2204     },\r
2205     {\r
2206         "id": "947dd966.3194a8",\r
2207         "type": "set",\r
2208         "name": "set sql statement",\r
2209         "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'update ' + $generate-unique-name-input.index-table-name\n+ ' set index_number = ' + $tmp.gun.index-string + ' where '\n+ $generate-unique-name-input.index-table-prefix-column\n+ ' = $generate-unique-name-input.prefix'`\" />\n",\r
2210         "comments": "",\r
2211         "x": 2717.400923047747,\r
2212         "y": 4576.952276706696,\r
2213         "z": "f2af2445.16fe78",\r
2214         "wires": []\r
2215     },\r
2216     {\r
2217         "id": "6a923ca1.f35424",\r
2218         "type": "set",\r
2219         "name": "set sql statement",\r
2220         "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into ' + $generate-unique-name-input.index-table-name\n+ '(' + $generate-unique-name-input.index-table-prefix-column + ', index_number) values ('\n+ ' $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ')'`\" />\n\n",\r
2221         "comments": "",\r
2222         "x": 2715.972471509661,\r
2223         "y": 4671.23809337616,\r
2224         "z": "f2af2445.16fe78",\r
2225         "wires": []\r
2226     },\r
2227     {\r
2228         "id": "66a1cd31.360d64",\r
2229         "type": "not-found",\r
2230         "name": "not-found",\r
2231         "xml": "<outcome value='not-found'>\n",\r
2232         "comments": "",\r
2233         "outputs": 1,\r
2234         "x": 2483.115350995745,\r
2235         "y": 4209.809792518616,\r
2236         "z": "f2af2445.16fe78",\r
2237         "wires": [\r
2238             [\r
2239                 "8688c71d.6f6348"\r
2240             ]\r
2241         ]\r
2242     },\r
2243     {\r
2244         "id": "72aa4efd.c0c88",\r
2245         "type": "set",\r
2246         "name": "clear namedb.name",\r
2247         "xml": "<set>\n<parameter name='tmp.gun.namedb.name' value='' />\n",\r
2248         "comments": "",\r
2249         "x": 2298.829534803118,\r
2250         "y": 3959.8097257614136,\r
2251         "z": "f2af2445.16fe78",\r
2252         "wires": []\r
2253     },\r
2254     {\r
2255         "id": "f36b5bce.ce38d8",\r
2256         "type": "switchNode",\r
2257         "name": "switch generate-unique-name-input.index-length",\r
2258         "xml": "<switch test='`$generate-unique-name-input.index-length`'>\n",\r
2259         "comments": "",\r
2260         "outputs": 1,\r
2261         "x": 1743.1152479989187,\r
2262         "y": 3538.1906385421753,\r
2263         "z": "f2af2445.16fe78",\r
2264         "wires": [\r
2265             [\r
2266                 "81e22e00.c515a"\r
2267             ]\r
2268         ]\r
2269     },\r
2270     {\r
2271         "id": "81e22e00.c515a",\r
2272         "type": "outcome",\r
2273         "name": "NULL",\r
2274         "xml": "<outcome value=''>",\r
2275         "comments": "",\r
2276         "outputs": 1,\r
2277         "x": 1998.829580579485,\r
2278         "y": 3539.0955476760864,\r
2279         "z": "f2af2445.16fe78",\r
2280         "wires": [\r
2281             [\r
2282                 "76724a0a.7f9af4"\r
2283             ]\r
2284         ]\r
2285     },\r
2286     {\r
2287         "id": "76724a0a.7f9af4",\r
2288         "type": "returnFailure",\r
2289         "name": "return failure",\r
2290         "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"We have exhausted the naming index count\" />\n",\r
2291         "comments": "",\r
2292         "x": 2155.9724638802663,\r
2293         "y": 3539.0955476760864,\r
2294         "z": "f2af2445.16fe78",\r
2295         "wires": []\r
2296     },\r
2297     {\r
2298         "id": "9b5b9cd9.fbaa6",\r
2299         "type": "comment",\r
2300         "name": "if we get here when there is no index length, then we have used up all 1000",\r
2301         "info": "",\r
2302         "comments": "",\r
2303         "x": 1874.5438444955007,\r
2304         "y": 3494.809862136841,\r
2305         "z": "f2af2445.16fe78",\r
2306         "wires": []\r
2307     },\r
2308     {\r
2309         "id": "8e750ec7.2ae83",\r
2310         "type": "returnFailure",\r
2311         "name": "return failure",\r
2312         "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"We have exhausted the naming index count\" />\n",\r
2313         "comments": "",\r
2314         "x": 1636.543878827776,\r
2315         "y": 4968.095459938049,\r
2316         "z": "f2af2445.16fe78",\r
2317         "wires": []\r
2318     },\r
2319     {\r
2320         "id": "3e63e2e.8d66c1e",\r
2321         "type": "set",\r
2322         "name": "set found-flag=false",\r
2323         "xml": "<set>\n<parameter name='tmp.gun.found-flag' value='false' />\n",\r
2324         "comments": "",\r
2325         "x": 1178.4484672546387,\r
2326         "y": 1258.0357694625854,\r
2327         "z": "f2af2445.16fe78",\r
2328         "wires": []\r
2329     },\r
2330     {\r
2331         "id": "2276b160.a9183e",\r
2332         "type": "set",\r
2333         "name": "set found-flag=true",\r
2334         "xml": "<set>\n<parameter name='tmp.gun.found-flag' value='true' />\n",\r
2335         "comments": "",\r
2336         "x": 2372.6151809692383,\r
2337         "y": 1873.0953306470599,\r
2338         "z": "f2af2445.16fe78",\r
2339         "wires": []\r
2340     },\r
2341     {\r
2342         "id": "41d904c1.515ddc",\r
2343         "type": "block",\r
2344         "name": "block : atomic",\r
2345         "xml": "<block atomic=\"true\">",\r
2346         "atomic": "true",\r
2347         "outputs": 1,\r
2348         "x": 2179.7580032348633,\r
2349         "y": 1899.2382749829974,\r
2350         "z": "f2af2445.16fe78",\r
2351         "wires": [\r
2352             [\r
2353                 "2276b160.a9183e",\r
2354                 "ad173e2b.5c512"\r
2355             ]\r
2356         ]\r
2357     },\r
2358     {\r
2359         "id": "19972ef5.57be21",\r
2360         "type": "returnFailure",\r
2361         "name": "BREAK",\r
2362         "xml": "<return status='failure'>\n",\r
2363         "comments": "",\r
2364         "x": 2787.972330365862,\r
2365         "y": 4230.952507972717,\r
2366         "z": "f2af2445.16fe78",\r
2367         "wires": []\r
2368     },\r
2369     {\r
2370         "id": "e21c1774.c206a8",\r
2371         "type": "comment",\r
2372         "name": "found one we can use",\r
2373         "info": "",\r
2374         "comments": "",\r
2375         "x": 2605.8297865731374,\r
2376         "y": 4162.000430107117,\r
2377         "z": "f2af2445.16fe78",\r
2378         "wires": []\r
2379     },\r
2380     {\r
2381         "id": "eaee2222.dfde9",\r
2382         "type": "set",\r
2383         "name": "set found-flag=true",\r
2384         "xml": "<set>\n<parameter name='tmp.gun.found-flag' value='true' />\n",\r
2385         "comments": "",\r
2386         "x": 2824.8772490365163,\r
2387         "y": 4182.714360237122,\r
2388         "z": "f2af2445.16fe78",\r
2389         "wires": []\r
2390     },\r
2391     {\r
2392         "id": "8688c71d.6f6348",\r
2393         "type": "block",\r
2394         "name": "block : atomic",\r
2395         "xml": "<block atomic=\"true\">",\r
2396         "atomic": "true",\r
2397         "outputs": 1,\r
2398         "x": 2632.0200713021413,\r
2399         "y": 4208.857304573059,\r
2400         "z": "f2af2445.16fe78",\r
2401         "wires": [\r
2402             [\r
2403                 "eaee2222.dfde9",\r
2404                 "19972ef5.57be21"\r
2405             ]\r
2406         ]\r
2407     },\r
2408     {\r
2409         "id": "3e4250a5.0ac4c",\r
2410         "type": "switchNode",\r
2411         "name": "switch generate-unique-name-input.supplied-name",\r
2412         "xml": "<switch test='`$generate-unique-name-input.supplied-name`'>\n",\r
2413         "comments": "",\r
2414         "outputs": 1,\r
2415         "x": 732.7340965270996,\r
2416         "y": 290.7143205915179,\r
2417         "z": "f2af2445.16fe78",\r
2418         "wires": [\r
2419             [\r
2420                 "d25a80d5.4e3b8",\r
2421                 "b7f46cb8.21a18"\r
2422             ]\r
2423         ]\r
2424     },\r
2425     {\r
2426         "id": "d25a80d5.4e3b8",\r
2427         "type": "outcome",\r
2428         "name": "NULL",\r
2429         "xml": "<outcome value=''>",\r
2430         "comments": "",\r
2431         "outputs": 1,\r
2432         "x": 991.3055953979492,\r
2433         "y": 317.85711615426203,\r
2434         "z": "f2af2445.16fe78",\r
2435         "wires": [\r
2436             [\r
2437                 "d51fb171.df3c3"\r
2438             ]\r
2439         ]\r
2440     },\r
2441     {\r
2442         "id": "b7f46cb8.21a18",\r
2443         "type": "other",\r
2444         "name": "other",\r
2445         "xml": "<outcome value='Other'>\n",\r
2446         "comments": "",\r
2447         "outputs": 1,\r
2448         "x": 991.3055725097656,\r
2449         "y": 259.7142862592425,\r
2450         "z": "f2af2445.16fe78",\r
2451         "wires": [\r
2452             [\r
2453                 "12ab5681.ce04d9"\r
2454             ]\r
2455         ]\r
2456     },\r
2457     {\r
2458         "id": "130234ee.46d2ab",\r
2459         "type": "switchNode",\r
2460         "name": "switch generate-unique-name-input.name-table-type",\r
2461         "xml": "<switch test='`$generate-unique-name-input.name-table-type`'>\n",\r
2462         "comments": "",\r
2463         "outputs": 1,\r
2464         "x": 1460.5912437438965,\r
2465         "y": 196.42856734139582,\r
2466         "z": "f2af2445.16fe78",\r
2467         "wires": [\r
2468             [\r
2469                 "15992563.c8c55b"\r
2470             ]\r
2471         ]\r
2472     },\r
2473     {\r
2474         "id": "15992563.c8c55b",\r
2475         "type": "outcome",\r
2476         "name": "NULL",\r
2477         "xml": "<outcome value=''>",\r
2478         "comments": "",\r
2479         "outputs": 1,\r
2480         "x": 1793.9244403839111,\r
2481         "y": 196.42857687813898,\r
2482         "z": "f2af2445.16fe78",\r
2483         "wires": [\r
2484             [\r
2485                 "47420284.6ade7c"\r
2486             ]\r
2487         ]\r
2488     },\r
2489     {\r
2490         "id": "47420284.6ade7c",\r
2491         "type": "returnFailure",\r
2492         "name": "return failure",\r
2493         "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value='generate-unique-name-input.name-table-type not supplied' />\n",\r
2494         "comments": "",\r
2495         "x": 1965.5912170410156,\r
2496         "y": 196.76188032967707,\r
2497         "z": "f2af2445.16fe78",\r
2498         "wires": []\r
2499     },\r
2500     {\r
2501         "id": "12ab5681.ce04d9",\r
2502         "type": "block",\r
2503         "name": "block : atomic",\r
2504         "xml": "<block atomic=\"true\">",\r
2505         "atomic": "true",\r
2506         "outputs": 1,\r
2507         "x": 1145.5912971496582,\r
2508         "y": 259.2857164655413,\r
2509         "z": "f2af2445.16fe78",\r
2510         "wires": [\r
2511             [\r
2512                 "130234ee.46d2ab",\r
2513                 "aabd4d90.16dd8",\r
2514                 "23a0ac.95990f54"\r
2515             ]\r
2516         ]\r
2517     },\r
2518     {\r
2519         "id": "23a0ac.95990f54",\r
2520         "type": "get-resource",\r
2521         "name": "get-resource name",\r
2522         "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n",\r
2523         "comments": "",\r
2524         "outputs": 1,\r
2525         "x": 1354.1627082824707,\r
2526         "y": 289.2857317243304,\r
2527         "z": "f2af2445.16fe78",\r
2528         "wires": [\r
2529             [\r
2530                 "6d7e1700.805508",\r
2531                 "5e3c9b34.a10a74",\r
2532                 "65ca162d.6df4c8"\r
2533             ]\r
2534         ]\r
2535     },\r
2536     {\r
2537         "id": "6d7e1700.805508",\r
2538         "type": "failure",\r
2539         "name": "failure",\r
2540         "xml": "<outcome value='failure'>\n",\r
2541         "comments": "",\r
2542         "outputs": 1,\r
2543         "x": 1536.7817573547363,\r
2544         "y": 276.42862742287775,\r
2545         "z": "f2af2445.16fe78",\r
2546         "wires": [\r
2547             [\r
2548                 "2d9f6bb3.0fef44"\r
2549             ]\r
2550         ]\r
2551     },\r
2552     {\r
2553         "id": "aabd4d90.16dd8",\r
2554         "type": "set",\r
2555         "name": "set sql statement",\r
2556         "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $generate-unique-name-input.supplied-name'`\" />\n",\r
2557         "comments": "",\r
2558         "x": 1347.734260559082,\r
2559         "y": 241.6667494092669,\r
2560         "z": "f2af2445.16fe78",\r
2561         "wires": []\r
2562     },\r
2563     {\r
2564         "id": "5e3c9b34.a10a74",\r
2565         "type": "not-found",\r
2566         "name": "not-found",\r
2567         "xml": "<outcome value='not-found'>\n",\r
2568         "comments": "",\r
2569         "outputs": 1,\r
2570         "x": 1544.8771133422852,\r
2571         "y": 321.6667379651751,\r
2572         "z": "f2af2445.16fe78",\r
2573         "wires": [\r
2574             [\r
2575                 "ef3f7999.12f238"\r
2576             ]\r
2577         ]\r
2578     },\r
2579     {\r
2580         "id": "2d9f6bb3.0fef44",\r
2581         "type": "returnFailure",\r
2582         "name": "return failure",\r
2583         "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value=\"`'Error reading the ' + $generate-unique-name-input.name-table-index + ' table'`\" />\n\n",\r
2584         "comments": "",\r
2585         "x": 1692.7341804504395,\r
2586         "y": 276.00003283364435,\r
2587         "z": "f2af2445.16fe78",\r
2588         "wires": []\r
2589     },\r
2590     {\r
2591         "id": "65ca162d.6df4c8",\r
2592         "type": "other",\r
2593         "name": "other",\r
2594         "xml": "<outcome value='Other'>\n",\r
2595         "comments": "",\r
2596         "outputs": 1,\r
2597         "x": 1537.0198822021484,\r
2598         "y": 363.57143156869074,\r
2599         "z": "f2af2445.16fe78",\r
2600         "wires": [\r
2601             [\r
2602                 "4d68280b.2d7b18"\r
2603             ]\r
2604         ]\r
2605     },\r
2606     {\r
2607         "id": "4d68280b.2d7b18",\r
2608         "type": "returnFailure",\r
2609         "name": "return failure",\r
2610         "xml": "<return status='failure'>\n<parameter name='generate-unique-name-output.error-message' value=\"`'The name ' + $generate-unique-name-input.supplied-name + ' has already been used'`\" />\n\n",\r
2611         "comments": "",\r
2612         "x": 1692.7341194152832,\r
2613         "y": 362.999995640346,\r
2614         "z": "f2af2445.16fe78",\r
2615         "wires": []\r
2616     },\r
2617     {\r
2618         "id": "6ed6588d.7a0f78",\r
2619         "type": "comment",\r
2620         "name": "Caller supplied name - make sure it's not already used",\r
2621         "info": "",\r
2622         "comments": "",\r
2623         "x": 1387.7699127197266,\r
2624         "y": 154.1428575515747,\r
2625         "z": "f2af2445.16fe78",\r
2626         "wires": []\r
2627     },\r
2628     {\r
2629         "id": "ef3f7999.12f238",\r
2630         "type": "block",\r
2631         "name": "block : atomic",\r
2632         "xml": "<block atomic=\"true\">",\r
2633         "atomic": "true",\r
2634         "outputs": 1,\r
2635         "x": 1694.1628074645996,\r
2636         "y": 322.1428446088519,\r
2637         "z": "f2af2445.16fe78",\r
2638         "wires": [\r
2639             [\r
2640                 "553234b3.8d5a7c",\r
2641                 "be029280.19e4b"\r
2642             ]\r
2643         ]\r
2644     },\r
2645     {\r
2646         "id": "be029280.19e4b",\r
2647         "type": "save",\r
2648         "name": "save (insert) generated name",\r
2649         "xml": "<save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='pfx'>\n",\r
2650         "comments": "",\r
2651         "outputs": 1,\r
2652         "x": 1934.1628074645996,\r
2653         "y": 346.42858069283625,\r
2654         "z": "f2af2445.16fe78",\r
2655         "wires": [\r
2656             [\r
2657                 "94aa6f8b.9aaf4"\r
2658             ]\r
2659         ]\r
2660     },\r
2661     {\r
2662         "id": "94aa6f8b.9aaf4",\r
2663         "type": "failure",\r
2664         "name": "failure",\r
2665         "xml": "<outcome value='failure'>\n",\r
2666         "comments": "",\r
2667         "outputs": 1,\r
2668         "x": 2144.162738800049,\r
2669         "y": 346.42863219124933,\r
2670         "z": "f2af2445.16fe78",\r
2671         "wires": [\r
2672             [\r
2673                 "98e91b64.eafea8"\r
2674             ]\r
2675         ]\r
2676     },\r
2677     {\r
2678         "id": "98e91b64.eafea8",\r
2679         "type": "returnFailure",\r
2680         "name": "return failure",\r
2681         "xml": "<return status='failure'>\n<parameter name=\"generate-unique-name-output.error-message\" value=\"Failed insert into GENERIC_RESOURCE_NAME table\" />\n",\r
2682         "comments": "",\r
2683         "x": 2298.448554992676,\r
2684         "y": 346.42865126473566,\r
2685         "z": "f2af2445.16fe78",\r
2686         "wires": []\r
2687     },\r
2688     {\r
2689         "id": "553234b3.8d5a7c",\r
2690         "type": "set",\r
2691         "name": "set sql statement",\r
2692         "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'insert into GENERIC_RESOURCE_NAME values ( '\n+ ' $generate-unique-name-input.name-table-type , $generate-unique-name-input.supplied-name , null , null, $generate-unique-name-input.service-instance-id )'`\" />\n\n",\r
2693         "comments": "",\r
2694         "x": 1894.1627388000488,\r
2695         "y": 296.4287580762591,\r
2696         "z": "f2af2445.16fe78",\r
2697         "wires": []\r
2698     },\r
2699     {\r
2700         "id": "b3a55875.754e68",\r
2701         "type": "set",\r
2702         "name": "set sql statement",\r
2703         "xml": "<set>\n<parameter name='tmp.gun.sql' \n\tvalue=\"`'insert into GENERIC_RESOURCE_NAME values ( $generate-unique-name-input.name-table-type , $tmp.gun.generated-name , $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ' , $tmp.gun.transient )'`\" />\n\n",\r
2704         "comments": "",\r
2705         "x": 1638.1627791268484,\r
2706         "y": 3122.857078552246,\r
2707         "z": "f2af2445.16fe78",\r
2708         "wires": []\r
2709     },\r
2710     {\r
2711         "id": "6dd3f32a.b9635c",\r
2712         "type": "set",\r
2713         "name": "set sql statement",\r
2714         "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $tmp.gun.generated-name'`\" />\n",\r
2715         "comments": "",\r
2716         "x": 2292.2581084115163,\r
2717         "y": 4075.2382822036743,\r
2718         "z": "f2af2445.16fe78",\r
2719         "wires": []\r
2720     },\r
2721     {\r
2722         "id": "144fc795.5db808",\r
2723         "type": "set",\r
2724         "name": "set sql statement",\r
2725         "xml": "<set>\n<parameter name='tmp.gun.sql' \n\tvalue=\"`'insert into GENERIC_RESOURCE_NAME values ( $generate-unique-name-input.name-table-type , $tmp.gun.generated-name , $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ' , $tmp.gun.transient )'`\" />\n\n",\r
2726         "comments": "",\r
2727         "x": 2167.972303662981,\r
2728         "y": 4759.523810386658,\r
2729         "z": "f2af2445.16fe78",\r
2730         "wires": []\r
2731     },\r
2732     {\r
2733         "id": "b2adf596.b14dc8",\r
2734         "type": "returnFailure",\r
2735         "name": "return failure",\r
2736         "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to update ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n",\r
2737         "comments": "",\r
2738         "x": 2561.019964490618,\r
2739         "y": 2987.142795562744,\r
2740         "z": "f2af2445.16fe78",\r
2741         "wires": []\r
2742     },\r
2743     {\r
2744         "id": "a521b607.e28cf8",\r
2745         "type": "returnFailure",\r
2746         "name": "return failure",\r
2747         "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"`'Failed to insert record into ' + $generate-unique-name-input.index-table-name + ' table'`\" />\n",\r
2748         "comments": "",\r
2749         "x": 2558.1625769478933,\r
2750         "y": 3080.4285764694214,\r
2751         "z": "f2af2445.16fe78",\r
2752         "wires": []\r
2753     },\r
2754     {\r
2755         "id": "c4268ba7.916128",\r
2756         "type": "outcomeFalse",\r
2757         "name": "false",\r
2758         "xml": "<outcome value='false'>\n",\r
2759         "comments": "",\r
2760         "outputs": 1,\r
2761         "x": 1280.1151068551198,\r
2762         "y": 3397.8571519851685,\r
2763         "z": "f2af2445.16fe78",\r
2764         "wires": [\r
2765             [\r
2766                 "59148c70.cdee34"\r
2767             ]\r
2768         ]\r
2769     },\r
2770     {\r
2771         "id": "59148c70.cdee34",\r
2772         "type": "block",\r
2773         "name": "block : atomic",\r
2774         "xml": "<block atomic=\"true\">",\r
2775         "atomic": "true",\r
2776         "outputs": 1,\r
2777         "x": 1430.9485152108327,\r
2778         "y": 4009.523675918579,\r
2779         "z": "f2af2445.16fe78",\r
2780         "wires": [\r
2781             [\r
2782                 "f36b5bce.ce38d8",\r
2783                 "7c854eaa.cabde",\r
2784                 "cbbbd754.515278",\r
2785                 "8da20e83.48444",\r
2786                 "8e750ec7.2ae83",\r
2787                 "974e3eea.a57fc"\r
2788             ]\r
2789         ]\r
2790     },\r
2791     {\r
2792         "id": "a98b0c69.c8ff5",\r
2793         "type": "success",\r
2794         "name": "success",\r
2795         "xml": "<outcome value='success'>\n",\r
2796         "comments": "",\r
2797         "outputs": 1,\r
2798         "x": 1445.0913696289062,\r
2799         "y": 1005.5357429981232,\r
2800         "z": "f2af2445.16fe78",\r
2801         "wires": [\r
2802             [\r
2803                 "f97c717e.aeece"\r
2804             ]\r
2805         ]\r
2806     },\r
2807     {\r
2808         "id": "b88e0290.6b67d",\r
2809         "type": "not-found",\r
2810         "name": "not-found",\r
2811         "xml": "<outcome value='not-found'>\n",\r
2812         "comments": "",\r
2813         "outputs": 1,\r
2814         "x": 1451.6628875732422,\r
2815         "y": 1112.1785898208618,\r
2816         "z": "f2af2445.16fe78",\r
2817         "wires": [\r
2818             [\r
2819                 "4201eca6.c7d3f4"\r
2820             ]\r
2821         ]\r
2822     },\r
2823     {\r
2824         "id": "4201eca6.c7d3f4",\r
2825         "type": "block",\r
2826         "name": "block",\r
2827         "xml": "<block>\n",\r
2828         "atomic": "false",\r
2829         "comments": "",\r
2830         "outputs": 1,\r
2831         "x": 1583.091438293457,\r
2832         "y": 1111.607195854187,\r
2833         "z": "f2af2445.16fe78",\r
2834         "wires": [\r
2835             [\r
2836                 "3d4b23e4.f03d2c",\r
2837                 "e19f8c74.cb7de"\r
2838             ]\r
2839         ]\r
2840     },\r
2841     {\r
2842         "id": "a3abe6b2.a53fb8",\r
2843         "type": "set",\r
2844         "name": "set sql statement",\r
2845         "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $tmp.gun.generated-name'`\" />\n",\r
2846         "comments": "",\r
2847         "x": 1837.9365768432617,\r
2848         "y": 1771.428593635559,\r
2849         "z": "f2af2445.16fe78",\r
2850         "wires": []\r
2851     },\r
2852     {\r
2853         "id": "5cfa637b.4338bc",\r
2854         "type": "get-resource",\r
2855         "name": "get-resource name",\r
2856         "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n",\r
2857         "comments": "",\r
2858         "outputs": 1,\r
2859         "x": 1839.3651847839355,\r
2860         "y": 1858.5715169906616,\r
2861         "z": "f2af2445.16fe78",\r
2862         "wires": [\r
2863             [\r
2864                 "be62e7ae.90b8f8",\r
2865                 "96f6c88d.8b7e38"\r
2866             ]\r
2867         ]\r
2868     },\r
2869     {\r
2870         "id": "360fc793.866bf8",\r
2871         "type": "block",\r
2872         "name": "block : atomic",\r
2873         "xml": "<block atomic=\"true\">",\r
2874         "atomic": "true",\r
2875         "outputs": 1,\r
2876         "x": 431.68655014038086,\r
2877         "y": 265.00000381469727,\r
2878         "z": "f2af2445.16fe78",\r
2879         "wires": [\r
2880             [\r
2881                 "3e4250a5.0ac4c",\r
2882                 "dcbeacf.6f2ab5"\r
2883             ]\r
2884         ]\r
2885     },\r
2886     {\r
2887         "id": "dcbeacf.6f2ab5",\r
2888         "type": "set",\r
2889         "name": "clear variables",\r
2890         "xml": "<set>\n<parameter name='generate-unique-name-output.error-message' value='' />\n<parameter name='generate-unique-name-output.generated-name' value='' />\n",\r
2891         "comments": "",\r
2892         "x": 619.0079803466797,\r
2893         "y": 242.8571424484253,\r
2894         "z": "f2af2445.16fe78",\r
2895         "wires": []\r
2896     },\r
2897     {\r
2898         "id": "26eda43b.2c3b5c",\r
2899         "type": "outcome",\r
2900         "name": "0",\r
2901         "xml": "<outcome value='0'>\n",\r
2902         "comments": "",\r
2903         "outputs": 1,\r
2904         "x": 1624.1148872375488,\r
2905         "y": 690.3571691513062,\r
2906         "z": "f2af2445.16fe78",\r
2907         "wires": [\r
2908             [\r
2909                 "e3969b91.7deb58"\r
2910             ]\r
2911         ]\r
2912     },\r
2913     {\r
2914         "id": "e3969b91.7deb58",\r
2915         "type": "set",\r
2916         "name": "set list-end = 0",\r
2917         "xml": "<set>\n<parameter name='tmp.gun.list-end' value='0' />\n",\r
2918         "comments": "",\r
2919         "x": 1813.7815322875977,\r
2920         "y": 690.3571462631226,\r
2921         "z": "f2af2445.16fe78",\r
2922         "wires": []\r
2923     },\r
2924     {\r
2925         "id": "187251ba.f9a6ce",\r
2926         "type": "switchNode",\r
2927         "name": "switch tmp.gun.noindex-flag",\r
2928         "xml": "<switch test='`$tmp.gun.noindex-flag`'>\n",\r
2929         "comments": "",\r
2930         "outputs": 1,\r
2931         "x": 1388.6150038582937,\r
2932         "y": 2054.000086784363,\r
2933         "z": "f2af2445.16fe78",\r
2934         "wires": [\r
2935             [\r
2936                 "47d30b82.5fa434"\r
2937             ]\r
2938         ]\r
2939     },\r
2940     {\r
2941         "id": "dc9a064f.20c918",\r
2942         "type": "switchNode",\r
2943         "name": "switch generate-unique-name-input.index-length",\r
2944         "xml": "<switch test='`$generate-unique-name-input.index-length`'>\n",\r
2945         "comments": "",\r
2946         "outputs": 1,\r
2947         "x": 1844.9008140563965,\r
2948         "y": 1030.4285879135132,\r
2949         "z": "f2af2445.16fe78",\r
2950         "wires": [\r
2951             [\r
2952                 "35b6590.63450a8",\r
2953                 "7a0d894c.1efd48"\r
2954             ]\r
2955         ]\r
2956     },\r
2957     {\r
2958         "id": "35b6590.63450a8",\r
2959         "type": "outcome",\r
2960         "name": "0",\r
2961         "xml": "<outcome value='0'>\n",\r
2962         "comments": "",\r
2963         "outputs": 1,\r
2964         "x": 2111.1508140563965,\r
2965         "y": 1058.6785898208618,\r
2966         "z": "f2af2445.16fe78",\r
2967         "wires": [\r
2968             [\r
2969                 "ca199039.4ea94"\r
2970             ]\r
2971         ]\r
2972     },\r
2973     {\r
2974         "id": "7a0d894c.1efd48",\r
2975         "type": "other",\r
2976         "name": "other",\r
2977         "xml": "<outcome value='Other'>\n",\r
2978         "comments": "",\r
2979         "outputs": 1,\r
2980         "x": 2112.650810241699,\r
2981         "y": 998.6785879135132,\r
2982         "z": "f2af2445.16fe78",\r
2983         "wires": [\r
2984             [\r
2985                 "5e88e850.5de788"\r
2986             ]\r
2987         ]\r
2988     },\r
2989     {\r
2990         "id": "5e88e850.5de788",\r
2991         "type": "set",\r
2992         "name": "increment index number",\r
2993         "xml": "<set>\n<parameter name='tmp.gun.index-number' value='`$tmp.gun.prefixdb.index-number + 1`' />\n",\r
2994         "comments": "",\r
2995         "x": 2305.150810241699,\r
2996         "y": 998.4285879135132,\r
2997         "z": "f2af2445.16fe78",\r
2998         "wires": []\r
2999     },\r
3000     {\r
3001         "id": "85418744.04a698",\r
3002         "type": "set",\r
3003         "name": "set  index number to 0",\r
3004         "xml": "<set>\n<parameter name='tmp.gun.index-number' value='0' />\n",\r
3005         "comments": "",\r
3006         "x": 2449.1510581970215,\r
3007         "y": 1060.4285879135132,\r
3008         "z": "f2af2445.16fe78",\r
3009         "wires": []\r
3010     },\r
3011     {\r
3012         "id": "e19f8c74.cb7de",\r
3013         "type": "switchNode",\r
3014         "name": "switch generate-unique-name-input.index-length",\r
3015         "xml": "<switch test='`$generate-unique-name-input.index-length`'>\n",\r
3016         "comments": "",\r
3017         "outputs": 1,\r
3018         "x": 1842.4008140563965,\r
3019         "y": 1141.4285898208618,\r
3020         "z": "f2af2445.16fe78",\r
3021         "wires": [\r
3022             [\r
3023                 "9925306e.7b5d6",\r
3024                 "4fb0aa57.8d75b4"\r
3025             ]\r
3026         ]\r
3027     },\r
3028     {\r
3029         "id": "4fb0aa57.8d75b4",\r
3030         "type": "other",\r
3031         "name": "other",\r
3032         "xml": "<outcome value='Other'>\n",\r
3033         "comments": "",\r
3034         "outputs": 1,\r
3035         "x": 2112.400810241699,\r
3036         "y": 1163.4285898208618,\r
3037         "z": "f2af2445.16fe78",\r
3038         "wires": [\r
3039             [\r
3040                 "80595c6f.d370b"\r
3041             ]\r
3042         ]\r
3043     },\r
3044     {\r
3045         "id": "9925306e.7b5d6",\r
3046         "type": "outcome",\r
3047         "name": "0",\r
3048         "xml": "<outcome value='0'>\n",\r
3049         "comments": "",\r
3050         "outputs": 1,\r
3051         "x": 2112.400833129883,\r
3052         "y": 1107.1785457134247,\r
3053         "z": "f2af2445.16fe78",\r
3054         "wires": [\r
3055             [\r
3056                 "ca199039.4ea94"\r
3057             ]\r
3058         ]\r
3059     },\r
3060     {\r
3061         "id": "ca199039.4ea94",\r
3062         "type": "block",\r
3063         "name": "block",\r
3064         "xml": "<block>\n",\r
3065         "atomic": "false",\r
3066         "comments": "",\r
3067         "outputs": 1,\r
3068         "x": 2261.150806427002,\r
3069         "y": 1085.9285879135132,\r
3070         "z": "f2af2445.16fe78",\r
3071         "wires": [\r
3072             [\r
3073                 "85418744.04a698",\r
3074                 "c639252a.452078"\r
3075             ]\r
3076         ]\r
3077     },\r
3078     {\r
3079         "id": "c639252a.452078",\r
3080         "type": "set",\r
3081         "name": "set noindex-flag=true",\r
3082         "xml": "<set>\n<parameter name='tmp.gun.noindex-flag' value='true' />\n",\r
3083         "comments": "",\r
3084         "x": 2448.650775909424,\r
3085         "y": 1109.4285726547241,\r
3086         "z": "f2af2445.16fe78",\r
3087         "wires": []\r
3088     },\r
3089     {\r
3090         "id": "4139d69a.f19178",\r
3091         "type": "set",\r
3092         "name": "set generated-name to prefix",\r
3093         "xml": "<set>\n<parameter name='tmp.gun.generated-name' value='`$generate-unique-name-input.prefix`' />\n",\r
3094         "comments": "",\r
3095         "x": 1991.650854383196,\r
3096         "y": 2105.428624153137,\r
3097         "z": "f2af2445.16fe78",\r
3098         "wires": []\r
3099     },\r
3100     {\r
3101         "id": "47d30b82.5fa434",\r
3102         "type": "outcome",\r
3103         "name": "true",\r
3104         "xml": "<outcome value='true'>",\r
3105         "comments": "",\r
3106         "outputs": 1,\r
3107         "x": 1585.936540876116,\r
3108         "y": 2054.000069618225,\r
3109         "z": "f2af2445.16fe78",\r
3110         "wires": [\r
3111             [\r
3112                 "6400bec6.70c0b"\r
3113             ]\r
3114         ]\r
3115     },\r
3116     {\r
3117         "id": "6400bec6.70c0b",\r
3118         "type": "block",\r
3119         "name": "block : atomic",\r
3120         "xml": "<block atomic=\"true\">",\r
3121         "atomic": "true",\r
3122         "outputs": 1,\r
3123         "x": 1737.3648970467702,\r
3124         "y": 2054.0001916885376,\r
3125         "z": "f2af2445.16fe78",\r
3126         "wires": [\r
3127             [\r
3128                 "1d2241eb.be7a9e",\r
3129                 "8c4f455f.ad7488",\r
3130                 "4139d69a.f19178",\r
3131                 "e298800b.28418"\r
3132             ]\r
3133         ]\r
3134     },\r
3135     {\r
3136         "id": "8c4f455f.ad7488",\r
3137         "type": "set",\r
3138         "name": "set sql statement",\r
3139         "xml": "<set>\n<parameter name='tmp.gun.sql' value=\"`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\n+ ' AND name = $tmp.gun.generated-name'`\" />\n",\r
3140         "comments": "",\r
3141         "x": 1958.6389601571218,\r
3142         "y": 2148.286027908325,\r
3143         "z": "f2af2445.16fe78",\r
3144         "wires": []\r
3145     },\r
3146     {\r
3147         "id": "1d2241eb.be7a9e",\r
3148         "type": "get-resource",\r
3149         "name": "get-resource name",\r
3150         "xml": "<get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\n  key=\"`$tmp.gun.sql`\" pfx='tmp.gun.namedb'>\n\n",\r
3151         "comments": "",\r
3152         "outputs": 1,\r
3153         "x": 1965.3533537728445,\r
3154         "y": 2192.4287090301514,\r
3155         "z": "f2af2445.16fe78",\r
3156         "wires": [\r
3157             [\r
3158                 "c3e26aa5.5a6ad8",\r
3159                 "f20ea659.abb5d8",\r
3160                 "ddda4cb5.69a3c"\r
3161             ]\r
3162         ]\r
3163     },\r
3164     {\r
3165         "id": "c3e26aa5.5a6ad8",\r
3166         "type": "failure",\r
3167         "name": "failure",\r
3168         "xml": "<outcome value='failure'>\n",\r
3169         "comments": "",\r
3170         "outputs": 1,\r
3171         "x": 2157.6509650094167,\r
3172         "y": 2191.7145656858174,\r
3173         "z": "f2af2445.16fe78",\r
3174         "wires": [\r
3175             [\r
3176                 "e6b7e26f.94d48"\r
3177             ]\r
3178         ]\r
3179     },\r
3180     {\r
3181         "id": "f20ea659.abb5d8",\r
3182         "type": "not-found",\r
3183         "name": "not-found",\r
3184         "xml": "<outcome value='not-found'>\n",\r
3185         "comments": "",\r
3186         "outputs": 1,\r
3187         "x": 2164.3177016122,\r
3188         "y": 2282.6669611249654,\r
3189         "z": "f2af2445.16fe78",\r
3190         "wires": [\r
3191             [\r
3192                 "f1cf4980.556c18"\r
3193             ]\r
3194         ]\r
3195     },\r
3196     {\r
3197         "id": "f1cf4980.556c18",\r
3198         "type": "block",\r
3199         "name": "block : atomic",\r
3200         "xml": "<block atomic=\"true\">",\r
3201         "atomic": "true",\r
3202         "outputs": 1,\r
3203         "x": 2347.1746297563823,\r
3204         "y": 2282.0954637527466,\r
3205         "z": "f2af2445.16fe78",\r
3206         "wires": [\r
3207             [\r
3208                 "825e78.6ae53188",\r
3209                 "caf8b992.a7b668"\r
3210             ]\r
3211         ]\r
3212     },\r
3213     {\r
3214         "id": "caf8b992.a7b668",\r
3215         "type": "returnFailure",\r
3216         "name": "BREAK",\r
3217         "xml": "<return status='failure'>\n",\r
3218         "comments": "",\r
3219         "x": 2503.126888820103,\r
3220         "y": 2304.190667152405,\r
3221         "z": "f2af2445.16fe78",\r
3222         "wires": []\r
3223     },\r
3224     {\r
3225         "id": "825e78.6ae53188",\r
3226         "type": "set",\r
3227         "name": "set found-flag=true",\r
3228         "xml": "<set>\n<parameter name='tmp.gun.found-flag' value='true' />\n",\r
3229         "comments": "",\r
3230         "x": 2540.0318074907573,\r
3231         "y": 2255.952519416809,\r
3232         "z": "f2af2445.16fe78",\r
3233         "wires": []\r
3234     },\r
3235     {\r
3236         "id": "63ab1b54.3f87f4",\r
3237         "type": "returnFailure",\r
3238         "name": "BREAK",\r
3239         "xml": "<return status='failure'>\n",\r
3240         "comments": "",\r
3241         "x": 2468.8414633614675,\r
3242         "y": 2210.285986355373,\r
3243         "z": "f2af2445.16fe78",\r
3244         "wires": []\r
3245     },\r
3246     {\r
3247         "id": "b2a157a3.5da4b8",\r
3248         "type": "set",\r
3249         "name": "set generate-unique-name-output.error-message",\r
3250         "xml": "<set>\n<parameter name='generate-unique-name-output.error-message' value=\"`'Error reading the GENERIC_RESOURCE_NAME table'`\" />\n",\r
3251         "comments": "",\r
3252         "x": 2603.603216443743,\r
3253         "y": 2165.285898617336,\r
3254         "z": "f2af2445.16fe78",\r
3255         "wires": []\r
3256     },\r
3257     {\r
3258         "id": "e6b7e26f.94d48",\r
3259         "type": "block",\r
3260         "name": "block : atomic",\r
3261         "xml": "<block atomic=\"true\">",\r
3262         "atomic": "true",\r
3263         "outputs": 1,\r
3264         "x": 2310.0319617135183,\r
3265         "y": 2191.238484791347,\r
3266         "z": "f2af2445.16fe78",\r
3267         "wires": [\r
3268             [\r
3269                 "b2a157a3.5da4b8",\r
3270                 "63ab1b54.3f87f4"\r
3271             ]\r
3272         ]\r
3273     },\r
3274     {\r
3275         "id": "c261792d.2d6c28",\r
3276         "type": "comment",\r
3277         "name": "found one we can use",\r
3278         "info": "",\r
3279         "comments": "",\r
3280         "x": 2320.9843450273784,\r
3281         "y": 2235.238589286804,\r
3282         "z": "f2af2445.16fe78",\r
3283         "wires": []\r
3284     },\r
3285     {\r
3286         "id": "412400cc.a3efa",\r
3287         "type": "comment",\r
3288         "name": "NEW",\r
3289         "info": "",\r
3290         "comments": "",\r
3291         "x": 1517.9363158089773,\r
3292         "y": 697.1428834370204,\r
3293         "z": "f2af2445.16fe78",\r
3294         "wires": []\r
3295     },\r
3296     {\r
3297         "id": "9e0fc23a.f7e51",\r
3298         "type": "comment",\r
3299         "name": "NEW",\r
3300         "info": "",\r
3301         "comments": "",\r
3302         "x": 1387.3651237487793,\r
3303         "y": 2019.7142505645752,\r
3304         "z": "f2af2445.16fe78",\r
3305         "wires": []\r
3306     },\r
3307     {\r
3308         "id": "e7d53672.156128",\r
3309         "type": "comment",\r
3310         "name": "NEW",\r
3311         "info": "",\r
3312         "comments": "",\r
3313         "x": 1987.9365043640137,\r
3314         "y": 997.1428213119507,\r
3315         "z": "f2af2445.16fe78",\r
3316         "wires": []\r
3317     },\r
3318     {\r
3319         "id": "c8a8f3.23f8271",\r
3320         "type": "comment",\r
3321         "name": "NEW",\r
3322         "info": "",\r
3323         "comments": "",\r
3324         "x": 1980.7937278747559,\r
3325         "y": 1111.4285726547241,\r
3326         "z": "f2af2445.16fe78",\r
3327         "wires": []\r
3328     },\r
3329     {\r
3330         "id": "e298800b.28418",\r
3331         "type": "set",\r
3332         "name": "set index-string to 0",\r
3333         "xml": "<set>\n<parameter name='tmp.gun.index-string' value='0' />\n",\r
3334         "comments": "",\r
3335         "x": 1975.9364073617116,\r
3336         "y": 2054.285785675049,\r
3337         "z": "f2af2445.16fe78",\r
3338         "wires": []\r
3339     },\r
3340     {\r
3341         "id": "974e3eea.a57fc",\r
3342         "type": "switchNode",\r
3343         "name": "switch tmp.gun.noindex-flag",\r
3344         "xml": "<switch test='`$tmp.gun.noindex-flag`'>\n",\r
3345         "comments": "",\r
3346         "outputs": 1,\r
3347         "x": 1679.3651259286062,\r
3348         "y": 3421.2859582901,\r
3349         "z": "f2af2445.16fe78",\r
3350         "wires": [\r
3351             [\r
3352                 "7a90c21f.11fb9c"\r
3353             ]\r
3354         ]\r
3355     },\r
3356     {\r
3357         "id": "7a90c21f.11fb9c",\r
3358         "type": "outcome",\r
3359         "name": "true",\r
3360         "xml": "<outcome value='true'>",\r
3361         "comments": "",\r
3362         "outputs": 1,\r
3363         "x": 1885.0794051034109,\r
3364         "y": 3421.285864830017,\r
3365         "z": "f2af2445.16fe78",\r
3366         "wires": [\r
3367             [\r
3368                 "fde97220.7206d"\r
3369             ]\r
3370         ]\r
3371     },\r
3372     {\r
3373         "id": "fde97220.7206d",\r
3374         "type": "returnFailure",\r
3375         "name": "return failure",\r
3376         "xml": "<return status='failure'>\n    <parameter name=\"generate-unique-name-output.error-message\" value=\"naming exhausted for input with index-length = 0\" />\n",\r
3377         "comments": "",\r
3378         "x": 2049.3652479989187,\r
3379         "y": 3419.8571424484253,\r
3380         "z": "f2af2445.16fe78",\r
3381         "wires": []\r
3382     },\r
3383     {\r
3384         "id": "ddda4cb5.69a3c",\r
3385         "type": "success",\r
3386         "name": "success",\r
3387         "xml": "<outcome value='success'>\n",\r
3388         "comments": "",\r
3389         "outputs": 1,\r
3390         "x": 2159.8293882097514,\r
3391         "y": 2338.14271068573,\r
3392         "z": "f2af2445.16fe78",\r
3393         "wires": [\r
3394             [\r
3395                 "f1cf4980.556c18"\r
3396             ]\r
3397         ]\r
3398     },\r
3399     {\r
3400         "id": "59274ef2.cf994",\r
3401         "type": "outcome",\r
3402         "name": "4",\r
3403         "xml": "<outcome value='4'>\n",\r
3404         "comments": "",\r
3405         "outputs": 1,\r
3406         "x": 1623.650779724121,\r
3407         "y": 871.4285898208618,\r
3408         "z": "f2af2445.16fe78",\r
3409         "wires": [\r
3410             [\r
3411                 "2c30bd52.6fca32"\r
3412             ]\r
3413         ]\r
3414     },\r
3415     {\r
3416         "id": "2c30bd52.6fca32",\r
3417         "type": "set",\r
3418         "name": "set list-end = 10000",\r
3419         "xml": "<set>\n<parameter name='tmp.gun.list-end' value='10000' />\n",\r
3420         "comments": "",\r
3421         "x": 1813.31742477417,\r
3422         "y": 871.4285669326782,\r
3423         "z": "f2af2445.16fe78",\r
3424         "wires": []\r
3425     },\r
3426     {\r
3427         "id": "c12d0b68.b45788",\r
3428         "type": "outcome",\r
3429         "name": "4",\r
3430         "xml": "<outcome value='4'>\n",\r
3431         "comments": "",\r
3432         "outputs": 1,\r
3433         "x": 2207.9363975524902,\r
3434         "y": 1584.2856855392456,\r
3435         "z": "f2af2445.16fe78",\r
3436         "wires": [\r
3437             [\r
3438                 "6a0e3f0e.bdf0d"\r
3439             ]\r
3440         ]\r
3441     },\r
3442     {\r
3443         "id": "6a0e3f0e.bdf0d",\r
3444         "type": "switchNode",\r
3445         "name": "switch idx < 10",\r
3446         "xml": "<switch test='`$tmp.gun.idx &lt; 10`'>\n",\r
3447         "comments": "",\r
3448         "outputs": 1,\r
3449         "x": 2376.269733428955,\r
3450         "y": 1582.6188135147095,\r
3451         "z": "f2af2445.16fe78",\r
3452         "wires": [\r
3453             [\r
3454                 "e077a096.c90b5",\r
3455                 "3ba27764.7bb978"\r
3456             ]\r
3457         ]\r
3458     },\r
3459     {\r
3460         "id": "e077a096.c90b5",\r
3461         "type": "outcomeTrue",\r
3462         "name": "true",\r
3463         "xml": "<outcome value='true'>\n",\r
3464         "comments": "",\r
3465         "outputs": 1,\r
3466         "x": 2544.8410606384277,\r
3467         "y": 1535.5236520767212,\r
3468         "z": "f2af2445.16fe78",\r
3469         "wires": [\r
3470             [\r
3471                 "6f52ffca.5f968"\r
3472             ]\r
3473         ]\r
3474     },\r
3475     {\r
3476         "id": "3ba27764.7bb978",\r
3477         "type": "outcomeFalse",\r
3478         "name": "false",\r
3479         "xml": "<outcome value='false'>\n",\r
3480         "comments": "",\r
3481         "outputs": 1,\r
3482         "x": 2557.936367034912,\r
3483         "y": 1660.9521493911743,\r
3484         "z": "f2af2445.16fe78",\r
3485         "wires": [\r
3486             [\r
3487                 "532853bc.fe84cc"\r
3488             ]\r
3489         ]\r
3490     },\r
3491     {\r
3492         "id": "c2125c33.cdb9e",\r
3493         "type": "set",\r
3494         "name": "set noindex-flag=false",\r
3495         "xml": "<set>\n<parameter name='tmp.gun.noindex-flag' value='false' />\n",\r
3496         "comments": "",\r
3497         "x": 1190.7936058044434,\r
3498         "y": 874.2857313156128,\r
3499         "z": "f2af2445.16fe78",\r
3500         "wires": []\r
3501     },\r
3502     {\r
3503         "id": "1a8e79c7.61ce76",\r
3504         "type": "set",\r
3505         "name": "set index-string to '00' + idx",\r
3506         "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '00' + $tmp.gun.idx`\" />\n",\r
3507         "comments": "",\r
3508         "x": 3100.793617248535,\r
3509         "y": 1616.4285522188459,\r
3510         "z": "f2af2445.16fe78",\r
3511         "wires": []\r
3512     },\r
3513     {\r
3514         "id": "1afc6185.a5540e",\r
3515         "type": "switchNode",\r
3516         "name": "switch idx < 1000",\r
3517         "xml": "<switch test='`$tmp.gun.idx &lt; 1000`'>\n",\r
3518         "comments": "",\r
3519         "outputs": 1,\r
3520         "x": 3063.7935638427734,\r
3521         "y": 1695.7619800567627,\r
3522         "z": "f2af2445.16fe78",\r
3523         "wires": [\r
3524             [\r
3525                 "a4f34d49.5db71",\r
3526                 "751b1f96.b3bdc"\r
3527             ]\r
3528         ]\r
3529     },\r
3530     {\r
3531         "id": "a4f34d49.5db71",\r
3532         "type": "outcomeTrue",\r
3533         "name": "true",\r
3534         "xml": "<outcome value='true'>\n",\r
3535         "comments": "",\r
3536         "outputs": 1,\r
3537         "x": 3220.79354095459,\r
3538         "y": 1669.0953578948975,\r
3539         "z": "f2af2445.16fe78",\r
3540         "wires": [\r
3541             [\r
3542                 "5d36ed1a.607764"\r
3543             ]\r
3544         ]\r
3545     },\r
3546     {\r
3547         "id": "751b1f96.b3bdc",\r
3548         "type": "outcomeFalse",\r
3549         "name": "false",\r
3550         "xml": "<outcome value='false'>\n",\r
3551         "comments": "",\r
3552         "outputs": 1,\r
3553         "x": 3220.79349899292,\r
3554         "y": 1717.4286937713623,\r
3555         "z": "f2af2445.16fe78",\r
3556         "wires": [\r
3557             [\r
3558                 "d68323fd.8707c"\r
3559             ]\r
3560         ]\r
3561     },\r
3562     {\r
3563         "id": "5d36ed1a.607764",\r
3564         "type": "set",\r
3565         "name": "set index-string to '0' + idx",\r
3566         "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '0' + $tmp.gun.idx`\" />\n",\r
3567         "comments": "",\r
3568         "x": 3413.4603271484375,\r
3569         "y": 1668.7620124816895,\r
3570         "z": "f2af2445.16fe78",\r
3571         "wires": []\r
3572     },\r
3573     {\r
3574         "id": "d68323fd.8707c",\r
3575         "type": "set",\r
3576         "name": "set index-string to idx",\r
3577         "xml": "<set>\n<parameter name='tmp.gun.index-string' value='`$tmp.gun.idx`' />\n",\r
3578         "comments": "",\r
3579         "x": 3397.4603118896484,\r
3580         "y": 1717.0953159332275,\r
3581         "z": "f2af2445.16fe78",\r
3582         "wires": []\r
3583     },\r
3584     {\r
3585         "id": "6f52ffca.5f968",\r
3586         "type": "set",\r
3587         "name": "set index-string to '000' + idx",\r
3588         "xml": "<set>\n<parameter name='tmp.gun.index-string' value=\"`'' + '000' + $tmp.gun.idx`\" />\n",\r
3589         "comments": "",\r
3590         "x": 2752.2221069335938,\r
3591         "y": 1535.142939567566,\r
3592         "z": "f2af2445.16fe78",\r
3593         "wires": []\r
3594     },\r
3595     {\r
3596         "id": "532853bc.fe84cc",\r
3597         "type": "switchNode",\r
3598         "name": "switch idx < 100",\r
3599         "xml": "<switch test='`$tmp.gun.idx &lt; 100`'>\n",\r
3600         "comments": "",\r
3601         "outputs": 1,\r
3602         "x": 2726.650703430176,\r
3603         "y": 1660.9049066816058,\r
3604         "z": "f2af2445.16fe78",\r
3605         "wires": [\r
3606             [\r
3607                 "26118820.193aa8",\r
3608                 "e9a76d39.5370a"\r
3609             ]\r
3610         ]\r
3611     },\r
3612     {\r
3613         "id": "26118820.193aa8",\r
3614         "type": "outcomeTrue",\r
3615         "name": "true",\r
3616         "xml": "<outcome value='true'>\n",\r
3617         "comments": "",\r
3618         "outputs": 1,\r
3619         "x": 2883.650680541992,\r
3620         "y": 1616.2382845197405,\r
3621         "z": "f2af2445.16fe78",\r
3622         "wires": [\r
3623             [\r
3624                 "1a8e79c7.61ce76"\r
3625             ]\r
3626         ]\r
3627     },\r
3628     {\r
3629         "id": "e9a76d39.5370a",\r
3630         "type": "outcomeFalse",\r
3631         "name": "false",\r
3632         "xml": "<outcome value='false'>\n",\r
3633         "comments": "",\r
3634         "outputs": 1,\r
3635         "x": 2883.6506385803223,\r
3636         "y": 1696.5716203962054,\r
3637         "z": "f2af2445.16fe78",\r
3638         "wires": [\r
3639             [\r
3640                 "1afc6185.a5540e"\r
3641             ]\r
3642         ]\r
3643     },\r
3644     {\r
3645         "id": "909034be.bcdcb8",\r
3646         "type": "comment",\r
3647         "name": "Change History",\r
3648         "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",\r
3649         "comments": "",\r
3650         "x": 463.65077209472656,\r
3651         "y": 401.4285840988159,\r
3652         "z": "f2af2445.16fe78",\r
3653         "wires": []\r
3654     },\r
3655     {\r
3656         "id": "895c17e1.4d8998",\r
3657         "type": "comment",\r
3658         "name": "iTrack 10767",\r
3659         "info": "",\r
3660         "comments": "",\r
3661         "x": 1766.507999420166,\r
3662         "y": 3105.714337348938,\r
3663         "z": "f2af2445.16fe78",\r
3664         "wires": []\r
3665     },\r
3666     {\r
3667         "id": "a16f0f71.a4d2c",\r
3668         "type": "set",\r
3669         "name": "set tmp.gun.transient",\r
3670         "xml": "<set>\n<parameter name='tmp.gun.transient' value='TRANSIENT' />\n",\r
3671         "comments": "",\r
3672         "x": 1112.2221374511719,\r
3673         "y": 2779.999990940094,\r
3674         "z": "f2af2445.16fe78",\r
3675         "wires": []\r
3676     },\r
3677     {\r
3678         "id": "9f71976e.e5c5f8",\r
3679         "type": "service-logic",\r
3680         "name": "GENERIC-RESOURCE-API ${project.version}",\r
3681         "module": "GENERIC-RESOURCE-API",\r
3682         "version": "${project.version}",\r
3683         "comments": "",\r
3684         "xml": "<service-logic xmlns='http://www.onap.org/sdnc/svclogic' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.onap.org/sdnc/svclogic ./svclogic.xsd' module='GENERIC-RESOURCE-API' version='${project.version}'>",\r
3685         "outputs": 1,\r
3686         "x": 720.8888549804688,\r
3687         "y": 26.66666889190674,\r
3688         "z": "f2af2445.16fe78",\r
3689         "wires": [\r
3690             [\r
3691                 "4eedc095.04b8b"\r
3692             ]\r
3693         ]\r
3694     }\r
3695 ]