Riskeer / Application / Ringtoets / src

Application.Ringtoets.Migration.Core

Clone Tools

Stats

Commits this week: 0
Total Committers: 7
Last Commit: 26 Nov
Commits this week: 0

Lines of code count not available

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated a few seconds ago
All Commits Reviews
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 09 Apr 2018
2:11 pm

Dennis Tang <dennis.tang@deltares.nl>

Formatting SQL migration script: - USING ( --> USING(

WTI-1657

Options
    • -37
    • +37
    ./EmbeddedResources/Migration_17.3_18.1.sql
1:58 pm

Carlos Lubbers

Fix migration WTI-1668

Options
    • -2
    • +2
    ./EmbeddedResources/Migration_17.3_18.1.sql
  2. … 1 more file in changeset.
1:48 pm

Dennis Tang <dennis.tang@deltares.nl>

Adjusted migration script and verification queries after removing the association table.

WTI-1657

Options
    • -70
    • +50
    ./EmbeddedResources/Migration_17.3_18.1.sql
  2. … 1 more file in changeset.
1:46 pm

Carlos Lubbers

Update migration script and test project WTI-1668

Options
    • -8
    • +134
    ./EmbeddedResources/Migration_17.3_18.1.sql
  2. … 1 more file in changeset.
1:46 pm

Dennis Tang <dennis.tang@deltares.nl>

Regenerated database entities after removal association table

WTI-1657

Options
    • -33
    • +7
    ./EmbeddedResources/DatabaseStructure18.1.sql
  2. … 5 more files in changeset.
1:00 pm

Carlos Lubbers

Update entities and database structure sql files WTI-1668

Options
    • -25
    • +43
    ./EmbeddedResources/DatabaseStructure18.1.sql
  2. … 13 more files in changeset.
Friday 06 Apr 2018
4:24 pm

Dennis Tang <dennis.tang@deltares.nl>

Updated migration script for failure mechanism section results in group 3 (WaveImpactAsphaltCover, DuneErosion, GrassCoverErosionOutwards, StabilityStoneCover)

WTI-1667

Options
    • -4
    • +100
    ./EmbeddedResources/Migration_17.3_18.1.sql
  2. … 1 more file in changeset.
2:29 pm

Dennis Tang <dennis.tang@deltares.nl>

Updated database design for failure mechanism section results in group 3 (WaveImpactAsphaltCover, DuneErosion, GrassCoverErosionOutwards, StabilityStoneCover) - Regenerated entities

WTI-1667

Options
    • -13
    • +37
    ./EmbeddedResources/DatabaseStructure18.1.sql
  2. … 8 more files in changeset.
8:34 am

Dennis Tang <dennis.tang@deltares.nl>

Updated migration script in group 2 (piping, macrostability inwards)

WTI-1666

Options
    • -2
    • +38
    ./EmbeddedResources/Migration_17.3_18.1.sql
  2. … 1 more file in changeset.
Thursday 05 Apr 2018
4:16 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -5
    • +13
    ./EmbeddedResources/DatabaseStructure18.1.sql
  2. … 6 more files in changeset.
2:34 pm

Dennis Tang <dennis.tang@deltares.nl>

Adjusted migration script for the remaining failure mechanism section result in group 1 (GrassCoverErosionInwards, StabilityPointStructures, ClosingStructures)

WTI-1665

Options
    • -4
    • +64
    ./EmbeddedResources/Migration_17.3_18.1.sql
  2. … 1 more file in changeset.
Wednesday 04 Apr 2018
4:37 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -7
    • +19
    ./EmbeddedResources/DatabaseStructure18.1.sql
  2. … 7 more files in changeset.
4:07 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -1
    • +11
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -392
    • +83
    ./EmbeddedResources/Migration_17.3_18.1.sql
  3. … 3 more files in changeset.
3:52 pm

Dennis Tang <dennis.tang@deltares.nl>

Adjusted migration script to migrate section results for height structures

WTI-1665

Options
    • -1
    • +21
    ./EmbeddedResources/Migration_17.3_18.1.sql
  2. … 1 more file in changeset.
1:57 pm

Dennis Tang <dennis.tang@deltares.nl>

Cleanup: - Grouped several queries for updating the hydraulic location calculations into one

WTI-1657

Options
    • -92
    • +22
    ./EmbeddedResources/Migration_17.3_18.1.sql
1:32 pm

Dennis Tang <dennis.tang@deltares.nl>

Cleanup: - Grouped several queries for inserting into the hydraulic location output into one

WTI-1657

Options
    • -129
    • +18
    ./EmbeddedResources/Migration_17.3_18.1.sql
1:10 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -1
    • +11
    ./EmbeddedResources/DatabaseStructure18.1.sql
  2. … 3 more files in changeset.
12:00 pm

Dennis Tang <dennis.tang@deltares.nl>

Cleanup: - Optimised migration queries by introducing a temp table with calculation types

WTI-1657

Options
    • -171
    • +43
    ./EmbeddedResources/Migration_17.3_18.1.sql
9:02 am

Dennis Tang <dennis.tang@deltares.nl>

Updated database design for the failure mechanism section result for height structures - Regenerated entities and the database structure .sql file

WTI-1665

Options
    • -3
    • +7
    ./EmbeddedResources/DatabaseStructure18.1.sql
  2. … 5 more files in changeset.
Tuesday 03 Apr 2018
1:35 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -124
    • +121
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -119
    • +459
    ./EmbeddedResources/Migration_17.3_18.1.sql
  3. … 1 more file in changeset.
1:35 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -124
    • +121
    ./EmbeddedResources/DatabaseStructure18.1.sql
    • -119
    • +459
    ./EmbeddedResources/Migration_17.3_18.1.sql
  3. … 1 more file in changeset.
Wednesday 28 Mar 2018
12:01 pm

Dennis Tang <dennis.tang@deltares.nl>

Cleanup: - Removed constraint on the combination of FKs of calculation collections (constraint was not present in the previous implementation)

WTI-1656

Options
    • -2
    • +1
    ./EmbeddedResources/DatabaseStructure18.1.sql
  2. … 5 more files in changeset.
10:52 am

Dennis Tang <dennis.tang@deltares.nl>

Cleanup: - Fixed typo from migration script

WTI-1656

Options
    • -1
    • +1
    ./EmbeddedResources/Migration_17.3_18.1.sql
10:37 am

Dennis Tang <dennis.tang@deltares.nl>

Cleanup: - Updated the database structure to fix failing test

WTI-1656

Options
    • -9
    • +9
    ./EmbeddedResources/DatabaseStructure18.1.sql
10:19 am

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -0
    • +88
    ./EmbeddedResources/Migration_17.3_18.1.sql
  2. … 1 more file in changeset.
Tuesday 27 Mar 2018
3:31 pm

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -0
    • +54
    ./EmbeddedResources/Migration_17.3_18.1.sql
  2. … 1 more file in changeset.
11:52 am

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -212
    • +251
    ./EmbeddedResources/Migration_17.3_18.1.sql
  2. … 1 more file in changeset.
Thursday 22 Mar 2018
11:38 am

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -9
    • +9
    ./EmbeddedResources/DatabaseStructure18.1.sql
  2. … 6 more files in changeset.
8:41 am

Dennis Tang <dennis.tang@deltares.nl>

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

Options
    • -31
    • +29
    ./EmbeddedResources/DatabaseStructure18.1.sql
  2. … 8 more files in changeset.
Tuesday 20 Mar 2018
2:45 pm

Dennis Tang <dennis.tang@deltares.nl>

Adjusted database design: - Updated 18.1 database structure

WTI-1656

Options
    • -203
    • +165
    ./EmbeddedResources/DatabaseStructure18.1.sql