//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