NoMethodError When Using Database Column Aliases in Rails

Question

Undefined method errors when I try to use a column alias for an aggregate (PostgreSQL)

Inside my model:

class B2bLoginAttempt < ActiveRecord::Base
  set_table_name "b2b_logins"
end

Inside my controller:

    @client_ip = request.env['REMOTE_ADDR']
    @sql = "select count(id) as failed_logins FROM b2b_logins WHERE ip_address = '"+@client_ip+"'"

    f = B2bLoginAttempt.find_by_sql(@sql)
    failed_attempts = f.failed_logins.to_s
    f.destroy

Then I see: undefined method `failed_logins' for #<Array:0x104d08478>

Khaled · Accepted Answer · 2012-12-20 16:26:31Z

2

The error occurs because find_by_sql returns an array, so you need to write f.first.failed_logins.to_s instead of f.failed_logins.to_s. Check find_by_sql doc here.

answered Dec 20, 2012 at 16:26

Khaled

2,0911 gold badge18 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Brian · Accepted Answer · 2012-12-20 16:44:03Z

1

Not sure I am completely following your logic correctly, but it seems like you may be better off with this:

f = B2bLoginAttempt.where("ip_address = ?", @client_ip)

f.map(&:destroy)

You can get the actual count with f.count

Did I miss something?

answered Dec 20, 2012 at 16:44

Brian

6,8603 gold badges31 silver badges28 bronze badges

Collectives™ on Stack Overflow

NoMethodError When Using Database Column Aliases in Rails

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related