Edits history of script submission #12693 for ' Get the database schema (neondb)'

  • bun
    One script reply has been approved by the moderators
    Ap­pro­ved
    //native
    type Neondb = {
    	apiKey: string
    }
    /**
     * Get the database schema
     * Retrieves the schema from the specified database. The `lsn` and `timestamp` values cannot be specified at the same time. If both are omitted, the database schema is retrieved from database's head.
     */
    export async function main(
    	auth: Neondb,
    	project_id: string,
    	branch_id: string,
    	db_name: string | undefined,
    	lsn: string | undefined,
    	timestamp: string | undefined
    ) {
    	const url = new URL(
    		`https://console.neon.tech/api/v2/projects/${project_id}/branches/${branch_id}/schema`
    	)
    	for (const [k, v] of [
    		['db_name', db_name],
    		['lsn', lsn],
    		['timestamp', timestamp]
    	]) {
    		if (v !== undefined && v !== '' && k !== undefined) {
    			url.searchParams.append(k, v)
    		}
    	}
    	const response = await fetch(url, {
    		method: 'GET',
    		headers: {
    			Authorization: 'Bearer ' + auth.apiKey
    		},
    		body: undefined
    	})
    	if (!response.ok) {
    		const text = await response.text()
    		throw new Error(`${response.status} ${text}`)
    	}
    	return await response.json()
    }
    

    Submitted by hugo697 428 days ago