aboutsummaryrefslogtreecommitdiffstats
path: root/adapters/mso-catalog-db-adapter/src/main/resources/db
AgeCommit message (Collapse)AuthorFilesLines
2022-10-27Adding CNF Upgrade Code Enhancementssanket123451-1/+2
-Code Enhanced for CNF- Upgrade. -Code changes Deactivate older version of VfModule & VNFs while upgradation by giving older version inputs to SDNC. -Enabled onap-model-info true for Deactivate, which can be now seen in logs while Deactivation of VfModule/VNF. -New changes enable to fetch data from UserParams instead of RelatedInstanceList, which will further simplify the payload. Issue-ID: SO-3857 Change-Id: I99f71f025d813b413f82f1a802bab8867d0a9cbb Signed-off-by: sanket12345 <SX00562924@techmahindra.com> (cherry picked from commit 878a6668ed9031e61c672d5554573fb13ae05cde)
2022-10-03Merge "Code & Workflow Enhancements for CNF - Upgrade"Lukasz Rajewski1-9/+11
2022-10-03Rollback Scenario for recursive orchestrationsreeja gattagouni1-1/+2
-Child Services may fail in any of the BB's while creation of composite services, to handle in efficient manner, it is complied with existing rollback logic. -In case of Child Services >1 , when Workflow fails, the instantiated child remains in COMPLETED status, thus rollback changes ensure that such services are Deleted by triggering DeleteChildSvcBB. -Parent Service is ROLLED-BACK in case of any child service failing in the workflow. Instantiated child services are Deleted from AAI as well. Issue-ID: SO-3982 Change-ID:I73f97f986a817d423f92f8d922dcd9647b8a2503 Signed-off-by: sreeja gattagouni <sg00744975@techmahindra.com>
2022-10-03Code & Workflow Enhancements for CNF - Upgradesanket123451-9/+11
- Adding New Building Block : VfModuleUpgradeBB, which delgates Workflow to next BB by just changing AAI Orch_status, else WF fails during Orchestration flow validation DB lookup. - Adding changes to BB Inputs to take new version VNF & VFM model details and pass to BBs, as done for Service-Macro-Upgrade. - Adding new operations in CDS to skip execution,when SDC Model has skipCDS=True. - Calling CNF Adapter with existing heatStackID & passing it for CNF-Upgrade with new customization details. Issue-ID: SO-3857 Change-Id: I69f71f825b812d423f82f1a902dcb8567d8a6adb Signed-off-by: sanket12345 <SX00562924@techmahindra.com>
2022-08-05Merge branch 'recursive-orch'Lukasz Rajewski1-37/+43
Issue-ID: SO-3980 Signed-off-by: Lukasz Rajewski <lukasz.rajewski@t-mobile.pl> Change-Id: Ie0cd0f973800196d5cb1e038db4a49208a6c4a3b
2022-05-30Enable DeleteChildService functionalitymamed.mamedov1-16/+18
Issue-ID: SO-3830 Change-Id: I5cf8b1a998839813fd59576eb70eb79c72f2c2fe Signed-off-by: mamed.mamedov <mamed.mamedov@telekom.com>
2022-05-09Switch over BBRollback to use DB lookups.Oleg Mitsura1-0/+25
Issue-ID: SO-3793 Use feature provided by SO-3720. Signed-off-by: Oleg Mitsura <oleg.mitsura@amdocs.com> Change-Id: I31f2c00df738c37d04e5ad901dd94c9c6d4b147e
2022-04-20VNF-Payload support for CNF HealthChecksreeja gattagouni1-0/+1
-CNF HealthCheck feature currently supports for Create-Service-Instance Payload. -Addition of requestAction in catalogDB in vnf_recipe will now support for VNF- Payload format while triggering requests for CNF HealthCheck. Issue-ID: SO-3927 Change-Id:I99b33f225a132d943f42f0d808bcd4510d9c8adf Signed-off-by: sreeja gattagouni <sg00744975@techmahindra.com>
2022-03-02CNF- Upgrade Functionality - CatalogDBsanket123452-4/+20
-Catalog DB Changes with new macro action. Issue-ID: SO-3859 Change-Id: I99f33f225d114d713f42f0a900aeb6532d7c6afe Signed-off-by: sanket12345 <SX00562924@techmahindra.com>
2022-02-03Hard-coded cloud owner in mariadb-galera for VNF-Macro-Modify actionMD IRSHAD SHEIKH1-3/+3
Issue-ID: SO-3836 Signed-off-by: MD IRSHAD SHEIKH <md.irshad.sheikh@huawei.com> Change-Id: I07dc6c8073197aae2aac5ff3ea3429563b3cbb38
2022-01-20CNF Healthcheck Workflow broken after macro sql file refactoringsanket123451-2/+6
Re-added Macro DB Entries in below tables - orchestration_flow_reference - building_block_detail Issue-ID: SO-3834 Signed-off-by: sanket12345 <SX00562924@techmahindra.com> Change-Id: I33f12f156c122d723f52f0a855adb9430b7c6ade
2021-11-26Enable CreateChildServiceBB for Service-Macro-CreateJozsef Csongvai1-22/+26
Issue-ID: SO-3811 Signed-off-by: Jozsef Csongvai <jozsef.csongvai@bell.ca> Change-Id: I7979082a9f145a84f6f03cf2c44e9ccbca198c5a
2021-10-06Merge "Clean R_MacroData.sql file"Seshu Kumar M1-505/+346
2021-10-04Clean R_MacroData.sql fileSebastien Premont-Tendland1-505/+346
Updated file to only have one INSERT statement for each macro table instead of multiple INSERT/UPDATE statements across the file making it difficult to work with. Change-Id: I6ff934befbd4f54e6338388cdb3e11b2a8b8de63 Issue-ID: SO-3706 Signed-off-by: Sebastien Premont-Tendland <sebastien.premont@bell.ca>
2021-08-26SO-3720 BuildingBlockRollback lookup tableOleg Mitsura1-0/+10
Issue-ID: SO-3720 BuildingBlockRollback lookup table will indicate the rollback BB to take; this is the first part for simplifying WorkflowActionBBTasks logic: instead of doing string matching, we just do a lookup of a block to call to perform the rollback operation. In some cases, the Action is set as well - this would be needed for certain BBs, in that case, there is a corresponding rollbackAction as well. Change-Id: I072a2ada894cf4672f5a1cdce762605757cb1d14 Signed-off-by: Oleg Mitsura <oleg.mitsura@amdocs.com>
2021-08-25Expose HealthCheck Northbound API of SOsanket123452-1/+20
Code changes in CNFO to Create Workflow and Expose if over Northbound API of SO Issue-ID: SO-3716 Signed-off-by: sanket12345 <SX00562924@techmahindra.com> Change-Id: I88f55f115c112d613f42f0b800aeb5491d7c6ace
2021-08-13Merge "SO changes for Service Intent"Seshu Kumar M1-0/+8
2021-08-11SO changes for Service Intenthyu20101-0/+8
This update contains the SO changes for the CCVPN extension to support Intent Based Networking (REQ-719). The SO is responsible for providing the Service Intent orchestration, as well as providing the Service Intent APIs which are consumed by the IBN use-case. The changes on the SO are technology-agnostic and are relatively simple. i.e., Technology specific network configurations are carried out by the SDNC. Issue-ID: SO-3714 Signed-off-by: hyu2010 <hyu2010b@gmail.com> Change-Id: Iec9d2fc80adc79faaeeaf811bd0d02c9d7611d61 Signed-off-by: hyu2010 <hyu2010b@gmail.com>
2021-08-04Add new endpoint and macro for service upgradeJozsef Csongvai1-0/+8
This enables upgrading an existing service instance by updating its model UUID's in AAI and md-sal. Issue-ID: SO-3636 Signed-off-by: Jozsef Csongvai <jozsef.csongvai@bell.ca> Change-Id: Ic5f067a1267053a61f46e2d9563ca4e4ac869bdf
2021-06-25Fixing gating catalogdb pod failurewaqas.ikram1-6/+6
Change-Id: I128b802e46532a30490c46afd1a6546783c92193 Issue-ID: SO-3688 Signed-off-by: waqas.ikram <waqas.ikram@est.tech>
2021-06-18Add VNF-Macro-Create and VNF-Macro-DeleteJozsef Csongvai1-0/+35
These macros enable creation and deletion of a vnf with vfmodules for an existing service instance using building blocks. Also: - No longer force alaCarte=true for these use cases - Fix broken vfModule sorting logic for baseFirst/baseLast - Minor refactoring replacing String literals with constants Issue-ID: SO-3635 Signed-off-by: Jozsef Csongvai <jozsef.csongvai@bell.ca> Change-Id: I16975f3561f2d978dede20679927ac3531def900
2021-05-05Fix typo DESACTIVATE to DEACTIVATESebastien Premont-Tendland1-3/+3
Issue-ID: SO-2798 Signed-off-by: Sebastien Premont-Tendland <sebastien.premont@bell.ca> Change-Id: I6b6334704fc4e7398ed785a99459a67c48def928
2021-01-28force not null with default valuesBenjamin, Max (mb388a)1-0/+25
force not null with default values update JUnit test setting default value update NULL fields before altering column sync beans with flyway changes updating test schema.sql files Issue-ID: SO-3494 Signed-off-by: Benjamin, Max (mb388a) <mb388a@att.com> Change-Id: I53f000531cfb653a20bfdfae274622553420cdc8
2021-01-06Fix for globalSubscriberId and requestIdtragait1-2/+4
Issue-ID: SO-3401 Signed-off-by: tragait <rahul.tyagi@est.tech> Change-Id: I33a71dffe7c63a50c807aa206d638a6aea5f1210
2020-12-30Added new column to the identity service.Benjamin, Max (mb388a)1-0/+3
Added new column to the identity service. Issue-ID: SO-3448 Signed-off-by: Benjamin, Max (mb388a) <mb388a@att.com> Change-Id: I5151016d1b4874cb77eecddc17169c04f59dc9a5
2020-12-08software-version fixtragait1-0/+6
In this commit software_versions added to the pnf customization table. A test case is also written to verify if the software_versions of type string is added to the pnfcustomization. Signed-off-by: tragait <rahul.tyagi@est.tech> Change-Id: Id07fe79e67ac96e71e6fe3775cce801edd81a42a Signed-off-by: tragait <rahul.tyagi@est.tech> Issue-ID: SO-3119 Signed-off-by: tragait <rahul.tyagi@est.tech>
2020-11-18Merge "Update SO Reference for scaling"Max Benjamin1-0/+5
2020-11-13bring back the config deploy to actionseshukm1-3/+3
Issue-ID: SO-3346 Signed-off-by: seshukm <seshu.kumar.m@huawei.com> Change-Id: I1a83418675f4061c659fdc92317b1b5bd96edbc2
2020-11-11Update SO Reference for scalingLukasz Rajewski1-0/+5
Update SO reference table for some Macro flows changing their execution with ControllerExecutionBB and dedicated action + scope Issue-ID: SO-3023 Change-Id: I030c1da04f02c3cf268fa9ba140b9b7920757d7c Signed-off-by: Lukasz Rajewski <lukasz.rajewski@orange.com>
2020-11-09comment the pnf entry in to test gatingseshukm1-2/+3
Issue-ID: SO-3369 Signed-off-by: seshukm <seshu.kumar.m@huawei.com> Change-Id: Ic2a72407fab753a52635ed9db29b8b616b6e8f4e
2020-11-05Support for PNF config deployKrzysztof Gajewski1-11/+13
Signed-off-by: Krzysztof Gajewski <krzysztof.gajewski@nokia.com> Issue-ID: SO-2647 Change-Id: I109da542258f7e038159868c9b65fcd3057716b9
2020-11-04Revert "Update SO Reference for scaling"Seshu Kumar M1-10/+0
This reverts commit fc381bbd38fc1106b713eaa87b7972ab240c5911. Reason for revert: Revert this change to make the macro flow to get rid of the controller_execution BB in the inst flow Issue-ID: SO-3346 Change-Id: I8a3d29dfcb1a96ec692ddb75510abd5173e42df1 Signed-off-by: seshukm <seshu.kumar.m@huawei.com>
2020-09-07Merge "Add new service in API-Handler for 3gpp service instances"Seshu Kumar M1-0/+10
2020-08-30Add new service in API-Handler for 3gpp service instancesReshmasree1-0/+10
Issue-ID: SO-3189 Signed-off-by: Reshmasree <reshmasree.chamarthi2@wipro.com> Change-Id: Ieb2d3d36b6a216b00f4c13ebabdf268cf833d267
2020-08-22Implement ModifyConfig SO Work flow (Day 2 configuration)aleemraja2-0/+18
- Added custom method to support ModifyConfig Issue-ID: SO-3151 Signed-off-by: aleemraja <ar00500721@techmahindra.com> Change-Id: I99dc4e53dbec1879a76ae184fe4b94afe1a999db Signed-off-by: aleemraja <ar00500721@techmahindra.com>
2020-08-07Add support for configAssignmharazin1-11/+14
Issue-ID: SO-2646 Signed-off-by: Mateusz Harazin <mateusz.harazin@nokia.com> Change-Id: Id69b3afd2bbb22607782d7d63409e381a1a23255
2020-07-31Create DeactivatePnfBB and include it into Service-Macro-Delete flow.Mateusz Gołuchowski1-10/+12
- created DeactivatePnfBB which changes orchestration status to inventoried when invoked - included BB into flow in R_MacroData script which initializes database - added support for mapping of service relations to PNFs - changed version of logging-analytics to 1.6.7 Issue-ID: SO-3111 Change-Id: I375db2014887f1f634adac31d4d1af3675f5911c Signed-off-by: Mateusz Goluchowski <mateusz.goluchowski@nokia.com>
2020-07-08Update SO Reference for scalingLukasz Rajewski1-0/+10
Update SO reference table for some Macro flows changing their execution with ControllerExecutionBB and dedicated action + scope Issue-ID: SO-3023 Signed-off-by: Lukasz Rajewski <lukasz.rajewski@orange.com> Change-Id: Ib46691b802a201c437e3c5257e586c3cfc039cd1
2020-04-29mso to support rollback forKuleshov, Elena1-9/+11
Add Rollback and Manual for CM BBs for rainy day handling table Add rollback flow generation logic for Change Management flows. Update Robot tests for ConfigModify Manual Task Add a test for rollback for inPlaceSoftwareUpdate, remove manualhandling tests for inPlaceSoftwareUpdate Issue-ID: SO-2853 Signed-off-by: Benjamin, Max (mb388a) <mb388a@att.com> Change-Id: I6a68662fee5295117f6f39ffe3fa97b7ef4e2116
2020-04-28Adding Generic VNF information in ControllerExeuctionBB flowSunil1-2/+4
Solving BlueprintName and BlueprintVersion issue Changing vf-module to vfmodule Updating AAI with Orchestration status Issue-ID: SO-2806 Signed-off-by: sunilb <sb00577584@techmahindra.com> Change-Id: I91aa653b946bae3940000f724710de87af3ce7df
2020-04-24Renamed duplidate flyway migrationBenjamin, Max (mb388a)1-0/+0
Two migrations with the same name were merged independently Issue-ID: SO-2828 Signed-off-by: Benjamin, Max (mb388a) <mb388a@att.com> Change-Id: I304a5f3498cf4b8e7e6f4600ae1a0017bf443723
2020-04-22Merge "Missing VNF Recipe for Optical service"Seshu Kumar M1-0/+6
2020-04-16Implement processing_flags table and correspondingKuleshov, Elena1-0/+13
Implement processing_flags table and corresponding interfaces. Implement rest interface for processingFlags table to toggle the value. Correct hashcode calculation for ProcessingFlags bean. Use newFabricConfigurationApi flag for managing FabricConfiguration BB logic. Remove readOnly specification from updating the processing_flags table Make sure update_timestamp field updates automatically. Issue-ID: SO-2814 Signed-off-by: Benjamin, Max (mb388a) <mb388a@att.com> Change-Id: I00697f8edf62c2d3d725daa710c17f03595eac51
2020-04-09Fix transition states for the BB workflow.Sebastien Premont-Tendland3-20/+11
Deleted the versioned flyway file in favor of the repeatable one for MacroData. I know deleting a versioned file could mess up upgrade but given no release has been done with those new versioned files it should be ok and cleaner. This is a list of transition states that were added internally at Bell when working with the BB workflow and post instantiation. Those are to support Rollback and Delete even if the VNF is in the status ConfigAssigned, Configure or Configured. The missing transition states was causing the Rollback or Delete to fail. Issue-ID: SO-2798 Signed-off-by: Sebastien Premont-Tendland <sebastien.premont@bell.ca> Change-Id: I21c11298a456a472cedc7a8733c6dbc3a071f3a6
2020-04-07Orchestration transitions missing for post instantiation workflowSebastien Premont-Tendland2-1/+18
This is a list of transition states that were added internally at Bell when working with the BB workflow and post instantiation. Those are to support Rollback and Delete even if the VNF is in the status ConfigAssigned, Configure or Configured. The missing trasition states was causing the Rollback or Delete to fail. Also update the initial script to support already existing data. Issue-ID: SO-2798 Signed-off-by: Sebastien Premont-Tendland <sebastien.premont@bell.ca> Change-Id: Ic90b74a25a5790f6d9ddb6919771735b1c081cb5
2020-04-03Orchestration migration table missing 'CONFIGURED'r.bogacki1-0/+2
Add missing Flyway migration to reduce manual steps for instantiation use cases. Issue-ID: SO-2784 Signed-off-by: Robert Bogacki <r.bogacki@samsung.com> Change-Id: Ieafafdb9abac3a0b0a4b14d60af5eac1710074c7
2020-04-01Missing VNF Recipe for Optical serviceSrinivasan Ramanathan1-0/+6
Added missing Recipe for orchestration of OTN services in Optical domain Change-Id: I515448ca6c799fbcaddbbe10fe803e47308cd8fe Issue-ID: SO-2773 Signed-off-by: Srinivasan Ramanathan <srinivasan.ramanathan2@us.fujitsu.com>
2020-03-25mso vnf configuration update composite flowBonkur, Venkat1-5/+18
Existing Change Management VNF Configuration Update flow migrated to the generic building blocks Introduced Activity BB VNFConfigModifyActivity.bpmn Updates to AppcOrcherationPreProcessor, ApplicationControllerTaskImpl to handle the ConfigModify Activity block. Updates to the catalog migration scripts to include VNF-Config-Update Macro flow. Issue-ID: SO-2768 Signed-off-by: Benjamin, Max (mb388a) <mb388a@att.com> Change-Id: I06be7a83fb2738b91b0257e1ec84298a7dafc1a1
2020-03-25Merge "split modification to flyscript into separate file"Steve Smokowski2-4/+27
2020-03-25Merge "Ingest and Process Service Function"Steve Smokowski1-0/+4