com.agimatec.sql.meta.postgres.PostgresJdbcSqlMetaFactory Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of dbmigrate Show documentation

The newest version!

package com.agimatec.sql.meta.postgres;

import com.agimatec.jdbc.JdbcDatabase;
import com.agimatec.sql.meta.ColumnDescription;
import com.agimatec.sql.meta.checking.JdbcSqlMetaFactory;

/**
 * Description: 

 * User: roman.stumm 

 * Date: 10.03.2008 

 * Time: 10:41:46 

 */
public class PostgresJdbcSqlMetaFactory extends JdbcSqlMetaFactory {
    public PostgresJdbcSqlMetaFactory(JdbcDatabase database) {
        super(database);
    }

    @Override
    /**
     * equalize type names: jdbcdriver -> sql-script-type-name
     * @param cd - contains the type name returned by the JdbcDriver
     **/
    public void equalizeColumn(ColumnDescription cd) {
        super.equalizeColumn(cd);
        if (cd.getTypeName().equalsIgnoreCase("int8")) {
            cd.setTypeName("BIGINT");
        } else if (cd.getTypeName().equalsIgnoreCase("int4")) {
            cd.setTypeName("INTEGER");
        } else if (cd.getTypeName().equalsIgnoreCase("timestamp")) {
            cd.setPrecision(0);
            cd.setPrecisionEnabled(false);
        } else if (cd.getTypeName().equalsIgnoreCase("int2")) {
            cd.setTypeName("SMALLINT");
        } else if (cd.getTypeName().equalsIgnoreCase("bpchar")) {
            cd.setTypeName("CHARACTER");
        } else if (cd.getTypeName().equalsIgnoreCase("bool")) {
            cd.setTypeName("BOOLEAN");
        } else if (cd.getTypeName().equalsIgnoreCase("time")) {
            cd.setPrecisionEnabled(false);
            cd.setPrecision(0);
        } else if(cd.getTypeName().equalsIgnoreCase("timestamptz")) {
            cd.setPrecision(0);
        } else if(cd.getTypeName().equalsIgnoreCase("timetz")) {
            cd.setPrecision(0);
        }
    }

    @Override
    protected TableIdentifier createTableIdentifier(String table) {
        return super.createTableIdentifier(table.toLowerCase());
    }

}