The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { zodResolver } from '@hookform/resolvers/zod'
import { useParams } from 'common'
import { PlusIcon, XIcon } from 'lucide-react'
import { useState } from 'react'
import { Control, SubmitHandler, useFieldArray, useForm, useWatch } from 'react-hook-form'
import { toast } from 'sonner'
import {
Button,
DialogSectionSeparator,
Form,
FormControl,
FormField,
FormInputGroupInput,
Input,
InputGroup,
InputGroupAddon,
Select,
SelectContent,
SelectItem,
SelectSeparator,
SelectTrigger,
SelectValue,
Sheet,
SheetContent,
SheetFooter,
SheetHeader,
SheetSection,
SheetTitle,
} from 'ui'
import { FormItemLayout } from 'ui-patterns/form/FormItemLayout/FormItemLayout'
import { z } from 'zod'
import { COLUMN_TYPE_FIELDS, COLUMN_TYPES } from './CreateTableSheet.constants'
import { createFormSchema } from './CreateTableSheet.schema'
import { useIcebergNamespaceCreateMutation } from '@/data/storage/iceberg-namespace-create-mutation'
import {
NamespaceTableFields,
useIcebergNamespaceTableCreateMutation,
} from '@/data/storage/iceberg-namespace-table-create-mutation'
import { useIcebergNamespaceTablesQuery } from '@/data/storage/iceberg-namespace-tables-query'
import { useIcebergNamespacesQuery } from '@/data/storage/iceberg-namespaces-query'
const formId = 'create-namespace-table'
const NEW_NAMESPACE_MARKER = 'new-namespace'
type CreateTableFormValues = z.infer<ReturnType<typeof createFormSchema>>
interface CreateTableSheetProps {
open: boolean
onOpenChange: (value: boolean) => void
}
export const CreateTableSheet = ({ open, onOpenChange }: CreateTableSheetProps) => {
const { ref: projectRef, bucketId } = useParams()
const [isCreating, setIsCreating] = useState(false)
const FormSchema = createFormSchema()
const defaultValues: CreateTableFormValues = {
namespace: '',
newNamespace: undefined,
name: '',
columns: [{ name: '', type: 'string' }],
}
const form = useForm<z.infer<typeof FormSchema>>({
resolver: zodResolver(FormSchema),
defaultValues,
mode: 'onChange',
})
const namespace = useWatch({ control: form.control, name: 'namespace' })
const {
fields: columns,
append: appendColumn,
remove: removeColumn,
} = useFieldArray({ control: form.control, name: 'columns' })
const { data: namespaces = [] } = useIcebergNamespacesQuery({ projectRef, warehouse: bucketId })
const { data: tables = [] } = useIcebergNamespaceTablesQuery(
{
projectRef,
warehouse: bucketId,
namespace,
},
{ enabled: namespace !== NEW_NAMESPACE_MARKER }
)
const { mutateAsync: createNamespace } = useIcebergNamespaceCreateMutation()
const { mutateAsync: createTable } = useIcebergNamespaceTableCreateMutation()
const onSubmit: SubmitHandler<z.infer<typeof FormSchema>> = async (values) => {
if (!bucketId) return console.error('Bucket ID is missing')
if (namespaces.includes(values.newNamespace ?? '')) {
return form.setError('newNamespace', { message: 'Namespace name already exists' })
}
if (tables.includes(values.name ?? '')) {
return form.setError('name', { message: 'Table name already exists' })
}
const isCreatingNewNamespace =
values.namespace === NEW_NAMESPACE_MARKER && !!values.newNamespace
try {
setIsCreating(true)
if (isCreatingNewNamespace) {
await createNamespace({
projectRef,
warehouse: bucketId,
namespace: values.newNamespace as string,
})
}
const fields = values.columns.map((column, idx) => {
return {
id: idx + 1,
name: column.name,
type:
column.type === 'decimal'
? `decimal(${column.precision}, ${column.scale})`
: column.type === 'fixed'
? `fixed[${column.length}]`
: column.type,
required: false,
}
}) as NamespaceTableFields
await createTable({
projectRef,
warehouse: bucketId,
namespace: isCreatingNewNamespace ? (values.newNamespace as string) : values.namespace,
name: values.name,
fields,
})
toast.success(`Successfully created table in ${values.newNamespace ?? values.namespace}!`)
onOpenChange(false)
form.reset(defaultValues)
} catch (error) {
} finally {
setIsCreating(false)
}
}
return (
<Sheet open={open} onOpenChange={onOpenChange}>
<Form {...form}>
<form id={formId} className="flex flex-col gap-4" onSubmit={form.handleSubmit(onSubmit)}>
<SheetContent aria-describedby={undefined} className="flex flex-col gap-0">
<SheetHeader className="shrink-0 flex items-center gap-4">
<SheetTitle>Create a new table</SheetTitle>
</SheetHeader>
<SheetSection className="overflow-auto grow p-0">
<div className="flex flex-col gap-y-4 py-4 px-5">
<FormField
name="namespace"
control={form.control}
render={({ field }) => (
<FormItemLayout
name="namespace"
label="Select a namespace to create your table in"
>
<FormControl>
<Select
value={field.value}
onValueChange={(value) => {
field.onChange(value)
form.resetField('newNamespace')
}}
>
<SelectTrigger>
<SelectValue placeholder="Select a namespace" />
</SelectTrigger>
<SelectContent>
{namespaces.map((x) => (
<SelectItem key={x} value={x}>
{x}
</SelectItem>
))}
{namespaces.length > 0 && <SelectSeparator />}
<SelectItem value={NEW_NAMESPACE_MARKER}>
<div className="flex items-center gap-x-2">
<PlusIcon size={14} />
<p>Create a new namespace</p>
</div>
</SelectItem>
</SelectContent>
</Select>
</FormControl>
</FormItemLayout>
)}
/>
{namespace === NEW_NAMESPACE_MARKER && (
<FormField
name="newNamespace"
control={form.control}
render={({ field }) => (
<FormItemLayout label="Name of new namespace">
<FormControl>
<Input {...field} placeholder="Provide a name for your new namespace" />
</FormControl>
</FormItemLayout>
)}
/>
)}
</div>
<DialogSectionSeparator />
{!!namespace && (
<div className="px-5 py-4 flex flex-col gap-y-4">
<FormField
name="name"
control={form.control}
render={({ field }) => (
<FormItemLayout label="Name of table">
<FormControl>
<Input {...field} placeholder="Provide a name for your new table" />
</FormControl>
</FormItemLayout>
)}
/>
<div className="flex flex-col gap-y-2">
<div className="flex items-center justify-between">
<p className="text-sm">Columns</p>
<Button
icon={<PlusIcon />}
onClick={() => appendColumn({ name: '', type: 'string' })}
>
Add column
</Button>
</div>
{columns.length === 0 ? (
<div className="flex items-center justify-center rounded-sm border border-strong border-dashed py-4 text-foreground-lighter text-sm">
Add a column to your table
</div>
) : (
<>
<div className="grid grid-cols-[1fr_1fr_32px]">
<p className="text-xs text-foreground-lighter">Name</p>
<p className="text-xs text-foreground-lighter">Type</p>
</div>
{columns.map((column, idx) => (
<ColumnRow
key={column.id}
control={form.control}
idx={idx}
isCreating={isCreating}
onRemove={() => removeColumn(idx)}
/>
))}
</>
)}
</div>
</div>
)}
</SheetSection>
<SheetFooter>
<Button
disabled={isCreating}
onClick={() => {
onOpenChange(false)
form.reset(defaultValues)
}}
>
Cancel
</Button>
<Button variant="primary" form={formId} type="submit" loading={isCreating}>
Create table
</Button>
</SheetFooter>
</SheetContent>
</form>
</Form>
</Sheet>
)
}
interface ColumnRowProps {
control: Control<CreateTableFormValues>
idx: number
isCreating: boolean
onRemove: () => void
}
const ColumnRow = ({ control, idx, isCreating, onRemove }: ColumnRowProps) => {
const columnType = useWatch({ control, name: `columns.${idx}.type` })
const additionalFields = COLUMN_TYPE_FIELDS[columnType] ?? []
return (
<div className="grid grid-cols-[1fr_1fr_32px] gap-x-1">
<FormField
control={control}
name={`columns.${idx}.name`}
render={({ field }) => (
<FormItemLayout>
<FormControl>
<Input
{...field}
placeholder="Provide a column name"
disabled={isCreating}
className="h-auto"
/>
</FormControl>
</FormItemLayout>
)}
/>
<FormField
control={control}
name={`columns.${idx}.type`}
render={({ field }) => (
<FormControl>
<Select value={field.value} onValueChange={field.onChange}>
<SelectTrigger className="h-auto">
<SelectValue placeholder="Select a type" />
</SelectTrigger>
<SelectContent>
{COLUMN_TYPES.map((x) => (
<SelectItem key={x} value={x}>
{x}
</SelectItem>
))}
</SelectContent>
</Select>
</FormControl>
)}
/>
<div className="flex items-center justify-center">
<Button
aria-label="Remove"
variant="text"
size="tiny"
icon={<XIcon strokeWidth={1.5} size={14} />}
className="w-6 h-6"
onClick={onRemove}
/>
</div>
{additionalFields.length > 0 && (
<div className="col-span-full flex items-center mt-2">
<div className="flex items-center justify-end gap-1 w-[85%] ">
{additionalFields.map((x) => (
<FormField
control={control}
key={`columns.${idx}.${x.name}`}
name={`columns.${idx}.${x.name}`}
render={({ field }) => (
<FormItemLayout>
<FormControl>
<InputGroup>
<InputGroupAddon align="inline-start">{x.name}</InputGroupAddon>
<FormInputGroupInput
{...field}
type={x.type === 'number' ? 'number' : 'text'}
disabled={isCreating}
className="h-[34px] rounded-l-none"
onChange={(event) =>
field.onChange(
isNaN(event.target.valueAsNumber) ? null : event.target.valueAsNumber
)
}
/>
</InputGroup>
</FormControl>
</FormItemLayout>
)}
/>
))}
</div>
<div className="w-4 h-[1.6rem] border-r border-b rounded-br mr-3 border-control -translate-y-3" />
</div>
)}
</div>
)
}