private bool HasColumnWithSameName(QueryElement queryElement, QueryColumn queryColumn)
{
var columns = queryElement.GetColumns();
if (columns == null)
{
return(false);
}
return(columns.Any(c => c.Value == queryColumn.Value));
}
private string AddGroupBy(QueryElement queryElement)
{
if (_query.GroupByColumns.Count == 0)
{
return(null);
}
var sb = new StringBuilder();
sb.AppendLine();
sb.Append(_level, "GROUP BY ");
var last = _query.GroupByColumns.Last();
foreach (var column in _query.GroupByColumns)
{
if (column.Alias != null)
{
sb.Append(column.Alias);
sb.Append('.');
}
else if (column.IsDbColumn)
{
sb.Append(queryElement.Table.GetAlias());
sb.Append('.');
}
sb.Append(column.Value);
if (column != last)
{
sb.Append(", ");
}
}
return(sb.ToString());
}
public static string GetExpression(IEnumerable <object> expressionParts, IEnumerable <QueryElement> queryElements, QueryElement mainQueryElement = null)
{
var sb = new StringBuilder();
string previous = null;
foreach (var obj in expressionParts)
{
if (obj is Expression expression)
{
sb.AppendSpace(GetExpression(expression.Values, queryElements, mainQueryElement));
}
else if (obj is SqlColumn sqlColumn)
{
if (previous?.EndsWith('.') != true)
{
var table = sqlColumn.Table;
var alias = "";
alias = table.GetAlias();
if (alias == null)
{
alias = mainQueryElement?.Table.SchemaAndTableName == table.SchemaAndTableName
? mainQueryElement.Table.GetAlias()
: queryElements.Single(qe => qe.Table.SchemaAndTableName == table.SchemaAndTableName).Table.GetAlias();
}
sb.AppendSpace(alias);
sb.Append('.');
}
sb.Append(((QueryColumn)sqlColumn).Value);
previous = null;
}
else if (obj is string @string)
{
sb.AppendSpace(@string);
previous = @string;
}
else if (obj is int @int)
{
sb.AppendSpace(@int.ToString(CultureInfo.InvariantCulture));
// previous = @int;
}
else
{
throw new ArgumentException($"Expression part type is not handled. Type: {obj.GetType()}, Value: {obj}.");
}
}
return(sb.ToString());
}
private string AddQueryElementColumns(QueryElement queryElement, bool useAlias = false)
{
var columns = queryElement.GetColumns();
if (columns == null)
{
return("");
}
var sb = new StringBuilder();
var last = columns.LastOrDefault();
foreach (var column in columns)
{
if (column.Alias != null)
{
sb.Append(column.Alias);
sb.Append('.');
}
else if (column.IsDbColumn)
{
sb.Append(queryElement.Table.GetAlias());
sb.Append('.');
}
sb.Append(column.Value);
if (column.As != null)
{
sb.Append(" AS '");
sb.Append(column.As);
sb.Append('\'');
}
else if (useAlias)
{
if (_query.QueryColumnAliasStrategy != QueryColumnAliasStrategy.EnableDuplicates)
{
if (_query.QueryColumnAliasStrategy == QueryColumnAliasStrategy.PrefixTableAliasAlways)
{
sb.Append(" AS '");
sb.Append(queryElement.Table.GetAlias());
sb.Append('_');
sb.Append(column.Value);
sb.Append('\'');
}
else if (_query.QueryColumnAliasStrategy == QueryColumnAliasStrategy.PrefixTableNameIfNeeded ||
_query.QueryColumnAliasStrategy == QueryColumnAliasStrategy.PrefixTableAliasIfNeeded)
{
var hasColumnWithSameName = HasColumnWithSameName(_query, column);
if (!hasColumnWithSameName)
{
foreach (var qe in _query.QueryElements.Where(qe => qe != queryElement))
{
hasColumnWithSameName = HasColumnWithSameName(qe, column);
if (hasColumnWithSameName)
{
break;
}
}
}
if (hasColumnWithSameName)
{
sb.Append(" AS '");
if (_query.QueryColumnAliasStrategy == QueryColumnAliasStrategy.PrefixTableNameIfNeeded)
{
sb.Append(QueryHelper.GetSimplifiedSchemaAndTableName(queryElement.Table.SchemaAndTableName));
}
else // PrefixTableAliasIfNeeded
{
sb.Append(queryElement.Table.GetAlias());
sb.Append('_');
}
sb.Append(column.Value);
sb.Append('\'');
}
}
else if (_query.QueryColumnAliasStrategy == QueryColumnAliasStrategy.PrefixTableNameAlways)
{
sb.Append(" AS '");
sb.Append(QueryHelper.GetSimplifiedSchemaAndTableName(queryElement.Table.SchemaAndTableName));
sb.Append(column.Value);
sb.Append('\'');
}
else
{
#pragma warning disable IDE0071 // Simplify interpolation
throw new NotImplementedException($"Unhandled QueryColumnAliasStrategy {_query.QueryColumnAliasStrategy.ToString()}.");
#pragma warning restore IDE0071 // Simplify interpolation
}
}
}
if (column != last)
{
sb.Append(", ");
}
}
return(sb.ToString());
}
