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; }