Function fetchBackend

client/censusGPT/src/App.js:504–773

(natural_language_query)

    }

    const fetchBackend = async (natural_language_query) => {
        if (natural_language_query == null) {
            return
        }
        // Don't send a request if the query is empty!
        natural_language_query = natural_language_query.trim()
        if (!natural_language_query.length) return

        setTableNames()
        setSqlExplanation()
        setShowExplanationModal(false)

        // clear previous layers
        clearMapLayers()
        clearAllButQuery()
        const table_names = await getTables(natural_language_query)

        if (!table_names) {
            await getSuggestionForFailedQuery()
            return
        }

        // Set the loading state
        setIsLoading(true)

        let requestBody = {
            natural_language_query,
            table_names,
            scope: props.version === 'San Francisco' ? 'SF' : 'USA',
            session_id: sessionId,
            generation_id: currentGenerationId,
        }

        // Set the options for the fetch request
        const options = {
            method: 'POST',
            headers: { 'content-type': 'application/json' },
            body: JSON.stringify(requestBody),
        }

        let responseOuter = null
        // Send the request
        const startTime = new Date().getTime()
        const apiCall = fetch(api_endpoint + '/api/text_to_sql', options)
        const TIMEOUT_DURATION = 45000
        const timeout = new Promise((_, reject) => {
            setTimeout(() => {
                reject(new Error('Server failed to respond in time'))
            }, TIMEOUT_DURATION) // timeout after 45 seconds
        })
        Promise.race([apiCall, timeout])
            .then((response) => response.json())
            .then(async (response) => {
                // Set the loading state to false
                setIsLoading(false)

                // Handle errors
                if (!response) {