Overview

This page documents the use of admin tools to create or update a DB schema.

This admin tool is used to create the schema (for a new installation) or update it (for a deployment of updated model objects).

Prerequisites

For this mojo to run, a MySQL database must already exist (e.g. "mappingservicedb").

Additionally the DB connection parameters must be defined in the properties file specified by "run.config".

Details

This tool is used to create an initial DB schema, or update the schema upon code changes to add or change existing fields.  NOTE: fields that get removed are not handled by this process.  The default mode is "update" is it does not destroy data. This can be overridden by running with "-Dhibernate.hbm2ddl.auto=create"

Following are some details about the implementation of this tool:

Mojo: UpdateDbMojo.java (in admin/mojo/src/main/resources/java/org/ihtsdo/otf/mapping/mojo)

Project: admin/updatedb

Configuration Parameters

• run.config - the standard configuration file specified as a -D parameter
• hibernate.hbm2ddl.auto - defaulted to "update" can be used with "create" for an initial creation.

Samples

% cd ~/code/admin/updatedb
% mvn -Dhibernate.hbm2ddl.auto=create -Drun.config=/home/ihtsdo/data/config.properties install

% cd ~/code/admin/updatedb
% mvn -Drun.config=/home/ihtsdo/data/config.properties install