public async Task CanModifyATable() { using (var cn = GetConnection()) { var init = new DbInitialiser(cn, null); await init.InitialiseDatabase(new IMigration[] { new Migration201(), new Migration202() }); } using (var cn = GetConnection()) { var init = new DbInitialiser(cn, null); var columnNames = init.GetColumnNames("Person"); Assert.AreEqual(4, columnNames.Length); } }
public async Task CanInitializeADatabase() { using (var cn = GetConnection()) { var init = new DbInitialiser(cn, this.GetType().Assembly); await init.InitialiseDatabase(); } using (var cn = GetConnection()) { var init = new DbInitialiser(cn, this.GetType().Assembly); var tables = init.GetTableNames(); Assert.IsTrue(tables.Contains("Person")); Assert.IsTrue(tables.Contains("Stuff")); } }
public async Task CanSeedADatabase() { using (var cn = GetConnection()) { var init = new DbInitialiser(cn, null); await init.InitialiseDatabase(new IMigration[] { new Migration101() }); } using (var cn = GetConnection()) { var people = cn.Query <Migration101.Person>("SELECT * FROM Person"); Assert.AreEqual(2, people.Count); var stuff = cn.Query <Migration101.Stuff>("SELECT * FROM Stuff"); Assert.AreEqual(4, stuff.Count); } }