run Gratipay 167

[chadwhitacre]

166

Let's move payday tickets over here to IG: 2370114.

[chadwhitacre]

Okay! Reviewed teams.

[chadwhitacre]

[gratipay] $ heroku config -s | run_dammit /dev/stdin -c ./env/bin/python ./bin/migrate-tips.py
'introtopython' already migrated.
'duo' already migrated.
'sudo-room' already migrated.
'nuvola-player' already migrated.
'cyberpipe' already migrated.
'mojolicious' already migrated.
'pageres' already migrated.
'Gratipay' already migrated.
'citizens-cooperative' already migrated.
'catapultpgh' already migrated.
'sudomesh' already migrated.
'perl-maven' already migrated.
'exercism' already migrated.
'devdocs' already migrated.
'weblate' already migrated.
'sublimelinter' already migrated.
'pillow' already migrated.
'simplytest-me' already migrated.
'json-resume' already migrated.
'encommuns' already migrated.
'perlweekly' already migrated.
'cuberite' already migrated.
'totalism-hackbase' already migrated.
'bevry' already migrated.
'cpan-io' already migrated.
Migrated 0 tip(s) for 'shields'
Migrated 0 tip(s) for 'kivy'
'gammu' already migrated.
Migrated 0 tip(s) for 'knopproject'
'the-charis-project' already migrated.
Migrated 0 tip(s) for 'libravatar'
'debian-lts-by-freexian' already migrated.
'doit' already migrated.
'northern-plains-athletics' already migrated.
'the-mountain-spirit' already migrated.
'jshttp' already migrated.
'aegirproject' already migrated.
Migrated 6 tip(s) for 'josd'
'image-optim' already migrated.
'survivejs' already migrated.
'nanoc' already migrated.
'sailor' already migrated.
'cider' already migrated.
'wdrl' already migrated.
Migrated 0 tip(s) for 'detexify'
'cpan-book' already migrated.
'trakt-for-plex' already migrated.
'act' already migrated.
'esdiscuss' already migrated.
'rhombus-tech' already migrated.
Migrated 0 tip(s) for 'kriasoft'
'jsbin' already migrated.
'ucoin' already migrated.
Migrated 0 tip(s) for 'piloting-postdevelopment'
Migrated 0 tip(s) for 'rtail'
Migrated 0 tip(s) for 'tech-store-club'
'davorg' already migrated.
'zed' already migrated.
Migrated 12 tip(s) for 'dreditor'
Migrated 5 tip(s) for 'svg-js'
'endless-parentheses' already migrated.
'gkz-open-source' already migrated.
Migrated 0 tip(s) for 'matlab-schemer'
'webtorrent' already migrated.
Migrated 169 tip(s) for 'sqlalchemy'
Migrated 1 tip(s) for 'magit'
Migrated 4 tip(s) for 'nim-programming-language'
Migrated 0 tip(s) for 'hamper'
Migrated 1 tip(s) for 'tabula'
Done.

[chadwhitacre]

We'll see what decline rate we get with all of those newly reactivated payments for sqlalchemy.

[chadwhitacre]

Backup taken and verified.

[chadwhitacre]

Script started.

[chadwhitacre]

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

[chadwhitacre]

Um ... where is sqlalchemy?

[chadwhitacre]

The payment_instructions are there.

[chadwhitacre]

Gah! No PayPal. :-(

[chadwhitacre]

gratipay/project-review#11 (comment)

[chadwhitacre]

How many others does this apply to?

[chadwhitacre]

Seven.

    SELECT name
         , owner
         , (SELECT address FROM exchange_routes WHERE participant=p.id AND network='paypal')
      FROM teams t
      JOIN participants p on p.username = t.owner
     WHERE is_approved
  ORDER BY slug_lower;

[chadwhitacre]

Dealing with those seven reticketed as gratipay/gratipay.com#3681.

[chadwhitacre]

I gotta find my phone before I can login to PayPal to run MassPay. Brb ...

[chadwhitacre]

I broke my phone. I bought a new one for $23 but I can't access the Verizon website to activate it. The Verizon store 15 minutes away closes in 30 minutes.

[chadwhitacre]

I was able to activate it by phone.

[chadwhitacre]

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

[chadwhitacre]

MassPay done and posted back for 48 users. One payout failed, and I emailed the user from support.

[chadwhitacre]

Escrow shuffled.

[chadwhitacre]

Logs uploaded in https://github.com/gratipay/logs/commit/6d74a0f33e98cd5f82dbdef9b79938454fa39176.