similar to: How to SELECT from multiple talbes with AR#find and associations?

Dears, [Rails 1.0.0] I''m working with a legacy schema, and around my 20+ models i''ve used some AR constructs. They are based on a finder_sql doing some dirty sql and using #{id} from the ''pivot'' model for extracting data in other tables. like : class Division < ActiveRecord::Base set_table_name "legacy_division" set_primary_key

Hello, I am attempting to create several plots based on "site" (~300 total) and am having trouble with the code. I simply want to create a plot using the code, plot(year, peak), for the following dataset. I would like for each site to be plotted on a separate page and the plots saved in a directory. Would a "foreach" loop work? I tried a "by" statement, but

Dear List-Colleagues: I have been working on installing Xen on Suse 10.3 for some time now. I am green as grass - both a total newbie to Xen and a relative newbie to Linux (as well as a total newbie to SuSE). Currently, I am at the point that when I click on the Xen entry in my grub loader I see Xen starting and running through much of its early setup. Eventually, however, it quits on

Hi there I''m planning to build "The Perfect Rails/Debian/Lighttpd Stack", published by Ezra Zygmuntowicz and Sean Schertell at http://brainspl.at/rails_stack.html I''m wondering what sort of constant maintanance that setup would incur. What actions have be regularly performed to keep this setup healthy and secure under normal conditions? Alder

Hi Let''s say we have model Foo. Each Foo instance can have several bars. Those bars are primitive, so they shouldn''t be models. For example, Foo might be a type of convention, and the bars might be years the convention was held in. Naively, we would have a conventions_years date, and put: has_many :years inside class Convention. But then we''d get an error, since for

Hi Let''s say we set session[:foo] = ''bar''. Now we want to remove the :foo key completely. How do you do that? Appearantly, session is a CGI::Session [1] instance, so it doesn''t have #delete like Hash. I tried: session[:foo] = nil But then debug(session) shows an empty :foo key. I''d like to remove that key, as my session is already pretty crowded. Is

File.open in core Ruby is nifty, in that it automagically closes the file when you''re done using/manipulating it. I''m wondering whether there''s something like that for ActiveRecord? So you can do: AR.find(23).open {|ar| ar.foo = ''bar'' ... } And ar.save would be called when the block closes. -- -Alder

A concrete example: We''re building a system to organize the information about workshops being held in various conventions. A convention has more than one workshop, and each workshop can be held in more than one convention. Also each workshop has a host, who is specific to a workshop being held in a specific convention. For example, Matz may host an "Introduction to Ruby"

I can submit a patch, but wanted to confirm I''m looking at this right... The docs indicate that if you specify a has_many association with :finder_sql, but no :counter_sql, it constructs the appropriate counter sql by substituting the SELECT clause. But has_many_association.rb doesn''t seem to do that -- it just passes Base#count_by_sql the finder_sql, which doesn''t

Hi there I need to store additional attributes on join table. Searching the Wiki [1] revealed two possible methods: 1) push_with_attributes, as described by Justin Palmer [2]. Unfortunately, "this method is now deprecated" [3]. Even if it wasn''t, there seem to be inherent problems with that approach, for example with updating those additional attributes, though Joshua Muheim

I''m sure there''s something right under my nose that I''m missing. I have two tables with two parallel one-to-many relationships. I wish to use the :finder_sql parameter to essentially ''or'' the two foreign keys. What isn''t working for me is performing a ''sub-search''. Let''s say the tables are "stores" and

Hi I have an action which saves the originating resource from which it was called, and returns to it later. This is done by setting: session[:return_to] = request.referer ... redirect_to(session[:return_to]) Which works great for GET resources. The problem is that POST variables aren''t kept in request.referer, so this method fails when the originating resource is a a POST.

Guys, I have a need to support as has_many/belongs_to relationship on a legacy(kind of) schema. The reason I say kind of is that the schema does have "id" columns that are used in many associations, but this particular has_many/belongs_to association needs to support different ones. I''ve attached to code at the end of this email. Suffice it to say I need to use the standard

I''ve got an order model that stores order data. One piece of data is a credit card type, which is a digit 1,2 or 3. I have a cardType model that has an id, shortName and LongName for the credit card merchant (visa, mastercard, amex). I want to be able to say: order.cardType.shortName, but can''t seem to get has_one working. It works with has_many and a finder_sql statement on

Hi I''m choosing a database for a new Rails application. I pretty much ruled out PostgreSQL, since despite good reviews of the database itself, it seems it has countless issues with Rails (for example: in recent releases migrations don''t work, and unit-tests fail). So I should now choose between MySQL 4.1, which as I understand enjoys widespread popularity - perhaps the most

This is my first rails app with a legacy database and I''m having a terrible time getting the models set up correctly. I have an order table that has a primary field named order_number. I have a name table with a primary of item_number. These two tables are liked by the item_number and the order_number, but not as you might think. If the order_number is 2500, then each entry in

Hi I created a custom route that looks like this: map.connect '':controller/:table/:action/:id'' Hierarchically, :table is above :action and :id. So, if we call ActionController::Base#url_for with an argument :table=>nil, we''re supposed to get a url with :action and :id set to nil as well. However, this is not the case: url_for(:table=>nil) from

Hi I was recently taught about the useful ActiveRecord::Base#serialize. It''s very useful for persisting arbitrary objects through the regular database. For example, say you want to store a Set of all the years a Convention took place. You do: class Convention < ActiveRecord::Base serialize :years, Set end This effectively creates a Convention#years attribute, which is a set: you

Hi there I''m considering Rails for a new web-application planned to be built from scratch. The application has an extensive web front, and in fact most of the application is interfaced through that front and engaged through clients'' HTTP requests (i.e. the conventional way web-applications and "dynamic web-sites" work). However, some essential parts are supposed to

I''m looking to implement model inheritance in a new application. Is there any good alternative to single-table-inheritance? -- -Alder