codeforamerica / citygram

Subscribe to your city.
MIT License
170 stars 91 forks source link

Dedupe subscriptions #261

Closed eeeschwartz closed 7 years ago

eeeschwartz commented 7 years ago

Send any thoughts, suggestions my way. Thanks in advance!

For #232

eeeschwartz commented 7 years ago

The rake task is set up to unsubscribe one publisher at a time since I don't assume everyone wants to mess with their data. (e.g. rake subscriptions:deduplicate['Lexington','Code Complaints']

For reference, here are the total duplicate subscriptions per city across email and sms:

City Duplicate subscriptions
Austin 1
Charlotte 13
Lexington 87
New York 3
Raleigh 9
San Francisco 5
Seattle 1
Tulsa 15
eeeschwartz commented 7 years ago

Merging now. This will prevent new duplicate subscriptions.

Let me know if anyone would like to deduplicate existing subscriptions for their city (See duplicate totals by city).