Edits history of script submission #13877 for ' Batch SQL queries (xata)'

• bun

  Ap­pro­ved version

  Edit in Windmill

  Embed

  //native
  type Xata = {
  	apiKey: string
  	workspaceUrl: string
  }
  /**
   * Batch SQL queries
   * Run multiple SQL queries across the database branch.
   */
  export async function main(
  	auth: Xata,
  	db_branch_name: string,
  	body: {
  		statements: { statement: string; params?: unknown[] }[]
  		consistency?: 'strong' | 'eventual'
  		responseType?: 'json' | 'array'
  	}
  ) {
  	const url = new URL(`${auth.workspaceUrl}/db/${db_branch_name}/sql/batch`)
  
  	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