Rails 3.x How to write update all based on row value?

Question

I would like the following SQL query to be executed in a migration file after adding a column (updating the new field with existing column value from the same row)

UPDATE users SET last_login=updated_at;

The SQL statements work properly when executed on the database, but in rails I tried multiple syntax using the ActiveRecord update_all method but without success

User.update_all("last_login=updated_at")

I get the following error

ActiveRecord::StatementInvalid: PGError: ERROR:  current transaction is aborted, commands ignored until end of transaction block
: UPDATE "users" SET last_login=updated_at

Obviously something is missing in my syntax, but can't figure out what. Can anyone point me to the right syntax?

Regards/J.

Can it be some validation problem, like the example on this link? http://guides.rubyonrails.org/migrations.html#using-models-in-your-migrations — Matzi, Apr 27 '12 at 10:31

score 3 · Accepted Answer · edited May 23 '17 at 12:06

3

Syntax is indeed correct, the issue was relying in the fact that I had to rollback the previous transaction.

User.update_all("last_login=updated_at")

This statement works properly.

edited May 23 '17 at 12:06

Community

1
1

answered Apr 30 '12 at 05:32

jlamberc

85
8

Rails 3.x How to write update all based on row value?

1 Answers1

Linked