liquibase.sqlgenerator.ext.GetViewDefinitionGeneratorHanaDB Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of liquibase-hana Show documentation

Liquibase support for SAP Hana DB

The newest version!

package liquibase.sqlgenerator.ext;

import liquibase.database.Database;
import liquibase.database.ext.HanaDBDatabase;
import liquibase.sql.Sql;
import liquibase.sql.UnparsedSql;
import liquibase.sqlgenerator.SqlGeneratorChain;
import liquibase.sqlgenerator.core.GetViewDefinitionGenerator;
import liquibase.statement.core.GetViewDefinitionStatement;

public class GetViewDefinitionGeneratorHanaDB extends GetViewDefinitionGenerator {

    @Override
    public int getPriority() {
        return PRIORITY_DATABASE;
    }

    @Override
    public boolean supports(GetViewDefinitionStatement statement, Database database) {
        return database instanceof HanaDBDatabase;
    }

    @Override
    public Sql[] generateSql(GetViewDefinitionStatement statement, Database database, SqlGeneratorChain sqlGeneratorChain) {
        if (!supports(statement, database)) {
            return sqlGeneratorChain.generateSql(statement, database);
    	}

        String condSchemaColumn = (statement.getSchemaName() == null) ?  "" : " upper(SCHEMA_NAME)='" + statement.getSchemaName().toUpperCase() + "' AND";
        String condViewNameColumn = " upper(VIEW_NAME)='" + statement.getViewName().toUpperCase() + "'";
        
    	return new Sql[] {
    	    new UnparsedSql("SELECT DEFINITION FROM VIEWS WHERE" + condSchemaColumn + condViewNameColumn )
    	};
    }

}