Edits history of script submission #13887 for ' Create new column (xata)'

  • bun
    One script reply has been approved by the moderators
    Ap­pro­ved
    //native
    type Xata = {
    	apiKey: string
    	workspaceUrl: string
    }
    /**
     * Create new column
     * Adds a new column to the table. The body of the request should contain the column definition.
     */
    export async function main(
    	auth: Xata,
    	db_branch_name: string,
    	table_name: string,
    	body: {
    		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?: {}[]
    	}
    ) {
    	const url = new URL(`${auth.workspaceUrl}/db/${db_branch_name}/tables/${table_name}/columns`)
    
    	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