Hi! I get an error trying to bulk upsert in to the...
# helpj
jbergius
09/19/2021, 10:42 AMHi! I get an error trying to bulk upsert in to the following table.
Error message says: All object keys must match
The array I'm trying to upsert looks like this:
Copy code
[
{
id: 'si_KFtDgimqIKkY6q',
subscription_id: 'sub_1JbNQoEXkCyWFmfFwTxz6Ewu',
user_id: '8f6cb53b-4a97-4297-a722-727cb2e6f335'
},
{
id: 'si_KFtDSFw9pGCr6G',
subscription_id: 'sub_1JbNQoEXkCyWFmfFwTxz6Ewu',
user_id: '8f6cb53b-4a97-4297-a722-727cb2e6f335'
}
]jbergius
09/19/2021, 10:54 AMThe upsert is happening directly after i created the subscription, which is referenced to with subscription_id.
Is it maybe a race condition? That the subscription hasen't been inserted into the db yet? The code looks like this:
Copy code
const { data: subData, error: subError } = await supabaseAdmin
.from('subscriptions')
.upsert([subscriptionData]);
const { data: subItemsData, error: subItemsError } = await supabaseAdmin
.from('subscription_items')
.insert([subscriptionItemsData]);jbergius
09/19/2021, 11:17 AMBut that dosen't make sense either. Because if i make a select from the subscriptions table, just before I'm trying to insert the subscription_items, I can see that the subscription has been created and should be able to make a reference to.
s
stibbs
09/19/2021, 11:46 AMI’m not sure, but could this be a row level security thing? Your schema has RLS enabled and is blocking everything except for SELECT queries where the user_id matches
j
jbergius
09/19/2021, 11:54 AMShouldn’t be that because I’m calling it from server side code and using the service key and not the anon key 🙄
jbergius
09/19/2021, 5:23 PMAnyone else got a clue? 😟
jbergius
09/19/2021, 6:47 PMgash I'm stupid 🤦🏻♂️ I was passing in ([array]) instead of (array) in to the .upsert-function. Now it's working as excepted