Add changes to event_credit_to_amendments

[?]

Jun 19, 2020, 3:28 AM

ZTPDQKLAB6JJGUFYNBE2OYDW7LV64FNI6BXBO3TBWOM4YF5UWI5QC

Dependencies

[2] AWWC6P5Z Add migration to include payment network with addresses.
[3] B6HWAPDP Modularize & update to recent haskoin.
[4] IPG33FAW Add billing daemon
[5] 73NDXDEZ Begin implementation of billing event persistence.
[6] EFSXYZPO Autoformat everything with brittany.
[7] HMDM3B55 Implement core of payments/billing infrastructure.
[*] IZEVQF62 Work in progress replacing sqlite with postgres.

Change contents

replacement in lib/Aftok/Database/PostgreSQL.hs at line 325

[3.10066]→[3.14378:14449](∅→∅),[3.19202]→[3.14378:14449](∅→∅),[3.14378]→[3.14378:14449](∅→∅)

( project_id, user_id, credit_to_type, credit_to_address

[3.19202]

[3.10067]

( project_id, user_id, credit_to_type, credit_to_network, credit_to_address
edit in lib/Aftok/Database/PostgreSQL.hs at line 332

[3.19250]

[3.19250]

, renderNetworkId nid
replacement in lib/Aftok/Database/PostgreSQL.hs at line 427

[3.12371]→[3.12371:12444](∅→∅)

(event_id, amended_at, credit_to_type, credit_to_btc_addr)

[3.12371]

[3.16675]

(event_id, amended_at, credit_to_type, credit_to_network, credit_to_address)
edit in lib/Aftok/Database/PostgreSQL.hs at line 432

[3.20670]

[3.20670]

, renderNetworkId nid
replacement in migrations/2020-06-06_03-53-54_add-payment-networks.txt at line 11

[2.1947]→[2.1947:1986](∅→∅)

WHERE credit_to_address IS NOT NULL;

[2.1947]

[2.1986]

WHERE credit_to_address IS NOT NULL;

ALTER TABLE event_credit_to_amendments RENAME COLUMN credit_to_btc_addr TO credit_to_address;
ALTER TABLE event_credit_to_amendments ADD COLUMN credit_to_network text;

UPDATE event_credit_to_amendments SET credit_to_network = 'btc'
WHERE credit_to_address IS NOT NULL;
edit in migrations/2020-06-06_03-53-54_add-payment-networks.txt at line 20

[2.1997]

[2.1997]

ALTER TABLE event_credit_to_amendments RENAME COLUMN credit_to_address TO credit_to_btc_addr;
ALTER TABLE event_credit_to_amendments DROP COLUMN credit_to_network;