import { useEffect } from 'react' import { ControllerRenderProps, UseFormReturn } from 'react-hook-form' import type { CloudProvider } from 'shared-data' import { Badge, Select_Shadcn_, SelectContent_Shadcn_, SelectGroup_Shadcn_, SelectItem_Shadcn_, SelectTrigger_Shadcn_, SelectValue_Shadcn_, } from 'ui' import { FormItemLayout } from 'ui-patterns/form/FormItemLayout/FormItemLayout' import { smartRegionToExactRegion } from './ProjectCreation.utils' import { useProjectCreationPostgresVersionsQuery } from '@/data/config/project-creation-postgres-versions-query' import { useProjectUnpausePostgresVersionsQuery } from '@/data/config/project-unpause-postgres-versions-query' import { PostgresEngine, ReleaseChannel } from '@/data/projects/new-project.constants' import { useSelectedProjectQuery } from '@/hooks/misc/useSelectedProject' interface PostgresVersionDetails { postgresEngine?: Exclude releaseChannel?: ReleaseChannel } interface PostgresVersionSelectorProps { cloudProvider: CloudProvider dbRegion: string organizationSlug?: string field: ControllerRenderProps form: UseFormReturn type?: 'create' | 'unpause' layout?: 'vertical' | 'horizontal' label?: string } const formatValue = ({ postgres_engine, release_channel, }: { postgres_engine: string release_channel: string }) => { return `${postgres_engine}|${release_channel}` } export const extractPostgresVersionDetails = (value: string): PostgresVersionDetails => { if (!value) { return { postgresEngine: undefined, releaseChannel: undefined } } const [postgresEngine, releaseChannel] = value.split('|') return { postgresEngine, releaseChannel } as PostgresVersionDetails } export const PostgresVersionSelector = ({ cloudProvider, dbRegion, organizationSlug, field, form, type = 'create', layout = 'horizontal', label = 'Postgres version', }: PostgresVersionSelectorProps) => { const { data: project } = useSelectedProjectQuery() const dbRegionExact = smartRegionToExactRegion(dbRegion) const { data: createVersions, isPending: isLoadingProjectCreateVersions, isSuccess, } = useProjectCreationPostgresVersionsQuery( { cloudProvider, dbRegion: dbRegionExact, organizationSlug, }, { enabled: type === 'create' } ) const { data: unpauseVersions, isPending: isLoadingProjectUnpauseVersions } = useProjectUnpausePostgresVersionsQuery( { projectRef: project?.ref }, { enabled: type === 'unpause' } ) const versions = type === 'create' ? (createVersions?.available_versions ?? []) : (unpauseVersions?.available_versions ?? []) const availableVersions = versions.sort((a, b) => a.version.localeCompare(b.version)).reverse() const { postgresVersionSelection } = form.watch() useEffect(() => { if (availableVersions.length > 0) { const gaVersion = availableVersions.find((x) => x.release_channel === 'ga') const defaultValue = gaVersion ? formatValue(gaVersion) : formatValue(availableVersions[0]) form.setValue('postgresVersionSelection', defaultValue) } }, [isSuccess, availableVersions, form]) return ( {availableVersions.map((value) => { const postgresVersion = value.version .split('supabase-postgres-')[1] .replace('-orioledb', '') return (
{postgresVersion}
{value.release_channel !== 'ga' && ( {value.release_channel} )} {value.postgres_engine.includes('oriole') && ( OrioleDB )}
) })}
) }