Function getSuggestionForQuery

client/censusGPT/src/App.js:225–266

()

    }

    const getSuggestionForQuery = async () => {
        currentSuggestionId = null
        const options = {
            method: 'POST',
            headers: { 'content-type': 'application/json' },
            body: JSON.stringify({
                natural_language_query: query,
                scope: props.version === 'San Francisco' ? 'SF' : 'USA',
                generation_id: currentGenerationId,
                session_id: sessionId,
            }),
        }

        fetch(api_endpoint + '/api/get_suggestion', options)
            .then((response) => response.json())
            .then((response) => {
                // Handle errors
                if (!response || !response.suggested_query) {
                    capturePosthog('backend_error', response)
                    return
                }

                // Capture the response in posthog
                capturePosthog('backend_response', {
                    origin: 'getSuggestionForQuery',
                })
                // Set the state for SQL and Status Code

                if (response.generation_id)
                    currentSuggestionId = response.generation_id

                setSuggestedQuery(response.suggested_query)
            })
            .catch((err) => {
                logSentryError({ query }, err)
                setIsLoading(false)
                capturePosthog('backend_error', {
                    error: err,
                })
                console.error(err)
            })
    }

    const executeSql = (sql) => {
        setIsLoading(true)