The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { useMutation, useQueryClient } from '@tanstack/react-query'
import type { QueryKey } from '@tanstack/react-query'
import { toast } from 'sonner'
import type { ContentData } from './content-query'
import { contentKeys } from './keys'
import { del, handleError } from '@/data/fetchers'
import type { ResponseError, UseCustomMutationOptions } from '@/types'
type DeleteContentVariables = { projectRef: string; ids: string[] }
type DeleteContext = { snapshots: [QueryKey, ContentData | undefined][] }
export async function deleteContents(
{ projectRef, ids }: DeleteContentVariables,
signal?: AbortSignal,
headersInit?: HeadersInit
) {
const headers = new Headers(headersInit)
headers.set('Version', '2')
const { data, error } = await del('/platform/projects/{ref}/content', {
headers,
params: {
path: { ref: projectRef },
query: { ids: ids.join(',') },
},
signal,
})
if (error) handleError(error)
return data.map((x) => x.id)
}
type DeleteContentData = Awaited<ReturnType<typeof deleteContents>>
/** Returns a copy of a cached content list with the given ids removed. Exported for testing. */
export function removeContentFromList(data: ContentData, ids: string[]): ContentData {
return { ...data, content: data.content.filter((item) => !ids.includes(item.id)) }
}
export const useContentDeleteMutation = ({
onSuccess,
onError,
...options
}: Omit<
UseCustomMutationOptions<DeleteContentData, ResponseError, DeleteContentVariables, DeleteContext>,
'mutationFn'
> = {}) => {
const queryClient = useQueryClient()
return useMutation<DeleteContentData, ResponseError, DeleteContentVariables, DeleteContext>({
mutationFn: (args) => deleteContents(args),
async onMutate({ projectRef, ids }) {
await queryClient.cancelQueries({ queryKey: contentKeys.allContentLists(projectRef) })
const snapshots = queryClient.getQueriesData<ContentData>({
queryKey: contentKeys.allContentLists(projectRef),
})
// allContentLists is a prefix of sibling caches (sql snippets, folders, counts) that
// don't share the { content: [...] } shape, so only optimistically update entries that do.
for (const [queryKey, data] of snapshots) {
if (data && Array.isArray(data.content)) {
queryClient.setQueryData<ContentData>(queryKey, removeContentFromList(data, ids))
}
}
return { snapshots }
},
async onSuccess(data, variables, context) {
const { projectRef } = variables
await Promise.all([
queryClient.invalidateQueries({ queryKey: contentKeys.allContentLists(projectRef) }),
queryClient.invalidateQueries({ queryKey: contentKeys.infiniteList(projectRef) }),
])
await onSuccess?.(data, variables, context)
},
async onError(error, variables, context) {
// Restore the snapshots captured in onMutate before surfacing the error.
if (context?.snapshots) {
for (const [queryKey, data] of context.snapshots) {
queryClient.setQueryData(queryKey, data)
}
}
if (onError === undefined) {
toast.error(`Failed to delete contents: ${error.message}`)
} else {
onError(error, variables, context)
}
},
...options,
})
}