Absence de nettoyage table média lors de la suppression d'un média d'une page d'accueil

Pour reproduire :

• Créer une page d'accueil :

  select ID_METATAG, META_ID_FICHE, META_CODE, META_LANGUE, META_LIBELLE_FICHE, META_CODE_OBJET, META_ETAT_OBJET FROM METATAG WHERE ID_METATAG = 816;
  +------------+---------------+---------------+-------------+--------------------+-----------------+-----------------+
  | ID_METATAG | META_ID_FICHE | META_CODE     | META_LANGUE | META_LIBELLE_FICHE | META_CODE_OBJET | META_ETAT_OBJET |
  +------------+---------------+---------------+-------------+--------------------+-----------------+-----------------+
  |        816 |       1000003 | 1567600858100 | 0           | Page de test       | 0111            | 0003            |
  +------------+---------------+---------------+-------------+--------------------+-----------------+-----------------+

• Créer une carte avec un média (non enregistré dans la médiathèque) associé :

  select * from CARD_META WHERE ID_META = 816;
  +--------------+---------+---------+
  | ID_CARD_META | ID_CARD | ID_META |
  +--------------+---------+---------+
  |            9 |       9 |     816 |
  +--------------+---------+---------+
  select * from CARD WHERE ID_CARD = 9;
  +---------+--------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  | ID_CARD | KEY_CARD                             | DATAS_CARD                                                                                                                                                                                                                                                                                                                     |
  +---------+--------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  |       9 | 49dc54de-3539-47df-90b5-3255eebb3f19 | {"class":"com.kosmos.layout.card.bean.PictureCardBean","title":"Carte","background_color":"#ffffff","foreground_color":"#000000","link":null,"style":null,"picture":{"class":"com.kosmos.components.media.bean.ComponentMediaFile","format":"image/jpeg","id":2119,"legende":"dsgfdgfd","titre":"chaton.jpg","file_number":1}} |
  +---------+--------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  select * from RESSOURCE WHERE ID_RESSOURCE = 2119;
  +--------------+----------+--------------------------------+------+-------+
  | ID_RESSOURCE | ID_MEDIA | CODE_PARENT                    | ETAT | ORDRE |
  +--------------+----------+--------------------------------+------+-------+
  |         2119 |      554 | 1000003,TYPE=FICHIER_0111,NO=1 | 1    |  NULL |
  +--------------+----------+--------------------------------+------+-------+
  select ID_MEDIA, URL, CODE_RUBRIQUE, IS_MUTUALISE FROM MEDIA WHERE ID_MEDIA = 554;
  +----------+--------------------------+---------------+--------------+
  | ID_MEDIA | URL                      | CODE_RUBRIQUE | IS_MUTUALISE |
  +----------+--------------------------+---------------+--------------+
  |      554 | chaton_1567601002817-jpg |               | 2            |
  +----------+--------------------------+---------------+--------------+

• Supprimer le média de la carte et enregistrer la page d'accueil :

  select * from CARD_META WHERE ID_META = 816;
  +--------------+---------+---------+
  | ID_CARD_META | ID_CARD | ID_META |
  +--------------+---------+---------+
  |           10 |      10 |     816 |
  +--------------+---------+---------+
  select * from CARD WHERE ID_CARD = 10;
  +---------+--------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  | ID_CARD | KEY_CARD                             | DATAS_CARD                                                                                                                                                                |
  +---------+--------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  |      10 | 49dc54de-3539-47df-90b5-3255eebb3f19 | {"class":"com.kosmos.layout.card.bean.PictureCardBean","title":"Carte","background_color":"#ffffff","foreground_color":"#000000","link":null,"style":null,"picture":null} |
  +---------+--------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

• Vérification des résidus présents :

  select * from RESSOURCE WHERE ID_RESSOURCE = 2119;
  Empty set (0.00 sec)
  
  select ID_MEDIA, URL, CODE_RUBRIQUE, IS_MUTUALISE FROM MEDIA WHERE ID_MEDIA = 554;
  +----------+--------------------------+---------------+--------------+
  | ID_MEDIA | URL                      | CODE_RUBRIQUE | IS_MUTUALISE |
  +----------+--------------------------+---------------+--------------+
  |      554 | chaton_1567601002817-jpg |               | 2            |
  +----------+--------------------------+---------------+--------------+

• Lancer le scansite
• Vérification de la présence du média :

  select ID_MEDIA, URL, CODE_RUBRIQUE, IS_MUTUALISE FROM MEDIA WHERE ID_MEDIA = 554;
  +----------+--------------------------+---------------+--------------+
  | ID_MEDIA | URL                      | CODE_RUBRIQUE | IS_MUTUALISE |
  +----------+--------------------------+---------------+--------------+
  |      554 | chaton_1567601002817-jpg |               | 2            |
  +----------+--------------------------+---------------+--------------+

-> Le média devrait être supprimé et supprimé également du storage