public void BadDeltaRollBackTransaction() { deltaRunner = DeltaRunnerFactory.CreateDeltaRunner(ConnectionString, deltaPath2, false); deltaRunner.RemoveDeltaRunner(); deltaRunner.PrepareForDeltaRunner(); Assert.AreEqual("0", deltaRunner.GetLatestVersion()); deltaRunner.ApplyDeltas(true); Assert.AreEqual("0", deltaRunner.GetLatestVersion()); }
public void ApplyDeltaWhenColumnNull() { deltaRunner = DeltaRunnerFactory.CreateDeltaRunner(ConnectionString, deltaPath, false); deltaRunner.RemoveDeltaRunner(); deltaRunner.PrepareForDeltaRunner(); ExecuteNonQuery(string.Format("update {0} set {1} = null", deltaRunner.DeltaVersionTableName, deltaRunner.DeltaVersionColumnName)); Assert.AreEqual("0", deltaRunner.GetLatestVersion()); deltaRunner.ApplyDeltas(); Assert.AreEqual("00003", deltaRunner.GetLatestVersion()); }
public void ApplyDeltasReturnBooleanResult() { deltaRunner = DeltaRunnerFactory.CreateDeltaRunner(ConnectionString, deltaPath2, true); deltaRunner.RemoveDeltaRunner(); deltaRunner.PrepareForDeltaRunner(); ExecuteNonQuery("insert into dr_deltaversion ([latestdelta], [hash], [filename]) VALUES ('00001', 'xstD0qrfGt7um9h/rqKnLQ==', '00001.sql')"); ExecuteNonQuery("insert into dr_deltaversion ([latestdelta], [hash], [filename]) VALUES ('00002', '6eOnIXx84dCOru/ArcGkog==', '00002.sql')"); Assert.AreEqual("00002", deltaRunner.GetLatestVersion()); Assert.IsTrue(deltaRunner.ApplyDeltas()); Assert.AreEqual("00003", deltaRunner.GetLatestVersion()); Assert.IsFalse(deltaRunner.ApplyDeltas()); Assert.AreEqual("00003", deltaRunner.GetLatestVersion()); }
public void deltaRunnerUpdatesItself_OnlyExecuteNewerDeltas() { deltaRunner = DeltaRunnerFactory.CreateDeltaRunner(ConnectionString, deltaPath2, true); string oldVersionSql = @" IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[dr_DeltaVersion]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) CREATE TABLE [dbo].[dr_DeltaVersion] ( [LatestDelta] int , [Hash] varchar(25) , [Filename] varchar(255) )"; deltaRunner.RemoveDeltaRunner(); ExecuteNonQuery(oldVersionSql); ExecuteNonQuery("INSERT INTO dr_DeltaVersion (LatestDelta, Hash, Filename) VALUES(1, 'blahblah', '00001.sql')"); ExecuteNonQuery("INSERT INTO dr_DeltaVersion (LatestDelta, Hash, Filename) VALUES(2, 'blahblah', '00002.sql')"); deltaRunner.PrepareForDeltaRunner(); Assert.AreEqual("00002", deltaRunner.GetLatestVersion()); deltaRunner.ApplyDeltas(); Assert.AreEqual("00003", deltaRunner.GetLatestVersion()); deltaRunner.ApplyDeltas(); deltaRunner.ApplyDeltas(); }