public async Task TestCase2_POST(int nversion)
{
// Arrange
var dbcontext = this.fixture.GetCurrentDataContext();
await dbcontext.Database.ExecuteSqlRawAsync("DELETE FROM t_dbversion WHERE VERSIONID > " + nversion.ToString());
await dbcontext.DisposeAsync();
// Test
dbcontext = this.fixture.GetCurrentDataContext();
DBVersionsController control = new DBVersionsController(dbcontext);
await control.Post();
var vers = dbcontext.DBVersions.ToList();
for (var i = nversion + 1; i <= DBVersionsController.CurrentVersion; i++)
{
Assert.True(vers.Exists(p => p.VersionID == i));
}
await dbcontext.DisposeAsync();
// Reset the db version table
dbcontext = this.fixture.GetCurrentDataContext();
await dbcontext.Database.ExecuteSqlRawAsync("DELETE FROM t_dbversion WHERE VERSIONID > 0");
DataSetupUtility.InitialTable_DBVersion(dbcontext);
await dbcontext.SaveChangesAsync();
var lastestVersion = await dbcontext.DBVersions.MaxAsync(p => p.VersionID);
Assert.True(lastestVersion == DBVersionsController.CurrentVersion);
await dbcontext.DisposeAsync();
}
public async Task TestCase1_Read()
{
var context = this.fixture.GetCurrentDataContext();
DBVersionsController control = new DBVersionsController(context);
var version = control.Get();
Assert.NotEmpty(version);
var cnt1 = DataSetupUtility.DBVersions.Count();
var cnt2 = version.Count();
Assert.Equal(cnt1, cnt2);
await context.DisposeAsync();
}
