using System;
using System.ComponentModel;
using System.IO;
using System.Linq;
using NewLife;
using XCode.DataAccessLayer;
using Xunit;
namespace XCoder.App.Tests;
/// <summary>数据层集成测试:用 SQLite 临时库验证「数据建模读取」与「跨库同步」的真实行为</summary>
/// <remarks>
/// 不依赖任何外部数据库服务:两个临时 .db 文件即充当源库与目标库,
/// 覆盖 DAL 连接注册、表结构读取(DEV-1 的输入)与 Sync 同步(DEV-2 的执行)。
/// </remarks>
public class DataLayerIntegrationTests : IDisposable
{
private readonly String _dir;
private readonly String _sourceName;
private readonly String _targetName;
public DataLayerIntegrationTests()
{
_dir = Path.Combine(Path.GetTempPath(), "xcoder-dal-" + Guid.NewGuid().ToString("N"));
Directory.CreateDirectory(_dir);
_sourceName = "xcoder_src_" + Guid.NewGuid().ToString("N")[..8];
_targetName = "xcoder_dst_" + Guid.NewGuid().ToString("N")[..8];
DAL.AddConnStr(_sourceName, $"Data Source={Path.Combine(_dir, "src.db")}", null, "SQLite");
DAL.AddConnStr(_targetName, $"Data Source={Path.Combine(_dir, "dst.db")}", null, "SQLite");
}
public void Dispose()
{
try
{
DAL.ConnStrs.Remove(_sourceName);
}
catch (Exception)
{
// 连接串可能已被移除
}
try
{
DAL.ConnStrs.Remove(_targetName);
}
catch (Exception)
{
// 连接串可能已被移除
}
try
{
if (Directory.Exists(_dir)) Directory.Delete(_dir, true);
}
catch (Exception)
{
// 文件被占用时忽略
}
}
[Fact]
[DisplayName("读取 SQLite 表结构可得到表名、字段与主键")]
public void ReadTables_ReturnsSchema()
{
var dal = DAL.Create(_sourceName);
dal.Execute("create table users(id integer primary key autoincrement, name varchar(50) not null, age int)");
dal.Execute("create table logs(id integer primary key autoincrement, message text)");
var tables = dal.Tables;
Assert.NotNull(tables);
Assert.True(tables!.Count >= 2);
var users = tables.First(e => e.TableName.EqualIgnoreCase("users"));
Assert.Contains(users.Columns, c => c.Name.EqualIgnoreCase("name"));
Assert.Contains(users.Columns, c => c.Name.EqualIgnoreCase("age"));
Assert.NotEmpty(users.Columns);
}
[Fact]
[DisplayName("跨库同步把表结构与数据复制到目标库")]
public void Sync_CopiesTableAndRows()
{
var source = DAL.Create(_sourceName);
var target = DAL.Create(_targetName);
source.Execute("create table items(id integer primary key autoincrement, name varchar(50))");
source.Execute("insert into items(name) values('a')");
source.Execute("insert into items(name) values('b')");
var table = source.Tables!.First(e => e.TableName.EqualIgnoreCase("items"));
source.Db.ShowSQL = false;
source.Session.ShowSQL = false;
var count = source.Sync(table, _targetName, true);
Assert.True(count >= 0);
var targetTables = target.Tables;
Assert.NotNull(targetTables);
Assert.Contains(targetTables!, e => e.TableName.EqualIgnoreCase("items"));
var rows = target.SelectCount(new SelectBuilder { Table = "items" });
Assert.Equal(2, rows);
}
[Fact]
[DisplayName("重复同步会再次写入数据(Sync 不自动去重,界面需提示)")]
public void Sync_SecondRunAppendsRows()
{
var source = DAL.Create(_sourceName);
var target = DAL.Create(_targetName);
source.Execute("create table keys(id integer primary key autoincrement, code varchar(20))");
source.Execute("insert into keys(code) values('k1')");
var table = source.Tables!.First(e => e.TableName.EqualIgnoreCase("keys"));
source.Db.ShowSQL = false;
source.Session.ShowSQL = false;
source.Sync(table, _targetName, true);
Assert.Equal(1, target.SelectCount(new SelectBuilder { Table = "keys" }));
// 再次同步不会自动清空目标表,因此行数再次增加;这是 XCode Sync 的既定语义
source.Sync(table, _targetName, true);
Assert.Equal(2, target.SelectCount(new SelectBuilder { Table = "keys" }));
}
[Fact]
[DisplayName("SQL 工作台的查询判定与连接注册协同工作")]
public void SqlWorkbench_QueryAgainstSqlite()
{
var dal = DAL.Create(_sourceName);
dal.Execute("create table demo(id integer primary key autoincrement, title varchar(50))");
dal.Execute("insert into demo(title) values('hello')");
var ds = dal.Select("select title from demo", System.Data.CommandType.Text, (System.Data.IDataParameter[]?)null);
Assert.NotNull(ds);
Assert.NotEmpty(ds.Tables);
Assert.Equal("hello", ds.Tables[0].Rows[0][0]?.ToString());
}
[Fact]
[DisplayName("未注册的连接名走默认连接,不抛异常")]
public void Create_UnknownConnection_UsesFallback()
{
var dal = DAL.Create("no_such_conn_" + Guid.NewGuid().ToString("N"));
// XCode 对未注册名称回落默认连接,Creator 名称与请求不同即可判定已回落
Assert.NotNull(dal);
Assert.NotEqual("no_such_conn", dal.ConnName);
}
}
|