Sha256: 33bd51535a08d8d39f71539f542aeedaecf6f1f083d786a3bea2b9434b31770d
Contents?: true
Size: 689 Bytes
Versions: 12
Compression:
Stored size: 689 Bytes
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
),
rubocop_log 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 * from rubocop_log
Version data entries
12 entries across 10 versions & 1 rubygems