Contents

class CreateDuneAdminFundingRaisedPerProjectReports < ActiveRecord::Migration
  def up
    execute <<-SQL
        CREATE OR REPLACE VIEW dune_admin_funding_raised_per_project_reports AS
        SELECT
          project.id AS project_id,
          project.name AS project_name,
          sum(contributions.value) AS total_raised,
          count(*) AS total_backs,
          count(DISTINCT contributions.user_id) AS total_backers
         FROM contributions
         JOIN projects AS project ON project.id = contributions.project_id
        WHERE contributions.state::text <> ALL (ARRAY['waiting_confirmation'::character varying::text, 'pending'::character varying::text, 'canceled'::character varying::text, 'deleted'])
        GROUP BY project.id;
    SQL
  end

  def down
    drop_view :dune_admin_funding_raised_per_project_reports
  end
end

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
dune-admin-1.2.7	db/migrate/20141005184741_create_dune_admin_funding_raised_per_project_reports.rb
dune-admin-1.2.6	db/migrate/20141005184741_create_dune_admin_funding_raised_per_project_reports.rb
dune-admin-1.2.5	db/migrate/20141005184741_create_dune_admin_funding_raised_per_project_reports.rb
dune-admin-1.2.4	db/migrate/20141005184741_create_dune_admin_funding_raised_per_project_reports.rb
dune-admin-1.2.3	db/migrate/20141005184741_create_dune_admin_funding_raised_per_project_reports.rb
dune-admin-1.0.0	db/migrate/20141005184741_create_dune_admin_funding_raised_per_project_reports.rb