Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
titleOrchestration 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


MariaDB [catalogdb]> select * from orchestration_flow_reference where FLOW_NAME like '%Config%';

MariaDB [catalogdb]> update orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', scope='vnf', action='config-assign' where id in (1465);

MariaDB [catalogdb]> update orchestration_flow_reference set FLOW_NAME='ControllerExecutionBB', scope='vnf', action='config-deploy' where id in (1495);


MariaDB [catalogdb]> select * from orchestration_flow_reference where COMPOSITE_ACTION='Service-Macro-Create' order by seq_no;
+------+----------------------+--------+-----------------------------+--------------+----------------------+-------+---------------+
| id   | COMPOSITE_ACTION     | SEQ_NO | FLOW_NAME                   | FLOW_VERSION | NB_REQ_REF_LOOKUP_ID | SCOPE | ACTION        |
+------+----------------------+--------+-----------------------------+--------------+----------------------+-------+---------------+
| 1447 | Service-Macro-Create |      1 | AssignServiceInstanceBB     |            1 |                  262 | NULL  | NULL          |
| 1450 | Service-Macro-Create |      2 | CreateNetworkCollectionBB   |            1 |                  262 | NULL  | NULL          |
| 1453 | Service-Macro-Create |      3 | AssignNetworkBB             |            1 |                  262 | NULL  | NULL          |
| 1456 | Service-Macro-Create |      4 | AssignVnfBB                 |            1 |                  262 | NULL  | NULL          |
| 1459 | Service-Macro-Create |      5 | AssignVolumeGroupBB         |            1 |                  262 | NULL  | NULL          |
| 1462 | Service-Macro-Create |      6 | AssignVfModuleBB            |            1 |                  262 | NULL  | NULL          |
| 1465 | Service-Macro-Create |      7 | ControllerExecutionBB       |            1 |                  262 | vnf   | config-assign |
| 1468 | Service-Macro-Create |      8 | AssignPnfBB                 |            1 |                  262 | NULL  | NULL          |
| 1471 | Service-Macro-Create |      9 | WaitForPnfReadyBB           |            1 |                  262 | NULL  | NULL          |
| 1474 | Service-Macro-Create |     10 | ActivatePnfBB               |            1 |                  262 | NULL  | NULL          |
| 1477 | Service-Macro-Create |     11 | CreateNetworkBB             |            1 |                  262 | NULL  | NULL          |
| 1480 | Service-Macro-Create |     12 | ActivateNetworkBB           |            1 |                  262 | NULL  | NULL          |
| 1483 | Service-Macro-Create |     15 | CreateVolumeGroupBB         |            1 |                  262 | NULL  | NULL          |
| 1486 | Service-Macro-Create |     16 | ActivateVolumeGroupBB       |            1 |                  262 | NULL  | NULL          |
| 1489 | Service-Macro-Create |     17 | CreateVfModuleBB            |            1 |                  262 | NULL  | NULL          |
| 1492 | Service-Macro-Create |     18 | ActivateVfModuleBB          |            1 |                  262 | NULL  | NULL          |
| 1495 | Service-Macro-Create |     19 | ControllerExecutionBB       |            1 |                  262 | vnf   | config-deploy |
| 1498 | Service-Macro-Create |     20 | ActivateVnfBB               |            1 |                  262 | NULL  | NULL          |
| 1501 | Service-Macro-Create |     21 | ActivateNetworkCollectionBB |            1 |                  262 | NULL  | NULL          |
| 1504 | Service-Macro-Create |     22 | ActivateServiceInstanceBB   |            1 |                  262 | NULL  | NULL          |
+------+----------------------+--------+-----------------------------+--------------+----------------------+-------+---------------+
20 rows in set (0.00 sec)

MariaDB [catalogdb]>

...