public static WhereClause Create(SearchCondition sc)
{
var wh = new WhereClause();
wh.Stack.AddLast(Keyword.Create("WHERE"));
wh.Stack.AddLast(Whitespace.Create());
wh.Stack.AddLast(sc);
return wh;
}
public WhereClause GenerateWhereClauseSpecificToTable(TableReference table)
{
SearchCondition sc = null;
// Loop over all conditions (JOIN ONs and WHERE conditions)
// Result will be a combinations of the table specific conditions terms
// of all these
// Chain up search conditions with AND operator
foreach (var condition in conditions)
{
foreach (var ex in EnumerateCnfTermsSpecificToTable(condition, table))
{
var nsc = ex.GetParsingTree();
if (sc != null)
{
nsc.Stack.AddLast(Whitespace.Create());
nsc.Stack.AddLast(LogicalOperator.CreateAnd());
nsc.Stack.AddLast(Whitespace.Create());
nsc.Stack.AddLast(sc);
}
sc = nsc;
}
}
// Prefix with the WHERE keyword
if (sc != null)
{
var where = new WhereClause();
where.Stack.AddLast(Keyword.Create("WHERE"));
where.Stack.AddLast(Whitespace.Create());
where.Stack.AddLast(sc);
return where;
}
else
{
return null;
}
}