Cleanup one_allowed_collections field on collection delete (directus#…

…6167) Fixes directus#6161
baranelitez · Jun 9, 2021 · fb908ef · fb908ef
1 parent b5abb0f
commit fb908ef
Showing 1 changed file with 13 additions and 0 deletions.
diff --git a/api/src/services/collections.ts b/api/src/services/collections.ts
@@ -399,6 +399,19 @@ export class CollectionsService {
 				}
 			}
 
+			const m2aRelationsThatIncludeThisCollection = this.schema.relations.filter((relation) => {
+				return relation.meta?.one_allowed_collections?.includes(collectionKey);
+			});
+
+			for (const relation of m2aRelationsThatIncludeThisCollection) {
+				const newAllowedCollections = relation
+					.meta!.one_allowed_collections!.filter((collection) => collectionKey !== collection)
+					.join(',');
+				await trx('directus_relations')
+					.update({ one_allowed_collections: newAllowedCollections })
+					.where({ id: relation.meta!.id });
+			}
+
 			await collectionItemsService.deleteOne(collectionKey);
 			await trx.schema.dropTable(collectionKey);
 		});