[B! activerecord] june29ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

june29 id:june29

activerecordã«é–¢ã™ã‚‹june29ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (39)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ActiveRecordã®includes, preload, eager_load ã®å€‹äººçš„ãªä½¿ã„åˆ†ã‘ - Money Forward Developers Blog
ãƒžãƒãƒ¼ãƒ•ã‚©ãƒ¯ãƒ¼ãƒ‰ç¦å²¡æ‹ ç‚¹ã®è²¬ä»»è€…ã‚’ã—ã¦ãŠã‚Šã¾ã™ é»’ç”° ã§ã™ã€‚ æ™®æ®µã¯Rails ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ ãƒžãƒãƒ¼ãƒ•ã‚©ãƒ¯ãƒ¼ãƒ‰ã‚¯ãƒ©ã‚¦ãƒ‰çµŒè²» ã®é–‹ç™ºã‚’æ‹…å½“ã—ã¦ã„ã¾ã™ã€‚ æ™®æ®µRailsã‚’ä½¿ã£ã¦é–‹ç™ºã•ã‚Œã¦ã„ã‚‹æ–¹ã§ã‚ã‚Œã°ã€N+1å•é¡Œã«æ‚©ã¾ã•ã‚ŒãŸçµŒé¨“ã¯å¤§æŠµã®æ–¹ãŒãŠã‚ã‚Šã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ N+1ãªã‚¯ã‚¨ãƒªã®ç™ºè¦‹ã«ã¯ bullet ã‚’ä½¿ã†ã¨è‰¯ã„ã§ã™ãã€‚ bulletã‚’ä½¿ã†ã¨N+1ãªã‚¯ã‚¨ãƒªã‚’ç™ºè¦‹ã—ã¦ãã‚Œã€ã•ã‚‰ã«ã€å…·ä½“çš„ã«ã“ã“ã«includesã‚’è¿½åŠ ã—ãªã•ã„ã¨æŒ‡æ‘˜ã¾ã§ã—ã¦ãã‚Œã‚‹ã®ã§å¤§å¤‰åŠ©ã‹ã‚Šã¾ã™ã€‚ ã—ã‹ã—ã€å…ˆæ—¥bulletã«è¨€ã‚ã‚Œã‚‹ãŒã¾ã¾ã«includesã‚’ä»˜ã‘ã¦ã¿ãŸã¨ã“ã‚ã€N+1ã¯è§£æ¶ˆã—ãŸã‚‚ã®ã®ã€ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã«è¦‹èˆžã‚ã‚Œã‚‹ã“ã¨ã¨ãªã£ãŸã®ã§ã€includes,preload, eager_loadã«ã¤ã„ã¦æ”¹ã‚ã¦èª¿ã¹ã¦ã¾ã¨ã‚ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ï¼ˆã‚½ãƒ¼ã‚¹èª¿æŸ»ã—ãŸRailsã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 6.0.0.beta3 ã§ã™ã€‚ï¼‰ i
june29 2019/04/02
rails

activerecord
ãƒªãƒ³ã‚¯
ankane/strong_migrations: Catch unsafe migrations at dev time
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
june29 2017/09/24
rails

activerecord

migration
ãƒªãƒ³ã‚¯
Rails SQL Injection Examples
Overview The Ruby on Rails web framework provides a library called ActiveRecord which provides an abstraction for accessing databases. This page lists many query methods and options in ActiveRecord which do not sanitize raw SQL arguments and are not intended to be called with unsafe user input. Careless use of these methods can open up code to SQL Injection exploits. The examples here do not inclu
june29 2017/01/12
rails

activerecord

sql

security
ãƒªãƒ³ã‚¯
GitHub - barkbox/cursor: Simple cursor pagination
june29 2016/04/26
cursor åž‹ã®ãƒšãƒ¼ã‚¸ãƒãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®Ÿç¾ã™ã‚‹ã€‚

rails

activerecord
ãƒªãƒ³ã‚¯
GitHub - soundcloud/lhm: Online MySQL schema migrations
Rails style database migrations are a useful way to evolve your data schema in an agile manner. Most Rails projects start like this, and at first, making changes is fast and easy. That is until your tables grow to millions of records. At this point, the locking nature of ALTER TABLE may take your site down for an hour or more while critical tables are migrated. In order to avoid this, developers b
june29 2016/04/19
soundcloud

mysql

migration

activerecord
ãƒªãƒ³ã‚¯
auto-explain-on-activerecord.rb
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
june29 2016/04/18
rails

activerecord

sql
ãƒªãƒ³ã‚¯
Rails5ã‹ã‚‰ä½¿ãˆã‚‹ActiveRecordä¾¿åˆ©æ©Ÿèƒ½ - Qiita
Railsã®ChangeLogã‚’èªã‚“ã§ã„ãŸã‚‰kamipoã•ã‚“ã® ActiveRecordã¸ã®ã‚³ãƒŸãƒƒãƒˆãŒRails5ã‹ã‚‰ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ã¦ã‚‹ã‚‚ã®ãŒãŸãã•ã‚“ã‚ã£ãŸã®ã§ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ PostgreSQLã§Expression Indexã¨Operator Classã‚’ã‚µãƒãƒ¼ãƒˆ MySQLã§Prepared statesmentsã‚’ã‚µãƒãƒ¼ãƒˆ config/database.ymlã§prepared_statements: trueã¨ã™ã‚‹ã¨åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚mysql2 0.4.4ä»¥é™ãŒå°Žå…¥ã•ã‚Œã¦ã„ãªã„ã¨ä½¿ãˆãªã„ã‚ˆã†ã§ã™ã€‚ Schema dumperãŒcreate_tableãƒ–ãƒãƒƒã‚¯ã®ä¸ã§indexã‚’å®šç¾©ã™ã‚‹ã‚ˆã†ã«ãªã£ãŸ schema.rbã®create_tableã®ãƒ–ãƒãƒƒã‚¯å†…ã§t.indexã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒå®šç¾©ã•ã‚Œã‚‹ã‚ˆã†ã«å¤‰æ›´ã•ã‚Œã¦ã„ã¾ã™ã€‚ä»¥å‰ã¯create_tableã®ãƒ–ãƒãƒƒã‚¯å¤–ã§
june29 2016/04/05
rails

rails5

mysql

activerecord
ãƒªãƒ³ã‚¯
shibaraku gem ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸ - onk.ninja
shibaraku gem ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸ ã“ã‚Œã¯ä½•ï¼Ÿ ActiveRecord ã§æœŸé–“ã‚’æŒã¤ model ã‚’æ‰±ã† gem ã§ã™ã€‚æœŸé–“é™å®šå…¬é–‹ã‚„ã€äºˆç´„å…¬é–‹ã—ãŸã„ã¨ããªã‚“ã‹ã«ä½¿ã„ã¾ã™ã€‚ ä½œã£ãŸã®ã¯ 1 å¹´å‰ãªã‚“ã§ã™ãŒã€ãšã£ã¨ç¤¾å†… gem ã¨ã—ã¦ä½¿ç”¨ã—ã¦ã„ãŸã‚‚ã®ã‚’ rubygems.org / github.com ã«ä¸Šã’ã¾ã—ãŸã€‚ https://rubygems.org/gems/shibaraku https://github.com/onk/shibaraku USAGE åŸºæœ¬çš„ãªä½¿ã„æ–¹ start_at, end_at ã®ã‚ã‚‹ãƒ¢ãƒ‡ãƒ«ã‚’ç”¨æ„ã—ã¾ã™ã€‚ create_table :campaigns do |t| t.datetime :start_at t.datetime :end_at end shibaraku ã¨ 1 è¡Œæ›¸ãã¨ class Campaign < ActiveRe
june29 2015/11/07
ã€Œã‚ãƒ©ã‚ãƒ©ãƒãƒ¼ãƒ ãŒæ°—ã«ãªã£ã¦ã€‚ã€‚ã€ã„ã„è©±

ruby

activerecord
ãƒªãƒ³ã‚¯
countã˜ã‚ƒãªãã¦sizeã‚’ä½¿ã£ãŸæ–¹ãŒã„ã„!! ã‚¢ã‚½ã‚·ã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ãŒLoadã•ã‚Œã¦ã‚‹ã‹èª¿ã¹ã¦å¸¸ã«é«˜é€Ÿãªãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½œã‚ã†ï¼ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
june29 2015/09/30
count ã¨ size ã®ä½¿ã„åˆ†ã‘é›£ã—ã„ãžï¼

rails

activerecord

ruby
ãƒªãƒ³ã‚¯
Rails ã®ãƒãƒªãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ç‰¹å®šã®ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆã€Œä»¥å¤–ã€ã§å®Ÿè¡Œã•ã›ã‚‹ | Webã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºï¼æ•™è‚²ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¿ã‚¤ãƒ ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ¡ãƒ‡ã‚£ã‚¢
Rails ã®ãƒãƒªãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¯ç‰¹å®šã®ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆã®ã¨ãã ã‘å®Ÿè¡Œã•ã›ã‚‹ã“ã¨ãŒã§ãã‚‹ on ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒå˜åœ¨ã—ã¦ã„ã‚‹ã€‚ validates :field1, presence: true validates :field2, presence: true validates :field3, presence: true, on: :admin ã“ã†ã™ã‚‹ã¨ã€ valid?(:admin) ã®ã¨ãã ã‘ã¯å…¨ã¦ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãŒå¿…é ˆå…¥åŠ›ã¨ãªã‚‹ãŒã€ãã†ã§ãªã„å ´åˆã¯ field1ã€field2 ã®ã¿å¿…é ˆã¨ãªã‚Šã€ field3 ã¯ä»»æ„å…¥åŠ›ã«ãªã‚‹ã€‚ãªã‚‹ã»ã©ã€ä¾¿åˆ©ã ã€‚ ã¨ã“ã‚ãŒã€ã“ã‚Œã‚’é€†è»¢ã•ã›ãŸã„ã¨ãã€å³ã¡ :admin ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆã®ã¨ãã€Œã ã‘ã€field3 ã‚’ä»»æ„å…¥åŠ›ã«ã—ãŸã„ã¨ãªã‚‹ã¨ã€é€”ç«¯ã«é¢å€’ãªã“ã¨ã«ãªã‚‹ã€‚ validates :field1, presence: true validates :fiel
june29 2015/09/14
on ã‚ã£ãŸã‚‰ off ã‚‚ã—ãã¯ãã‚Œã«é¡žã™ã‚‹ä½•ã‹ãŒæ¬²ã—ããªã£ã¦ã—ã¾ã†æ°—æŒã¡ã¯ã‚ã‹ã‚‹ã€‚

rails

activerecord
ãƒªãƒ³ã‚¯
Loading...
june29 2015/06/30
scope ã‚’ä¸€ç®‡æ‰€ã«ã¾ã¨ã‚ã¦æ›¸ã„ã¦ãŠãã¨è¦‹é€šã—ãŒã‚ˆããªã‚‹ã€ã£ã¦ã„ã†ç´°ã‹ã„ç‚¹ã‚‚å¥½ãã§ã™ã€‚

rails

activerecord
ãƒªãƒ³ã‚¯
ActiveRecord + SQLite3 ã‚’ä½¿ã† - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
june29 2015/06/10
ã“ã‚ŒãŒæœ€å°ã‚³ãƒ¼ãƒ‰ã£ã½ã„ã€‚

activerecord

sqlite3
ãƒªãƒ³ã‚¯
ActiveRecordã®èªã¿è¾¼ã¿ãŒå®Ÿéš›ã«ãƒˆãƒªã‚¬ãƒ¼ã•ã‚ŒãŸå ´æ‰€ã‚’ãƒã‚°ã«è¨˜éŒ²ã™ã‚‹gem - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
june29 2015/04/17
ruby

activerecord
ãƒªãƒ³ã‚¯
ãƒ¦ãƒ¼ã‚¶ã¨ãƒ¦ãƒ¼ã‚¶ã‚’å¤šå¯¾å¤šã§é–¢é€£ä»˜ã‘ã‚‹ãƒ¢ãƒ‡ãƒ«ã‚’å…±é€šåŒ–ã™ã‚‹ - Hidden in Plain Sight
æ€ã„ã®ã»ã‹å‰å›žã®Railsãƒ—ãƒãƒ»ãƒ‡ã‚¶ã‚¤ãƒ³ãƒ‘ã‚¿ãƒ¼ãƒ³ã®ç´¹ä»‹ã«åå¿œãŒã‚ã£ãŸã®ã§ã€ã“ã†ã„ã†å°ãƒã‚¿ã‚‚å‡ºã—ã¦ã„ã£ãŸã»ã†ãŒã„ã„ã®ã‹ãªã€ã¨ã„ã†ã“ã¨ã§ç¬¬äºŒå¼¾ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ç³»ã‚¢ãƒ—ãƒªã ã¨ã€ãƒ¦ãƒ¼ã‚¶ã¨ãƒ¦ãƒ¼ã‚¶ã‚’é–¢é€£ä»˜ã‘ã‚‹å¤šå¯¾å¤šã®ãƒ¢ãƒ‡ãƒ«ãŒãŸãã•ã‚“ã§ã¦ãã¾ã™ã€‚ãŸã¨ãˆã°ã€ä¸€èˆ¬çš„ãªã¨ã“ã‚ã§ã¯ãƒ•ã‚©ãƒãƒ¼ã¨ã‹ãƒ–ãƒãƒƒã‚¯ã¨ã‹è¶³ã‚ã¨ã¨ã‹ã€‚ã•ã‚‰ã«ãƒ‡ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã‚µã‚¤ãƒˆã«ãªã‚‹ã¨ã€ã‚¦ã‚£ãƒ³ã‚¯ã ã£ãŸã‚Šã€Secret admirerï¼ˆã“ã£ãã‚Šlikeã™ã‚‹ã‘ã©ä¸¡æ€ã„ã ã£ãŸã‚‰ãŠã‚ã§ã¨ã†ã£ã¦é€šçŸ¥ãŒãã‚‹ã£ã¦ã‚„ã¤ï¼‰ã ã£ãŸã‚Šã€ã„ã‚ã„ã‚ãªãƒ¢ãƒ‡ãƒ«ãŒã“ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã«ã‚ã¦ã¯ã¾ã‚Šã¾ã™ã€‚ ã“ã®å ´åˆã€ã€ŒAãŒBã‚’ãƒ•ã‚©ãƒãƒ¼ã—ã¦ã„ã‚‹ã€ã€ŒBãŒAã‚’ãƒ•ã‚©ãƒãƒ¼ã—ã¦ã„ã‚‹ã€ã€ŒAã¨BãŒãŠäº’ã„ã«ãƒ•ã‚©ãƒãƒ¼ã—ã¦ã„ã‚‹ã€ã¨ã„ã†3ã¤ã®çŠ¶æ…‹ãŒã‚ã‚‹ã‚ã‘ã§ã™ãŒã€ç›¸äº’ãƒ•ã‚©ãƒãƒ¼ã®çŠ¶æ…‹ã¯ã€ŒAãŒBã‚’ãƒ•ã‚©ãƒãƒ¼ã—ã€ã‹ã¤BãŒAã‚’ãƒ•ã‚©ãƒãƒ¼ã—ã¦ã„ã‚‹ã€ã¨èªã¿æ›¿ãˆã¦SQLã§ã‚‚è¨˜è¿°å¯èƒ½ãªã®ã§ã€ä»¥ä¸‹ã§ã¯ã‚·ãƒ³ãƒ—ãƒ«ã«å˜æ–¹å‘ã®ã‚°ãƒ©ãƒ•ã§å…¨ã¦ã‚’æ‰±ã†ã‚‚ã®
june29 2014/03/07
ã“ã“ã«ãŸã©ã‚Šã¤ãã¾ã§ã«ã€ã©ã‚Œãã‚‰ã„ã®ä¼¼ãŸã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ãŸã®ã ã‚ã†â€¦ï¼ã‚¼ãƒã‹ã‚‰å§‹ã‚ã¦å°‘ã—ãšã¤æ‹¡å¼µã—ã¦ã„ã£ãŸã‚‰ã€ã‚«ãƒ©ãƒ åãŒ target_user_id ã¿ãŸã„ã«çµ±ä¸€ã•ã‚Œã‚‹ã“ã¨ã‚‚ãªã•ãã†(ç¾å ´ã‹ã‚‰ã®å£°)

rails

activerecord
ãƒªãƒ³ã‚¯
Ruby on Railsã®find_by_*ãƒ¡ã‚½ãƒƒãƒ‰ã«SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§(CVE-2012-5664) | å¾³ä¸¸æµ©ã®æ—¥è¨˜
Ruby on Rails(3.2.9, 3.1.8, 3.0.17ä»¥å‰)ã®find_by_*ãƒ¡ã‚½ãƒƒãƒ‰ã«SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ãŒè¦‹ã¤ã‹ã‚Šã¾ã—ãŸ(CVE-2012-5664)ã€‚ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ãã®æ¦‚è¦ã¨å¯¾ç–ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ æ¦‚è¦ Ruby on Railsã®find_by_*ãƒ¡ã‚½ãƒƒãƒ‰ã®å¼•æ•°ã¨ã—ã¦ãƒãƒƒã‚·ãƒ¥ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã§ã€ä»»æ„ã®SELECTæ–‡ã‚’å®Ÿè¡Œã§ãã‚‹è„†å¼±æ€§ãŒã‚ã‚Šã¾ã™ã€‚ æ¤œè¨¼ Ruby on Rails3.2.9ã®ç’°å¢ƒã‚’ç”¨æ„ã—ã¦ã€ä»¥ä¸‹ã®2ã¤ã®ãƒ¢ãƒ‡ãƒ«ã‚’ç”¨æ„ã—ã¾ã—ãŸã€‚ $ rails g scaffold user name:string em ail:string $ rails g scaffold book author:string title:string ãƒ¢ãƒ‡ãƒ«Userã¯å€‹äººæƒ…å ±ã‚’ä¿æŒã—ã¦ãŠã‚Šã€è‡ªåˆ†è‡ªèº«ã®æƒ…å ±ã®ã¿ãŒé–²è¦§ã§ãã‚‹ã¨ã„ã†æƒ³å®šã§ã™ã€‚ãƒ¢ãƒ‡ãƒ«Bookã¯æ›¸èªŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚
june29 2013/01/06
rails

activerecord

security
ãƒªãƒ³ã‚¯
Rails ã§ååˆ†ã«æ´»ç”¨ã•ã‚Œã¦ã„ãªãã¦ã‚‚ã£ãŸã„ãªã„ ActiveRecord::Relation ã®ãƒ¡ã‚½ãƒƒãƒ‰ TOP 10 - æ‰é¢¨å‘‚2.0 - A Lifelog -
2013å¹´12æœˆ2æ—¥æ›´æ–°: å‚ç…§ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã®ã§ Rails 4 ã®æƒ…å ±ã‚’è¨³æ³¨ã¨ã—ã¦è¿½è¨˜ã—ã¾ã—ãŸã€‚ã¾ãŸã€Rails 4 ã«é–¢ã™ã‚‹æƒ…å ±ã¯ã€ WEB+DB PRESS Vol.73 ãŒéžå¸¸ã«å‚è€ƒã«ãªã‚‹ã®ã§ã€ä¸€èªã‚’ãŠã™ã™ã‚ã—ã¾ã™ã€‚ ã“ã®æ–‡ç« ã¯ Mitch Crowe æ°ã®ãƒ–ãƒã‚°ã‚ˆã‚Š 2012å¹´4æœˆ14æ—¥ã®è¨˜äº‹ã‚’ç¿»è¨³ã—ãŸã‚‚ã®ã§ã™ã€‚ The 10 Most Underused ActiveRecord::Relation Methods http://blog.mitchcrowe.com/blog/2012/04/14/10-most-underused-activerecord-relation-methods/ æ˜¨æ—¥ã¯ ActiveRecord::Relation ã®ã‚³ãƒ¼ãƒ‰ã«è†ã¾ã§æµ¸ã‹ã£ã¦ã€ä½¿ã‚ã‚Œã¦ã„ã‚‹ã®ã‚’ã“ã‚Œã¾ã§å…¨ç„¶è¦‹ãŸã“ã¨ãŒãªã„é¢ç™½ã„ãƒŠã‚²ãƒƒãƒˆã‚’æ€ã„å‡ºã•ã›ã¦ãã‚ŒãŸã€‚ã“ã®è¨˜äº‹ã§ã€ååˆ†ã«æ´»ç”¨
june29 2012/12/04
rails

activerecord
ãƒªãƒ³ã‚¯
What's new in Edge Rails: EXPLAIN
The result of that method call is a string that carefully imitates the output of database shells. For example, under MySQL you get something similar to EXPLAIN for: SELECT `users`.* FROM `users` INNER JOIN `posts` ON `posts`.`user_id` = `users`.`id` WHERE `users`.`id` = 1 +----+-------------+-------+-------+---------------+---------+---------+-------+------+-------------+ | id | select_type | tabl
june29 2011/12/21
Running EXPLAIN manually / Automatic EXPLAIN for slow queries / Silencing automatic EXPLAIN

rails

rails3.2

sql

activerecord

database
ãƒªãƒ³ã‚¯
Unavailable
The page is unavailable. Please visit the main one.
june29 2011/04/04
scope ã®ä¾‹ãŒã„ã£ã±ã„ã€‚

ruby

rails

activerecord
ãƒªãƒ³ã‚¯
ç¬¬43å›žã€€Rails 3ã‚’æ”¯ãˆã‚‹åè„‡å½¹ãŸã¡ ãã®1 - Arel - | gihyo.jp
ã¯ã˜ã‚ã« Ruby on Railsã®2å¹´åŠã¶ã‚Šã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã§ã‚ã‚‹3.0ã®æ£å¼ãƒªãƒªãƒ¼ã‚¹ãŒã„ã‚ˆã„ã‚ˆé–“è¿‘ã«è¿«ã£ã¦ãã¾ã—ãŸã€‚ Rails 3ã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ»ãƒ¬ãƒ™ãƒ«ã§ã¯Rails 2.3ã¨ã®äº’æ›æ€§ã‚’ãªã‚‹ã¹ãä¿ã¡ãªãŒã‚‰ã‚‚ã€ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã ã‘ã‚ã£ã¦ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯è‡ªä½“ã¯éš…ã€…ã«ã¾ã§å¾¹åº•çš„ãªãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ãŒæ–½ã•ã‚Œã¦æ›´ãªã‚‹æ´—ç·´ã‚’é‚ã’ã¦ã„ã¾ã™ã€‚çµæžœã¨ã—ã¦ã€Rails 3ã§ã¯èžé€šã®åŠ¹ã‹ãªã„ãƒ•ãƒ«ã‚¹ã‚¿ãƒƒã‚¯æ§‹é€ ã‚’æ¨ã¦ã¦ã™ã£ãã‚Šã¨ã—ãŸãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ç‹¬ç«‹æ€§ãŒå®Ÿç¾ã•ã‚Œã¦ã„ã‚‹ã®ã§ã™ãŒã€ã“ã®éš›ã«ã€Merbã¨ã®åˆä½µã®å½±éŸ¿ã‚‚ã‚ã£ã¦ã‹ã€ã„ãã¤ã‹ã®æ–°ãŸãªå¤–éƒ¨ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«ä¾å˜ã™ã‚‹å½¢ã«ãªã£ã¦ã„ã‚‹ã®ã‚‚èˆˆå‘³æ·±ã„ã¨ã“ã‚ã§ã™ã€‚ ãã“ã§æœ¬ç¨¿ã§ã¯ã€ã‚ãˆã¦Rails 3ãã®ã‚‚ã®ã§ã¯ãªãã€ã“ã®Rails 3ã®å¤§æ”¹é€ ã®èˆžå°è£ã‚’æ”¯ãˆã‚‹è£æ–¹ã•ã‚“ã«ã‚¹ãƒãƒƒãƒˆãƒ©ã‚¤ãƒˆã‚’å½“ã¦ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ Arelã«ã‚ˆã£ã¦ãƒ‘ãƒ©ãƒ€ã‚¤ãƒ ãŒå¤§ããå¤‰ã‚ã£ãŸAct
june29 2010/11/17
Arel ã®æ©Ÿèƒ½ã ã‘ã§ãªãã€é–‹ç™ºã•ã‚ŒãŸèƒŒæ™¯ã‚„é–‹ç™ºè€…ã®è€ƒãˆã‚‚å«ã‚ã¦èªã‚ã‚‹è¨˜äº‹ã€‚ã•ã™ãŒç¾Žå°‘å¥³ã®çˆ¶ã€‚

ruby

rails

activerecord

arel
ãƒªãƒ³ã‚¯
Railsã§ã€SQL Server 2005ã«JDBCæŽ¥ç¶š - ç¨Žç†å£«æ¥ç•Œã§SaaSé–‹ç™ºã‚’è¡Œã†ãƒ—ãƒã‚°ãƒ©ãƒžã®è¨˜éŒ² - s21g
ç¤¾å†…ã§ä½¿ã£ã¦ã„ã‚‹SQL Serverã«æŽ¥ç¶šã™ã‚‹å¿…è¦ãŒã‚ã£ãŸã®ã§ã€JDBCæŽ¥ç¶šã™ã‚‹æ–¹æ³•ã‚’èª¿ã¹ã¦ã¿ãŸã€‚ ç’°å¢ƒ JRuby 1.1.4 Rails 2.1.2 Microsoft SQL Server 2005 activerecord-jdbc-adapterã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ActiveRecordã§JDBCæŽ¥ç¶šã™ã‚‹ãŸã‚ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ gem install activerecord-jdbc-adapter SQL Serverç”¨JDBCãƒ‰ãƒ©ã‚¤ãƒã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« msdnã‹ã‚‰ã€JDBCãƒ‰ãƒ©ã‚¤ãƒã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³1.2ã ã¨ã†ã¾ãå‹•ã‹ãªã„ã®ã§ã€1.1ã‚’ä½¿ã†ã“ã¨ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã®è§£å‡å¾Œã€jruby/lib/ã«ã€sqljdbc.jarã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹ã€‚ database.ymlã®è¨å®š æº–å‚™ãŒã§ããŸã‚‰ã€ã‚ã¨ã¯database.ymlã‚’æ›¸ãæ›ãˆã‚‹ã ã‘ã€‚ config/
june29 2008/11/26
ActiveRecord ã§ SQL Server ã«æŽ¥ç¶šã™ã‚‹è¨å®šã®ã‚µãƒ³ãƒ—ãƒ«

ruby

activerecord

sqlserver
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸