Edits history of script submission #13881 for ' Compare branch with user schema. (xata)'

• bun

  Ap­pro­ved version

  Edit in Windmill

  Embed

  //native
  type Xata = {
  	apiKey: string
  	workspaceUrl: string
  }
  /**
   * Compare branch with user schema.
   *
   */
  export async function main(
  	auth: Xata,
  	db_branch_name: string,
  	body: {
  		schema: {
  			tables: {
  				id?: string
  				name: string
  				columns: {
  					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?: {}[]
  				}[]
  				revLinks?: { table: string; column: string }[]
  			}[]
  			tablesOrder?: string[]
  		}
  		schemaOperations?:
  			| { 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 } }[]
  		branchOperations?:
  			| { 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/compare`)
  
  	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