public void NAntTaskApplyWithFilesAfter()
{
deltaRunner.RemoveDeltaRunner();
Assert.IsFalse(deltaRunner.TableExists("dr_DeltaVersion"));
if(TableExists("Table2_Static"))
{
ExecuteNonQuery("Drop Table [Table2_Static]");
}
deltaRunnerTask testTask = new deltaRunnerTask();
testTask.ConnectionString = ConnectionString;
testTask.Action = "PREPARE";
testTask.DeltaPath = deltaPath;
testTask.AfterScriptFiles = new FileInfo("../../TestFiles/SampleStaticFile1.sql").FullName;
testTask.ExecuteTaskImpl();
Assert.AreEqual("0", deltaRunner.GetLatestVersion());
deltaRunnerTask testTask2 = new deltaRunnerTask();
testTask2.ConnectionString = ConnectionString;
testTask2.Action = "APPLYWITHFILES";
testTask2.DeltaPath = deltaPath;
testTask2.AfterScriptFiles = new FileInfo("../../TestFiles/SampleStaticFile1.sql").FullName;
testTask2.ExecuteTaskImpl();
Assert.AreEqual("00003", deltaRunner.GetLatestVersion());
Assert.AreEqual(true, TableExists("Table2_Static"));
}
public void NAntTaskApply()
{
deltaRunner.RemoveDeltaRunner();
Assert.IsFalse(deltaRunner.TableExists("dr_DeltaVersion"));
deltaRunnerTask testTask = new deltaRunnerTask();
testTask.ConnectionString = ConnectionString;
testTask.Action = "PREPARE";
testTask.DeltaPath = deltaPath;
testTask.ExecuteTaskImpl();
Assert.AreEqual("0", deltaRunner.GetLatestVersion());
deltaRunnerTask testTask2 = new deltaRunnerTask();
testTask2.ConnectionString = ConnectionString;
testTask2.Action = "APPLY";
testTask2.DeltaPath = deltaPath;
testTask2.ExecuteTaskImpl();
Assert.AreEqual("00003", deltaRunner.GetLatestVersion());
}
public void NAntTaskRemove()
{
deltaRunner.RemoveDeltaRunner();
Assert.IsFalse(deltaRunner.TableExists("dr_DeltaVersion"));
deltaRunnerTask testTask = new deltaRunnerTask();
testTask.ConnectionString = ConnectionString;
testTask.Action = "PREPARE";
testTask.DeltaPath = deltaPath;
testTask.ExecuteTaskImpl();
Assert.IsTrue(deltaRunner.TableExists("dr_DeltaVersion"));
deltaRunnerTask testTask2 = new deltaRunnerTask();
testTask2.ConnectionString = ConnectionString;
testTask2.Action = "REMOVE";
testTask2.DeltaPath = deltaPath;
testTask2.ExecuteTaskImpl();
Assert.IsFalse(deltaRunner.TableExists("dr_DeltaVersion"));
}