The list of things to be changed in OpenSpecimen when moving the production database to the test environment.

Data directory

The data directory contains files like JSON files, bulk import reports, consents/spr files, files uploaded via Forms controls, etc. Therefore whole data directory should be copied from prod to test.

...

• Application URL: This should be configured to test application URL.

• Deployment environment: This should be changed to 'TEST'.

• Data directory: This should be configured to the physical location of the test server data directory.

...

SAML Configuration

If LDAP / SAML is configured on the test server then following needs to be ensured in the test environment

1. Following tables should not be refresh or should not be touched: os_auth_domains, os_auth_providers, os_auth_provider_props.

   1. Alternatively, these tables need to be copied before the refresh and restored after the refresh process.

2. The $OS_DATA_DIR/saml directory should not be touched or copied from the prod environment.