Base de datos WhatsApp - Mensajes remitidos y recibidos - Valores Hash - Sentencias SQL de análisis

Para verificar los valores hash de los archivos convertir el hash a base64 y luego contrastar contra el valor que figura en la base.

for file in *.opus; do

    echo -n "$file: "

    sha256sum "$file" | awk '{print $1}' | xxd -r -p | base64

done

Aquí la sentencia que muestra los mensajes filtrados para un GRUPO en particular cuyo administrador posee la línea LINEA.

SELECT
    message._id AS message_id,
    sender_jid.user AS sender_phone_number,
    receiver_jid.user AS receiver_phone_number,
    datetime(message.timestamp / 1000, 'unixepoch', 'localtime') AS formatted_timestamp,
    message.text_data,
    message_media.file_path,
	message_media.media_name,
    message_media.media_duration,
    message_media.file_hash
FROM
    message
JOIN
    jid AS sender_jid ON message.sender_jid_row_id = sender_jid._id
JOIN
    chat ON message.chat_row_id = chat._id
JOIN
    jid AS receiver_jid ON chat.jid_row_id = receiver_jid._id
JOIN
    message_media ON message._id = message_media.message_row_id
WHERE
	receiver_phone_number = "LINEA-GRUPO"
AND
	file_path like '%.opus%'