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 }