@Before public void setUp() throws Exception { file.delete(); db.start(); connection = db.getConnection(); }
@Test public void whenDatabaseIsUpgradedTheVersionIsIncremented() throws Exception { db.shutdown(); db = new FileDatabaseVersion2(file); db.start(); connection = db.getConnection(); long dbVersion = db.getCurrentVersion(); assertThat(dbVersion, is(equalTo(db.getSoftwareVersion()))); }
@Test public void schemaCreationIsNotRunWhenDatabaseExists() throws Exception { db.shutdown(); db.start(); connection = db.getConnection(); // Would throw an exception if the table didn't exist QueryPreparedStatementWrapper prepareQueryStatement = connection.prepareQueryStatement("SELECT * FROM testtable"); try { prepareQueryStatement.execute(); } finally { DatabaseUtil.close(prepareQueryStatement); } }
@Test public void upgradeScriptsRunWhenDatabaseIsOlderVersion() throws Exception { db.shutdown(); db = new FileDatabaseVersion2(file); db.start(); connection = db.getConnection(); // Would throw an exception if the table didn't exist QueryPreparedStatementWrapper prepareQueryStatement = connection.prepareQueryStatement("SELECT * FROM version2table"); try { prepareQueryStatement.execute(); } finally { DatabaseUtil.close(prepareQueryStatement); } }
@After public void tearDown() throws Exception { db.shutdown(); }