public DefaultDateStatsCteQueryBuilder(IDataSourceComponents dataSourceComponents) : base(dataSourceComponents)
{
var statsTable = dataSourceComponents.TableMappings.GetAllTables().FirstOrDefault(x => x is StatsTableMapping);
if (statsTable != null)
{
_statsTableName = statsTable.KnownTableName;
_statsTableAlias = statsTable.Alias;
}
}
protected DataSourceBase(IDataSourceComponents dataSourceComponents)
{
_dataSourceComponents = dataSourceComponents;
columnProvider = dataSourceComponents.ColumnProvider;
QueryHelpers = dataSourceComponents.QueryHelpers;
_calculatedColumnHelper = dataSourceComponents.CalculatedColumnHelper;
requestMapper = dataSourceComponents.SearchRequestMapper;
_constants = dataSourceComponents.Constants;
_tableMappings = dataSourceComponents.TableMappings;
_columnValidator = dataSourceComponents.ColumnMappingValidator;
}
public DefaultOneToManyCteQueryBuilder(IDataSourceComponents dataSourceComponents, string fromKnownTable) : base(dataSourceComponents)
{
var fromTable = dataSourceComponents.TableMappings.GetTableMapping(fromKnownTable);
_fromTableName = fromKnownTable;
_fromTableNameAlias = fromTable.Alias;
// important : if this column is not in the db, it can cause performance issues having to lookup the value all the time, so set cacheOnly:true
var primaryKeyColumn = _calculatedColumnHelper.FindColumnByFieldName(fromTable.KnownTableName, fromTable.PrimaryKey, FieldAggregationMethod.Exclude, statTransposeKeyValue: null, cacheOnly: true);
if (primaryKeyColumn != null)
{
_primaryKeyColumnId = primaryKeyColumn.Id;
}
}
public DefaultTransposeStatsCteQueryBuilder(IDataSourceComponents dataSourceComponents) : base(dataSourceComponents)
{
_dataSourceComponents = dataSourceComponents;
var transposeStatsTable = dataSourceComponents.TableMappings.GetAllTables().FirstOrDefault(x => x is TransposeStatsTableMapping);
if (transposeStatsTable != null)
{
_transposeStatsTableName = transposeStatsTable.KnownTableName;
_transposeStatsTableAlias = transposeStatsTable.Alias;
var transposeKeyField = ((TransposeStatsTableMapping)transposeStatsTable).TransposeKey;
_transposeStatsKeyFieldAlias = "_" + transposeKeyField;
var transposeKeyColumn = _columnProvider.Find(_constants.DataSourceId, _transposeStatsTableName, transposeKeyField, null);
_transposeKeyColumnId = transposeKeyColumn.First().Id;
}
}
public DefaultStatsQueryBuilder(IDataSourceComponents dataSourceComponents) : base(dataSourceComponents)
{
_dataSourceComponents = dataSourceComponents;
var statsTable = dataSourceComponents.TableMappings.GetAllTables().FirstOrDefault(x => x is StatsTableMapping);
if (statsTable != null)
{
_statsTableName = statsTable.KnownTableName;
_statsTableAlias = statsTable.Alias;
_dateStatsTableAlias = "dateStats"; // _constants.DateStatsTableAliasPrefix + _statsTableAlias;
}
var transposeStatsTable = dataSourceComponents.TableMappings.GetAllTables().FirstOrDefault(x => x is TransposeStatsTableMapping);
if (transposeStatsTable != null)
{
_transposeStatsTableAlias = transposeStatsTable.Alias;
_transposeStatsKeyField = "_" + ((TransposeStatsTableMapping)transposeStatsTable).TransposeKey;
}
}
protected QueryBuilderBase(IDataSourceComponents dataSourceComponents)
{
_dataSourceComponents = dataSourceComponents;
}
public Scenario1QueryBuilderBase(IDataSourceComponents dataSourceComponents)
: base(dataSourceComponents)
{
}
public DefaultSearchQueryBuilder(IDataSourceComponents dataSourceComponents) : base(dataSourceComponents)
{
_dataSourceComponents = dataSourceComponents;
}
public DefaultSearchRequestMapper(IDataSourceComponents dataSourceComponents)
{
_dataSourceComponents = dataSourceComponents;
}
public DefaultMissingSummariseDataQueryBuilder(IDataSourceComponents dataSourceComponents) : base(dataSourceComponents)
{
}
public DefaultOneToManyCteQueryBuilderFactory(IDataSourceComponents dataSourceComponents)
{
_dataSourceComponents = dataSourceComponents;
}
