</return></outcome></switch><set>\r
<parameter name='tmp.gun.sql' value="`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\r
+ ' AND name = $generate-unique-name-input.supplied-name'`" />\r
-</set><get-resource plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'\r
+</set><get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\r
key="`$tmp.gun.sql`" pfx='tmp.gun.namedb'>\r
\r
<outcome value='failure'>\r
<parameter name='tmp.gun.sql' value="`'insert into GENERIC_RESOURCE_NAME values ( '\r
+ ' $generate-unique-name-input.name-table-type , $generate-unique-name-input.supplied-name )'`" />\r
\r
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'\r
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\r
key="`$tmp.gun.sql`" pfx='pfx'>\r
<outcome value='failure'>\r
<return status='failure'>\r
<parameter name='tmp.gun.sql' value="`'SELECT * from ' + $generate-unique-name-input.index-table-name\r
+ ' WHERE ' + $generate-unique-name-input.index-table-prefix-column + ' = '\r
+ '$generate-unique-name-input.prefix'`" />\r
-</set><get-resource plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'\r
+</set><get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\r
key="`$tmp.gun.sql`" pfx='tmp.gun.prefixdb'>\r
\r
<outcome value='success'>\r
</set><set>\r
<parameter name='tmp.gun.sql' value="`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\r
+ ' AND name = $tmp.gun.generated-name'`" />\r
-</set><get-resource plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'\r
+</set><get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\r
key="`$tmp.gun.sql`" pfx='tmp.gun.namedb'>\r
\r
<outcome value='failure'>\r
+ ' set index_number = ' + $tmp.gun.index-string + ' where '\r
+ $generate-unique-name-input.index-table-prefix-column\r
+ ' = $generate-unique-name-input.prefix'`" />\r
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'\r
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\r
key="`$tmp.gun.sql`" pfx='pfx'>\r
<outcome value='failure'>\r
<return status='failure'>\r
+ '(' + $generate-unique-name-input.index-table-prefix-column + ', index_number) values ('\r
+ ' $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ')'`" />\r
\r
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'\r
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\r
key="`$tmp.gun.sql`" pfx='pfx'>\r
<outcome value='failure'>\r
<return status='failure'>\r
<parameter name='tmp.gun.sql' value="`'insert into GENERIC_RESOURCE_NAME values ( '\r
+ ' $generate-unique-name-input.name-table-type , $tmp.gun.generated-name )'`" />\r
\r
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'\r
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\r
key="`$tmp.gun.sql`" pfx='pfx'>\r
<outcome value='failure'>\r
<return status='failure'>\r
</set><set>\r
<parameter name='tmp.gun.sql' value="`'SELECT * from GENERIC_RESOURCE_NAME WHERE type = $generate-unique-name-input.name-table-type'\r
+ ' AND name = $tmp.gun.generated-name'`" />\r
-</set><get-resource plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'\r
+</set><get-resource plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\r
key="`$tmp.gun.sql`" pfx='tmp.gun.namedb'>\r
\r
<outcome value='failure'>\r
+ ' set index_number = ' + $tmp.gun.index-string + ' where '\r
+ $generate-unique-name-input.index-table-prefix-column\r
+ ' = $generate-unique-name-input.prefix'`" />\r
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'\r
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\r
key="`$tmp.gun.sql`" pfx='pfx'>\r
<outcome value='failure'>\r
<return status='failure'>\r
+ '(' + $generate-unique-name-input.index-table-prefix-column + ', index_number) values ('\r
+ ' $generate-unique-name-input.prefix , ' + $tmp.gun.index-string + ')'`" />\r
\r
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'\r
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\r
key="`$tmp.gun.sql`" pfx='pfx'>\r
<outcome value='failure'>\r
<return status='failure'>\r
<parameter name='tmp.gun.sql' value="`'insert into GENERIC_RESOURCE_NAME values ( '\r
+ ' $generate-unique-name-input.name-table-type , $tmp.gun.generated-name )'`" />\r
\r
-</set><save plugin='org.onap.ccsdk.sli.adaptors.sli.resource.sql.SqlResource' resource='SQL'\r
+</set><save plugin='org.onap.ccsdk.sli.adaptors.resource.sql.SqlResource' resource='SQL'\r
key="`$tmp.gun.sql`" pfx='pfx'>\r
<outcome value='failure'>\r
<return status='failure'>\r