public void FindAndNormalizeCreate_BrokenThrowsException()
{
var triggerItemMock = new Mock <ISchemaBase>();
triggerItemMock.Setup(x => x.FullName).Returns("[dbo].[iutrgTriggerName]");
FormatCode.FindAndNormalizeCreate(triggerItemMock.Object, extractor.ReadFileFromResource("broken.sql"));
}
public void FindAndNormalizeCreate_NormalizedSql_ShouldKeepSourceText()
{
var triggerItemMock = new Mock <ISchemaBase>();
triggerItemMock.Setup(x => x.FullName).Returns("[dbo].[iutrgTriggerName]");
var normalized = extractor.ReadFileFromResource("normalized.sql");
var a = FormatCode.FindAndNormalizeCreate(triggerItemMock.Object, normalized);
Assert.AreEqual(normalized, a.Body);
Assert.AreEqual(0, a.FindPosition);
}
public void FindAndNormalizeCreate_WithComment_ShouldNormalize()
{
var triggerItemMock = new Mock <ISchemaBase>();
triggerItemMock.Setup(x => x.FullName).Returns("[dbo].[iutrgTriggerName]");
var a = FormatCode.FindAndNormalizeCreate(triggerItemMock.Object, extractor.ReadFileFromResource("with-comments.sql"));
var normalized = extractor.ReadFileFromResource("normalized.sql");
Assert.AreEqual(62, a.FindPosition);
Assert.AreEqual(normalized, a.Body.Substring(a.FindPosition));
}
