Skip to content

medisysco/medisys-dbms-change

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

All of the projects of Medical Systems Co. are mavenized, It's a maven POM project for Database Migration on top of Java using Liquibase. This project develop to knowledge share of Liquibase migration process forIHE Team. It will be package as JAR. The immediate child projects of the medisys-dbms-change are able to access all of the properties, dependencies as well as profiles by following way:

<dependency>
    <artifactId>medisys-dbms-change</artifactId>
    <groupId>my.com.medisys.dbms</groupId>
    <version>0.0.00.GA</version>
</dependency>

All of the resource and library of Medical Systems Co. permitted to use under considering GPL V3 license. Clone the source code from GitHub at medisys-dbms-change git repository.

git clone git@github.com:medisysco/medisys-dbms-change.git
cd ./medisys-dbms-change

Properties Files

mkdir -p $HOME/.hmis/etc/dbms/liquibase
cp ./src/test/resources/liquibase/*.properties $HOME/.hmis/etc/dbms/liquibase
cd $HOME/.hmis/etc/dbms/liquibase
explorer .

Path Settings

export MYSQL_HOME=/c/opt/xampp/mysql
export PATH=$PATH:$MYSQL_HOME/bin

Database Creation

# execute database creation script for empty password
mysql -uroot < ./src/test/resources/schema/hr_all_ini.sql
# execute database creation script for prompt password in cli
mysql -uroot -p < ./src/test/resources/schema/hr_all_ini.sql

Import Dump

# import hr_dev_bas_ini.sql dump into hr_dev from cli
mysql -uroot hr_dev < ./src/test/resources/schema/hr_dev_bas_ini.sql
# import hr_dev_bas_ini.sql dump into hr_dev & prompt password from cli
mysql -uroot -p hr_dev < ./src/test/resources/schema/hr_dev_bas_ini.sql

Maven Commands

mvn clean install -Pdev,log
mvn clean install -Pdev,syn
mvn clean install -Pdev,upd
mvn clean install -Pdif

mvn clean install -Pqac,syn
mvn clean install -Pqac,upd

mvn clean install -Puat,syn
mvn clean install -Puat,upd

mvn clean install -Ppro,syn
mvn clean install -Ppro,upd

mvn clean install -Ppro,del
mvn clean install -Ppro,rol -Dmedisys.tag=20180806

You may use Epoch Converter for UTC Time Stamp Standard Id, Here is the maven repository of this project. add the repository to .m2 settings.xml or pom.xml.

<server>
  <id>medisys.snapshots</id>
  <configuration>
      <httpHeaders>
        <property>
          <name>Authorization</name>
          <value>Basic bWF2ZW46bWF2ZW4=</value>
        </property>
      </httpHeaders>
  </configuration>
</server>

<repository>
    <id>medisys.releases</id>
    <url>http://mvn.medisys.com.my/m2/snapshots/</url>
    <releases>
        <enabled>true</enabled>
    </releases>
    <snapshots>
        <enabled>false</enabled>
    </snapshots>
</repository>

LICENSE

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is furnished
to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
THE SOFTWARE.

Medisys is the short form of Medical Systems Co. is a Riyadh based company which provides full range offers through HMIS (Health Management Information Systems) starting from analysing requirements, development, application delivery and full range of support for user adaptations. The evolution and migration to Oracle 10g database and RAC from previous architecture gave Medisys's HMIS (Hospital Management Information System) location transparency, redundancy and volatility on information management.

About the Founder

Mohamad Al-Sherbini(Sherbini) is the founder of Medical Systems Co.. Azizul Hoque Bhuyan(Aziz) is the Technical Manager as well as founder of Medisys (BD) Ltd and Medisys (MY) Ltd.

About the Project

This project started aim to development HL7 Interoperability/Integration to add feature on HMIS (Hospital Management Information System). This project developed by java EE with Apache Camel ESB and OpeneHealth IPF Tools. Md Shahed Hossain(Shahed) is Technical Lead of this project.

Contact