Function buildDatabaseFilter

frontend/src/react/stores/app/utils.ts:101–139

(filter: DatabaseFilter)

// `DatabaseFilter`. Mirrors the legacy Pinia `getListDatabaseFilter` so the
// app store lists databases identically to the old store.
export function buildDatabaseFilter(filter: DatabaseFilter): string {
  const params: string[] = [];
  if (isValidProjectName(filter.project)) {
    params.push(`project == "${filter.project}"`);
  }
  if (isValidInstanceName(filter.instance)) {
    params.push(`instance == "${filter.instance}"`);
  }
  if (filter.environment === unknownEnvironment().name) {
    params.push(`environment == ""`);
  } else if (isValidEnvironmentName(filter.environment)) {
    params.push(`environment == "${filter.environment}"`);
  }
  if (filter.excludeUnassigned) {
    params.push(`exclude_unassigned == true`);
  }
  if (filter.engines && filter.engines.length > 0) {
    params.push(
      `engine in [${filter.engines.map((e) => `"${Engine[e]}"`).join(", ")}]`
    );
  } else if (filter.excludeEngines && filter.excludeEngines.length > 0) {
    params.push(
      `!(engine in [${filter.excludeEngines
        .map((e) => `"${Engine[e]}"`)
        .join(", ")}])`
    );
  }
  const keyword = filter.query?.trim()?.toLowerCase();
  if (keyword) {
    params.push(`name.contains("${keyword}")`);
  }
  if (filter.labels) {
    params.push(...getLabelFilter(filter.labels));
  }
  if (filter.table) {
    params.push(`table.contains("${filter.table}")`);
  }
  return params.join(" && ");
}

function bindingMemberToNames(member: string): string[] {
  if (member === "allUsers" || member === "user:allUsers") {