public void Add_WhenAddingSubQuery_Adds()
{
var expected = @"SELECT
Id,
Name";
var clause = new SelectClause(null);
clause.Add("Id");
clause.Add("Name");
clause.GetQueryString().Should(Be.EqualTo(expected));
}
private string GetQueryStringForCurrentQuery()
{
var buf = new IndentingStringBuilder();
if (selectClause == null)
selectClause = new SelectClause(this);
if (selectClause != null)
buf.AppendLine(selectClause.GetQueryString());
if (fromClause != null)
buf.AppendLine(fromClause.GetQueryString());
if (whereClause != null)
buf.AppendLine(whereClause.GetQueryString());
if (groupByClause != null)
buf.AppendLine(groupByClause.GetQueryString());
if (havingClause != null)
buf.AppendLine(havingClause.GetQueryString());
if (orderByClause != null)
{
if (IsSubQuery == false)
buf.AppendLine(orderByClause.GetQueryString());
}
return buf.ToString();
}
