Edits history of script submission #13941 for ' Update Branch schema (xata)'

  • bun
    One script reply has been approved by the moderators
    Ap­pro­ved
    //native
    type Xata = {
    	apiKey: string
    	workspaceUrl: string
    }
    /**
     * Update Branch schema
     *
     */
    export async function main(
    	auth: Xata,
    	db_branch_name: string,
    	body: {
    		parentID?: string
    		operations:
    			| { addTable: { table: string } }
    			| { removeTable: { table: string } }
    			| { renameTable: { oldName: string; newName: string } }
    			| {
    					addColumn: {
    						table: string
    						column: {
    							name: string
    							type:
    								| 'string'
    								| 'object'
    								| 'bool'
    								| 'int'
    								| 'float'
    								| 'text'
    								| 'email'
    								| 'multiple'
    								| 'link'
    								| 'datetime'
    								| 'vector'
    								| 'file[]'
    								| 'file'
    								| 'json'
    							link?: { table: string }
    							vector?: { dimension: number }
    							file?: { defaultPublicAccess?: false | true }
    							'file[]'?: { defaultPublicAccess?: false | true }
    							notNull?: false | true
    							defaultValue?: string
    							unique?: false | true
    							columns?: {}[]
    						}
    					}
    			  }
    			| { removeColumn: { table: string; column: string } }
    			| { renameColumn: { table: string; oldName: string; newName: string } }[]
    	}
    ) {
    	const url = new URL(`${auth.workspaceUrl}/db/${db_branch_name}/schema/update`)
    
    	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