notes for replacing a media with files

gistfile1.txt

# Reges for finding drupal entities.
/<drupal-entity.*?data-entity-uuid="(.{36})">\s*?<\/drupal-entity>/


# raw data for command linking UUID with file
ahoy drush sqlq "SELECT m.mid as mid, m.uuid as uuid, mfd.status, f.fid as fid, f.filemime, f.filesize, f.filename, f.uri, mfd.name FROM media m INNER JOIN media_field_data mfd ON m.mid = mfd.mid INNER JOIN media__field_media_file mff ON m.mid = mff.entity_id INNER JOIN file_managed f ON mff.field_media_file_target_id = f.fid;"


# rough command
gsed -i -e s/PLACEHOLDER_12312312-1231-1231-1231-123123123123_PLACEHOLDER/"[<a href=\\\\\"\/sites\/default\/files\/SOMEFILE.pdf\\\\\">PDF: 8818 KB<\/a>]"/g ~/Backups/iwork.sql && echo "12312312-1231-1231-1231-123123123123"