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