using System.Text;
using XCode.DataAccessLayer;
namespace XCoderMac.Services;
/// <summary>
/// Windows æ•°æ®å·¥å…·æ ¸å¿ƒæ“作的 Mac 适é…层。
/// 全部调用 XCode 自带的 DAL.Import / Export / Metadata,且ä¸ä¼šæ‚„悄修改数æ®åº“。
/// </summary>
public static class MacDataToolsService
{
public static List<IDataTable> ImportXml(string xml)
{
if (string.IsNullOrWhiteSpace(xml)) throw new InvalidDataException("XML 文件为空");
var result = DAL.Import(xml) ?? throw new InvalidDataException("XCode 未返回任何模型");
return result.ToList();
}
public static List<IDataTable> ImportFile(string path) =>
ImportXml(File.ReadAllText(path));
public static string ExportXml(IEnumerable<IDataTable> tables)
{
var list = tables.ToList();
if (list.Count == 0) throw new InvalidOperationException("当剿²¡æœ‰å¯å¯¼å‡ºçš„æ•°æ®è¡¨");
return DAL.Export(list);
}
// ç¼–è¾‘å‰¯æœ¬ï¼šå–æ¶ˆç¼–辑时ä¸ä¼šæ±¡æŸ“主窗体原始数æ®åº“表对象。
public static List<IDataTable> CloneModel(IEnumerable<IDataTable> tables) =>
ImportXml(ExportXml(tables));
public static string CreateTableSql(IMetaData metadata, IDataTable table)
{
var builder = new StringBuilder();
void Add(DDLSchema action, object obj)
{
var sql = metadata.GetSchemaSQL(action, obj);
if (string.IsNullOrWhiteSpace(sql)) return;
builder.Append(sql.Trim().TrimEnd(';')).AppendLine(";").AppendLine();
}
Add(DDLSchema.CreateTable, table);
if (!string.IsNullOrWhiteSpace(table.Description))
Add(DDLSchema.AddTableDescription, table);
foreach (var column in table.Columns)
if (!string.IsNullOrWhiteSpace(column.Description))
Add(DDLSchema.AddColumnDescription, column);
foreach (var index in table.Indexes)
if (!index.PrimaryKey)
Add(DDLSchema.CreateIndex, index);
return builder.ToString();
}
public static string CreateAllSql(IMetaData metadata, IEnumerable<IDataTable> tables) =>
string.Join(Environment.NewLine, tables.Select(t => CreateTableSql(metadata, t)));
public static void ValidateModel(IEnumerable<IDataTable> tables)
{
var all = tables.ToList();
if (all.Count == 0) throw new InvalidOperationException("模型ä¸è‡³å°‘需è¦ä¸€å¼ 表");
if (all.Any(t => string.IsNullOrWhiteSpace(t.Name) ||
string.IsNullOrWhiteSpace(t.TableName)))
throw new InvalidOperationException("表å和实体åç§°ä¸èƒ½ä¸ºç©º");
if (all.GroupBy(t => t.TableName, StringComparer.OrdinalIgnoreCase).Any(g => g.Count() > 1))
throw new InvalidOperationException("æ¨¡åž‹å«æœ‰é‡å¤çš„æ•°æ®åº“表å");
foreach (var table in all)
{
if (table.Columns.GroupBy(c => c.ColumnName, StringComparer.OrdinalIgnoreCase)
.Any(g => g.Count() > 1))
throw new InvalidOperationException($"æ•°æ®è¡¨ {table.Name} ä¸å˜åœ¨é‡å¤å—段å");
if (table.Columns.Any(c => string.IsNullOrWhiteSpace(c.Name) ||
string.IsNullOrWhiteSpace(c.ColumnName)))
throw new InvalidOperationException($"æ•°æ®è¡¨ {table.Name} å˜åœ¨ç©ºå—段å");
foreach (var index in table.Indexes)
{
if (index.Columns is not { Length: > 0 } ||
index.Columns.Any(name => table.Columns.All(c =>
!c.ColumnName.Equals(name, StringComparison.OrdinalIgnoreCase))))
throw new InvalidOperationException($"表 {table.Name} ä¸ç´¢å¼• {index.Name} 引用了ä¸å˜åœ¨çš„å—æ®µ");
}
}
}
}
|