public override void Append(SDatabase?db, StringBuilder sb)
{
sce.Append(db, sb);
sb.Append(" where ");
var cm = "";
for (var b = where.First(); b != null; b = b.Next())
{
sb.Append(cm); cm = " and ";
b.Value.Append(db, sb);
}
}
public override void Append(SDatabase?db, StringBuilder sb)
{
source.Append(db, sb);
sb.Append(" groupby ");
var cm = "";
for (var b = groupby.First(); b != null; b = b.Next())
{
sb.Append(cm); cm = ",";
sb.Append(b.Value.Item2);
}
if (having.Length > 0)
{
sb.Append(" having ");
cm = "";
for (var b = having.First(); b != null; b = b.Next())
{
sb.Append(cm); cm = " and ";
b.Value.Append(db, sb);
}
}
}
public override void Append(SDatabase?db, StringBuilder sb)
{
left.Append(db, sb);
if (outer)
{
sb.Append(" outer ");
}
if (joinType != JoinType.Inner)
{
sb.Append(" "); sb.Append(joinType); sb.Append(" ");
}
right.Append(db, sb);
if (ons.Length != 0)
{
sb.Append(" on ");
var cm = "";
for (var b = ons.First(); b != null; b = b.Next())
{
sb.Append(cm); cm = ",";
b.Value.Append(db, sb);
}
}
}
