orWhere method

QueryBuilder orWhere(
  1. String column,
  2. dynamic value, [
  3. dynamic operator
])

Add an "or where" clause to the query.

If operator is not null, then value becomes operator and the operator becomes value.

  queryBuilder.where('id', 1).orWhere('name', 'Cals');
  queryBuilder.where('id', '=', 1).orWhere('name', '=', 'Cals');

When operator is null means the default operator is equal.

Implementation

QueryBuilder orWhere(String column, dynamic value, [dynamic operator]) {
  String clause = '$column = $value';
  if (value.runtimeType == String) {
    clause = "$column = '$value'";
  }
  if (operator != null) {
    clause = "$column $value $operator";
    if (operator.runtimeType == String) {
      clause = "$column $value '$operator'";
    }
  }
  if (_where == "") {
    _where = clause;
  } else {
    _where = "$_where OR $clause";
  }
  return this;
}