run Gratipay 150

[chadwhitacre]

149

[chadwhitacre]

We should turn off tips to Gratipay for users that were only giving to infinitechan. Surely they don't want to give to Gratipay anymore.

[chadwhitacre]

Reviewed 54 (48) accounts.

[chadwhitacre]

Backup taken and verified.

[chadwhitacre]

Droplet spun up and updated. Still looking at infinitechan tipper tweaks ...

[chadwhitacre]

I count 25 users with tips to both infinitechan and Gratipay. Of those, 7 have a tip to a third user.

[chadwhitacre]

I count 14 users who only gave to infinitechan and Gratipay, who now have a non-zero tip Gratipay.

[chadwhitacre]

We should also issue refunds for their remaining balance, but let's get payday run first.

[chadwhitacre]

Okay, here's the script I came up with:

#!/usr/bin/env python
from decimal import Decimal as D
from gratipay import wireup

env = wireup.env()
db = wireup.db(env)

tippers = db.all("""

select distinct on (p.username) p.*::participants
  from participants p
  join current_tips on tipper=p.username
 where tippee='Gratipay'
   and tipper in (
        select tipper
          from current_tips
         where tippee='infinitechan'
    )

""")

for p in tippers:
    other = [t for t in p.get_current_tips() if t['tippee'] not in ('Gratipay', 'infinitechan')]
    gratip = p.get_tip_to('Gratipay')['amount']
    if len(other) == 0 and gratip > 0:
        print len(other), p.get_tip_to('Gratipay')['amount'], p.username
        p.set_tip_to('Gratipay', D('0.00'))

[chadwhitacre]

Okay, tip to Gratipay zeroed out for 14 users. Refunding infinitechan tippers reticketed as #3342.

[chadwhitacre]

Script started.

[chadwhitacre]

Script ran for 17 minutes (0:17:50.957850).

[chadwhitacre]

Pinned https://twitter.com/Gratipay/status/588807649925451777.

[chadwhitacre]

I'm not sure all the emails went out properly.

[chadwhitacre]

Log downloaded and droplet destroyed.

[chadwhitacre]

MassPay submitted.

[chadwhitacre]

MassPay posted back for 93 users. IRC

[chadwhitacre]

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

[chadwhitacre]

Escrow shuffled.

[chadwhitacre]

Reticketed charge notification emails blockage.

[chadwhitacre]

I guess that's that, eh?