Smoke Testing: Database

Database

On the machine that hosts the database:

Backup

• Run python scripts/mysql_dump/reset_database_post_cycle.py selecting backup and supplying the credentials for the database you want to reset (when prompted) in the terminal. Note the default database is localhost:3306.
• Check the backup file has been generated at C:\database_backup\cycle_xx_x\cycle_xx_x.sql

Remove

• Run python scripts/mysql_dump/reset_database_post_cycle.py selecting wipe and supplying the credentials for the database you want to reset (when prompted) in the terminal. Note the default database is localhost:3306.

• Check the database to ensure that the tables are empty:

reduction_viewer_datalocation
reduction_viewer_experiment
reduction_viewer_notification
reduction_viewer_reductionrun
reduction_viewer_reductionlocation
reduction_viewer_setting
reduction_variables_instrumentvariable
reduction_variables_runvariable
reduction_variables_variable

validate

• Submit one run per instrument - This is to ensure all the options are valid on the webapp

python scripts/manual_submission/manual_submission <INST> <run_number>