public static string GenerateAccessorKey(DbContextAccessorBase accessor,
string invokeTypeName, Type designTimeType = null, params string[] partialKeys)
{
accessor.NotNull(nameof(accessor));
invokeTypeName.NotNull(nameof(invokeTypeName));
var connector = DataSettings.Preference.AccessorIsolateableStringConnector;
var builder = new StringBuilder();
builder.Append(invokeTypeName);
builder.Append(connector);
AppendAccessorIsolateableString(accessor, builder, connector, designTimeType);
partialKeys.ForEach((key, index) =>
{
builder.Append(key);
if (index < partialKeys.Length - 1)
{
builder.Append(connector);
}
});
return(builder.ToString());
}
public static FilePathCombiner GenerateAccessorFilePath(DbContextAccessorBase accessor,
string extension, string basePath = null, Type designTimeType = null)
{
accessor.NotNull(nameof(accessor));
extension.NotEmpty(nameof(extension));
var filePath = new FilePathCombiner(GetAccessorFileName(), basePath);
filePath.CreateDirectory();
return(filePath);
// GetAccessorFileName
string GetAccessorFileName()
{
var connector = DataSettings.Preference.AccessorIsolateableStringConnector;
var builder = new StringBuilder();
AppendAccessorIsolateableString(accessor, builder, connector, designTimeType);
builder.Append(extension);
return(builder.ToString());
}
}
public static void ConfigureDataStores <TAudit, TAuditProperty, TMigration, TTabulation, TTenant, TGenId, TIncremId, TCreatedBy>
(this ModelBuilder modelBuilder, DbContextAccessorBase accessor)
where TAudit : DataAudit <TGenId, TCreatedBy>
where TAuditProperty : DataAuditProperty <TIncremId, TGenId>
where TMigration : DataMigration <TGenId, TCreatedBy>
where TTabulation : DataTabulation <TGenId, TCreatedBy>
where TTenant : DataTenant <TGenId, TCreatedBy>
where TGenId : IEquatable <TGenId>
where TIncremId : IEquatable <TIncremId>
where TCreatedBy : IEquatable <TCreatedBy>
{
modelBuilder.NotNull(nameof(modelBuilder));
accessor.NotNull(nameof(accessor));
var maxLength = accessor.Dependency.Options.Stores.MaxLengthForProperties;
var protectPrivacyData = accessor.Dependency.Options.Stores.ProtectPrivacyData;
var tables = accessor.Dependency.Options.Tables;
var isGenIdString = typeof(TGenId).IsStringType();
if (tables.DefaultSchema.IsNotEmpty())
{
modelBuilder.HasDefaultSchema(tables.DefaultSchema);
}
// 审计
modelBuilder.Entity <TAudit>(b =>
{
b.ToTable(t =>
{
if (tables.UseDataPrefix)
{
t.InsertDataPrefix();
}
t.Configure(tables.Audit);
});
b.HasIndex(i => new { i.TableName, i.EntityId, i.State }).HasName().IsUnique();
b.HasKey(k => k.Id);
b.Property(p => p.Id).ValueGeneratedNever();
if (maxLength > 0)
{
if (isGenIdString)
{
b.Property(p => p.Id).HasMaxLength(maxLength);
}
b.Property(p => p.EntityId).HasMaxLength(maxLength).IsRequired();
b.Property(p => p.TableName).HasMaxLength(maxLength).IsRequired();
b.Property(p => p.StateName).HasMaxLength(maxLength);
// 在 MySQL 中如果长度超出 255 会被转换为不能作为主键或唯一性约束 的 BLOB/TEXT 类型
b.Property(p => p.EntityTypeName).HasMaxLength(maxLength);
}
});
// 审计属性
modelBuilder.Entity <TAuditProperty>(b =>
{
b.ToTable(t =>
{
if (tables.UseDataPrefix)
{
t.InsertDataPrefix();
}
// 按年月分表
t.AppendYearAndMonthSuffix(accessor.CurrentTimestamp)
.Configure(tables.AuditProperty);
});
b.HasIndex(i => new { i.AuditId }).HasName();
b.HasKey(k => k.Id);
b.Property(x => x.Id).ValueGeneratedOnAdd();
if (maxLength > 0)
{
b.Property(p => p.AuditId).HasMaxLength(maxLength).IsRequired();
b.Property(p => p.PropertyName).HasMaxLength(maxLength);
b.Property(p => p.PropertyTypeName).HasMaxLength(maxLength);
}
// MaxLength
b.Property(p => p.OldValue);
b.Property(p => p.NewValue);
});
// 迁移
modelBuilder.Entity <TMigration>(b =>
{
b.ToTable(t =>
{
if (tables.UseDataPrefix)
{
t.InsertDataPrefix();
}
t.Configure(tables.Migration);
});
b.HasIndex(i => i.ModelHash).HasName().IsUnique();
b.HasKey(k => k.Id);
b.Property(p => p.Id).ValueGeneratedNever();
if (maxLength > 0)
{
if (isGenIdString)
{
b.Property(p => p.Id).HasMaxLength(maxLength);
}
b.Property(p => p.ModelHash).HasMaxLength(maxLength).IsRequired();
b.Property(p => p.AccessorName).HasMaxLength(maxLength);
b.Property(p => p.ModelSnapshotName).HasMaxLength(maxLength);
}
});
// 表格
modelBuilder.Entity <TTabulation>(b =>
{
b.ToTable(t =>
{
if (tables.UseDataPrefix)
{
t.InsertDataPrefix();
}
t.Configure(tables.Tabulation);
});
b.HasIndex(i => new { i.Schema, i.TableName }).HasName().IsUnique();
b.HasKey(k => k.Id);
b.Property(p => p.Id).ValueGeneratedNever();
if (maxLength > 0)
{
if (isGenIdString)
{
b.Property(p => p.Id).HasMaxLength(maxLength);
}
b.Property(p => p.Schema).HasMaxLength(maxLength).IsRequired();
b.Property(p => p.TableName).HasMaxLength(maxLength).IsRequired();
b.Property(p => p.EntityName).HasMaxLength(maxLength);
b.Property(p => p.AssemblyName).HasMaxLength(maxLength);
b.Property(p => p.Description).HasMaxLength(maxLength);
}
b.Property(p => p.IsSharding).HasDefaultValue(false);
});
// 租户
modelBuilder.Entity <TTenant>(b =>
{
b.ToTable(t =>
{
if (tables.UseDataPrefix)
{
t.InsertDataPrefix();
}
t.Configure(tables.Tenant);
});
b.HasIndex(i => new { i.Name, i.Host }).HasName().IsUnique();
b.HasKey(k => k.Id);
b.Property(p => p.Id).ValueGeneratedNever();
if (maxLength > 0)
{
if (isGenIdString)
{
b.Property(p => p.Id).HasMaxLength(maxLength);
}
b.Property(p => p.Name).HasMaxLength(maxLength).IsRequired();
b.Property(p => p.Host).HasMaxLength(maxLength).IsRequired();
b.Property(p => p.DefaultConnectionString).HasMaxLength(maxLength).IsRequired();
b.Property(p => p.WritingConnectionString).HasMaxLength(maxLength);
}
if (protectPrivacyData)
{
var protector = accessor.GetService <IPrivacyDataProtector>();
b.ConfigurePrivacyData(protector);
}
});
}