Java Code Examples for org.javalite.activejdbc.Base#close()

public void executeMojo() throws MojoExecutionException {
    getLog().info("Checking " + getUrl() + " using migrations from " + getMigrationsPath());

    List<Migration> pendingMigrations;
    try {
        openConnection();
        MigrationManager manager = new MigrationManager(getMigrationsPath());
        pendingMigrations = manager.getPendingMigrations();
    } catch (Exception e) {
        throw new MojoExecutionException("Failed to check " + getUrl(), e);
    }finally {
        Base.close();
    }

    if (pendingMigrations.isEmpty()) return;

    getLog().warn("Pending migration(s): ");
    for (Migration migration : pendingMigrations)
        getLog().warn("Migration: " + migration.getName());

    getLog().warn("Run db-migrator:migrate to apply pending migrations.");
    throw new MojoExecutionException("Pending migration(s) exist, migrate your db and try again.");
}
 

public void executeMojo() throws MojoExecutionException {
    getLog().info("Validating " + getUrl() + " using migrations from " + getMigrationsPath());
    try {
        openConnection();
        MigrationManager manager = new MigrationManager(getMigrationsPath());
        List<Migration> pendingMigrations = manager.getPendingMigrations();

        getLog().info("Database: " + getUrl());
        getLog().info("Up-to-date: " + pendingMigrations.isEmpty());
        if (!pendingMigrations.isEmpty()) {
            getLog().info("Pending Migrations: ");
            for (Migration migration : pendingMigrations) {
                getLog().info(migration.getName());
            }
        }else{
            getLog().info("No pending migrations found");
        }
    } catch (Exception e) {
        throw new MojoExecutionException("Failed to validate " + getUrl(), e);
    }finally {
        Base.close();
    }
}
 

@Override
public void destroy() {
    try {
        Base.close();
    } catch (Exception e) {
        LOG.warn("could not close conn", e);
    }
}
 

public static void reConnect(String[] db_connection) {
    try {
        Base.close();
    } catch (Exception e) {// nope
    }
    connect(db_connection);
}
 

public static void main( String[] args )
{
    try {
        Base.open();
        ActiveJDBCApp app = new ActiveJDBCApp();
        app.create();
        app.update();
        app.delete();
        app.deleteCascade();
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        Base.close();
    }
}
 

public static void after() {

        try {
            Base.connection().rollback();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        Base.close();
    }
 

public void executeMojo() throws MojoExecutionException {
    getLog().info("Migrating " + getUrl() + " using migrations at " + getMigrationsPath());
    try {
        openConnection();
        new MigrationManager(getMigrationsPath()).migrate(getLog(), getEncoding());
    } catch(SQLException e){
        throw new MojoExecutionException("Failed to migrate database " + getUrl(), e);
    } finally {
        Base.close();
    }
}
 

public void executeMojo() throws MojoExecutionException {
    try {
        String dropSql = blank(getDropSql()) ? "drop database %s" : getDropSql();
        openConnection(true);
        exec(format(dropSql, DbUtils.extractDatabaseName(getUrl())));
        getLog().info("Dropped database " + getUrl());
    } finally {
        Base.close();
    }
}
 

@Before
public void setup() throws Exception {

    Base.open(driver(), url(), user(), password());
    try {
        exec("drop database mysql_migration_test");
    } catch (Exception e) {/*ignore*/}
    exec("create database mysql_migration_test");
    Base.close();
    Base.open(driver(), "jdbc:mysql://localhost/mysql_migration_test", user(), password());
    migrationManager = new MigrationManager("src/test/resources/test_migrations/mysql/");
}
 

@After
public void tearDown() throws Exception {
    try {
        exec("drop database mysql_migration_test");
    } catch (Exception e) {/*ignore*/}
    Base.close();
}
 

public static final void dbClose() {
    Base.close();
}
 

private void run(String dir, String val) throws IOException, InterruptedException {
    // drop
    execute(dir, "db-migrator:drop");

    // create database
    String output = execute(dir, "db-migrator:create");
    the(output).shouldContain("Created database jdbc:mysql://localhost/test_project");
    the(output).shouldContain("BUILD SUCCESS");

    // migrate
    output = execute(dir, "db-migrator:migrate");
    the(output).shouldContain("BUILD SUCCESS");

    if(val != null){
        the(output).shouldContain(val);
    }

    Base.open(driver(), "jdbc:mysql://localhost/test_project", user(), password());
    the(countRows("books")).shouldBeEqual(9);
    the(countRows("authors")).shouldBeEqual(2);
    Base.close();

    // drop, create and validate
    output = execute(dir, "db-migrator:drop");
    the(output).shouldContain("Dropped database jdbc:mysql://localhost/test_project");
    the(output).shouldContain("BUILD SUCCESS");

    output = execute(dir, "db-migrator:create");
    the(output).shouldContain("Created database jdbc:mysql://localhost/test_project");
    the(output).shouldContain("BUILD SUCCESS");

    output = execute(dir, "db-migrator:validate");
    the(output).shouldContain("BUILD SUCCESS");

    // now migrate and validate again
    output = execute(dir, "db-migrator:migrate");
    the(output).shouldContain("BUILD SUCCESS");

    output = execute(dir, "db-migrator:validate");
    the(output).shouldContain("No pending migrations found");
    the(output).shouldContain("BUILD SUCCESS");

    // creation of new migration
    execute(dir, "db-migrator:new", "-Dname=add_people");
    File migrationsDir = new File(dir, "src/migrations");
    String migrationFile = findMigrationFile(migrationsDir, "add_people");
    assertNotNull(migrationFile);
    assertTrue(new File(migrationsDir, migrationFile).delete());
}
 

@After
public void tearDown(){
    Base.close();
}
 

@After
public void tearDown() {
    Base.close();
}
 

@After
public void tearDown() throws Exception {
    Base.close();
}