First of all, sorry for the crossposting, but I put this into the Ruby
Forum first of all, but was pointed to this as a more appropriate
location.
I'm using ActiveRecord and ActiveSupport in a non-rails environment
to connect to multiple databases, and I've found the following (single
database) to cause me an error. Note that params is my database settings
and omitted for obvious reasons. pages, components, and books are all
tables in the same db.
require 'active_record'
module TestDB
class Inherited < ActiveRecord::Base
self.logger
self.default_timezone :utc
self.establish_connection(params)
end
class Page < Inherited
puts self.name
puts self.table_name
end
class Book < ActiveRecord::Base
puts self.name
puts self.table_name
end
end
class Component < ActiveRecord::Base
puts self.name
puts self.table_name
end
outputs:
TestDB::Page <= expected
inheriteds <= Hmm, table name for the parent?
TestDB::Book <= also expected
books <= Seems to be using the Inherited connection
Component <= Yep, no module name
components <= also using the Inherited connection
Is this expected behaviour from an inherited class. Is there anyway to
scope the ActiveRecord connection without resorting to plugins or other
gems?
You should set self.abstract_class = true on this class or
activerecord might think you're trying single table inheritance.
Fred
I've used inheritance with many of my models. To expand upon what Fred
is saying here, you really need to do two things. I'll show you an
example use and then you can configure your own class to use it:
One of my models is an inheritance template:
class InheritanceTemplate < ActiveRecord::Base
self.abstract_class = true
end
Other models inherit from this template by doing the following:
class MyPage < InheritanceTemplate
set_table_name "my_pages" #pluralized table name
end
etc.
Notice in the classes that are using the inheritance template you should
also set the table name so that there's no confusion going on in the
templates.
Frederick Cheung wrote:
class MyPage < InheritanceTemplate
set_table_name "my_pages" #pluralized table name
end
etc.
Notice in the classes that are using the inheritance template you should
also set the table name so that there's no confusion going on in the
templates.
I was doing that in the models that I had inherited, but if there isn't
a way to do it without setting the table name then I don't see the
benefit.
Frederick Cheung wrote:
class MyPage < InheritanceTemplate
set_table_name "my_pages" #pluralized table name
end
etc.
Notice in the classes that are using the inheritance template you should
also set the table name so that there's no confusion going on in the
templates.
I was doing that in the models that I had inherited, but if there isn't
a way to do it without setting the table name then I don't see the
benefit.
As Fred said, setting the table name is probably unnecessary.