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

Version Path
metka-2.3.4 lib/generators/metka/strategies/view/templates/migration.rb.erb
metka-2.3.3 lib/generators/metka/strategies/view/templates/migration.rb.erb
metka-2.3.2 lib/generators/metka/strategies/view/templates/migration.rb.erb
metka-2.3.1 lib/generators/metka/strategies/view/templates/migration.rb.erb
metka-2.3.0 lib/generators/metka/strategies/view/templates/migration.rb.erb
metka-2.2.1 lib/generators/metka/strategies/view/templates/migration.rb.erb
metka-2.2.0 lib/generators/metka/strategies/view/templates/migration.rb.erb
metka-2.1.0 lib/generators/metka/strategies/view/templates/migration.rb.erb
metka-2.0.3 lib/generators/metka/strategies/view/templates/migration.rb.erb
metka-2.0.2 lib/generators/metka/strategies/view/templates/migration.rb.erb
metka-2.0.1 lib/generators/metka/strategies/view/templates/migration.rb.erb
metka-2.0.0 lib/generators/metka/strategies/view/templates/migration.rb.erb