public void TestCollectsAllVersionsFromAssembly()
{
DBVersionRepository repo = new DBVersionRepository()
.AddVersions(typeof(TestDBVersionSystem).Assembly)
;
Assert.AreEqual(1, repo.VersionsTable.Count);
}
public void TestExecutesDBVersions()
{
DBVersionRepository repo = new DBVersionRepository()
.AddVersions(typeof(TestDBVersionSystem).Assembly)
;
new DBVersionSystem(new DBVersionRepository().AddVersions(typeof(TestDBVersionsFile).Assembly)).UpdateToNewest();
using (IConnection con = new ConnectionCollector().GetConnection())
{
// DB Version was executed?
IDataReader reader = con.ExecuteReader("SELECT COUNT(*) FROM TROL_TEST");
Assert.IsTrue(reader.Read());
Assert.AreEqual(1, reader.GetInt32(0));
// Version number was written?
Assert.AreEqual(1, DBVersionSystem.GetCurrentVersion());
// DB version information is written corretly (was bug, which duplicated lines)
reader = con.ExecuteReader("SELECT COUNT(*) FROM DB_VERSION");
Assert.IsTrue(reader.Read());
Assert.AreEqual(1, reader.GetInt32(0));
}
}
