コード例 #1
0
        public static SqlSnapshotCollection MakeCollection()
        {
            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
            collection.LoadSchemaOverrides(typeof(SchemaObjectMother).Assembly);

            //In practice, however, some extra configuration settings are needed
            return(collection);
        }
コード例 #2
0
        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();
        }
コード例 #3
0
        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>();
        }
コード例 #4
0
        public void SchemaOverridesCannotBeLoadedFromAssemblyAfterSnapshot()
        {
            //Arrange
            var collection = new SqlSnapshotCollection(DbController.ConnectionString);

            collection.ConfigureSchema("Test");
            collection.Snapshot("Test");

            //Act
            Action action = () => collection.LoadSchemaOverrides(GetType().Assembly);

            //Assert
            action.Should().Throw <ConfigurationCannotBeChangedException>();
        }
コード例 #5
0
        public void SchemaOverridesCanBeLoadedFromAssembly()
        {
            //Arrange
            var collection = new SqlSnapshotCollection(DbController.ConnectionString);

            collection.ConfigureSchema("Test");

            //Act
            collection.LoadSchemaOverrides(GetType().Assembly);

            //Assert
            var output = new Output();

            collection.GetSchemaReport(output, true);
            output.Report.Verify();
        }
コード例 #6
0
        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();
        }
コード例 #7
0
        public void SnapshotReportCanBeExtracted()
        {
            //Arrange
            var collection = new SqlSnapshotCollection(DbController.ConnectionString);

            collection.ConfigureSchema("Test");
            collection.Snapshot("Test");

            //Act
            var output = new Output();

            collection.GetSnapshotReport("Test", output);

            //Assert
            output.Report.Verify();
        }
コード例 #8
0
        public void SchemaConfigurationIsConsistent()
        {
            //Arrange
            var collection = new SqlSnapshotCollection(Config.ConnectionString);

            //Act
            collection.ConfigureSchema("Chess"); //this loads table definitions direct from the database schema. In theory no further config should be required

            //Assert
            var output = new Output();

            output.WrapLine("Default schema");
            output.WriteLine();
            collection.GetSchemaReport(output, true);
            output.Report.Verify();
        }
コード例 #9
0
        public void AutomaticDataSnapshotCanBeAvoided()
        {
            //Arrange
            var collection = new SqlSnapshotCollection(DbController.ConnectionString);

            collection.ConfigureSchema("Test");
            var builder = collection.Snapshot("Test", SnapshotOptions.NoAutoSnapshot);
            var row     = builder.AddNewRow("[Test].[A_Main]");

            row["MainId"]      = 101;
            row["CreatedDate"] = DateTime.Parse("2020-10-16 08:16");
            row["Comment"]     = "This row was added manually, not snapped from the database. This column isn't even in the database.";

            //Act
            var output = new Output();

            collection.GetSnapshotReport("Test", output);


            //Assert
            output.Report.Verify();
        }