Application.Ringtoets.Migration.Core

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Updated database design for failure mechanism section results in group 3 (WaveImpactAsphaltCover, DuneErosion, GrassCoverErosionOutwards, StabilityStoneCover) - Regenerated entities

WTI-1667

    • -13
    • +37
    ./EmbeddedResources/DatabaseStructure18.1.sql
  1. … 8 more files in changeset.
Updated migration script in group 2 (piping, macrostability inwards)

WTI-1666

    • -2
    • +38
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 1 more file in changeset.
Updated database design for failure mechanism section results in group 2 (piping, macrostability inwards) - Generated entities and .sql files for the database structure

WTI-1666

    • -5
    • +13
    ./EmbeddedResources/DatabaseStructure18.1.sql
  1. … 6 more files in changeset.
Adjusted migration script for the remaining failure mechanism section result in group 1 (GrassCoverErosionInwards, StabilityPointStructures, ClosingStructures)

WTI-1665

    • -4
    • +64
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 1 more file in changeset.
Updated database design for the remaining failure mechanism section result in group 1 (GrassCoverErosionInwards, StabilityPointStructures, ClosingStructures) - Regenerated entities and the database structure .sql file

WTI-1665

    • -7
    • +19
    ./EmbeddedResources/DatabaseStructure18.1.sql
  1. … 7 more files in changeset.
Merge branch 'master' into 1601

# Conflicts:

# Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure18.1.sql

# Application/Ringtoets/src/Application.Ringtoets.Storage/Ringtoets.rtd

# build/DatabaseStructure.sql

# design/DatabaseDesign.eap

    • -1
    • +11
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -392
    • +83
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 3 more files in changeset.
Adjusted migration script to migrate section results for height structures

WTI-1665

    • -1
    • +21
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 1 more file in changeset.
Cleanup: - Grouped several queries for updating the hydraulic location calculations into one

WTI-1657

    • -92
    • +22
    ./EmbeddedResources/Migration_17.3_18.1.sql
Cleanup: - Grouped several queries for inserting into the hydraulic location output into one

WTI-1657

    • -129
    • +18
    ./EmbeddedResources/Migration_17.3_18.1.sql
Cleanup: - Readded trigger for the association table between collection and calculations --> calculations are not removed automatically if a grass cover erosion outwards failure mechanism meta entity entry is removed

WTI-1657

    • -1
    • +11
    ./EmbeddedResources/DatabaseStructure18.1.sql
  1. … 3 more files in changeset.
Cleanup: - Optimised migration queries by introducing a temp table with calculation types

WTI-1657

    • -171
    • +43
    ./EmbeddedResources/Migration_17.3_18.1.sql
Updated database design for the failure mechanism section result for height structures - Regenerated entities and the database structure .sql file

WTI-1665

    • -3
    • +7
    ./EmbeddedResources/DatabaseStructure18.1.sql
  1. … 5 more files in changeset.
Adjusted Migration to 181 integration scripts - Added asserts for the hydraulic boundary location inputs for grass cover erosion outwards - Adjusted migration script and the database structure.sql file for 181

WTI-1657

    • -124
    • +121
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -119
    • +459
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 1 more file in changeset.
Adjusted Migration to 181 integration scripts - Added asserts for the hydraulic boundary location inputs for grass cover erosion outwards - Adjusted migration script and the database structure.sql file for 181

WTI-1657

    • -124
    • +121
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -119
    • +459
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 1 more file in changeset.
Cleanup: - Removed constraint on the combination of FKs of calculation collections (constraint was not present in the previous implementation)

WTI-1656

    • -2
    • +1
    ./EmbeddedResources/DatabaseStructure18.1.sql
  1. … 5 more files in changeset.
Cleanup: - Fixed typo from migration script

WTI-1656

    • -1
    • +1
    ./EmbeddedResources/Migration_17.3_18.1.sql
Cleanup: - Updated the database structure to fix failing test

WTI-1656

    • -9
    • +9
    ./EmbeddedResources/DatabaseStructure18.1.sql
Adjusted migration script and asserts: - Migrated the hydraulic location output based on the normative norm and mapped them onto the new HydraulicLocationOutputEntity and the corresponding HydraulicLocationCalculationEntities

WTI-1656

    • -0
    • +88
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 1 more file in changeset.
Adjusted migration script and asserts: - Migrated the hydraulic location input based on the normative norm and mapped them onto the new HydraulicLocationCalculationEntity - Refactored test

Note: output is not migrated yet

WTI-1656

    • -0
    • +54
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 1 more file in changeset.
Adjusted migration script and asserts: - Migrated the hydraulic location calculations and mapped them onto the assessment section conform the new design of the database - Removed obsolete queries from the generator

Note: output is not migrated yet

WTI-1656

    • -212
    • +251
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 1 more file in changeset.
Finalized database design: - Added comments to indicate which FK represents which type of calculation - Adjusted read and create extensions on the assessment section to maintain consistency with the comments

WTI-1656

    • -9
    • +9
    ./EmbeddedResources/DatabaseStructure18.1.sql
  1. … 6 more files in changeset.
Cleaned up database related files: - Removed trigger from association table between the calculation collection and the calculation - Renamed names of foreign key according to the naming conventions - Added uniqueness constraint for: -- the association table on the calculations -- the uniqueness of the FK entries of the assessment section entity - Removed two obsolete table entities from the .eap file - Updated the .sql file --> added HydraulicBoundaryLocationCalculationCollection entities should be autonumbered - Removed obsolete lines from the edmx.diagram - Added additional load logic for the PartialRingtoetsEntities in order to fully load the project

WTI-1656

    • -31
    • +29
    ./EmbeddedResources/DatabaseStructure18.1.sql
  1. … 8 more files in changeset.
Adjusted database design: - Updated 18.1 database structure

WTI-1656

    • -203
    • +165
    ./EmbeddedResources/DatabaseStructure18.1.sql
Rename "toetslaag 3" to "toets op maat" in the migration script 17.1->17.2 WTI-1543

    • -6
    • +6
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 1 more file in changeset.
Removed derived output from storage. WTI-1591

    • -131
    • +67
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -6
    • +50
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 30 more files in changeset.
Added comments for the FKs to indicate which calculations they represent

WTI-1579

    • -9
    • +9
    ./EmbeddedResources/DatabaseStructure18.1.sql
  1. … 2 more files in changeset.
Add delta L property to storage WTI-1531

    • -1
    • +2
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -1
    • +10
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 40 more files in changeset.
Add delta L property to storage WTI-1531

    • -1
    • +2
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -1
    • +10
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 40 more files in changeset.
Merge branch '1579'

# Conflicts:

# Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure18.1.sql

# Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql

# Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram

# Application/Ringtoets/src/Application.Ringtoets.Storage/Ringtoets.rtd

# Application/Ringtoets/test/Application.Ringtoets.Migration.Core.Test/test-data/FullTestProject181.rtd

# Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs

# build/DatabaseStructure.sql

# design/DatabaseDesign.eap

    • -60
    • +217
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -2
    • +239
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 106 more files in changeset.
Simplified migration script by introducing union when inserting into the HydraulicLocationOutputEntity

WTI-1579

    • -13
    • +2
    ./EmbeddedResources/Migration_17.3_18.1.sql