public void ObjectRef()
{
var dot = new Token("dot", ".");
var text = new Text("Text", ".+");
var root = new Def("ObjectRef", text, new Optional(dot, text), new Optional(dot, text));
Grammar grammar = new Grammar
{
StringQuote = '\'',
Root = root
};
string actual = GenerateAndBuildParser(grammar, "abc");
Assert.That(actual, Is.EqualTo(@"
ObjectRef
Text - abc"));
actual = GenerateAndBuildParser(grammar, "abc.def");
Assert.That(actual, Is.EqualTo(@"
ObjectRef
Text - abc
Dot
Text - def"));
actual = GenerateAndBuildParser(grammar, "abc.def.ghi");
Assert.That(actual, Is.EqualTo(@"
ObjectRef
Text - abc
Dot
Text - def
Dot
Text - ghi"));
}
public SqlGrammar()
{
var dot = new Token("dot", ".");
var star = new Token("star", "*");
var equalTo = new Token("equalTo", "=");
var comma = new Token("comma", ",");
var openParen = new Token("openParen", "(");
var closeParen = new Token("closeParen", ")");
var whitespace1 = new Token("whitespace", " ");
var whitespace2 = new Token("whitespace", "\t");
var whitespace3 = new Token("whitespace", "\n");
var whitespace4 = new Token("whitespace", "\r");
var openSquare = new Token("openSquare", "[");
var closeSquare = new Token("closeSquare", "]");
var _select = new Token("select");
var _from = new Token("from");
var _distinct = new Token("distinct");
var _top = new Token("top");
var _inner = new Token("inner");
var _left = new Token("left");
var _right = new Token("right");
var _outer = new Token("outer");
var _join = new Token("join");
var _on = new Token("on");
var _as = new Token("as");
var _count = new Token("count");
var _min = new Token("min");
var _max = new Token("max");
var _avg = new Token("avg");
var _where = new Token("where");
var _cross = new Token("cross");
var _order = new Token("order");
var _by = new Token("by");
var _with = new Token("with");
var _nolock = new Token("nolock");
var _like = new Token("like");
var integer = new Text("Integer", "[0-9]+");
var text = new Text("Text", ".+");
var objectRef = new Def("ObjectRef", text, new Optional(dot, text), new Optional(dot, text));
var table = new Def("Table", text, new Optional(_as), new Optional(text));
var joinDef = new Def("JoinDef", new Optional(new OneOf(_inner, _left, _right)), new Optional(_outer), _join, table, _on, objectRef, equalTo, objectRef);
var starOrObjectRef = new Def("StarOrObjectRef", new OneOf(star, objectRef));
var aggregate = new Def("Aggregate", new Def("Agg", new OneOf(_count, _min, _max, _avg)), openParen, starOrObjectRef, closeParen);
var objectRefOrAggregate = new Def("ObjectRefOrAggregate", new OneOf(objectRef, aggregate));
var selectField = new Def("SelectField", objectRefOrAggregate, new Optional(_as), new Optional(text));
var commaSelectField = new Def("CommaSelectField", comma, selectField);
var selectFieldList = new Def("SelectFieldList", selectField, new ZeroOrMore(commaSelectField));
var selectFields = new Def("SelectFields", new OneOf(star, selectFieldList));
var topX = new Def("TopX", _top, integer);
_root = new Def("SelectStatement", _select, new Optional(topX), new Optional(_distinct), selectFields, _from, table, new ZeroOrMore(joinDef));
}
public void Table()
{
var _as = new Token("as");
var _space = new Token("WhiteSpace", " ");
var text = new Text("Text", ".+");
var root = new Def("Table", text, new Optional(_as), new Optional(text));
Grammar grammar = new Grammar
{
StringQuote = '\'',
Root = root,
IgnoreTokens = new[] { _space }
};
string actual = GenerateAndBuildParser(grammar, "abc");
Assert.That(actual, Is.EqualTo(@"
Table
Text - abc"));
actual = GenerateAndBuildParser(grammar, "abc ABC");
Assert.That(actual, Is.EqualTo(@"
Table
Text - abc
Text - ABC"));
actual = GenerateAndBuildParser(grammar, "abc as ABC");
Assert.That(actual, Is.EqualTo(@"
Table
Text - abc
As
Text - ABC"));
}
public void StarOrObjectRef()
{
var dot = new Token("dot", ".");
var text = new Text("Text", ".+");
var star = new Token("star", "*");
var _space = new Token("whitespace", " ");
var objectRef = new Def("ObjectRef", text, new Optional(dot, text), new Optional(dot, text));
var root = new Def("StarOrObjectRef", new OneOf(star, objectRef));
Grammar grammar = new Grammar
{
StringQuote = '\'',
Root = root,
IgnoreTokens = new[] { _space }
};
string actual = GenerateAndBuildParser(grammar, "*");
Assert.That(actual, Is.EqualTo(@""));
}