summaryrefslogtreecommitdiffstats
path: root/packages/base/src/files/install/mysql/data
diff options
context:
space:
mode:
authorMichael Mokry <mm117s@att.com>2018-09-12 10:32:42 -0500
committerMichael Mokry <mm117s@att.com>2018-09-12 10:32:42 -0500
commit786e6c02b0a95a8553cdea67861a3669ccb0c42e (patch)
treef369dcad637e10969d432457b52bd3521cd10c2d /packages/base/src/files/install/mysql/data
parenta290a5fedd395f075135949a7f5313ee1abffc89 (diff)
Added SQL to import SDNC naming model
Modified the script to inlcude an insert statement to add the SDNCGenerate Naming model to the microservicemodels table during installation This will need to be merged before I add the CSIT test to Integration Change-Id: I1620ce3f1097d45111bddb08c12b5b8c12bb1b2e Issue-ID: POLICY-983 Signed-off-by: Michael Mokry <mm117s@att.com>
Diffstat (limited to 'packages/base/src/files/install/mysql/data')
-rw-r--r--packages/base/src/files/install/mysql/data/181002_upgrade_script.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/packages/base/src/files/install/mysql/data/181002_upgrade_script.sql b/packages/base/src/files/install/mysql/data/181002_upgrade_script.sql
index 022a31132..854297dc1 100644
--- a/packages/base/src/files/install/mysql/data/181002_upgrade_script.sql
+++ b/packages/base/src/files/install/mysql/data/181002_upgrade_script.sql
@@ -69,4 +69,7 @@ update fn_function set type = 'menu' , action = '*' where function_cd = 'view_re
update fn_function set type = 'url' , action = '*' where function_cd = 'login';
update fn_function set type = 'url' , action = '*' where function_cd = 'quantum_bd';
+INSERT INTO `onap_sdk`.`microservicemodels` (`modelname`, `description`, `dependency`, `imported_by`, `attributes`, `ref_attributes`, `sub_attributes`, `version`, `enumValues`, `dataOrderInfo`, `annotation`)
+VALUES ('SDNC_GenerateName', 'SRIOV 1806 Model', '[]', 'demo', 'policy-instance-name=string:defaultValue-null:required-null:MANY-false:description-null', 'naming-models=naming-model-entity:MANY-true:description-null,', '{"naming-property":{"property-value":"string:defaultValue-null:required-false:MANY-false:description-null","property-operation":"string:defaultValue-null:required-false:MANY-false:description-null","source-endpoint":"string:defaultValue-null:required-false:MANY-false:description-null","property-name":"string:defaultValue-null:required-true:MANY-false:description-null","increment-sequence":"increment-sequence:required-false:MANY-false:description-null","source-system":"string:defaultValue-null:required-false:MANY-false:description-null"},"increment-sequence":{"max":"string:defaultValue-null:required-false:MANY-false:description-null","scope":"SCOPE:defaultValue-null:required-true:MANY-false:description-null","start-value":"string:defaultValue-null:required-true:MANY-false:description-null","length":"integer:defaultValue-null:required-true:MANY-false:description-null","increment":"string:defaultValue-null:required-true:MANY-false:description-null","sequence-type":"string:defaultValue-null:required-false:MANY-false:description-null"},"naming-model-entity":{"naming-properties":"naming-property:required-true:MANY-true:description-null","name-operation":"string:defaultValue-null:required-false:MANY-false:description-null","naming-type":"string:defaultValue-null:required-true:MANY-false:description-null","nfRole":"string:defaultValue-null:required-false:MANY-false:description-null","naming-recipe":"String:defaultValue-null:required-true:MANY-false:description-null"}}', 'CSIT', 'SCOPE=[CLOUD_REGION_ID,LOCATION_CLLI,VNF,VM,VFMODULE,PRECEEDING,TRAILING,ENTIRETY,]', '\"[policy-instance-name,naming-models,nfRole,naming-type,naming-recipe,name-operation,naming-properties,property-name,property-value,property-operation,source-system,source-endpoint,increment-sequence,scope,sequence-type,start-value,max,increment,length]\"','naming-type=matching-true, nfRole=matching-true, property-name=matching-true');
+
commit; \ No newline at end of file