Skip to content

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

2.3 KB
Raw Blame
import { useParams } from 'common'
import { SqlEditor } from 'icons'
import Link from 'next/link'
import {
  Button,
  cn,
  Dialog,
  DialogContent,
  DialogFooter,
  DialogHeader,
  DialogSection,
  DialogSectionSeparator,
  DialogTitle,
  DialogTrigger,
} from 'ui'
import { CodeBlock } from 'ui-patterns/CodeBlock'

import { DocsButton } from '@/components/ui/DocsButton'
import { FDWTable } from '@/data/fdw/fdws-query'
import { DOCS_URL } from '@/lib/constants'

interface InsertDataDialogProps {
  table: string
  fdwTable: FDWTable
}

export const InsertDataDialog = ({ table, fdwTable }: InsertDataDialogProps) => {
  const { ref } = useParams()

  const sql = /* SQL */ `
insert into ${fdwTable.schema}.${fdwTable.name} (
  -- specify columns
)
values (
  -- specify values for each column
);
`.trim()

  return (
    <Dialog>
      <DialogTrigger asChild>
        <Button>Insert data</Button>
      </DialogTrigger>
      <DialogContent aria-describedby={undefined}>
        <DialogHeader>
          <DialogTitle>
            Insert data into <code>{table}</code>
          </DialogTitle>
        </DialogHeader>

        <DialogSectionSeparator />

        <DialogSection className="flex flex-col gap-y-2">
          <p className="text-sm">
            The Iceberg Foreign Data Wrapper (FDW) supports inserting data into Iceberg tables using
            standard SQL <code>INSERT</code> statements.
          </p>
          <p className="text-sm">
            Use the following SQL snippet to insert data into your iceberg table:
          </p>
        </DialogSection>

        <DialogSectionSeparator />

        <DialogSection className="p-0!">
          <CodeBlock
            hideLineNumbers
            wrapperClassName={cn('[&_pre]:px-4 [&_pre]:py-3 [&>pre]:rounded-none [&>pre]:border-0')}
            className="[&_code]:text-foreground"
            language="sql"
            value={sql}
          />
        </DialogSection>

        <DialogFooter>
          <DocsButton
            href={`${DOCS_URL}/guides/database/extensions/wrappers/iceberg#data-insertion`}
          />
          <Button asChild icon={<SqlEditor />}>
            <Link href={`/project/${ref}/sql/new?content=${encodeURIComponent(sql)}`}>
              Open in SQL Editor
            </Link>
          </Button>
        </DialogFooter>
      </DialogContent>
    </Dialog>
  )
}