The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import pgMeta from '@supabase/pg-meta'
import type { SafeSqlFragment } from '@supabase/pg-meta'
import { useMutation, useQueryClient } from '@tanstack/react-query'
import { toast } from 'sonner'
import { databasePoliciesKeys } from './keys'
import { executeSql } from '@/data/sql/execute-sql-mutation'
import type { ResponseError, UseCustomMutationOptions } from '@/types'
export type DatabasePolicyUpdateVariables = {
projectRef: string
connectionString?: string | null
originalPolicy: {
id: number
name: string
schema: string
table: string
}
payload: {
name?: string
definition?: SafeSqlFragment
check?: SafeSqlFragment
roles?: string[]
}
}
export async function updateDatabasePolicy({
projectRef,
connectionString,
originalPolicy,
payload,
}: DatabasePolicyUpdateVariables) {
let headers = new Headers()
if (connectionString) headers.set('x-connection-encrypted', connectionString)
const { sql } = pgMeta.policies.update(originalPolicy, payload)
const { result } = await executeSql({
projectRef,
connectionString,
sql,
queryKey: ['policy', 'update', originalPolicy.id],
})
return result
}
type DatabasePolicyUpdateData = Awaited<ReturnType<typeof updateDatabasePolicy>>
export const useDatabasePolicyUpdateMutation = ({
onSuccess,
onError,
...options
}: Omit<
UseCustomMutationOptions<DatabasePolicyUpdateData, ResponseError, DatabasePolicyUpdateVariables>,
'mutationFn'
> = {}) => {
const queryClient = useQueryClient()
return useMutation<DatabasePolicyUpdateData, ResponseError, DatabasePolicyUpdateVariables>({
mutationFn: (vars) => updateDatabasePolicy(vars),
async onSuccess(data, variables, context) {
const { projectRef } = variables
await queryClient.invalidateQueries({ queryKey: databasePoliciesKeys.list(projectRef) })
await onSuccess?.(data, variables, context)
},
async onError(data, variables, context) {
if (onError === undefined) {
toast.error(`Failed to update database policy: ${data.message}`)
} else {
onError(data, variables, context)
}
},
...options,
})
}