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

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

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

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

namespace Data.Adapter.SqlServer.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] WITH (NOLOCK)";

        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);
            //DELETE FROM [Article]  WHERE [Id]=@Id;