get_previous_name_from_history.sql

SELECT
       mcl.changes #>> '{name, old_value, repr}'
FROM history_modelchangelog as mcl
WHERE (
    mcl.action = 'updated'
    AND (mcl.changes #>> '{name, new_value, repr}') = %(new_name)s
        AND (mcl.changes #>> '{name, old_value, repr}') IS NOT NULL
        AND mcl.content_type_id = %(content_type_id)s
        AND mcl.object_id = %(object_id)s
    )
ORDER BY mcl.updated_at DESC
LIMIT 1