public void Parse_Entity_Info()
{
var input = "[Student]\r\n* StudentNr char(10)";
var parser = new Parser();
var model = parser.Parse(input);
var infos = model.Tables.Where(t => t is Info);
Assert.AreEqual(1, infos.Count());
Assert.AreEqual("StudentInfo", infos.ElementAt(0).Shortname);
}
public void Parse_Entity_Anchor()
{
var input = "[Student]\r\n* StudentNr char(10)";
var parser = new Parser();
var model = parser.Parse(input);
var anchors = model.Tables.Where(t => t is Anchor);
Assert.AreEqual(1, anchors.Count());
Assert.AreEqual("Student", anchors.ElementAt(0).Shortname);
}
public void Parse_EntityCompositeBK_BusinessKey()
{
var input = "[Student]\r\n* StudentNr char(10)\r\n* Year char(2)\r\nName varchar(50)";
var parser = new Parser();
var model = parser.Parse(input);
var anchor = model.Tables.ElementAt(0) as Anchor;
Assert.IsNotNull(anchor);
Assert.AreEqual(2, anchor.BusinessKey.Count());
}
public void Parse_Entities_Link()
{
var input = "[Student]\r\n* StudentNr char(10)\r\n[Course] * CourseKey char(5)\r\n [Student] *-follow-* [Course]\r\n";
var parser = new Parser();
var model = parser.Parse(input);
var links = model.Tables.Where(t => t.GetType()==typeof(Link));
Assert.AreEqual(1, links.Count());
Assert.AreEqual("StudentCourseLink", links.ElementAt(0).Shortname);
}
public void Parse_Entity_BusinessKey()
{
var input = "[Student]\r\n* StudentNr char(10)";
var parser = new Parser();
var model = parser.Parse(input);
var anchor = model.Tables.ElementAt(0) as Anchor;
Assert.IsNotNull(anchor);
Assert.AreEqual(1, anchor.BusinessKey.Count());
Assert.AreEqual("StudentNr", anchor.BusinessKey.ElementAt(0).Name);
Assert.AreEqual(Microsoft.SqlServer.Dac.Model.SqlDataType.Char, anchor.BusinessKey.ElementAt(0).DataType.SqlDataType);
}
public void Parse_Entity_InfoAttributes()
{
var input = "[Student]\r\n* StudentNr char(10)\r\n* Year char(2)\r\nName varchar(50)^\r\nClass varchar(50) {='Standard'=}";
var parser = new Parser();
var model = parser.Parse(input);
var info = model.Tables.Where(t => t is Info).ElementAt(0) as Info;
Assert.IsNotNull(info);
Assert.AreEqual(2, info.Fields.Count());
Assert.AreEqual("Name", info.Fields.ElementAt(0).Name);
Assert.AreEqual("Class", info.Fields.ElementAt(1).Name);
Assert.AreEqual(true, info.Fields.ElementAt(1).IsDefault);
Assert.AreEqual("'Standard'", info.Fields.ElementAt(1).Default);
}
public void Parse_Entity_InfoAttributeMultivalued()
{
var input = "[Student]\r\n* StudentNr char(10)\r\n* Year char(2)\r\nName varchar(50)^\r\nEmail varchar(255)#";
var parser = new Parser();
var model = parser.Parse(input);
}