Exemple #1
0
        public static BlogDbContextProvider Create()
        {
            var provider = new BlogDbContextProvider();

            using (var ctx = provider.CreateContext())
            {
                ctx.Database.Migrate();
            }

            return(provider);
        }
        public async Task ShouldSaveTheTagsOfThePostAsExpected()
        {
            using (var provider = BlogDbContextProvider.Create())
            {
                string userId = Guid.NewGuid().ToString();
                using (var context = provider.CreateContext())
                {
                    var user = new IdentityUser
                    {
                        Id       = userId,
                        UserName = TestUtils.RandomString(),
                        Email    = $"{TestUtils.RandomString()}@{TestUtils.RandomString()}.com"
                    };

                    await context.Users.AddAsync(user);

                    await context.SaveChangesAsync();
                }

                var postId = Guid.NewGuid();
                var tags   = new[]
                {
                    TestUtils.RandomString(),
                    TestUtils.RandomString()
                };

                using (var context = provider.CreateContext())
                {
                    const string ipAddress = "127.0.0.1";
                    var          user      = await context.Users.FirstOrDefaultAsync(x => x.Id == userId);

                    var post = new PostEntity
                    {
                        Id                = postId,
                        Language          = "en-US",
                        Title             = TestUtils.RandomString(),
                        Abstract          = TestUtils.RandomString(40),
                        Content           = TestUtils.RandomString(200),
                        Format            = PostFormatEntity.PlainText,
                        CreatedBy         = user,
                        CreatedOnUtc      = DateTime.UtcNow,
                        CreationIpAddress = ipAddress,
                        Tags              = new Collection <PostTagEntity>(tags.Select(t => new PostTagEntity
                        {
                            Tag = new TagEntity
                            {
                                Name              = t,
                                Slug              = TestUtils.RandomString(),
                                CreatedBy         = user,
                                CreatedOnUtc      = DateTime.UtcNow,
                                CreationIpAddress = ipAddress
                            }
                        }).ToList())
                    };

                    await context.Posts.AddAsync(post);

                    await context.SaveChangesAsync();
                }

                using (var context = provider.CreateContext())
                {
                    // see https://docs.microsoft.com/en-us/ef/core/querying/related-data
                    var post = await context.Posts.Include(x => x.Tags)
                               .ThenInclude((PostTagEntity x) => x.Tag)
                               .AsNoTracking()
                               .FirstOrDefaultAsync(x => x.Id == postId);

                    var tagNames = post.Tags.Select(x => x.Tag.Name);

                    Assert.Equal(tags, tagNames);
                }
            }
        }
Exemple #3
0
        public async Task FindApprovedPostById_ShouldFindThePostWhenItExistsAndApproved()
        {
            using (var provider = BlogDbContextProvider.Create())
            {
                var postId           = Guid.NewGuid();
                var expectedTitle    = TestUtils.RandomString();
                var expectedAbstract = TestUtils.RandomString(40);

                using (var context = provider.CreateContext())
                {
                    const string ipAddress = "127.0.0.1";
                    string       userId    = Guid.NewGuid().ToString();
                    var          user      = new IdentityUser
                    {
                        Id       = userId,
                        UserName = TestUtils.RandomString(),
                        Email    = $"{TestUtils.RandomString()}@{TestUtils.RandomString()}.com"
                    };

                    var post = new PostEntity
                    {
                        Id                = postId,
                        Language          = "en-US",
                        Title             = expectedTitle,
                        Abstract          = expectedAbstract,
                        Content           = TestUtils.RandomString(200),
                        Format            = PostFormatEntity.PlainText,
                        CreatedBy         = user,
                        CreatedOnUtc      = DateTime.UtcNow,
                        CreationIpAddress = ipAddress,
                        Tags              = new Collection <PostTagEntity>((new[]
                        {
                            TestUtils.RandomString(),
                            TestUtils.RandomString()
                        }).Select(t => new PostTagEntity
                        {
                            Tag = new TagEntity
                            {
                                Name              = t,
                                Slug              = TestUtils.RandomString(),
                                CreatedBy         = user,
                                CreatedOnUtc      = DateTime.UtcNow,
                                CreationIpAddress = ipAddress
                            }
                        }).ToList())
                    };

                    await context.Users.AddAsync(user);

                    await context.Posts.AddAsync(post);

                    await context.SaveChangesAsync();
                }

                using (var context = provider.CreateContext())
                {
                    var store  = new PostsSqlServerRepository(context);
                    var result = await store.FindApprovedPostById(postId.ToString());

                    result.Match(
                        some =>
                    {
                        some.Switch(
                            found =>
                        {
                            var post = found;
                            Assert.Equal(postId.ToString(), post.Id);
                            Assert.Equal(expectedTitle, post.Title);
                            Assert.Equal(expectedAbstract, post.Abstract);
                        },

                            notApproved =>
                        {
                            Assert.True(false, $"Result shouldn't be {notApproved.GetType().ToString()}");
                        });
                    },
                        () =>
                    {
                        Assert.True(false, $"Result shouldn't be Option.None");
                    });
                }
            }
        }