{"action":"closed","issue":{"url":"https://api.github.com/repos/YupItsZac/FreeGeoAPI/issues/17","labels_url":"https://api.github.com/repos/YupItsZac/FreeGeoAPI/issues/17/labels{/name}","comments_url":"https://api.github.com/repos/YupItsZac/FreeGeoAPI/issues/17/comments","events_url":"https://api.github.com/repos/YupItsZac/FreeGeoAPI/issues/17/events","html_url":"https://github.com/YupItsZac/FreeGeoAPI/issues/17","id":120593011,"number":17,"title":"Remove raw SQL","user":{"login":"YupItsZac","id":6219957,"avatar_url":"https://avatars.githubusercontent.com/u/6219957?v=3","gravatar_id":"","url":"https://api.github.com/users/YupItsZac","html_url":"https://github.com/YupItsZac","followers_url":"https://api.github.com/users/YupItsZac/followers","following_url":"https://api.github.com/users/YupItsZac/following{/other_user}","gists_url":"https://api.github.com/users/YupItsZac/gists{/gist_id}","starred_url":"https://api.github.com/users/YupItsZac/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/YupItsZac/subscriptions","organizations_url":"https://api.github.com/users/YupItsZac/orgs","repos_url":"https://api.github.com/users/YupItsZac/repos","events_url":"https://api.github.com/users/YupItsZac/events{/privacy}","received_events_url":"https://api.github.com/users/YupItsZac/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/YupItsZac/FreeGeoAPI/labels/code-enhancement","name":"code-enhancement","color":"006b75"},{"url":"https://api.github.com/repos/YupItsZac/FreeGeoAPI/labels/needs-investigation","name":"needs-investigation","color":"5319e7"},{"url":"https://api.github.com/repos/YupItsZac/FreeGeoAPI/labels/next-release","name":"next-release","color":"207de5"}],"state":"closed","locked":false,"assignee":{"login":"YupItsZac","id":6219957,"avatar_url":"https://avatars.githubusercontent.com/u/6219957?v=3","gravatar_id":"","url":"https://api.github.com/users/YupItsZac","html_url":"https://github.com/YupItsZac","followers_url":"https://api.github.com/users/YupItsZac/followers","following_url":"https://api.github.com/users/YupItsZac/following{/other_user}","gists_url":"https://api.github.com/users/YupItsZac/gists{/gist_id}","starred_url":"https://api.github.com/users/YupItsZac/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/YupItsZac/subscriptions","organizations_url":"https://api.github.com/users/YupItsZac/orgs","repos_url":"https://api.github.com/users/YupItsZac/repos","events_url":"https://api.github.com/users/YupItsZac/events{/privacy}","received_events_url":"https://api.github.com/users/YupItsZac/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/YupItsZac/FreeGeoAPI/milestones/1","html_url":"https://github.com/YupItsZac/FreeGeoAPI/milestones/V1%20Lauch","labels_url":"https://api.github.com/repos/YupItsZac/FreeGeoAPI/milestones/1/labels","id":1445564,"number":1,"title":"V1 Lauch","description":"This is the first public, stable version of the API. This release is expected to include major bugfixes, functionality improvement, new functionality implementation and better documentation. ","creator":{"login":"YupItsZac","id":6219957,"avatar_url":"https://avatars.githubusercontent.com/u/6219957?v=3","gravatar_id":"","url":"https://api.github.com/users/YupItsZac","html_url":"https://github.com/YupItsZac","followers_url":"https://api.github.com/users/YupItsZac/followers","following_url":"https://api.github.com/users/YupItsZac/following{/other_user}","gists_url":"https://api.github.com/users/YupItsZac/gists{/gist_id}","starred_url":"https://api.github.com/users/YupItsZac/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/YupItsZac/subscriptions","organizations_url":"https://api.github.com/users/YupItsZac/orgs","repos_url":"https://api.github.com/users/YupItsZac/repos","events_url":"https://api.github.com/users/YupItsZac/events{/privacy}","received_events_url":"https://api.github.com/users/YupItsZac/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":7,"state":"open","created_at":"2015-12-05T15:15:56Z","updated_at":"2015-12-23T17:18:26Z","due_on":"2015-12-30T23:00:00Z","closed_at":null},"comments":1,"created_at":"2015-12-05T22:38:21Z","updated_at":"2015-12-23T17:18:26Z","closed_at":"2015-12-23T17:18:26Z","body":"All raw SQL should be removed from the API controller (and anywhere else it may be). We should use some ORM (like Doctrine) for building queries. \r\n\r\nNote: This may be tricky with the various geospatial functions these queries use. Will investigate. "}}