xUnit理论。如何在测试之间清除数据库。

huangapple
go评论114阅读模式
英文:

xUnit Theory. How clear database between tests

问题

我使用 xUnit [Theory] 编写测试。我的问题是，我运行第一个测试它通过了，而第二个测试抛出异常 ---- Microsoft.Data.Sqlite.SqliteException：SQLite 错误 19：'UNIQUE constraint failed: CONTRAHENT.ID'。当我分别运行每个测试时，在测试资源管理器中它们都通过了。因此，我认为在第二次运行之前数据库没有被清除/释放。

  1. public class TestDatabaseFixture
  2. {
  3.     private const string ConnectionString = "DataSource=file::memory:?cache=shared";
  4.     private static readonly object _lock = new();
  5.     private static bool _databaseInitialized;
  7.     public TestDatabaseFixture()
  8.     {
  9.         lock (_lock)
  10.         {
  11.             if (!_databaseInitialized)
  12.             {
  13.                 using (var context = CreateContext())
  14.                 {
  15.                     context.Database.EnsureDeleted();
  16.                     context.Database.EnsureCreated();
  17.                 }
  19.                 _databaseInitialized = true;
  20.             }
  21.         }
  22.     }
  24.     public DbTrancheTest CreateContext(bool sensitiveDataLoggingEnabled = false)
  25.     {
  26.         return new DbTrancheTest(
  27.             new DbContextOptionsBuilder<DbTranche>()
  28.                 .EnableSensitiveDataLogging(sensitiveDataLoggingEnabled)
  29.                 .UseSqlite(ConnectionString)
  30.                 .Options);
  31.     }
  32. }

测试类

  1. public class TrancheServiceTest : IClassFixture<TestDatabaseFixture>
  2. {
  3.     private TestDatabaseFixture Fixture { get; }
  5.     public TrancheServiceTest(TestDatabaseFixture fixture)
  6.     {
  7.         Fixture = fixture;
  8.     }
  10.     [Theory]
  11.     [InlineData(TrancheStatus.created, true)] // passed
  12.     [InlineData(TrancheStatus.accepted, false)] // failed
  13.     [InlineData(TrancheStatus.chanaged, true)] // failed
  14.     [InlineData(TrancheStatus.waitforconf, false)] // failed
  15.     [InlineData(TrancheStatus.rejected, false)] // failed
  16.     public void Should_Set_Can_Edit_Flag_For_User(TrancheStatus status, bool result)
  17.     {
  18.         // Arrange
  19.         using var context = Fixture.CreateContext();
  20.         context.Database.EnsureDeleted();
  21.         context.Database.EnsureCreated();
  23.         var orderRepository = new TrancheOrderRepository(context);
  24.         var userRepo = new UserRepository(context);
  25.         var contrahentRepository = new ContrahentRepository(context);
  27.         contrahentRepository.Add(new CONTRAHENT { ID = 1, NAME = "Contrahent1" });
  28.         contrahentRepository.Save();
  30.         var trancheOrder = new TRANCHE_ORDER
  31.         {
  32.             ID = 1,
  33.             ISSUE_DATE = DateTime.Parse("2023-02-01"),
  34.             LAST_UPDATE = DateTime.Parse("2023-02-01"),
  35.             STATUS = (short)status,
  36.             VOLUME = 0,
  37.             USER = "",
  38.         };
  39.         orderRepository.Add(trancheOrder);
  40.         orderRepository.Save();
  42.         userRepo.Add(new USER { ID = 1, CAN_MODIFY = 1, DESCRIPTION = "Test user", FK_CONTRAHENT_ID = 1, NAME = "User1", USER_ID = 123 });
  43.         userRepo.Save();
  45.         var service = new TrancheService(contrahentRepository, orderRepository, userRepo);
  46.         DateTime dateFrom = DateTime.Parse("2023-01-01");
  47.         DateTime dateTo = DateTime.Parse("2023-12-01");
  49.         // Act
  50.         var trancheList = service.GetTrancheList(dateFrom, dateTo, 123, true);
  52.         // Assert
  53.         Assert.Collection(trancheList,
  54.             e => Assert.Equal(result, e.CanEdit));
  55.     }
  56. }

希望这对你有所帮助。

英文:

I write test using xUnit [Theory]. My problem is that I run first test and it pass, while 2nd test throw exception ---- Microsoft.Data.Sqlite.SqliteException : SQLite Error 19: 'UNIQUE constraint failed: CONTRAHENT.ID'. When I run each test separately, in Test Explorer they all passed. So I assume that database is not cleared/disposed before second run.

  1.  public class TestDatabaseFixture
  2.     {
  3.         private const string ConnectionString = &quot;DataSource=file::memory:?cache=shared&quot;;
  4.         private static readonly object _lock = new();
  5.         private static bool _databaseInitialized;
  7.         public TestDatabaseFixture()
  8.         {
  10.             lock (_lock)
  11.             {
  12.                 if (!_databaseInitialized)
  13.                 {
  14.                     using (var context = CreateContext())
  15.                     {
  16.                         context.Database.EnsureDeleted();
  17.                         context.Database.EnsureCreated();
  18.                     }
  20.                     _databaseInitialized = true;
  21.                 }
  22.             }
  23.         }
  25.         public DbTrancheTest CreateContext(bool sensitiveDataLoggingEnabled = false)
  26.             =&gt; new DbTrancheTest(
  27.                 new DbContextOptionsBuilder&lt;DbTranche&gt;()
  28.                 .EnableSensitiveDataLogging(sensitiveDataLoggingEnabled)
  29.                 .UseSqlite(ConnectionString)
  30.                 .Options);
  33.     }

Test class

  1. public class TrancheServiceTest : IClassFixture&lt;TestDatabaseFixture&gt;
  2.     {
  3.         private TestDatabaseFixture Fixture { get; }
  4.         // private readonly ITestOutputHelper output;
  5.         public TrancheServiceTest(TestDatabaseFixture fixture)
  6.         {
  7.             Fixture = fixture;
  8.         }
  10.             [Theory]
  11.             [InlineData(TrancheStatus.created, true)] // passed
  12.             [InlineData(TrancheStatus.accepted, false)] // failed
  13.             [InlineData(TrancheStatus.chanaged, true)] // failed
  14.             [InlineData(TrancheStatus.waitforconf, false)] // failed
  15.             [InlineData(TrancheStatus.rejected, false)] //failed
  16.            
  17.             public void Should_Set_Can_Edit_Flag_For_User(TrancheStatus status, bool result)
  18.             {
  19.                 // Arrange
  20.                 using var context = Fixture.CreateContext();
  21.                 context.Database.EnsureDeleted();
  22.                 context.Database.EnsureCreated();
  23.     
  24.               
  25.                 var orderRepository = new TrancheOrderRepository(context);
  26.                 var userRepo = new UserRepository(context);
  27.                 var contrahentRepository = new ContrahentRepository(context);
  28.     
  29.                 contrahentRepository.Add(new CONTRAHENT { ID = 1, NAME = &quot;Contrahent1&quot; });
  30.                 contrahentRepository.Save();
  32.                 var trancheOrder = new TRANCHE_ORDER
  33.                 {
  34.                     ID = 1,
  35.                     ISSUE_DATE = DateTime.Parse(&quot;2023-02-01&quot;),
  36.                     LAST_UPDATE = DateTime.Parse(&quot;2023-02-01&quot;),
  37.                     STATUS = (short)status,
  38.                     VOLUME = 0,
  39.                     USER = &quot;&quot;,
  40.                 };
  41.                 orderRepository.Add(trancheOrder);
  42.                 orderRepository.Save();
  43.     
  44.                 userRepo.Add(new USER { ID = 1, CAN_MODIFY = 1, DESCRIPTION = &quot;Test user&quot;, FK_CONTRAHENT_ID = 1, NAME = &quot;User1&quot;, USER_ID = 123 });
  45.                 userRepo.Save();
  46.     
  47.                 var service = new TrancheService(contrahentRepository, orderRepository, userRepo);
  48.                 DateTime dateFrom = DateTime.Parse(&quot;2023-01-01&quot;);
  49.                 DateTime dateTo = DateTime.Parse(&quot;2023-12-01&quot;);
  50.     
  51.                 // Act
  52.                 var trancheList = service.GetTrancheList(dateFrom, dateTo, 123, true);
  53.     
  54.                 // Assert
  55.                 Assert.Collection(trancheList,
  56.                     e =&gt; Assert.Equal(result, e.CanEdit));
  57.     
  58.             }
  59. }

答案1

得分: 1

就像 @fildor 所说的那样，您可以每次创建一个新的数据库。为此，您可以使用一个类似这样的 连接字符串：

  1. ConnectionString = "file:{0}?mode=memory";

然后按照以下方式更新您的代码：

  1. public TestDatabaseFixture()
  2. {
  3.     lock (_lock)
  4.     {
  5.         using (var context = CreateContext())
  6.         {
  7.             context.Database.EnsureDeleted();
  8.             context.Database.EnsureCreated();
  9.         }
  10.     }
  11. }
  13. public DbTrancheTest CreateContext(bool sensitiveDataLoggingEnabled = false)
  14.     => new DbTrancheTest(
  15.         new DbContextOptionsBuilder<DbTranche>()
  16.         .EnableSensitiveDataLogging(sensitiveDataLoggingEnabled)
  17.         .UseSqlite(string.Format(ConnectionString, DateTime.Now.Ticks))
  18.         .Options);
英文:

Just like @fildor said, you can create a new DB each time. For that, you can use a connection string which looks like this:

  1. ConnectionString = &quot;file:{0}?mode=memory&quot;;

And update your code like this:

  1. public TestDatabaseFixture()
  2.     {
  4.         lock (_lock)
  5.         {
  6.                 using (var context = CreateContext())
  7.                 {
  8.                     context.Database.EnsureDeleted();
  9.                     context.Database.EnsureCreated();
  10.                 }
  11.             }
  12.         }
  13.     }
  15. public DbTrancheTest CreateContext(bool sensitiveDataLoggingEnabled = false)
  16.         =&gt; new DbTrancheTest(
  17.             new DbContextOptionsBuilder&lt;DbTranche&gt;()
  18.             .EnableSensitiveDataLogging(sensitiveDataLoggingEnabled)
  19.             .UseSqlite(string.Format(ConnectionString, DateTime.Now.Ticks))
  20.             .Options);

答案2

得分: 0

我最终在每个单独的测试中创建了上下文，就像这样。所有的测试都通过了。

  1. 使用 var context = new DbTrancheTest(
  2.     new DbContextOptionsBuilder<DbTranche>()
  3.     .EnableSensitiveDataLogging(false)
  4.     .UseSqlite(string.Format("DataSource=file::memory:?{0}", Guid.NewGuid().ToString()))
  5.     .Options);
  7. context.Database.EnsureDeleted();
  8. context.Database.EnsureCreated();
英文:

I end up creating context in each individual test like this. All tests passed.

  1.   using var context = new DbTrancheTest(
  2.         new DbContextOptionsBuilder&lt;DbTranche&gt;()
  3.         .EnableSensitiveDataLogging(false)
  4.         .UseSqlite(string.Format(&quot;DataSource=file::memory:?{0}&quot;, Guid.NewGuid().ToString()))
  5.         .Options);
  7.     context.Database.EnsureDeleted();
  8.     context.Database.EnsureCreated();

huangapple
  • 本文由 发表于 2023年8月10日 20:09:20
  • 转载请务必保留本文链接：https://go.coder-hub.com/76875615.html
  • c#
  • xunit
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定