Delete rows in supabase

BenajaEphrath · 2024-07-25T06:53:24.216+00:00

I have followed a similar post but unfortunately I can't get any further. https://discord.com/channels/972416966683926538/1265353107752222720/1265353107752222720I have the following goal: From the tutorial https://youtu.be/SHJ3EadcrgY?si=o1xRI347kmt9VuE0 the possibility to delete individual Task-entries via a button.So this is what i have:

BenajaEphrath
1 year ago
I have followed a similar post but unfortunately I can't get any further. https://discord.com/channels/972416966683926538/1265353107752222720/1265353107752222720

I have the following goal: From the tutorial https://youtu.be/SHJ3EadcrgY?si=o1xRI347kmt9VuE0 the possibility to delete individual Task-entries via a button.

So this is what i have:
BenajaEphrath
1 year ago
I think I'm doing something wrong with the variable or with the click event. I am grateful for any tips. I understood the query, but as I said, nothing happens when I activate the delete button...
Tod
1 year ago
Great energy @BenajaEphrath! Your continuous contribution to the toddle Community just made you advance to Community Level 3!
Lucas G
1 year ago
If you set RLS policies on the table, does it allow delete?
Though it's weird that there is no feedback from supabase on it
BenajaEphrath
1 year ago
Yes:
Lucas G
1 year ago
Try setting the header
Name: Prefer
Value: return=representation
And see if you get any feedback
BenajaEphrath
1 year ago
Like this? Nothing happens
Lucas G
1 year ago
RIght, you would see something when you make the call
BenajaEphrath
1 year ago
Nothing happens
BenajaEphrath
1 year ago
Lol this is weird. When i check the left check/uncheck button it deletes
Not sure if i can post here a screencast lets see...
https://app.screencast.com/tExP6Ik8CmmjG
Lucas G
1 year ago
It seems like it is actually deleting it but you might not be seeing it right away because the list is repeating straight from the API call instead of from a variable?
🫣1
BenajaEphrath
1 year ago
So when i click the delete button nothing happens. But when i click first the delete button, and AFTER that the check/uncheck it gets deleted
Lucas G
1 year ago
Also I just realized that a return=representation wouldn't make sense on deletes lol 😅 early in the morning 😬
😅1
@Lucas G
It seems like it is actually deleting it but you might not be seeing it right away because the list is repeating straight from the API call instead of from a variable?
BenajaEphrath
1 year ago
Hm, but my click event first fires the variable...
Max
1 year ago
It looks like in your list you are repeating directly over the results from the API. In this scenario, you need to refetch the list after the delete. So call the get data API again. Otherwise you delete it in the backend but you won't see the change in the frontend. I'm guessing that after the check you fetch the data again?
😶1
BenajaEphrath
1 year ago
So now it works. 🔥🔥🍹👋 I set in my Click Event -> on success -> fetch the data

Is this correct? Or is there an better way to do this?
@BenajaEphrath
So now it works. 🔥🔥🍹👋 I set in my Click Event -> on success -> fetch the data

Is this correct? Or is there an better way to do this?
Max
1 year ago
That is fine. It's a question of philosophy. You could also not repeat the list over the actual api result, but store the api result in a variable and repeat over that. Then you could update the variable (list of tasks) directly after success without refetching. Both versions work and are valid
BenajaEphrath
1 year ago
@Max thanks AGAIN! So helpful!!
💪1

Delete rows in supabase

BenajaEphrath

BenajaEphrath

Tod

Lucas G

BenajaEphrath

Lucas G

BenajaEphrath

Lucas G

BenajaEphrath

BenajaEphrath

Lucas G

BenajaEphrath

Lucas G

BenajaEphrath

Max

BenajaEphrath

Max

BenajaEphrath