public void VisualiseSchemaAsMap_returns_viewcontroller_with_mapdefaultzoom_as_from_systemconfiguration_service()
{
//arrange
IList <FilterCriteria> filter = null;
DataSetSchema schema = null;
var ds = new DataSet();
ds.Tables.Add(ReturnDataTable(null, 0)); //table1
ds.Tables.Add(ReturnDataTable(null, 1)); //table2
ds.Tables.Add(ReturnDataTable(null, 0)); //table3
var mock = new Mock <IDataSetDetailSqlRepo>();
mock.Setup(x => x.ExecuteQueryVisualiseSchemaMap(_repositoryDataSetDetail.DbConnectionString, null, null)).Returns(ds);
_sqlRepo = mock.Object;
var mock2 = new Mock <ISystemConfigurationService>();
mock2.Setup(x => x.GetSystemConfigurations()).Returns(new SystemConfigurationObject()
{
MapDefaultZoom = "3"
});
_systemConfigurationService = mock2.Object;
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.VisualiseSchemaAsMap(filter, schema);
//assert
Assert.AreEqual(3, result.MapDefaultZoom);
//cleanup
_sqlRepo = null;
_systemConfigurationService = null;
}
public void SearchSchema_will_return_view_controller_data_object_with_total_pages_if_not_zero_will_return_value_of_total_pages()
{
//arrange
IList <FilterCriteria> filter = null;
DataSetSchema schema = null;
int currentPage = 0;
int pageSize = 10;
string orderByColumn = "";
string orderDirection = "DESC";
bool getTotals = false;
var ds = new DataSet();
ds.Tables.Add(ReturnDataTable(null, 50));
ds.Tables.Add(new DataTable());
ds.Tables.Add(new DataTable());
var mock = new Mock <IDataSetDetailSqlRepo>();
mock.Setup(
x =>
x.ExecuteQuerySearchSchema(_repositoryDataSetDetail.DbConnectionString, filter, schema, currentPage,
pageSize, orderByColumn, orderDirection)).Returns(ds);
_sqlRepo = mock.Object;
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.SearchSchema(filter, schema, currentPage, pageSize, orderByColumn, orderDirection, getTotals);
//assert
Assert.AreEqual(5, result.TotalPages);
//cleanup
}
VisualiseSchema_when_count_mod_page_size_more_than_zero_total_pages_returns_viewcontrollerdata_totalpages_is_equal_to_total_pages_plus_1()
{
//arrange
IList <FilterCriteria> filter = null;
DataSetSchema schema = null;
int pageNumber = 1;
int pageSize = 3;
string chartType = null;
string xAxis = "123";
string yAxis = "11";
string yAxisAggregate = null;
var ds = new DataSet();
ds.Tables.Add(ReturnDataTable(null, 50));
ds.Tables.Add(ReturnDataTable(null, 10)); //10 mod 3 > 0
ds.Tables.Add(ReturnDataTable(null, 1)); //this is tested ( count of negative values)
var vsCriteria = new VisualSchemaCriteria("", null, null, "", "", "", "", "", "", 0, 0);
var mock = new Mock <IDataSetDetailSqlRepo>();
mock.Setup(x => x.ExecuteQueryVisualiseSchema(vsCriteria)).Returns(ds);
mock.Setup(
x =>
x.ConvertToVisualSchemaCriteria(_repositoryDataSetDetail.DbConnectionString, filter, schema, chartType,
xAxis, yAxis, yAxisAggregate, pageNumber, pageSize)).Returns(vsCriteria);
_sqlRepo = mock.Object;
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.VisualiseSchema(filter, schema, pageNumber, pageSize, chartType, xAxis, yAxis, yAxisAggregate);
//assert
Assert.AreEqual(4, result.TotalPages);
//cleanup
_sqlRepo = null;
}
public void SearchSchema_when_orderdirection_is_null_empty_will_set_order_direction_to_asc()
{
//arrange
IList <FilterCriteria> filter = null;
DataSetSchema schema = null;
int currentPage = 0;
int pageSize = 10;
string orderByColumn = "";
string orderDirection = "ASC";
bool getTotals = false;
var mock = new Mock <IDataSetDetailSqlRepo>();
var ds = new DataSet();
ds.Tables.Add(ReturnDataTable(null, 2));
ds.Tables.Add(new DataTable());
ds.Tables.Add(new DataTable());
mock.Setup(
x =>
x.ExecuteQuerySearchSchema(_repositoryDataSetDetail.DbConnectionString, filter, schema, currentPage,
pageSize, orderByColumn, orderDirection)).Returns(ds);
_sqlRepo = mock.Object;
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.SearchSchema(filter, schema, currentPage, pageSize, orderByColumn, "", getTotals);
//assert
Assert.AreEqual(2, result.Count);
//cleanup
}
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 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_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 GetData_when_datasetdetail_is_not_null_returns_datatable()
{
//arrange
var datasetdetail = new DataSetDetail()
{
Title = "datasetdetail title here", Schema = new DataSetSchema()
{
Title = "schema title here", Definition = new DataSetSchemaDefinition()
{
TableName = "table1", Columns = new List <DataSetSchemaColumn>()
{
new DataSetSchemaColumn()
{
Title = "col1"
}
}
}
}
};
_repositoryDataSetDetail.Add(datasetdetail);
var ds = new DataSet();
ds.Tables.Add(new DataTable());
var mock = new Mock <IDataSetDetailSqlRepo>();
mock.Setup(x => x.ExecuteQueryDatasetDetailId(_repositoryDataSetDetail.DbConnectionString, datasetdetail.Schema.Definition, datasetdetail.Id)).Returns(ds);
_sqlRepo = mock.Object;
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.GetData("datasetdetail-title-here", "schema-title-here");
//assert
Assert.AreEqual(typeof(DataTable), result.GetType());
//cleanup
}
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;
}
