aktin / aktin/aktin-scripts

Create a database integrity check

Offen
#12 0 Kommentare 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen
Vorherrschende Sprache
Shell
Sterne
0
Forks
0
PR-Merge-Kennzahlen
Keine gemergten PRs in 30 T.

Beschreibung

Write a bash script that searches for _missing tables_ and _incorrect deployment format_ (local or docker).

## Feature: Missing tables
This script should be used before creating and after applying a data warehouse backup file, or just independantly for integrity checking purposes.
These checks work by mapping the database against a list of required tables. Map tables on their name and structure.

## Feature: Incorrect deployment format
Between a local and a dockerized deployment exist differences inside the database. Currently the relevant table breaking a deployment overarching database migration is the table "i2b2pm.pm_cell_data", that contains references to the i2b2 services. A local data warehouse points to a "localhost"-wildfly path while dockerized deployments point to a docker container running wildfly:

### local deployment
Image

### dockerized deployment
Image

Beitragsleitfaden

Für dieses Repository ist kein Beitragsleitfaden indexiert

Bewertung

Dieses Issue wurde noch nicht bewertet.

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.