{"push_id":1285473142,"size":16,"distinct_size":16,"ref":"refs/heads/sorter-db-integration","head":"0ae62b0a3e1e78300f7a4394bc1606cfefa59f95","before":"5204c6bf38e5e47ec9b886c7e52ba3eaa5c8509a","commits":[{"sha":"275cafcf2b70f9fee9fb20038889ead9912d9a94","author":{"name":"redshiftzero","email":"9abf979adbc582de9c203a5a077d53e36227a54c@redshiftzero.com"},"message":"Add database design graphviz diagram","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/275cafcf2b70f9fee9fb20038889ead9912d9a94"},{"sha":"620f688c34b4806c81a7d7b23a577ec8fbb267ff","author":{"name":"redshiftzero","email":"9abf979adbc582de9c203a5a077d53e36227a54c@redshiftzero.com"},"message":"Add libpq-dev to packages that ansible installs","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/620f688c34b4806c81a7d7b23a577ec8fbb267ff"},{"sha":"2ea7e68584f48ac946e542eed0ca8509f642682e","author":{"name":"redshiftzero","email":"9abf979adbc582de9c203a5a077d53e36227a54c@redshiftzero.com"},"message":"Add new options to config.ini","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/2ea7e68584f48ac946e542eed0ca8509f642682e"},{"sha":"6f239f85b041fc425353046fb7d3ecaa2b55e43d","author":{"name":"redshiftzero","email":"9abf979adbc582de9c203a5a077d53e36227a54c@redshiftzero.com"},"message":"Add database upload code","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/6f239f85b041fc425353046fb7d3ecaa2b55e43d"},{"sha":"3d43c33a9589647a32fa0d86755a88eaf1acdb5e","author":{"name":"redshiftzero","email":"9abf979adbc582de9c203a5a077d53e36227a54c@redshiftzero.com"},"message":"Update database.py to use env vars directly","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/3d43c33a9589647a32fa0d86755a88eaf1acdb5e"},{"sha":"c875bb71a811123a5cdc78ae8f888b4b96c4e905","author":{"name":"redshiftzero","email":"9abf979adbc582de9c203a5a077d53e36227a54c@redshiftzero.com"},"message":"Update sorter to enable saving into the database","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/c875bb71a811123a5cdc78ae8f888b4b96c4e905"},{"sha":"d7bb9d8a02699286c6d7a6b07e30f60ef8e13ebb","author":{"name":"redshiftzero","email":"9abf979adbc582de9c203a5a077d53e36227a54c@redshiftzero.com"},"message":"Update pip requirements","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/d7bb9d8a02699286c6d7a6b07e30f60ef8e13ebb"},{"sha":"8e5b937f1d9080555596f79cdf9e6f4e5de41517","author":{"name":"redshiftzero","email":"9abf979adbc582de9c203a5a077d53e36227a54c@redshiftzero.com"},"message":"Add function for processing datetime objects from new config options","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/8e5b937f1d9080555596f79cdf9e6f4e5de41517"},{"sha":"119e40e80e5b5cfb4cd2c11fdede1836ec09dfd6","author":{"name":"redshiftzero","email":"9abf979adbc582de9c203a5a077d53e36227a54c@redshiftzero.com"},"message":"Add tests for new utils","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/119e40e80e5b5cfb4cd2c11fdede1836ec09dfd6"},{"sha":"dca978b7c801832bc22fbb431ad69449277c6ebe","author":{"name":"redshiftzero","email":"9abf979adbc582de9c203a5a077d53e36227a54c@redshiftzero.com"},"message":"Add methods to RawStorage to handle upload of traces to database","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/dca978b7c801832bc22fbb431ad69449277c6ebe"},{"sha":"066f18c37a7c646b1c970557c21bf30f2f84523d","author":{"name":"redshiftzero","email":"9abf979adbc582de9c203a5a077d53e36227a54c@redshiftzero.com"},"message":"Enable crawler to save data to the database","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/066f18c37a7c646b1c970557c21bf30f2f84523d"},{"sha":"94c05bdc622a25f50d92803b8a75835d2a056cec","author":{"name":"Noah Vesely","email":"ce02ba4d7a237f680321aee0b3f02a6b7568fa6b@freedom.press"},"message":"Add database role, fpsd db, raw schema & assoc tables\n\n- Installs and starts PostgresSQL server & initializes the database cluster.\n- Creates the fp_user role, fpsd database, and the raw schema.\n- Creates the crawls, hs_history, frontpage_examples, and frontpage_traces\n  tables for the raw schema.\n- Creates a random password for the fp_user and saves it to a PGPASSFILE.\n  - Documents the creation of this file in the README.","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/94c05bdc622a25f50d92803b8a75835d2a056cec"},{"sha":"ab64e693fd5e12420ef2630082d160abf63ba9ce","author":{"name":"Noah Vesely","email":"ce02ba4d7a237f680321aee0b3f02a6b7568fa6b@freedom.press"},"message":"Ensure idempotency of db initialization tasks\n\nIf /etc/passwordfile is no longer on the controller this makes sure:\n- fp_user is not re-created with new password.\n- The password file on the remote host is not modified.","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/ab64e693fd5e12420ef2630082d160abf63ba9ce"},{"sha":"c5ced04375a76e066e952242c01ea8d6e69ea36a","author":{"name":"Noah Vesely","email":"ce02ba4d7a237f680321aee0b3f02a6b7568fa6b@freedom.press"},"message":"Ensure pip updates Python packages when versions change\n\nIf a package is already installed to the target environment, pip will not\nupgrade/ downgrade that package (even if a different version is requested than\nis already installed) unless the -U/--upgrade option is passed. I confirmed in\nthe Ansible pip module source code that specifying the state=latest parameter\ndoes pass the -U option when installing packages.","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/c5ced04375a76e066e952242c01ea8d6e69ea36a"},{"sha":"9b3e9cf66883fc9355692397b8129c8557780334","author":{"name":"Noah Vesely","email":"ce02ba4d7a237f680321aee0b3f02a6b7568fa6b@freedom.press"},"message":"Simplify and best-practices-ify pip update script","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/9b3e9cf66883fc9355692397b8129c8557780334"},{"sha":"0ae62b0a3e1e78300f7a4394bc1606cfefa59f95","author":{"name":"redshiftzero","email":"9abf979adbc582de9c203a5a077d53e36227a54c@redshiftzero.com"},"message":"Update README","distinct":true,"url":"https://api.github.com/repos/freedomofpress/FingerprintSecureDrop/commits/0ae62b0a3e1e78300f7a4394bc1606cfefa59f95"}]}
{"actor":{"display_login":"redshiftzero"}}