public void GlobalSetup()
{
var queryBuilder = new StringBuilder("SELECT * FROM Table WHERE Id IN (");
_params = new(NumParams);
for (var i = 0; i < NumParams; i++)
{
queryBuilder.Append("@param");
queryBuilder.Append(i + 1);
if (i != NumParams - 1)
{
queryBuilder.Append(',');
}
_params.Add(new SqlTimingParameter
{
Name = $"{(ParamNamePrefixed ? '@' : string.Empty)}param{i + 1}",
DbType = "Int32",
Value = i.ToString(),
});
}
queryBuilder.Append(')');
_queryString = queryBuilder.ToString();
_formatter = new();
}
public void InlineParameterNamesInParameterValues()
{
var formatter = new InlineFormatter();
var parameters = new List <SqlTimingParameter>
{
new SqlTimingParameter()
{
DbType = "string", Name = "url", Value = "http://www.example.com?myid=1"
},
new SqlTimingParameter()
{
DbType = "string", Name = "myid", Value = "1"
}
};
const string command = "SELECT * FROM urls WHERE url = @url OR myid = @myid";
var formatted = formatter.FormatSql(command, parameters);
Assert.Equal("SELECT * FROM urls WHERE url = 'http://www.example.com?myid=1' OR myid = '1'", formatted);
}
public void InlineSpacesAfterCommasDisabled()
{
var formatter = new InlineFormatter()
{
InsertSpacesAfterCommas = false
};
var parameters = new List <SqlTimingParameter>
{
new SqlTimingParameter()
{
DbType = "string", Name = "url", Value = "http://www.example.com?myid=1"
},
new SqlTimingParameter()
{
DbType = "string", Name = "myid", Value = "1"
}
};
const string command = "SELECT myid,url FROM urls WHERE url = @url OR myid = @myid";
var formatted = formatter.FormatSql(command, parameters);
Assert.Equal("SELECT myid,url FROM urls WHERE url = 'http://www.example.com?myid=1' OR myid = '1'", formatted);
}
public ExtensibleHtmlFormatter WithFormatter(InlineTag inlineTag, Func <Inline, bool> canFormat, Func <Inline, string> openingFormatter, Func <Inline, string> closingFormatter)
{
this.inlineFormatters.Add(inlineTag, InlineFormatter.Create(canFormat, openingFormatter, closingFormatter));
return(this);
}
public ExtensibleHtmlFormatter WithFormatter(InlineTag inlineTag, Func <Inline, string> formatter)
{
this.inlineFormatters.Add(inlineTag, InlineFormatter.Create(formatter));
return(this);
}
