public void Reseed_TableWithNewSeed() { //arrange var expected = "DBCC CHECKIDENT('dbo.Table', RESEED, 1)"; //act var query = Dbcc.Reseed("dbo.Table", 1); //assert query.Should().Be(expected); }
internal async Task <DbccGap> CreateDbccGap(Database database, Dbcc dbcc) { var lastDbcc = database.LastDbccDate; // If there isn't a last dbcc then we'll record the current dbcc as the last _if_ it's not the default dbcc date of '1900-01-01 00:00:00.000' if (!lastDbcc.HasValue && dbcc.End > new DateTime(1901, 1, 1)) { database.LastDbccDate = dbcc.End; await this.databaseRepository.UpdateAsync(database); } else if (lastDbcc.HasValue && (dbcc.End - lastDbcc.Value).TotalMilliseconds > 10) // checking if the current doesn't equal the last with a little buffer { database.LastDbccDate = dbcc.End; await this.databaseRepository.UpdateAsync(database); return(new DbccGap { DatabaseId = dbcc.DatabaseId, Start = lastDbcc.Value, End = dbcc.End }); } return(null); }
public async Task ServerDbccProcessor_CreateDbccGap(int dbccEnd, int?lastDbccEnd, bool expectedResultNotNull, bool expectedResultUpdateLast) { // Arrange var dbcc = new Dbcc { DatabaseId = 123, End = DateTime.UtcNow.AddDays(dbccEnd) }; var lastDbcc = lastDbccEnd.HasValue ? DateTime.UtcNow.AddDays(lastDbccEnd.Value) : (DateTime?)null; var database = new Database { Id = 2, LastDbccDate = lastDbcc }; this.databaseRepository.Setup(r => r.UpdateAsync(database)) .ReturnsAsyncDefault(); // Act var result = await this.serverDbccProcessor.CreateDbccGap(database, dbcc); // Assert Assert.That(result, expectedResultNotNull ? Is.Not.Null : Is.Null); this.databaseRepository.Verify( r => r.UpdateAsync(database), expectedResultUpdateLast ? Times.Once() : Times.Never()); }