Mercurial > hg > orthanc-tests
comparison NewTests/PostgresUpgrades/downgrade.sh @ 651:c3aa39672db1
fix path
| author | Alain Mazy <am@orthanc.team> |
|---|---|
| date | Mon, 03 Jun 2024 14:20:17 +0200 |
| parents | 087888659ba3 |
| children |
comparison
equal
deleted
inserted
replaced
| 649:5d7b6e43ab7d | 651:c3aa39672db1 |
|---|---|
| 1 #!/bin/bash | 1 #!/bin/bash |
| 2 | 2 |
| 3 pushd /scripts | 3 pushd /scripts |
| 4 | 4 |
| 5 # TODO: change pg-transactions by the plugin version number ! | 5 # TODO: change pg-transactions by the plugin version number ! |
| 6 apt-get update && apt-get install -y wget && wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/tip/PostgreSQL/Plugins/SQL/Downgrades/Rev2ToRev1.sql | 6 apt-get update && apt-get install -y wget && wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Downgrades/Rev2ToRev1.sql |
| 7 psql -U postgres -f Rev2ToRev1.sql | 7 psql -U postgres -f Rev2ToRev1.sql |
| 8 | 8 |
| 9 # if you want to test a downgrade procedure, you may use this code ... | 9 # if you want to test a downgrade procedure, you may use this code ... |
| 10 # psql -U postgres -f downgrade.sql | 10 # psql -U postgres -f downgrade.sql |
| 11 popd | 11 popd |