Unit Testing w/Live DB #3616

bbakermmc created 6 years ago

Is there a way to setup a unit test/appservice/change out the context to use a read DB instead of in memory?

12 Answer(s)

0

ismcagdas created 6 years ago
Support Team

Hi @BBakerMMC,

Do you use ASP.NET Core version or ASP.NET MVC 5.x ?

Thanks.
0

bbakermmc created 6 years ago

ASP.NET Core
0

ismcagdas created 6 years ago
Support Team

Hi,

Haven't tried it but replacing ServiceCollectionRegistrar in unit test project with the one in Migrator project should do this. You should also add a appsettings.json and connection string in it for unit tests project.

But testing with real db is a bit hard. You need to recreate the db before running each unit test.

Thanks.
0

bbakermmc created 6 years ago

Shouldn't there be an easier way to test our app services using real data? No one in their right mind is going to mock up data for every table they have.

Ideally I just want to say use this app service using this db context/connection string.

I'm not looking to run the test cases for all the stuff you guys wrote, its more for my own stuff.
0

ismcagdas created 6 years ago
Support Team

Hi,

AspNet Zero does not provide such a solution for unit tests. But, you can create a similar unit test project in your solution and you can place your own unit tests in it and use a real database for your unit tests.

Thanks.

bbakermmc created 6 years ago

Can you guys provide a GIST/small project that implements this. I need to be able to login as a tenant and run an app service.

I tried copying your test project and swapping out the ServiceCollectionRegistrar but it throws an error.

This gets me half way there:

public static void Register(IIocManager iocManager)
        {
            RegisterIdentity(iocManager);

            var builder = new DbContextOptionsBuilder<PlatformDbContext>();
            builder.UseSqlServer("Server=mmcsqldev02; Database=MMCPlatformControl_BradV2; Trusted_Connection=True;", o => o.UseRowNumberForPaging());

                     iocManager.IocContainer.Register(
                Component
                    .For<DbContextOptions<PlatformDbContext>>()
                    .Instance(builder.Options)
                    .LifestyleSingleton()
            );
        }

How do I make this change the connection to the clients db now, I'm missing something to change the ctx?

protected void LoginAsTenant(string tenancyName, string userName)
        {
            AbpSession.TenantId = null;

            var tenant = UsingDbContext(context => context.Tenants.FirstOrDefault(t => t.TenancyName == tenancyName));
            if (tenant == null)
            {
                throw new Exception("There is no tenant: " + tenancyName);
            }

            AbpSession.TenantId = tenant.Id;
            if (string.IsNullOrEmpty(tenant.ConnectionString))
            {
                var user = UsingDbContext(
                    context => context.Users.FirstOrDefault(
                        u => u.TenantId == AbpSession.TenantId && u.UserName == userName));
                if (user == null)
                {
                    throw new Exception("There is no user: " + userName + " for tenant: " + tenancyName);
                }

                AbpSession.UserId = user.Id;
            }
            else
            {
                var connString = SimpleStringCipher.Instance.Decrypt(tenant.ConnectionString);

                var builder = new DbContextOptionsBuilder<PlatformDbContext>();
                builder.UseSqlServer(connString, o => o.UseRowNumberForPaging());
                
                var ctx = new PlatformDbContext(builder.Options);
                
                var user = UsingDbContext(
                    context => context.Users.FirstOrDefault(
                        u => u.TenantId == AbpSession.TenantId && u.UserName == userName));
                if (user == null)
                {
                    throw new Exception("There is no user: " + userName + " for tenant: " + tenancyName);
                }

                AbpSession.UserId = user.Id;

            }
            
        }

0

ismcagdas created 6 years ago
Support Team

Hi @BBakerMMC,

We will prepare a sample or maybe a article about this but it might take a few days to prepare. I will let you know when it's done.

Thanks.
0

bbakermmc created 6 years ago

Bump
0

ismcagdas created 6 years ago
Support Team

Hi @BBakerMMC,

Sorry for the delay. We couldn't hav etime for this yet. We will let you know when it is done.

Thanks.
0

bbakermmc created 6 years ago

Bump. Also added Issue for this.
0

exlnt created 5 years ago

Bump.

Has anyone been able to get this to work? I really would prefer to test against a live DB. The in-memory DB testing is not realistic. As my application is advancing and more tables are introduced, I would have to create so many data entries into the "Databuilder" class. Plus worry about all the FK relationships. It's just not practical.
1

aaron created 5 years ago
Support Team

Yes, see #4659 (answer).

GitHub issue mentioned above: aspnetzero/aspnet-zero-core#764

Have an answer to this question? Log in and write your answer.