Contents

WITH

files AS (
  SELECT jsonb_array_elements(data->'files') FROM rubocops
),
lines AS (
  SELECT 
    jsonb_array_elements(files)->>'file' as file,
    jsonb_array_elements(files)->'lines' as lines
  FROM files 
),
denormalized AS (
  SELECT
    jsonb_array_elements(lines)->>'position' as position,
    jsonb_array_elements(lines)->>'status' as status,
    jsonb_array_elements(lines)->>'status_message' as status_message,
    jsonb_array_elements(lines)->>'cop' as cop,
    jsonb_array_elements(lines)->>'message' as message,
    jsonb_array_elements(lines)->>'full_line' as full_line,
    jsonb_array_elements(lines)->>'file_name' as file_name
  FROM lines
)
select row_number() OVER () AS id, * from denormalized

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
rails_app_generator-0.3.6	after_templates/application/klueless/db/views/rubocop_entries_v01.sql
rails_app_generator-0.3.5	after_templates/application/klueless/db/views/rubocop_entries_v01.sql
rails_app_generator-0.3.4	after_templates/application/klueless/db/views/rubocop_entries_v01.sql
rails_app_generator-0.3.3	after_templates/application/klueless/db/views/rubocop_entries_v01.sql
rails_app_generator-0.3.2	after_templates/application/klueless/db/views/rubocop_entries_v01.sql