Application.Ringtoets.Migration.Core

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
Updated database design: - Renamed PK of HydraulicLocationOutputEntity to match with the current naming conventions -- Updated migration script and integration test - Updated triggers of the HydraulicLocationEntity to match with the current naming convention and exhibit the correct behaviour

WTI-1579

    • -34
    • +34
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -2
    • +2
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 8 more files in changeset.
Added migration script and asserts to migrate hydraulic boundary location migration outputs to the correct calculation entities: - Expanded the reference file to be migrated with outputs on the HBLs

WTI-1579

    • -1
    • +64
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 3 more files in changeset.
Adapt storage with the N parameter for the Piping Structure failure mechanism WTI-1531

    • -16
    • +32
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -1
    • +8
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 20 more files in changeset.
Added migration script and asserts to migrate hydraulic boundary location migration inputs to the correct calculation entities

WTI-1579

    • -1
    • +51
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 2 more files in changeset.
Adapt storage to include the macro stability outwards probability assessment input WTI-1531

    • -91
    • +107
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -1
    • +11
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 34 more files in changeset.
Resolved by: - Discarding their changes on binary files - Merging .sql files

Merge branch 'master' into 1579

# Conflicts:

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

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

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

# build/DatabaseStructure.sql

# design/DatabaseDesign.eap

    • -4
    • +4
    ./EmbeddedResources/DatabaseStructure18.1.sql
  1. … 5 more files in changeset.
Extended migration script: - Generates 8 calculations based for each hydraulic boundary location and mapped accordingly

Warning:

- Hydraulic Boundary Location output is currently cleared during migration

- Input settings for the HBLs are not migrated yet

WTI-1579

    • -2
    • +141
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 1 more file in changeset.
Regenerated context files related to the Ringtoets project files: - Regenerated with digit suffixes instead of written out digits

WTI-1579

    • -41
    • +41
    ./EmbeddedResources/DatabaseStructure18.1.sql
  1. … 7 more files in changeset.
Adapt N parameter in stability point structures failure mechanism to be a double on the data model and storage WTI-1531

    • -2
    • +2
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -35
    • +3
    ./EmbeddedResources/Migration_17.3_18.1.sql
  1. … 15 more files in changeset.