GitHub - departurerb/departure: Percona's pt-online-schema-change runner for ActiveRecord migrations.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
Create new page · zdennis/activerecord-import Wiki
Attach files by dragging & dropping, selecting or pasting them. Loading Uploading your files… We don’t support that file type. Try again with a GIF, JPEG, JPG, MOV, MP4, PNG, SVG or WEBM. Attaching documents requires write permission to this repository. Try again with a GIF, JPEG, JPG, MOV, MP4, PNG, SVG or WEBM. We don’t support that file type. Try again with a GIF, JPEG, JPG, MOV, MP4, PNG, SVG
ActiveRecordを使ã£ã¦Redshiftã‹ã‚‰å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’効率的ã«èªã¿å‡ºã™ - クックパッド開発者ブãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ãƒˆãƒ¬ãƒ³ãƒ‰èª¿æŸ»ãƒ©ãƒœã®äº•ä¸Šå¯›ä¹‹ï¼ˆ@inohiro）ã§ã™ã€‚ 普段ã¯ã€ã‚¯ãƒƒã‚¯ãƒ‘ッドã®æ¤œç´¢ãƒã‚°ã‚’基ã«ã—ãŸæ³•äººå‘ã‘データサービス「ãŸã¹ã¿ã‚‹ã€ã®é–‹ç™ºã‚„〠広告事æ¥å‘¨è¾ºã®ãƒ‡ãƒ¼ã‚¿åˆ†æžãªã©ã‚’担当ã—ã¦ã„ã¾ã™ã€‚ Amazon Redshiftãªã©ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«è“„ç©ã•ã‚ŒãŸãƒã‚°ãªã©ã®å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ã€ 日次や週次ãªã©ã®å˜ä½ã§ãƒãƒƒãƒå‡¦ç†ã‚’è¡Œã£ã¦ã„ã‚‹æ–¹ã¯å¤šãã„らã£ã—ゃるã¨æ€ã„ã¾ã™ã€‚ ãƒã‚°ãªã©ã‚’扱ã†ãƒãƒƒãƒå‡¦ç†ã§ã¯ã€å‡¦ç†å¯¾è±¡ãŒè†¨å¤§ã§ã‚ã‚‹ã¨ã‚¢ãƒ—リケーションãŒä½¿ã†ãƒ¡ãƒ¢ãƒªãŒå¢—大ã—〠枯渇ã—ã¦ã—ã¾ã†æれもã‚ã‚‹ãŸã‚ã€ãƒ‡ãƒ¼ã‚¿ã®æ‰±ã„ã«æ°—ã‚’ã¤ã‘ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ データベース内ã§å®Œçµã™ã‚‹ãƒãƒƒãƒå‡¦ç†ãªã‚‰ã°ãã“ã¾ã§æ°—ã«ã™ã‚‹å¿…è¦ã¯ç„¡ã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ 外部ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿å‡ºã—ã¦å‡¦ç†ã™ã‚‹å ´åˆã¯ç‰¹ã«æ³¨æ„ãŒå¿…è¦ã§ã™ã€‚ ãã“ã§è€ƒãˆã‚‰ã‚Œã‚‹ä¸€ã¤ã®å·¥å¤«ã¨ã—ã¦ã€å‡¦ç†å¯¾è±¡ã‚’分割ã—ã¦ã€ç¹°ã‚Šè¿”ã—ã¦å‡¦ç†ã‚’è¡Œã†æ–¹æ³•ãŒæŒ™ã’られã¾ã™ã€‚ 一般的ãª
Active Record and PostgreSQL — Ruby on Rails Guides
This guide covers PostgreSQL specific usage of Active Record. After reading this guide, you will know: How to use PostgreSQL's datatypes. How to use UUID primary keys. How to include non-key columns in indexes. How to use deferrable foreign keys. How to use unique constraints. How to implement exclusion constraints. How to implement full text search with PostgreSQL. How to back your Active Record
Reversible Migrations with Active Record
I figured I would take some time to write about a nifty feature that I’m not sure many developers know about, or have had an opportunity to use yet: the reversible method in Active Record migrations. Introduced in Rails 4.0, reversible makes it possible to tell a migration using change (instead of up and down) how to reverse migrations that Active Record doesn’t know how to reverse by default, so
Postgresqlã®ãƒ‡ãƒ¼ã‚¿åž‹ä¸€è¦§ã¨Railsã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã®æŒ‡å®šæ–¹æ³• - Rails Webook
Postgresqlã®å„データ型ã¨Railsã®ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã§ã®æŒ‡å®šæ–¹æ³•ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ 次ã®ç›®æ¬¡ã«ã‚ã‚‹ã€ãƒ‡ãƒ¼ã‚¿åž‹ã«ã¤ã„ã¦ã¾ã¨ã‚ã¾ã—ãŸã€‚ 目次 数値データ型 通貨型 æ–‡å—åž‹ 日付/時刻データ型 è«–ç†å€¤ãƒ‡ãƒ¼ã‚¿åž‹ å‹•ä½œç¢ºèª Ruby 2.2.0 Rails 4.2.1 Postgresql 9.4.1 数値データ型数値データ型ã«ã¯2ã€4ã€8ãƒã‚¤ãƒˆæ•´æ•°ã¨ã€4ã€8ãƒã‚¤ãƒˆæµ®å‹•å°æ•°ç‚¹ã€ç²¾åº¦è¨å®šãŒå¯èƒ½ãªæ•°ãŒã‚ã‚Šã¾ã™ã€‚ åž‹åæ ¼ç´ã‚µã‚¤ã‚ºèª¬æ˜Žç¯„囲 smallint2ãƒã‚¤ãƒˆç‹ç¯„囲ã®æ•´æ•°-32768ã‹ã‚‰+32767 integer4ãƒã‚¤ãƒˆå…¸åž‹çš„ã«ä½¿ç”¨ã™ã‚‹æ•´æ•°-2147483648ã‹ã‚‰+2147483647 bigint8ãƒã‚¤ãƒˆåºƒç¯„囲整数-9223372036854775808ã‹ã‚‰+9223372036854775807 decimalå¯å¤‰é•·ãƒ¦ãƒ¼ã‚¶æŒ‡å®šç²¾åº¦ã€æ£ç¢ºã€é€šè²¨ãªã©ã«ä½¿ç”¨å°æ•°ç‚¹å‰ã¾ã§ã¯131072æ¡ã€å°æ•°ç‚¹
monoe's blog - Site Home - MSDN Blogs
In Visual Studio 2022 17.10 Preview 2, we’ve introduced some UX updates and usability improvements to the Connection Manager. With these updates we provide a more seamless experience when connecting to remote systems and/or debugging failed connections. Please install the latest Preview to try it out. Read on to learn what the Connection ...
Blog
What We Know Our key takeaways from partnering with enterprise-level engineering teams. Details How We Ensure Success Our unique and personalized approach to help you achieve your business goals. Details Your SEI Platform Get to know your custom-designed Software Engineering Intelligence (SEI) platform. Details
GitHub - zdennis/activerecord-import: A library for bulk insertion of data into your database using ActiveRecord.
Activerecord-Import is a library for bulk inserting data using ActiveRecord. One of its major features is following activerecord associations and generating the minimal number of SQL insert statements required, avoiding the N+1 insert problem. An example probably explains it best. Say you had a schema like this: Publishers have Books Books have Reviews and you wanted to bulk insert 100 new publish
ActiveRecordを支ãˆã‚‹æŠ€è¡“ - Arelã¨ã¯ä½•è€…ãªã®ã‹? (å…¨5回) ãã®1 | Webシステム開発ï¼æ•™è‚²ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¿ã‚¤ãƒ インターメディア
ActiveRecordを支ãˆã‚‹æŠ€è¡“ – Arelã¨ã¯ä½•è€…ãªã®ã‹? (å…¨5回) ãã®1 #activerecord#Arel#rails#ruby#sql 2014å¹´ 05月 04æ—¥ nishio Rails3, ActiveRecordã‹ã‚‰ã¯ã€å†…部ã§Arelã¨å‘¼ã°ã‚Œã‚‹SQL生æˆç”¨ã®ãƒ©ã‚¤ãƒ–ラリãŒåˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ 今回ã€ArelãŒå†…部ã§ã©ã®ã‚ˆã†ã«SQLを生æˆã—ã¦ã„ã‚‹ã®ã‹ã‚’調査ã—ãŸã®ã§ã€å½“ブãƒã‚°ã«ã¦å…¬é–‹ã„ãŸã—ã¾ã™ã€‚ ã¡ã‚‡ã£ã¨é•·ããªã£ã¦ã—ã¾ã£ãŸãŸã‚ã€å…¨5回ã«åˆ†å‰²ã—ã¾ã—ãŸã€‚ 以下ã€ç›®æ¬¡ã¨ãªã‚Šã¾ã™ã€‚ ActiveRecordを支ãˆã‚‹æŠ€è¡“ – Arelã¨ã¯ä½•è€…ãªã®ã‹?(å…¨5回) ãã®1 [ã“ã®è¨˜äº‹]Arelã«ã¤ã„ã¦ãªãœèª¿æŸ»ã—よã†ã¨æ€ã£ãŸã®ã‹ã€ãã®èƒŒæ™¯ã¨ä»Šå¾Œåˆ©ç”¨ã™ã‚‹ã‚µãƒ³ãƒ—ルコードを掲載ã—ã¦ã„ã¾ã™ã€‚ActiveRecordを支ãˆã‚‹æŠ€è¡“ – Arelã¨ã¯ä½•è€…ãªã®ã‹?(å…¨5回) ãã®2シンプルãªSQLæ–‡ã€ã€Œ
RSpec ã§ä¾‹å¤–テストã®æ›¸ãæ–¹ã€ãŠã‚ˆã³ ActiveRecord ã®ä¾‹å¤–をテストã™ã‚‹éš›ã®æ³¨æ„
— 環境 — rails-4.0.1 rspec-rails-2.14.0 capybara-2.2.0 RSpec ã§ä¾‹å¤–をテストã™ã‚‹ã‚³ãƒ¼ãƒ‰ unique ã‚ー制約ã®ä»˜ã„ã¦ã„ã¦ã‚‹DBカラムã«å¯¾ã—ã¦ã€ä»¥ä¸‹ã®ã‚ˆã†ã«ä¾‹å¤–ã®ç™ºç”Ÿã‚’確èªã™ã‚‹ãƒ†ã‚¹ãƒˆã‚’書ã„ãŸã®ã§ã™ãŒã€ã“ã®æ™‚ã¯ã¾ã£ãŸç®‡æ‰€ãŒã‚ã‚Šã¾ã—ãŸã€‚ spec/models/user_spec.rb describe "with DB" do describe "column having unique-key constraint" do describe "when email address is already taken" do before { @user.save! } it "should raise error ActiveRecord::RecordNotUnique" do expect do user_with_same_ema
ActiveRecord4ã§ã“ã‚“ãªSQLクエリã©ã†æ›¸ãã®? Arelç·¨ | Webシステム開発ï¼æ•™è‚²ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¿ã‚¤ãƒ インターメディア
ActiveRecord4ã§ã“ã‚“ãªSQLクエリã©ã†æ›¸ãã®ï¼Ÿ Mergeç·¨ ã§ã¯ã€é–¢é€£å…ˆã®scopeを使ã†ã“ã¨ãŒã§ãã‚‹mergeを紹介ã—ã¾ã—ãŸã€‚mergeを使ã†äº‹ã§ã€å¤‰æ›´ã«å¼·ã„クエリを美ã—ã組ã¿ç«‹ã¦ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ 今回ã¯ã€ActiveRecord4ã§æ›¸ãã«ãã„SQLクエリãŸã¡ã‚’紹介ã—ã¾ã™ã€‚ 書ãã«ãã„クエリã¨ã¯ã€å…·ä½“çš„ã«ã¯ä»¥ä¸‹ã®ã‚‚ã®ãŒã‚ã’られã¾ã™ã€‚ 比較演算ORlikeleft outer joinunionサブクエリexists ActiveRecordã§ã“れらã®ã‚¯ã‚¨ãƒªã‚’組ã¿ç«‹ã¦ã‚‹å ´åˆã€ã©ã†ã—ã¦ã‚‚美ã—ããªã„（SQLæ–‡å—列をã¹ã£ãŸã‚Šæ›¸ã„ã¦ã—ã¾ã†ã‚ˆã†ãªï¼‰æ›¸ãæ–¹ã¨ãªã£ã¦ã—ã¾ã„ãŒã¡ã§ã™ã€‚ ã“ã®å‡¦ç†ã‚’美ã—ã書ããŸã‚ã«ã¯ã€ActiveRecordã ã‘ã®æ©Ÿèƒ½ã§ã¯è¶³ã‚Šãšã€ActiveRecordãŒå†…部ã§ä½¿ã£ã¦ã„ã‚‹Arelã¨ã„ã†ãƒ©ã‚¤ãƒ–ラリを使ã†å¿…è¦ãŒã§ã¦ãã¾ã™ã€‚ 今回ã¯ã€Arelを使ã£ã¦è¯éº—ã«SQLク
ActiveRecordã§ã‚µãƒ–クエリã®INå¥ã‚’書ããŸã„ã‚“ã§ã™ - ãªã‚“ã§ã‚„。。
ruby 1.9.2p290 (2011-07-09) [i386-mingw32] activerecord (3.1.0) activerecord-oracle_enhanced-adapter (1.4.2) INå¥è‡ªä½“ã¯ãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ã‚’é…列ã«ã™ã‚Œã°å‹æ‰‹ã«ã„ã„よã†ã«ã—ã¦ãれるよã†ã§ã™ã€‚ サブクエリã¯Arelを徹底活用ã™ã‚‹ã®ãŒã„ã„よã†ã§ã™ã€‚“ãµã¤ã†ã«â€æ›¸ã„ãŸã®ã§ã¯ã‚¯ã‚¨ãƒªã‚’2回投ã’ã¦ã—ã¾ã†ã‚ˆã†ã§ã™ã。 Oracle 11g XE HRスã‚ーマã«ã¦ã€ã‚µãƒ©ãƒªãƒ¼ãŒæœ€å¤§9000ドルãªJOBã®å¾“æ¥å“¡ã‚’EMPLOYEESã‹ã‚‰æŠ½å‡ºã™ã‚‹ã€‚ サブクエリ使ã‚ãªã„版 ids = Job.where(max_salary: 9000).all.map{|record| record.job_id} Employee.where(job_id: ids).each do |record| p record end
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
Rails 4.1ã§å°Žå…¥ã•ã‚Œã‚‹ActiveRecord Enumsã«éš ã•ã‚ŒãŸç½ - ã¼ããŸã¡å®‡å®™äºº
TL;DR ActiveRecord::Enumã§ã€å®‰æ˜“ã«å€¤ã‚’è¿½åŠ ãƒ»å‰Šé™¤ã™ã‚‹ã®ã¯å±é™ºã€‚å°†æ¥ã®å¤‰æ›´ã«å‚™ãˆã¦ã€DBã«ç™»éŒ²ã•ã‚Œã‚‹å€¤ã‚’Hashã§æŒ‡å®šã—ã¾ã—ょã†ã€‚ class User < ActiveRecord::Base # This is BAD enum authority: [:registrant, :admin] # This is OK enum authority: { registrant: 10, admin: 20 } end 本編 年度も変ã‚ã‚Šã•ã¦å¿ƒæ©Ÿä¸€è»¢ã€ã¨ã„ã†å£ç¯€ãªã®ã«ç§ã®åœ°å…ƒã¯æ˜¨æ—¥å¤§é›ªã§ã—ãŸãŒã€çš†æ§˜ã„ã‹ãŒãŠéŽã”ã—ã§ã—ょã†ã‹ã€‚ã•ã¦ä»Šæ—¥ã¯è¡¨é¡Œã®é€šã‚Šã€Rails 4.1ã«ãŠã‘る目玉ã®ã²ã¨ã¤ã€ActiveRecord Enumsã«ã¤ã„ã¦ã§ã™ã€‚ ActiveRecord Enumsã¨ã¯ 例ãˆã°Userモデルã«authority（権é™ï¼‰ã¨ã„ã†å±žæ€§ã‚’æŒãŸã›ãŸã„時ã«ã‚ˆãã‚„ã‚‹ã®ã¯ã€D
肥大化ã—ãŸActiveRecordモデルをリファクタリングã™ã‚‹7ã¤ã®æ–¹æ³•ï¼ˆç¿»è¨³ï¼‰
æ›´æ–°æƒ…å ±: 2013/11/19: åˆç‰ˆå…¬é–‹ 2021/01/08: 訳文見直ã—ã€è¿½è¨˜ ã“ã‚“ã«ã¡ã¯ã€hachi8833ã§ã™ã€‚今回ã¯ã€è‡ªåˆ†ãŒçŸ¥ã‚ŠãŸã‹ã£ãŸã€Active Recordモデルã®ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã«é–¢ã™ã‚‹è¨˜äº‹ã‚’翻訳ã„ãŸã—ã¾ã—ãŸã€‚1å¹´å‰ã®è¨˜äº‹ãªã®ã§Rails 3ãŒå‰æã§ã™ãŒã€Rails 4以é™ã§ã‚‚基本的ã«ã¯å¤‰ã‚らãªã„ã¨æ€ã„ã¾ã™ã€‚リンクã¯å¯èƒ½ãªã‚‚ã®ã«ã¤ã„ã¦ã¯æ—¥æœ¬èªžã®ã‚‚ã®ã«ç½®ãæ›ãˆã¦ã„ã¾ã™ã€‚ ãªãŠã€ã“ã“ã§ã”紹介ã—ãŸã‚ªãƒ–ジェクトã¯ã€app以下ã«ãã‚Œãžã‚Œä»¥ä¸‹ã®ã‚ˆã†ã«ãƒ•ã‚©ãƒ«ãƒ€ã‚’è¿½åŠ ã—ã¦ãã“ã«é…ç½®ã—ã¾ã™ã€‚ 注記: 以下ã¯ä½¿ã‚ã‚Œãã†ãªãƒ•ã‚©ãƒ«ãƒ€ã‚’列挙ã—ãŸã ã‘ã§ã‚ã‚Šã€å®Ÿéš›ã«ã¯ã“ã®ä¸€éƒ¨ã—ã‹ä½¿ã„ã¾ã›ã‚“。 Value Object Service Object Form Object Query Object View Object Policy Object Decorator âš“ 肥大化ã—ãŸActive
RDBMSã®é›†ç´„関数ã®çµæžœã‚’ActiveRecordã§å–å¾—ã™ã‚‹æ–¹æ³• - 森薫ã®æ—¥è¨˜
Rails | 21:25 | SQLã®max()ã‚„mix()ã®å€¤ã‚’ActiveRecordã§å–å¾—ã™ã‚‹ã«ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«è¨˜è¿°ã—ã¾ã™ã€‚検索æ¡ä»¶ã‚’指定ã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ 最大値 (max)最大値をå–å¾— User.maximum(:login_count) User.maximum(:login_count, :conditions => {:age > 20}) 最å°å€¤ (min)最å°å€¤ã‚’å–å¾— User.minimum(:login_count) User.minimum(:login_count, :conditions => {:age > 20}) å¹³å‡ (avg)å¹³å‡å€¤ã‚’å–å¾— User.avg(:login_count) User.avg(:login_count, :conditions => {:age > 20}) åˆè¨ˆ (sum)åˆè¨ˆã‚’å–å¾— User.sum(:login_co
Rails ActiveRecord group_by & sum db results for use with Lazy HighCharts
I am completely new to RoR/Ruby and i am using Lazy High Charts gem to generate some purdy charts based on some database information. I have tried the answers that were provided in a previous question but i am still a bit confused as to how to do this.. I need to sum amount_used, and billed_amount and group by month/year (e.g; Aug/2012) The end result will be something similar to a dual axis chart
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
GitHub - jesjos/active_record_upsert: Upsert for Rails 5 / Active Record 5
GitHub - amatsuda/stateful_enum: A very simple state machine plugin built on top of ActiveRecord::Enum
{{#tags}}- {{label}}
{{/tags}}