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