public void Initialize()
{
Logger.LogActivity("IDATests - TransformationServiceTests - Start");
_DemiContext = new DEMIContext();
_TransformationService = new TransformationService(_DemiContext);
_ExcelService = new ExcelService();
DeleteTransformationSet("UnitTest_CreateTransformationSet");
DeleteTransformation("UnitTest_UpdateTransformationSetAddTwoFields", "Field5");
DeleteTransformation("UnitTest_UpdateTransformationSetAddTwoFields", "Field6");
DropTable(_DemiContext.GetTransformedDataTableName(USER_NAME));
}
public void UpdateTransformationSetAddTwoFields()
{
const string DEST_FILE = TEST_FILE_FOLDER + @"02_UpdateTransformationSetAddTwoFields_Destination.xlsx";
const string SET_NAME = "UnitTest_UpdateTransformationSetAddTwoFields";
const int SET_ID = 29;
const int EXPECTED_START_COUNT = 4;
const int EXPECTED_END_COUNT = 6;
TransformationSet set = _DemiContext.TransformationSets.Where(ts => ts.Name == SET_NAME).FirstOrDefault();
Assert.AreEqual(EXPECTED_START_COUNT, set.Transformations.Count);
_TransformationService.CreateTransformationSet(USER_NAME, SET_NAME, DEST_FILE);
_DemiContext = new DEMIContext();
set = _DemiContext.TransformationSets.Where(ts => ts.Name == SET_NAME).FirstOrDefault();
Assert.AreEqual(EXPECTED_END_COUNT, set.Transformations.Count);
Assert.IsTrue(set.Id == SET_ID);
}
public TransformationService(DEMIContext context)
{
_DemiContext = context;
}