aktin / aktin/aktin-scripts

Create a database integrity check

Ouverte
#12 0 commentaires 0 réactions 0 personnes assignées Voir sur GitHub
Langage dominant
Shell
Étoiles
0
Forks
0
Métriques de merge des PR
Aucune PR mergée en 30 j

Description

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

Guide de contribution

Aucun guide de contribution indexé pour ce dépôt

Évaluation

Cette issue n'a pas encore été évaluée.

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.