public void should_MySQL_VerifyConnection()
{
TestInitializer.InitDbMySql();
var databaseProtocol = TestInitializer.IQtoolsDbProtocol;
var connected = _databaseManager.VerifyConnection(databaseProtocol);
Assert.True(connected);
Console.WriteLine($"connection OK:[{databaseProtocol}] | {databaseProtocol.DatabaseType}");
}
public void should_MySQL_GetConnection()
{
TestInitializer.InitDbMySql();
var databaseProtocol = TestInitializer.IQtoolsDbProtocol;
var connection = _databaseManager.GetConnection(databaseProtocol);
Assert.NotNull(connection);
Console.WriteLine($"connections Found:[{connection.ConnectionString}] | {databaseProtocol.DatabaseType}");
}
public void should_Verify_MySQL_Query()
{
TestInitializer.InitDbMySql();
var extract = Builder <Extract> .CreateNew().Build();
extract.ExtractSql = @"SELECT * FROM psmart_store";
var databaseProtocol = TestInitializer.KenyaEmrDbProtocol;
var verified = _databaseManager.VerifyQuery(extract, databaseProtocol);
Assert.True(verified);
Console.WriteLine($"{extract} query [{extract.ExtractSql}] OK | {databaseProtocol.DatabaseType}");
}