Overview
This page documents the use of admin tools to run quality assurance script against the data.
Prerequisites
- MySQL database must already exist (e.g. "refset").
- MySQL database connection parameters must be defined in the properties file specified by "refset.config".
- The file system directory specified by the "hibernate.search.default.indexBase" in the properties file specified by refset.config must exist.
- IMPORTANT: The Tomcat server must not be running while this is invoked, otherwise indexes can get corrupted.
Details
This tool is used to validate data states in the database. The tool runs a series of SQL queries to validate certain aspects of referential integrity or data quality that are not easily validated by unique or foreign key constraints. The tool is currently configured without any such queries.
Following are some details about the implementation of this tool:
Mojo: QaDatabase.java (in admin/src/main/resources/java/org/ihtsdo/otf/refset/mojo)
Project: admin
Configuration Parameters
- Profile "Database"
refset.config - the standard configuration file specified as a -D parameter
Samples
Sample command line call of the admin tool to recreate a database, clear indexes, and load sample data:
% cd /home/ihtsdo/refset/code/admin % mvn install -PDatabase -Drefset.config=/home/ihtsdo/refset/config/config.properties
Troubleshooting
If the script reports errors, the underlying data conditions should be fixed.
References/Links
- n/a