Function upsert

packages/core/fumadb/src/query/orm/index.ts:427–447

(name, { where, ...options })

      return await internal.count(table, { where: constrainedWhere });
    },
    async upsert(name, { where, ...options }) {
      const table = toTable(name);
      const conditions = where ? buildCondition(table.columns, where) : undefined;
      if (conditions === false) return;
      let compiledWhere: Condition | undefined | false = conditions === true ? undefined : conditions;

      compiledWhere = await applyUpdatePolicies(
        table,
        compiledWhere,
        options.update,
        context,
        "upsert",
        options.create,
      );
      if (compiledWhere === false) return;
      await runCreatePolicies(table, options.create, context);
      await internal.upsert(table, {
        where: compiledWhere,
        ...options,
      });
    },
    async upsertMany(name, { target, update, values }) {
      const table = toTable(name);
      if (values.length === 0) return;