You can put in a DDL filter to ignore certain tables for table changes too.
See:
http://www.slideshare.net/gr8conf/gorm-burt-beckwith2011
import java.util.ArrayList;
import java.util.List;
import org.codehaus.groovy.grails.orm.hibernate.cfg.GrailsAnnotationConfiguration;
import org.hibernate.HibernateException;
import org.hibernate.dialect.Dialect;
import org.hibernate.dialect.HSQLDialect;
import org.hibernate.tool.hbm2ddl.DatabaseMetadata;
@SuppressWarnings("serial")
public class DdlFilterConfiguration extends GrailsAnnotationConfiguration {
private static final String[] IGNORED_NAMES = { "com.billto",
"com.company", "trk.eqmast", "trk.eqowner", "trk.locprof",
"trk.move", "trk.order" };
@Override
public String[] generateSchemaCreationScript(Dialect dialect)
throws HibernateException {
return prune(super.generateSchemaCreationScript(dialect), dialect);
}
@Override
public String[] generateDropSchemaScript(Dialect dialect)
throws HibernateException {
return prune(super.generateDropSchemaScript(dialect), dialect);
}
@Override
public String[] generateSchemaUpdateScript(Dialect dialect,
DatabaseMetadata databaseMetadata) throws HibernateException {
return prune(
super.generateSchemaUpdateScript(dialect, databaseMetadata),
dialect);
}
private String[] prune(String[] script, Dialect dialect) {
if (dialect instanceof HSQLDialect) {
// do nothing for test env
return script;
}
List<String> pruned = new ArrayList<String>();
for (String command : script) {
if (!isIgnored(command)) {
pruned.add(command);
System.out.println("RUNNING: " + command);
} else {
System.out.println("IGNORING: " + command);
}
}
return pruned.toArray(new String[pruned.size()]);
}
private boolean isIgnored(String command) {
command = command.toLowerCase();
for (String table : IGNORED_NAMES) {
if (command.startsWith("create table " + table + " ")
|| command.startsWith("alter table " + table + " ")
|| command.startsWith("drop table " + table + " ")
|| command.startsWith("drop table if exists" + table + " ")) {
return true;
}
}
return false;
}
}
Locked
