Page History

...

Code Block

title	Orchestration Flow Reference Table Updates

from rancher

root@sb00-nfs:~# kubectl -n onap exec -it dev-mariadb-galera-0 bash

bash-4.2$ mysql -uroot -pTepsMavaFota9+
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 172842
Server version: 10.1.24-MariaDB MariaDB Server

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use catalogdb
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

select * from orchestration_flow_reference where COMPOSITE_ACTION='VFModule-Delete' order by seq_no;

insert into orchestration_flow_reference (id, COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) value ("1164", "VFModule-Delete", "1", "ControllerExecutionBB", "1", "135", "vnf", "HealthCheck");

insert into orchestration_flow_reference (id, COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) value ("1165", "VFModule-Delete", "2", "ControllerExecutionBB", "1", "135", "vfmodule", "ScaleInReconfiguration");


insert into orchestration_flow_reference (id, COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID, SCOPE, ACTION) value ("1174", "VFModule-Delete", "6", "ControllerExecutionBB", "1", "135", "vnf", "HealthCheck");



MariaDB [catalogdb]> select * from orchestration_flow_reference where COMPOSITE_ACTION='VFModule-Delete' order by id;
+------+------------------+--------+-----------------------+--------------+----------------------+----------+------------------------+
| id   | COMPOSITE_ACTION | SEQ_NO | FLOW_NAME             | FLOW_VERSION | NB_REQ_REF_LOOKUP_ID | SCOPE    | ACTION                 |
+------+------------------+--------+-----------------------+--------------+----------------------+----------+------------------------+
| 1164 | VFModule-Delete  |      1 | ControllerExecutionBB |            1 |                  212 | vnf      | HealthCheck            |
| 1165 | VFModule-Delete  |      2 | ControllerExecutionBB |            1 |                  212 | vfmodule | ScaleInReconfiguration |
| 1166 | VFModule-Delete  |      3 | DeactivateVfModuleBB  |            1 |                  212 | NULL     | NULL                   |
| 1169 | VFModule-Delete  |      4 | DeleteVfModuleBB      |            1 |                  212 | NULL     | NULL                   |
| 1172 | VFModule-Delete  |      5 | UnassignVfModuleBB    |            1 |                  212 | NULL     | NULL                   |
| 1174 | VFModule-Delete  |      6 | ControllerExecutionBB |            1 |                  212 | vnf      | HealthCheck            |
+------+------------------+--------+-----------------------+--------------+----------------------+----------+------------------------+
6 rows in set (0.00 sec)

MariaDB [catalogdb]>

CDS Bootstrap command for preloading the CDS Catalog Data for Data Dictionary, Node Types, and CBA:

Step 1:

Edit the blueprint processor HTTP service and change the ClusterIP to NodePort. This shall expose an http external node port need to execute the curl command in step 2.

Step 2:

Execute the Curl Command to preload the CDS Catalog Data for Data Dictionary, Node Types and CBA. Substitute k8s and cds_http_port with the right information.

Code Block

language	js
title	CDS CBA & DD Bootstrap

curl --location --request POST 'http://{{k8s}}:{{cds_http_port}}/api/v1/blueprint-model/bootstrap' \
--header 'Content-Type: application/json' \
--header 'Authorization: Basic Y2NzZGthcHBzOmNjc2RrYXBwcw==' \
--data-raw '{
"loadModelType" : true,
"loadResourceDictionary" : true,
"loadCBA" : true
}'

Space shortcuts

Page tree

Versions Compared

Old Version 13

New Version Current

Key

CDS Bootstrap command for preloading the CDS Catalog Data for Data Dictionary, Node Types, and CBA:

Step 1:

Edit the blueprint processor HTTP service and change the ClusterIP to NodePort. This shall expose an http external node port need to execute the curl command in step 2.

Step 2:

Execute the Curl Command to preload the CDS Catalog Data for Data Dictionary, Node Types and CBA. Substitute k8s and cds_http_port with the right information.