Fix signup database issues.

[?]
Oct 11, 2020, 6:27 PM
F4ONFXF4MSA3QM64T7ATRVO3NQR2MC3RVZGVNGSQXCKXXQX2UG7QC

Dependencies

  • [2] 5IDB3IWS Integrate zcashd-based zaddr validation.
  • [3] AWWC6P5Z Add migration to include payment network with addresses.
  • [4] B6HWAPDP Modularize & update to recent haskoin.
  • [5] U256ZALI Add captcha check to register route.
  • [6] 2XQD6KKK Add invitation logic and clean up DBProg error handling.
  • [7] 73NDXDEZ Begin implementation of billing event persistence.
  • [8] EFSXYZPO Autoformat everything with brittany.
  • [*] IZEVQF62 Work in progress replacing sqlite with postgres.
  • [*] BROSTG5K Beginning of modularization of server.

Change contents

  • replacement in lib/Aftok/Database/PostgreSQL.hs at line 530
    [3.1324][3.14139:14185](),[3.1819][3.14139:14185](),[3.14139][3.14139:14185]()
    VALUES (?, ?, ?, ?) RETURNING id |]
    [3.1819]
    [3.22348]
    VALUES (?, ?, ?) RETURNING id |]
  • edit in migrations/2020-09-14_23-27-54_users-account-recovery.txt at line 8
    [3.3739]
    [3.3739]
    ALTER TABLE users ALTER COLUMN default_payment_addr DROP NOT NULL;
  • edit in migrations/2020-09-14_23-27-54_users-account-recovery.txt at line 11
    [3.3750]
    [3.3750]
    ALTER TABLE users ALTER COLUMN default_payment_addr SET NOT NULL;
  • replacement in server/Aftok/Snaplet/Users.hs at line 90
    [2.5740][2.5740:5801]()
    <*> (parseInvitationCodes =<< v .: "invitation_codes")
    [2.5740]
    [3.10820]
    <*> (parseInvitationCodes . maybeToList =<< v .:? "invitation_codes")