{"action":"created","issue":{"url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/358","repository_url":"https://api.github.com/repos/fsprojects/SQLProvider","labels_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/358/labels{/name}","comments_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/358/comments","events_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/358/events","html_url":"https://github.com/fsprojects/SQLProvider/pull/358","id":187988501,"number":358,"title":"Initial version of GroupBy working.","user":{"login":"Thorium","id":229355,"avatar_url":"https://avatars.githubusercontent.com/u/229355?v=3","gravatar_id":"","url":"https://api.github.com/users/Thorium","html_url":"https://github.com/Thorium","followers_url":"https://api.github.com/users/Thorium/followers","following_url":"https://api.github.com/users/Thorium/following{/other_user}","gists_url":"https://api.github.com/users/Thorium/gists{/gist_id}","starred_url":"https://api.github.com/users/Thorium/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Thorium/subscriptions","organizations_url":"https://api.github.com/users/Thorium/orgs","repos_url":"https://api.github.com/users/Thorium/repos","events_url":"https://api.github.com/users/Thorium/events{/privacy}","received_events_url":"https://api.github.com/users/Thorium/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2016-11-08T13:13:52Z","updated_at":"2016-12-23T14:31:19Z","closed_at":"2016-12-22T20:22:37Z","pull_request":{"url":"https://api.github.com/repos/fsprojects/SQLProvider/pulls/358","html_url":"https://github.com/fsprojects/SQLProvider/pull/358","diff_url":"https://github.com/fsprojects/SQLProvider/pull/358.diff","patch_url":"https://github.com/fsprojects/SQLProvider/pull/358.patch"},"body":"Simple version of group-by done. \r\nNo join and multi-column-key-support yet.\r\n\r\nThis kind of simple group-by works:\r\n\r\n```fsharp\r\n[<Test>]\r\nlet ``verify groupBy results``() = \r\n    let dc = sql.GetDataContext()\r\n    let enumtest =\r\n        query {\r\n            for cust in dc.Main.Customers do\r\n            select (cust)\r\n        } |> Seq.toList\r\n    let inlogics = \r\n        query {\r\n            for cust in enumtest do\r\n            groupBy cust.City into c\r\n            select (c.Key, c.Count())\r\n        } |> Seq.toArray |> Array.sortBy (fun (k,v) -> k )\r\n\r\n    let groupqry = \r\n        query {\r\n            for cust in dc.Main.Customers do\r\n            groupBy cust.City into c\r\n            select (c.Key, c.Count())\r\n        } |> Seq.toArray |> Array.sortBy (fun (k,v) -> k )\r\n\r\n    CollectionAssert.AreEqual(inlogics,groupqry)\r\n```"},"comment":{"url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/comments/268998062","html_url":"https://github.com/fsprojects/SQLProvider/pull/358#issuecomment-268998062","issue_url":"https://api.github.com/repos/fsprojects/SQLProvider/issues/358","id":268998062,"user":{"login":"pezipink","id":2384821,"avatar_url":"https://avatars.githubusercontent.com/u/2384821?v=3","gravatar_id":"","url":"https://api.github.com/users/pezipink","html_url":"https://github.com/pezipink","followers_url":"https://api.github.com/users/pezipink/followers","following_url":"https://api.github.com/users/pezipink/following{/other_user}","gists_url":"https://api.github.com/users/pezipink/gists{/gist_id}","starred_url":"https://api.github.com/users/pezipink/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pezipink/subscriptions","organizations_url":"https://api.github.com/users/pezipink/orgs","repos_url":"https://api.github.com/users/pezipink/repos","events_url":"https://api.github.com/users/pezipink/events{/privacy}","received_events_url":"https://api.github.com/users/pezipink/received_events","type":"User","site_admin":false},"created_at":"2016-12-23T14:31:19Z","updated_at":"2016-12-23T14:31:19Z","body":"Sorry @Thorium I did not manage to look at this properly, you know what this time of year is like!  I'm sure it is great though, still intend to have a look in the near future ...."}}
{"actor":{"display_login":"pezipink"}}