public void SupportsInvalidSql()
{
using (var spy = new SqlLogSpy())
{
var logger = new SqlStatementLogger(false, true);
using (var cmd = new System.Data.SqlClient.SqlCommand(
"UPDATE Table Set Column = @p0; @p0 = 'Some data with an embedded quote in parentheses and signal word (''UPDATE'') like this: (don't update)'"))
{
Assert.DoesNotThrow(() => logger.LogCommand(cmd, FormatStyle.Basic));
}
Assert.That(spy.GetWholeLog(), Contains.Substring("Some data with an embedded quote"));
}
}
public void SupportsKeywordInParameter()
{
using (var spy = new SqlLogSpy())
{
var logger = new SqlStatementLogger(false, true);
using (var cmd = new System.Data.SqlClient.SqlCommand("UPDATE Table Set Column = @p0;"))
{
cmd.Parameters.AddWithValue(
"p0",
"Some data with an embedded quote in parentheses and signal word ('UPDATE') like this: (don't update)");
Assert.DoesNotThrow(() => logger.LogCommand(cmd, FormatStyle.Basic));
}
var log = spy.GetWholeLog();
Assert.That(log, Contains.Substring("Some data with an embedded quote"));
Assert.That(log.Split('\n'), Has.Length.GreaterThan(2), "SQL seems not formatted");
}
}
static PersistentIdGeneratorParmsNames()
{
SqlStatementLogger = new SqlStatementLogger(false, false);
}
