{"width":"100%","height":"190","provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/madogiwa0124/","title":"Ruby on Rails:\u751f\u306eSQL\u3092\u4f5c\u6210(\u76f4\u66f8\u304d)\u3057\u3066\u5b9f\u884c\u3055\u305b\u308b\u65b9\u6cd5","categories":["Ruby on Rails"],"blog_url":"https://madogiwa0124.hatenablog.com/","blog_title":"Madogiwa Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmadogiwa0124.hatenablog.com%2Fentry%2F2017%2F08%2F28%2F000127\" title=\"Ruby on Rails:\u751f\u306eSQL\u3092\u4f5c\u6210(\u76f4\u66f8\u304d)\u3057\u3066\u5b9f\u884c\u3055\u305b\u308b\u65b9\u6cd5 - Madogiwa Blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_name":"madogiwa0124","provider_name":"Hatena Blog","url":"https://madogiwa0124.hatenablog.com/entry/2017/08/28/000127","type":"rich","published":"2017-08-28 00:01:27","image_url":"https://images-fe.ssl-images-amazon.com/images/I/51k5wqPu7jL._SL160_.jpg","description":"\u306f\u3058\u3081\u306b Rails\u306e\u30a2\u30d7\u30ea\u3092\u4f5c\u3063\u3066\u3066\u3001\u8907\u6570TBL\u3092\u7d50\u5408\u3057\u305f\u7d50\u679c\u3092GROUP BY\u3067\u96c6\u8a08\u3059\u308b\u3088\u3046\u306a\u3001\u3061\u3087\u3063\u3068\u8907\u96d1\u306a\u691c\u7d22\u51e6\u7406\u304c\u5fc5\u8981\u3068\u306a\u308a\u751f\u306eSQL\u3092\u5b9f\u884c\u3057\u305f\u304b\u3063\u305f\u306e\u3067\u3001\u305d\u306e\u3084\u308a\u65b9\u3092\u30e1\u30e2\u3057\u307e\u3057\u305f\u03c6(..) \u3084\u308a\u304b\u305f SELECT\u6587\u306e\u5834\u5408\u306f\u3001ActiveRecord::Base.connection.select_all\u306e\u5f15\u6570\u306bSQL\u306e\u6587\u5b57\u5217\u3092\u4e0e\u3048\u3066\u3042\u3052\u308c\u3070OK(/\uff65\u03c9\uff65)/ \u8fd4\u308a\u5024\u3092to_hash\u3057\u3066\u3042\u3052\u308c\u3070\u3001[{\"column1\" => \"hoge1\",\"column2\" => \"hoge2\"},{\"column1\" => \"hoge1\",\"column2\" => \"hoge2\"}...]\u306e\u3088\u3046\u2026","version":"1.0"}