/// <summary>
/// Initializes a new instance of the <see cref="WhereClause" /> class.
/// </summary>
/// <param name="builder">The builder.</param>
/// <param name="column">The field.</param>
/// <param name="compareOperator">The compare operator.</param>
/// <param name="compareValue">The compare value.</param>
public WhereClause(ISelectStringBuilder builder, string column, ComparisonOperator compareOperator, object compareValue)
{
this.builder = builder;
ColumnName = column;
Operator = compareOperator;
Value = compareValue;
}
/// <summary>
/// Initializes a new instance of the <see cref="JoinClause" /> struct.
/// </summary>
/// <param name="builder">The builder.</param>
/// <param name="joinType">Type of the join.</param>
/// <param name="toTableName">Name of to table.</param>
/// <param name="toColumnName">Name of to column.</param>
/// <param name="operator">The operator.</param>
/// <param name="fromTableName">Name of from table.</param>
/// <param name="fromColumnName">Name of from column.</param>
public JoinClause(ISelectStringBuilder builder, JoinType joinType, string toTableName, string toColumnName,
ComparisonOperator @operator,
string fromTableName, string fromColumnName) : this(builder, joinType, toTableName)
{
FromTable = fromTableName;
FromColumn = fromColumnName;
ComparisonOperator = @operator;
ToColumn = toColumnName;
}
private static string BuildSelectString(MessageQuery messageQuery, ISelectStringBuilder ssb)
{
ssb.SelectAll().From(TableName);
if (messageQuery.Id != null)
{
ssb.Where("content_id").EqualsTo(messageQuery.Id);
}
if (messageQuery.CreatedStartDate != null)
{
ssb.Where("created_at").GreaterOrEqualsTo(messageQuery.CreatedStartDate);
}
if (messageQuery.CreatedEndDate != null)
{
ssb.Where("created_at").LessOrEqualsTo(messageQuery.CreatedEndDate);
}
if (messageQuery.ContentType != null)
{
ssb.Where("content_type").EqualsTo(messageQuery.ContentType);
}
if (messageQuery.ErrorType != null)
{
ssb.Where("error_type").EqualsTo(messageQuery.ErrorType);
}
if (messageQuery.Status != null)
{
ssb.Where("status").EqualsTo(messageQuery.Status);
}
if (messageQuery.Type != null)
{
ssb.Where("type").EqualsTo(messageQuery.Type);
}
if (messageQuery.ExecutionDurationAbove != null)
{
ssb.Where("execution_duration").GreaterOrEqualsTo(messageQuery.ExecutionDurationAbove);
}
if (messageQuery.ExecutionDurationBelow != null)
{
ssb.Where("execution_duration").LessOrEqualsTo(messageQuery.ExecutionDurationBelow);
}
if (messageQuery.Skip > 0)
{
ssb.Skip(messageQuery.Skip);
}
if (messageQuery.Take > 0)
{
ssb.Take(messageQuery.Take);
}
return(ssb.Build());
}
/// <summary>
/// Initializes a new instance of the <see cref="JoinClause"/> class.
/// </summary>
/// <param name="builder">The builder.</param>
/// <param name="joinType">Type of the join.</param>
/// <param name="toTableName">Name of to table.</param>
public JoinClause(ISelectStringBuilder builder, JoinType joinType, string toTableName)
{
this.builder = builder;
JoinType = joinType;
ToTable = toTableName;
}
/// <summary>
/// Initializes a new instance of the <see cref="WhereClause" /> struct.
/// </summary>
/// <param name="builder">The builder.</param>
/// <param name="column">The column.</param>
public WhereClause(ISelectStringBuilder builder, string column) : this(builder, column, ComparisonOperator.NotSet, null)
{
}
