Vipul Naik Donations Database

vipulnaik
 
 / 
 
 donations 
 

 Public 
 

 

 
 
 
 

 
 
 
 Notifications
 You must be signed in to change notification settings 

 

 
 
 
 Fork
 2 
 
 

 
 
 
 
 
 Star
 21 
 
 

 

 
 

 
 

 

 
 

 
 
 

 
 
 

 
 
 
 master Branches Tags Go to file Code Open more actions menu Latest commit

   History

 2,463 Commits 2,463 Commits Folders and files

 Name Name Last commit message Last commit date access-portal access-portal     cause-area-guidance cause-area-guidance     dedup-donees dedup-donees     disclosure-calculations disclosure-calculations     python python     similarity similarity     sql sql     .gitignore .gitignore     LICENSE LICENSE     Makefile Makefile     README.md README.md     TODO.md TODO.md     classified-and-unclassified.md classified-and-unclassified.md     data-update-playbook.md data-update-playbook.md     gates-foundation-maps.txt gates-foundation-maps.txt     google-org-discrepancies-to-resolve.txt google-org-discrepancies-to-resolve.txt     View all files Repository files navigation

 Donations list website (DLW)

 
 Available at https://donations.vipulnaik.com but still in beta!

 Note that the passwordFile.inc file in access-portal/backend/globalVariables is excluded from the Git repository, but you can see a corresponding dummy password file at dummyPasswordFile.inc .

 Setting up

 
 From the shell run (note this will create and read into a donations database,
so be careful if you already have a database with that name):

 make init && make read && make reset_similarity
 
 If you need to pass in arguments to mysql , use the MYSQL_ARGS variable:

 make read MYSQL_ARGS="-u user -psecret"
 
 After modifying the SQL instructions, use reset to drop the tables:

 make reset && make read
 
 Once the database is ready, you can run the site locally:

 cp access-portal/backend/globalVariables/{dummyPasswordFile.inc,passwordFile.inc}
vi access-portal/backend/globalVariables/passwordFile.inc # change to add database login info
cd access-portal
php -S localhost:8000
 
 Now you can visit http://localhost:8000/index.php in your browser.

 To show the similarity table, the values must be precomputed. To do that, first
run (this only needs to be run once):

 make reset_similarity
 
 Then each time the donations data changes, run:

 make compute_similarity
 
 For table sorting:

 make fetch_table_sorting
 
 This will fetch the necessary files to allow tables to be sorted.
To remove these files, run make clean_table_sorting .

 For AnchorJS :

 make fetch_anchorjs
 
 To remove AnchorJS, run make clean_anchorjs .

 Tutorial

 
 This section is a tutorial of the main features of Donations List Website
(DLW), with a focus on the parts that are probably non-obvious to casual users.

 Main page

 
 The main page of DLW shows information
aggregated from all donations tracked by the site.
The main page has the path starting with / or /index.php .

 The main page of DLW has an optional parameter called display that changes
the kin

... (truncated, 8 KB total)