private TableSourceExpression ExpressionTestHelper(string query)
{
var p = new SqlParser();
var ss = (SelectStatement)p.Execute(new SelectStatement(), query);
return(ss.FindDescendantRecursive <TableSourceExpression>());
}
private void GetSearchCondition(string query, out SelectStatement select, out SearchCondition where)
{
var p = new SqlParser();
select = (SelectStatement)p.Execute(new SelectStatement(), query);
where = select.FindDescendantRecursive <WhereClause>().FindDescendant <SearchCondition>();
}
private SearchCondition GetSearchCondition(string sql)
{
SqlParser p = new SqlParser();
var select = (SelectStatement)p.Execute(new SelectStatement(), sql);
var where = select.FindDescendantRecursive <WhereClause>();
return(where.FindDescendant <SearchCondition>());
}
private TableHint[] TableHintTestHelper(string query)
{
var p = new SqlParser();
var ss = (SelectStatement)p.Execute(new SelectStatement(), query);
var hl = ss.FindDescendantRecursive<TableHintList>();
return hl.EnumerateDescendantsRecursive<TableHint>().ToArray();
}
private TableHint[] TableHintTestHelper(string query)
{
var p = new SqlParser();
var ss = (SelectStatement)p.Execute(new SelectStatement(), query);
var hl = ss.FindDescendantRecursive <TableHintList>();
return(hl.EnumerateDescendantsRecursive <TableHint>().ToArray());
}
private QuerySpecification Parse(string query)
{
var p = new SqlParser();
var ss = (SelectStatement)p.Execute(query);
var qs = (QuerySpecification)ss.EnumerateQuerySpecifications().First();
ResolveNames(qs);
return(qs);
}
private SelectStatement CreateSelect(string query)
{
SqlParser p = new SqlParser();
var select = (SelectStatement)p.Execute(new SelectStatement(), query);
SqlNameResolver nr = new SqlNameResolver();
nr.DefaultTableDatasetName = Jhu.Graywulf.Test.Constants.TestDatasetName;
nr.DefaultFunctionDatasetName = Jhu.Graywulf.Test.Constants.CodeDatasetName;
nr.SchemaManager = CreateSchemaManager();
nr.Execute(select);
return(select);
}
private Jhu.Graywulf.SqlParser.TableOrViewName TablenameTestHelper(string query)
{
var p = new SqlParser();
return((Jhu.Graywulf.SqlParser.TableOrViewName)p.Execute(new Jhu.Graywulf.SqlParser.TableOrViewName(), query));
}
private Jhu.Graywulf.SqlParser.Expression ExpressionTestHelper(string query)
{
var p = new SqlParser();
return((Jhu.Graywulf.SqlParser.Expression)p.Execute(new Jhu.Graywulf.SqlParser.Expression(), query));
}
private SelectStatement CreateSelect(string query)
{
var p = new SqlParser();
return (SelectStatement)p.Execute(new SelectStatement(), query);
}
private Jhu.Graywulf.SqlParser.SelectStatement ExpressionTestHelper(string query)
{
var p = new SqlParser();
return (Jhu.Graywulf.SqlParser.SelectStatement)p.Execute(new Jhu.Graywulf.SqlParser.SelectStatement(), query);
}
private SelectStatement CreateSelect(string query)
{
SqlParser p = new SqlParser();
var select = (SelectStatement)p.Execute(new SelectStatement(), query);
SqlNameResolver nr = new SqlNameResolver();
nr.DefaultTableDatasetName = Jhu.Graywulf.Test.Constants.TestDatasetName;
nr.DefaultFunctionDatasetName = Jhu.Graywulf.Test.Constants.CodeDatasetName;
nr.SchemaManager = CreateSchemaManager();
nr.Execute(select);
return select;
}
private TableSourceExpression ExpressionTestHelper(string query)
{
var p = new SqlParser();
var ss = (SelectStatement)p.Execute(new SelectStatement(), query);
return ss.FindDescendantRecursive<TableSourceExpression>();
}
private void GetSearchCondition(string query, out SelectStatement select, out SearchCondition where)
{
var p = new SqlParser();
select = (SelectStatement)p.Execute(new SelectStatement(), query);
where = select.FindDescendantRecursive<WhereClause>().FindDescendant<SearchCondition>();
}
private Jhu.Graywulf.SqlParser.TableOrViewName TablenameTestHelper(string query)
{
var p = new SqlParser();
return (Jhu.Graywulf.SqlParser.TableOrViewName)p.Execute(new Jhu.Graywulf.SqlParser.TableOrViewName(), query);
}
private Jhu.Graywulf.SqlParser.SelectStatement ExpressionTestHelper(string query)
{
var p = new SqlParser();
return((Jhu.Graywulf.SqlParser.SelectStatement)p.Execute(new Jhu.Graywulf.SqlParser.SelectStatement(), query));
}
private SelectStatement CreateSelect(string query)
{
var p = new SqlParser();
return((SelectStatement)p.Execute(new SelectStatement(), query));
}
private SearchCondition GetSearchCondition(string sql)
{
SqlParser p = new SqlParser();
var select = (SelectStatement)p.Execute(new SelectStatement(), sql);
var where = select.FindDescendantRecursive<WhereClause>();
return where.FindDescendant<SearchCondition>();
}
private Jhu.Graywulf.SqlParser.Expression ExpressionTestHelper(string query)
{
var p = new SqlParser();
return (Jhu.Graywulf.SqlParser.Expression)p.Execute(new Jhu.Graywulf.SqlParser.Expression(), query);
}
private QuerySpecification Parse(string query)
{
var p = new SqlParser();
var ss = (SelectStatement)p.Execute(query);
var qs = (QuerySpecification)ss.EnumerateQuerySpecifications().First();
ResolveNames(qs);
return qs;
}
