Sha256: 2ee228eaa9e38d530739a13f19d00174d41f313c440ebd17d09b0fabeaed14d1
Contents?: true
Size: 576 Bytes
Versions: 12
Compression:
Stored size: 576 Bytes
Contents
# frozen_string_literal: true
class <%= @migration_class_name %> < ActiveRecord::Migration<%= ActiveRecord::VERSION::MAJOR < 5 ? '' : '[5.0]' %>
def up
execute <<-SQL
CREATE OR REPLACE VIEW <%= view_name %> AS
SELECT
tag_name,
COUNT(*) AS taggings_count
FROM (
SELECT UNNEST
(<%= source_columns.join(' || ') %>) AS tag_name
FROM
<%= source_table_name %>
) subquery
GROUP BY
tag_name;
SQL
end
def down
execute <<-SQL
DROP VIEW <%= view_name %>;
SQL
end
end
Version data entries
12 entries across 12 versions & 1 rubygems