The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { useDebounce } from '@uidotdev/usehooks'
import { useParams } from 'common'
import { HomeIcon, PlusIcon } from 'lucide-react'
import { useState } from 'react'
import {
Command,
CommandGroup,
CommandInput,
CommandItem,
CommandList,
DropdownMenuCheckboxItem,
DropdownMenuPortal,
DropdownMenuSub,
DropdownMenuSubContent,
DropdownMenuSubTrigger,
SQL_ICON,
} from 'ui'
import { ShimmeringLoader } from 'ui-patterns/ShimmeringLoader'
import { BURSTABLE_IO_METRIC_KEYS, DEPRECATED_REPORTS } from './Reports.constants'
import { hasBurstableIO } from '@/components/interfaces/DiskManagement/DiskManagement.utils'
import { SIDEBAR_KEYS } from '@/components/layouts/ProjectLayout/LayoutSidebar/LayoutSidebarProvider'
import { useContentQuery } from '@/data/content/content-query'
import { useIsFeatureEnabled } from '@/hooks/misc/useIsFeatureEnabled'
import { useSelectedProjectQuery } from '@/hooks/misc/useSelectedProject'
import { Metric, METRIC_CATEGORIES, METRICS } from '@/lib/constants/metrics'
import { useTrack } from '@/lib/telemetry/track'
import { editorPanelState } from '@/state/editor-panel-state'
import { useSidebarManagerSnapshot } from '@/state/sidebar-manager-state'
import type { Dashboards } from '@/types'
interface MetricOptionsProps {
config?: Dashboards.Content
handleChartSelection: ({
metric,
isAddingChart,
}: {
metric: Metric
isAddingChart: boolean
}) => void
}
export const MetricOptions = ({ config, handleChartSelection }: MetricOptionsProps) => {
const { ref: projectRef } = useParams()
const { data: project } = useSelectedProjectQuery()
const { openSidebar } = useSidebarManagerSnapshot()
const [search, setSearch] = useState('')
const { projectAuthAll: authEnabled, projectStorageAll: storageEnabled } = useIsFeatureEnabled([
'project_auth:all',
'project_storage:all',
])
const supportsBurstableIO = hasBurstableIO(project?.infra_compute_size)
const metricCategories = Object.values(METRIC_CATEGORIES).filter(({ key }) => {
if (key === 'api_auth') return authEnabled
if (key === 'api_storage') return storageEnabled
return true
})
const track = useTrack()
const debouncedSearch = useDebounce(search, 300)
const {
data,
isPending: isLoading,
refetch,
} = useContentQuery({
projectRef,
type: 'sql',
name: debouncedSearch.length === 0 ? undefined : debouncedSearch,
})
const snippets = data?.content
return (
<>
{metricCategories.map((cat) => {
return (
<DropdownMenuSub key={cat.key}>
<DropdownMenuSubTrigger className="space-x-2">
{cat.icon ? cat.icon() : <HomeIcon size={14} />}
<p>{cat.label}</p>
</DropdownMenuSubTrigger>
<DropdownMenuPortal>
<DropdownMenuSubContent>
{METRICS.filter(
(metric) =>
!DEPRECATED_REPORTS.includes(metric.key) &&
metric?.category?.key === cat.key &&
(supportsBurstableIO || !BURSTABLE_IO_METRIC_KEYS.includes(metric.key))
).map((metric) => {
return (
<DropdownMenuCheckboxItem
key={metric.key}
className="cursor-pointer"
checked={config?.layout?.some((x: any) => x.attribute === metric.key)}
onCheckedChange={(e) => handleChartSelection({ metric, isAddingChart: e })}
>
<div className="flex flex-col space-y-0">
<span>{metric.label}</span>
</div>
</DropdownMenuCheckboxItem>
)
})}
</DropdownMenuSubContent>
</DropdownMenuPortal>
</DropdownMenuSub>
)
})}
<DropdownMenuSub
onOpenChange={(open) => {
if (open) refetch()
}}
>
<DropdownMenuSubTrigger className="space-x-2">
<SQL_ICON
size={14}
strokeWidth={1.5}
className="fill-foreground-light w-5 h-4 shrink-0 grow-0 -ml-0.5"
/>
<p>SQL Snippets</p>
</DropdownMenuSubTrigger>
<DropdownMenuPortal>
<DropdownMenuSubContent className="p-0">
<Command shouldFilter={false}>
<CommandInput
autoFocus
placeholder="Search snippets..."
value={search}
onValueChange={setSearch}
/>
<CommandList>
{isLoading ? (
<div className="flex flex-col p-1 gap-y-1">
<ShimmeringLoader />
<ShimmeringLoader className="w-3/4" />
</div>
) : !snippets?.length ? (
<p className="text-xs text-center text-foreground-lighter py-3">
No snippets found
</p>
) : null}
<CommandGroup>
{snippets?.map((snippet) => (
<CommandItem
key={snippet.id}
value={snippet.id}
className="cursor-pointer"
onSelect={() => {
if (!config?.layout.find((x) => x.id === snippet.id)) {
handleChartSelection({
metric: {
id: snippet.id,
key: `snippet_${snippet.id}`,
label: snippet.name,
},
isAddingChart: true,
})
track('custom_report_add_sql_block_clicked')
}
}}
>
{snippet.name}
</CommandItem>
))}
</CommandGroup>
</CommandList>
<div className="h-px bg-border-overlay -mx-1" />
<CommandGroup>
<CommandItem
className="cursor-pointer w-full"
onSelect={() => {
editorPanelState.openAsNew()
openSidebar(SIDEBAR_KEYS.EDITOR_PANEL)
}}
>
<div className="w-full flex items-center gap-2">
<PlusIcon size={14} strokeWidth={1.5} />
<p>Create snippet</p>
</div>
</CommandItem>
</CommandGroup>
</Command>
</DropdownMenuSubContent>
</DropdownMenuPortal>
</DropdownMenuSub>
</>
)
}