Ajax_when_getVisualisationData_is_true_and_chart_type_is_NOT_map_and_schema_definition_hasLatLngColumns_SETS_chartNumberToShow_value_from_WebConfig_if_null_andReturns_data_from_visualiseSchema
()
{
//arrange
string category = "";
string schema = "";
int? currentPage = null;
int? numberToShow = null;
string orderByColumn = "";
string orderByDirection = "";
IList <FilterCriteria> filter = new List <FilterCriteria>();
string download = "";
bool getVisualisationData = true;
string chartType = "";
string xAxis = "";
string yAxis = "";
int chartCurrentPage = 1;
int chartNumberToShow = 10;
string yAxisAggregate = "";
DataSetSchema schemaDetail = new DataSetSchema()
{
Definition = new DataSetSchemaDefinition()
{
Columns = new List <DataSetSchemaColumn>()
{
new DataSetSchemaColumn()
{
ColumnName = "Latitude"
}, new DataSetSchemaColumn()
{
ColumnName = "Longitude"
}
}
}
};
var mock = new Mock <IDataSetDetailService>();
mock.Setup(x => x.VisualiseSchema(filter, schemaDetail, 1, 10, chartType, xAxis, yAxis, yAxisAggregate)).Returns(new ViewControllerData()
{
DataGraph = "fromVisualiseSchema"
});
_datasetDetailService = mock.Object;
var mock2 = new Mock <IDataSetSchemaService>();
mock2.Setup(x => x.Get(schema)).Returns(schemaDetail);
_dataSchemaService = mock2.Object;
var sut = new ViewController(_dataSchemaService, _datasetDetailService, _categoryService, _sysConfigService);
//action
var result = (JsonResult)sut.Ajax(category, schema, currentPage, numberToShow, orderByColumn, orderByDirection, filter,
download, getVisualisationData, chartType, xAxis, yAxis, chartCurrentPage,
null, yAxisAggregate);
var unboxedResult = (ViewControllerData)result.Data;
//assert
Assert.AreEqual(unboxedResult.DataGraph, "fromVisualiseSchema");
//cleanup
}
public void Index_when_category_url_schema_url_filetitle_is_given_and_format_is_xml_returns_XmlDocument_that_is_not_empty()
{
//arrange
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get("schemaurl")).Returns(new DataSetSchema());
_datasetschemaservice = mock.Object;
var dt = new DataTable("tablename");
dt.Columns.Add(new DataColumn("test"));
var row = dt.NewRow();
row["test"] = "testvalue";
dt.Rows.Add(row);
var mock2 = new Mock <IDataSetDetailService>();
mock2.Setup(x => x.GetData("dataseturl", "schemaurl")).Returns(dt);
_datasetdetailservice = mock2.Object;
var customersController = new DownloadController(_datasetschemaservice, _datasetdetailservice, _categoryservice, _systemConfigurationService);
// Act
var result = customersController.Index("categoryurl", "schemaurl", "dataseturl", "xml", null, null, null, null) as XmlResult;
// Assert
Assert.IsTrue(((XmlDocument)result.ObjectToSerialize).HasChildNodes, "Xml document was empty");
}
public void Index_when_schema_is_not_null_and_schema_detail_is_not_null_and_schema_is_online_and_is_external_data_returns_ViewResult_ExternalDataset()
{
//arrange
var schema = "schemanotNull";
var schemaDetail = new DataSetSchema()
{
IsDisabled = false, IsApproved = true, IsExternalData = true, Category = new Category()
{
IsDisabled = false
}
};
var filter = new List <FilterCriteria>();
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get(schema)).Returns(schemaDetail);
_dataSchemaService = mock.Object;
var mock2 = new Mock <IDataSetDetailService>();
mock2.Setup(x => x.SearchSchema(filter, schemaDetail, "", "")).Returns(new ViewControllerData());
_datasetDetailService = mock2.Object;
var sut = new ViewController(_dataSchemaService, _datasetDetailService, _categoryService, _sysConfigService);
//action
var result = (ViewResult)sut.Index("category", schema, 1, 1, "", "", filter, "", "");
//assert
Assert.AreEqual("ExternalDataSet", result.ViewName);
//cleanup
_dataSchemaService = null;
_datasetDetailService = null;
}
ImportFromUrl_when_imported_ok_returns_importdatasetschemaresult_with_no_error_message()
{
//arrange
var dschema = new DataSetSchema()
{
SchemaDefinitionFromUrl = "http://dummyurl"
};
var obj = new SchemaRestDefinition()
{
ErrorMessage = "", RestSchema = new RestSchema()
{
}, RestColumnDefinitions = new RestColumnDefinitions()
};
var mock = new Mock <IXmlToObjectService>();
mock.Setup(x => x.GetXmlFromUrl("http://dummyurl")).Returns("<SchemaRestDefinition></SchemaRestDefinition>");
mock.Setup(x => x.ConvertXml <SchemaRestDefinition>("<SchemaRestDefinition></SchemaRestDefinition>"))
.Returns(obj);
_xmlToObjectService = mock.Object;
_dataSetSchemaService = new Mock <IDataSetSchemaService>().Object;
var service = new DataShareSchemaImportService(_xmlToObjectService, _dataSetSchemaService,
_dataSetSchemaColumnService);
//act
var result = service.ImportFromUrl(dschema);
//assert
Assert.AreEqual("", result.ErrorMessage);
//cleanup
_xmlToObjectService = null;
}
public void DatasetExistsAlready_when_title_isnot_found_and_alldataisoverwrittenonupload_true_returns_false()
{
//arrange
var schema = new DataSetSchema()
{
Id = 1, IsAllDataOverwittenOnUpload = true
};
var dsd1 = new DataSetDetail()
{
Title = "title", Schema = schema
};
_repositoryDataSetDetail.Add(dsd1);
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get(1)).Returns(schema);
_dataSetSchemaService = mock.Object;
var sut = new DataSetDetailUploaderService(_dataSetSchemaService, _repositoryDataSetDetail, _csvProcessor, _sqlRepo);
//act
var result = sut.DatasetExistsAlready(1, "tidsatle");
//assert
Assert.AreEqual(false, result);
//cleanup
_repositoryDataSetDetail.Delete(dsd1);
}
Ajax_when_getVisualisationData_is_FALSE_returns_result_from_search_schema()
{
//arrange
string category = "";
string schema = "";
int currentPage = 1;
int numberToShow = 10;
string orderByColumn = "";
string orderByDirection = "";
IList <FilterCriteria> filter = new List <FilterCriteria>();
string download = "";
bool getVisualisationData = false;
string chartType = "";
string xAxis = "";
string yAxis = "";
int chartCurrentPage = 1;
int chartNumberToShow = 10;
string yAxisAggregate = "";
DataSetSchema schemaDetail = new DataSetSchema()
{
Definition = new DataSetSchemaDefinition()
{
Columns = new List <DataSetSchemaColumn>()
{
new DataSetSchemaColumn()
{
ColumnName = "Latitude"
}, new DataSetSchemaColumn()
{
ColumnName = "Longitude"
}
}
}
};
var mock = new Mock <IDataSetDetailService>();
mock.Setup(x => x.SearchSchema(filter, schemaDetail, currentPage, numberToShow, orderByColumn, orderByDirection, true)).Returns(new ViewControllerData()
{
DataGraph = "fromSearchSchema"
});
_datasetDetailService = mock.Object;
var mock2 = new Mock <IDataSetSchemaService>();
mock2.Setup(x => x.Get(schema)).Returns(schemaDetail);
_dataSchemaService = mock2.Object;
var sut = new ViewController(_dataSchemaService, _datasetDetailService, _categoryService, _sysConfigService);
//action
var result = (JsonNetResult)sut.Ajax(category, schema, currentPage, numberToShow, orderByColumn, orderByDirection, filter,
download, getVisualisationData, chartType, xAxis, yAxis, chartCurrentPage,
null, yAxisAggregate);
var unboxedResult = (ViewControllerData)result.Data;
//assert
Assert.AreEqual(unboxedResult.DataGraph, "fromSearchSchema");
//cleanup
}
public DownloadController(IDataSetSchemaService dataSetSchemaService,
IDataSetDetailService dataSetDetailService,
ICategoryService categoryService,
ISystemConfigurationService systemConfigurationService)
: base(systemConfigurationService, categoryService)
{
_dataSetSchemaService = dataSetSchemaService;
_dataSetDetailService = dataSetDetailService;
_categoryService = categoryService;
}
public DataSetDetailService(ISystemConfigurationService systemConfigurationService
, IRepository <DataSetDetail> repository
, IDataSetSchemaService dataSetSchemaService
, IDataSetDetailSqlRepo dataSetDetailSqlRepo, ISqlOrderByColumnAndDirectionFormatter sqlOrderByTextFormatter)
{
_systemConfigurationService = systemConfigurationService;
_repository = repository;
_dataSetSchemaService = dataSetSchemaService;
_dataSetDetailSqlRepo = dataSetDetailSqlRepo;
_sqlOrderByTextFormatter = sqlOrderByTextFormatter;
}
public DataSetDetailUploaderService(IDataSetSchemaService dataSetSchemaService
, IRepository <DataSetDetail> repositoryDataSetDetails
, IDataSetDetailCsvProcessor csvProcessor
, IDataSetDetailSqlRepo dataSetDetailSqlRepo
)
{
_dataSetSchemaService = dataSetSchemaService;
_repositoryDataSetDetails = repositoryDataSetDetails;
_csvProcessor = csvProcessor;
_dataSetDetailSqlRepo = dataSetDetailSqlRepo;
}
public SchemaController(IEsdFunctionService esdFunctionService,
IDataShareSchemaImportService dataShareSchemaImportService,
IDataSetSchemaService dataSetSchemaService,
IDataSetSchemaColumnService dataSetSchemaColumnService,
ICategoryService categoryService, ISystemConfigurationService systemConfigurationService)
: base(systemConfigurationService, categoryService)
{
_esdFunctionService = esdFunctionService;
_dataShareSchemaImportService = dataShareSchemaImportService;
_dataSetSchemaService = dataSetSchemaService;
_dataSetSchemaColumnService = dataSetSchemaColumnService;
_categoryService = categoryService;
}
public void Index_when_schema_is_null_and_schema_detail_is_null_and_category_is_null_return_view_index()
{
//arrange
var mock = new Mock <IDataSetSchemaService>();
_dataSchemaService = mock.Object;
_categoryService = new Mock <ICategoryService>().Object;
var filter = new List <FilterCriteria>();
var sut = new ViewController(_dataSchemaService, _datasetDetailService, _categoryService, _sysConfigService);
//action
var result = (ViewResult)sut.Index(null, null, 1, 1, "", "", filter, "", "");
//assert
Assert.AreEqual("Index", result.ViewName);
//cleanup
}
Index_when_schema_is_null_and_schema_detail_is_null_and_category_is_not_null_and_category_is_all_returns_viewREsult_schema
()
{
//arrange
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.GetAll()).Returns(new List <DataSetSchema>());
_dataSchemaService = mock.Object;
var sut = new ViewController(_dataSchemaService, _datasetDetailService, _categoryService, _sysConfigService);
//action
var result = (ViewResult)sut.Index("all", "", 1, 1, "", "", null, "", "");
//assert
Assert.AreEqual("Schema", result.ViewName);
//cleanup
_dataSchemaService = null;
}
public void AddExternalDataSet_returns_datasetdetail_fileurl_with_url()
{
//arrange
var mock = new Mock <IDataSetSchemaService>();
var repositoryDataSetSchema = new MemoryRepository <DataSetSchema>();
mock.Setup(x => x.Repository).Returns(repositoryDataSetSchema);
_dataSetSchemaService = mock.Object;
var sut = new DataSetDetailUploaderService(_dataSetSchemaService, _repositoryDataSetDetail, _csvProcessor, _sqlRepo);
//act
var result = sut.AddExternalDataSet(1, "title", "url", "type");
//assert
Assert.AreEqual("url", result.FileUrl);
//cleanup
_dataSetSchemaService = null;
}
public void AddExternalDataSet_add_dataset_into_repository()
{
//arrange
var mock = new Mock <IDataSetSchemaService>();
var repositoryDataSetSchema = new MemoryRepository <DataSetSchema>();
mock.Setup(x => x.Repository).Returns(repositoryDataSetSchema);
_dataSetSchemaService = mock.Object;
var sut = new DataSetDetailUploaderService(_dataSetSchemaService, _repositoryDataSetDetail, _csvProcessor, _sqlRepo);
//act
var result = sut.AddExternalDataSet(1, "titleinserted", "url", "type");
var resultfromrepo = _repositoryDataSetDetail.GetQuery().FirstOrDefault(x => x.Title == "titleinserted");
//assert
Assert.AreEqual("titleinserted", resultfromrepo.Title);
//cleanup
_dataSetSchemaService = null;
}
ImportFromUrl_when_columnDefinitions_contains_publisherlabel_returns_importdatasetschemaresult_with_error_message_with_xml_schema_cannot_contain_reserved_columns()
{
//arrange
var dschema = new DataSetSchema()
{
SchemaDefinitionFromUrl = "http://dummyurl"
};
var obj = new SchemaRestDefinition()
{
ErrorMessage = "",
RestSchema = new RestSchema()
{
},
RestColumnDefinitions = new RestColumnDefinitions()
{
ColumnDefinitions = new List <RestColumnDefinition>()
{
new RestColumnDefinition()
{
Name = "publisherLabel"
}
}
}
};
var mock = new Mock <IXmlToObjectService>();
mock.Setup(x => x.GetXmlFromUrl("http://dummyurl")).Returns("<SchemaRestDefinition></SchemaRestDefinition>");
mock.Setup(x => x.ConvertXml <SchemaRestDefinition>("<SchemaRestDefinition></SchemaRestDefinition>"))
.Returns(obj);
_xmlToObjectService = mock.Object;
_dataSetSchemaService = new Mock <IDataSetSchemaService>().Object;
var service = new DataShareSchemaImportService(_xmlToObjectService, _dataSetSchemaService,
_dataSetSchemaColumnService);
//act
var result = service.ImportFromUrl(dschema);
//assert
Assert.AreEqual("Error: Columns cannot contain reserved column names - PublisherUri/PublisherLabel/Publisher Uri/Publisher Label. http://dummyurl"
, result.ErrorMessage);
//cleanup
_xmlToObjectService = null;
}
public void Index_when_schema_is_not_null_and_schema_detail_is_not_null_and_schema_is_not_online_and_preview_is_not_true_returns_partial_view_offline()
{
//arrange
var schema = "schemanotNull";
var schemaDetail = new DataSetSchema();
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get(schema)).Returns(schemaDetail);
_dataSchemaService = mock.Object;
var sut = new ViewController(_dataSchemaService, _datasetDetailService, _categoryService, _sysConfigService);
//action
var filter = new List <FilterCriteria>();
var result = (PartialViewResult)sut.Index("category", schema, 1, 1, "", "", filter, "", "previewNotTrue");
//assert
Assert.AreEqual("Offline", result.ViewName);
//cleanup
_dataSchemaService = null;
}
private static void InitialiseDatabase()
{
// Setup StructureMap to determine the concrete repository pattern to use.
ObjectFactory.Initialize(
x =>
{
x.For <IUnitOfWorkFactory>().Use <EFUnitOfWorkFactory>();
x.For(typeof(IRepository <>)).Use(typeof(Repository <>));
x.For <ISqlTableUtility>().Use <SqlTableUtility>();
x.For <IDataSetSchemaDefinitionService>().Use <DataSetSchemaDefinitionService>();
x.For <IDataSetDetailSqlRepo>().Use <DataSetDetailSqlRepo>();
x.For <ISystemConfigurationService>().Use <SystemConfigurationService>();
x.For <ICacheProvider>().Use <HttpCache>();
x.For <IDataSetDetailCsvProcessor>().Use <DataSetDetailCsvProcessor>();
x.For <IDataSetSchemaService>().Use <DataSetSchemaService>();
}
);
// Select an Entity Framework model to use with the factory.
EFUnitOfWorkFactory.SetObjectContext(() => new DataShareContext());
//Never recreate the database
Database.SetInitializer <DataShareContext>(null);
//initialise all services
_dataSetSchemaService = new DataSetSchemaService(
ObjectFactory.GetInstance <IRepository <DataSetSchema> >()
, ObjectFactory.GetInstance <DataSetSchemaDefinitionService>()
, ObjectFactory.GetInstance <IRepository <DataSetDetail> >()
, ObjectFactory.GetInstance <ISqlTableUtility>());
_uploaderService = new DataSetDetailUploaderService(
_dataSetSchemaService
, ObjectFactory.GetInstance <IRepository <DataSetDetail> >()
, ObjectFactory.GetInstance <IDataSetDetailCsvProcessor>()
, ObjectFactory.GetInstance <IDataSetDetailSqlRepo>());
_debugInfoService = new DebugInfoService(ObjectFactory.GetInstance <IRepository <DebugInfo> >());
}
public void Index_when_schema_is_not_null_and_schema_detail_is_not_null_schema_is_online_Filter_has_value_and_Not_external_data_will_use_Search_schema_to_return_viewControllerData()
{
//arrange
var schema = "schemanotNull";
var schemaDetail = new DataSetSchema()
{
IsDisabled = false, IsApproved = true, IsExternalData = false, Category = new Category()
{
IsDisabled = false
}
};
var filter = new List <FilterCriteria>()
{
new FilterCriteria()
{
}
};
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get(schema)).Returns(schemaDetail);
_dataSchemaService = mock.Object;
var mock2 = new Mock <IDataSetDetailService>();
mock2.Setup(x => x.SearchSchema(filter, schemaDetail, 1, 1, "", "", true)).Returns(new ViewControllerData()
{
Count = 1234
});
_datasetDetailService = mock2.Object;
var sut = new ViewController(_dataSchemaService, _datasetDetailService, _categoryService, _sysConfigService);
//action
var result = (ViewResult)sut.Index("category", schema, 1, 1, "", "", filter, "", "");
var model = (ViewControllerData)result.Model;
//assert
Assert.AreEqual(1234, model.Count);
//cleanup
_dataSchemaService = null;
_datasetDetailService = null;
}
public void Index_Download_when_categoryurl_and_schema_url_is_given_will_return_a_viewname_of_DataSet()
{
//arrange
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get("schemafriendlyurl")).Returns(new DataSetSchema());
_datasetschemaservice = mock.Object;
var customersController = new DownloadController(_datasetschemaservice, _datasetdetailservice, _categoryservice, _systemConfigurationService);
// Act
var result = customersController.Index("categoryfriendlyurl", "schemafriendlyurl", null, null, null, null, null, null) as ViewResult;
// Assert
Assert.AreEqual("DataSet", result.ViewName, "View name should have been DataSet");
//var data = (IList<DataSetDetail>)result.Model;
//Assert.IsTrue(data != null && data.Count > 0, "Shuuld have returned a list of DataSets");
}
public void LoadList_When_schema_is_not_null_and_schemadetail_is_null_returns_view_error()
{
//arrange
DataSetSchema nullobj = null;
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get("schema")).Returns(nullobj);
_datasetschemaservice = mock.Object;
_mockHttpContextBase.SetupGet(x => x.Response).Returns(_mockResponseBase.Object);
var controller = new DownloadController(_datasetschemaservice, _datasetdetailservice, _categoryservice, _systemConfigurationService);
controller.ControllerContext = new ControllerContext(_mockHttpContextBase.Object, new RouteData(), controller);
//act
var result = (ViewResult)controller.Index(null, "schema", null, null, null, null, null, null);
//assert
Assert.AreEqual("Error", result.ViewName);
//cleanup
}
public void Index_Download_when_categoryurl_and_schema_url_is_given_will_return_a_list_of_datasetdetails_more_than_zero()
{
//arrange
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get("schemafriendlyurl")).Returns(new DataSetSchema());
mock.Setup(x => x.GetByFriendlyUrl("categoryfriendlyurl", "schemafriendlyurl", false)).Returns(new List <DataSetDetail>()
{
new DataSetDetail()
});
_datasetschemaservice = mock.Object;
var customersController = new DownloadController(_datasetschemaservice, _datasetdetailservice, _categoryservice, _systemConfigurationService);
// Act
var result = customersController.Index("categoryfriendlyurl", "schemafriendlyurl", null, null, null, null, null, null) as ViewResult;
var data = (IList <DataSetDetail>)result.Model;
// Assert
Assert.IsTrue(data.Count > 0, "Shuuld have returned a list of DataSets");
}
public void TestInit()
{
_repositoryDataSetSchema = new MemoryRepository <DataSetSchema>();
_datasetschemaservice = GetMockDataSetSchemaService();
_esdFunctionService = GetMockEsdFunctionService();
_mockFileSystem = GetMockFileSystem();
_datasetdetailservice = Getdatasetdetailservice();
ObjectFactory.Initialize(
x =>
{
x.For <IUnitOfWorkFactory>().Use <MemoryUnitOfWorkFactory>();
x.For <IDataSetSchemaService>().Use(_datasetschemaservice);
x.For <IEsdFunctionService>().Use(_esdFunctionService);
x.For <IFileSystem>().Use(_mockFileSystem);
x.For <IDataTableSerializer>().Use <CustomDataTableToJsonSerializer>().Named("json");
x.For <IDataTableSerializer>().Use <CustomDataTableToXmlSerializer>().Named("xml");
x.For <IDataSetDetailService>().Use(_datasetdetailservice);
}
);
}
public void GetTemplateCsv_will_return_csv_from_schema_id()
{
//arrange
var schema = new DataSetSchema()
{
Id = 1,
Definition = new DataSetSchemaDefinition()
{
Columns = new List <DataSetSchemaColumn>()
{
new DataSetSchemaColumn()
{
ColumnName = "col1"
}
, new DataSetSchemaColumn()
{
ColumnName = "col2"
}
, new DataSetSchemaColumn()
{
ColumnName = "col3"
}
}
}
};
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get(1)).Returns(schema);
_dataSetSchemaService = mock.Object;
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.GetTemplateCsv(1);
//assert
Assert.AreEqual("\"col1\",\"col2\",\"col3\"", result);
//cleanup
}
public void SaveCsv_returns_type_of_upload_result()
{
//arrange
var mock = new Mock <IDataSetSchemaService>();
_dataSetSchemaService = mock.Object;
var mock2 = new Mock <IDataSetDetailCsvProcessor>();
_csvProcessor = mock2.Object;
var mock3 = new Mock <IDataSetDetailSqlRepo>();
_sqlRepo = mock3.Object;
var sut = new DataSetDetailUploaderService(_dataSetSchemaService, _repositoryDataSetDetail, _csvProcessor, _sqlRepo);
//act
var result = sut.SaveCsv(1, "title", "filepathhere");
//assert
Assert.AreEqual(typeof(UploadResult), result.GetType());
//cleanup
_dataSetSchemaService = null;
_csvProcessor = null;
_sqlRepo = null;
}
public void Index_when_category_url_schema_url_filetitle_is_given_and_format_is_xml_returns_XmlResulttype()
{
//arrange
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get("schemaurl")).Returns(new DataSetSchema());
_datasetschemaservice = mock.Object;
var dt = new DataTable("tablename");
var mock2 = new Mock <IDataSetDetailService>();
mock2.Setup(x => x.GetData("dataseturl", "schemaurl")).Returns(dt);
_datasetdetailservice = mock2.Object;
var customersController = new DownloadController(_datasetschemaservice, _datasetdetailservice, _categoryservice, _systemConfigurationService);
// Act
var result = customersController.Index("categoryurl", "schemaurl", "dataseturl", "xml", null, null, null, null);
// Assert
Assert.AreEqual(typeof(XmlResult), result.GetType(), "Should have returned an XmlResult");
//Assert.IsNotNull(result, "Should have returned an XmlResult");
//Assert.IsTrue(((XmlDocument)result.ObjectToSerialize).HasChildNodes, "Xml document was empty");
}
public void SaveCsv_when_schema_cant_be_found_from_id_returns_null_will_return_uploadResult_with_error_message_unable_to_find_schema()
{
//arrange
var mock = new Mock <IDataSetSchemaService>();
_dataSetSchemaService = mock.Object;
var mock2 = new Mock <IDataSetDetailCsvProcessor>();
_csvProcessor = mock2.Object;
var mock3 = new Mock <IDataSetDetailSqlRepo>();
_sqlRepo = mock3.Object;
var sut = new DataSetDetailUploaderService(_dataSetSchemaService, _repositoryDataSetDetail, _csvProcessor, _sqlRepo);
//act
var result = sut.SaveCsv(1, "title", "filepathhere");
//assert
Assert.AreEqual("Unable to find schema 1", result.Errors[0]);
//cleanup
_dataSetSchemaService = null;
_csvProcessor = null;
_sqlRepo = null;
}
public void SaveCsv_when_exception_is_thrown_returns_uploadresult_with_error_message_contains_error_validating()
{
//arrange
var schema = new DataSetSchema();
var mock = new Mock <IDataSetSchemaService>();
mock.Setup(x => x.Get(1)).Returns(schema);
_dataSetSchemaService = mock.Object;
var uploadResult = new UploadResult();
var mock2 = new Mock <IDataSetDetailCsvProcessor>();
mock2.Setup(x => x.ProcessCsv("filepathhere", schema, "title")).Returns(uploadResult);
_csvProcessor = mock2.Object;
var sut = new DataSetDetailUploaderService(_dataSetSchemaService, _repositoryDataSetDetail, _csvProcessor, _sqlRepo);
//act
var result = sut.SaveCsv(1, "title", "filepathhere");
//assert
Assert.AreEqual(true, result.Errors[0].Contains("Error Validating"));
//cleanup
_dataSetSchemaService = null;
_csvProcessor = null;
_sqlRepo = null;
}
public DataSetDetailCsvProcessor(IDataSetSchemaService dataSetSchemaService, IRepository <DataSetDetail> repository)
{
_dataSetSchemaService = dataSetSchemaService;
_repository = repository;
}
public SearchController(IDataSetSchemaService dataSetSchemaService, ISystemConfigurationService systemConfigurationService, ICategoryService categoryService)
: base(systemConfigurationService, categoryService)
{
_dataSetSchemaService = dataSetSchemaService;
}
public void TestCleanup()
{
_datasetschemaservice = null;
_esdFunctionService = null;
_mockFileSystem = null;
}
