public async Task ConstructorAndPropertiesTests() { try { new SqlDBManager(null, _sqlFile); Assert.Fail("Should have thrown"); } catch (ArgumentNullException) { } try { new SqlDBManager(DBName, null); Assert.Fail("Should have thrown"); } catch (ArgumentNullException) { } try { new SqlDBManager(DBName, "blah"); Assert.Fail("Should have thrown"); } catch (ArgumentException) { } var sdc = new SqlDBManager(DBName, _sqlFile); Assert.IsNotNull(sdc); Assert.IsTrue(await SqlDBManager.DBExistsAsync(DBName)); }
public async Task DBExistsTest() { Assert.IsFalse(await SqlDBManager.DBExistsAsync(DBName)); await Setup(); Assert.IsTrue(await SqlDBManager.DBExistsAsync(DBName)); }
public async Task ExecuteNonQueryTest() { await Setup(); Assert.AreEqual(5, await SqlDBManager.ExecuteScalarAsync("SELECT COUNT(*) FROM Diagnosis;")); Assert.AreEqual(1, await SqlDBManager.ExecuteNonQueryAsync("INSERT INTO Diagnosis ( DiagnosisID , DiagnosisDescription )VALUES ( 6 , 'Test Diagnosis 6' );")); Assert.AreEqual(6, await SqlDBManager.ExecuteScalarAsync("SELECT COUNT(*) FROM Diagnosis;")); }
public async Task ExecuteReaderTest() { await Setup(); var table = await SqlDBManager.ExecuteReaderAsync("SELECT * FROM DiagnosisCategory;"); Assert.IsNotNull(table); Assert.AreEqual(3, table.Rows.Count); }
public async Task CreateDropDBTest() { Assert.IsFalse(await SqlDBManager.DBExistsAsync(DBName)); await SqlDBManager.CreateDBAsync(DBName, _sqlFile); Assert.IsTrue(await SqlDBManager.DBExistsAsync(DBName)); await SqlDBManager.DropDBAsync(DBName); Assert.IsFalse(await SqlDBManager.DBExistsAsync(DBName)); }
public async Task MiscQueryTest(string query, params string[] expected) { await Setup(); var result = await SqlDBManager.ExecuteReaderAsync(query); for (var i = 0; i < expected.Length; i++) { Assert.AreEqual(expected[i], result.Rows[0][i].ToString()); } }
public async Task ExecuteScalarTest() { await Setup(); Assert.AreEqual(3, await SqlDBManager.ExecuteScalarAsync("SELECT COUNT(*) FROM DiagnosisCategory;")); }
private async Task Setup() { await SqlDBManager.CreateDBAsync(DBName, _sqlFile); }
public async Task TearDown() { await SqlDBManager.DropDBAsync(DBName); }