public ForeignKeyVisitor(IReadOnlyList <string> currentPath, SqlFieldConfiguration <TForeignEntity> sqlFieldConfiguration)
{
_currentPath = currentPath
.Concat(sqlFieldConfiguration.Options.ForeignKeyFieldPath.Path)
.ToArray();
_sqlFieldConfiguration = sqlFieldConfiguration;
_joinSpecification = null;
}
private static SqlFieldConfiguration CreateFieldConfiguration(PropertyField field, FieldGraphPath <PropertyField> graphPath)
{
var fieldConfig = SqlFieldConfiguration.Create(field)
.ColumnName(string.Join("_", graphPath.Path))
.DataType(SqlTypeHelper.GetDataType(field.FieldType.Type))
.IsNullable(SqlTypeHelper.TypeIsNullable(field.FieldType.Type));
fieldConfig.PropertyPath = graphPath;
return(fieldConfig);
}
public void Apply(BuildContext context, BuildStep buildStep, SqlEntityConfiguration sqlEntityConfiguration,
SqlDataModelBuilder sqlDataModelBuilder)
{
if (buildStep != BuildStep.DefineRelationships)
{
return;
}
var typeModel = TypeModel.GetModelOf(sqlEntityConfiguration.EntityType);
ModelFields(typeModel.Fields, new string[0]);
void ModelFields(IReadOnlyList <PropertyField> fields, string[] parentPath)
{
foreach (var field in fields)
{
var fieldGraphPath = new FieldGraphPath <PropertyField>(
parentPath.Concat(new[] { field.FieldName }).ToArray(),
field
);
if (SqlTypeHelper.GetDataType(field.FieldType.Type) == null)
{
if (!IsRegisteredEntity(context, field.FieldType.Type))
{
ModelFields(field.FieldModel.Fields, fieldGraphPath.Path);
}
else
{
// build a fk relationship
var model = context.SqlBuilders.First(q => q.EntityType == field.FieldType.Type);
var foreignKeyField = model.ModelledFields.FirstOrDefault(q => q.Options.IsPrimaryKey);
if (foreignKeyField == null)
{
throw new Exception("Referenced entity missing primary key field.");
}
var fieldConfig = SqlFieldConfiguration.Create(field)
.ColumnName($"{string.Join("_", fieldGraphPath.Path)}_{foreignKeyField.Options.ColumnName}")
.DataType(foreignKeyField.Options.SqlDataType)
.IsNullable(true)
.ForeignKey(foreignKeyField.PropertyPath);
fieldConfig.PropertyPath = fieldGraphPath;
sqlDataModelBuilder.ModelledFields.Add(fieldConfig);
}
}
}
}
}
private IModelNode CreateLocalStorageField <T>(SqlFieldConfiguration <T> fieldConfiguration, IEnumerable <string> path,
IModelFieldOf <T> field)
{
if (fieldConfiguration.Options.IsForeignKey)
{
// todo: the pattern employed here only permits one foreign key to entities
// to support more complex foreign key relationships this needs to be adjusted
return(new ForeignKeyVisitor <TEntity, T>(_currentPath, fieldConfiguration)
.Visit(fieldConfiguration.Options.ForeignKeyFieldPath.Field));
}
return(new SqlStorageField <TEntity, T>(
string.Join("_", path), true, true,
fieldConfiguration.Options.IsServerGenerated,
fieldConfiguration.Options.ColumnName,
fieldConfiguration.Options.DefaultValue,
fieldConfiguration.Options.IsPrimaryKey,
new FieldGraphPath <PropertyField>(path.ToArray(), field as PropertyField)));
}
public ConfiguredFieldPolicy(SqlFieldConfiguration fieldConfiguration)
{
FieldConfiguration = fieldConfiguration;
}