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