Request Column Name

Question

I have a table containing 2 "unusual" columns - order and like .

The table is replicated in two databases - MySQL and PostgreSQL .

And I need the same application to connect to both databases and use the same query for both:

 PageModel.where("`like` >= ?", params[:liked])

This will only work in MySQL .

How to make ActiveRecord to specify a column name?

Something like:

 PageModel.where("%s >= ?" % quote_column_name(:like), params[:liked])

I found a method that is useless right now - it just returns the column name without a quote.

Perhaps this is just a placeholder, and is there another way that does this?

+7

user904990 Dec 16 '12 at 11:31

source share

1 answer

vise · Accepted Answer · 2012-12-16T12:08:40+0000

It depends on one database adapter to another. Thus, each adapter overrides this method with its own definition.

Are you interested in:

 ActiveRecord::Base.connection.quote_column_name "my_column"