Index: Migration/Core/src/Migration.Core.Storage/Migration.Core.Storage.csproj =================================================================== diff -u -r6cc96c5f52e06c2dc083a1ae3eb56d358b28a62b -r4d5dca55a70d246ccfc093c982e9805d9c07301e --- Migration/Core/src/Migration.Core.Storage/Migration.Core.Storage.csproj (.../Migration.Core.Storage.csproj) (revision 6cc96c5f52e06c2dc083a1ae3eb56d358b28a62b) +++ Migration/Core/src/Migration.Core.Storage/Migration.Core.Storage.csproj (.../Migration.Core.Storage.csproj) (revision 4d5dca55a70d246ccfc093c982e9805d9c07301e) @@ -92,6 +92,10 @@ {F49BD8B2-332A-4C91-A196-8CCE0A2C7D98} Core.Common.Utils + + {EED7826A-5397-4EEB-A1F8-A7550078459E} + Migration.Ringtoets.Data + {d08db9e2-6861-44c8-a725-71a70274cc77} Migration.Scripts.Data Index: Migration/Core/src/Migration.Core.Storage/MigrationDatabaseSourceFile.cs =================================================================== diff -u -r6cc96c5f52e06c2dc083a1ae3eb56d358b28a62b -r4d5dca55a70d246ccfc093c982e9805d9c07301e --- Migration/Core/src/Migration.Core.Storage/MigrationDatabaseSourceFile.cs (.../MigrationDatabaseSourceFile.cs) (revision 6cc96c5f52e06c2dc083a1ae3eb56d358b28a62b) +++ Migration/Core/src/Migration.Core.Storage/MigrationDatabaseSourceFile.cs (.../MigrationDatabaseSourceFile.cs) (revision 4d5dca55a70d246ccfc093c982e9805d9c07301e) @@ -24,7 +24,7 @@ using Core.Common.Base.Storage; using Core.Common.IO.Exceptions; using Core.Common.IO.Readers; -using Migration.Scripts.Data; +using Migration.Ringtoets.Data; namespace Migration.Core.Storage { Index: Migration/Ringtoets/src/Migration.Ringtoets.Data/Migration.Ringtoets.Data.csproj =================================================================== diff -u -r81c60620a31dcb8c4f174212d266b38f6ba08e6a -r4d5dca55a70d246ccfc093c982e9805d9c07301e --- Migration/Ringtoets/src/Migration.Ringtoets.Data/Migration.Ringtoets.Data.csproj (.../Migration.Ringtoets.Data.csproj) (revision 81c60620a31dcb8c4f174212d266b38f6ba08e6a) +++ Migration/Ringtoets/src/Migration.Ringtoets.Data/Migration.Ringtoets.Data.csproj (.../Migration.Ringtoets.Data.csproj) (revision 4d5dca55a70d246ccfc093c982e9805d9c07301e) @@ -40,6 +40,8 @@ Properties\GlobalAssembly.cs + + Index: Migration/Ringtoets/src/Migration.Ringtoets.Data/RingtoetsDatabaseQueryBuilder.cs =================================================================== diff -u --- Migration/Ringtoets/src/Migration.Ringtoets.Data/RingtoetsDatabaseQueryBuilder.cs (revision 0) +++ Migration/Ringtoets/src/Migration.Ringtoets.Data/RingtoetsDatabaseQueryBuilder.cs (revision 4d5dca55a70d246ccfc093c982e9805d9c07301e) @@ -0,0 +1,41 @@ +// Copyright (C) Stichting Deltares 2016. All rights reserved. +// +// This file is part of Ringtoets. +// +// Ringtoets is free software: you can redistribute it and/or modify +// it under the terms of the GNU General Public License as published by +// the Free Software Foundation, either version 3 of the License, or +// (at your option) any later version. +// +// This program is distributed in the hope that it will be useful, +// but WITHOUT ANY WARRANTY; without even the implied warranty of +// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +// GNU General Public License for more details. +// +// You should have received a copy of the GNU General Public License +// along with this program. If not, see . +// +// All names, logos, and references to "Deltares" are registered trademarks of +// Stichting Deltares and remain full property of Stichting Deltares at all times. +// All rights reserved. + +namespace Migration.Scripts.Data +{ + /// + /// Defines queries to execute on a Ringtoets database. + /// + public static class RingtoetsDatabaseQueryBuilder + { + /// + /// Returns the query to get the version from the Ringtoets database. + /// + /// The query to get the version from the Ringtoets database. + public static string GetVersionQuery() + { + return $"SELECT {VersionTableDefinitions.Version} " + + $"FROM {VersionTableDefinitions.TableName} " + + $"Order by {VersionTableDefinitions.Timestamp} DESC " + + "LIMIT 1"; + } + } +} \ No newline at end of file Index: Migration/Ringtoets/src/Migration.Ringtoets.Data/VersionTableDefinitions.cs =================================================================== diff -u --- Migration/Ringtoets/src/Migration.Ringtoets.Data/VersionTableDefinitions.cs (revision 0) +++ Migration/Ringtoets/src/Migration.Ringtoets.Data/VersionTableDefinitions.cs (revision 4d5dca55a70d246ccfc093c982e9805d9c07301e) @@ -0,0 +1,33 @@ +// Copyright (C) Stichting Deltares 2016. All rights reserved. +// +// This file is part of Ringtoets. +// +// Ringtoets is free software: you can redistribute it and/or modify +// it under the terms of the GNU General Public License as published by +// the Free Software Foundation, either version 3 of the License, or +// (at your option) any later version. +// +// This program is distributed in the hope that it will be useful, +// but WITHOUT ANY WARRANTY; without even the implied warranty of +// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +// GNU General Public License for more details. +// +// You should have received a copy of the GNU General Public License +// along with this program. If not, see . +// +// All names, logos, and references to "Deltares" are registered trademarks of +// Stichting Deltares and remain full property of Stichting Deltares at all times. +// All rights reserved. + +namespace Migration.Ringtoets.Data +{ + /// + /// Defines the table and column names of the table 'VersionEntity' in the Ringtoets database. + /// + public static class VersionTableDefinitions + { + public const string TableName = "VersionEntity"; + public const string Version = "Version"; + public const string Timestamp = "Timestamp"; + } +} \ No newline at end of file Index: Migration/Scripts/src/Migration.Scripts.Data/Migration.Scripts.Data.csproj =================================================================== diff -u -r6cc96c5f52e06c2dc083a1ae3eb56d358b28a62b -r4d5dca55a70d246ccfc093c982e9805d9c07301e --- Migration/Scripts/src/Migration.Scripts.Data/Migration.Scripts.Data.csproj (.../Migration.Scripts.Data.csproj) (revision 6cc96c5f52e06c2dc083a1ae3eb56d358b28a62b) +++ Migration/Scripts/src/Migration.Scripts.Data/Migration.Scripts.Data.csproj (.../Migration.Scripts.Data.csproj) (revision 4d5dca55a70d246ccfc093c982e9805d9c07301e) @@ -45,8 +45,6 @@ True Resources.resx - - Fisheye: Tag 4d5dca55a70d246ccfc093c982e9805d9c07301e refers to a dead (removed) revision in file `Migration/Scripts/src/Migration.Scripts.Data/RingtoetsDatabaseQueryBuilder.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 4d5dca55a70d246ccfc093c982e9805d9c07301e refers to a dead (removed) revision in file `Migration/Scripts/src/Migration.Scripts.Data/VersionTableDefinitions.cs'. Fisheye: No comparison available. Pass `N' to diff? Index: Migration/Scripts/src/Migration.Scripts.Service/Migration.Scripts.Service.csproj =================================================================== diff -u --- Migration/Scripts/src/Migration.Scripts.Service/Migration.Scripts.Service.csproj (revision 0) +++ Migration/Scripts/src/Migration.Scripts.Service/Migration.Scripts.Service.csproj (revision 4d5dca55a70d246ccfc093c982e9805d9c07301e) @@ -0,0 +1,63 @@ + + + + + {1EA671F9-1F34-480C-B232-FF9A2A06AF8F} + Library + Properties + Migration.Scripts.Service + Migration.Scripts.Service + v4.0 + 512 + + + true + full + false + DEBUG;TRACE + prompt + + + none + true + TRACE + prompt + + + TRACE + true + true + pdbonly + prompt + AllRules.ruleset + + + + + + + + Properties\GlobalAssembly.cs + + + + + + Copying.licenseheader + + + + + {EFD7E662-5B69-4B71-A448-565B64E9C033} + Migration.Core.Storage + + + + + \ No newline at end of file Index: Migration/Scripts/src/Migration.Scripts.Service/MigrationScriptsService.cs =================================================================== diff -u --- Migration/Scripts/src/Migration.Scripts.Service/MigrationScriptsService.cs (revision 0) +++ Migration/Scripts/src/Migration.Scripts.Service/MigrationScriptsService.cs (revision 4d5dca55a70d246ccfc093c982e9805d9c07301e) @@ -0,0 +1,33 @@ +// Copyright (C) Stichting Deltares 2016. All rights reserved. +// +// This file is part of Ringtoets. +// +// Ringtoets is free software: you can redistribute it and/or modify +// it under the terms of the GNU General Public License as published by +// the Free Software Foundation, either version 3 of the License, or +// (at your option) any later version. +// +// This program is distributed in the hope that it will be useful, +// but WITHOUT ANY WARRANTY; without even the implied warranty of +// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +// GNU General Public License for more details. +// +// You should have received a copy of the GNU General Public License +// along with this program. If not, see . +// +// All names, logos, and references to "Deltares" are registered trademarks of +// Stichting Deltares and remain full property of Stichting Deltares at all times. +// All rights reserved. + +using Migration.Core.Storage; + +namespace Migration.Scripts.Service +{ + public static class MigrationScriptsService + { + public static void Execute(MigrationDatabaseSourceFile sourceFile, MigrationDatabaseTargetFile targetFile) + { + + } + } +} \ No newline at end of file Index: Migration/Scripts/src/Migration.Scripts.Service/Properties/AssemblyInfo.cs =================================================================== diff -u --- Migration/Scripts/src/Migration.Scripts.Service/Properties/AssemblyInfo.cs (revision 0) +++ Migration/Scripts/src/Migration.Scripts.Service/Properties/AssemblyInfo.cs (revision 4d5dca55a70d246ccfc093c982e9805d9c07301e) @@ -0,0 +1,27 @@ +// Copyright (C) Stichting Deltares 2016. All rights reserved. +// +// This file is part of Ringtoets. +// +// Ringtoets is free software: you can redistribute it and/or modify +// it under the terms of the GNU General Public License as published by +// the Free Software Foundation, either version 3 of the License, or +// (at your option) any later version. +// +// This program is distributed in the hope that it will be useful, +// but WITHOUT ANY WARRANTY; without even the implied warranty of +// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +// GNU General Public License for more details. +// +// You should have received a copy of the GNU General Public License +// along with this program. If not, see . +// +// All names, logos, and references to "Deltares" are registered trademarks of +// Stichting Deltares and remain full property of Stichting Deltares at all times. +// All rights reserved. + +using System.Reflection; +using System.Runtime.InteropServices; + +[assembly: AssemblyTitle("Migration.Scripts.Service")] +[assembly: AssemblyProduct("Migration.Scripts.Service")] +[assembly: Guid("1ea671f9-1f34-480c-b232-ff9a2a06af8f")] \ No newline at end of file Index: Migration/Scripts/test/Migration.Scripts.Service.Test/Migration.Scripts.Service.Test.csproj =================================================================== diff -u --- Migration/Scripts/test/Migration.Scripts.Service.Test/Migration.Scripts.Service.Test.csproj (revision 0) +++ Migration/Scripts/test/Migration.Scripts.Service.Test/Migration.Scripts.Service.Test.csproj (revision 4d5dca55a70d246ccfc093c982e9805d9c07301e) @@ -0,0 +1,64 @@ + + + + Debug + x86 + {E3C605BE-2EA5-4877-9BC7-71EA499CD21C} + Library + Properties + Migration.Scripts.Service.Test + Migration.Scripts.Service.Test + v4.0 + 512 + + + true + bin\Debug\ + 4 + x86 + MinimumRecommendedRules.ruleset + TRACE;DEBUG + full + + + none + bin\Release\ + 4 + x86 + MinimumRecommendedRules.ruleset + TRACE + true + none + + + bin\ReleaseForCodeCoverage\ + TRACE + true + x86 + MinimumRecommendedRules.ruleset + none + + + + + + + + Properties\GlobalAssembly.cs + + + + + + Copying.licenseheader + + + + + \ No newline at end of file Index: Migration/Scripts/test/Migration.Scripts.Service.Test/Properties/AssemblyInfo.cs =================================================================== diff -u --- Migration/Scripts/test/Migration.Scripts.Service.Test/Properties/AssemblyInfo.cs (revision 0) +++ Migration/Scripts/test/Migration.Scripts.Service.Test/Properties/AssemblyInfo.cs (revision 4d5dca55a70d246ccfc093c982e9805d9c07301e) @@ -0,0 +1,27 @@ +// Copyright (C) Stichting Deltares 2016. All rights reserved. +// +// This file is part of Ringtoets. +// +// Ringtoets is free software: you can redistribute it and/or modify +// it under the terms of the GNU General Public License as published by +// the Free Software Foundation, either version 3 of the License, or +// (at your option) any later version. +// +// This program is distributed in the hope that it will be useful, +// but WITHOUT ANY WARRANTY; without even the implied warranty of +// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +// GNU General Public License for more details. +// +// You should have received a copy of the GNU General Public License +// along with this program. If not, see . +// +// All names, logos, and references to "Deltares" are registered trademarks of +// Stichting Deltares and remain full property of Stichting Deltares at all times. +// All rights reserved. + +using System.Reflection; +using System.Runtime.InteropServices; + +[assembly: AssemblyTitle("Migration.Scripts.Service.Test")] +[assembly: AssemblyProduct("Migration.Scripts.Service.Test")] +[assembly: Guid("e3c605be-2ea5-4877-9bc7-71ea499cd21c")] \ No newline at end of file Index: Ringtoets.sln =================================================================== diff -u -r81c60620a31dcb8c4f174212d266b38f6ba08e6a -r4d5dca55a70d246ccfc093c982e9805d9c07301e --- Ringtoets.sln (.../Ringtoets.sln) (revision 81c60620a31dcb8c4f174212d266b38f6ba08e6a) +++ Ringtoets.sln (.../Ringtoets.sln) (revision 4d5dca55a70d246ccfc093c982e9805d9c07301e) @@ -1342,6 +1342,16 @@ {C90B77DA-E421-43CC-B82E-529651BC21AC} = {C90B77DA-E421-43CC-B82E-529651BC21AC} EndProjectSection EndProject +Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Migration.Scripts.Service", "Migration\Scripts\src\Migration.Scripts.Service\Migration.Scripts.Service.csproj", "{1EA671F9-1F34-480C-B232-FF9A2A06AF8F}" + ProjectSection(ProjectDependencies) = postProject + {C90B77DA-E421-43CC-B82E-529651BC21AC} = {C90B77DA-E421-43CC-B82E-529651BC21AC} + EndProjectSection +EndProject +Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Migration.Scripts.Service.Test", "Migration\Scripts\test\Migration.Scripts.Service.Test\Migration.Scripts.Service.Test.csproj", "{E3C605BE-2EA5-4877-9BC7-71EA499CD21C}" + ProjectSection(ProjectDependencies) = postProject + {C90B77DA-E421-43CC-B82E-529651BC21AC} = {C90B77DA-E421-43CC-B82E-529651BC21AC} + EndProjectSection +EndProject Global GlobalSection(SolutionConfigurationPlatforms) = preSolution CreateInstaller|x86 = CreateInstaller|x86 @@ -3341,6 +3351,24 @@ {997FE5B1-F7E1-47A2-A354-EC97E59155A2}.Release|x86.Build.0 = Release|x86 {997FE5B1-F7E1-47A2-A354-EC97E59155A2}.ReleaseForCodeCoverage|x86.ActiveCfg = ReleaseForCodeCoverage|x86 {997FE5B1-F7E1-47A2-A354-EC97E59155A2}.ReleaseForCodeCoverage|x86.Build.0 = ReleaseForCodeCoverage|x86 + {1EA671F9-1F34-480C-B232-FF9A2A06AF8F}.CreateInstaller|x86.ActiveCfg = Release|x86 + {1EA671F9-1F34-480C-B232-FF9A2A06AF8F}.CreateInstaller|x86.Build.0 = Release|x86 + {1EA671F9-1F34-480C-B232-FF9A2A06AF8F}.CreateInstallerWithDemoProject|x86.ActiveCfg = Release|x86 + {1EA671F9-1F34-480C-B232-FF9A2A06AF8F}.CreateInstallerWithDemoProject|x86.Build.0 = Release|x86 + {1EA671F9-1F34-480C-B232-FF9A2A06AF8F}.Debug|x86.ActiveCfg = Debug|x86 + {1EA671F9-1F34-480C-B232-FF9A2A06AF8F}.Debug|x86.Build.0 = Debug|x86 + {1EA671F9-1F34-480C-B232-FF9A2A06AF8F}.Release|x86.ActiveCfg = Release|x86 + {1EA671F9-1F34-480C-B232-FF9A2A06AF8F}.Release|x86.Build.0 = Release|x86 + {1EA671F9-1F34-480C-B232-FF9A2A06AF8F}.ReleaseForCodeCoverage|x86.ActiveCfg = ReleaseForCodeCoverage|x86 + {1EA671F9-1F34-480C-B232-FF9A2A06AF8F}.ReleaseForCodeCoverage|x86.Build.0 = ReleaseForCodeCoverage|x86 + {E3C605BE-2EA5-4877-9BC7-71EA499CD21C}.CreateInstaller|x86.ActiveCfg = Release|x86 + {E3C605BE-2EA5-4877-9BC7-71EA499CD21C}.CreateInstallerWithDemoProject|x86.ActiveCfg = Release|x86 + {E3C605BE-2EA5-4877-9BC7-71EA499CD21C}.Debug|x86.ActiveCfg = Debug|x86 + {E3C605BE-2EA5-4877-9BC7-71EA499CD21C}.Debug|x86.Build.0 = Debug|x86 + {E3C605BE-2EA5-4877-9BC7-71EA499CD21C}.Release|x86.ActiveCfg = Release|x86 + {E3C605BE-2EA5-4877-9BC7-71EA499CD21C}.Release|x86.Build.0 = Release|x86 + {E3C605BE-2EA5-4877-9BC7-71EA499CD21C}.ReleaseForCodeCoverage|x86.ActiveCfg = ReleaseForCodeCoverage|x86 + {E3C605BE-2EA5-4877-9BC7-71EA499CD21C}.ReleaseForCodeCoverage|x86.Build.0 = ReleaseForCodeCoverage|x86 EndGlobalSection GlobalSection(SolutionProperties) = preSolution HideSolutionNode = FALSE @@ -3638,6 +3666,8 @@ {EED7826A-5397-4EEB-A1F8-A7550078459E} = {ECD6276C-D7AC-41F8-A202-384C6CB96450} {A1091DFF-25FE-494A-8B96-56BB16D22AA2} = {49F87ABC-EC9F-4993-8E33-37C5C883C543} {997FE5B1-F7E1-47A2-A354-EC97E59155A2} = {49F87ABC-EC9F-4993-8E33-37C5C883C543} + {1EA671F9-1F34-480C-B232-FF9A2A06AF8F} = {19834E97-BB19-4755-A652-814E48BA433E} + {E3C605BE-2EA5-4877-9BC7-71EA499CD21C} = {FA7A737E-D2DB-4AD4-94CC-E3EFF242C485} EndGlobalSection GlobalSection(TextTemplating) = postSolution TextTemplating = 1