public static List <string> TableIndices(this TypeSchema schema, string suffix = null)
{
return(schema
.Fields
.Where(f => f.IsIndex && !f.IsPrimaryKey)
.Select(p => $"CREATE INDEX {schema.TableNameWithSuffix(suffix)}_{p.Name}_idx ON {schema.TableNameWithSuffix(suffix)} {p.TableIndex()};")
.ToList());
}
public static string TableDefinition(this TypeSchema schema, string suffix = null)
{
return($@"CREATE TABLE {schema.TableNameWithSuffix(suffix)}(
{string.Join(",\n", schema.Fields.Select(f => f.FieldDeclaration()))}
);");
}