{"action":"created","issue":{"url":"https://api.github.com/repos/paulmach/go.geo/issues/19","labels_url":"https://api.github.com/repos/paulmach/go.geo/issues/19/labels{/name}","comments_url":"https://api.github.com/repos/paulmach/go.geo/issues/19/comments","events_url":"https://api.github.com/repos/paulmach/go.geo/issues/19/events","html_url":"https://github.com/paulmach/go.geo/pull/19","id":62902612,"number":19,"title":"Add Scan and UnmarshalWKB methods","user":{"login":"paulmach","id":366320,"avatar_url":"https://avatars.githubusercontent.com/u/366320?v=3","gravatar_id":"","url":"https://api.github.com/users/paulmach","html_url":"https://github.com/paulmach","followers_url":"https://api.github.com/users/paulmach/followers","following_url":"https://api.github.com/users/paulmach/following{/other_user}","gists_url":"https://api.github.com/users/paulmach/gists{/gist_id}","starred_url":"https://api.github.com/users/paulmach/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/paulmach/subscriptions","organizations_url":"https://api.github.com/users/paulmach/orgs","repos_url":"https://api.github.com/users/paulmach/repos","events_url":"https://api.github.com/users/paulmach/events{/privacy}","received_events_url":"https://api.github.com/users/paulmach/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-03-19T07:29:17Z","updated_at":"2015-03-20T07:39:03Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/paulmach/go.geo/pulls/19","html_url":"https://github.com/paulmach/go.geo/pull/19","diff_url":"https://github.com/paulmach/go.geo/pull/19.diff","patch_url":"https://github.com/paulmach/go.geo/pull/19.patch"},"body":"Scan implements the [sql.Scanner](http://golang.org/pkg/database/sql/#Scanner) interface allowing points, lines, point sets and paths to be passed into rows.Scan(…interface{}) calls. This simplifies working with the database a long.\r\n\r\nBasically allows you to do stuff like\r\n```\r\nrow := db.QueryRow(\"SELECT AsBinary(point_column) FROM table\")\r\n\r\nvar p *geo.Point\r\nrow.Scan(&p)\r\n```\r\n\r\nNote that you need to wrap the column in `AsBinary`\r\n\r\n@mlerner "},"comment":{"url":"https://api.github.com/repos/paulmach/go.geo/issues/comments/83943732","html_url":"https://github.com/paulmach/go.geo/pull/19#issuecomment-83943732","issue_url":"https://api.github.com/repos/paulmach/go.geo/issues/19","id":83943732,"user":{"login":"paulmach","id":366320,"avatar_url":"https://avatars.githubusercontent.com/u/366320?v=3","gravatar_id":"","url":"https://api.github.com/users/paulmach","html_url":"https://github.com/paulmach","followers_url":"https://api.github.com/users/paulmach/followers","following_url":"https://api.github.com/users/paulmach/following{/other_user}","gists_url":"https://api.github.com/users/paulmach/gists{/gist_id}","starred_url":"https://api.github.com/users/paulmach/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/paulmach/subscriptions","organizations_url":"https://api.github.com/users/paulmach/orgs","repos_url":"https://api.github.com/users/paulmach/repos","events_url":"https://api.github.com/users/paulmach/events{/privacy}","received_events_url":"https://api.github.com/users/paulmach/received_events","type":"User","site_admin":false},"created_at":"2015-03-20T07:39:03Z","updated_at":"2015-03-20T07:39:03Z","body":"Updated as discussed in the previous comment. There are now `NewPointFromWKB`, `NewLineFromWKB`, etc. methods.\r\n\r\nScan now supports WKB or mysqls SRID+WKB encoding. See the updates to the readme for more details. "}}