Method updateOne

api/src/services/relations.ts:314–434

* Update an existing foreign key constraint * * Note: You can update anything under meta, but only the `on_delete` trigger under schema

(
		collection: string,
		field: string,
		relation: Partial<Relation>,
		opts?: MutationOptions,
	)

	 * Note: You can update anything under meta, but only the `on_delete` trigger under schema
	 */
	async updateOne(
		collection: string,
		field: string,
		relation: Partial<Relation>,
		opts?: MutationOptions,
	): Promise<void> {
		if (this.accountability && this.accountability.admin !== true) {
			throw new ForbiddenError();
		}

		const collectionSchema = this.schema.collections[collection];

		if (!collectionSchema) {
			throw new InvalidPayloadError({ reason: `Collection "${collection}" doesn't exist` });
		}

		const fieldSchema = collectionSchema.fields[field];

		if (!fieldSchema) {
			throw new InvalidPayloadError({ reason: `Field "${field}" doesn't exist in collection "${collection}"` });
		}

		const existingRelation = this.schema.relations.find(
			(existingRelation) => existingRelation.collection === collection && existingRelation.field === field,
		);

		if (!existingRelation) {
			throw new InvalidPayloadError({
				reason: `Field "${field}" in collection "${collection}" doesn't have a relationship.`,
			});
		}

		const runPostColumnChange = await this.helpers.schema.preColumnChange();
		this.helpers.schema.preRelationChange(relation);

		const nestedActionEvents: ActionEventParams[] = [];

		try {
			await transaction(this.knex, async (trx) => {
				if (existingRelation.related_collection) {
					await trx.schema.alterTable(collection, async (table) => {
						let constraintName: string = getDefaultIndexName('foreign', collection, field);

						// If the FK already exists in the DB, drop it first
						if (existingRelation?.schema) {
							constraintName = existingRelation.schema.constraint_name || constraintName;
							table.dropForeign(field, constraintName);

							constraintName = this.helpers.schema.constraintName(constraintName);
							existingRelation.schema.constraint_name = constraintName;
						}

						this.alterType(table, relation, fieldSchema.nullable);

						const builder = table
							.foreign(field, constraintName || undefined)
							.references(
								`${existingRelation.related_collection!}.${