Edits history of script submission #12667 for ' Get a connection URI (neondb)'

  • bun
    One script reply has been approved by the moderators
    Ap­pro­ved
    //native
    type Neondb = {
    	apiKey: string
    }
    /**
     * Get a connection URI
     * Retrieves a connection URI for the specified database.
    You can obtain a `project_id` by listing the projects for your Neon account.
    You can obtain the `database_name` by listing the databases for a branch.
    You can obtain a `role_name` by listing the roles for a branch.
    
     */
    export async function main(
    	auth: Neondb,
    	project_id: string,
    	branch_id: string | undefined,
    	endpoint_id: string | undefined,
    	database_name: string | undefined,
    	role_name: string | undefined,
    	pooled: string | undefined
    ) {
    	const url = new URL(`https://console.neon.tech/api/v2/projects/${project_id}/connection_uri`)
    	for (const [k, v] of [
    		['branch_id', branch_id],
    		['endpoint_id', endpoint_id],
    		['database_name', database_name],
    		['role_name', role_name],
    		['pooled', pooled]
    	]) {
    		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