Tests-in-a-layered-solution #8238

3 Answer(s)

• 

  0

  maliming created one month ago

  Support Team Fullstack Developer

  hi

  Can you share a minimal project to show your problem?

  liming.ma@volosoft.com

  Thanks.

  Save Cancel
• 

  0

  dmeagor created one month ago

  Sorry I didn't explain the issue very well. I've managed to figure out what was happening. Basicially we had two separate databases Shout (top layer) and Survey (module). Sqlite was destroying /overwriting the module later in this use case.

  Can you please confirm that this is the correct way to resolve the issue? If it is then it should probably be documented in your Integration Test setup section.

  #ShoutEntityFrameworkCoreTestModule.cs
  
  namespace Shout.EntityFrameworkCore;
  
  [DependsOn(
      typeof(ShoutEntityFrameworkCoreDbMigrationsModule),
      typeof(ShoutTestBaseModule),
      typeof(AbpEntityFrameworkCoreSqliteModule)
  )]
  public class ShoutEntityFrameworkCoreTestModule : AbpModule
  {
      private SqliteConnection _sqliteConnection;
  
      public override void ConfigureServices(ServiceConfigurationContext context)
      {
          context.Services.AddAlwaysDisableUnitOfWorkTransaction();
  
          ConfigureInMemorySqlite(context.Services);
      }
  
      private void ConfigureInMemorySqlite(IServiceCollection services)
      {
          _sqliteConnection = CreateDatabaseAndGetConnection();
  
          services.Configure<AbpDbContextOptions>(options =>
          {
              options.Configure(context =>
              {
                  context.DbContextOptions.UseSqlite(_sqliteConnection);
              });
          });
      }
  
      public override void OnApplicationShutdown(ApplicationShutdownContext context)
      {
          _sqliteConnection.Dispose();
      }
  
      private static SqliteConnection CreateDatabaseAndGetConnection()
      {
          var connection = new SqliteConnection("Data Source=:memory:");
          connection.Open();
  
          // Configure logging for SurveyDbContext
          var surveyDbOptions = new DbContextOptionsBuilder<SurveyDbContext>()
              .UseSqlite(connection)
              .EnableSensitiveDataLogging() // Include parameter values in logs
              .LogTo(Console.WriteLine, LogLevel.Information) // Log SQL queries to console
              .Options;
  
          // Configure logging for ShoutMigrationsDbContext
          var shoutMigrationsDbOptions = new DbContextOptionsBuilder<ShoutMigrationsDbContext>()
              .UseSqlite(connection)
              .EnableSensitiveDataLogging()
              .LogTo(Console.WriteLine, LogLevel.Information)
              .Options;
  
          // Create tables with logging enabled
          new SurveyDbContext(surveyDbOptions).GetService<IRelationalDatabaseCreator>().CreateTables();
          new ShoutMigrationsDbContext(shoutMigrationsDbOptions).GetService<IRelationalDatabaseCreator>().CreateTables();
  
          return connection;
      }
  }
  

  Save Cancel
• 

  0

  maliming created one month ago

  Support Team Fullstack Developer

  hi

  If you have two DbContext in the unit test, the code is no problem

  new SurveyDbContext(surveyDbOptions).GetService<IRelationalDatabaseCreator>().CreateTables();
  new ShoutMigrationsDbContext(shoutMigrationsDbOptions).GetService<IRelationalDatabaseCreator>().CreateTables();
  

  https://github.com/abpframework/abp/blob/dev/modules/openiddict/test/Volo.Abp.OpenIddict.EntityFrameworkCore.Tests/Volo/Abp/OpenIddict/EntityFrameworkCore/OpenIddictEntityFrameworkCoreTestModule.cs#L38-L56

  Save Cancel