Sha256: 3945d79e074baf651d9f414f55167a13b6a82d2c70fd99d0533de3edf5f1f653
Contents?: true
Size: 1.59 KB
Versions: 8
Compression:
Stored size: 1.59 KB
Contents
class AddCpfToBackerReport < ActiveRecord::Migration
def up
drop_view :backer_reports
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,
coalesce(b.payer_document, u.cpf) as 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
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
end
Version data entries
8 entries across 8 versions & 2 rubygems