Rails(ActiveRecord)ã§è‡ªåœ¨ã«SQLを書ã手段ã„ã‚ã„ã‚ã“ã‚“ã«ã¡ã¯ãƒ¼ã€‚ Railsã§ã‚る程度ã®è¦æ¨¡ã®é–‹ç™ºã‚’ã—ã¦ã„ã‚‹ã¨ã€ã¡ã‚‡ã£ã¨è¾¼ã¿å…¥ã£ãŸå½¢ã®SQLã§ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã—ãŸã„状æ³ãŒç™ºç”Ÿã—ã¦ãã¾ã™ã€‚ 今回ã¯ã€ãã‚“ãªã¨ãã«å½¹ç«‹ã¤ActiveRecordクエリã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ã”紹介ã—ã¾ã™ã€‚ ã¡ãªã¿ã«execute()ã€arelã¯ä½¿ã„ã¾ã›ã‚“。 （環境: Ruby 2.5.3, Rails 6.1.3） selectをゴリゴリ書ã ActiveRecordã®selectã¨ã„ã†ãƒ¡ã‚½ãƒƒãƒ‰ãŒã‚ã‚Šã¾ã™ã€‚ 基本的ãªä½¿ã„æ–¹ã¨ã—ã¦ã¯ã€ã“ã‚“ãªæ„Ÿã˜ã§ã€å¿…è¦ãªã‚«ãƒ©ãƒ ã ã‘å–å¾—ã™ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã™ã€‚ users = User.all.select(:id, :name) users.first.attributes # => {"id"=>1, "name"=>"Alice"} ãªã‚“ã§ã™ãŒã€SELECTå¥ã‚’æ–‡å—列ã§å¥½ãã«æ›¸ãã“ã¨ã‚‚ã§ãã¾ã™ã€‚別åを付ã‘ã¦ãŠãã“ã¨ã§ã€ãã®åå‰ã§å€¤ã‚’å–å¾—ã§ãã¾ã™
Railsã®ç”ŸSQL概è¦ï¼šexecute, select_all, find_by_sqlã®ä½¿ã„方を覚ãˆã‚‹ - Qiita
MySQLã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®è¿½åŠ ・確èªãƒ»å‰Šé™¤ã‚’è¡Œã†æ–¹æ³• - プãƒã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢
[MySQL Workbench] VISUAL EXPLAIN ã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æŒ™å‹•ã‚’確èªã™ã‚‹![[MySQL Workbench] VISUAL EXPLAIN ã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æŒ™å‹•ã‚’確èªã™ã‚‹](https://cdn-ak-scissors.b.st-hatena.com/image/square/c361eb0b9ed35a0934d2f7c1e008d4330adf3c7c/height=288;version=1;width=512/https%3A%2F%2Fvos.line-scdn.net%2Flandpress-content-v2_1761%2F1666852622685.png%3FupdatedAt%3D1666852623000)
Gboard ãƒãƒ¼ãƒ ã‹ã‚‰ã®æ–°ã—ã„ã”æ案
{{#tags}}- {{label}}
{{/tags}}