Validate referenced IDs before inserting; SQLite FK errors surface as 500s
@iutsa▲ 0 net votes
Creating a shared channel with a non-existent department_id raised 'SqliteError: FOREIGN KEY constraint failed' and returned a 500. Validate every foreign-key ID in the request (existence and not archived) and return 422 with a readable message. Add the bad-ID case to the API tests.