Function likeToRegExp

showcase/harness/src/fleet/queue-client.test.ts:150–168

* Convert a PB `~`/`!~` LIKE pattern into an anchored RegExp, faithful to * PocketBase 0.22's semantics: the SQL is built as `LIKE ... ESCAPE '\'` * (pocketbase tools/search/filter.go), so a `\`-escaped `%`/`_` is a LITERAL * character while unescaped `%`/`_` are wildcards. The fakes must honor t

(pattern: string)

 * just the least-surprising fallback, not a verified PB contract.
 */
function likeToRegExp(pattern: string): RegExp {
  const escapeRegExp = (ch: string): string =>
    ch.replace(/[.*+?^${}()|[\]\\]/g, "\\$&");
  let out = "";
  for (let i = 0; i < pattern.length; i++) {
    const ch = pattern[i];
    if (ch === "\\" && i + 1 < pattern.length) {
      out += escapeRegExp(pattern[i + 1]);
      i += 1;
    } else if (ch === "%") {
      out += ".*";
    } else if (ch === "_") {
      out += ".";
    } else {
      out += escapeRegExp(ch);
    }
  }
  return new RegExp(`^${out}$`);
}

/** The row shape the shared filter matcher evaluates. */
interface FilterableRow {