filter method

String filter(String expr, [ Map<String, dynamic> query = const {} ])

Constructs a filter expression with placeholders populated from a map.

Placeholder parameters are defined with the {:paramName} notation.

The following parameter values are supported:

• String
• num
• bool
• DateTime
• null
• everything else is converted to a string using jsonEncode()

Example:

pb.collection("example").getList(filter: pb.filter(
  "title ~ {:title} && created >= {:created}",
  { "title": "example", "created": DateTime.now() },
));

Implementation

String filter(String expr, [Map<String, dynamic> query = const {}]) {
  if (query.isEmpty) {
    return expr;
  }

  query.forEach((key, value) {
    if (value == null || value is num || value is bool) {
      value = value.toString();
    } else if (value is DateTime) {
      value =
          jsonEncode(value.toUtc().toIso8601String().replaceFirst("T", " "));
    } else if (value is String) {
      value = jsonEncode(value);
    } else {
      final stringified = jsonEncode(value);
      if (stringified.startsWith("[") || stringified.startsWith("{")) {
        value = jsonEncode(stringified);
      } else {
        value = stringified;
      }
    }
    expr = expr.replaceAll("{:$key}", value.toString());
  });

  return expr;
}