Rails を使用ã—ãªã„ ActiveRecord + Migrate - chaotic valkyrie
メモ代ã‚り。 ActiveRecord require 'rubygems' require 'active_record' ActiveRecord::Base.establish_connection( :adapter => 'postgresql', :host => 'localhost', :username => 'foo', :database => 'baz', :encoding => 'utf8' ) class User < ActiveRecord::Base end User.find(:all).each do |u| p u end Migrate Rakefile ã»ã‚“ã¨ã¯è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã‚ã‘ãŸã»ã†ãŒã„ã„ã‚“ã ã‘ã©ã require 'rubygems' require 'active_record' require 'logger' ActiveRecord:
nick - HasFinder -- It's Now Easier than ever to create complex, re-usable SQL queries
HasFinder is an extension to ActiveRecord that makes it easier than ever to create custom find and count queries. Let's start with an example. Suppose you have an Article model; some articles are published, some are popular. Let's declare finders for each of these notions. You may be tempted to write something like the following: class Article < ActiveRecord::Base def self.published find(:all, :co
compositekeys ActiveRecord Composite Primary Keys
→ Ruby on Rails → ActiveRecords What Ruby on Rails does not support composite primary keys. This free software is an extension to the database layer of Rails – ActiveRecords – to support composite primary keys as transparently as possible. Any Ruby script using ActiveRecords can use Composite Primary Keys with this library. Installing sudo gem install composite_primary_keys Rails: Add the followi
Better Nested Set for Ruby on rails - Trac
Welcome to Better Nested Set for Ruby on Rails This is a plugin to replace acts_as_nested_set and ehance it. What is nested set ? It's a great and smart way to represent ordered trees into a table. Joe Celko explained this solution in a famous article in 1996. What is it useful for ? Categories, or menus, are often organized as ordered trees. Rails provides the good acts_as_tree, but it cannot han
[rails][è² è·åˆ†æ•£]Railsã®DBè² è·åˆ†æ•£èª¿æŸ»ã®ãŸã‚ã®è³‡æ–™ - yoshitetsuã®æ—¥è¨˜
magic_multi_connections Magic Multi-Connections magic_multi_connectionsã®ãƒšãƒ¼ã‚¸ Magic Multi-Connections: A “facility in Rails to talk to more than one database at a time†magic_multi_connections作ã£ãŸäººã®è¨˜äº‹ Twitterã®ãƒˆãƒ©ãƒ–ルã‹ã‚‰è¦‹ã‚‹ã€DB分割ã§ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ルãªRailsサイト構築 magic_multi_connectionsã®ä½¿ã„æ–¹ãŒã®ã£ã¦ã‚‹ Ruby on Railsã§Magic Multi-Connectionsを使ㆠmagic_multi_connectionsã®ä½¿ã„æ–¹ãŒã®ã£ã¦ã‚‹ 分散DB対応ライブラリ Magic Multi-Connections を試ã—ã¦ã¿ã‚‹ magic_multi_
![[rails][è² è·åˆ†æ•£]Railsã®DBè² è·åˆ†æ•£èª¿æŸ»ã®ãŸã‚ã®è³‡æ–™ - yoshitetsuã®æ—¥è¨˜](https://cdn-ak-scissors.b.st-hatena.com/image/square/438548124851f1bc8c72d6b93ef644a077b1ada8/height=288;version=1;width=512/https%3A%2F%2Fogimage.blog.st-hatena.com%2F17680117127121096700%2F17680117127121100502%2F1557249666)
Foreign Key to Foreign Key Relationships and Single Table Inheritance in Ruby on Rails
Foreign Key to Foreign Key Relationships and Single Table Inheritance in Ruby on Rails ActiveRecord is great and efficient for simple normalized databases, but once you start tread off the beaten path ActiveRecord starts to lose a lot of its mojo. A few months ago I had a rather abstract database that utilized a number of models based on Single Table Inheritance (STI). Prior to refactoring our our
Plugins - ActiveRecord::Base Without Table - Agile Web Development
Get the power of ActiveRecord models, including validation, without having a table in the database. class Contact < ActiveRecord::BaseWithoutTable column :name, :string column :email_address, :string column :message, :text validates_presence_of :name, :email_address, :string end This model can be used just like a regular model based on a table, except it will never be saved to the database. Name U
has_many :through - Book Review: Pro Active Record
I've been wanting to start doing some book reviews for a while, so here goes. The folks at Apress have been kind enough to send me review copies of a couple books, so I'm going to start with one of them. First up, Pro Active Record. Title: Pro Active Record: Databases with Ruby and Rails Authors: Kevin Marshall, Chad Pytel, Jon Yurek Publisher: Apress My first thought at seeing this book was, "Hey
Matzã«ã£ã(2007-08-31) ruby->sql converter
<< 2007/08/ 1 1. [言語] 連載：C# 2.0入門 第3回　新ã—ã„ç¹°ã‚Šè¿”ã—ã®ã‚¹ã‚¿ã‚¤ãƒ« − yield returnæ–‡ã¨ForEachメソッド − ï¼ IT 2. [Ruby] Shoes, a Tiny Toolkit for Making Browser-like Things 2 1. [OSS] Download Hadoop at OSCON (Yahoo! Developer Network blog) 2. ウェブã‚ャリアã§Webエンジニアã¨ã—ã¦ã®ã‚ャリアを磨ã“ã†ã€€æ ªå¼ä¼šç¤¾ã‚¦ã‚§ãƒ–ã‚ャリア 3. å…ˆé”ã®æ¥ç•Œã«å¦ã¶ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆ 第1回　20å¹´ã¯é…ã‚Œã¦ã„ã‚‹ITプãƒãƒžãƒï¼šITpro 4. 横浜 3 1. [OSS] 特別講演：「オープンソース・ソフトウェア開発æ€æƒ³ã¨ãƒªã‚¢ãƒ«ãªåœ°åŸŸãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã®é€£ 2. [Ruby] トークセッション-5：「世界ã«åºƒãŒã‚‹ã‚ªãƒ–ジェク
Full of Ambition — err.the_blog
This idea has been kicked around a whole lot, I know. In IRC. Dark alleyways. Sweaty dance halls. Courts of law. It’s this: instead of writing SQL, write Ruby. Generate the SQL behind the curtain. Something like this: User.detect { |u| u.name == 'Jericho' && u.age == 22 } Or this: User.select { |u| [1, 2, 3, 4].include? u.id } Or even this: User.select { |u| u.name =~ 'rick' }.sort_by(&:age) It’d
SQLã®æ¡ä»¶ã‚’組ã¿ç«‹ã¦ã‚‹Railsプラグイン Condition Builder 1.1 - ã“ã›ãã®æŠ€è¡“日記
Railsã§SQLã®æ¡ä»¶ã‚’扱ã†ã€Condition BuilderプラグインãŒä¾¿åˆ©ã§ã™ã€‚ 最新版(1.1) http://blog.inquirylabs.com/2007/06/28/condition-builder-11/ 説明 http://blog.inquirylabs.com/2007/01/04/condition-builder-10-released/ 以å‰ã®è¨˜äº‹ http://blog.inquirylabs.com/index.php?s=condition+builder&submit=Search Conditionクラスã®ãƒ¡ã‚½ãƒƒãƒ‰ä¸€è¦§ 通常ã€ActiveRecordã«æ¡ä»¶ã‚’指定ã™ã‚‹å ´åˆã€:conditionsオプション㧠["a = ? AND b = ?", 1 , 2] ã®ã‚ˆã†ãªé…列を指定ã—ã¾ã™ã€‚ã“ã®é…列ã®æ§‹ç¯‰ã‚’サãƒãƒ¼ãƒˆã—ã¦ãれるã®ãŒConditionBu
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚了日を2020å¹´1月31æ—¥(金)ã«æ±ºå®šã—ã¾ã—㟠- ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚了日を2020å¹´1月31æ—¥(金)ã«æ±ºå®šã—ã¾ã—㟠以下ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’目処ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—を終了予定ã§ã‚る旨をãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019年末を目処ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æ供を終了ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—日記 ã“ã®ãŸã³ã€æ£å¼ã«çµ‚了日を決定ã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”確èªãã ã•ã„。 終了日: 2020å¹´1月31æ—¥(金) エクスãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1月31æ—¥(金) 終了日以é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“。日記ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„。 ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„㦠- ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—日記 ã”利用ã®ã¿ãªã•ã¾ã«ã¯ã”迷惑をãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 追記 ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—日記ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2月28
ApplicationModel クラスã®ã‚¹ã‚¹ãƒ¡ (STI ã¨ã®å…±å˜) - ヽ( ・∀・)ノãã¾ãã¾ãƒ¼(2007-09-02)
Rails ã§é•å’Œæ„Ÿã‚’覚ãˆã‚‹ã®ã¯ã€ãƒ¢ãƒ‡ãƒ«ã«ã ã‘アプリケーション層ã«åŸºåº•ã‚¯ãƒ©ã‚¹ãŒç”¨æ„ã•ã‚Œã¦ã„ãªã„所。é•å’Œæ„Ÿã®æ£ä½“ã¯MVCã®å¯¾ç§°æ€§ã ã‘ã§ã¯ãªãã€å®Ÿéš›ã«ä¸ä¾¿ãªã®ã 。ã“ã“ã§è¨€ã†ã€Œã‚¢ãƒ—リケーション層ã®åŸºåº•ã‚¯ãƒ©ã‚¹ã€ã¨ã¯ã€ãƒ•ãƒ¬ãƒ¼ãƒ ワークレベルã«ç›´æŽ¥å®šç¾©ã™ã‚‹ã®ã¯æ°—ãŒã²ã‘ã‚‹ã‘ã©ã€ç¾åœ¨ã®ã‚¢ãƒ—リケーションã§è‡ªåˆ†ãŒå®šç¾©ã™ã‚‹ã‚¯ãƒ©ã‚¹å…¨ä½“ã«ã¯å½±éŸ¿ã‚’与ãˆãŸã„よã†ãªå®šç¾©ã‚’è¡Œã†ã‚¯ãƒ©ã‚¹ã®æ„。例ãˆã°ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³æƒ…å ±ã§ã‚ã‚Œã°ã€ãƒ•ãƒ¬ãƒ¼ãƒ ワークレベルã§ãªãã€ApplicationControllerã«å®šç¾©ã™ã‚‹ã®ãŒè‡ªç„¶ã ã—ã€ç¾åœ¨ã® ActionPack ã§ã‚‚ãã†ã„ã†å®Ÿè£…ã«ãªã£ã¦ã„る。åŒã˜ã“ã¨ãŒãƒ“ュー(ヘルパ)ã«ãŠã„ã¦ã‚‚å¯èƒ½ã ãŒã€ãƒ¢ãƒ‡ãƒ«ã ã‘ã¯ãªãœã‹ ActiveRecord::Base を直接継承ã—ã¦ãŠã‚Šã€ã“ã‚ŒãŒä¸ä¾¿ãªå±€é¢ãŒå¤šã€…ã‚る。 ApplicationModel 具体的ã«ã¯ã€æ—¢å˜ã®NKSKプãƒã‚¸ã‚§ã‚¯ãƒˆã®ãƒ¢ãƒ‡ãƒ«(クラス群)を別ã®ãƒ—ãƒã‚¸
1
ランã‚ング
ランã‚ング
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
http://actsasnetwork.rubyforge.org/
How to Use Multiple Databases on Rails - English As A Programming Language - s21g
http://plugins.require.errtheblog.com/browser/cache_fu
ライブドアブãƒã‚°ï½œç„¡æ–™ã§è±Šå¯Œãªæ©Ÿèƒ½ãŒå……実
{{#tags}}- {{label}}
{{/tags}}