EsupPortail / Esup-Pod / 28669484862

69%

main: 71%

Pull #1427

github

Fix tag cleanup during v3 to v4 import (#1482)

## Summary

This fixes tag cleanup during the Pod v3 to v4 import command.

The import command could fail when rerun on a non-empty database because tag parent tables were deleted before their many-to-many relation tables. MySQL then raised a foreign key constraint error when existing rows in `video_video_tags` still referenced `video_tagulous_video_tags`.

## Changes

- Delete tag relation tables before deleting Tagulous tag tables.
- Apply the same cleanup order for video and recorder tags.
- Temporarily disable MySQL foreign key checks during tag cleanup.
- Re-enable foreign key checks in a `finally` block to avoid leaving them disabled after an error.

## Validation

- Ran Python syntax validation with:

```bash
python3 -m py_compile pod/video/management/commands/import_data_from_v3_to_v4.py

804 of 1118 new or added lines in 24 files covered. (71.91%)

13682 of 19776 relevant lines covered (69.18%)

0.69 hits per line