run Gratipay 173

[chadwhitacre]

172

[chadwhitacre]

Reviewed teams and users, took a backup.

[chadwhitacre]

[gratipay] $ heroku config -s | run_dammit /dev/stdin -c ./env/bin/python ./bin/migrate-tips.py
updating Heroku CLI...done. Updated to 3.42.3
Migrated 0 tip(s) for 'detexify'
Migrated 0 tip(s) for 'hamper'
Migrated 0 tip(s) for 'juice-shop'
'knopproject' already migrated.
'konlpy' already migrated.
'byebug' already migrated.
Migrated 0 tip(s) for 'shields'
'pageres' already migrated.
'org-mode' already migrated.
Migrated 0 tip(s) for 'searx'
'md-for-bootstrap' already migrated.
'nim' already migrated.
'tabula' already migrated.
'torque3d' already migrated.
'magit' already migrated.
'aegirproject' already migrated.
'catapultpgh' already migrated.
Migrated 0 tip(s) for 'meteor-active-route'
Migrated 0 tip(s) for 'openlp'
'svg-js' already migrated.
'zed' already migrated.
Migrated 0 tip(s) for 'rtail'
'pylonsproject' already migrated.
'trakt-for-plex' already migrated.
'rubocop' already migrated.
'davorg' already migrated.
'esdiscuss' already migrated.
'image-optim' already migrated.
'nanoc' already migrated.
'rhombus-tech' already migrated.
Migrated 0 tip(s) for 'tech-store-club'
'ucoin' already migrated.
'wdrl' already migrated.
'cpan-book' already migrated.
'dreditor' already migrated.
'gammu' already migrated.
Migrated 0 tip(s) for 'libravatar'
'northern-plains-athletics' already migrated.
'the-charis-project' already migrated.
'josd' already migrated.
Migrated 0 tip(s) for 'kriasoft'
'sqlalchemy' already migrated.
'webtorrent' already migrated.
'simplytest-me' already migrated.
'sailor' already migrated.
'nuvola-player' already migrated.
'debian-lts-by-freexian' already migrated.
'mojolicious' already migrated.
'teampopong' already migrated.
'cpan-io' already migrated.
'cuberite' already migrated.
'doit' already migrated.
'encommuns' already migrated.
'json-resume' already migrated.
'perlweekly' already migrated.
'sudo-room' already migrated.
'devdocs' already migrated.
'exercism' already migrated.
'perl-maven' already migrated.
'pillow' already migrated.
'sudomesh' already migrated.
'the-mountain-spirit' already migrated.
'weblate' already migrated.
'act' already migrated.
'bevry' already migrated.
Migrated 0 tip(s) for 'coala'
Migrated 0 tip(s) for 'kivy'
'citizens-cooperative' already migrated.
'cider' already migrated.
'grip' already migrated.
Migrated 0 tip(s) for 'concrete-clouds'
'duo' already migrated.
'gkz-open-source' already migrated.
'introtopython' already migrated.
'Gratipay' already migrated.
'jshttp' already migrated.
Migrated 0 tip(s) for 'matlab-schemer'
'pariskiwi' already migrated.
Migrated 0 tip(s) for 'piloting-postdevelopment'
'sublimelinter' already migrated.
'totalism-hackbase' already migrated.
'contribkanban-com' already migrated.
'civicrm-lts' already migrated.
Migrated 12 tip(s) for 'webpack'
'endless-parentheses' already migrated.
Migrated 32 tip(s) for 'reddit-enhancement-suite'
Migrated 1 tip(s) for 'dokku'
'cyberpipe' already migrated.
Migrated 0 tip(s) for 'neocities'
Migrated 0 tip(s) for 'jeto'
'jsbin' already migrated.
Done.

[chadwhitacre]

Script started.

[chadwhitacre]

Script ran for two minutes (0:02:03.059495).

[chadwhitacre]

Decline rate is 2 / 45 (4%).

[chadwhitacre]

=> select count(due), sum(due) from current_payment_instructions where due > 0;
┌───────┬─────────┐
│ count │   sum   │
├───────┼─────────┤
│   889 │ 6244.44 │
└───────┴─────────┘
(1 row)

[chadwhitacre]

=> update exchange_routes set fee_cap=20 where fee_cap is null and network='paypal';
UPDATE 27

[chadwhitacre]

I reviewed and approved eight 1.0 payouts.

[chadwhitacre]

Uploaded MassPay. We're only out by $2.04 this week.

[chadwhitacre]

fee_caps updated. MassPay done and posting back ...

[chadwhitacre]

Logs in https://github.com/gratipay/logs/commit/1a47a18409f5258ce61c4116ed990ef724e5bfbc.

[chadwhitacre]

Gonna leave escrow as it stands. Didn't pay out that much this week, and we need to start thinking about where we want money to be for https://github.com/gratipay/gratipay.com/issues/3763 and https://github.com/gratipay/gratipay.com/issues/3539.

[chadwhitacre]

MassPay posted back for 58 users (1 unclaimed, 2 denied).

[chadwhitacre]

New check! :dancer:

Source	Amount ($)	∆ ($)
About > Stats	129,501.89	0.00
Cash in Escrow	132,526.71	3,024.82
Escrow Liabilities	32,103.87	-97,398.02

Those three numbers should be equal, but they're not because #308 isn't done yet. But it's started! :-)