Function statement

packages/infra/src/Store/Cosmos/query.ts:65–146

(x: FilterR, i: number)

  limit?: number
) {
  const statement = (x: FilterR, i: number) => {
    if (x.path === idKey) {
      x = { ...x, path: "id" }
    }
    let k = x.path.includes(".-1.")
      ? dottedToAccess(`${x.path.split(".-1.")[0]}.${x.path.split(".-1.")[1]!}`)
      : x.path.endsWith(".length")
      ? `ARRAY_LENGTH(${dottedToAccess(`f.${x.path.split(".length")[0]}`)})`
      : dottedToAccess(`f.${x.path}`)

    // would have to map id, but shouldnt allow id in defaultValues anyway..
    k = x.path in defaultValues ? `(${k} ?? ${JSON.stringify(defaultValues[x.path])})` : k

    const v = "@v" + i

    switch (x.op) {
      case "in":
        return `ARRAY_CONTAINS(${v}, ${k})`
      case "notIn":
        return `(NOT ARRAY_CONTAINS(${v}, ${k}))`

      case "includes":
        return `ARRAY_CONTAINS(${k}, ${v})`
      case "notIncludes":
        return `(NOT ARRAY_CONTAINS(${k}, ${v}))`

      case "includes-any":
        return `ARRAY_CONTAINS_ANY(${k}, ${
          (x.value as unknown as readonly unknown[]).map((_, i) => `${v}__${i}`).join(", ")
        })`
      case "notIncludes-any":
        return `(NOT ARRAY_CONTAINS_ANY(${k}, ${
          (x.value as unknown as readonly unknown[]).map((_, i) => `${v}__${i}`).join(", ")
        }))`

      case "includes-all":
        return `ARRAY_CONTAINS_ALL(${k}, ${
          (x.value as unknown as readonly unknown[]).map((_, i) => `${v}__${i}`).join(", ")
        })`
      case "notIncludes-all":
        return `(NOT ARRAY_CONTAINS_ALL(${k}, ${
          (x.value as unknown as readonly unknown[]).map((_, i) => `${v}__${i}`).join(", ")
        }))`

      case "contains":
        return `CONTAINS(${k}, ${v}, true)`

      case "startsWith":
        return `STARTSWITH(${k}, ${v}, true)`
      case "endsWith":
        return `ENDSWITH(${k}, ${v}, true)`
      case "notContains":
        return `NOT(CONTAINS(${k}, ${v}, true))`
      case "notStartsWith":
        return `NOT(STARTSWITH(${k}, ${v}, true))`
      case "notEndsWith":
        return `NOT(ENDSWITH(${k}, ${v}, true))`
    }