Skip to content

The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.

6.1 KB
Raw Blame
import { zodResolver } from '@hookform/resolvers/zod'
import { useParams } from 'common'
import { useState } from 'react'
import { SubmitHandler, useForm } from 'react-hook-form'
import { toast } from 'sonner'
import {
  Button,
  Dialog,
  DialogContent,
  DialogFooter,
  DialogHeader,
  DialogSection,
  DialogSectionSeparator,
  DialogTitle,
  DialogTrigger,
  Form,
  FormField,
  Select,
  SelectContent,
  SelectItem,
  SelectTrigger,
  SelectValue,
  Tooltip,
  TooltipContent,
  TooltipTrigger,
} from 'ui'
import { FormItemLayout } from 'ui-patterns/form/FormItemLayout/FormItemLayout'
import z from 'zod'

import { getAnalyticsBucketFDWServerName } from './AnalyticsBucketDetails.utils'
import { useAnalyticsBucketAssociatedEntities } from './useAnalyticsBucketAssociatedEntities'
import { DocsButton } from '@/components/ui/DocsButton'
import { InlineLinkClassName } from '@/components/ui/InlineLink'
import { useFDWImportForeignSchemaMutation } from '@/data/fdw/fdw-import-foreign-schema-mutation'
import { useSelectedProjectQuery } from '@/hooks/misc/useSelectedProject'
import { DOCS_URL } from '@/lib/constants'

export const UpdateForeignSchemaDialog = ({
  namespace,
  tables,
}: {
  namespace: string
  tables: string[]
}) => {
  const { ref: projectRef, bucketId } = useParams()
  const { data: project } = useSelectedProjectQuery()

  const [isOpen, setIsOpen] = useState(false)

  const { icebergWrapper } = useAnalyticsBucketAssociatedEntities({ bucketId })
  const connectedForeignTablesForNamespace = (icebergWrapper?.tables ?? []).filter((x) =>
    x.options[0].startsWith(`table=${namespace}.`)
  )
  const schemasAssociatedWithNamespace = [
    ...new Set(connectedForeignTablesForNamespace.map((x) => x.schema)),
  ]

  const serverName = getAnalyticsBucketFDWServerName(bucketId ?? '')

  const FormSchema = z.object({
    schema: z.string().trim().min(1, 'Schema name is required'),
  })
  const form = useForm<z.infer<typeof FormSchema>>({
    resolver: zodResolver(FormSchema),
    defaultValues: { schema: schemasAssociatedWithNamespace[0] },
    values: { schema: schemasAssociatedWithNamespace[0] },
  })

  const { mutateAsync: importForeignSchema, isPending: isUpdating } =
    useFDWImportForeignSchemaMutation()

  const onSubmit: SubmitHandler<z.infer<typeof FormSchema>> = async (values) => {
    if (!projectRef) return console.error('Project ref is required')

    try {
      await importForeignSchema({
        projectRef,
        connectionString: project?.connectionString,
        serverName: serverName,
        sourceSchema: namespace,
        targetSchema: values.schema,
      })

      toast.success(`Successfully updated "${values.schema}" schema!`)
      setIsOpen(false)
    } catch (error: any) {
      toast.error(`Failed to update schema: ${error.message}`)
    }
  }

  return (
    <Dialog open={isOpen} onOpenChange={setIsOpen}>
      <DialogTrigger asChild>
        <Button>Update schema tables</Button>
      </DialogTrigger>
      <DialogContent size="medium" aria-describedby={undefined}>
        <Form {...form}>
          <form onSubmit={form.handleSubmit(onSubmit)}>
            <DialogHeader>
              <DialogTitle>Update schema to expose foreign tables</DialogTitle>
            </DialogHeader>
            <DialogSectionSeparator />
            <DialogSection className="flex flex-col gap-y-4">
              <p className="text-sm">
                {tables.length > 1 ? (
                  <>
                    There are{' '}
                    <Tooltip>
                      <TooltipTrigger>
                        <span className={InlineLinkClassName}>{tables.length} tables</span>
                      </TooltipTrigger>
                      <TooltipContent className="max-w-64 text-center" side="bottom">
                        {tables.join(', ')}
                      </TooltipContent>
                    </Tooltip>{' '}
                    that aren't included in the Iceberg Foreign Data Wrapper. Update the wrapper to
                    create foreign tables for all unexposed tables. This will let you query the
                    tables from Postgres.
                  </>
                ) : (
                  `The table "${tables[0]}" in the "${namespace}" namespace is not yet included in the Iceberg Foreign Data Wrapper. The schema can be updated to expose this table as a foreign table.`
                )}
              </p>

              {schemasAssociatedWithNamespace.length > 1 ? (
                <FormField
                  control={form.control}
                  name="schema"
                  render={({ field }) => (
                    <FormItemLayout
                      layout="vertical"
                      label="Select which Postgres schema to update"
                    >
                      <Select value={field.value} onValueChange={(val) => field.onChange(val)}>
                        <SelectTrigger>
                          <SelectValue />
                        </SelectTrigger>
                        <SelectContent>
                          {schemasAssociatedWithNamespace.map((x) => (
                            <SelectItem key={x} value={x}>
                              {x}
                            </SelectItem>
                          ))}
                        </SelectContent>
                      </Select>
                    </FormItemLayout>
                  )}
                />
              ) : (
                <p className="text-sm">
                  Confirm to update foreign schema on the "{namespace}" namespace?
                </p>
              )}
            </DialogSection>
            <DialogFooter className="justify-between!">
              <DocsButton href={`${DOCS_URL}/guides/storage/analytics/query-with-postgres`} />
              <div className="flex items-center gap-x-2">
                <Button disabled={isUpdating} onClick={() => setIsOpen(false)}>
                  Cancel
                </Button>
                <Button type="submit" variant="primary" loading={isUpdating}>
                  Update schema
                </Button>
              </div>
            </DialogFooter>
          </form>
        </Form>
      </DialogContent>
    </Dialog>
  )
}