private string BuildFkName(IExprTableFullName tableIn, IExprTableFullName foreignTableIn)
{
StringBuilder nameBuilder = new StringBuilder();
ExprTableFullName table = tableIn.AsExprTableFullName();
ExprTableFullName foreignTable = foreignTableIn.AsExprTableFullName();
var schemaName = table.DbSchema != null?this.Options.MapSchema(table.DbSchema.Schema.Name) + "_" : null;
nameBuilder.Append("FK_");
if (schemaName != null)
{
nameBuilder.Append(schemaName);
nameBuilder.Append('_');
}
nameBuilder.Append(table.TableName.Name);
nameBuilder.Append("_to_");
if (schemaName != null)
{
nameBuilder.Append(schemaName);
nameBuilder.Append('_');
}
nameBuilder.Append(foreignTable.TableName.Name);
return(nameBuilder.ToString());
}
private string BuildPkName(IExprTableFullName tableIn)
{
var table = tableIn.AsExprTableFullName();
var schemaName = table.DbSchema != null?this.Options.MapSchema(table.DbSchema.Schema.Name) + "_" : null;
return($"PK_{schemaName}{table.TableName.Name}");
}
protected string BuildIndexName(IExprTableFullName tableIn, IndexMeta index)
{
if (index.Name != null && !string.IsNullOrEmpty(index.Name))
{
return(index.Name);
}
var table = tableIn.AsExprTableFullName();
var schemaName = table.DbSchema != null?this.Options.MapSchema(table.DbSchema.Schema.Name) + "_" : null;
var columns = string.Join("_", index.Columns.Select(c => c.Column.ColumnName.Name + (c.Descending ? "_DESC" : null)));
return($"IX_{schemaName}{table.TableName.Name}_{columns}");
}