summaryrefslogtreecommitdiffstats
path: root/policy-db-migrator/src
AgeCommit message (Collapse)AuthorFilesLines
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-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>
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 Sreekumar1-1/+1
2021-08-25Bump docker to 2.3.1Jim Hahn1-1/+1
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-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-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>