hotdangthatsnasty

BEGIN;

WITH object_attributes AS (
    WITH object_keys AS (
        SELECT uuid, json_object_keys(properties::json->'values') AS key FROM object_data
    )
    SELECT
        object_data.uuid AS object_id,
        hstore(array_agg(object_keys.key), array_agg(json_build_object('type', properties::json->'values'->object_keys.key->'attribute_type', 'value', properties::json->'values'->object_keys.key->'value')::text)) AS VALUE
        FROM object_data
        JOIN object_keys ON (object_keys.uuid = object_data.uuid)
        GROUP BY object_data.uuid
)
UPDATE object_data
SET attributes = attributes || object_attributes.VALUE
FROM object_attributes
WHERE object_data.uuid = object_attributes.object_id;

COMMIT;