Edits history of script submission #13939 for ' SQL query (xata)'

• bun

  Ap­pro­ved version

  Edit in Windmill

  Embed

  //native
  type Xata = {
  	apiKey: string
  	workspaceUrl: string
  }
  /**
   * SQL query
   * Run an SQL query across the database branch.
   */
  export async function main(
  	auth: Xata,
  	db_branch_name: string,
  	body: { statement: string; params?: unknown[] } & {
  		consistency?: 'strong' | 'eventual'
  		responseType?: 'json' | 'array'
  	}
  ) {
  	const url = new URL(`${auth.workspaceUrl}/db/${db_branch_name}/sql`)
  
  	const response = await fetch(url, {
  		method: 'POST',
  		headers: {
  			'Content-Type': 'application/json',
  			Authorization: 'Bearer ' + auth.apiKey
  		},
  		body: JSON.stringify(body)
  	})
  	if (!response.ok) {
  		const text = await response.text()
  		throw new Error(`${response.status} ${text}`)
  	}
  	return await response.json()
  }
  

  Submitted by hugo697 428 days ago