{"action":"created","issue":{"url":"https://api.github.com/repos/gratipay/gratipay.com/issues/2779","labels_url":"https://api.github.com/repos/gratipay/gratipay.com/issues/2779/labels{/name}","comments_url":"https://api.github.com/repos/gratipay/gratipay.com/issues/2779/comments","events_url":"https://api.github.com/repos/gratipay/gratipay.com/issues/2779/events","html_url":"https://github.com/gratipay/gratipay.com/issues/2779","id":43660941,"number":2779,"title":"backfill the `status` and `route` columns of the `exchanges` table","user":{"login":"whit537","id":134455,"avatar_url":"https://avatars.githubusercontent.com/u/134455?v=3","gravatar_id":"","url":"https://api.github.com/users/whit537","html_url":"https://github.com/whit537","followers_url":"https://api.github.com/users/whit537/followers","following_url":"https://api.github.com/users/whit537/following{/other_user}","gists_url":"https://api.github.com/users/whit537/gists{/gist_id}","starred_url":"https://api.github.com/users/whit537/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/whit537/subscriptions","organizations_url":"https://api.github.com/users/whit537/orgs","repos_url":"https://api.github.com/users/whit537/repos","events_url":"https://api.github.com/users/whit537/events{/privacy}","received_events_url":"https://api.github.com/users/whit537/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/gratipay/gratipay.com/labels/Ready%20to%20Start","name":"Ready to Start","color":"eeeeee"},{"url":"https://api.github.com/repos/gratipay/gratipay.com/labels/%E2%98%85%E2%98%85%E2%98%85","name":"★★★","color":"339966"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/gratipay/gratipay.com/milestones/11","html_url":"https://github.com/gratipay/gratipay.com/milestones/Balanced%20Shutdown","labels_url":"https://api.github.com/repos/gratipay/gratipay.com/milestones/11/labels","id":1037902,"number":11,"title":"Balanced Shutdown","description":"http://blog.balancedpayments.com/shutting-down","creator":{"login":"Changaco","id":1581590,"avatar_url":"https://avatars.githubusercontent.com/u/1581590?v=3","gravatar_id":"","url":"https://api.github.com/users/Changaco","html_url":"https://github.com/Changaco","followers_url":"https://api.github.com/users/Changaco/followers","following_url":"https://api.github.com/users/Changaco/following{/other_user}","gists_url":"https://api.github.com/users/Changaco/gists{/gist_id}","starred_url":"https://api.github.com/users/Changaco/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Changaco/subscriptions","organizations_url":"https://api.github.com/users/Changaco/orgs","repos_url":"https://api.github.com/users/Changaco/repos","events_url":"https://api.github.com/users/Changaco/events{/privacy}","received_events_url":"https://api.github.com/users/Changaco/received_events","type":"User","site_admin":false},"open_issues":17,"closed_issues":48,"state":"open","created_at":"2015-03-25T10:10:33Z","updated_at":"2015-10-05T17:48:10Z","due_on":"2015-10-09T04:00:00Z","closed_at":null},"comments":49,"created_at":"2014-09-23T17:49:10Z","updated_at":"2015-10-05T18:16:46Z","closed_at":null,"body":"Right now the `exchanges.status` column has NULL values. It would be great to constrain that column to non-NULL, but it would take some effort with the Balanced API to determine the proper value for previous exchanges. [IRC](https://botbot.me/freenode/gratipay/2014-09-23/?msg=22175953&page=2)\r\n\r\n<bountysource-plugin>\r\n---\r\nWant to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/4689324-backfill-the-status-and-route-columns-of-the-exchanges-table?utm_campaign=plugin&utm_content=tracker%2F85909&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F85909&utm_medium=issues&utm_source=github).\r\n</bountysource-plugin>"},"comment":{"url":"https://api.github.com/repos/gratipay/gratipay.com/issues/comments/145620740","html_url":"https://github.com/gratipay/gratipay.com/issues/2779#issuecomment-145620740","issue_url":"https://api.github.com/repos/gratipay/gratipay.com/issues/2779","id":145620740,"user":{"login":"whit537","id":134455,"avatar_url":"https://avatars.githubusercontent.com/u/134455?v=3","gravatar_id":"","url":"https://api.github.com/users/whit537","html_url":"https://github.com/whit537","followers_url":"https://api.github.com/users/whit537/followers","following_url":"https://api.github.com/users/whit537/following{/other_user}","gists_url":"https://api.github.com/users/whit537/gists{/gist_id}","starred_url":"https://api.github.com/users/whit537/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/whit537/subscriptions","organizations_url":"https://api.github.com/users/whit537/orgs","repos_url":"https://api.github.com/users/whit537/repos","events_url":"https://api.github.com/users/whit537/events{/privacy}","received_events_url":"https://api.github.com/users/whit537/received_events","type":"User","site_admin":false},"created_at":"2015-10-05T18:16:46Z","updated_at":"2015-10-05T18:16:46Z","body":"Haven't even touched refunds, or bank deposits or reversals yet. We don't actually need those in order to be able to issue refunds against Balanced this week, which is our primary objective atm."}}