[B! ruby.rails.ar] asipã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

asip id:asip

ruby.rails.arã«é–¢ã™ã‚‹asipã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (38)

${{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}}

è¤‡æ•°ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰å‚ç…§ã•ã‚Œã‚‹DBã‚’ridgepoleã§ç®¡ç†ã™ã‚‹ | ã†ãªã™ã‘ã¨ã‚ã‚Œã“ã‚Œ
å¿™ã—ã„äººã®ãŸã‚ã®ã¾ã¨ã‚ Circle CIã«ã€å˜åœ¨ã—ãªã„Hostnameã§ç§˜å¯†éµã‚’è¿½åŠ ã™ã‚‹ã®ã¯è«¦ã‚ã‚ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¤‰æ›´ã¯ãã‚Œã‚’ç‹¬ç«‹ã§è¡Œãˆã‚‹ã‚ˆã†ã«ã—ãŸã€‚å…·ä½“çš„ã«ã¯cap deployã§ridgepole applyã§ãã‚‹ã‚ˆã†ã«ã—ãŸã€‚ tmixã®ç¾çŠ¶ æœ€è¿‘ã®å¤§è¦æ¨¡ãªwebã‚µãƒ¼ãƒ“ã‚¹ãŒã€1ã¤ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã—ã¦å‹•ã„ã¦ã„ã‚‹ã¨ã„ã†ã®ã¯çã—ã„ã ã‚ã†ã€‚cookpadç¤¾ãŒãã†ã§ã‚ã‚‹ã‚ˆã†ã«ã€tmixã‚‚è£ã§ã¯ã„ãã¤ã‹ã®Rails ApplicationãŒåŒæ™‚ã«å‹•ä½œã—ã¦ã„ã‚‹ã€‚ ãã—ã¦ãã‚Œã‚‰ã®RailsãŒè¦‹ã«è¡Œããƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚‚ã¡ã‚ã‚“å…±é€šã®1ã¤ã§ã‚ã‚‹ã€‚ Railsã¯ã€ãã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å†…ã§schema.rbã‚’ç”¨ã„ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å®šç¾©ã‚’è¡Œã£ã¦ã„ã‚‹ã€‚ãã—ã¦Railsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ•°ã ã‘schema.rbãŒå˜åœ¨ã—ã€å„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºè€…ãŒå„ã€…ã§schema.rbã‚’å¥½ãã«ç·¨é›†ã™ã‚‹ã¨ã€conflictã¯é¿ã‘
asip 2017/06/29
ruby.rails.ar
ãƒªãƒ³ã‚¯
ã•ã‚‰ã°ã€Œrails migrateã€ã€ã‚ˆã‚ã—ãã€Œridgepoleã€ | RE:ENGINES
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€æœ¬æ—¥ã¯DBã‚¹ã‚ãƒ¼ãƒžã‚’ç®¡ç†ã™ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã®ä¸€ã¤ã§ã‚ã‚‹ã€ŒRidgepoleã€ã«ã¤ã„ã¦ãƒ–ãƒã‚°æŠ•ç¨¿ã‚’ã—ã¾ã™ã€‚ ã€Œrails migrateã€ã§ã¯ãªãã€ãªãœã€ŒRidgepoleã€ã‚’ä½¿ã£ã¦ã¿ãŸã‹ãªã©ã®èƒŒæ™¯ã‹ã‚‰ã€ã€Œrails migrateã€ã‹ã‚‰ã®ç§»è¡Œæ‰‹é †ã¾ã§è¨˜è¼‰ã—ã¾ã—ãŸã®ã§ã€ãœã²æœ€å¾Œã¾ã§ãŠèªã¿ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ Ridgepoleã¨ã¯ railsã®migrateã®ã‚ˆã†ãªDBã‚¹ã‚ãƒ¼ãƒžã‚’ç®¡ç†ã™ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ãŒé–‹ç™ºã•ã‚Œã€GitHubä¸Šã§å…¬é–‹ã•ã‚Œã€gemã¨ã—ã¦ç°¡å˜ã«çµ„ã¿è¾¼ã‚€ã“ã¨ãŒã§ãã¾ã™ã€‚ https://github.com/winebarrel/ridgepole ç‰¹å¾´ã¨ã—ã¦ã¯ã€ä¸‹è¨˜ãŒã‚ã‚Šã¾ã™ã€‚ ã‚«ãƒ©ãƒ è¿½åŠ /å‰Šé™¤ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¿½åŠ /å‰Šé™¤ãªã©ã®å¤‰æ›´ã®åº¦ã«migrateãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã™ã‚‹ã®ã§ã¯ãªãã€ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ï¼ˆSchemafileï¼‰ã‚’ä¿®æ£ã™ã‚‹ã ã‘ã¨
asip 2017/06/29
ruby.rails.ar
ãƒªãƒ³ã‚¯
Railsã§ã®SIé–‹ç™ºã«Ridgepoleã¯ç›¸æ€§ãŒã„ã„ã®ã§ã¯ãªã„ã ã‚ã†ã‹ï¼Ÿ - ãƒ‘ãƒ‘ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ã‚¢ã‚¦ãƒˆãƒ—ãƒƒãƒˆå¸³
ä»•äº‹ã§Railsã§ã®SIé–‹ç™ºã‚’è¡Œã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€æ¯Žå›žæ‚©ã¿ã®ç¨®ã®ï¼‘ã¤ã«DBã®MigrationãŒã‚ã‚Šã¾ã™ã€‚ SIé–‹ç™ºã®æ€§è³ªä¸Šã€ã©ã†ã—ã¦ã‚‚ä¸‹è¨˜ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒå¿…è¦ã§ã‚ã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ ERå›³ ä»•äº‹ã§ã¯ã€ã“ã‚Œã‚‰ã‚’ä½œæˆã™ã‚‹ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ä¸‹è¨˜ã®A5:SQL Mk-2ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚ A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®æ±Žç”¨SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ« ã“ã®ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ã“ã¨ã§ã€ERå›³ã‚’æ›¸ãã ã‘ã§ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã‚‚å‡ºåŠ›ã§ãã‚‹ã®ã§ã¨ã¦ã‚‚ä¾¿åˆ©ã§ã™ã€‚ (ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã¯å¿…è¦ã«å¿œã˜ã¦åŠ å·¥ã™ã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ãŒ) ãã—ã¦ã€ã“ã®ãƒ„ãƒ¼ãƒ«ã®ã•ã‚‰ã«ä¾¿åˆ©ãªã¨ã“ã‚ãŒã€ERå›³ã‹ã‚‰DDLã‚’ç”Ÿæˆã§ãã‚‹ã¨ã“ã‚ã§ã™ã€‚ æ¡ˆä»¶ã§ã¯é–‹ç™ºã®ç«‹ã¡ä¸ŠãŒã‚Šã‚’æ—©ãã™ã‚‹ãŸã‚ã«ã€è¨è¨ˆã«åˆ©ç”¨ã—ãŸERå›³ã‹ã‚‰DDLç”Ÿæˆæ©Ÿèƒ½(ERå›³ > DDLã‚’ç”Ÿæˆã™ã‚‹)ã‚’åˆ©ç”¨ã—ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆã‚’è¡Œã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ é–‹ç™ºåˆæœŸã¯ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ãŒå¤‰ã‚ã‚‹ã“ã¨ãŒã‚ˆãã‚ã‚‹
asip 2017/06/29
ruby.rails.ar
ãƒªãƒ³ã‚¯
Ruby on Rails ã‚’MSSQLã«æŽ¥ç¶šã•ã›ã‚‹ - ã‚ã‹ã‚Šã¥ã‚‰ã„äº‹ã°ã‹ã‚Š
Railsã‚¢ãƒ—ãƒªã®Gemfileï¼ˆæ‹¡å¼µåãŒãªã„ã‘ã©ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ï¼‰ã‚’é–‹ãã€ä¸‹è¨˜ã‚’è¿½åŠ ã—ã¾ã™ã€‚ gem 'tiny_tds' gem 'activerecord-sqlserver-adapter' sqliteã®gemã¯å‰Šé™¤ã—ã¦å•é¡Œã‚ã‚Šã¾ã›ã‚“ã€‚ æ¬¡ã«ã€configãƒ•ã‚©ãƒ«ãƒ€é…ä¸‹ã®database.ymlã‚’é–‹ãã¾ã™ã€‚ config/database.yml developmentéƒ¨åˆ†ã‚’ä¸‹è¨˜ã«ç½®ãæ›ãˆã¾ã™ã€‚ development: adapter: sqlserver vmode: DBLIB port: æŽ¥ç¶šå…ˆSQLã‚µãƒ¼ãƒãƒ¼ãŒTCP/IPã‚’é€šã—ã¦ã„ã‚‹ãƒãƒ¼ãƒˆ host: æŽ¥ç¶šå…ˆã‚µãƒ¼ãƒãƒ¼ã®IPã‚¢ãƒ‰ãƒ¬ã‚¹ï¼ˆã¾ãŸã¯ãƒžã‚·ãƒ³åï¼‰ database: ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å username: ãƒ¦ãƒ¼ã‚¶ãƒ¼å password: ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ timeout: ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆç§’ ä»¥ä¸Šã€ã§ã™ã€‚ gemã‚’æ›´æ–°ã—ãŸå ´åˆã¯ã€Ra
asip 2017/06/29
ruby.rails.ar
ãƒªãƒ³ã‚¯
railsã¨SQL Serverã®é€£æºã«ã¤ã„ã¦ â€“ kobu pages
asip 2017/06/29
ruby.rails.ar
ãƒªãƒ³ã‚¯
rails-sqlserver/activerecord-sqlserver-adapter: SQL Server Adapter For Rails
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
asip 2017/06/29
ruby.rails.ar
ãƒªãƒ³ã‚¯
Rails ã«ãŠã‘ã‚‹å†…éƒ¨çµåˆã€å¤–éƒ¨çµåˆã¾ã¨ã‚ - Qiita
0. ã¯ã˜ã‚ã« Qiitaã¯ã˜ã‚ã€ã•ã¾ã–ã¾ãªã¨ã“ã‚ã§Railsã®ActiveRecordã®å†…éƒ¨çµåˆã‚„å¤–éƒ¨çµåˆã«é–¢ã™ã‚‹è¨˜äº‹ãŒã‚ã‚Šã¾ã™ãŒã€ãã‚Œã‚‰ãŒã¾ã¨ã¾ã£ã¦å˜åœ¨ã—ã¦ã„ã‚‹ã¨è‰¯ã„ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã¨ãªã‚‹ã®ã§ã¯ãªã„ã‹ã¨æ€ã„æœ¬è¨˜äº‹ã‚’ä½œæˆã—ã¾ã—ãŸã€‚ ã¾ãŸã€Rails5ã§å‹•ä½œç¢ºèªã—ã¦ãŠããªãŒã‚‰ã€Rails5ã‹ã‚‰è¿½åŠ ã•ã‚ŒãŸleft_outer_joinsãªã©ã¯è¼‰ã›ã¦ã¾ã›ã‚“ã€‚ä»Šå¾Œã€è¼‰ã›ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ group byã‚„ã‚µãƒ–ã‚¯ã‚¨ãƒªï¼ˆå‰¯å•ã„åˆã‚ã›ï¼‰ã«é–¢ã—ã¦ã¯ä¸‹è¨˜ã‚‚ã”å‚ç…§ãã ã•ã„ã€‚ ActiveRecordã«ãŠã‘ã‚‹GROUP BYã®ä½¿ã„æ–¹ ActiveRecordã§ã‚µãƒ–ã‚¯ã‚¨ãƒªï¼ˆå‰¯å•ã„åˆã‚ã›ï¼‰ã¨å†…éƒ¨çµåˆ 0-1. Rubyã¨Railsã¨PostgreSQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ $ ruby -v ruby 2.2.4p230 (2015-12-16 revision 53155) [x86_64-darwin15] $ r
asip 2017/06/02
ruby.rails.ar
ãƒªãƒ³ã‚¯
Google
ä¸–ç•Œä¸ã®ã‚ã‚‰ã‚†ã‚‹æƒ…å ±ã‚’æ¤œç´¢ã™ã‚‹ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã‚’æä¾›ã—ã¦ã„ã¾ã™ã€‚ã•ã¾ã–ã¾ãªæ¤œç´¢æ©Ÿèƒ½ã‚’æ´»ç”¨ã—ã¦ã€ãŠæŽ¢ã—ã®æƒ…å ±ã‚’è¦‹ã¤ã‘ã¦ãã ã•ã„ã€‚
asip 2017/03/01
ruby.rails.ar
ãƒªãƒ³ã‚¯
Railsã§bulletã‚’ä½¿ã£ã¦N+1å•é¡Œã‚’ç™ºè¦‹ã—DBã‚¢ã‚¯ã‚»ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã‚‹ - Rails Webook
bulletã¨ã¯ã€N+1å•é¡Œã‚„ä½¿ã‚ã‚Œã¦ã„ãªã„Eager Loadingã‚’ç™ºè¦‹ã™ã‚‹ãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ã“ã‚Œã‚‰ã®å•é¡ŒãŒã‚ã‚‹ã¨ç„¡é§„ãªSQLã‚¯ã‚¨ãƒªãŒå®Ÿè¡Œã•ã‚Œã‚‹ã®ã§ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è½ã¨ã—ã¦ã—ã¾ã„ã¾ã™ã€‚ æ°—ã‚’ã¤ã‘ã¦ã„ã¦ã‚‚N+1å•é¡Œã¯ç™ºç”Ÿã—ã¦ã—ã¾ã†å¯èƒ½æ€§ãŒã‚ã‚‹ã®ã§ã€bulletã‚’å°Žå…¥ã—ã¦è‡ªå‹•ã§ç™ºè¦‹ã§ãã‚‹ã‚ˆã†ã«ã—ã¦ã¿ã¾ã™ã€‚ â€» N+1å•é¡Œã‚„Eager Loadingã«ã¤ã„ã¦ã‚ˆãã‚ã‹ã‚‰ãªã„æ–¹ã¯ã€N+1å•é¡Œ / Eager Loading ã¨ã¯ã‚’å‚ç…§ãã ã•ã„ã€‚ ç¢ºèªç’°å¢ƒ Ruby 2.1.2 Rails 4.1 bullet 4.14.0 ç›®æ¬¡ Rails ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ä½œæˆ Bulletã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³• Bulletã®ãƒ›ãƒ¯ã‚¤ãƒˆãƒªã‚¹ãƒˆã®è¨å®š Bulletã‚’ãƒ†ã‚¹ãƒˆã§å®Ÿè¡Œ 1. Rails ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ä½œæˆã¾ãšã¯Rails ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œæˆã—ã¾ã™ã€‚ rails new bullet_test cd bullet
asip 2015/08/31
ruby.rails.ar
ãƒªãƒ³ã‚¯
GitHub - joker1007/activerecord-cause: This gem logs where ActiveRecord actually loads record
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
asip 2015/08/31
ruby.rails.ar
ãƒªãƒ³ã‚¯
GitHub - refile/refile-s3: Amazon S3 Backend for Refile
asip 2015/07/10
ruby.rails.ar
ãƒªãƒ³ã‚¯
GitHub - brainspec/enumerize: Enumerated attributes with I18n and ActiveRecord/Mongoid support
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
asip 2015/07/10
ruby.rails.ar
ãƒªãƒ³ã‚¯
heart_seedã¨ã„ã†ãƒžã‚¹ã‚¿ãƒ‡ãƒ¼ã‚¿DBæŠ•å…¥ç”¨ã®gemã‚’ä½œã‚Šã¾ã—ãŸ - ãã‚Šã«ã£ã
github: https://github.com/sue445/heart_seed rubygems: http://rubygems.org/gems/heart_seed ãƒžã‚¹ã‚¿ãƒ‡ãƒ¼ã‚¿ä½œæˆæ™‚ã®å•é¡Œç‚¹ xlsã‚„xlsxã¯Excelã§ç·¨é›†ã™ã‚‹ã®ã«ã¯å‘ã„ã¦ã‚‹ã‘ã©ã€ãƒã‚¤ãƒŠãƒªãªã®ã§gitã‚„svnã¨ã®ç›¸æ€§ã¯æ‚ªã„ diffãŒè¦‹ã‚Œãªã„ yamlã¯diffãŒè¦‹ã‚„ã™ã„ã‘ã©å¤§é‡ã®ãƒžã‚¹ã‚¿ãƒ‡ãƒ¼ã‚¿ã®ç·¨é›†ã«ã¯å‘ã‹ãªã„ è¡Œåˆ—æ§‹é€ ã¯Excelã§ç·¨é›†ã™ã‚‹ã®ãŒæ¥½ éžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«yamlã‚’ç›´æŽ¥ç·¨é›†ã—ã¦ã‚‚ã‚‰ã†ã®ã¯ã¤ã‚‰ã„ï¼ˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚ã¤ã‚‰ã„ï¼‰ ã¨ã„ã†ã“ã¨ã§ã€xlsã‚’yamlã«å¤‰æ›ã—ã¦ã€ã•ã‚‰ã«yamlã‚’seedã¨ã—ã¦DBã«æŠ•å…¥ã™ã‚‹ãŸã‚ã®gemã‚’ä½œã‚Šã¾ã—ãŸã€‚ï¼ˆãƒžã‚¹ã‚¿ãƒ‡ãƒ¼ã‚¿ã®ç·¨é›†æ™‚ã¯xlsã¨yamlã‚’åŒæ™‚ã«commitã™ã‚‹æƒ³å®šï¼‰ å…ƒã€…padrinoã§ä½¿ã†äºˆå®šã ã£ãŸã®ã§padrinoã‚’æƒ³å®šã—ã¦ã¾ã™ãŒä¸€å¿œrailsã‚‚å¯¾å¿œã—ã¦ã¾ã™ã€‚
asip 2015/07/10
ruby.rails.ar
ãƒªãƒ³ã‚¯
ActiveRecord::Relation vs Arel
No, I don't work in NYC, DC, or the valley, and I'm cool with that. Since the release of ActiveRecord Query Interface 3.0, I think the line has been pretty blurry for the Rails community about where ActiveRecord ends and Arel begins. Iâ€™ve seen folks attribute ActiveRecord::PredicateBuilder to Arel, and Iâ€™ve seen folks assume that an ActiveRecord::Relation is an Arel object. Neither is the case. Si
asip 2015/06/29
ruby.rails.ar
ãƒªãƒ³ã‚¯
GitHub - activewarehouse/rails_sql_views: Rails SQL Views project extracted from ActiveWarehouse
asip 2014/11/25
ruby.rails.ar
ãƒªãƒ³ã‚¯
Railsã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã§bigintã‚’ä½¿ã†ã«ã¯ - Qiita
ã¯ã˜ã‚ã« ã¿ãªã•ã‚“Railsã‚„ã£ã¦ã¾ã™ã‹ï¼Ÿ DBã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¡Œã†ã¨ãã€integerã¨ã‹stringã¨ã‹æŒ‡å®šã™ã‚‹ã¨æ€ã†ã‚“ã§ã™ãŒã€ã‚ã‚ŒæŒ‡å®šã™ã‚‹ã¨ ã£ã¦é™å®šã•ã‚Œã¦ã—ã¾ã„ã¾ã™ã‚ˆãã€‚æ–‡å—åˆ—ãªã‚‰textåž‹ä½¿ãˆã¨ã‹ã„ã‚ã„ã‚ã‚ã‚Šã¾ã™ãŒã€ãã‚Œã«ã—ã¦ã‚‚æ•°å€¤åž‹ã‚’bigintã«ã§ããªã„ã®ã¯ä¸ä¾¿ã§ã™ã€‚ bigintä½¿ã„ãŸã„ï¼ ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžãƒ¼å‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã ã¨ãƒ¦ãƒ¼ã‚¶æ•°ãŒã¨ã‚“ã§ã‚‚ãªãå¢—ãˆã¦ã„ãã®ã§ã€ãƒ¦ãƒ¼ã‚¶IDã ã‘ã§ã‚‚ã™ã”ã„æ•°ã«ãªã‚Šã¾ã™ã€‚ãã‚“ãªãƒ¦ãƒ¼ã‚¶æ•°ã„ãªã„ã¨ã—ã¦ã‚‚Facebookã§ãƒã‚°ã‚¤ãƒ³ã¨ã‹ã•ã›ã¦ã„ã‚‹ã¨ã€IDãŒRailsæŒ‡å®šã®integerã§ã¯ã‚¨ãƒ©ãƒ¼ã«ãªã‚Šã¾ã™ã€‚ ãã“ã§ã©ã†ã—ã¦ã‚‚bigintãŒå¿…è¦ã«ãªã‚‹ã‚“ã§ã™ãŒã€æŒ‡å®šæ–¹æ³•ã‚ã‹ã‚Šã¥ã‚‰ã„ã§ã™ã‚ˆãã€‚ Railsã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ•ã‚¡ã‚¤ãƒ«ã§ã€limitã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¤ã‘ã‚Œã°ãã‚ŒãŒã§ãã‚‹ã‚“ã§ã™ã€‚
asip 2014/11/24
ruby.rails.ar
ãƒªãƒ³ã‚¯
GitHub - amatsuda/everywhere: Hash condition syntax for AR query everywhere!
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
asip 2014/11/20
ruby.rails.ar
ãƒªãƒ³ã‚¯
Rails ActiveRecordã®SQLã§LIKEæ¤œç´¢ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—
ä¾‹ãˆã°ã€â€100%å®Œæˆâ€ ã¿ãŸã„ãªæ–‡å—åˆ—ã‚’ LIKE æ¤œç´¢ã«ãã®ã¾ã¾æ¸¡ã™ã¨ã€% ãŒãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰ã¨ã—ã¦ä½¿ã‚ã‚Œã¦ã—ã¾ã†ã®ã§ã€ãã‚Œã‚’é˜²ããŸã‚ã« â€œ100\\%å®Œæˆâ€ ã¨ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã¯æ–‡å—åˆ—ã§ã‚‚ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ç”¨ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã¨ã—ã¦ä½¿ã‚ã‚Œã‚‹ã®ã§ã€LIKEæ¤œç´¢ã«æ¸¡ã™éš›ã«ã¯ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ãŒ2ã¤å¿…è¦ãªã“ã¨ã«ã‚‚æ³¨æ„ã€‚ â€” ç’°å¢ƒ â€” Rails 4.0.1 ç‹¬è‡ªã« escape_like ãƒ¡ã‚½ãƒƒãƒ‰ã‚’å®Ÿè£… LIKE æ¤œç´¢æ™‚ã«ä½¿ãˆã‚‹ API ãŒ Rails ã§ã¯ç‰¹ã«ç”¨æ„ã•ã‚Œã¦ã„ãªã•ãã†ã ã£ãŸã®ã§ã€ä»¥ä¸‹ã®ãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½œã‚Šã¾ã—ãŸã€‚
asip 2014/11/20
ruby.rails.ar
ãƒªãƒ³ã‚¯
Rails ã€ãƒ¢ãƒ‡ãƒ«ã€‘ scopeã‚’ä½¿ã£ã¦æ¤œç´¢ã—ã¦ã¿ãŸã‚ˆ
(ï¿£(ï½´)ï¿£)å½¡â˜† ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã«æ›¸ãã¨â€¦ @user = User.where(:name => params[:name]) ã§ã‚‚ã€ã“ã†ã„ã†ã®ã¯ãƒ¢ãƒ‡ãƒ«ã«æ›¸ããŸã„ãƒ˜(^o^)ãƒŽ Userãƒ¢ãƒ‡ãƒ« class User < ActiveRecord::Base scope :search, lambda { |name| where("name = ?", "#{name}") } end ä½¿ã„æ–¹ã¯ã“ã‚“ãªæ„Ÿã˜ @user = User.search ã™ã£ãã‚Šã—ãŸããƒ¼ãƒ¾(â•¹â—¡â•¹âœ½ä¸‰âœ½â•¹â—¡â•¹)ï¾‰â€³ ã‚“ã˜ã‚ƒã€è¤‡æ•°ã®å ´åˆã¯â€¦ Userãƒ¢ãƒ‡ãƒ« class User < ActiveRecord::Base scope :search, lambda { |name, admin| where("name = ?", "#{name}").where("admin = ?", "#{admin}") }
asip 2014/11/04
ruby.rails.ar
ãƒªãƒ³ã‚¯
Railsã§ã‚«ãƒ©ãƒ ã‚’è¿½åŠ ã™ã‚‹éš›ã«referencesã‚’æŒ‡å®šã™ã‚‹ã¨db:migrateãŒé€šã‚‰ãªã„ | blog.nomnel.net
[2014/07/03è¿½è¨˜] Rails4.0ä»¥ä¸Šãªã‚‰add_referenceä½¿ãˆã°OK. [è¿½è¨˜çµ‚ã‚ã‚Š] Stack Overflowã«å…¨ãåŒã˜çŠ¶æ…‹ã®æŠ•ç¨¿ãŒã‚ã£ãŸã®ã§ãã®é€šã‚Šã«ã—ã¦è§£æ±º. ä¸€å¿œã“ã¡ã‚‰ã«ã‚‚æ›¸ã„ã¦ãŠã. ç¾è±¡ æ¬¡ã®ã‚ˆã†ã«referencesã‚’æŒ‡å®šã—ã¦migrationãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”Ÿæˆã—ãŸã¨ã, rails g migration AddUserCategoryToUsers user_category:references class AddUserCategoryToUsers < ActiveRecord::Migration def change add_column :users, :user_category, :references, :default => 1 end end db:migrateã«å¤±æ•—ã™ã‚‹. rake db:migrate == AddUser
asip 2014/10/15
ruby.rails.ar
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸