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

@Override
public void initialize(UimaContext context)
        throws ResourceInitializationException {
    super.initialize(context);
    Base.open("com.mysql.jdbc.Driver", "jdbc:mysql://" + db_connection[0]
            + "/" + db_connection[1] + "", db_connection[2],
            db_connection[3]);
    processed = 0;
    inserted = 0;
}
 

public void givenSavedProduct_WhenFindFirst_ThenSavedProductIsReturned() {
    //Open DB connection
    Base.open("com.mysql.jdbc.Driver", "jdbc:mysql://localhost/dbname", "user", "password");

    //Create a product and save it
    Product toSaveProduct = new Product();
    toSaveProduct.set("name", "Bread");
    toSaveProduct.saveIt();

    //Find product
    Product savedProduct = Product.findFirst("name = ?", "Bread");

    Assert.assertEquals(toSaveProduct.get("name"), savedProduct.get("name"));
}
 

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();
    }
}
 

@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/");
}
 

public static final void dbInit() {
    Base.open(hikariDataSource); // get connection from pool
}
 

public static void connect(String[] db_connection) {
    Base.open("com.mysql.jdbc.Driver", "jdbc:mysql://" + db_connection[0]
            + "/" + db_connection[1] + "", db_connection[2],
            db_connection[3]);
}
 

public static void main(String[] args){
    DBConfiguration.loadConfiguration("/database.properties");
    Base.open();
}
 

protected static void before() throws SQLException {
    Base.open(driver(), url(), user(), password());
    tryGenSchema();
    Base.connection().setAutoCommit(false);
}
 

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());
}
 

/**
 * @param root open connection to root URL
 */
protected void openConnection(boolean root){
    String url = root? DbUtils.extractServerUrl(getUrl()): getUrl();
    Base.open(getDriver(), url, getUsername(), getPassword());
}
 

@Before
public void setup() throws Exception {
    Base.open("org.h2.Driver", "jdbc:h2:mem:h2-migration-test;DB_CLOSE_DELAY=-1", "sa", "");
    migrationManager = new MigrationManager("src/test/resources/test_migrations/h2/");
}
 

@Before
public void setup() {
    strategy = new VersionStrategy();
    Base.open("org.h2.Driver", "jdbc:h2:mem:h2-migration-test;DB_CLOSE_DELAY=-1", "sa", "");
    try {exec("drop table " + VersionStrategy.VERSION_TABLE);} catch (Exception e) {/* ignore*/}
}
 

@Before
public void setup() throws Exception {
    Base.open("org.hsqldb.jdbcDriver", "jdbc:hsqldb:file:./target/tmp/hsql-migration-test", "sa", "");
    migrationManager = new MigrationManager("src/test/resources/test_migrations/hsql/");
}