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

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

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

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

namespace Data.Adapter.Sqlite.Test
{
    public class QueryableSqlBuilderTests : DbContextTests
    {
        public QueryableSqlBuilderTests(ITestOutputHelper output) : base(output)
        {
        }

        internal QueryableSqlBuilder CreateBuilder()
        {
            var queryBody = new QueryBody(_serviceProvider.GetService<IArticleRepository>());
            queryBody.Joins.Add(new QueryJoin(_dbContext.EntityDescriptors.FirstOrDefault(m => m.TableName == "Article"), "T1"));
            return new QueryableSqlBuilder(queryBody);
        }

        #region ==解析排序==

        //解析排序测试
        [Fact]
        public void ResolveSortTest()
        {
            var builder = CreateBuilder();

            Expression<Func<ArticleEntity, string>> exp = m => m.Title;
            builder.QueryBody.SetSort(exp, SortType.Asc);
            Assert.Equal(" ORDER BY [Title] ASC", builder.ResolveSort());
        }

        //解析排序测试
        [Fact]
        public void ResolveSortForSqlTest()
        {
            var builder = CreateBuilder();

            builder.QueryBody.SetSort("Title", SortType.Asc);
            Assert.Equal(" ORDER BY Title ASC", builder.ResolveSort());
        }

        //解析排序，针对字符串的Substring函数
        [Fact]
        public void ResolveSortForSubstringTest()
        {
            var builder = CreateBuilder();

            Expression<Func<ArticleEntity, string>> exp = m => m.Title.Substring(1);
            builder.QueryBody.SetSort(exp, SortType.Asc);
            Assert.Equal(" ORDER BY SUBSTR([Title],2) ASC", builder.ResolveSort());
        }