Application.Ringtoets.Migration.Core

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Adjusted migration script from 171 tot 172 to incorporate requirements: - Added log messages for after migration: indicate what has changed for LayerThree when relevant - Updated FullProject171 test file: removed extra testcase, each relevant failure mechanisms tests one positive, one negative value (<0 or >1) Related to Issue [WTI-1373]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11374 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 11699a4aac6f9b455e80cc581f4eda9b484a6627

Former-commit-id: eaafbe7c7940152b1957af6ae923fe80accbfb97

    • -0
    • +65
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 2 more files in changeset.
Adjusted migration script from 171 tot 172 to incorporate requirements: - AssessmentLayerThree for relevant failure mechanisms are converted to probabilities. Every other value not matching criteria >0 and <1 are removed - Adjusted test file: appended an assessmentSection which contains invalid results for the relevant failure mechanisms -- Updated FullProject172 test file: is in sync with the 171 equivalent

Related to Issue [WTI-1373]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11369 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: c86b02fd5f703468518712f5ddfd1fb2732a3fe1

Former-commit-id: e34ef7ad7e078ebca5adc44d28dde29d95c5c0ba

    • -5
    • +92
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 3 more files in changeset.
Ensured enumerations are directly evaluated during clone Related to Issue [WTI-1365]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11365 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 87d4754b4f8d59c83c433c9fdc721ec296e225e9

Former-commit-id: 3620c9e1332623da8fb6804dfd934afa24872335

    • -2
    • +4
    ./RingtoetsSqLiteDatabaseFileMigrator.cs
  1. … 4 more files in changeset.
Ensured enumerations are directly evaluated in storage Related to Issue [WTI-1365]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11351 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: d425fc0f117724370d3c0af63b23b2cbcb463bca

Former-commit-id: c9ccab4f026bb6b2a2b2cdc83c640a446b2f5672

    • -2
    • +4
    ./RingtoetsSqLiteDatabaseFileMigrator.cs
  1. … 8 more files in changeset.
Initialized MechanismSurfaceLineBase.Name from constructor and added check for Null Related to Issue [WTI-1343]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11334 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 2e9213487250cbc814b3b91307890cf7b5979f23

Former-commit-id: 1af404f013ac6e0a765c468b3c13ec22aa80a186

    • -2
    • +2
    ./EmbeddedResources/DatabaseStructure17.2.sql
    • -1
    • +22
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 98 more files in changeset.
Set SoilProfileEntity.Name to be not null Related to Issue [WTI-1343]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11319 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: e97e925d1e5f2d25d11f65496dbb566aca98356a

Former-commit-id: c9392fd939ffe39f33d1a7c8f8eba64ae146bdac

    • -2
    • +2
    ./EmbeddedResources/DatabaseStructure17.2.sql
    • -1
    • +6
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 2 more files in changeset.
Moved 'Type' from StochasticSoilProfileEntity to 'SourceType' SoilProfileEntity in database Ran Cleanup for storage Related to Issue [WTI-1343]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11272 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 5390416ecba199da438854b0481ab20184862a17

Former-commit-id: 2102fe55684e8b3215a87aa15960a2dd62b27852

    • -3
    • +3
    ./EmbeddedResources/DatabaseStructure17.2.sql
    • -2
    • +29
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 16 more files in changeset.
Implemented patch, updated tests and added more cases for the migration filename tests Related to Issue [WTI-1380]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11250 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 2dde992b6811dcda5bb3f98dfb28111d61b1aac1

Former-commit-id: 7ce9e80b4a14f68f78f5bab40d44896b1262f9ef

    • -2
    • +2
    ./EmbeddedResources/Migration_17.1_17.2.sql
    • -2
    • +2
    ./EmbeddedResources/Migration_5_17.1.sql
  1. … 7 more files in changeset.
Updated database design to store the general results for all the grass cover erosion inwards calculation outputs - Updated Migration script: -- Row value for calculating the illustration points is per default FALSE -- Row value for the general result entity of the grass output is per default NULL Related to Issue [WTI-1319]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11032 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: a6e32f96b906b4b64510c63345178cd50eafc2be

Former-commit-id: 4479e2a1d1daeae1b11d7c1a71f5930cf1a3eaab

    • -1205
    • +1104
    ./EmbeddedResources/DatabaseStructure17.2.sql
    • -4
    • +110
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 18 more files in changeset.
Incorporated comments review 2000 - Removed superfluous GeneralResult assertions - Added missing assertions - Renamed variables and fixed typos

Paired with ~janssen

Related to Issue [WTI-1309]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11026 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 66ce181cb0df03c034bbe0d0b71960ce91f8f964

Former-commit-id: 99935a220f1560d9d3aa04f6aad2269d90f96065

    • -1
    • +1
    ./EmbeddedResources/DatabaseStructure17.2.sql
  1. … 11 more files in changeset.
- Updated 'True/false' indicators in DatabaseDesign.eap - Formatted DatabaseStructure.sql to use tabs instead of spaces - Formatted Migration_17.1_17.2.sql to use tabs instead of spaces Related to Issue [WTI-1309]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10965 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: e40073342b4fe78e16730f3208b96c508097e18d

Former-commit-id: 4dc1221ed9f91fdd176934e8ebf3915698ae8ac7

    • -1082
    • +1238
    ./EmbeddedResources/DatabaseStructure17.2.sql
    • -66
    • +143
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 2 more files in changeset.
Review related changes Related to Issue [WTI-1289]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10904 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 8da61f371910ecdb3a6abd62b7380522e211f99c

Former-commit-id: 2550b686dac43fbf19504595b155fba963a95ddd

    • -2
    • +2
    ./EmbeddedResources/Migration_17.1_17.2.sql
    • -1
    • +1
    ./EmbeddedResources/Migration_5_17.1.sql
  1. … 1 more file in changeset.
- Updated database structure to allow illustration points checkbox to be saved for closing, height, and stability point structures - cleaned up SQL scripts for triggers Related to Issue [WTI-1309]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10688 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 8ad836dabcae087b9fe2f6795744585b25cfe61a

Former-commit-id: 3ff9f166b319dedf175816064d437a1ca6048694

    • -30
    • +71
    ./EmbeddedResources/DatabaseStructure17.2.sql
    • -3
    • +285
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 7 more files in changeset.
Updated database structure to allow illustration points to be saved for closing, height, and stability point structures Related to Issue [WTI-1309]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10684 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: be8c916f68ddeb29afdb2bb13805fcafea3d3e66

Former-commit-id: 160e78924ef4560ed5b7f4b86ce0eb9b6e0c3319

    • -53
    • +219
    ./EmbeddedResources/DatabaseStructure17.2.sql
    • -3
    • +57
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 15 more files in changeset.
Updated database items: - Renamed ShouldWaterLevelIllustrationPointsBeCalculated to ShouldDesignWaterLevelIllustrationPointsBeCalculated for consistency - Migration script updated Related to Issue [WTI-1305]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10564 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: dfd8709b8f04316ff5f4d057765601383e8fc9e1

Former-commit-id: ecbc3f3561b1fcafc99e54520552bbec7f1c70d6

    • -3
    • +3
    ./EmbeddedResources/DatabaseStructure17.2.sql
    • -2
    • +2
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 14 more files in changeset.
Updated database items: - Removed obsolete column Beta from the TopLevelSubMechanismIllustrationPoint: beta is stored in the children - Updated all string based properties: the database entity property should have an AreEqualButNotSame assert and implementation

Related to Issue [WTI-1305]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10546 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 8006b700370e30dd3a5e2569de77172fe7c27366

Former-commit-id: 1e9b3abb2f1dd84dc47b0e5452b5514459bd582a

    • -2
    • +1
    ./EmbeddedResources/DatabaseStructure17.2.sql
  1. … 9 more files in changeset.
Query for no changes message improved to also show when migrating from db version 5 to 17.2 Related to Issue [WTI-1283]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10544 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: ef7b6fbe12faff90fb09df6786637edd44135982

Former-commit-id: 83ec4ab1d849912d886b03b8d4a237e302633bb1

    • -0
    • +1
    ./EmbeddedResources/Migration_17.1_17.2.sql
    • -0
    • +1
    ./EmbeddedResources/Migration_5_17.1.sql
  1. … 2 more files in changeset.
Renamed Submechanism<X> to SubMechanism<X> for the illustration points: - Initial commit - Performed on the RT side only - Updated database and migration scripts with the updated names

Related to Issue [WTI-1305]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10537 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: b4e245c45841961f67a8e6a215a8ddc0108b06d0

Former-commit-id: 9551680e9783a3e8a70dd77616fb14872b7ebcde

    • -60
    • +60
    ./EmbeddedResources/DatabaseStructure17.2.sql
    • -2
    • +2
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 89 more files in changeset.
Updated database design: - Incorporated new proposed design for the HBL: -- Removed obsolete functions, interfaces and partial classes - Adjusted migration script --> HBL output entities contain 10 instead of 9 columns, 10 column is filled with a NULL value as it is a FK referring to a general result. This result is not available in prior versions - Made final adjustments in the .eap file

Related to Issue [WTI-1305]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10528 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: a3794269143bbcedac08b328c29405ee9381d62f

Former-commit-id: 71d06472bab4af5854e1bba0119db7a626652c83

    • -181
    • +164
    ./EmbeddedResources/DatabaseStructure17.2.sql
    • -2
    • +46
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 51 more files in changeset.
Updated database design: - GrassCoverErosionOutwardsHydraulicLocationGeneralResultEntityId NOT NULL - HydraulicLocationWindDirectionClosingSituationIllustrationPointEntityId.Name --> IllustrationPointName - GrassCoverErosionOutwardsHydraulicLocationWindDirectionClosingSituationIllustrationPointEntity.Name --> IllustrationPointName Related to Issue [WTI-1305]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10496 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 3da96a93828cb50dae0e84cf2fa10f8ebd52b5fb

Former-commit-id: e8ce056c878fd3818e395ffda68c998aafe254b6

    • -4
    • +4
    ./EmbeddedResources/DatabaseStructure17.2.sql
  1. … 11 more files in changeset.
Updated DatabaseDesign: - Added Order property for tables that represent items in a list

Related to Issue [WTI-1305]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10488 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 2efddb53739e7e899f2e123701991e12f09ffae9

Former-commit-id: 467bb1ef02a72497007b67c646f1bec786f0672d

    • -1
    • +9
    ./EmbeddedResources/DatabaseStructure17.2.sql
  1. … 13 more files in changeset.
small outline change Related to Issue [WTI-1283]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10486 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 63befa6d710fa8e10f069192511af70fc964ffb6

Former-commit-id: 7ba643a5d34ec03832a1bf13fb52fbc074a436ed

    • -2
    • +2
    ./EmbeddedResources/Migration_5_17.1.sql
Updated DatabaseDesign: - Generated SQL file - Updated migration script Related to Issue [WTI-1305]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10482 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 4c47ec5f0a8173acea93e1c9d7b684fb3b1a2b22

Former-commit-id: 1f3fb774a5674842b27dfd9e20cce583eefce32f

    • -64
    • +250
    ./EmbeddedResources/DatabaseStructure17.2.sql
    • -2
    • +42
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 20 more files in changeset.
Changed message "Gevolgen van de migratie van versie 5 naar versie 17.1:" to "Gevolgen van de migratie van versie 16.4 naar versie 17.1:" All TEMP tables have a prefix now, to identify them as temp fixed indenting and styling according to our standards Related to Issue [WTI-1283]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10480 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: c4c37a140abcc6d8e5f786df9d672f480b676981

Former-commit-id: 6d011cc9e658b7b3c4d2118b413f1da4b82e6ee5

    • -89
    • +179
    ./EmbeddedResources/Migration_17.1_17.2.sql
    • -95
    • +176
    ./EmbeddedResources/Migration_5_17.1.sql
  1. … 2 more files in changeset.
Updated log messages generated by migration

Related to Issue [WTI-1283]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10453 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 500fd8dce454b251fffa4c4d2cbd89a44b14c19d

Former-commit-id: cbd914235124434d2bf216ed980e5eb1d28e52cf

    • -5
    • +18
    ./EmbeddedResources/Migration_17.1_17.2.sql
    • -3
    • +16
    ./EmbeddedResources/Migration_5_17.1.sql
  1. … 6 more files in changeset.
Hierarchy in log messages Related to Issue [WTI-1283]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10446 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: aa0477de3e07ea65979b3341705121e4a71f729f

Former-commit-id: 1323af3f3404fd44fc043a1fa07b22c007fdd6e2

    • -27
    • +79
    ./EmbeddedResources/Migration_17.1_17.2.sql
    • -7
    • +67
    ./EmbeddedResources/Migration_5_17.1.sql
  1. … 3 more files in changeset.
Added migration log messages for changing id's. Related to Issue [WTI-1283]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10423 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: fea09a7a8babfaf1a46c307a0b1f8041f56b80cd

Former-commit-id: 512d7105e12625cd5c923b8a4cd5e09645d3a58f

    • -8
    • +46
    ./EmbeddedResources/Migration_17.1_17.2.sql
    • -0
    • +11
    ./EmbeddedResources/Migration_5_17.1.sql
  1. … 3 more files in changeset.
Changed migration scripts to fix unigue ids. Related to Issue [WTI-1332]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10389 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 8d1e4992cf35e8786312d4d75549db02b999daa3

Former-commit-id: 5fbb827b469dc486ded5200983be644b8a9c5e7f

    • -4
    • +4
    ./EmbeddedResources/Migration_17.1_17.2.sql
    • -1
    • +1
    ./EmbeddedResources/Migration_5_17.1.sql
  1. … 3 more files in changeset.
Removed the SegmentName from the database for piping: - Updated migration script to provide the correct data - Updated the RTD file - Updated documentation Related to Issue [WTI-1285]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@10347 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 5384406e34cbb3cfd7f2181aa46e414ea2af7950

Former-commit-id: 45d55e1a1c1b70d793a12ddf8ea82921516fedb9

    • -2
    • +1
    ./EmbeddedResources/DatabaseStructure17.2.sql
    • -1
    • +13
    ./EmbeddedResources/Migration_17.1_17.2.sql
  1. … 8 more files in changeset.
Added test case for unique dike profile id generation. Fixed bug where non-unique id's were generated. Reviewed by: janssen Related to Issue [WTI-1287]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/branches/Release/17_1@10346 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 8ed0437d5fc7f24e44b60113fe925ad5a2218097

Former-commit-id: f0dd602931072f222a9c9cfe51fb2c1e04103ba3

    • -1
    • +1
    ./EmbeddedResources/Migration_5_17.1.sql
  1. … 1 more file in changeset.