Chain Supabase Insert(s)

Nin · 2022-09-29T21:53:03.992Z

Wondering if I can chain a Supabase insert, for example: Insert into table x Select newly inserted row Insert into table y with id of newly inserted row And if so, how would a JS function look like?

N

NinOP•9/29/22, 9:56 PM

I thought since Supabase is a promise I could chain a .finally to it but it appears that's not working

N

NinOP•9/29/22, 10:00 PM

Think I figured it out!

N

NinOP•9/29/22, 10:01 PM

await supabase
      .from("timetable")
      .insert(scheduleEntries)
      .select()
      .then((result) => {
        console.log(result);
      });

await supabase
      .from("timetable")
      .insert(scheduleEntries)
      .select()
      .then((result) => {
        console.log(result);
      });

await supabase
      .from("timetable")
      .insert(scheduleEntries)
      .select()
      .then((result) => {
        console.log(result);
      });

await supabase
      .from("timetable")
      .insert(scheduleEntries)
      .select()
      .then((result) => {
        console.log(result);
      });

This works

N

NinOP•9/29/22, 10:01 PM

const { data, error } = await supabase
      .from("timetable")
      .insert(scheduleEntries)
      .select()
      .then((data) => {
        console.log(data);
      });

const { data, error } = await supabase
      .from("timetable")
      .insert(scheduleEntries)
      .select()
      .then((data) => {
        console.log(data);
      });

const { data, error } = await supabase
      .from("timetable")
      .insert(scheduleEntries)
      .select()
      .then((data) => {
        console.log(data);
      });

const { data, error } = await supabase
      .from("timetable")
      .insert(scheduleEntries)
      .select()
      .then((data) => {
        console.log(data);
      });

this was my first attempt and didn't work

G

garyaustin•9/29/22, 10:03 PM

You can also use an rpc call so they are also run as a transaction so if either insert fails, they both fail. And you only have one API call overhead.

You would use insert returning in sql to get the id for the first inserted row, to use in the next insert call.

Otherwise a postgres google would find you the two insert code in SQL.

N

NinOP•9/29/22, 10:05 PM

Uff, I've not worked with those RPCs yet but will take that into consideration

G

garyaustin•9/29/22, 10:07 PM

You can easily do with two calls in the client, you just need to handle error cases for each insert as appropriate. In particular if the 2nd insert fails do you need to delete the first insert or not.

N

NinOP•9/29/22, 10:09 PM

Yeah makes sense, thanks for helping out Gary!

Chain Supabase Insert(s)

Similar Threads

Similar Threads

Similar Threads