Function query

src/environmentd/src/http/static/js/fetch.js:18–35

* Execute a SQL query against the /api/sql endpoint. * * @param {string} sql - SQL query string * @returns {Promise } - The parsed JSON response

(sql)

 * @returns {Promise<Object>} - The parsed JSON response
 */
async function query(sql) {
  const response = await fetch('/api/sql', {
    method: 'POST',
    body: JSON.stringify({ query: sql }),
    headers: { 'Content-Type': 'application/json' },
  });
  if (!response.ok) {
    const text = await response.text();
    throw `request failed: ${response.status} ${response.statusText}: ${text}`;
  }
  const data = await response.json();
  for (const result of data.results) {
    if (result.error) {
      throw `SQL error: ${result.error.message}`;
    }
  }
  return data;
}