test/02_Data/Data.Adapter.Sqlite.Test/MultiTableExpressionResolverTests.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Text;
using Data.Common.Test.Domain.Article;
using Data.Common.Test.Domain.Category;
using Microsoft.Extensions.DependencyInjection;
using Mkh.Data.Abstractions.Extensions;
using Mkh.Data.Abstractions.Queryable;
using Mkh.Data.Core.Internal;
using Mkh.Data.Core.Internal.QueryStructure;
using Xunit;
using Xunit.Abstractions;

namespace Data.Adapter.Sqlite.Test
{
    /*
     * 多表连接表达式解析测试
     */
    public class MultiTableExpressionResolverTests : DbContextTests
    {
        private readonly QueryBody _queryBody;

        public MultiTableExpressionResolverTests(ITestOutputHelper output) : base(output)
        {
            _queryBody = new QueryBody(_serviceProvider.GetService<IArticleRepository>());
            _queryBody.Joins.Add(new QueryJoin(_dbContext.EntityDescriptors.FirstOrDefault(m => m.TableName == "Article"), "T1"));
            Expression<Func<ArticleEntity, CategoryEntity, bool>> exp = (m, n) => m.CategoryId == n.Id;
            _queryBody.Joins.Add(new QueryJoin(_dbContext.EntityDescriptors.FirstOrDefault(m => m.TableName == "MyCategory"), "T2", JoinType.Left, exp));
        }

        /// <summary>
        /// 解析表达式
        /// </summary>
        [Fact]
        public void ResolveExpressionTest()
        {
            var parameters = new QueryParameters();
            Expression<Func<IQueryableJoins<ArticleEntity, CategoryEntity>, bool>> exp = m => m.T1.Id > 10 && m.T2.Name == "mkh";
            var sql = ExpressionResolver.Resolve(_queryBody, exp, parameters);

            Assert.Equal("T1.[Id] > @P1 AND T2.[Name] = @P2", sql);
            Assert.Equal(2, parameters.Count);
            Assert.Equal("mkh", parameters[1].Value);
        }

        /// <summary>
        /// 解析表达式
        /// </summary>
        [Fact]
        public void ResolveExpressionTest1()
        {
            Expression<Func<IQueryableJoins<ArticleEntity, CategoryEntity>, bool>> exp = m => m.T1.Id > 10 && m.T1.Id < 20 && m.T2.Name == "123";

            var parameters = new QueryParameters();
            var sql = ExpressionResolver.Resolve(_queryBody, exp, parameters);

            Assert.Equal("T1.[Id] > @P1 AND T1.[Id] < @P2 AND T2.[Name] = @P3", sql);
            Assert.Equal(3, parameters.Count);