//
// SPDX-License-Identifier: AGPL-3.0
-import * as _ from "lodash";
-
-export function joinFilters(filters0?: string, filters1?: string) {
- return [filters0, filters1].filter(s => s).join(",");
+export function joinFilters(...filters: string[]) {
+ return filters.filter(s => s).join(",");
}
export class FilterBuilder {
return this.addCondition(field, "=", value, "", "", resourcePrefix);
}
+ public addDistinct(field: string, value?: string | boolean | null, resourcePrefix?: string) {
+ return this.addCondition(field, "!=", value, "", "", resourcePrefix);
+ }
+
public addLike(field: string, value?: string, resourcePrefix?: string) {
return this.addCondition(field, "like", value, "%", "%", resourcePrefix);
}
return this.addCondition(field, "ilike", value, "%", "%", resourcePrefix);
}
+ public addContains(field: string, value?: string, resourcePrefix?: string) {
+ return this.addCondition(field, "contains", value, "", "", resourcePrefix);
+ }
+
public addIsA(field: string, value?: string | string[], resourcePrefix?: string) {
return this.addCondition(field, "is_a", value, "", "", resourcePrefix);
}
public addExists(value?: string, resourcePrefix?: string) {
return this.addCondition("properties", "exists", value, "", "", resourcePrefix);
}
+ public addDoesNotExist(field: string, resourcePrefix?: string) {
+ return this.addCondition("properties." + field, "exists", false, "", "", resourcePrefix);
+ }
public addFullTextSearch(value: string) {
- // Filter construction implementation taken from
- // https://dev.arvados.org/projects/arvados/repository/entry/apps/workbench/app/assets/javascripts/filterable.js
- // https://dev.arvados.org/projects/arvados/repository/entry/apps/workbench/app/assets/javascripts/to_tsquery.js
- return this.addCondition('any', '@@', value.replace(/[^-\w\.\/]+/g, ' ').trim().replace(/ /g, ':*&'));
+ const terms = value.trim().split(/(\s+)/);
+ terms.forEach(term => {
+ if (term !== " ") {
+ this.addCondition("any", "ilike", term, "%", "%");
+ }
+ });
+ return this;
}
public getFilters() {
? resourcePrefix + "."
: "";
- const fld = field.indexOf('properties.') < 0 ? _.snakeCase(field) : field;
-
- this.filters += `${this.filters ? "," : ""}["${resPrefix}${fld}","${cond}",${value}]`;
+ this.filters += `${this.filters ? "," : ""}["${resPrefix}${field}","${cond}",${value}]`;
}
return this;
}