@Test
public void testEdnParser() throws LiquibaseException {
ResourceAccessor resourceAccessor = new ClassLoaderResourceAccessor();
Connection connection = getH2Connection();
DatabaseConnection databaseConnection = new JdbcConnection(connection);
Liquibase lb = new Liquibase(changeLogFile, resourceAccessor, databaseConnection);
lb.update("");
}
private void liquibaseDropAll(Application application) {
Liquibase liquibase = null;
try {
liquibase = newLiquibase(application);
liquibase.dropAll();
} catch (ClassNotFoundException | LiquibaseException | SQLException ex) {
throw new WervalException("Unable to drop database data: " + ex.getMessage(), ex);
} finally {
closeLiquibaseSilently(liquibase);
}
}
private void liquibaseUpdate(Application application) {
Liquibase liquibase = null;
try {
liquibase = newLiquibase(application);
liquibase.update(EMPTY);
} catch (ClassNotFoundException | LiquibaseException | SQLException ex) {
throw new WervalException("Unable to apply database changelog: " + ex.getMessage(), ex);
} finally {
closeLiquibaseSilently(liquibase);
}
}
private void runLiquibaseUpdate(Connection connection) {
try {
ResourceAccessor resourceAccessor = new ClassLoaderResourceAccessor();
Database database =
DatabaseFactory.getInstance()
.findCorrectDatabaseImplementation(new JdbcConnection(connection));
Liquibase liquibase = new Liquibase(getChangeLogFile(), resourceAccessor, database);
liquibase.update(getContext());
} catch (LiquibaseException e) {
throw new RuntimeException(e);
}
}
public void upgrade() throws IOException, SQLException {
try {
Liquibase liquibase =
new Liquibase(
"liquibase-update-to-latest.xml",
new ClassLoaderResourceAccessor(getClass().getClassLoader()),
liqubaseConnection);
liquibase.update(null);
connection.commit();
} catch (LiquibaseException e) {
throw new IOException(e);
}
}
public void setUp(String contexts) {
try {
ResourceAccessor resourceAccessor = new FileSystemResourceAccessor();
Class.forName("org.hsqldb.jdbcDriver");
holdingConnection = getConnectionImpl();
HsqlConnection hsconn = new HsqlConnection(holdingConnection);
LogFactory.getLogger().setLogLevel("severe");
liquibase = new Liquibase(CHANGE_LOG, resourceAccessor, hsconn);
liquibase.dropAll();
liquibase.update(contexts);
hsconn.close();
} catch (Exception e) {
LOG.error("Error during database initialization", e);
throw new RuntimeException("Error during database initialization", e);
}
}
private void closeLiquibaseSilently(Liquibase liquibase) {
if (liquibase != null) {
try {
liquibase.getDatabase().getConnection().close();
} catch (DatabaseException ignored) {
}
}
}
public void checkSchema(String schema) throws LiquibaseException {
Connection connection = resolveConnection();
ClassLoader classLoader = Thread.currentThread().getContextClassLoader();
ResourceAccessor resourceAccessor = new ClassLoaderResourceAccessor(classLoader);
Database database =
DatabaseFactory.getInstance()
.findCorrectDatabaseImplementation(new JdbcConnection(connection));
Liquibase liquibase = new Liquibase(schema, resourceAccessor, database);
liquibase.forceReleaseLocks();
LOG.info("Comprobando actualizaciones de esquema de BBDD");
liquibase.update("");
LOG.info("Comprobacion de esquema de BBDD finalizada");
try {
connection.close();
} catch (SQLException ignore) {
}
}
@Override
protected void starting(final Description description) {
// ----------------------
// Clear the cache
// ----------------------
try {
context.clearCache();
} catch (NamingException e) {
e.printStackTrace();
throw new Error(e);
}
// --------------------
// Gain liquidbaseList
// --------------------
TestInputSet dataSetAnnnotation =
(TestInputSet) description.getAnnotation(TestInputSet.class);
if (null != dataSetAnnnotation) {
for (String value : dataSetAnnnotation.value()) {
// databaseChangeLogXmlList.add( value );
try {
Liquibase liquibase = new Liquibase(value, new FileSystemResourceAccessor(), database);
liquibaseList.add(liquibase);
} catch (LiquibaseException e) {
e.printStackTrace();
throw new Error(e);
}
}
}
// ----------------------
// Clears all tables
// Fill out tables
// ----------------------
for (Liquibase liquibase : liquibaseList) {
try {
liquibase.update("");
} catch (LiquibaseException e) {
e.printStackTrace();
throw new Error(e);
}
}
}
public void contextInitialized(ServletContextEvent arg0) {
try {
ConfigDBMapper.getInstance().setDefaultConnectionName("fatec");
Connection conn = ConfigDBMapper.getInstance().getDefaultConnection();
Database database =
DatabaseFactory.getInstance().findCorrectDatabaseImplementation(new JdbcConnection(conn));
Liquibase liquibase =
new Liquibase(
"br/com/fatec/aulas/liquibase/changelog-master.xml",
new ClassLoaderResourceAccessor(),
database);
liquibase.forceReleaseLocks();
liquibase.update("fatec");
conn.prepareStatement("COMMIT;").execute();
} catch (Exception e) {
// TODO: handle exception
}
}
@Override
protected void finished(final Description description) {
super.finished(description);
try {
for (Liquibase liquibase : liquibaseList) {
liquibase.rollback(1000, null);
}
} catch (Exception e) {
e.printStackTrace();
throw new Error(e);
} finally {
try {
conn.close();
} catch (Exception f) {
}
}
}
@Override
public void execute() throws BuildException {
super.execute();
Liquibase liquibase = null;
try {
PrintStream writer = createPrintStream();
if (writer == null) {
throw new BuildException("generateChangeLog requires outputFile to be set");
}
liquibase = createLiquibase();
Database database = liquibase.getDatabase();
DiffControl diffControl =
new DiffControl(
getDefaultCatalogName(), getDefaultSchemaName(), null, null, getDiffTypes());
diffControl.setDataDir(getDataDir());
DatabaseSnapshot referenceSnapshot =
DatabaseSnapshotGeneratorFactory.getInstance()
.createSnapshot(database, diffControl, DiffControl.DatabaseRole.REFERENCE);
DiffResult diffResult =
DiffGeneratorFactory.getInstance()
.compare(referenceSnapshot, new DatabaseSnapshot(database), diffControl);
// diff.addStatusListener(new OutDiffStatusListener());
if (getChangeLogFile() == null) {
new DiffToChangeLog(diffResult).print(writer);
} else {
new DiffToChangeLog(diffResult).print(getChangeLogFile());
}
writer.flush();
writer.close();
} catch (Exception e) {
throw new BuildException(e);
} finally {
closeDatabase(liquibase);
}
}
private static void initDB() throws LiquibaseException {
Database database =
DatabaseFactory.getInstance().findCorrectDatabaseImplementation(new JdbcConnection(conn));
// TODO: We should not point to a relative file outside of the project.
liquibase =
new Liquibase(
"../task-management/src/main/resources/db/changelog/db.changelog-1.0.0.xml",
new FileSystemResourceAccessor(),
database);
liquibase.update((String) null);
}
public static void cleanDB() throws Exception {
liquiBase = new Liquibase(changeLogFile, new ClassLoaderResourceAccessor(), jdbcConnection);
liquiBase.dropAll();
}
@Override
protected void doUpdate(Liquibase liquibase) throws LiquibaseException {
liquibase.updateTestingRollback(contexts);
}
public static void closeDB() throws LiquibaseException, SQLException {
liquibase.rollback(1000, null);
conn.close();
}