User Activities - Healthbit | ASP.NET Zero Support

Unit tests with multiple db contexts #7198

5 years ago Answer

@ismcagdas even all the default tests are not woking. All tests are ending with Microsoft.Data.Sqlite.SqliteException : SQLite Error 1: 'no such table: xxxx'.

CommerceDbContext.cs

using Abp.IdentityServer4;
using Abp.Zero.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore;
using CommerceDemo.Authorization.Roles;
using CommerceDemo.Authorization.Users;
using CommerceDemo.Chat;
using CommerceDemo.Editions;
using CommerceDemo.Friendships;
using CommerceDemo.MultiTenancy;
using CommerceDemo.MultiTenancy.Accounting;
using CommerceDemo.MultiTenancy.Payments;
using CommerceDemo.Storage;

namespace CommerceDemo.EntityFrameworkCore
{
    public class CommerceDbContext : AbpZeroDbContext<Tenant, Role, User, CommerceDbContext>, IAbpPersistedGrantDbContext
    {
        /* Define an IDbSet for each entity of the application */

        public virtual DbSet<CommerceDemo.Main.Items.Item> Items { get; set; }
 


		public virtual DbSet<PersistedGrantEntity> PersistedGrants { get; set; }
        public CommerceDbContext(DbContextOptions<CommerceDbContext> options)
            : base(options)
        {
            
        }
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);

             
            modelBuilder.ConfigurePersistedGrantEntity();
        }
    }
}

ItemAppService_Tests.cs

using System.Globalization;
using System.Linq;
using System.Threading.Tasks;
using Abp;
using Abp.Application.Services.Dto;
using Abp.Localization;
using CommerceDemo.Main.Items;
using CommerceDemo.Localization;
using CommerceDemo.Localization.Dto;
using CommerceDemo.Migrations.Seed.Host;
using CommerceDemo.Test.Base;
using Shouldly;
using Xunit;

namespace CommerceDemo.Tests.Main.Items
{
    // ReSharper disable once InconsistentNaming
    public class ItemAppService_Tests : AppTestBase
    {
        private readonly IItemAppService _ItemAppService;
        private readonly bool _multiTenancyEnabled  = CommerceDemoConsts.MultiTenancyEnabled;

        public ItemAppService_Tests()
        {
            if (_multiTenancyEnabled)
            {
                LoginAsHostAdmin();
            }
            else
            {
                LoginAsDefaultTenantAdmin();
            }

			_ItemAppService = Resolve<IItemAppService>();
 
        }

        [Fact]
        public async Task Test_GetItems()
        {
            //Act
            var output = await _ItemAppService.GetItems( new CommerceDemo.Main.Items.Dto.GetItemsInput());

            //Assert
            output.Items.Count.ShouldBeGreaterThan(0); ;
        }

    
    }
}

Activities of "Healthbit"