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();
}
