public void Execute_Args_ParametersAssigned()
{
var resolver = new ExternalFileQueryResolver(BuildArgs());
var query = resolver.Execute();
Assert.That(query.Parameters, Has.Count.EqualTo(1));
}
public void Execute_Args_CommandTextAssigned()
{
var resolver = new ExternalFileQueryResolver(BuildArgs());
var query = resolver.Execute();
Assert.That(query.Statement, Is.EqualTo("select * from myTable;"));
}
public void Execute_Args_CommandInstantiated()
{
var resolver = new ExternalFileQueryResolver(BuildArgs());
var cmd = resolver.Execute();
Assert.That(cmd, Is.Not.Null);
}
public void Execute_Args_ConnectionStringAssigned()
{
var resolver = new ExternalFileQueryResolver(BuildArgs());
var query = resolver.Execute();
Assert.That(query.ConnectionString, Is.Not.Null.And.Not.Empty);
Assert.That(query.ConnectionString, Is.EqualTo(ConnectionStringReader.GetSqlClient()));
}
public void Execute_InvalidPath_ThrowExternalDependency()
{
var args = new ExternalFileQueryResolverArgs(
@"NotExistingFile.sql",
ConnectionStringReader.GetSqlClient(),
new List <IQueryParameter>()
{
new QueryParameter("param", "10")
},
new List <IQueryTemplateVariable>()
{
new QueryTemplateVariableXml()
{
Name = "operator", Value = "not in"
}
},
new TimeSpan(0, 0, 10));
var resolver = new ExternalFileQueryResolver(args);
Assert.Throws <ExternalDependencyNotFoundException>(() => resolver.Execute());
}
public void Execute_InvalidAbsolutePath_MessageAbsolutePath()
{
var args = new ExternalFileQueryResolverArgs(
@"C:\NotExistingFile.sql",
ConnectionStringReader.GetSqlClient(),
new List <IQueryParameter>()
{
new QueryParameter("param", "10")
},
new List <IQueryTemplateVariable>()
{
new QueryTemplateVariableXml()
{
Name = "operator", Value = "not in"
}
},
new TimeSpan(0, 0, 10));
var resolver = new ExternalFileQueryResolver(args);
var ex = Assert.Catch <ExternalDependencyNotFoundException>(() => resolver.Execute());
Assert.That(ex.Message, Does.Contain(@"C:\NotExistingFile.sql"));
}
