MigrateTest.java

package net.lr.tutorial.db;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.h2.jdbcx.JdbcDataSource;
import org.junit.Assert;
import org.junit.Test;

import net.lr.tutorial.db.migration.Migrator;


public class MigrateTest {

    @Test
    public void testMigrate() throws SQLException {
        JdbcDataSource ds = new JdbcDataSource();
        ds.setUrl("jdbc:h2:mem:person;DB_CLOSE_DELAY=-1");
        new Migrator().prepare(ds);
        try (Connection con = ds.getConnection()) {
            testQuery(con);
        }
    }

    private void testQuery(Connection con) throws SQLException {
        try (ResultSet rs = con.createStatement().executeQuery("select id, name, age from person")) {
            rs.next();
            Assert.assertEquals(1, rs.getInt(1));
            Assert.assertEquals("Chris", rs.getString(2));
            Assert.assertEquals(29, rs.getInt(3));
        }
    }
}