summaryrefslogtreecommitdiffstats
path: root/extra/sql
AgeCommit message (Collapse)AuthorFilesLines
2021-01-05Change the java package namesebdet1-30/+30
Rename java package name to org.onap.policy.clamp instead of org.onap.clamp Issue-ID: POLICY-2922 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: Ic3255b90fd52a7b2689ae7a55f55ee7841abebac Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-10-09Fix the DCAE querysebdet1-32/+31
The DCAE deployment URL can contain URI parameters that crashes the URL used by HTTP4 Camel. Also the parameter connectionTimeToLive is removed as it is transmitted in each call. The SDC client is also updated to 1.4.1 Issue-ID: CLAMP-954 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: Ieebdfe009f4339188c75c7a3365546779a087561 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-08-03Update some direct dependenciessebdet1-33/+33
Update vulnerable dependencies tomcat Issue-ID: CLAMP-850 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: Idf72aa9155fda422bd58013b6eaf888d67557e68
2020-06-03Update sql filessebdet2-33/+31
Update sql files and swagger due to svg removal Issue-ID: CLAMP-854 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: I90b9ea58c63733d6b7a8ed7354469a68e9f914cf
2020-05-18Add info in the SVGsebdet1-31/+31
Add two additional fields in the SVG for the UI so that components can easily get the data without the need to access the models Issue-ID: CLAMP-852 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: I872d3c8b0336d813e1a1cf590f6c8a06cccbe230
2020-04-28Fix VNF entityId in policiessebdet1-31/+31
Fix the VNF entity IDs value in json schema for each policies (in UI) Issue-ID: CLAMP-843 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: I9515b01422acdfc0ec36f10cc70994145e561d7f
2020-04-23Fix entityId bugsebdet1-31/+31
A user defined entry has been added to the entity id by default, so that json editor falls back to that value when re-editing the policies Issue-ID: CLAMP-829 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: I593163f87df9f97a19964428bf2016154dc9576d
2020-04-20Fix the get statussebdet1-32/+32
The policy status goes to unknown because the status code returned is not good in some cases (failure with dcae comm) Issue-ID: CLAMP-827 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: Iae189f62b4c7061949ffd4c842465bf5e379b669
2020-04-15Bump up clamp to 5.0.4sebdet1-31/+31
Bump up clamp to 5.0.4 for future release Issue-ID: CLAMP-822 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: If3fe1d2efc81576926220d578428f8db488a943e
2020-04-03Fix pdp group info not there for legacy policysebdet1-31/+31
The operational policy legacy name must be changed so that clamp can get the right pdp group and subgroup Issue-ID: CLAMP-817 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: Iaede77977b8f450c10bf7df73cf2b84a74ab122a
2020-04-01Rework the logssebdet1-31/+31
Rework the logs so that it's easier to debug the issues on a lab Issue-ID: CLAMP-804 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: I9cff98205c2135a759e7e6156ab39f8af8129927
2020-03-25Improve the policy model downloadsebdet1-31/+31
Improve the policy model download so that the yaml is now in pretty printing and the policy engine is not triggered if the model is already in the database Issue-ID: CLAMP-784 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: Ibd1e6bd617cf052ad4c475e4dd9c63eb2b046acd
2020-03-24Improve metadata supportsebdet1-22/+45
Improve the metadata support for CDS and default values Issue-ID: CLAMP-786 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: I8a24e31a93ff1e288ec8f0f6d522b1b15d39a8d2
2020-03-23Fix the CDS callssebdet1-15/+22
Fix the CDS calls for generic tosca policies, the new tosca parser must be interrupted so that clamp can do json schema enrichment Issue-ID: CLAMP-786 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: Ib7e85a6cc3849f614a3025779d29e8024f7a2ef2
2020-03-16Fix the legacy policiessebdet1-15/+15
Fix the legacy policies not displayed in the UI properly due to the new PolicyModal dialog. Issue-ID: CLAMP-779 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: I8070d8c57e43c9a386e09475f0d377f91104aef1
2020-03-13Fix the new tosca convertersebdet1-15/+15
Fix the metadata section analysis and make the tosca parser more configurable (in applications.properties) Issue-ID: CLAMP-580 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: I9068bd9dc89861c640660a7f78fae2cb70bdc178 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-03-10Fix the tosca convertersebdet1-16/+16
Fix the new tosca converter to support metadata section Issue-ID: CLAMP-580 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: I9068bd9dc89851c630660a7f78fae1cb70bdc178
2020-03-10Rework tosca convertersebdet1-15/+15
Fix the tosca converter template to support json instead of properties file. Issue-ID: CLAMP-253 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: Id4f839d0b5bfece519b0b1e615e8d6e14e464f16
2020-03-09Rework tosca convertersebdet1-15/+15
New code to convert the Policy Tosca Yaml to Json Schema for the Clamp UI Issue-ID: CLAMP-647 Signed-off-by: sebdet <sebastien.determe@intl.att.com> Change-Id: Id15ddedc1910f6a40bf6e407b34e343e00135571
2020-03-04Change json representation in op policysebdet2-23/+21
Change the json generation for an operational policy instance and update all emulator response for all policy types Issue-ID: CLAMP-653 Change-Id: I68525be3d5bfbf5dd7a4bcf6d59853df07fd4dd9 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-02-27Fix bug in operational policysebdet1-17/+17
Fix bugs in camel routes and operational policy due to changes done for op policy insertion/removal Issue-ID: CLAMP-647 Change-Id: I68524bd3d5bfbf5dd7a4bcf6d59853df07fd4dd9 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-02-26Add new dialog for policysebdet1-17/+17
Add a new dialog component for tosca based policy, config/op should use that dialog now. Issue-ID: CLAMP-653 Change-Id: I57523bc2d4bfbf5ca5a3acf5c59823df06fd4cd9 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-02-26Create get Pdp Groups flowxuegao1-0/+3
Create a camel flow to get the list of Pdp Groups info from Policy. Create a scheduler to trigger the camel flow regularly and store the Pdp Groups info into DB. Issue-ID: CLAMP-644, CLAMP-649 Change-Id: I6427202cc0186cd85428d5d25b28a8622e4d7ca4 Signed-off-by: xuegao <xg353y@intl.att.com>
2020-02-25Fix Bug due to user management changessebdet1-17/+17
Fix the bugs, build is broken due to changes done previously Issue-ID: CLAMP-651 Change-Id: I57523bc2c3bfbf5ca5a3acf5c59823df06fd4cd9 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-02-25Modify the Uisebdet1-18/+18
Modify the Ui to have a modify option in the menu so that the user can tune the loop instance Issue-ID: CLAMP-648 Change-Id: I57523bc1c3afaf5ca5a2acf5c59823df06fd4cd9 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-02-25Operational policy modificationsebdet2-20/+25
policyModel added to Operational policy object so that a user in the UI can add op policies, guard or whatever Issue-ID: CLAMP-647 Change-Id: I57521bc1c3afaf5ca5a2acf5c59823df06fd4cd9 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-02-17Fix the loop template viewsebdet1-10/+27
Fix the loop template view modal as the rest api has been changed + the database model as well Issue-ID: CLAMP-589 Change-Id: I57521bc1c3afaf4ca5a2acf4c59823df06fd4cd9 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-02-14Changes include Metadata support, Upload tosca policy model and Loop Templateash742681-11/+20
CLAMP Metadata support to parse policy_model_type, acronym and clamp_possible_values from the Tosca Policy Model UI and Backend changes to support Loop Template Backend APIs for Dictionary referenced in the Tosca Policy Model. Upload Tosca Model UI changes to allow user to upload policy models. DB Schema changes for the Loop Element Model and updated schema for the Dictionary Added Jest test cases and snapshots checkstyle issues fix and Junits Issue-ID: CLAMP-580 Signed-off-by: ash74268 <ashwin.shyam.sharma@att.com> Change-Id: I57521bc1c3afaf4ca5a2acf4c59823df05fd4cd6 Signed-off-by: ash74268 <ashwin.shyam.sharma@att.com>
2020-02-10Get policy in CsarInstallersebdet2-12/+12
Get the policies on the PEF engine when installing the CSAR (if needed) Issue-ID: CLAMP-518 Change-Id: I2cca157821c22ef63dc748984140287667cc4663 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-02-10Update get Dcae Status flowxuegao1-1/+2
Update the flow to get Dcae Status, supporting multiple blue print. Issue-ID: CLAMP-590 Change-Id: I6a05a40d4879082413d3ed83159467ea616c5d37 Signed-off-by: xuegao <xg353y@intl.att.com>
2020-01-30Remove blueprintId in loopsebdet2-11/+10
Remove the blueprint Id for DCAE in loop object as now the one in loop template will be used. Issue-ID: CLAMP-592 Change-Id: Ie86f362451d58de07f7a715ae0bfc92566893e13 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-01-30Change the Csar installersebdet2-15/+13
Change the csar installer so that it installs a loop template instead of a loop object Issue-ID: CLAMP-592 Change-Id: I757f6411ce959573fcb3a82e48359a1a44f87410 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-01-30Update deploy-loop routexuegao1-1/+2
Update deploy-loop to support multiple blueprint deployments Issue-ID: CLAMP-571 Change-Id: If98e9305c36a01f86a522db002174f92f6ff5996 Signed-off-by: xuegao <xg353y@intl.att.com>
2020-01-23Modify the template modelsebdet2-79/+109
Add loopElement to loopTemplate so that operational policy can be added into the template as well Issue-ID: CLAMP-555 Change-Id: I298c05f7f92536e4dab840983c41b0f7ee22daac Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-01-17Add fields on microservicesebdet2-14/+16
Add fields for DCAE on microservice instance Issue-ID: CLAMP-572 Change-Id: Ia68b45921ba6f6f3a3efd574887475aff22bc3a8 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2020-01-16Add template and tosca model entities and repositoriesnrpandya2-15/+207
Add Control loop template, tosca model and model policy properties hibernate entity classes and crud repositories Issue-ID: CLAMP-555 Change-Id: Ib7f07aca5ad2ddf5caff7c98ea9341bdc147e817 Signed-off-by: nrpandya <neenendra.pandya@att.com>
2019-12-18Move jsonRepresentationxuegao1-1/+1
Move the storage of jsonRepresentation to OperationalPolicy level Issue-ID: CLAMP-582 Change-Id: Id555ebc1f2f04468f7bf0ffd813de7732bcee97f Signed-off-by: xuegao <xg353y@intl.att.com>
2019-12-09Update service objectxuegao1-0/+1
Seperate the procedure to install service and loops. Issue-ID: CLAMP-566 Change-Id: Ied7143ce8849baffda7678e82f4d6c4d9f1443d9 Signed-off-by: xuegao <xg353y@intl.att.com>
2019-11-18Create Service objectxuegao1-1/+14
User Service object to store loop service and resource realted info. Issue-ID: CLAMP-545 Change-Id: I0df6f5d43d7e0575346e02a27bca5c0b5ecdb0a0 Signed-off-by: xuegao <xg353y@intl.att.com>
2019-09-12Add scritp for DBsebdet5-3/+178
Add scripts to load/save the db + add autogeneration of the test data used by the CSIT Issue-ID: CLAMP-496 Change-Id: I90cc4d1860562c0325038e6b8e900d99b64d201a Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2019-09-10Remove dead codesebdet5-801/+12
Removal of deprecated v1 interface code, sql cleaned up as well, old model removed from database Issue-ID: CLAMP-487 Change-Id: I4a9f14de9ea1c1b76c522581d75cf4b011c2aa01 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2019-08-20Fix SQLsebdet1-1/+1
Fix SQL due to change in the Loop object Issue-ID: CLAMP-430 Change-Id: Ia97aaf58a71cb7d585ef2c296a97b911635ad8fb Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2019-08-19Draft of op policysebdet1-0/+1
First draft of the Operational policy based on JsonEditor, it's a wip code Issue-ID: CLAMP-430 Change-Id: I2c7970e94488f4020377fd9d4d00691a3590b13e Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2019-06-05Rework the loop statesebdet1-0/+1
Rework the state loop so there is no bug in the loop state anymore, now the components are scanned + upgrade to 4.0.4 Issue-ID: CLAMP-384 Change-Id: If7649238ee52864c84bfb9b6b8471d1738752e29 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2019-05-03Fix log reportingsebdet1-1/+1
Fix loop log reported in UI, in case of failure it's not working correclty Issue-ID: CLAMP-360 Change-Id: I4533c650134b254619523d8c9cfe2791e9b6584b Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2019-04-05Introduce Camel routesebdet1-1/+0
Camel route for Submit operation using http4 component Issue-ID: CLAMP-303 Change-Id: I29804a7db6286dfa84f7eed63813f25299a385e6 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2019-03-28Rework the submit operationxg353y1-0/+2
Rework the logic to create/delete ms config policies. Issue-ID: CLAMP-303 Change-Id: I317e262ab68280a7518a6e31e82e5fcb0a7f94ed Signed-off-by: xg353y <xg353y@intl.att.com>
2019-03-12Add svg supportsebdet1-1/+1
Add SVG support to the CSAR installer so that UI could render the loop Issue-ID: CLAMP-306 Change-Id: Ief963c4ad8e4c142f20c16b2049cad3a8aeedfb0 Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2019-03-12Add unit testssebdet1-2/+2
Add unit tests and fix code to support them, columns modified and csar installer fixed as well Issue-ID: CLAMP-306 Change-Id: I946ef1aa957ca36bbb00357308ac67a3f07dcdce Signed-off-by: sebdet <sebastien.determe@intl.att.com>
2019-03-11Add sqlsebdet1-0/+70
Add sql file to the project, so the csit can use the docker-compose Change-Id: I1b7fd810d3686f686803b30ffce41823a2f3abd3 Issue-ID: CLAMP-299 Signed-off-by: sebdet <sebastien.determe@intl.att.com>