Files
supabase/apps/studio/data/vault/vault-secret-create-mutation.ts
Joshen Lim 1baaded0bb Consolidate execute-sql-query into execute-sql-mutation (#46944)
## Context

Just some clean up as I was going through stuff
- `useExecuteSqlQuery` is deprecated and not used at all
- As such `execute-sql-query` is technically irrelevant, the more
relevant file is `execute-sql-mutation`
- Hence opting to consolidate `execute-sql-query` into
`execute-sql-mutation`
- Also removing `ExecuteSqlError` since its just re-exporting the
`ResponseError` type

There's a lot of file changes but its essentially just updating the
importing statements across the files
2026-06-16 00:07:16 +08:00

57 lines
1.8 KiB
TypeScript

import { getCreateVaultSecretSQL } from '@supabase/pg-meta'
import { useMutation, useQueryClient } from '@tanstack/react-query'
import { toast } from 'sonner'
import { vaultSecretsKeys } from './keys'
import { executeSql } from '@/data/sql/execute-sql-mutation'
import type { ResponseError, UseCustomMutationOptions, VaultSecret } from '@/types'
export type VaultSecretCreateVariables = {
projectRef: string
connectionString?: string | null
} & Partial<VaultSecret>
export async function createVaultSecret({
projectRef,
connectionString,
...newSecret
}: VaultSecretCreateVariables) {
const { name, description, secret } = newSecret
if (!secret) throw new Error('Secret value is required')
const sql = getCreateVaultSecretSQL({ secret, name, description })
const { result } = await executeSql({ projectRef, connectionString, sql })
return result
}
type VaultSecretCreateData = Awaited<ReturnType<typeof createVaultSecret>>
export const useVaultSecretCreateMutation = ({
onError,
onSuccess,
...options
}: Omit<
UseCustomMutationOptions<VaultSecretCreateData, ResponseError, VaultSecretCreateVariables>,
'mutationFn'
> = {}) => {
const queryClient = useQueryClient()
return useMutation<VaultSecretCreateData, ResponseError, VaultSecretCreateVariables>({
mutationFn: (vars) => createVaultSecret(vars),
async onSuccess(data, variables, context) {
const { projectRef } = variables
await queryClient.invalidateQueries({ queryKey: vaultSecretsKeys.list(projectRef) })
await onSuccess?.(data, variables, context)
},
async onError(data, variables, context) {
if (onError === undefined) {
toast.error(`Failed to create secret: ${data.message}`)
} else {
onError(data, variables, context)
}
},
...options,
})
}