yu000hong/db-compare-plugin

A gradle plugin for database comparison

Download

Step 1. Add the JitPack repository to your build file

Add it in your root settings.gradle at the end of repositories:

	dependencyResolutionManagement {
		repositoriesMode.set(RepositoriesMode.FAIL_ON_PROJECT_REPOS)
		repositories {
			mavenCentral()
			maven { url 'https://jitpack.io' }
		}
	}

Add it in your settings.gradle.kts at the end of repositories:

	dependencyResolutionManagement {
		repositoriesMode.set(RepositoriesMode.FAIL_ON_PROJECT_REPOS)
		repositories {
			mavenCentral()
			maven { url = uri("https://jitpack.io") }
		}
	}

Add to pom.xml

	<repositories>
		<repository>
		    <id>jitpack.io</id>
		    <url>https://jitpack.io</url>
		</repository>
	</repositories>

Add it in your build.sbt at the end of resolvers:

 
    resolvers += "jitpack" at "https://jitpack.io"

Add it in your project.clj at the end of repositories:

 
    :repositories [["jitpack" "https://jitpack.io"]]

Step 2. Add the dependency

	dependencies {
		implementation 'com.github.yu000hong:db-compare-plugin:1.0.5'
	}
	dependencies {
		implementation("com.github.yu000hong:db-compare-plugin:1.0.5")
	}
	<dependency>
	    <groupId>com.github.yu000hong</groupId>
	    <artifactId>db-compare-plugin</artifactId>
	    <version>1.0.5</version>
	</dependency>

                            
    libraryDependencies += "com.github.yu000hong" % "db-compare-plugin" % "1.0.5"
        
        

                            
    :dependencies [[com.github.yu000hong/db-compare-plugin "1.0.5"]]

Readme

db-compare-plugin

db-compare-plugin is a gradle plugin for database comparison. Because it compares database metadata through JDBC, so it can compare different databases. However, it can only compare the common parts of these databases.

Usage

build.gradle

buildscript {
    repositories {
        mavenCentral()
        maven {
            url 'https://jitpack.io'
        }
    }
    dependencies {
        classpath 'com.github.yu000hong:db-compare-plugin:1.0.5'
        classpath 'mysql:mysql-connector-java:5.1.18'
    }
}

apply plugin: 'com.github.yu000hong.dbcompare'

dbCompareConfig{
    testUrl = 'jdbc:mysql://localhost:3306/test'
    testUser = 'root'
    testPasswd = 'root'
    prodUrl = 'jdbc:mysql://localhost:3306/prod'
    prodUser = 'root'
    prodPasswd = 'root'
    driver = 'com.mysql.jdbc.Driver'
    tables = '*'
}

Execute

$> gradle dbCompare

Output

If there is no difference between two databases, then no output. Or, the output will look like as follow:

 --------------------------------------------------------------------------
     TABLE                       TEST                    PROD
 --------------------------------------------------------------------------
     account                     -                       +
 --------------------------------------------------------------------------
     article                     -                       +
 --------------------------------------------------------------------------
     comment                     +                       -
 --------------------------------------------------------------------------
     message
       F:XCID                    +                       -
       F:COMMENT_ID              VARCHAR(30) NOT NULL    VARCHAR(30) NULL
       I:INDEX_XCID_ARTICLEID    -                       +
 --------------------------------------------------------------------------