public void InvalidSqlInliner() { const string viewSql = "CREATE OR VIEW dbo.X AS SELECT 0"; var inliner = new DatabaseViewInliner(connection, viewSql); Assert.IsNull(inliner.View); Assert.AreNotEqual(viewSql, inliner.Sql); }
public void ReturnOriginalIfNoViewsAreReferenced() { const string viewSql = "CREATE VIEW dbo.X AS SELECT 0"; var inliner = new DatabaseViewInliner(connection, viewSql); Assert.AreEqual(0, inliner.Errors.Count); Assert.AreEqual(viewSql, inliner.Sql); Assert.IsNotNull(inliner.View); }
public void WarningForSinglePartIdentifiers() { const string viewSql = "CREATE OR ALTER VIEW dbo.VActivePeople AS SELECT Id, FirstName, LastName FROM dbo.VNestedPeople"; var inliner = new DatabaseViewInliner(connection, viewSql, options); Assert.AreEqual(0, inliner.Errors.Count); Assert.AreNotEqual(0, inliner.Warnings.Count); Assert.AreNotEqual(viewSql, inliner.Sql); }
public void InlineSimpleView() { const string viewSql = "CREATE VIEW dbo.VActivePeople AS SELECT p.Id, p.FirstName, p.LastName FROM dbo.VPeople p WHERE p.IsActive = 1"; var inliner = new DatabaseViewInliner(connection, viewSql, options); Assert.AreEqual(0, inliner.Errors.Count); Assert.AreNotEqual(viewSql, inliner.Sql); var result = inliner.Result; Assert.IsNotNull(result); Assert.IsTrue(result.Sql.Contains("dbo.People")); Assert.IsTrue(result.ConvertedSql.Contains("dbo.People")); Assert.IsFalse(result.ConvertedSql.Contains("dbo.VPeople")); Assert.IsFalse(result.ConvertedSql.Contains("UnusedFunction")); }
public void InlineSimpleViewWithAliasesWithColumnAliases() { const string viewSql = "CREATE VIEW dbo.VActivePeople AS SELECT ap.Id, ap.FName PersonFirstName, ap.LName PersonLastName FROM dbo.VPeopleWithAliases ap WHERE ap.ActiveInd = 1"; var inliner = new DatabaseViewInliner(connection, viewSql, options); Assert.AreEqual(0, inliner.Errors.Count); Assert.AreNotEqual(viewSql, inliner.Sql); var result = inliner.Result; Assert.IsNotNull(result); Assert.IsTrue(result.Sql.Contains("dbo.People")); Assert.IsTrue(result.ConvertedSql.Contains("dbo.People")); Assert.IsFalse(result.ConvertedSql.Contains("dbo.VPeopleWithAliases")); Assert.IsFalse(result.ConvertedSql.Contains("UnusedFunction")); Assert.IsTrue(result.ConvertedSql.Contains("ap.FName AS PersonFirstName")); }