借助网络配置,控制Modbus工具的日志显示,避免卡死界面
智能大石头 authored at 2021-12-11 22:09:19
5.44 KiB
XCoder
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);
    }
}