public Query Where(Where where, bool clearWhereList)
{
if (_ListWhere == null) _ListWhere = new WhereList();
if (clearWhereList) _ListWhere.Clear();
_ListWhere.Add(where);
return this;
}
public Query AddWhere(Where where)
{
return Where(where, false);
}
public Query OR(string columnName, object betweenValue, object andValue)
{
Where where = new Where(WhereCondition.OR, columnName, ValueObjectType.ColumnName, betweenValue, ValueObjectType.Value, andValue, ValueObjectType.Value);
return Where(where, false);
}
public static Round Round(Where where)
{
return new Round(where);
}
public Query AND(string tableName, string columnName, object betweenValue, object andValue)
{
Where where = new Where(WhereCondition.AND, columnName, ValueObjectType.ColumnName, betweenValue, ValueObjectType.Value, andValue, ValueObjectType.Value);
where.FirstTableName = tableName;
return Where(where, false);
}
public static JsonExtract JsonExtract(Where where, string path = "$")
{
return new JsonExtract(where, path);
}
public static RandWeight RandWeight(Where where)
{
return new RandWeight(where);
}
public Query Having(WhereCondition condition, string tableName, string columnName, object betweenValue, object andValue)
{
Where where = new Where(condition, columnName, ValueObjectType.ColumnName, betweenValue, ValueObjectType.Value, andValue, ValueObjectType.Value);
where.FirstTableName = tableName;
return Having(where);
}
public Query Having(Where where)
{
if (_ListHaving == null) _ListHaving = new WhereList();
_ListHaving.Add(where);
return this;
}
public static ValueWrapper From(Where where)
{
return new ValueWrapper(where);
}
public ValueWrapper(Where where)
{
this.TableName = null;
this.Value = where;
this.Type = ValueObjectType.Value;
}
/// <summary>
/// Adds a where condition. Does not remove any existing conditions.
/// </summary>
/// <param name="where"></param>
/// <returns>Current <typeparamref name="Query"/> object</returns>
public Query Where(Where where)
{
if (_ListWhere == null) _ListWhere = new WhereList();
_ListWhere.Add(where);
return this;
}