X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/f5c0cb11102a006cda59711f29458b7569b9a21f..a5cc3b71b39f304f15c03b175e541b5adf4541f7:/src/services/api/filter-builder.ts diff --git a/src/services/api/filter-builder.ts b/src/services/api/filter-builder.ts index b5558dbb16..e899234109 100644 --- a/src/services/api/filter-builder.ts +++ b/src/services/api/filter-builder.ts @@ -11,8 +11,8 @@ export function joinFilters(filters0?: string, filters1?: string) { export class FilterBuilder { constructor(private filters = "") { } - public addEqual(field: string, value?: string, resourcePrefix?: string) { - return this.addCondition(field, "=", value, "", "", resourcePrefix ); + public addEqual(field: string, value?: string | boolean | null, resourcePrefix?: string) { + return this.addCondition(field, "=", value, "", "", resourcePrefix); } public addLike(field: string, value?: string, resourcePrefix?: string) { @@ -31,21 +31,58 @@ export class FilterBuilder { return this.addCondition(field, "in", value, "", "", resourcePrefix); } + public addNotIn(field: string, value?: string | string[], resourcePrefix?: string) { + return this.addCondition(field, "not in", value, "", "", resourcePrefix); + } + + public addGt(field: string, value?: string, resourcePrefix?: string) { + return this.addCondition(field, ">", value, "", "", resourcePrefix); + } + + public addGte(field: string, value?: string, resourcePrefix?: string) { + return this.addCondition(field, ">=", value, "", "", resourcePrefix); + } + + public addLt(field: string, value?: string, resourcePrefix?: string) { + return this.addCondition(field, "<", value, "", "", resourcePrefix); + } + + public addLte(field: string, value?: string, resourcePrefix?: string) { + return this.addCondition(field, "<=", value, "", "", resourcePrefix); + } + + public addExists(value?: string, resourcePrefix?: string) { + return this.addCondition("properties", "exists", value, "", "", 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, ':*&')); + } + public getFilters() { return this.filters; } - private addCondition(field: string, cond: string, value?: string | string[], prefix: string = "", postfix: string = "", resourcePrefix?: string) { - if (value) { - value = typeof value === "string" - ? `"${prefix}${value}${postfix}"` - : `["${value.join(`","`)}"]`; + private addCondition(field: string, cond: string, value?: string | string[] | boolean | null, prefix: string = "", postfix: string = "", resourcePrefix?: string) { + if (value !== undefined) { + if (typeof value === "string") { + value = `"${prefix}${value}${postfix}"`; + } else if (Array.isArray(value)) { + value = `["${value.join(`","`)}"]`; + } else if (value !== null) { + value = value ? "true" : "false"; + } const resPrefix = resourcePrefix - ? _.snakeCase(resourcePrefix) + "." + ? resourcePrefix + "." : ""; - this.filters += `${this.filters ? "," : ""}["${resPrefix}${_.snakeCase(field)}","${cond}",${value}]`; + const fld = field.indexOf('properties.') < 0 ? _.snakeCase(field) : field; + + this.filters += `${this.filters ? "," : ""}["${resPrefix}${fld}","${cond}",${value}]`; } return this; }