The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { useParams } from 'common'
import { useRouter } from 'next/router'
import { useCallback, useEffect, useMemo, useState } from 'react'
import { toast } from 'sonner'
import { ContentDiff, DiffType } from './SQLEditor.types'
import {
compareAsAddition,
compareAsModification,
compareAsNewSnippet,
createSqlSnippetSkeletonV2,
} from './SQLEditor.utils'
import {
FGA_PERMISSIONS,
useAsyncCheckUserContentPermissions,
} from '@/hooks/misc/useCheckPermissionsV2'
import { useSelectedProjectQuery } from '@/hooks/misc/useSelectedProject'
import { useProfile } from '@/lib/profile'
import { useSqlEditorV2StateSnapshot } from '@/state/sql-editor/sql-editor-state'
export const useNewQuery = () => {
const router = useRouter()
const { ref } = useParams()
const { profile } = useProfile()
const { data: project } = useSelectedProjectQuery()
const snapV2 = useSqlEditorV2StateSnapshot()
const { can: canCreateSQLSnippet } = useAsyncCheckUserContentPermissions(
FGA_PERMISSIONS.PROJECT.SNIPPETS_WRITE,
{ mode: 'create', type: 'sql' }
)
const newQuery = async (sql: string, name: string, shouldRedirect: boolean = true) => {
if (!ref) return console.error('Project ref is required')
if (!project) return console.error('Project is required')
if (!profile) return console.error('Profile is required')
if (!canCreateSQLSnippet) {
toast('Your queries will not be saved as you do not have sufficient permissions')
return undefined
}
try {
const snippet = createSqlSnippetSkeletonV2({
name,
sql,
owner_id: profile?.id,
project_id: project?.id,
})
snapV2.addSnippet({ projectRef: ref, snippet })
snapV2.addNeedsSaving(snippet.id)
if (shouldRedirect) {
router.push(`/project/${ref}/sql/${snippet.id}`)
return undefined
} else {
return snippet.id
}
} catch (error: any) {
toast.error(`Failed to create new query: ${error.message}`)
return undefined
}
}
return { newQuery }
}
export function useSqlEditorDiff() {
const [sourceSqlDiff, setSourceSqlDiff] = useState<ContentDiff>()
const [selectedDiffType, setSelectedDiffType] = useState<DiffType>()
const [isAcceptDiffLoading, setIsAcceptDiffLoading] = useState(false)
const isDiffOpen = !!sourceSqlDiff
const defaultSqlDiff = useMemo(() => {
if (!sourceSqlDiff) {
return { original: '', modified: '' }
}
switch (selectedDiffType) {
case DiffType.Modification:
return compareAsModification(sourceSqlDiff)
case DiffType.Addition:
return compareAsAddition(sourceSqlDiff)
case DiffType.NewSnippet:
return compareAsNewSnippet(sourceSqlDiff)
default:
return { original: '', modified: '' }
}
}, [selectedDiffType, sourceSqlDiff])
const closeDiff = useCallback(() => {
setSourceSqlDiff(undefined)
setSelectedDiffType(undefined)
}, [])
return useMemo(
() => ({
sourceSqlDiff,
setSourceSqlDiff,
selectedDiffType,
setSelectedDiffType,
isAcceptDiffLoading,
setIsAcceptDiffLoading,
isDiffOpen,
defaultSqlDiff,
closeDiff,
}),
[sourceSqlDiff, selectedDiffType, isAcceptDiffLoading, isDiffOpen, defaultSqlDiff, closeDiff]
)
}
interface PromptState {
isOpen: boolean
selection: string
beforeSelection: string
afterSelection: string
startLineNumber: number
endLineNumber: number
}
const initialPromptState: PromptState = {
isOpen: false,
selection: '',
beforeSelection: '',
afterSelection: '',
startLineNumber: 0,
endLineNumber: 0,
}
export function useSqlEditorPrompt() {
const [promptState, setPromptState] = useState<PromptState>(initialPromptState)
const [promptInput, setPromptInput] = useState('')
useEffect(() => {
if (!promptState.isOpen) {
setPromptInput('')
}
}, [promptState.isOpen])
const resetPrompt = useCallback(() => {
setPromptState(initialPromptState)
setPromptInput('')
}, [])
const openPrompt = useCallback((context: Omit<PromptState, 'isOpen'>) => {
setPromptState((prev) => ({ ...prev, isOpen: true, ...context }))
}, [])
return useMemo(
() => ({
promptState,
setPromptState,
promptInput,
setPromptInput,
resetPrompt,
openPrompt,
}),
[promptState, promptInput, resetPrompt, openPrompt]
)
}