[Referential integrity constraints missing]Validate the Backup, Restore mechanisms in Bahmni

Description

  1. Having seen the Constraints missing in OpenMRS database, we need to validate that our Back up and restore mechanisms are getting the database schema along with Constraints.

  1. Angshu : if you see there are constraints defined in “bed_location_map” and not on “obs” - take a dump like we do during backup - and on a different machine restore that (like we do in restore)

Default openmrs database dump which has integrity constraint issues ->
https://github.com/Bahmni/emr-functional-tests/blob/master/dbdump/openmrs_backup.sql.gz
Base/Clean openmrs database dump which has all constraints ->
https://github.com/Bahmni/bahmni-package/blob/master/openmrs/resources/openmrs_clean_dump.sql

Status

Assignee

Unassigned

Reporter

Swathi Varkala

Labels

None

Units

None

PercentDone

None

DueTime

None

Clients

None

External issue ID

None

UAT Assignee

None

Reviewer

None

Sprint

Fix versions