liquibase.database.ext.MySqlDatabase Maven / Gradle / Ivy
// 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;
}
}