public override void WriteToStream(IndentStream stream)
{
stream.Write("SELECT ");
Columns.WriteToStream(stream);
stream.Write(" FROM ");
From.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("GRANT ");
PermissionList.Select(x => x.ToUpper()).WriteToStreamWithComma(stream);
if (OnObjectId != null)
{
stream.WriteLine();
stream.Write("ON ");
OnObjectId.WriteToStream(stream);
}
stream.Write(" TO ");
TargetList.WriteToStreamWithComma(stream);
if (AsDbo != null)
{
stream.Write(" AS ");
AsDbo.WriteToStream(stream);
}
if (IsSemicolon)
{
stream.Write(" ;");
}
}
public override void WriteToStream(IndentStream stream)
{
stream.WriteLine("BEGIN");
Items.WriteToStream(stream);
stream.WriteLine();
stream.Write("END");
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("CREATE ROLE ");
RoleName.WriteToStream(stream);
stream.Write(" AUTHORIZATION ");
SchemaName.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("DELETE");
if (TopExpr != null)
{
stream.Write(" ");
TopExpr.WriteToStream(stream);
}
stream.Write(" FROM ");
Table.WriteToStream(stream);
if (WithOptions != null && WithOptions.Count > 0)
{
stream.Write(" WITH(");
WithOptions.WriteToStreamWithComma(stream);
stream.Write(")");
}
if (OutputList != null && OutputList.Count > 0)
{
stream.WriteLine();
stream.Write("OUTPUT ");
OutputList.WriteToStreamWithComma(stream);
}
if (IntoTableExpr != null)
{
stream.WriteLine();
IntoTableExpr.WriteToStream(stream);
}
if (OutputList1 != null && OutputList1.Count > 0)
{
stream.WriteLine();
stream.Write("OUTPUT ");
OutputList.WriteToStreamWithComma(stream);
}
if (FromSourceList != null && FromSourceList.Count > 0)
{
stream.WriteLine();
stream.Write("FROM ");
FromSourceList.WriteToStreamWithComma(stream);
}
if (WhereExpr != null)
{
stream.WriteLine();
stream.Write("WHERE ");
WhereExpr.WriteToStream(stream);
}
if (OptionExpr != null)
{
stream.WriteLine();
OptionExpr.WriteToStream(stream);
}
}
public override void WriteToStream(IndentStream stream)
{
Name.WriteToStream(stream);
stream.Write(" ");
DataType.WriteToStream(stream);
Size?.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("CONSTRAINT ");
ConstraintName.WriteToStream(stream);
stream.Write($" ");
KeyType.WriteToStream(stream);
if (ClusterExpr != null)
{
stream.Write(" ");
ClusterExpr.WriteToStream(stream);
}
if (WithExpr != null)
{
stream.Write(" ");
WithExpr.WriteToStream(stream);
}
if (OnPrimary != null)
{
stream.Write(" ");
OnPrimary.WriteToStream(stream);
}
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("OPTION");
stream.Write("(");
Maxdop.WriteToStream(stream);
stream.Write(")");
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("INSERT INTO ");
Table.WriteToStream(stream);
if (ColumnsList != null && ColumnsList.Count > 0)
{
stream.Write("(");
ColumnsList.WriteToStreamWithComma(stream);
stream.Write(")");
}
if (WithExpr != null)
{
stream.Write(" ");
WithExpr.WriteToStream(stream);
}
if (OutputList != null && OutputList.Count > 0)
{
stream.WriteLine();
stream.Write("OUTPUT ");
OutputList.WriteToStreamWithComma(stream);
}
if (OutputIntoExpr != null)
{
stream.WriteLine();
OutputIntoExpr.WriteToStream(stream);
}
stream.WriteLine();
SelectFromExpr.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("CASE");
if (InputExpr != null)
{
stream.Write(" ");
InputExpr.WriteToStream(stream);
}
foreach (var whenExpr in WhenList)
{
stream.WriteLine();
whenExpr.WriteToStream(stream);
}
if (ElseExpr != null)
{
stream.WriteLine();
stream.Write("ELSE ");
ElseExpr.WriteToStream(stream);
}
stream.WriteLine();
stream.Write("END");
}
public override void WriteToStream(IndentStream stream)
{
stream.Write(":SETVAR ");
Name.WriteToStream(stream);
stream.Write(" ");
Value.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("MERGE");
if (!string.IsNullOrEmpty(IntoToken))
{
stream.Write($" {IntoToken}");
}
stream.Write(" ");
TargetTable.WriteToStream(stream);
if (WithOptions != null && WithOptions.Count > 0)
{
stream.Write(" WITH(");
WithOptions.WriteToStreamWithComma(stream);
stream.Write(")");
}
if (TargetTableAliasName != null)
{
stream.Write(" AS ");
TargetTableAliasName.WriteToStream(stream);
}
stream.WriteLine();
stream.Write("USING ");
TableSource.WriteToStream(stream);
if (TableSourceAliasName != null)
{
stream.Write(" AS ");
TableSourceAliasName.WriteToStream(stream);
}
if (SourceColumnList != null && SourceColumnList.Count > 0)
{
stream.Write("(");
SourceColumnList.WriteToStreamWithComma(stream);
stream.Write(")");
}
stream.Write(" ON ");
OnMergeSearchCondition.WriteToStream(stream);
if (WhenList != null && WhenList.Count > 0)
{
stream.WriteLine();
WhenList.WriteToStream(stream);
}
if (OutputList != null && OutputList.Count > 0)
{
stream.WriteLine();
stream.Write("OUTPUT ");
OutputList.WriteToStreamWithComma(stream);
}
stream.Write(" ;");
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("SET ");
Name.WriteToStream(stream);
stream.Write($" {Oper} ");
Value.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
if (!string.IsNullOrEmpty(JoinType))
{
stream.Write($"{JoinType.ToUpper()} ");
}
if (!string.IsNullOrEmpty(OuterType))
{
stream.Write($"{OuterType.ToUpper()} ");
}
stream.Write("JOIN ");
SecondTable.WriteToStream(stream);
if (AliasName != null)
{
stream.Write(" ");
AliasName.WriteToStream(stream);
}
if (WithOptions != null && WithOptions.Count > 0)
{
stream.Write(" WITH(");
WithOptions.ToUpper().WriteToStreamWithComma(stream);
stream.Write(")");
}
if (JoinOnExpr != null)
{
stream.Write(" ON ");
JoinOnExpr.WriteToStream(stream);
}
}
public override void WriteToStream(IndentStream stream)
{
Name.WriteToStream(stream);
stream.Write("(");
Column.WriteToStream(stream);
stream.Write(")");
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("DECLARE ");
Name.WriteToStream(stream);
stream.Write(" ");
DataType.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
DataType.WriteToStream(stream);
// if (IsIdentity)
// {
// stream.Write(" IDENTITY");
// }
//
// if (IsReadOnly)
// {
// stream.Write(" READONLY");
// }
//
// if (SizeExpr != null)
// {
// SizeExpr.WriteToStream(stream);
// }
if (ExtraList != null && ExtraList.Count > 0)
{
stream.Write(" ");
ExtraList.WriteToStream(stream);
}
}
public override void WriteToStream(IndentStream stream)
{
stream.Write($"DROP {TargetId}");
stream.Write(" ");
ObjectId.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("CREATE SYNONYM ");
Name.WriteToStream(stream);
stream.Write(" FOR ");
ObjectId.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("CREATE TYPE ");
Name.WriteToStream(stream);
stream.Write(" AS ");
TypeExpr.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
Left.WriteToStream(stream);
stream.Write(" NOT IN (");
Right.WriteToStream(stream);
stream.Write(")");
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("INSERT ");
if (!string.IsNullOrEmpty(IntoStr))
{
stream.Write($"{IntoStr.ToUpper()} ");
}
TableName.WriteToStream(stream);
if (Columns != null && Columns.Count > 0)
{
stream.Write("(");
Columns.WriteToStreamWithComma(stream);
stream.Write(")");
}
if (WithExpr != null)
{
stream.Write(" ");
WithExpr.WriteToStream(stream);
}
stream.Write(" VALUES");
stream.WriteLine();
foreach (var values in ValuesList.Select((val, idx) => new { val, idx }))
{
if (values.idx != 0)
{
stream.WriteLine(",");
}
stream.Write("(");
values.val.WriteToStream(stream);
stream.Write(")");
}
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("CREATE LOGIN ");
LoginName.WriteToStream(stream);
stream.Write(" WITH PASSWORD = ");
Password.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
Left.WriteToStream(stream);
stream.Write(" NOT BETWEEN ");
Start.WriteToStream(stream);
stream.Write(" AND ");
End.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("BREAK");
if (IsSemicolon)
{
stream.Write(" ;");
}
}
public override void WriteToStream(IndentStream stream)
{
Name.WriteToStream(stream);
if (!string.IsNullOrEmpty(AscOrDesc))
{
stream.Write($" {AscOrDesc}");
}
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("SET ");
var optionsStr = string.Join(", ", Options.Select(x => x.ToUpper()));
stream.Write(optionsStr);
stream.Write($" {Toggle.ToUpper()}");
}
public override void WriteToStream(IndentStream stream)
{
LeftExpr.WriteToStream(stream);
stream.Write(" BETWEEN ");
StartExpr.WriteToStream(stream);
stream.Write(" AND ");
EndExpr.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
Name.WriteToStream(stream);
if (!string.IsNullOrEmpty(SortToken))
{
stream.Write($" {SortToken.ToUpper()}");
}
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("WHEN ");
ConditionExpr.WriteToStream(stream);
stream.WriteLine();
stream.Write("THEN ");
ThenExpr.WriteToStream(stream);
}
