Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure21.2.sql =================================================================== diff -u -r81e817d53fa78b1e8603cc906595f693ae1bb28f -r648cae0cb9e1cb3124dfd88173b4b3b78b0e5b0d --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure21.2.sql (.../DatabaseStructure21.2.sql) (revision 81e817d53fa78b1e8603cc906595f693ae1bb28f) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure21.2.sql (.../DatabaseStructure21.2.sql) (revision 648cae0cb9e1cb3124dfd88173b4b3b78b0e5b0d) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 15.2 */ -/* Created On : 26-jan-2022 15:59:02 */ +/* Created On : 27-jan-2022 10:04:08 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -1118,11 +1118,13 @@ ( 'GrassCoverSlipOffInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'SimpleAssessmentResult' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'DetailedAssessmentResult' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = Sufficient, 3 = Insufficient, 4 = NotAssessed - 'TailorMadeAssessmentResult' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = ProbabilityNegligible, 3 = Sufficient, 4 = Insufficient, 5 = NotAssessed - 'UseManualAssembly' TINYINT (1) NOT NULL, -- true or false - 'ManualAssemblyCategoryGroup' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = NotApplicable, 3 = Iv, 4 = IIv, 5 = Vv, 6 = VIIv + 'IsRelevant' TINYINT (1) NOT NULL, -- true or false + 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 + 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, + 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, + 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'RefinedSectionProbability' REAL NULL, + 'RefinedProfileProbability' REAL NULL, CONSTRAINT 'FK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql =================================================================== diff -u -r226ed94fe66d05ccadeb05b43a103f6281904f46 -r648cae0cb9e1cb3124dfd88173b4b3b78b0e5b0d --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql (.../Migration_21.1_21.2.sql) (revision 226ed94fe66d05ccadeb05b43a103f6281904f46) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql (.../Migration_21.1_21.2.sql) (revision 648cae0cb9e1cb3124dfd88173b4b3b78b0e5b0d) @@ -272,7 +272,28 @@ 1 END FROM [SOURCEPROJECT].GrassCoverErosionOutwardsWaveConditionsCalculationEntity; -INSERT INTO GrassCoverSlipOffInwardsSectionResultEntity SELECT * FROM [SOURCEPROJECT].GrassCoverSlipOffInwardsSectionResultEntity; +INSERT INTO GrassCoverSlipOffInwardsSectionResultEntity ( + [GrassCoverSlipOffInwardsSectionResultEntityId], + [FailureMechanismSectionEntityId], + [IsRelevant], + [InitialFailureMechanismResultType], + [ManualInitialFailureMechanismResultSectionProbability], + [ManualInitialFailureMechanismResultProfileProbability], + [FurtherAnalysisNeeded], + [RefinedSectionProbability], + [RefinedProfileProbability] +) +SELECT + [GrassCoverSlipOffInwardsSectionResultEntityId], + [FailureMechanismSectionEntityId], + 1, + 1, + NULL, + NULL, + 0, + NULL, + NULL +FROM [SOURCEPROJECT].GrassCoverSlipOffInwardsSectionResultEntity; INSERT INTO GrassCoverSlipOffInwardsFailureMechanismMetaEntity ( [FailureMechanismEntityId], [N], Index: Riskeer/Migration/test/Riskeer.Migration.Integration.Test/MigrationTo212IntegrationTest.cs =================================================================== diff -u -r226ed94fe66d05ccadeb05b43a103f6281904f46 -r648cae0cb9e1cb3124dfd88173b4b3b78b0e5b0d --- Riskeer/Migration/test/Riskeer.Migration.Integration.Test/MigrationTo212IntegrationTest.cs (.../MigrationTo212IntegrationTest.cs) (revision 226ed94fe66d05ccadeb05b43a103f6281904f46) +++ Riskeer/Migration/test/Riskeer.Migration.Integration.Test/MigrationTo212IntegrationTest.cs (.../MigrationTo212IntegrationTest.cs) (revision 648cae0cb9e1cb3124dfd88173b4b3b78b0e5b0d) @@ -109,6 +109,7 @@ AssertMicrostabilitySectionResults(reader, sourceFilePath); AssertWaterPressureAsphaltCoverSectionResults(reader, sourceFilePath); AssertGrassCoverSlipOffOutwardsSectionResults(reader, sourceFilePath); + AssertGrassCoverSlipOffInwardsSectionResults(reader, sourceFilePath); } AssertLogDatabase(logFilePath); @@ -668,6 +669,11 @@ AssertNonAdoptableWithProfileProbabilityFailureMechanismSectionResults(reader, "GrassCoverSlipOffOutwardsSectionResultEntity", sourceFilePath); } + private static void AssertGrassCoverSlipOffInwardsSectionResults(MigratedDatabaseReader reader, string sourceFilePath) + { + AssertNonAdoptableWithProfileProbabilityFailureMechanismSectionResults(reader, "GrassCoverSlipOffInwardsSectionResultEntity", sourceFilePath); + } + #endregion #region HydraulicBoundaryLocations