summaryrefslogtreecommitdiffstats
path: root/policy-db-migrator/src
AgeCommit message (Collapse)AuthorFilesLines
2023-11-10Update snapshot and/or references of policy/docker to latest snapshotsliamfallon1-1/+1
policy/docker updated to its latest own and reference snapshots *** This commit is generated by a PF release script *** Issue-ID: POLICY-4854 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: I8f3d58ae8d2fce590aa9e63c24ed9d6dfff5737a
2023-11-08update parent references in policy/docker pom3.0.2liamfallon1-1/+1
updated the parent references in the policy/docker pom *** This commit is generated by a PF release script *** Issue-ID: POLICY-4854 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: I7b3394d18519b333e436eae209dc17864adb3e43
2023-11-08Remove statistics tablesadheli.tavares13-0/+308
- added scripts with removal of statistics tables and indexes for upgrade; - added scripts with creation of tables and indexes for downgrade; - fixed the leftover of sequence table when not using it for indexing primary keys. Issue-ID: POLICY-4109 Change-Id: Ic643df87a149d3c27eaa846bd4b46db5d61eda22 Signed-off-by: adheli.tavares <adheli.tavares@est.tech>
2023-10-18Update snapshot and/or references of policy/docker to latest snapshotsliamfallon1-1/+1
policy/docker updated to its latest own and reference snapshots *** This commit is generated by a PF release script *** Issue-ID: POLICY-4854 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: I0b68c11b655b38fa845fe983ac1d7d23087701a9
2023-10-17update parent references in policy/docker pomliamfallon1-1/+1
updated the parent references in the policy/docker pom *** This commit is generated by a PF release script *** Issue-ID: POLICY-4854 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: I05cb629d58d83d35e6e3f5a45c123e0ced2b801c
2023-09-20Java 17 Upgradeadheli.tavares1-2/+2
- change of snapshot versions - csit fixes - apk update for openjdk security updates Issue-ID: POLICY-4667 Change-Id: I0f1044b88db9573886e5c5a14ebabb098128b2f2 Signed-off-by: adheli.tavares <adheli.tavares@est.tech>
2023-08-28Change java image for db migratorliamfallon1-1/+1
Issue-ID: POLICY-4665 Change-Id: Ie910a5c00c7802343c0608702504465c188ac38c Signed-off-by: liamfallon <liam.fallon@est.tech>
2023-04-24Update snapshot and/or references of policy/docker to latest snapshotsrameshiyer271-1/+1
policy/docker updated to its latest own and reference snapshots *** This commit is generated by a PF release script *** Issue-ID: POLICY-4648 Signed-off-by: rameshiyer27 <ramesh.murugan.iyer@est.tech> Change-Id: Iea14df61ba745fa3121b7b51fa4f8d419695fdce
2023-04-24update parent references in policy/docker pom2.6.2rameshiyer271-1/+1
updated the parent references in the policy/docker pom *** This commit is generated by a PF release script *** Issue-ID: POLICY-4648 Signed-off-by: rameshiyer27 <ramesh.murugan.iyer@est.tech> Change-Id: If877a16fa939c09cca335e2f3c3343cc44f335c6
2023-04-20Fix postgres sql syntax errorswaynedunican7-7/+11
Issue-ID: POLICY-4649 Change-Id: I96bb55ddadae9449f5cb115dd294bf7630b93fcc Signed-off-by: waynedunican <wayne.dunican@est.tech>
2023-02-28Update snapshot and/or references of policy/docker to latest snapshotssaul.gill1-1/+1
policy/docker updated to its latest own and reference snapshots *** This commit is generated by a PF release script *** Issue-ID: POLICY-4570 Signed-off-by: saul.gill <saul.gill@est.tech> Change-Id: Ie7cebf3963d13081b4ec1c31e454c7026370aef3 Signed-off-by: saul.gill <saul.gill@est.tech>
2023-02-28update parent references in policy/docker pom2.6.1saul.gill1-1/+1
updated the parent references in the policy/docker pom *** This commit is generated by a PF release script *** Issue-ID: POLICY-4570 Signed-off-by: saul.gill <saul.gill@est.tech> Change-Id: I527246c9df1f9dcd34a1d2c31301e39650fdc598
2023-02-14Remove integration base images from PF base imagesliamfallon1-5/+11
The Docker base image from the integration project is now unmaintained. We replace the Integration base image by updating our own base image to work directly off Alpine. Issue-ID: POLICY-4558 Change-Id: I00097cede2536c88ade3f318479eab309695b41e Signed-off-by: liamfallon <liam.fallon@est.tech>
2023-02-09Merge "Add sequence tables for Hibernate"Liam Fallon8-0/+178
2023-02-09Add sequence tables for Hibernateliamfallon8-0/+178
Hibernate does not allow the same sequence table to be used for more than one sequence number generator JPA class. Issue-ID: POLICY-4533 Change-Id: If7e70164a5da7e0678aeb192d563bafc213f8bb6 Signed-off-by: liamfallon <liam.fallon@est.tech> Signed-off-by: adheli.tavares <adheli.tavares@est.tech>
2023-02-08Improve MariaDB Sqls for db-migrator tooladheli.tavares61-119/+122
Issue-ID: POLICY-4549 Change-Id: I4a1cd6514ae8025726ca015081632633ea49361a Signed-off-by: adheli.tavares <adheli.tavares@est.tech>
2022-12-19Changes for H2 database upgradeliamfallon8-0/+164
The latest verison of H2 does not allow colums called "user" or indexes using an underscore in their name. Issue-ID: POLICY-4488 Change-Id: I632f0715d597da1d306002e6079efc98bba0487f Signed-off-by: liamfallon <liam.fallon@est.tech>
2022-12-15Update snapshot and/or references of policy/docker to latest snapshotsliamfallon1-1/+1
policy/docker updated to its latest own and reference snapshots *** This commit is generated by a PF release script *** Issue-ID: POLICY-4484 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: Id9c0499baef561e5c48688c5071d07f4f2d08c3a
2022-12-15update parent references in policy/docker pom2.6.0liamfallon1-1/+1
updated the parent references in the policy/docker pom *** This commit is generated by a PF release script *** Issue-ID: POLICY-4484 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: Ied0e7cb66a66220b4566a5a7f4d9f026f128a177
2022-10-21Set snapshot and/or references of policy/docker for new releaseliamfallon1-1/+1
policy/docker updated to its latest own and reference snapshots *** This commit is generated by a PF release script *** Issue-ID: POLICY-4408 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: Id900a74168359265a327fa652d958edc56e15214
2022-10-20Update snapshot and/or references of policy/docker to latest snapshotsliamfallon1-1/+1
policy/docker updated to its latest own and reference snapshots *** This commit is generated by a PF release script *** Issue-ID: POLICY-4408 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: Ic99f4fe294722c669639aebc362b96b25b1ed07c
2022-10-20update parent references in policy/docker pom2.5.1liamfallon1-1/+1
updated the parent references in the policy/docker pom *** This commit is generated by a PF release script *** Issue-ID: POLICY-4408 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: I75c221301140aba485a3d80f072be134ce0ec615
2022-10-20Adding Khon as latest db version.adheli.tavares4-0/+80
- no schema changes, adding a simple message for completion. Issue-ID: POLICY-4408 Change-Id: I293278b242cc263443933393ca99eab2bef207be Signed-off-by: adheli.tavares <adheli.tavares@est.tech>
2022-10-18OpenSuse docker file for db-migratordanielhanrahan1-0/+55
Create OpenSuse docker file Add build profile for OpenSuse docker image Issue-ID: POLICY-4309 Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech> Change-Id: I80ec31c62096f9aefa2b729a4e024f63d04e62ad
2022-09-26db-migrator SQL compatibility mysql/mariadbjhh5-5/+5
Issue-ID: POLICY-3464 Signed-off-by: jhh <jorge.hernandez-herrero@att.com> Change-Id: I6b1fd22062ca4f55c036bc2632307454a1f00840
2022-09-23Allow for mysql command flags in db-migratorjhh1-1/+5
For example by setting the env var to MYSQL_CMD="mysql --ssl" Issue-ID: POLICY-4182 Signed-off-by: jhh <jorge.hernandez-herrero@att.com> Change-Id: If7298fb2ea01f15324a526e49f2ec860d29f8d31
2022-09-22Update snapshot and/or references of policy/docker to latest snapshotsliamfallon1-1/+1
policy/docker updated to its latest own and reference snapshots *** This commit is generated by a PF release script *** Issue-ID: POLICY-4343 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: I57d1adc21b8fedd6346edd467f524a6849632429
2022-09-22update parent references in policy/docker pom2.5.0liamfallon1-1/+1
updated the parent references in the policy/docker pom *** This commit is generated by a PF release script *** Issue-ID: POLICY-4343 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: I50a42992090a865fc5f78249a2e2258b761ec35d
2022-09-14Change the properties column type to hibernate/postgres match.adheli.tavares5-5/+5
- changing the type to bigint because pap was having side effects errors with the bytea forced cast Issue-ID: POLICY-4352 Change-Id: I368c3ba80fce0c10d9417deee8f9ac25c467d4e3 Signed-off-by: adheli.tavares <adheli.tavares@est.tech>
2022-09-07Fix casting of lob type on db-migrator for postgres installationadheli.tavares5-5/+5
Issue-ID: POLICY-4352 Change-Id: Ib3aa68a512c1278920a8bdf1ed29914195d0e371 Signed-off-by: adheli.tavares <adheli.tavares@est.tech>
2022-07-29Update docker base image to snapshotliamfallon1-1/+1
Update docker base image to snapshot *** This commit is generated by a PF release script *** Issue-ID: POLICY-4287 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: I55c64b06282fb7fd920924351f2d471d59bcf403
2022-07-15Update parent references on docker filesliamfallon1-1/+1
Issue-ID: POLICY-4287 Change-Id: I9c6c59e264624d35b70b26640c2442f937419527 Signed-off-by: liamfallon <liam.fallon@est.tech>
2022-06-29OCI image spec labels for policy-docker imagesdanielhanrahan1-0/+8
Issue-ID: POLICY-4264 Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech> Change-Id: I8ab51f82a441361b8aa6b5f9aa0b6917ceea5399
2022-03-28DB migrator fixes after smoke testadheli.tavares10-329/+311
Issue-ID: POLICY-3999 Change-Id: I65d95cbfab4b49245bb68f2ca5067fda9437b531 Signed-off-by: adheli.tavares <adheli.tavares@est.tech>
2022-03-24Merge "Add db migrator changes for tosca node templates"Liam Fallon4-0/+80
2022-03-23Add db migrator changes for tosca node templatesrameshiyer274-0/+80
Issue-ID: POLICY-3934 Signed-off-by: zrrmmua <ramesh.murugan.iyer@est.tech> Change-Id: Ie59a0658a42fb0ae2a3a289c35df0ffcf30d518e
2022-03-23Fix postgres scriptswaynedunican3-3/+3
Fix for syntax errors in postgres scripts Issue-ID: POLICY-2715 Change-Id: I109056f7ee37b439f914fbd5d1d0ca87df550e4e Signed-off-by: Wayne Dunican <wayne.dunican@est.tech>
2022-02-16Fix issue with GeneratedValue in PfGeneratedIdKeya.sreekumar8-0/+168
Until now, 'ID, name and version' was used as the primary key in jpapolicyaudit and pdpstatistics tables. With this change, only ID will be used as the PK. The applications works with or without this change, as ID was the only field which was always unique. "name" and "version" are mostly duplicates (policyName in case of jpapolicyaudit & pdpName in case of pdpstatistics table). Pushing this change anyway to keep the tables consistent with the entity classes. Change-Id: I34a7582ed9c74fa0ead8fce2e86ac2ce1ecacf1e Issue-ID: POLICY-3897 Signed-off-by: a.sreekumar <ajith.sreekumar@bell.ca>
2022-02-07Merge "Modified db-migrator to allow configuration of database"Liam Fallon4-14/+806
2022-02-04Add upgrade/downgrade scripts for postgres in db-migratorwaynedunican12-0/+244
- Jakarta upgrade scripts - Jakarta downgrade scripts Issue-ID: POLICY-2715 Change-Id: I1dbe902644ce392ef0823022a256cf37cc499a3e Signed-off-by: Wayne Dunican <wayne.dunican@est.tech>
2022-02-02Merge "Add upgrade/downgrade scripts for postgres in db-migrator"Liam Fallon96-0/+1920
2022-02-02Merge "Add upgrade/downgrade scripts for postgres in db-migrator"Liam Fallon96-0/+1920
2022-02-02Merge "Add upgrade/downgrade scripts for postgres in db-migrator"Liam Fallon26-0/+528
2022-02-02Modified db-migrator to allow configuration of databasewaynedunican4-14/+806
- Updated the Dockerfile to include postgres sql and to copy postgres scripts - Added db-migrator-pg script for postgres installation - Updated prepare upgrade/downgrade scripts Issue-ID: POLICY-2715 Change-Id: Ib8d3523e8445ad1528fe225c96acdac5ca61535d Signed-off-by: Wayne Dunican <wayne.dunican@est.tech>
2022-01-20Add upgrade/downgrade scripts for postgres in db-migratorwaynedunican96-0/+1920
- Honolulu upgrade scripts Issue-ID: POLICY-2715 Change-Id: I1cec6f16c4797bd1ce34d506173d28ae48e36801 Signed-off-by: Wayne Dunican <wayne.dunican@est.tech>
2022-01-20Add upgrade/downgrade scripts for postgres in db-migratorwaynedunican96-0/+1920
- Honolulu downgrade scripts Issue-ID: POLICY-2715 Change-Id: Id3c242311868898d32c3d2e92427cf687a1d7cc1 Signed-off-by: Wayne Dunican <wayne.dunican@est.tech>
2022-01-20Add upgrade/downgrade scripts for postgres in db-migratorwaynedunican26-0/+528
- Istanbul upgrade scripts - Istanbul downgrade scripts Issue-ID: POLICY-2715 Change-Id: I0dcfd11acaf5971581db081f2ff18b7657d0c7af Signed-off-by: Wayne Dunican <wayne.dunican@est.tech>
2022-01-10Fix issues in existing entity classesa.sreekumar12-0/+244
Change-Id: I862a5c413f5cf4d0e472a527cd6dc5a32c28459c Issue-ID: POLICY-3871 Signed-off-by: a.sreekumar <ajith.sreekumar@bell.ca>
2021-10-12Update parent version, jdk version in db-migrator2.3.1liamfallon1-1/+1
Issue-ID: POLICY-3696 Change-Id: I827bdd238ab51a1798dab3d83f088377be7949ff Signed-off-by: liamfallon <liam.fallon@est.tech>
2021-09-28Retain datetime precision on downgradektimoney2-2/+2
Retain datetime precision during downgrade operation to prevent duplicate keys in pdpstatistics Issue-ID: POLICY-3679 Change-Id: Ic93519b9420f0f77c3af7b63d3963f1971d77c37 Signed-off-by: ktimoney <kevin.timoney@est.tech>