1 // Copyright (C) The Arvados Authors. All rights reserved.
3 // SPDX-License-Identifier: AGPL-3.0
5 import * as _ from "lodash";
7 export function joinFilters(filters0?: string, filters1?: string) {
8 return [filters0, filters1].filter(s => s).join(",");
11 export class FilterBuilder {
12 constructor(private filters = "") { }
14 public addEqual(field: string, value?: string, resourcePrefix?: string) {
15 return this.addCondition(field, "=", value, "", "", resourcePrefix );
18 public addLike(field: string, value?: string, resourcePrefix?: string) {
19 return this.addCondition(field, "like", value, "%", "%", resourcePrefix);
22 public addILike(field: string, value?: string, resourcePrefix?: string) {
23 return this.addCondition(field, "ilike", value, "%", "%", resourcePrefix);
26 public addIsA(field: string, value?: string | string[], resourcePrefix?: string) {
27 return this.addCondition(field, "is_a", value, "", "", resourcePrefix);
30 public addIn(field: string, value?: string | string[], resourcePrefix?: string) {
31 return this.addCondition(field, "in", value, "", "", resourcePrefix);
38 private addCondition(field: string, cond: string, value?: string | string[], prefix: string = "", postfix: string = "", resourcePrefix?: string) {
40 value = typeof value === "string"
41 ? `"${prefix}${value}${postfix}"`
42 : `["${value.join(`","`)}"]`;
44 const resPrefix = resourcePrefix
45 ? _.snakeCase(resourcePrefix) + "."
48 this.filters += `${this.filters ? "," : ""}["${resPrefix}${_.snakeCase(field)}","${cond}",${value}]`;