liquibase.database.ext.MySqlDatabase Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of kualigan-lb-extensions Show documentation

Extensions to liquibase that make it more database agnostic

There is a newer version: 2.0.1

Show newest version

// Copyright 2011 Leo Przybylski. All rights reserved.
//
// Redistribution and use in source and binary forms, with or without modification, are
// permitted provided that the following conditions are met:
//
//    1. Redistributions of source code must retain the above copyright notice, this list of
//       conditions and the following disclaimer.
//
//    2. Redistributions in binary form must reproduce the above copyright notice, this list
//       of conditions and the following disclaimer in the documentation and/or other materials
//       provided with the distribution.
//
// THIS SOFTWARE IS PROVIDED BY  ''AS IS'' AND ANY EXPRESS OR IMPLIED
// WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
// FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL  OR
// CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
// CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
// SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
// ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
// NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
// ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
//
// The views and conclusions contained in the software and documentation are those of the
// authors and should not be interpreted as representing official policies, either expressed
// or implied, of Leo Przybylski.
package liquibase.database.ext;

import liquibase.exception.DatabaseException;

import static liquibase.ext.Constants.EXTENSION_PRIORITY;

/**
 * Overridden to replace all schema instances with "" when getting view definitions. The purpose is to make it schema non-specific
 *
 * @author Leo Przybylski (leo [at] rsmart.com
 */
public class MySqlDatabase extends liquibase.database.core.MySQLDatabase {

    public int getPriority() {
        return EXTENSION_PRIORITY;
    }

    @Override
    public String getViewDefinition(String schemaName, String viewName) throws DatabaseException {
        String retval = super.getViewDefinition(schemaName, viewName);
        final String schemaStr = String.format("`%s`.", schemaName);
        retval = retval.replaceAll(schemaStr.toLowerCase(), "");
        retval = retval.replaceAll(schemaStr.toUpperCase(), "");
        return retval;
    }
}