The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import pgMeta, { type PGTrigger } from '@supabase/pg-meta'
import { useQuery } from '@tanstack/react-query'
import { executeSql } from '../sql/execute-sql-mutation'
import { databaseTriggerKeys } from './keys'
import type { PostgresTrigger } from '@/components/interfaces/Database/Triggers/TriggersList/TriggerList.utils'
import type { ResponseError, UseCustomQueryOptions } from '@/types'
function markSavedTriggerSafe(trigger: DatabaseTriggersData[number]): PostgresTrigger {
return trigger as PostgresTrigger
}
export type DatabaseTriggersVariables = {
projectRef?: string
connectionString?: string | null
schemas?: string[]
}
export async function getDatabaseTriggers(
{ projectRef, connectionString, schemas }: DatabaseTriggersVariables,
signal?: AbortSignal
) {
if (!projectRef) throw new Error('projectRef is required')
const { sql } = pgMeta.triggers.list({ includedSchemas: schemas })
const { result } = await executeSql(
{
projectRef,
connectionString,
sql,
queryKey: ['triggers'],
},
signal
)
return result as PGTrigger[]
}
export type DatabaseTriggersData = Awaited<ReturnType<typeof getDatabaseTriggers>>
export type DatabaseTriggersError = ResponseError
export const useDatabaseHooksQuery = <TData = DatabaseTriggersData>(
{ projectRef, connectionString, schemas }: DatabaseTriggersVariables,
{
enabled = true,
...options
}: UseCustomQueryOptions<DatabaseTriggersData, DatabaseTriggersError, TData> = {}
) =>
useQuery<DatabaseTriggersData, DatabaseTriggersError, TData>({
queryKey: databaseTriggerKeys.list(projectRef, schemas),
queryFn: ({ signal }) => getDatabaseTriggers({ projectRef, connectionString }, signal),
select: (data) => {
return data.filter((trigger) => {
return (
trigger.function_schema === 'supabase_functions' &&
(trigger.schema !== 'net' || trigger.function_args.length === 0)
)
}) as any
},
enabled: enabled && typeof projectRef !== 'undefined',
...options,
})
export const useDatabaseTriggersQuery = <TData = PostgresTrigger[]>(
{ projectRef, connectionString }: DatabaseTriggersVariables,
{
enabled = true,
...options
}: UseCustomQueryOptions<PostgresTrigger[], DatabaseTriggersError, TData> = {}
) =>
useQuery<PostgresTrigger[], DatabaseTriggersError, TData>({
queryKey: databaseTriggerKeys.list(projectRef),
queryFn: ({ signal }) =>
getDatabaseTriggers({ projectRef, connectionString }, signal).then((data) =>
data.map(markSavedTriggerSafe)
),
enabled: enabled && typeof projectRef !== 'undefined',
...options,
})