The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { useParams } from 'common'
import { includes, sortBy } from 'lodash'
import {
CheckIcon,
CopyIcon,
Edit2Icon,
EditIcon,
MoreVerticalIcon,
TrashIcon,
XIcon,
} from 'lucide-react'
import Link from 'next/link'
import { parseAsJson, parseAsString, useQueryState } from 'nuqs'
import {
Badge,
Button,
DropdownMenu,
DropdownMenuContent,
DropdownMenuItem,
DropdownMenuSeparator,
DropdownMenuTrigger,
TableCell,
TableRow,
Tooltip,
TooltipContent,
TooltipTrigger,
} from 'ui'
import {
generateTriggerCreateSQL,
getDatabaseFunctionsHref,
type PostgresTrigger,
} from './TriggerList.utils'
import { selectFilterSchema } from '@/components/interfaces/Reports/v2/ReportsSelectFilter'
import { SIDEBAR_KEYS } from '@/components/layouts/ProjectLayout/LayoutSidebar/LayoutSidebarProvider'
import { ButtonTooltip } from '@/components/ui/ButtonTooltip'
import { TableRowNoResults } from '@/components/ui/TableRowNoResults'
import { useDatabaseTriggersQuery } from '@/data/database-triggers/database-triggers-query'
import { FGA_PERMISSIONS, useAsyncCheckPermissionsV2 } from '@/hooks/misc/useCheckPermissionsV2'
import { useQuerySchemaState } from '@/hooks/misc/useSchemaQueryState'
import { useSelectedProjectQuery } from '@/hooks/misc/useSelectedProject'
import { useIsProtectedSchema } from '@/hooks/useProtectedSchemas'
import { useAiAssistantStateSnapshot } from '@/state/ai-assistant-state'
import { useSidebarManagerSnapshot } from '@/state/sidebar-manager-state'
interface TriggerListProps {
editTrigger: (trigger: PostgresTrigger) => void
duplicateTrigger: (trigger: PostgresTrigger) => void
deleteTrigger: (trigger: PostgresTrigger) => void
}
export const TriggerList = ({ editTrigger, duplicateTrigger, deleteTrigger }: TriggerListProps) => {
const { ref: projectRef } = useParams()
const { data: project } = useSelectedProjectQuery()
const aiSnap = useAiAssistantStateSnapshot()
const { openSidebar } = useSidebarManagerSnapshot()
const { can: canUpdateTriggers } = useAsyncCheckPermissionsV2(
FGA_PERMISSIONS.PROJECT.DATABASE_WRITE
)
const { selectedSchema: schema } = useQuerySchemaState()
const { isSchemaLocked: isLocked } = useIsProtectedSchema({ schema })
const [filterString] = useQueryState('search', parseAsString.withDefault(''))
const [tablesFilter] = useQueryState(
'tables',
parseAsJson(selectFilterSchema.parse).withDefault([])
)
const { data: triggers } = useDatabaseTriggersQuery({
projectRef: project?.ref,
connectionString: project?.connectionString,
})
const filteredTriggers = (triggers ?? []).filter((x) => {
const search = filterString?.toLowerCase()
const matchesSearch =
!search ||
x.name.toLowerCase().includes(search) ||
(!!x.function_name && includes(x.function_name.toLowerCase(), search))
const matchesTables = !tablesFilter?.length || tablesFilter.includes(x.table)
return matchesSearch && matchesTables
})
const _triggers = sortBy(
filteredTriggers.filter((x) => x.schema == schema),
(trigger) => trigger.name.toLocaleLowerCase()
)
if (_triggers.length === 0 && filterString.length === 0) {
return (
<TableRow key={schema}>
<TableCell colSpan={7}>
<p className="text-sm text-foreground">No triggers created yet</p>
<p className="text-sm text-foreground-light">
There are no triggers found in the schema "{schema}"
</p>
</TableCell>
</TableRow>
)
}
if (_triggers.length === 0 && filterString.length > 0) {
return <TableRowNoResults key={schema} colSpan={7} search={filterString} />
}
return (
<>
{_triggers.map((x) => (
<TableRow key={x.id}>
<TableCell className="space-x-2">
<Button
variant="text"
disabled={isLocked || !canUpdateTriggers}
onClick={() => editTrigger(x)}
title={x.name}
className="text-link-table-cell text-left text-sm disabled:opacity-90 disabled:no-underline min-w-0 p-0 hover:bg-transparent font-medium max-w-48 title"
>
{x.name}
</Button>
</TableCell>
<TableCell className="break-all">
{x.table_id ? (
<Link
href={`/project/${projectRef}/editor/${x.table_id}`}
className="text-link-table-cell block max-w-40 text-foreground-light"
>
{x.table}
</Link>
) : (
<p title={x.table} className="truncate">
{x.table}
</p>
)}
</TableCell>
<TableCell className="space-x-2">
{x.function_name ? (
<Link
href={getDatabaseFunctionsHref(projectRef, x.function_schema, x.function_name)}
className="text-link-table-cell block max-w-40 text-foreground-light"
>
{x.function_name}
</Link>
) : (
<p className="truncate text-foreground-light">-</p>
)}
</TableCell>
<TableCell>
<div className="flex gap-2 flex-wrap">
{x.events.map((event: string) => (
<Badge key={event}>{`${x.activation} ${event}`}</Badge>
))}
</div>
</TableCell>
<TableCell className="space-x-2">
<p title={x.orientation} className="truncate">
{x.orientation}
</p>
</TableCell>
<TableCell>
<div className="flex items-center justify-center">
{x.enabled_mode !== 'DISABLED' ? (
<CheckIcon strokeWidth={2} className="text-primary" />
) : (
<XIcon strokeWidth={2} />
)}
</div>
</TableCell>
<TableCell className="text-right">
{!isLocked && (
<div className="flex items-center justify-end">
{canUpdateTriggers ? (
<DropdownMenu>
<Tooltip>
<TooltipTrigger asChild>
<DropdownMenuTrigger asChild>
<Button
aria-label={`${x.function_name} actions`}
className="px-1"
icon={<MoreVerticalIcon />}
/>
</DropdownMenuTrigger>
</TooltipTrigger>
<TooltipContent side="bottom">More options</TooltipContent>
</Tooltip>
<DropdownMenuContent side="bottom" align="end" className="w-52">
<DropdownMenuItem
className="space-x-2"
onClick={() => {
editTrigger(x)
}}
>
<Edit2Icon size={14} />
<p>Edit trigger</p>
</DropdownMenuItem>
<DropdownMenuItem
className="space-x-2"
onClick={() => {
const sql = generateTriggerCreateSQL(x)
openSidebar(SIDEBAR_KEYS.AI_ASSISTANT)
aiSnap.newChat({
name: `Update trigger ${x.name}`,
initialInput: `Update this trigger which exists on the ${x.schema}.${x.table} table to...`,
suggestions: {
title:
'I can help you make a change to this trigger, here are a few example prompts to get you started:',
prompts: [
{
label: 'Rename Trigger',
description: 'Rename this trigger to ...',
},
{
label: 'Change Events',
description: 'Change the events this trigger responds to ...',
},
{
label: 'Modify Timing',
description:
'Modify this trigger to run after instead of before ...',
},
],
},
sqlSnippets: [sql],
})
}}
>
<EditIcon size={14} />
<p>Edit with Assistant</p>
</DropdownMenuItem>
<DropdownMenuItem className="space-x-2" onClick={() => duplicateTrigger(x)}>
<CopyIcon size={14} />
<p>Duplicate trigger</p>
</DropdownMenuItem>
<DropdownMenuSeparator />
<DropdownMenuItem className="space-x-2" onClick={() => deleteTrigger(x)}>
<TrashIcon stroke="red" size={14} />
<p>Delete trigger</p>
</DropdownMenuItem>
</DropdownMenuContent>
</DropdownMenu>
) : (
<ButtonTooltip
disabled
className="px-1"
icon={<MoreVerticalIcon />}
tooltip={{
content: {
side: 'bottom',
text: 'You need additional permissions to update triggers',
},
}}
/>
)}
</div>
)}
</TableCell>
</TableRow>
))}
</>
)
}