Generate Database Types

dbdatatypes.groovy

@Grab('org.liquibase:liquibase-core:3.5.1')

import liquibase.database.core.*
import liquibase.datatype.core.*

def datatypes = [BooleanType,TinyIntType,SmallIntType,IntType,BigIntType,
                 FloatType,DoubleType,DecimalType,NumberType,
                 CharType,VarcharType,NCharType,NVarcharType,
                 DateTimeType,TimeType,TimestampType,DateType,
                 ClobType,BlobType,UUIDType]
def databases = [MySQLDatabase, SQLiteDatabase, OracleDatabase, PostgresDatabase]

def mappings = [
'tinyint': 'byte',
'smallint': 'short',
'bigint': 'long',
'varchar': 'string',
'nvarchar': 'unicode',
'blob': 'binary',
'clob': 'text'
]

databases.each {
    println "$it.simpleName"
    datatypes.each { dt ->
        def datatype = dt.newInstance()
        datatype.finishInitialization("")

        if (mappings["$datatype.name"]) {
           print mappings["$datatype.name"] + ": "
        } else {
            print "$datatype.name: "
        }
        println "${datatype.toDatabaseDataType(it.newInstance())}"
    }
    println ''
}