/// <summary>
/// Appends the current column name in unqualified form, e.g. <c>"MyColumn"</c>, to the attribute buffer.
/// </summary>
/// <param name="attribute">The current attribute.</param>
/// <returns>A new attribute containing the appended buffer.</returns>
public static IProjectionAttribute ColName(this IProjectionAttribute attribute)
{
ITableMetadata column = ProjectionHelper.GetPreferredColumnMetadata(attribute);
string identifier = attribute.Context.Domain.Dialect.Identifier(column.ColumnName);
return(attribute.Append(identifier));
}
/// <summary>
/// Appends the current table alias, e.g. <c>T0</c>, to the attribute buffer.
/// </summary>
/// <param name="attribute">The current attribute.</param>
/// <returns>A new attribute containing the appended buffer.</returns>
public static IProjectionAttribute Ali(this IProjectionAttribute attribute)
{
ITableMetadata table = ProjectionHelper.GetTableMetadata(attribute);
string alias = attribute.Context.Lookup.Table(attribute.Identity, table.Identity);
return(attribute.Append(alias));
}
/// <summary>
/// Appends the current JSON path literal, e.g. <c>'$.my.value'</c>, to the attribute buffer.
/// </summary>
/// <param name="attribute">The current attribute.</param>
/// <returns>A new attribute containing the appended buffer.</returns>
public static IProjectionAttribute JsonPath(this IProjectionAttribute attribute)
{
IJsonMetadata metadata = ProjectionHelper.GetJsonMetadata(attribute.Metadata);
string literal = attribute.Context.Domain.Dialect.String(metadata.Path);
return(attribute.Append(literal));
}
/// <summary>
/// Appends the current table name, e.g. <c>"MyTable"</c>, to the attribute buffer.
/// </summary>
/// <param name="attribute">The current attribute.</param>
/// <returns>A new attribute containing the appended buffer.</returns>
public static IProjectionAttribute TblName(this IProjectionAttribute attribute)
{
ITableMetadata table = ProjectionHelper.GetTableMetadata(attribute);
string qualifier = attribute.Context.Domain.Dialect.Qualifier;
string tableName = string.Join(qualifier, table.TableName.Select(attribute.Context.Domain.Dialect.Identifier));
return(attribute.Append(tableName));
}
/// <summary>
/// Appends the current variable name, e.g. <c>@V0</c>, to the attribute buffer.
/// </summary>
/// <param name="attribute">The current attribute.</param>
/// <returns>A new attribute containing the appended buffer.</returns>
public static IProjectionAttribute Var(this IProjectionAttribute attribute)
{
IField field = ProjectionHelper.GetFieldValue(attribute);
string variableName = attribute.Context.Lookup.Variable(attribute.Identity, field);
string dialectName = attribute.Context.Domain.Dialect.Variable(variableName);
return(attribute.Append(dialectName));
}
/// <summary>
/// Appends mappings between the current qualified columns and their properties, e.g. <c>T0."MyColumn" AS "Item.MyValue"</c>, to the projection buffer. Identical to calling <c>Cols().As().Props()</c>.
/// </summary>
/// <param name="projection">The current projection</param>
/// <param name="tblAlias">The table alias to qualify each column name with.</param>
/// <returns>A new projection containing the appended buffer.</returns>
public static IProjection Star(this IProjection projection, string tblAlias = null)
{
if (!projection.Any())
{
throw ProjectionException.AttributesNotFound(projection.Metadata);
}
IProjectionMetadata metadata = ProjectionHelper.GetPreferredTableMetadata(projection.Metadata);
return(projection.With(metadata).Cols(tblAlias).As().Props());
}
/// <summary>
/// Appends mappings between the current qualified columns and their properties, e.g. <c>T0."MyColumn" AS "Item.MyValue"</c>, to the projection buffer. Identical to calling <c>Cols().As().Props()</c>.
/// </summary>
/// <param name="projection">The current projection</param>
/// <returns>A new projection containing the appended buffer.</returns>
public static IProjection Star(this IProjection projection)
{
if (!projection.Any())
{
throw ProjectionException.FromProjection(projection, "No attributes found.");
}
IProjectionMetadata metadata = ProjectionHelper.GetPreferredTableMetadata(projection).Identity.GetMetadata <IProjectionMetadata>();
return(projection.With(metadata).Cols().As().Props());
}
/// <summary>
/// Appends the current value in safe literal form, e.g. <c>1</c>, to the attribute buffer. Parameters are used for unsafe literals.
/// </summary>
/// <param name="attribute">The current attribute.</param>
/// <returns>A new attribute containing the appended buffer.</returns>
public static IProjectionAttribute Lit(this IProjectionAttribute attribute)
{
IField field = ProjectionHelper.GetFieldValue(attribute);
string literal = attribute.Context.Domain.Dialect.Literal(field?.Value);
if (literal == null)
{
return(attribute.Par());
}
else
{
return(attribute.Append(literal));
}
}
/// <summary>
/// Navigates the current projection to a selected target.
/// </summary>
/// <param name="projection">The current projection.</param>
/// <param name="expression">Expression selecting a projection target.</param>
/// <returns>A new projection from the selected target.</returns>
public static IProjection <TProperty> For <TModel, TProperty>(this IProjection <TModel> projection, Expression <Func <TModel, TProperty> > expression)
{
IProjectionMetadata metadata = ProjectionHelper.GetMetadataFromRelativeLambda(projection, expression);
return(projection.With(metadata).Cast <TProperty>());
}