import { zodResolver } from '@hookform/resolvers/zod' import { Check, Code, Plus } from 'lucide-react' import { useEffect, useState } from 'react' import { useForm } from 'react-hook-form' import { toast } from 'sonner' import * as z from 'zod' import { useParams } from 'common' import { getContentById } from 'data/content/content-id-query' import { useContentUpsertMutation } from 'data/content/content-upsert-mutation' import { useSQLSnippetFolderCreateMutation } from 'data/content/sql-folder-create-mutation' import { Snippet } from 'data/content/sql-folders-query' import { SnippetWithContent, useSnippetFolders, useSqlEditorV2StateSnapshot, } from 'state/sql-editor-v2' import { Button, CommandEmpty_Shadcn_, CommandGroup_Shadcn_, CommandInput_Shadcn_, CommandItem_Shadcn_, CommandList_Shadcn_, CommandSeparator_Shadcn_, Command_Shadcn_, Dialog, DialogContent, DialogDescription, DialogFooter, DialogHeader, DialogSection, DialogSectionSeparator, DialogTitle, FormControl_Shadcn_, FormField_Shadcn_, FormItem_Shadcn_, FormLabel_Shadcn_, FormMessage_Shadcn_, Form_Shadcn_, Input_Shadcn_, Label_Shadcn_, PopoverContent_Shadcn_, PopoverTrigger_Shadcn_, Popover_Shadcn_, ScrollArea, } from 'ui' interface MoveQueryModalProps { visible: boolean snippets?: Snippet[] onClose: () => void } /** * [Joshen] Just FYI react-accessible-tree-view doesn't support drag and drop for moving * files out of the box and we'll need to figure out a way to support this ideal UX. Same * thing for the Storage Explorer actually. So this is just a temporary UX till we can figure * out drag and drop that works nicely with the tree view. React beautiful dnd unfortunately * doesn't support drag drop into a folder kind of UX. */ export const MoveQueryModal = ({ visible, snippets = [], onClose }: MoveQueryModalProps) => { const { ref } = useParams() const snapV2 = useSqlEditorV2StateSnapshot() const [open, setOpen] = useState(false) const [selectedId, setSelectedId] = useState() const { mutateAsync: createFolder, isPending: isCreatingFolder } = useSQLSnippetFolderCreateMutation() const { mutateAsync: moveSnippetAsync, isPending: isMovingSnippet } = useContentUpsertMutation({ onError: (error) => { toast.error(`Failed to move query: ${error.message}`) }, }) const getFormSchema = () => { if (selectedId === 'new-folder') { return z .object({ name: z.string().min(1, 'Please provide a name for the folder'), }) .refine((data) => !snapV2.allFolderNames.includes(data.name), { message: 'This folder name already exists', path: ['name'], }) } else { return z.object({}) } } const FormSchema = getFormSchema() const form = useForm>({ mode: 'onSubmit', reValidateMode: 'onSubmit', resolver: zodResolver(FormSchema), defaultValues: { name: '' }, }) const folders = useSnippetFolders(ref as string) const selectedFolder = selectedId === 'root' ? 'Root of the editor' : selectedId === 'new-folder' ? 'Create a new folder' : folders.find((f) => f.id === selectedId)?.name const isCurrentFolder = snippets.length === 1 && ((!snippets[0].folder_id && selectedId === 'root') || snippets[0].folder_id === selectedId) const isMovingToSameFolder = snippets.length === 1 && ((!snippets[0].folder_id && selectedId === 'root') || snippets[0].folder_id === selectedId) const onConfirmMove = async (values: z.infer) => { if (!ref) return console.error('Project ref is required') try { let folderId = selectedId if (selectedId === 'new-folder' && 'name' in values) { const { id } = await createFolder({ projectRef: ref, name: values.name, }) folderId = id } await Promise.all( snippets.map(async (snippet) => { let snippetContent = (snippet as SnippetWithContent)?.content if (snippetContent === undefined) { const { content } = await getContentById({ projectRef: ref, id: snippet.id }) if ('sql' in content) { snippetContent = content } } if (snippetContent === undefined) { return toast.error('Failed to save snippet: Unable to retrieve snippet contents') } else { await moveSnippetAsync({ projectRef: ref, payload: { id: snippet.id, type: 'sql', name: snippet.name, description: snippet.description, visibility: snippet.visibility, project_id: snippet.project_id, owner_id: snippet.owner_id, folder_id: selectedId === 'root' ? null : folderId, content: snippetContent as any, }, }) } }) ) toast.success( `Successfully moved ${snippets.length === 1 ? `"${snippets[0].name}"` : `${snippets.length} snippets`} to ${selectedId === 'root' ? 'the root of the editor' : selectedFolder}` ) snippets.forEach((snippet) => { snapV2.updateSnippet({ id: snippet.id, snippet: { ...snippet, folder_id: selectedId === 'root' ? null : folderId }, skipSave: true, }) }) onClose() } catch (error: any) { toast.error(`Failed to create new folder: ${error.message}`) } } useEffect(() => { if (visible && snippets !== undefined) { if (snippets.length === 1) { setSelectedId(snippets[0].folder_id ?? 'root') } else { setSelectedId('root') } form.reset({ name: '' }) } }, [visible, snippets]) return ( onClose()}>
Move {snippets.length === 1 ? `"${snippets[0].name}"` : `${snippets.length}`}{' '} snippet{snippets.length > 1 ? 's' : ''} to a folder Select which folder to move your quer{snippets.length > 1 ? 'ies' : 'y'} to
Select a folder No folders found 6 ? 'h-[210px]' : ''}> { setOpen(false) setSelectedId('root') }} onClick={() => { setOpen(false) setSelectedId('root') }} > Root of the editor {snippets.length === 1 && snippets[0].folder_id === null && ` (Current)`} {selectedId === 'root' && } {folders?.map((folder) => ( { setOpen(false) setSelectedId(folder.id) }} onClick={() => { setOpen(false) setSelectedId(folder.id) }} > {folder.name} {snippets.length === 1 && snippets[0].folder_id === folder.id && ` (Current)`} {folder.id === selectedId && } ))} { setOpen(false) setSelectedId('new-folder') }} onClick={() => { setOpen(false) setSelectedId('new-folder') }} >

New folder

{selectedId === 'new-folder' && (
( Provide a name for your new folder )} />
)}
) }