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

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

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

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

namespace Data.Adapter.Sqlite.Test
{
    /// <summary>
    /// 多表测试
    /// </summary>
    public class MultiTableQueryableSqlBuilderTests : DbContextTests
    {
        private readonly QueryableSqlBuilder _builder;
        private readonly QueryBody _queryBody;
        public MultiTableQueryableSqlBuilderTests(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));
            _builder = new QueryableSqlBuilder(_queryBody);
        }

        #region ==解析排序==

        //解析排序测试
        [Fact]
        public void ResolveSortTest()
        {
            Expression<Func<IQueryableJoins<ArticleEntity, CategoryEntity>, string>> exp = m => m.T1.Title;
            _queryBody.SetSort(exp, SortType.Asc);
            Assert.Equal(" ORDER BY T1.[Title] ASC", _builder.ResolveSort());
        }

        //解析排序测试
        [Fact]
        public void ResolveSortForSqlTest()
        {
            _queryBody.SetSort("T1.Title", SortType.Asc);
            Assert.Equal(" ORDER BY T1.Title ASC", _builder.ResolveSort());
        }

        //解析排序，针对字符串的Substring函数
        [Fact]
        public void ResolveSortForSubstringTest()
        {
            Expression<Func<IQueryableJoins<ArticleEntity, CategoryEntity>, string>> exp = m => m.T1.Title.Substring(1);
            _queryBody.SetSort(exp, SortType.Asc);
            Assert.Equal(" ORDER BY SUBSTR(T1.[Title],2) ASC", _builder.ResolveSort());
        }

        //解析排序，针对字符串的Length属性