public async Task Extraction_Chart_In_Postgre_Test()
{
if (!_context.AllowPostgreSQL)
{
Assert.True(true);
return;
}
// Arrange
Mock <IDatabaseServiceProvider> mockDatabaseServiceProvider = new Mock <IDatabaseServiceProvider>();
mockDatabaseServiceProvider
.Setup(a => a.GetOneDatabaseConnectionAsync(It.IsAny <string>()))
.Returns(Task.FromResult(_context.PostgreSqlDatabaseConnection));
List <IExtractionChartQuery> extractionCharts = new List <IExtractionChartQuery>
{
new PostgreExtractionChartQuery(new PostgreSqlMapper(_context.MapperOptions), new CSharpMapper())
};
ChartService chartService = new ChartService(mockDatabaseServiceProvider.Object, extractionCharts, null);
// Act
LetPortal.Portal.Models.Charts.ExtractionChartFilter result = await chartService.Extract(
new LetPortal.Portal.Models.Charts.ExtractingChartQueryModel
{
DatabaseId = "asda",
Parameters = new List <LetPortal.Portal.Models.Charts.FilledParameterModel>
{
new LetPortal.Portal.Models.Charts.FilledParameterModel
{
Name = "queryparams.name",
Value = "testdatabase"
}
},
Query = "SELECT \"name\", \"displayName\", \"timeSpan\" FROM \"databases\" Where name={{queryparams.name}}"
});
// Assert
Assert.NotEmpty(result.Filters);
}
