Allow similarity computation to be filtered by cause area

vipulnaik / donations

Donations list website (DLW): a repository for keeping track of public donations by some people I (arbitrarily) decide to track

https://donations.vipulnaik.com

Creative Commons Zero v1.0 Universal

20 stars 2 forks source link

Allow similarity computation to be filtered by cause area #10

Closed riceissa closed 6 years ago

riceissa commented 7 years ago

Example of where this is needed: https://donations.vipulnaik.com/donor.php?donor=Open+Philanthropy+Project&cause_area_filter=Criminal+justice+reform#donorSimilarDonors

Currently, list of donations is filtered by the cause area, but the similarity computation is done over all cause areas rather than just criminal justice reform.

riceissa commented 6 years ago

This is now working, I think.

For changes to the database, see:

non-incremental version, run once: similarity-4.sql
incremental version, run each time a donor's donations are updated by calling the procedure with the donor name (example call at the bottom of the file): similarity-incremental-cause-area.sql

See 191d2b21077c97c02fd86e5dd19008fa114595e8 for the change in PHP.