public void RefFreeViewTest()
{
var model = PersistentModel.Compile(@"
class a prototype=dbtable
string Code
string Name
class b prototype=dbtable
string Code
ref a
view Full
selffields
reffields free
by a, nosuch
use Code Name NoSuch
");
var view = model["b"].SqlObjects.OfType <SqlView>().First();
var writer = new SqlViewWriter(view)
{
NoComment = true
};
var res = writer.ToString();
Console.WriteLine(res.Replace("\"", "\"\""));
Assert.AreEqual(@"IF OBJECT_ID('""dbo"".""bFull""') IS NOT NULL DROP VIEW ""dbo"".""bFull"";
GO
CREATE VIEW ""dbo"".""bFull"" AS SELECT
""id"", --
""code"", --
""a"", --
(select x.""code"" from ""dbo"".""a"" x where x.""id"" = ""dbo"".""b"".""a"") as aCode,
(select x.""name"" from ""dbo"".""a"" x where x.""id"" = ""dbo"".""b"".""a"") as aName,
1 as __TERMINAL FROM ""dbo"".""b""
".Trim(), res.Trim());
}
public void ViewWithFromTest(string from, string result)
{
var model = PersistentModel.Compile(@"
class a prototype=dbtable schema=test
view y
view x from='" + from + @"'
");
var cls = model["a"];
Assert.AreEqual("test", cls.Schema);
var f = cls.SqlObjects.OfType <SqlView>().Last();
var writer = new SqlViewWriter(f)
{
Dialect = DbDialect.SqlServer, NoComment = true
};
var res = writer.ToString();
Console.WriteLine(res.Replace("\"", "\"\""));
Assert.AreEqual(@"IF OBJECT_ID('""test"".""ax""') IS NOT NULL DROP VIEW ""test"".""ax"";
GO
CREATE VIEW ""test"".""ax"" AS SELECT
1 as __TERMINAL FROM ZZZZZZZ
GO".Replace("ZZZZZZZ", result).Trim().Replace("\r", ""), res.Trim().Replace("\r", ""));
}
public void BaseViewTest()
{
var model = PersistentModel.Compile(@"
class a prototype=dbtable
string Code
view Full
selffields
");
var view = model["a"].SqlObjects.OfType <SqlView>().First();
var writer = new SqlViewWriter(view)
{
NoComment = true
};
var res = writer.ToString();
Console.WriteLine(res.Replace("\"", "\"\""));
Assert.AreEqual(@"IF OBJECT_ID('""dbo"".""aFull""') IS NOT NULL DROP VIEW ""dbo"".""aFull"";
GO
CREATE VIEW ""dbo"".""aFull"" AS SELECT
""id"", --
""code"", --
1 as __TERMINAL FROM ""dbo"".""a""".Trim(), res.Trim());
}