summaryrefslogtreecommitdiffstats
path: root/policy-db-migrator
AgeCommit message (Collapse)AuthorFilesLines
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 snapshotsliamfallon2-2/+2
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-09-01Allow setting external dockerfile for db-migratordanielhanrahan1-1/+4
Added maven properties to allow overriding dockerfile during build e.g. mvn clean install -Pdocker -Ddocker.dbm.dockerFile=/path/to/dockerfile Issue-ID: POLICY-4334 Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech> Change-Id: Idb282cd121f5bf4ec91764596a88fb28e3557256
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 imagesdanielhanrahan2-1/+13
Issue-ID: POLICY-4264 Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech> Change-Id: I8ab51f82a441361b8aa6b5f9aa0b6917ceea5399
2022-05-03Set 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-4073 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: Ibc0b2ea07a80ece136ae81b6dec8bb457fc86fa9 Signed-off-by: liamfallon <liam.fallon@est.tech>
2022-04-27Update 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-4089 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: Ib1f5eaf1f685d3789375dc32fce07104fa4faf65
2022-04-12Update 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-4089 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: Icf8d329eeb1713f6edd6cb94d45015c952b43a98
2022-03-28DB migrator fixes after smoke testadheli.tavares13-329/+847
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-03-09Update 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-3982 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: I5779febc813b6a2c663c1f2cd863df150f2c9837
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-11-24Update snapshot of policy/docker to 2.4.1-SNAPSHOTliamfallon1-1/+1
*** This commit is generated by a PF release script *** This commit updates the snapshot of the repo to the next patch version. Issue-ID: POLICY-3827 Signed-off-by: liamfallon <liam.fallon@est.tech> Change-Id: I838765b413507978fff7dffce324df3f9f7e9dcf
2021-10-14Bump policy/docker to Jakarta 2.4.0-SNAPSHOTliamfallon1-1/+1
Issue-ID: POLICY-3696 Change-Id: I48777921ed97ec578fb797521c6dd1240a116d4b Signed-off-by: liamfallon <liam.fallon@est.tech>
2021-10-14Bump policy/docker to 2.3.2-SNAPSHOTliamfallon1-1/+1
Issue-ID: POLICY-3696 Change-Id: Id00233078bb6add59e5c90311cc78d7a4f29490d Signed-off-by: liamfallon <liam.fallon@est.tech>
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>
2021-09-27Modify pdpstatistics to prevent duplicate keysktimoney1-1/+1
Update timeStamp column in pdpstatistics to include microseconds. Issue-ID: POLICY-3679 Change-Id: Ibf622b090b1cd914413f79c663db8128263c4ac2 Signed-off-by: ktimoney <kevin.timoney@est.tech>
2021-09-21Update db-migrator version checksktimoney1-42/+35
DB-Migrator job completes even during failed upgrade Issue-ID: POLICY-3660 Change-Id: I7295c740853e4dd533e989faa3dddebab4d4ccab Signed-off-by: ktimoney <kevin.timoney@est.tech>
2021-08-31Update default value of LASTUPDATE in pdp tablektimoney1-1/+1
Update LASTUPDATE column in pdp table to use CURRENT_TIMESTAMP as default value Issue-ID: POLICY-3608 Change-Id: I28d267729ab3959a0d4602a4129737d6d8029f86 Signed-off-by: ktimoney <kevin.timoney@est.tech>
2021-08-26Merge "Bump docker to 2.3.1"Ajith Sreekumar2-2/+2
2021-08-25Bump docker to 2.3.1Jim Hahn2-2/+2
Also changed db-migrator to base off of 2.3.0 jre-alpine version. (We have a "chicken and egg" problem where the migrator can't point to the current docker version, as it hasn't been released yet, thus pointing it to the latest released version, which is one back.) Issue-ID: POLICY-3587 Change-Id: Idf34e9c6a724e31f16636388e239bed059c5dd3e Signed-off-by: Jim Hahn <jrh3@att.com>
2021-08-25Update pdp_enginestats records during upgrade/downgradektimoney28-54/+98
Updates to pdpstatistics have a knock on effect on pdp_enginestats. Table data needs to updated to ensure records are in sync Issue-ID: POLICY-3583 Change-Id: Id7408beceb47e540e933e8ccc0ff05095f8da85b Signed-off-by: ktimoney <kevin.timoney@est.tech>
2021-08-23Update METADATA table names for policy/docker db-migratorktimoney1-2/+2
METADATA tables for policy/docker db-migrator should be different than counterpart in policy/drools-pdp seed Issue-ID: POLICY-3547 Change-Id: Ie0c6ebf286ed410433014106425626cee55f222e Signed-off-by: ktimoney <kevin.timoney@est.tech>
2021-08-20Update pdpstatistics with IDs for change of PK.adheli.tavares3-1/+5
Update the new created ID column with values when changing pdpstatistics PK composition. Issue-ID: POLICY-3546 Change-Id: I53939557700237ccc7ab21e4069bd82ec6a4a4cf Signed-off-by: adheli.tavares <adheli.tavares@est.tech>
2021-08-18Upgrade/downgrade on existent tables and indexes.adheli.tavares27-74/+340
Issue-ID: POLICY-3535 Change-Id: I755bb0f279f4255eb9c452b9f569a88de69e14f2 Signed-off-by: adheli.tavares <adheli.tavares@est.tech>
2021-08-10use url resource for docker-tag -- dockerTaka Cho1-19/+5
use groovy url resource from docker repo to identify the tag for docker With this change, the "SNAPSHOT-latest" docker tag will change from "2.3.0-SNAPSHOT-latest" to "2.3-SNAPSHOT-latest" for jdk/jre alpine base image as well as db_migrator docker. Also fix a bug in println groovy script. Issue-ID: POLICY-3378 Change-Id: I72bd15e2535f688629ee5f1a823409d8fe83cdb1 Signed-off-by: Taka Cho <takamune.cho@att.com>
2021-08-09Add db-migrator to CSITktimoney3-0/+0
Update file permissions for db-migrator scripts Issue-ID: POLICY-3491 Change-Id: I6895d27cb45dcdb9faa94ef5dc5e97b610ba3509 Signed-off-by: ktimoney <kevin.timoney@est.tech>
2021-07-29Merge "Update db-migrator to include ability to deal with partial installs"Jim Hahn66-419/+506
2021-07-28Move policy-db-migrator to separate containerktimoney1-0/+154
Issue-ID: POLICY-3458 Change-Id: I4ae930d7f903efc4cf10dfca88dfed843ea29edb Signed-off-by: ktimoney <kevin.timoney@est.tech>
2021-07-27Update db-migrator to include ability to deal with partial installsktimoney66-419/+506
Allow user to upgrade or downgrade form a release that did not complete successfully Issue-ID: POLICY-3490 Change-Id: Ie14a744246f26a9036066b9f4064bca0c23290be Signed-off-by: ktimoney <kevin.timoney@est.tech>
2021-07-20Update db-migrator to include rollback functionalityktimoney1-23/+86
Issue-ID: POLICY-3490 Change-Id: Ibd1898819a5cb70f25bf69d71f2975dd2845389e Signed-off-by: ktimoney <kevin.timoney@est.tech>
2021-07-13Move drools-pdp db-migrator to separate containerktimoney205-0/+4876
Note: Instructions on how to use: https://wiki.onap.org/display/DW/Instructions+for+running+db-migrator Issue-ID: POLICY-3458 Change-Id: I42bce63eca94333c6aaab0e27eb3e514bb844661 Signed-off-by: ktimoney <kevin.timoney@est.tech>