1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
|
USE catalogdb;
ALTER TABLE collection_resource_customization
ADD FOREIGN KEY ( CR_MODEL_UUID)
REFERENCES collection_resource(MODEL_UUID)
ON DELETE CASCADE;
ALTER TABLE vnf_resource_customization
ADD COLUMN
INSTANCE_GROUP_MODEL_UUID varchar(200);
ALTER TABLE instance_group
ADD FOREIGN KEY ( CR_MODEL_UUID)
REFERENCES collection_resource(MODEL_UUID)
ON DELETE CASCADE;
ALTER TABLE collection_resource_customization_to_service
ADD FOREIGN KEY (service_model_uuid)
REFERENCES service(MODEL_UUID)
ON DELETE CASCADE;
ALTER TABLE allotted_resource_customization_to_service
ADD FOREIGN KEY (service_model_uuid)
REFERENCES service(MODEL_UUID)
ON DELETE CASCADE;
ALTER TABLE vnf_resource_customization_to_service
ADD FOREIGN KEY (service_model_uuid)
REFERENCES service(MODEL_UUID)
ON DELETE CASCADE;
ALTER TABLE network_resource_customization_to_service
ADD FOREIGN KEY (service_model_uuid)
REFERENCES service(MODEL_UUID)
ON DELETE CASCADE;
ALTER TABLE network_resource_customization_to_service
ADD FOREIGN KEY (resource_model_customization_uuid)
REFERENCES network_resource_customization(model_customization_uuid)
ON DELETE CASCADE;
ALTER TABLE vnf_resource_customization_to_service
ADD FOREIGN KEY (resource_model_customization_uuid)
REFERENCES vnf_resource_customization(model_customization_uuid)
ON DELETE CASCADE;
ALTER TABLE allotted_resource_customization_to_service
ADD FOREIGN KEY (resource_model_customization_uuid)
REFERENCES allotted_resource_customization(model_customization_uuid)
ON DELETE CASCADE;
ALTER TABLE collection_resource_customization_to_service
ADD FOREIGN KEY (resource_model_customization_uuid)
REFERENCES collection_resource_customization(model_customization_uuid)
ON DELETE CASCADE;
INSERT INTO network_resource_customization_to_service SELECT service_model_uuid,resource_model_customization_uuid
FROM service_to_resource_customizations WHERE model_type = 'network' and service_model_uuid in(select model_uuid from service)
AND resource_model_customization_uuid in ( SELECT MODEL_CUSTOMIZATION_UUID from network_resource_customization);
INSERT INTO allotted_resource_customization_to_service SELECT service_model_uuid,resource_model_customization_uuid
FROM service_to_resource_customizations WHERE model_type = 'allottedResource' and service_model_uuid in(select model_uuid from service)
AND resource_model_customization_uuid in ( SELECT MODEL_CUSTOMIZATION_UUID from allotted_resource_customization);
INSERT INTO vnf_resource_customization_to_service SELECT service_model_uuid,resource_model_customization_uuid
FROM service_to_resource_customizations WHERE model_type = 'vnf' and service_model_uuid in(select model_uuid from service)
AND resource_model_customization_uuid in ( SELECT MODEL_CUSTOMIZATION_UUID from vnf_resource_customization);
DROP TABLE service_to_resource_customizations;
INSERT INTO vnf_recipe (VNF_TYPE, ACTION, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
VALUES
('GR-API-DEFAULT', 'createInstance', '1', 'Gr api recipe to create vnf', '/mso/async/services/WorkflowActionBB', 180),
('GR-API-DEFAULT', 'deleteInstance', '1', 'Gr api recipe to delete vnf', '/mso/async/services/WorkflowActionBB', 180),
('GR-API-DEFAULT', 'updateInstance', '1', 'Gr api recipe to update vnf', '/mso/async/services/WorkflowActionBB', 180),
('GR-API-DEFAULT', 'replaceInstance', '1', 'Gr api recipe to replace vnf', '/mso/async/services/WorkflowActionBB', 180),
('GR-API-DEFAULT', 'inPlaceSoftwareUpdate', '1', 'Gr api recipe to do an in place software update', '/mso/async/services/WorkflowActionBB', 180),
('GR-API-DEFAULT', 'applyUpdatedConfig', '1', 'Gr api recipe to apply updated config', '/mso/async/services/WorkflowActionBB', 180);
UPDATE vnf_recipe
SET vnf_type = 'VNF-API-DEFAULT'
WHERE vnf_type = 'VID_DEFAULT';
UPDATE vnf_recipe
SET description = 'Vnf api recipe to create vnf'
WHERE description = 'VID_DEFAULT recipe to create VNF if no custom BPMN flow is found';
UPDATE vnf_recipe
SET description = 'Vnf api recipe to delete vnf'
WHERE description = 'VID_DEFAULT recipe to delete VNF if no custom BPMN flow is found';
UPDATE vnf_recipe
SET description = 'Vnf api recipe to update vnf'
WHERE description = 'VID_DEFAULT update';
UPDATE vnf_recipe
SET description = 'Vnf api recipe to replace vnf'
WHERE description = 'VID_DEFAULT replace';
UPDATE vnf_recipe
SET description = 'Vnf api recipe to do an in place software update'
WHERE description = 'VID_DEFAULT inPlaceSoftwareUpdate';
UPDATE vnf_recipe
SET description = 'Vnf api recipe to apply updated config'
WHERE description = 'VID_DEFAULT applyUpdatedConfig';
INSERT INTO service (MODEL_UUID, MODEL_NAME, MODEL_INVARIANT_UUID, MODEL_VERSION, DESCRIPTION)
VALUES
('DummyGRApiDefaultModelUUID?', 'GR-API-DEFAULT', 'DummyGRApiDefaultModelInvariantUUID?', '1.0', 'Gr api service for VID to use for infra APIH orchestration');
UPDATE service
SET model_name = 'VNF-API-DEFAULT',
description = 'Vnf api service for VID to use for infra APIH orchestration'
WHERE model_name = 'VID_DEFAULT';
INSERT INTO service_recipe (ACTION, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT, SERVICE_MODEL_UUID)
VALUES
('activateInstance', '1.0', 'Gr api recipe to activate service-instance', '/mso/async/services/WorkflowActionBB', 180, 'DummyGRApiDefaultModelUUID?'),
('createInstance', '1.0', 'Gr api recipe to create service-instance', '/mso/async/services/WorkflowActionBB', 180, 'DummyGRApiDefaultModelUUID?'),
('deactivateInstance', '1.0', 'Gr api recipe to deactivate service-instance', '/mso/async/services/WorkflowActionBB', 180, 'DummyGRApiDefaultModelUUID?'),
('deleteInstance', '1.0', 'Gr api recipe to delete service-instance', '/mso/async/services/WorkflowActionBB', 180, 'DummyGRApiDefaultModelUUID?');
UPDATE service_recipe
SET description = 'Vnf api recipe to activate service-instance'
WHERE description = 'VID_DEFAULT activate';
UPDATE service_recipe
SET description = 'Vnf api recipe to create service-instance'
WHERE description = 'VID_DEFAULT recipe to create service-instance if no custom BPMN flow is found';
UPDATE service_recipe
SET description = 'Vnf api recipe to deactivate service-instance'
WHERE description = 'VID_DEFAULT deactivate';
UPDATE service_recipe
SET description = 'Vnf api recipe to delete service-instance'
WHERE description = 'VID_DEFAULT recipe to delete service-instance if no custom BPMN flow is found';
INSERT INTO vnf_components_recipe (VNF_COMPONENT_TYPE, ACTION, VERSION, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT, VF_MODULE_MODEL_UUID)
VALUES
('volumeGroup', 'createInstance', '1', 'Gr api recipe to create volume-group', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT'),
('volumeGroup', 'deleteInstance', '1', 'Gr api recipe to delete volume-group', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT'),
('volumeGroup', 'updateInstance', '1', 'Gr api recipe to update volume-group', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT'),
('vfModule', 'createInstance', '1', 'Gr api recipe to create vf-module', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT'),
('vfModule', 'deleteInstance', '1', 'Gr api recipe to delete vf-module', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT'),
('vfModule', 'updateInstance', '1', 'Gr api recipe to update vf-module', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT'),
('vfModule', 'replaceInstance', '1', 'Gr api recipe to replace vf-module', '/mso/async/services/WorkflowActionBB', 180, 'GR-API-DEFAULT');
UPDATE vnf_components_recipe
SET vf_module_model_uuid = 'VNF-API-DEFAULT'
WHERE vf_module_model_uuid = 'VID_DEFAULT';
UPDATE vnf_components_recipe
SET description = 'Vnf api recipe to create volume-group'
WHERE description = 'VID_DEFAULT recipe to create volume-group if no custom BPMN flow is found';
UPDATE vnf_components_recipe
SET description = 'Vnf api recipe to delete volume-group'
WHERE description = 'VID_DEFAULT recipe to delete volume-group if no custom BPMN flow is found';
UPDATE vnf_components_recipe
SET description = 'Vnf api recipe to update volume-group'
WHERE description = 'VID_DEFAULT recipe to update volume-group if no custom BPMN flow is found';
UPDATE vnf_components_recipe
SET description = 'Vnf api recipe to create vf-module'
WHERE description = 'VID_DEFAULT recipe to create vf-module if no custom BPMN flow is found';
UPDATE vnf_components_recipe
SET description = 'Vnf api recipe to delete vf-module'
WHERE description = 'VID_DEFAULT recipe to delete vf-module if no custom BPMN flow is found';
UPDATE vnf_components_recipe
SET description = 'Vnf api recipe to update vf-module'
WHERE description = 'VID_DEFAULT recipe to update vf-module if no custom BPMN flow is found';
UPDATE vnf_components_recipe
SET description = 'Vnf api recipe to replace vf-module'
WHERE description = 'VID_DEFAULT vfModule replace';
INSERT INTO network_recipe (MODEL_NAME, ACTION, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT, VERSION_STR)
VALUES
('GR-API-DEFAULT', 'createInstance', 'Gr api recipe to create network', '/mso/async/services/WorkflowActionBB', 180, '1.0'),
('GR-API-DEFAULT', 'updateInstance', 'Gr api recipe to update network', '/mso/async/services/WorkflowActionBB', 180, '1.0'),
('GR-API-DEFAULT', 'deleteInstance', 'Gr api recipe to delete network', '/mso/async/services/WorkflowActionBB', 180, '1.0');
UPDATE network_recipe
SET model_name = 'VNF-API-DEFAULT'
WHERE model_name = 'VID_DEFAULT';
UPDATE network_recipe
SET description = 'Vnf api recipe to create network'
WHERE description = 'VID_DEFAULT recipe to create network if no custom BPMN flow is found';
UPDATE network_recipe
SET description = 'Vnf api recipe to update network'
WHERE description = 'VID_DEFAULT recipe to update network if no custom BPMN flow is found';
UPDATE network_recipe
SET description = 'Vnf api recipe to delete network'
WHERE description = 'VID_DEFAULT recipe to delete network if no custom BPMN flow is found';
|
