public void Write(SqlCreateTableStatement value, TextWriter writer) { writer.Write("CREATE "); if (value.IsTemporary) { writer.Write("TEMPORARY "); } writer.Write("TABLE "); if (value.IfNotExits) { writer.Write("IF NOT EXISTS "); } if (!string.IsNullOrWhiteSpace(value.SchemaName)) { _identifierFormatter.Write(value.SchemaName, writer); writer.Write("."); } _identifierFormatter.Write(value.Name, writer); writer.WriteLine(); // Column definitions writer.WriteLine("("); _columnDefinitionFormatter.Write(value.Columns, writer); writer.Write(")"); // Without RowID if (value.WithoutRowId) { writer.Write(" WITHOUT ROWID"); } writer.WriteLine(";"); }
public static ITextFormatter Li(this ITextFormatter fmt, string s) { fmt.BeginLi(); fmt.Write(s); fmt.EndLi(); return(fmt); }
public static ITextFormatter HeadingCell(this ITextFormatter fmt, params object[] data) { fmt.BeginCell(true); foreach (var param in data) { fmt.Write(param); } fmt.EndCell(true); return(fmt); }
public static string WriteToString <T>(this ITextFormatter <T> formatter, T value, string?newLine = default) { var sb = new StringBuilder(); using (var stream = new StringWriter(sb)) { stream.NewLine = newLine ?? stream.NewLine; formatter.Write(value, stream); } return(sb.ToString()); }
public void Write(IList <ISqlColumnDefinition> value, TextWriter writer) { for (var index = 0; index < value.Count; index++) { var colDef = value[index]; writer.Write(_indent); _identifierFormatter.Write(colDef.Name, writer); writer.Write(" "); writer.Write(colDef.Type); if (colDef.Constraints.Count != 0) { writer.Write(" "); _constraintFormatter.Write(colDef.Constraints, writer); } if (index < (value.Count - 1)) { writer.WriteLine(","); } } }
public static void WriteLine <T>(this ITextFormatter <T> formatter, T value, TextWriter writer) { formatter.Write(value, writer); writer.WriteLine(); }