similar to: legacy column names

I''m tinkering around with an old legacy table in SQL Server 2000. Ruby 1.8.4, most recent ADO.rb file from RubyForge, Rails 1.0 Here''s the model: class InventoryItem < ActiveRecord::Base set_table_name "[_SMDBA_].[_INVENTOR_]" set_primary_key "sequence" end Everything works fine. I can retrieve records without issue. However, when create a new

I have a legacy database with which I need to interface. There are two tables that are joined together by two fields, and neither field is the primary key of its associated table. Is constructing an association between these tables beyond the capability of Rails? -- Posted via http://www.ruby-forum.com/.

I have a legacy MySQL database with a weird naming convention - all table and column names have a prefix ''_'' , which is annoying, and some of the column names are misnomers. I would like to apply a pre-defined mapping between MySQL column names and method names to be used in the Ruby class, without having the original column names being visible anymore. how can I pre-define a

I have an ActiveRecord question... I have a legacy MySQL database with a weird naming convention - all table and column names have a prefix ''_'' , which is annoying, and some of the column names are plain misnomers. I would like to apply a pre-defined mapping between MySQL column names and method names to be used in the Ruby class, without having the underlying column names

I''m looking for the simplest way to *automatically* downcase the attribute names of Models mapped to legacy tables that use upper case. eg: class Workorder < ActiveRecord::Base set_table_name "WORKORDER" end which has "NAME" as an attribute can use "name" as an attribute. currently: workorder = Workorder.find(1) workorder.NAME # =>

All, I''ve found an issue that is somewhat strange. Assume: An AR object backed by a legacy schema which includes column names that start with a capital letter. Summary: In a partial view, you cannot access an overridden getter method for a column on your model object if that method name is equal to the column name and the column name starts with a capital letter. Observations:

Hi I''m building a Rails app that intereacts with several legacy databases, all on Postgres 7.4 and running into a few quirky problems. I seem to have a lot of inconsistencies w/ quoting field names in Postgres. I''ve written another app from scratch using Postgres and encountered quoting trouble there too. But it seemed tied to the machine I was serving the app from.

Hi I have a table called active and another one called authreg I did a one to one relation but it turns out that one of this legacy database column name has an hyphen!!! "-" now im screw how can I tell rails to use it? or make an alias of some sort like with table names.? @active = Active.new( :collection-owner => authreg.username, :time =>

For a while, I''ve been getting that HMT is replacing HABTM. It appears that HMT can do all of what HABTM can do and more. The question is: Should I stop using HABTM? Let''s take a simple case: A case has many categories For a given category, there are certain valid statuses Category has_and_belongs_to_many :statuses Status has_and_belongs_to_many :categories Question: Is

I''ve been listening to the discussions regarding the plans to eliminate push_with_attributes. While I think it''s good practice to make join models if you''re developing a new system, I can''t help but think t hat push_with_attributes should be left around to deal with legacy databases. I might want to wrap my application around a database I don''t

I''ve been stumped on this for a few days and I''m not sure if it''s an error on my end or an actual bug. I have a system where I have workshops and users. Workshops have students, presenters, and troubleshooters. I wanted to represent this simply by using has_many :through with :source. Workshop has_many :presenters, :through =>:presenterships, :source=>:user

Hi all, Is there anyway to work around having a $ in the column name (c$car_type)? I can''t change the legacy table and I haven''t found a way to alias a column name. Am I just SOL and can''t use rails in this case or am I missing something? Brent __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection

What is the most RoR friendly way of making a form mailer similar to this php one? http://tips-scripts.com/?tip=form_mail#tip Or is it easier just to use the php with RoR? -- Posted via http://www.ruby-forum.com/.

Does anyone know of any services that could be used to authenticate a user that would be a member of the general public? One of the projects we''re looking at here needs to have forms signed by parents of students. Since we simply can''t put every parent or guardian in our databse, we need a way to outsource the authentication. I''m wondering if there are any services that

I am connecting to a legacy DB that has some names plural and some not. I have configured: ActiveRecord::Base.pluralize_table_names = false now when i make a table that has an s on the end, it truncates the s. example: Table name: foo_bars Rails command: ruby script/generate FooBars Response (localhost:3000/FooBars): uninitialized constant FooBar It works fine with non-pluralized

I work at an organization that is very wrapped up in Microsoft products. I am trying to get a test application put in however I''m not sure what to do about the infratstructure. If it were up to me we would put in MySQL and Apache or Lighty, however its not up to me. The easiest way to get an application into production at our company would be to use the existing MS SQL server and IIS

Hello all, I am very happy to announce that registration for my new course entitled "Ruby on Rails Development" at my college is now open. We are offering this course as part of our LAMP certificate which is designed for working professionals who want to upgrade their skills. I think that it is a sign of Rails'' growing maturity that I was able to propose this and work it

I''d like to better understand the criticisms I''ve seen of Rails'' ability to handle legacy data. The ones I''m interested in are those based on Rails'' naming conventions for tables. In my experience in large corporate environments programmers / programs don''t access db tables directly. They access views of those tables. And, to my

Thank you for writing and pointing out that one can have WAVE files without getting the warning, and that your library does it. I found out Goldwave (Windows software) writes 24-bit WAVE files that do not get the warning. (Good for them!) However, the flac executable from the flac reference software apparently produces WAVE files that do get the warning. Example annotated log: Encode a 24-bit

Hi list, first evening of playing with rails, so please forgive me if I ask something stupid. ;-) I created a User model and tried to use ActiveRecord callbacks to convert the password to sha1 just before saving it. For some reason postgresql gives me a error because the given password is null. To test even further I tried to change :login too, same error happens, :login is empty too. I am sure