53 lines
2.6 KiB
C#
53 lines
2.6 KiB
C#
using Microsoft.EntityFrameworkCore.Metadata;
|
||
using Microsoft.EntityFrameworkCore.Storage;
|
||
using YLErp.BLL;
|
||
using YLErp.DBModels;
|
||
|
||
namespace YLErp.Modules.SwapModule
|
||
{
|
||
/// <summary>
|
||
/// 新建表列名规范测试（2026-08-20 约定：新建表所有数据库列一律小写下划线）。
|
||
/// 只构建 EF 模型（纯内存，不连库），断言映射列名不含大写字母：
|
||
/// client_credit_inout 全表、swap_position.fund_tag、credit.original_credit/max_credit_use_ratio。
|
||
/// 基类操作人列（OptId/OptName/OptTime）经 override+[Column] 覆写为小写，此处一并守护。
|
||
/// </summary>
|
||
[TestClass]
|
||
public class DbColumnNamingTest
|
||
{
|
||
[TestMethod]
|
||
public void DB_001_授信出入表_全部列名小写()
|
||
{
|
||
using var db = new YLContext();
|
||
var entity = db.Model.FindEntityType(typeof(client_credit_inout));
|
||
Assert.IsNotNull(entity, "client_credit_inout 未注册到 YLContext");
|
||
var table = StoreObjectIdentifier.Table("client_credit_inout", null);
|
||
foreach (var property in entity.GetProperties())
|
||
{
|
||
var column = property.GetColumnName(table);
|
||
Assert.IsNotNull(column, $"属性 {property.Name} 未映射列名");
|
||
Assert.IsFalse(column.Any(char.IsUpper), $"列名应全小写: {column}（属性 {property.Name}）");
|
||
}
|
||
}
|
||
|
||
[TestMethod]
|
||
public void DB_002_互换持仓与授信表_新增列名小写()
|
||
{
|
||
using var db = new YLContext();
|
||
AssertColumn(db, typeof(swap_position), nameof(swap_position.FundTag), "fund_tag");
|
||
AssertColumn(db, typeof(CreditTable), nameof(CreditTable.OriginalCredit), "original_credit");
|
||
AssertColumn(db, typeof(CreditTable), nameof(CreditTable.MaxCreditUseRatio), "max_credit_use_ratio");
|
||
}
|
||
|
||
private static void AssertColumn(YLContext db, Type entityType, string propertyName, string expectedColumn)
|
||
{
|
||
var entity = db.Model.FindEntityType(entityType);
|
||
Assert.IsNotNull(entity, $"{entityType.Name} 未注册到 YLContext");
|
||
var property = entity.FindProperty(propertyName);
|
||
Assert.IsNotNull(property, $"属性 {propertyName} 不在 {entityType.Name} 映射中");
|
||
var table = StoreObjectIdentifier.Create(entity, StoreObjectType.Table).Value;
|
||
var column = property.GetColumnName(table);
|
||
Assert.AreEqual(expectedColumn, column, $"{entityType.Name}.{propertyName} 映射列名不符");
|
||
}
|
||
}
|
||
}
|