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 SetUp() { DeltaRunnerFactory.CreateDeltaRunner("DeltaRunner", ConnectionStringMaster, false); deltaRunner = DeltaRunnerFactory.CreateDeltaRunner(ConnectionString, deltaPath, true); deltaRunner.PrepareForDeltaRunner(); }
public void SetUp() { DeltaRunnerBase.CreateDatabase("DeltaRunner", ConnectionStringMaster, false); deltaRunner = DeltaRunnerFactory.CreateDeltaRunner(ConnectionString, deltaPath, true); deltaRunner.AddSqlFile(new FileInfo("../../TestFiles/Database.sql"), SqlFileExecutionOption.ExecuteBeforeDeltas, false); deltaRunner.PrepareForDeltaRunner(); }
public void OverrideDeltaTableColumn() { deltaRunner = DeltaRunnerFactory.CreateDeltaRunner(ConnectionString, deltaPath, false); deltaRunner.DeltaVersionTableName = "Config"; deltaRunner.DeltaVersionColumnName = "Delta"; deltaRunner.RemoveDeltaRunner(); Assert.IsFalse(deltaRunner.TableExists("Config")); deltaRunner.PrepareForDeltaRunner(); Assert.IsTrue(deltaRunner.TableExists("Config")); deltaRunner.ApplyDeltas(); }
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(); }