Query Syntax

[bleonard]

I might be a good idea to take a in an object (key value pairs) for querying instead of having people put together a string.

It would work for single parameter queries. If there are multiple it would assume AND -- these seems to be the most common case.

Notes;

• allow empty query or null to be no filters
• auto escape strings and such
• ideally on a string or int column, i should be able to give an array - this would translate to an IN query if it was MySQL. ActiveRecord does this and I think it's super useful.

[bleonard]

fwiw so far

var makeQuery = function(queryHash) {
  var keys = Object.getOwnPropertyNames(queryHash);
  if (Object.getOwnPropertySymbols) {
    keys = keys.concat(Object.getOwnPropertySymbols(queryHash));
  }

  var out = "";
  for (var i=0; i<keys.length; i++) {
    var key = keys[i];
    if (i > 0) out += " AND ";
    out += key + " = ";
    if ((typeof queryHash[key]) === 'number') {
      out += queryHash[key];
    }
    else {
      // TODO: how to escape? so far only ascii ids, so it's ok
      out += "'" + queryHash[key] + "'";
    }
  }
  if (out.length === 0) return null;
  return out;
};

[bleonard]

what does a null query like realm.object('TodoItem', null) do?

[alazier]

realm.objects('TodoItem') gets all TodoItems. If you pass null for the query we will throw an exception as currently the second argument must be a string. If you want a query that will return all results you can use realm.objects("TodoItem", "truepredicate") and add build your string up from there.

[bleonard]

ok, i'll return "truepredicate" instead of null