Migration for Java - Ideas

CriaUsuarios_16082012_084830_jrdalpra.java

import static test.DataBaseField.DataBaseTypes.LONG;
import static test.DataBaseField.DataBaseTypes.STRING;
import static test.DatabaseCommands.createSequence;
import static test.DatabaseCommands.createTable;
import static test.DatabaseCommands.dropSequence;
import static test.DatabaseCommands.dropTable;
import static test.DatabaseCommands.sql;
import lombok.experimental.ExtensionMethod;
import test.DatabaseCommand;
import test.Migration;

// @ManagedBean <-- usar com CDI
// @Enviroment(Enviroments.TEST) <-- definir migrations que devem ser executadas apenas em alguns ambientes
@ExtensionMethod({ Migrations.Language.class })
public class CriaUsuarios_16082012_084830_jrdalpra implements Migration {

    @Override
    public DatabaseCommand[] up() {
        return new DatabaseCommand[] {
                createSequence(SEQ_USUARIOS()).startWith(2).incrementBy(1),
                createTable(USUARIO()).columns("id".as(LONG).primary("pk_usuario"),
                                               "login".as(STRING).length(255).unique("uk_usuario_login"),
                                               "senha".as(STRING).length(20)),
                sql(INSERT_USUARIO()).set(1, 1).set(2, "admin").set(3, "admin")
        };

    }

    @Override
    public DatabaseCommand[] down() {
        return new DatabaseCommand[] {
                dropTable(USUARIO()),
                dropSequence(SEQ_USUARIOS())
        };
    }

    private String USUARIO() {
        return "usuario";
    }

    private String SEQ_USUARIOS() {
        return "SEQ_USUARIO";
    }

    private String INSERT_USUARIO() {
        return "insert into usuario (id,login,senha) values (?,?,?)";
    }

}

Migrations.java

import test.DataBaseField;

public class Migrations {
    public static class Language {
        public static DataBaseField as(String name, DataBaseField.DataBaseTypes type) {
            return new DataBaseField(name).as(type);
        }
    }
}