liquibase.sqlgenerator.ext.TruncHandler 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

package liquibase.sqlgenerator.ext;

import java.util.regex.Matcher;
import java.util.regex.Pattern;

import liquibase.logging.LogFactory;

public class TruncHandler implements SqlMappingHandler {
    protected static Pattern PATTERN = Pattern.compile("TRUNC\\(([^\\)]*)\\)");
    
    @Override
    public boolean matches(final StringBuffer sql) {
	return PATTERN.matcher(sql.toString()).find();
    }
    
    @Override
    public void translate(final StringBuffer queryBuffer) {	    
	final Matcher matcher = PATTERN.matcher(queryBuffer.toString());
	while (matcher.find()) {
	    String translation = matcher.group(1);
	    info("Found a match. Translated to " + translation);
	    if (translation.equalsIgnoreCase("SYSDATE")) {
		translation = "NOW()";
	    }
	    queryBuffer.replace(matcher.start(), matcher.end(), translation);
	}
    }

    protected void info(final String message) {
	LogFactory.getLogger().info(message);
    }

    protected void debug(final String message) {
	LogFactory.getLogger().debug(message);
    }
}