Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -rbb04ea61be6e4ce94cb1453c4578b0e9256168c4 -r4ba34be778eb5da83e7483592764e8164d2be8af --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision bb04ea61be6e4ce94cb1453c4578b0e9256168c4) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 4ba34be778eb5da83e7483592764e8164d2be8af) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 03-aug-2016 11:20:12 */ +/* Created On : 04-aug-2016 10:16:21 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -131,9 +131,9 @@ CREATE TABLE 'VersionEntity' ( 'VersionId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FromVersion' TEXT, - 'ToVersion' TEXT, - 'Timestamp' NUMERIC + 'Version' TEXT NOT NULL, + 'Timestamp' DATETIME NOT NULL, + 'FingerPrint' BLOB NOT NULL ) ; Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Designer.cs =================================================================== diff -u -r182ee751da4cc43bd5d44e816199ded9787f619e -r4ba34be778eb5da83e7483592764e8164d2be8af --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Designer.cs (.../RingtoetsEntities.Designer.cs) (revision 182ee751da4cc43bd5d44e816199ded9787f619e) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Designer.cs (.../RingtoetsEntities.Designer.cs) (revision 4ba34be778eb5da83e7483592764e8164d2be8af) @@ -1,4 +1,4 @@ -// T4 code generation is enabled for model 'D:\Clean_WTI2017\Application\Ringtoets\src\Application.Ringtoets.Storage\DbContext\RingtoetsEntities.edmx'. +// T4 code generation is enabled for model 'D:\Branch_WTI2017\Application\Ringtoets\src\Application.Ringtoets.Storage\DbContext\RingtoetsEntities.edmx'. // To enable legacy code generation, change the value of the 'Code Generation Strategy' designer // property to 'Legacy ObjectContext'. This property is available in the Properties Window when the model // is open in the designer. Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx =================================================================== diff -u -rbb04ea61be6e4ce94cb1453c4578b0e9256168c4 -r4ba34be778eb5da83e7483592764e8164d2be8af --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx (.../RingtoetsEntities.edmx) (revision bb04ea61be6e4ce94cb1453c4578b0e9256168c4) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx (.../RingtoetsEntities.edmx) (revision 4ba34be778eb5da83e7483592764e8164d2be8af) @@ -4,7 +4,7 @@ - + @@ -433,9 +433,9 @@ - - - + + + @@ -1960,9 +1960,9 @@ - - - + + + @@ -2994,9 +2994,9 @@ + - - + Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram =================================================================== diff -u -rbb04ea61be6e4ce94cb1453c4578b0e9256168c4 -r4ba34be778eb5da83e7483592764e8164d2be8af --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram (.../RingtoetsEntities.edmx.diagram) (revision bb04ea61be6e4ce94cb1453c4578b0e9256168c4) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram (.../RingtoetsEntities.edmx.diagram) (revision 4ba34be778eb5da83e7483592764e8164d2be8af) @@ -7,44 +7,44 @@ - - - - + + + + - - - - - - - - - + + + + + + + + + - - - - - - - - - - + + + + + + + + + + - - - - - - - - - + + + + + + + + + - - + + Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/VersionEntity.cs =================================================================== diff -u -r4e65fa5d8abdf1c0a9238492cdbcd7d2b3fa2d0f -r4ba34be778eb5da83e7483592764e8164d2be8af --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/VersionEntity.cs (.../VersionEntity.cs) (revision 4e65fa5d8abdf1c0a9238492cdbcd7d2b3fa2d0f) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/VersionEntity.cs (.../VersionEntity.cs) (revision 4ba34be778eb5da83e7483592764e8164d2be8af) @@ -36,8 +36,8 @@ public partial class VersionEntity { public long VersionId { get; set; } - public string FromVersion { get; set; } - public string ToVersion { get; set; } - public Nullable Timestamp { get; set; } + public string Version { get; set; } + public System.DateTime Timestamp { get; set; } + public byte[] FingerPrint { get; set; } } } Index: Application/Ringtoets/src/Application.Ringtoets.Storage/StorageSqLite.cs =================================================================== diff -u -r91f7f3e9945fcda38418cb74c8173ff98b395d7a -r4ba34be778eb5da83e7483592764e8164d2be8af --- Application/Ringtoets/src/Application.Ringtoets.Storage/StorageSqLite.cs (.../StorageSqLite.cs) (revision 91f7f3e9945fcda38418cb74c8173ff98b395d7a) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/StorageSqLite.cs (.../StorageSqLite.cs) (revision 4ba34be778eb5da83e7483592764e8164d2be8af) @@ -184,6 +184,12 @@ try { var registry = new PersistenceRegistry(); + dbContext.VersionEntities.Add(new VersionEntity + { + FingerPrint = new byte[]{1,2,3,4,5}, + Timestamp = DateTime.Now, + Version = "1" + }); dbContext.ProjectEntities.Add(project.Create(registry)); dbContext.SaveChanges(); registry.TransferIds(); @@ -214,6 +220,9 @@ var updateCollector = new PersistenceRegistry(); project.Update(updateCollector, dbContext); updateCollector.RemoveUntouched(dbContext); + + dbContext.VersionEntities.Single().Timestamp = DateTime.Now; + dbContext.SaveChanges(); updateCollector.TransferIds(); } Index: Application/Ringtoets/test/Application.Ringtoets.Storage.TestUtil/SqLiteDatabaseHelper.cs =================================================================== diff -u -r1eed3e3f652618c52a462edc502cfd4250772314 -r4ba34be778eb5da83e7483592764e8164d2be8af --- Application/Ringtoets/test/Application.Ringtoets.Storage.TestUtil/SqLiteDatabaseHelper.cs (.../SqLiteDatabaseHelper.cs) (revision 1eed3e3f652618c52a462edc502cfd4250772314) +++ Application/Ringtoets/test/Application.Ringtoets.Storage.TestUtil/SqLiteDatabaseHelper.cs (.../SqLiteDatabaseHelper.cs) (revision 4ba34be778eb5da83e7483592764e8164d2be8af) @@ -97,7 +97,7 @@ { return "DROP TABLE IF EXISTS 'VersionEntity'; " + "CREATE TABLE VersionEntity (VersionId INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," + - " FromVersion VARCHAR (16), ToVersion VARCHAR (16),Timestamp NUMERIC); "; + " Version VARCHAR (16) NOT NULL, Timestamp DATETIME NOT NULL, FingerPrint BLOB NOT NULL); "; } ///