Insert data ( supabase)
One script reply has been approved by the moderators Verified

Created by adam186 63 days ago Viewed 83 times 0 Points

No comments yet

Login to be able to comment
Points: 0
deno
One script reply has been approved by the moderators
Ap­pro­ved
import { Resource } from "https://deno.land/x/windmill@v1.70.1/mod.ts";
import { createClient } from "https://esm.sh/@supabase/supabase-js@2";

/**
 * @param count Count algorithm to use to count rows in the table or view.
 * `"exact"`: Exact but slow count algorithm. Performs a `COUNT(*)` under the hood.
 * `"planned"`: Approximated but fast count algorithm. Uses the Postgres statistics under the hood.
 * `"estimated"`: Uses exact count for low numbers and planned count for high numbers.
 */
export async function main(
  auth: Resource<"supabase">,
  table: string,
  values: Record<string, any> | Record<string, any>[],
  returnInserted: boolean = false,
  count?: "exact" | "planned" | "estimated",
) {
  const client = createClient(auth.url, auth.key);

  let query: any = client.from(table).insert(values, { count });
  if (returnInserted) {
    query = query.select();
  }

  return await query;
}

Submitted by adam186 63 days ago

Edited 13 days ago

No comments yet

Login to be able to comment