abstract class QueryBuilder::Criteria(T)

• QueryBuilder::Criteria(T)
• Reference
• Object

Direct Known Subclasses

• QueryBuilder::AndCriteria(T)
• QueryBuilder::BasicCriteria(T)
• QueryBuilder::BetweenCriteria(T)
• QueryBuilder::ExistsCriteria(T)
• QueryBuilder::InCriteria(T)
• QueryBuilder::OrCriteria(T)
• QueryBuilder::ValueBetweenCriteria(T)

Defined in:

criteria/criteria.cr

Class Method Summary

• .between(column : String, min_value : T, max_value : T)

  Between

• .between(column : Projection, min_value : T, max_value : T)
• .contains(column : String, value : String)
• .contains(column : Projection, value : String)
• .ends_with(column : String, value : String)
• .ends_with(column : Projection, value : String)
• .equals(column : String, value : T)
• .equals(left_column : Projection, right_column : Projection)
• .equals(column : Projection, value : T)
• .exists(subquery : SqlBuilder)

  Exists

• .greater_than(column : String, value : T)
• .greater_than(column : Projection, value : T)
• .greater_than_or_equals(column : String, value : T)
• .greater_than_or_equals(column : Projection, value : T)
• .in(column : String, values : Array(T))

  In

• .in(column : Projection, values : Array(T))
• .is_not_null(column : String)
• .is_not_null(column : Projection)
• .is_null(column : String)

  Null

• .is_null(column : Projection)
• .lesser_than(column : String, value : T)
• .lesser_than(column : Projection, value : T)
• .lesser_than_or_equals(column : String, value : T)
• .lesser_than_or_equals(column : Projection, value : T)
• .not

  Basic criterias

• .parse(stm : String) : Criteria(T)
• .starts_with(column : String, value : String)

  String only criterias

• .starts_with(column : Projection, value : String)
• .value_between(column_min : String, column_max : String, value : T)
• .value_between(column_min : Projection, column_max : Projection, value : T)

Instance Method Summary

• #and(criteria : Criteria)

  Logic chains

• #build : String
• #or(criteria : Criteria)
• #params : Array(T)

Class Method Detail

Instance Method Detail