public ExprMerge Done() { var records = this._data.TryToCheckLength(out var capacity) ? capacity > 0 ? new List <ExprValueRow>(capacity) : null : new List <ExprValueRow>(); if (records == null) { throw new SqExpressException("Input data should not be empty"); } var dataMapKeys = this._dataMapKeys.AssertNotNull("DataMapKeys should be initialized"); var dataMap = this._dataMap.AssertNotNull("DataMap should be initialized"); DataMapSetter <TTable, TItem>? setter = null; List <ExprColumnName>? keys = null; IReadOnlyList <ExprColumnName>?allTableColumns = null; IReadOnlyList <ExprColumnName>?totalColumns = null; foreach (var item in this._data) { setter ??= new DataMapSetter <TTable, TItem>(this._table, item); setter.NextItem(item, totalColumns?.Count); dataMapKeys(setter); keys ??= new List <ExprColumnName>(setter.Columns); keys.AssertNotEmpty("There should be at least one key"); dataMap(setter); totalColumns = allTableColumns ??= new List <ExprColumnName>(setter.Columns); if (this._extraDataMap != null) { this._extraDataMap.Invoke(setter); if (ReferenceEquals(totalColumns, allTableColumns)) { totalColumns = new List <ExprColumnName>(setter.Columns); } } setter.EnsureRecordLength(); records.Add(new ExprValueRow(setter.Record.AssertFatalNotNull(nameof(setter.Record)))); } if (records.Count < 1) { throw new SqExpressException("Input data should not be empty"); } keys = keys.AssertFatalNotNull(nameof(keys)); allTableColumns = allTableColumns.AssertFatalNotNull(nameof(allTableColumns)); totalColumns = totalColumns.AssertFatalNotNull(nameof(allTableColumns)); var exprValuesTable = new ExprDerivedTableValues(new ExprTableValueConstructor(records), this._sourceTableAlias, totalColumns); if (keys.Count >= allTableColumns.Count) { throw new SqExpressException("The number of keys exceeds the number of columns"); } return(new ExprMerge( this._table, exprValuesTable, this.GetOn(keys), this.BuildWhenMatched(keys, allTableColumns), this.BuildWhenNotMatchedByTarget(keys, allTableColumns), this.BuildWhenNotMatchedBySource())); }
public ExprInsert Done() { var checkExistence = this._checkExistenceByColumns != null && this._checkExistenceByColumns.Count > 0; var useDerivedTable = this._targetInsertSelectMapping != null || checkExistence; var mapping = this._dataMapping.AssertFatalNotNull(nameof(this._dataMapping)); int?capacity = this._data.TryToCheckLength(out var c) ? c : (int?)null; if (capacity != null && capacity.Value < 1) { throw new SqExpressException("Input data should not be empty"); } List <ExprValueRow>? recordsS = null; List <ExprInsertValueRow>?recordsI = null; if (useDerivedTable) { recordsS = capacity.HasValue ? new List <ExprValueRow>(capacity.Value) : new List <ExprValueRow>(); } else { recordsI = capacity.HasValue ? new List <ExprInsertValueRow>(capacity.Value) : new List <ExprInsertValueRow>(); } DataMapSetter <TTable, TItem>? dataMapSetter = null; IReadOnlyList <ExprColumnName>?columns = null; foreach (var item in this._data) { dataMapSetter ??= new DataMapSetter <TTable, TItem>(this._target, item); dataMapSetter.NextItem(item, columns?.Count); mapping(dataMapSetter); columns ??= dataMapSetter.Columns; dataMapSetter.EnsureRecordLength(); recordsS?.Add(new ExprValueRow(dataMapSetter.Record.AssertFatalNotNull(nameof(dataMapSetter.Record)))); recordsI?.Add(new ExprInsertValueRow(dataMapSetter.Record.AssertFatalNotNull(nameof(dataMapSetter.Record)))); } if ((recordsS?.Count ?? 0 + recordsI?.Count ?? 0) < 1 || columns == null) { //In case of empty IEnumerable throw new SqExpressException("Input data should not be empty"); } IExprInsertSource insertSource; if (recordsI != null) { insertSource = new ExprInsertValues(recordsI); } else if (recordsS != null && useDerivedTable) { var valuesConstructor = new ExprTableValueConstructor(recordsS); var values = new ExprDerivedTableValues( valuesConstructor, new ExprTableAlias(Alias.Auto.BuildAliasExpression().AssertNotNull("Alias cannot be null")), columns); IReadOnlyList <ColumnValueInsertSelectMap>?additionalMaps = null; if (this._targetInsertSelectMapping != null) { var targetUpdateSetter = new TargetInsertSelectSetter <TTable>(this._target); this._targetInsertSelectMapping.Invoke(targetUpdateSetter); additionalMaps = targetUpdateSetter.Maps; if (additionalMaps.Count < 1) { throw new SqExpressException("Additional insertion cannot be null"); } } var selectValues = new List <IExprSelecting>(columns.Count + (additionalMaps?.Count ?? 0)); foreach (var exprColumnName in values.Columns) { selectValues.Add(exprColumnName); } if (additionalMaps != null) { foreach (var m in additionalMaps) { selectValues.Add(m.Value); } } IExprQuery query; var queryBuilder = SqQueryBuilder.Select(selectValues).From(values); if (checkExistence && this._checkExistenceByColumns != null) { var tbl = this._target.WithAlias(new ExprTableAlias(Alias.Auto.BuildAliasExpression() !)); var existsFilter = !SqQueryBuilder.Exists(SqQueryBuilder .SelectOne() .From(tbl) .Where(this._checkExistenceByColumns .Select(column => column.WithSource(tbl.Alias) == column.WithSource(values.Alias)) .JoinAsAnd())); query = queryBuilder.Where(existsFilter).Done(); } else { query = queryBuilder.Done(); } insertSource = new ExprInsertQuery(query); if (additionalMaps != null) { var extraInsertCols = additionalMaps.SelectToReadOnlyList(m => m.Column); columns = Helpers.Combine(columns, extraInsertCols); } } else { //Actually C# should have detected that this brunch cannot be invoked throw new SqExpressException("Fatal logic error!"); } return(new ExprInsert(this._target.FullName, columns, insertSource)); }
public static UpdateDataAnalysis AnalyzeUpdateData <TTable, TItem> ( IEnumerable <TItem> data, TTable targetTable, DataMapping <TTable, TItem> dataMapKeys, DataMapping <TTable, TItem>?dataMap, IndexDataMapping?extraDataMap, ExprTableAlias sourceTableAlias ) { var records = data.TryToCheckLength(out var capacity) ? capacity > 0 ? new List <ExprValueRow>(capacity) : null : new List <ExprValueRow>(); if (records == null) { throw new SqExpressException("Input data should not be empty"); } DataMapSetter <TTable, TItem>? setter = null; List <ExprColumnName>? keys = null; IReadOnlyList <ExprColumnName>?allTableColumns = null; IReadOnlyList <ExprColumnName>?totalColumns = null; foreach (var item in data) { setter ??= new DataMapSetter <TTable, TItem>(targetTable, item); setter.NextItem(item, totalColumns?.Count); dataMapKeys(setter); keys ??= new List <ExprColumnName>(setter.Columns); keys.AssertNotEmpty("There should be at least one key"); dataMap?.Invoke(setter); totalColumns = allTableColumns ??= new List <ExprColumnName>(setter.Columns); if (extraDataMap != null) { extraDataMap.Invoke(setter); if (ReferenceEquals(totalColumns, allTableColumns)) { totalColumns = new List <ExprColumnName>(setter.Columns); } } setter.EnsureRecordLength(); records.Add(new ExprValueRow(setter.Record.AssertFatalNotNull(nameof(setter.Record)))); } if (records.Count < 1) { throw new SqExpressException("Input data should not be empty"); } keys = keys.AssertFatalNotNull(nameof(keys)); allTableColumns = allTableColumns.AssertFatalNotNull(nameof(allTableColumns)); totalColumns = totalColumns.AssertFatalNotNull(nameof(allTableColumns)); var exprValuesTable = new ExprDerivedTableValues(new ExprTableValueConstructor(records), sourceTableAlias, totalColumns); if (keys.Count > allTableColumns.Count) { throw new SqExpressException("The number of keys exceeds the number of columns"); } return(new UpdateDataAnalysis(keys, allTableColumns, exprValuesTable)); }