test/02_Data/Data.Adapter.MySql.Test/RepositoryTest.cs

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

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

using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Data.Common.Test.Domain.Article;
using Microsoft.Extensions.DependencyInjection;
using Mkh.Data.Abstractions.Extensions;
using Mkh.Data.Abstractions.Pagination;
using Xunit;
using Xunit.Abstractions;

namespace Data.Adapter.MySql.Test
{
    public class RepositoryTest : BaseTest
    {
        private const string Select =
            "SELECT `Id` AS `Id`,`CategoryId` AS `CategoryId`,`Title` AS `Title`,`Content` AS `Content`,`IsPublished` AS `Published`,`PublishedTime` AS `PublishedTime`,`Price` AS `Price`,`Deleted` AS `Deleted`,`DeletedBy` AS `DeletedBy`,`Deleter` AS `Deleter`,`DeletedTime` AS `DeletedTime`,`CreatedBy` AS `CreatedBy`,`Creator` AS `Creator`,`CreatedTime` AS `CreatedTime`,`ModifiedBy` AS `ModifiedBy`,`Modifier` AS `Modifier`,`ModifiedTime` AS `ModifiedTime` FROM `Article`";

        public RepositoryTest(ITestOutputHelper output) : base(output)
        {
        }

        [Fact]
        public async void AddTest()
        {
            await ClearTable();

            var article = new ArticleEntity
            {
                Title = "test",
                Content = "test"
            };

            var b = await _articleRepository.Add(article);
            /*INSERT INTO `Article` (`CategoryId`,`Title`,`Content`,`Published`,`PublishedTime`,`TimeSpan`,`CreatedBy`,
            `Creator`,`CreatedTime`,`ModifiedBy`,`Modifier`,`ModifiedTime`) VALUES(@CategoryId,@Title,@Content,@Published,
            @PublishedTime,@TimeSpan,@CreatedBy,@Creator,@CreatedTime,@ModifiedBy,@Modifier,@ModifiedTime);*/

            Assert.True(b);
            Assert.True(article.Id > 0);

            var article1 = await _articleRepository.Get(article.Id);

            Assert.Equal(article.Title, article1.Title);
            Assert.Equal("OLDLI", article1.Creator);
        }

        [Fact]
        public async void DeleteTest()
        {
            var article = new ArticleEntity
            {
                Title = "test",
                Content = "test"
            };

            await _articleRepository.Add(article);

            Assert.True(article.Id > 0);

            var result = await _articleRepository.Delete(article.Id);