Contents

class CreateBackerReports < ActiveRecord::Migration
  def up
    create_view :backer_reports, "
    SELECT 
      b.project_id,
      u.name, 
      b.value,
      r.minimum_value,
      r.description,
      b.payment_method,
      b.payment_choice,
      b.payment_service_fee,
      b.key,
      b.created_at::date,
      b.confirmed_at::date,
      u.email,
      b.payer_email,
      b.payer_name,
      u.cpf,
      u.address_street,
      u.address_complement,
      u.address_number,
      u.address_neighbourhood,
      u.address_city,
      u.address_state,
      u.address_zip_code,
      b.requested_refund,
      b.refunded
    FROM 
      backers b
      JOIN users u ON u.id = b.user_id
      LEFT JOIN rewards r ON r.id = b.reward_id
    WHERE
      b.confirmed;
    "
  end

  def down
    drop_view :backer_reports
  end
end

Version data entries

8 entries across 8 versions & 2 rubygems

Version	Path
catarse_full-0.1.0	db/migrate/20130121162447_create_backer_reports.rb
catarse_full-0.0.6	db/migrate/20130121162447_create_backer_reports.rb
catarse_full-0.0.5	db/migrate/20130121162447_create_backer_reports.rb
catarse_full-0.0.4	db/migrate/20130121162447_create_backer_reports.rb
catarse_full-0.0.3	db/migrate/20130121162447_create_backer_reports.rb
catarse_full-0.0.2	db/migrate/20130121162447_create_backer_reports.rb
catarse_full-0.0.1	db/migrate/20130121162447_create_backer_reports.rb
catarse_core-1.0.0.beta	db/migrate/20130121162447_create_backer_reports.rb