public void Search_when_fromdate_and_todate_isemptyString_returns_all_datasetdetail()
{
//arrange
var searchText = "dstitle";
int schemaId = 0;
var schema = new DataSetSchema()
{
Title = "dstitle", Id = 0
};
var dsd1 = new DataSetDetail()
{
DateUpdated = new DateTime(2010, 11, 1), Schema = schema
};
var dsd2 = new DataSetDetail()
{
DateUpdated = new DateTime(2009, 12, 2), Schema = schema
};
_repositoryDataSetDetail.Add(dsd1);
_repositoryDataSetDetail.Add(dsd2);
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.Search(schemaId, searchText, "", "");
//assert
Assert.AreEqual(2, result.Count);
//cleanup
_repositoryDataSetDetail.Delete(dsd1);
_repositoryDataSetDetail.Delete(dsd2);
}
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
}
public void Search_when_todate_is_not_null_and_date_is_more_than_min_datevalue_returns_datasetdetail_with_correct_filtered_smaller_than_todate_list_of_DataSetDetail()
{
//arrange
string to = "01/01/2010";// new DateTime(2010, 1, 1);
string from = null;
var searchText = "dstitle";
int schemaId = 0;
var schema = new DataSetSchema()
{
Title = "dstitle", Id = 0
};
var dsd1 = new DataSetDetail()
{
DateUpdated = new DateTime(2010, 11, 1), Schema = schema
};
var dsd2 = new DataSetDetail()
{
DateUpdated = new DateTime(2009, 12, 2), Schema = schema
};
_repositoryDataSetDetail.Add(dsd1);
_repositoryDataSetDetail.Add(dsd2);
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.Search(schemaId, searchText, from, to);
//assert
Assert.AreEqual(new DateTime(2009, 12, 2), result[0].DateUpdated);
//cleanup
_repositoryDataSetDetail.Delete(dsd1);
_repositoryDataSetDetail.Delete(dsd2);
}
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;
}
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 void GetData_when_datasetdetail_is_null_returns_null()
{
//arrange
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.GetData("emptyurl", "emptyschemaurl");
//assert
Assert.AreEqual(null, result);
//cleanup
}
public void Search_returns_type_of_ListDataSetDetail()
{
//arrange
string to = null;
string from = null;
var searchText = "";
int schemaId = 0;
var mock = new Mock <IRepository <DataSetDetail> >();
_repositoryDataSetDetail = mock.Object;
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.Search(schemaId, searchText, from, to);
//assert
Assert.AreEqual(typeof(List <DataSetDetail>), result.GetType());
//cleanup
}
public void Get_will_return_dataset_detail_based_on_selected_id()
{
//arrange
var datasetdetail = new DataSetDetail()
{
Id = 1, Title = "datasetdetail1"
};
_repositoryDataSetDetail.Add(datasetdetail);
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.Get(1);
//assert
Assert.AreEqual("datasetdetail1", result.Title);
//cleanup
_repositoryDataSetDetail.Delete(datasetdetail);
}
VisualiseSchema_will_return_type_of_view_controller_data()
{
//arrange
IList <FilterCriteria> filter = null;
DataSetSchema schema = null;
int pageNumber = 0;
int pageSize = 0;
string chartType = null;
string xAxis = null;
string yAxis = null;
string yAxisAggregate = null;
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(typeof(ViewControllerData), result.GetType());
}
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 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
}
