private async Task <Pipeline.Admin.IDataStreamConnector> GetConnector(DataStream stream)
{
var connector = new DataStreamConnectors.SQLServerConnector(new Logging.Loggers.InstanceLogger(new Utils.LogWriter(), "HOSTID", "1234", "INSTID"));
Assert.IsTrue((await connector.InitAsync(stream)).Successful, "Invalid table schema");
return(connector);
}
public async Task DataStream_SQLServer_CouldNotOpenDB_DoesNotExists_Invalid()
{
var stream = GetValidStream();
stream.DbName = "does not exist";
var connector = new DataStreamConnectors.SQLServerConnector(new Logging.Loggers.InstanceLogger(new Utils.LogWriter(), "HOSTID", "1234", "INSTID"));
AssertInvalidError((await connector.InitAsync(stream)), @"Could not access SQL Server: Cannot open database ""does not exist"" requested by the login. The login failed.
Login failed for user 'nuviotadmin'.");
}
public async Task SQLServer_TableDoesNotExistOnDB_Invalid()
{
var stream = GetValidStream();
var oldName = stream.DBTableName;
stream.DBTableName = "does not exist";
var connector = new DataStreamConnectors.SQLServerConnector(new Logging.Loggers.InstanceLogger(new Utils.LogWriter(), "HOSTID", "1234", "INSTID"));
AssertInvalidError((await connector.InitAsync(stream)), "Table [does not exist] name not found on SQL Server database [UnitTestDB] on server [nuviot-dev.database.windows.net.");
stream.DBTableName = oldName;
}
private async Task <Pipeline.Admin.IDataStreamConnector> GetConnector(DataStream stream)
{
var connector = new DataStreamConnectors.SQLServerConnector(new Logging.Loggers.InstanceLogger(new Utils.LogWriter(), "HOSTID", "1234", "INSTID"));
var validation = (await connector.InitAsync(stream));
foreach (var err in validation.Errors)
{
Console.WriteLine(err.Message);
}
Assert.IsTrue(validation.Successful, "Invalid table schema");
return(connector);
}
