nuttycom/aftok - Change AWWC6P5ZVFDQHX3EAYDG4DKTUZ6A5LHQAV3NIUO3VP6FM7JKPK5AC

Add migration to include payment network with addresses.

Created by Kris Nuttycombe on June 6, 2020

AWWC6P5ZVFDQHX3EAYDG4DKTUZ6A5LHQAV3NIUO3VP6FM7JKPK5AC

Dependencies

In channels

main

Change contents

Insertion in .gitignore at line 6 [4.135]
[3.33]
[3.33]
```
dist-newstyle
```
Insertion in .gitignore at line 23 [4.135]
[5.14]
[5.14]
```
docker/fix-attrs.d
```
Replacement in Makefile at line 8 [8.1254]
B:BD[6.334] → [7.1345:1383]
```
	docker build -t aftok/aftok:latest .
```
[6.334]
[6.375]
```
	docker build -t aftok/aftok-server:latest .
```

Replacement in Makefile at line 11 [8.1254]

B:BD[6.402] → [7.1384:1484]

	docker tag aftok/aftok:latest aftok/aftok:$(VERSION)
	docker push docker.io/aftok/aftok:$(VERSION)

[6.402]

[8.1310]

	docker tag aftok/aftok-server:latest aftok/aftok-server:$(VERSION)
	docker push docker.io/aftok/aftok-server:$(VERSION)

Replacement in Makefile at line 15 [8.1254]

B:BD[7.1515] → [7.1515:1594]

	docker run --net=host -it -v $(PWD)/local/conf/:/etc/aftok aftok/aftok:latest

[7.1515]

	docker run --net=host -it -v $(PWD)/local/conf/:/etc/aftok aftok/aftok-server:latest

Insertion in docker-compose.yml at line 41 [7.23741]
[7.24502]
[7.24502]
```
    ports:
      - "5432:5432"
```
Insertion in lib/Aftok/Database/PostgreSQL.hs at line 31 [9.456]
[2.14316]
[2.14316]
```
import qualified Data.Text                     as T
```

Replacement in lib/Aftok/Database/PostgreSQL.hs at line 108 [9.456]

B:BD[10.7935] → [10.7935:7981]

  addrMay <- stringToAddr n <$> fromField f v

[10.7935]

[2.15891]

  fieldValue <- fromField f v
  let addrMay = stringToAddr n fieldValue

Replacement in lib/Aftok/Database/PostgreSQL.hs at line 112 [9.456]

B:BD[2.15958] → [2.15958:16035]

                        "could not deserialize value to a valid BTC address"

[2.15958]

[11.2131]

                        ("could not deserialize value " <> T.unpack fieldValue <> " to a valid BTC address")

Replacement in lib/Aftok/Database/PostgreSQL.hs at line 374 [9.456]

B:BD[10.10964] → [10.10964:11057]

                 credit_to_type, credit_to_address, credit_to_user_id, credit_to_project_id,

[10.10964]

[10.11057]

                 credit_to_type,
                 credit_to_network, credit_to_address, credit_to_user_id, credit_to_project_id,

Replacement in lib/Aftok/Database/PostgreSQL.hs at line 385 [9.456]

B:BD[2.19889] → [2.19889:19984]

      [sql| SELECT credit_to_type, credit_to_address, credit_to_user_id, credit_to_project_id,

[2.19889]

[10.11362]

      [sql| SELECT credit_to_type,
                     credit_to_network, credit_to_address, credit_to_user_id, credit_to_project_id,

Replacement in lib/Aftok/Database/PostgreSQL.hs at line 394 [9.456]

B:BD[2.20071] → [2.20071:20166]

      [sql| SELECT credit_to_type, credit_to_address, credit_to_user_id, credit_to_project_id,

[2.20071]

[10.11624]

      [sql| SELECT credit_to_type,
                     credit_to_network, credit_to_address, credit_to_user_id, credit_to_project_id,

Replacement in lib/Aftok/Database/PostgreSQL.hs at line 403 [9.456]

B:BD[2.20263] → [2.20263:20358]

      [sql| SELECT credit_to_type, credit_to_address, credit_to_user_id, credit_to_project_id,

[2.20263]

[10.11913]

      [sql| SELECT credit_to_type,
                     credit_to_network, credit_to_address, credit_to_user_id, credit_to_project_id,

Replacement in lib/Aftok/Database/PostgreSQL.hs at line 459 [9.456]

∅:D[2.21320] → [10.13154:13247]

B:BD[10.13154] → [10.13154:13247]

    [sql| SELECT credit_to_type, credit_to_address, credit_to_user_id, credit_to_project_id,

[2.21320]

[10.13247]

    [sql| SELECT credit_to_type,
                 credit_to_network, credit_to_address, credit_to_user_id, credit_to_project_id,

Replacement in lib/Aftok/Database/PostgreSQL.hs at line 511 [9.456]

∅:D[2.22347] → [10.14080:14139]

B:BD[10.14080] → [10.14080:14139]

    [sql| INSERT INTO users (handle, network, addr, email)

[2.22347]

[10.14139]

    [sql| INSERT INTO users (handle, default_payment_network, default_payment_addr, email)

Replacement in lib/Aftok/Database/PostgreSQL.hs at line 523 [9.456]
∅:D[10.14320] → [12.18341:18409]
∅:D[2.22465] → [12.18341:18409]
B:BD[12.18341] → [12.18341:18409]
```
    [sql| SELECT handle, btc_addr, email FROM users WHERE id = ? |]
```
[2.22465]
[13.9648]
```
    [sql| SELECT handle, default_payment_network, default_payment_addr, email FROM users WHERE id = ? |]
```

Replacement in lib/Aftok/Database/PostgreSQL.hs at line 530 [9.456]

∅:D[10.14455] → [12.18473:18549]

∅:D[2.22537] → [12.18473:18549]

B:BD[12.18473] → [12.18473:18549]

    [sql| SELECT id, handle, btc_addr, email FROM users WHERE handle = ? |]

[2.22537]

[13.9812]

    [sql| SELECT id, handle, default_payment_network, default_payment_addr, email FROM users WHERE handle = ? |]

File addition: 2020-06-06_03-53-54_add-payment-networks.txt (----------)

[14.1]

Description: (Describe migration here.)
Created: 2020-06-06 03:54:56.188542 UTC
Depends: 2016-10-13_05-36-55_user-event-log
Apply: |
  ALTER TABLE users ADD COLUMN default_payment_network text NOT NULL DEFAULT 'btc';
  ALTER TABLE users RENAME COLUMN btc_addr TO default_payment_addr;
  ALTER TABLE work_events ADD COLUMN credit_to_network text;
  UPDATE work_events SET credit_to_network = 'btc' 
  WHERE credit_to_address IS NOT NULL;
Revert: |
  ALTER TABLE work_events DROP COLUMN credit_to_network;
  ALTER TABLE users RENAME COLUMN default_payment_addr TO btc_addr;
  ALTER TABLE users DROP COLUMN default_payment_network;