Unit testing issue with SQLite #913

10 Answer(s)

• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi

  You can create a DbContext in the unit test to change DecimalProperty.

  The Decimal type provides a high level of precision. If you don't need that level of precision, however, we recommend using double instead. You can use a value converter to continue using decimal in your classes.

  modelBuilder.Entity<MyEntity>()
      .Property(e => e.DecimalProperty)
      .HasConversion<double>();****
  

  https://docs.microsoft.com/en-us/ef/core/providers/sqlite/limitations#query-limitations

  ---

  For GroupByShaperExpression

  Can you share the query code?

  Save Cancel
• 

  0

  hansmogren created 3 years ago

  I have a similar problem where I need to handle DateTimeOffset data and sqlite. I found this article. Where would I typically add the code? How do I create a separate DbContext for the unit tests? Today the tests use the MigrationsDbContext. I could edit the proper EntityFrameworkCore.DbContext and add code to the OnModelCreating and check if the the database is sqlite but that seems like the wrong way.

  You can create a DbContext in the unit test to change DecimalProperty.

  The Decimal type provides a high level of precision. If you don't need that level of precision, however, we recommend using double instead. You can use a value converter to continue using decimal in your classes.

  modelBuilder.Entity<MyEntity>() 
  

  .Property(e => e.DecimalProperty) 
  .HasConversion<double>();****
  

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi @all

  https://github.com/abpframework/abp/commit/b73f9e2c6e91251f800d5aa3a00b1edf516ed933

  Save Cancel
• 

  0

  hansmogren created 3 years ago

  hi @all

  https://github.com/abpframework/abp/commit/b73f9e2c6e91251f800d5aa3a00b1edf516ed933

  Thanks,

  After trying this I get this error when running the unit test:

  Volo.Abp.AbpInitializationException : An error occurred during the initialize Volo.Abp.Modularity.OnApplicationInitializationModuleLifecycleContributor phase of the module MyProject.MyProjectTestBaseModule, MyProject.TestBase, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null: SQLite Error 1: 'no such table: AbpSettings'.. See the inner exception for details.
  ---- Microsoft.Data.Sqlite.SqliteException : SQLite Error 1: 'no such table: AbpSettings'.
  

  And what about MyProjectNameEntityFrameworkCoreTestModule.CreateDatabaseAndGetConnection? Should it use the MyProjectNameMigrationsDbContext, not the new TestDbContext?

  private static SqliteConnection CreateDatabaseAndGetConnection()
  {
      var connection = new SqliteConnection("Data Source=:memory:");
      connection.Open();
      var options = new DbContextOptionsBuilder<MyProjectNameMigrationsDbContext>()
          .UseSqlite(connection)
          .Options;
      using (var context = new MyProjectNameMigrationsDbContext(options))
      {
          context.GetService<IRelationalDatabaseCreator>().CreateTables();
      }
      return connection;
  }
  

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi hansmogren

  You should use MyProjectNameMigrationsDbContext in CreateDatabaseAndGetConnection method.

  I'm using the free template, What is your app type? tiered or separate-tenant-schema?

  Save Cancel
• 

  0

  hansmogren created 3 years ago

  hi hansmogren

  You should use MyProjectNameMigrationsDbContext in CreateDatabaseAndGetConnection method.

  Ok! I don't understand why the migrations context is used for testing, but anyway :)

  I'm using the free template, What is your app type? tiered or separate-tenant-schema?

  My solution is based on the commercial startup template. It's a monolith, not tiered, and no separate tenants.

  Save Cancel
• 

  0

  maliming created 3 years ago

  Support Team Fullstack Developer

  hi @hansmogren

  Please create a demo project and send it to me, I will change it just like the free template. liming.ma@volosoft.com

  Save Cancel
• 

  0

  ServiceBot created 3 years ago

  Support Team Automatic process manager

  This question has been automatically marked as stale because it has not had recent activity.

  Save Cancel
• 

  0

  ademaygun created one year ago

  Hi @maliming ,

  Have you considered using the in-memory database in the .net core framework instead of sqllite? If so, why didn't you choose it?

  Save Cancel
• 

  1

  maliming created one year ago

  Support Team Fullstack Developer

  hi

  Considering that sqlite is more similar to the actual database

  https://learn.microsoft.com/en-us/ef/core/testing/

  Save Cancel

  1