public static string ApplyFormat(string sql)
{
if (string.IsNullOrWhiteSpace(sql))
{
return string.Empty;
}
sql = sql.Trim();
if (sql.ToLowerInvariant().StartsWith("create table"))
{
return sql;
}
if (sql.ToLowerInvariant().StartsWith("alter table") || sql.ToLowerInvariant().StartsWith("comment on"))
{
sql = new DdlFormatter().Format(sql);
}
else
{
sql = new BasicFormatter().Format(sql).Trim();
}
return FormatParams(sql);
}
public void StringWithNestedDelimiters()
{
string formattedSql = null;
IFormatter formatter = new BasicFormatter();
string sql = @"INSERT INTO Table (Name, id) VALUES (@p0, @p1); @p0 = 'a'(b', @p1 = 1";
Assert.DoesNotThrow(() => formattedSql = formatter.Format(sql));
Assert.That(formattedSql, Is.StringContaining("'a'(b'"));
sql = @"UPDATE Table SET Column = @p0;@p0 = '(')'";
Assert.DoesNotThrow(() => formattedSql = formatter.Format(sql));
Assert.That(formattedSql, Is.StringContaining("'(')'"));
}
public static string FormatSQL()
{
BasicFormatter formatter = new BasicFormatter();
return(formatter.Format(NHibernateGeneratedSQL.ToUpper()));
}
