Updates project's postgrest config
One script reply has been approved by the moderators Verified
Created by hugo697 151 days ago Picked 1 time
Submitted by hugo697 Bun
Verified 151 days ago
1
//native
2
type Supabase = {
3
	key: string
4
}
5
/**
6
 * Updates project's postgrest config
7
 *
8
 */
9
export async function main(
10
	auth: Supabase,
11
	ref: string,
12
	body: {
13
		db_extra_search_path?: string
14
		db_schema?: string
15
		max_rows?: number
16
		db_pool?: number
17
	}
18
) {
19
	const url = new URL(`https://api.supabase.com/v1/projects/${ref}/postgrest`)
20

21
	const response = await fetch(url, {
22
		method: 'PATCH',
23
		headers: {
24
			'Content-Type': 'application/json',
25
			Authorization: 'Bearer ' + auth.key
26
		},
27
		body: JSON.stringify(body)
28
	})
29
	if (!response.ok) {
30
		const text = await response.text()
31
		throw new Error(`${response.status} ${text}`)
32
	}
33
	return await response.json()
34
}
35