public async void DatabaseChangesAreFlaggedFluent()
{
//Arrange
var collection = new SqlSnapshotCollection(Config.ConnectionString);
collection.ConfigureSchema("Chess"); //this loads table definitions direct from the database schema. In theory no further config should be required
//In practice, however, some extra configuration settings are needed
collection.DefineTable("[Chess].[Rating]")
.IsUnpredictable("RatingDate") //RatingDate is not defaulted to GETDATE() or any of the automatic "get the time" variants. This was deliberate, to illustrate that we can alter the automated decisions.
.Sort("RatingDate") //* In a similar vein, a GUID was used as the table key for [Chess].[Rating] to illustrate that GUIDs can be handled, however, when they are the primary key they can
.Sort("RatingSourceId"); //* randomise the order rows are returned, so we need to force a sort on other fields to make the differences repeatable.
collection.DefineTable("[Chess].[Player]")
.Sort("Name"); // As above, we need to sort player data because it has a GUID for a primary key, randomising the order that rows are returned.
collection.DefineTable("[Chess].[AuditPlayer]")
.IsReference("PlayerId", "[Chess].[Player]", "PlayerId") //The audit table does not have the player ID defined as a foreign key, so no relationship is defined automatically. We define it manually to make the keys consistent.
.IsUnpredictable("AuditStartDate") //* These dates will match the update timestamp. They are set by a trigger, not a default
.IsUnpredictable("AuditEndDate") //* otherwise unpredictability would have been set automatically.
.Local("AuditStartDate") //* And they are...
.Local("AuditEndDate"); //* local dates
collection.DefineTable("[Chess].[AuditRating]")
.IsReference("PlayerId", "[Chess].[Player]", "PlayerId") //The audit table does not have the player ID defined as a foreign key, so no relationship is defined automatically. We define it manually to make the keys consistent.
.IsReference("RatingId", "[Chess].[Rating]", "RatingId") //The audit table does not have the Rating Id defined as a foreign key, so no relationship is defined automatically. We define it manually to make the keys consistent.
.IsUnpredictable("AuditStartDate") //* These dates will match the update timestamp. They are set by a trigger, not a default
.IsUnpredictable("AuditEndDate") //* otherwise unpredictability would have been set automatically.
.IsUnpredictable("RatingDate") //*
.Local("AuditStartDate") //* And they are...
.Local("AuditEndDate") //* local dates
.Local("RatingDate"); //*
var builder = collection.Snapshot("before");
var entities = new ChessContext(Config.ConnectionString);
//Act
await _om.AddPlayerAsync("Bill", (ChessObjectMother.ChessDotCom, 1801), (ChessObjectMother.Lichess, 1992));
await _om.AddPlayerAsync("Ted", (ChessObjectMother.ChessDotCom, 1836), (ChessObjectMother.Lichess, 1918));
collection.Snapshot("after");
//Assert
var output = new Output();
collection.ReportChanges("before", "after", output);
output.Report.Verify();
}
public void SchemaOverridesCannotBeAppliedAfterSnapshot()
{
//Arrange
var collection = new SqlSnapshotCollection(DbController.ConnectionString);
collection.ConfigureSchema("Test");
collection.Snapshot("Test");
//Act
Action action = () => collection.DefineTable("[Test].[A_Main]").IsPredictable("MainId");
//Assert
action.Should().Throw <ConfigurationCannotBeChangedException>();
}
public void SchemaOverridesCanBeAppliedDirectly()
{
//Arrange
var collection = new SqlSnapshotCollection(DbController.ConnectionString);
collection.ConfigureSchema("Test");
//Act
collection.DefineTable("[Test].[A_Main]").IsPredictable("MainId");
//Assert
var output = new Output();
collection.GetSchemaReport(output, true);
output.Report.Verify();
}