Affected rows for ActiveRecord::Base.connection.execute with Postgres

Question

Is there a way to get the number of affected rows resulting from a SQL operation using ActiveRecord::Base.connection.execute?

I found this answer for MySQL adapters, but it doesn't work with Postgres.

Alternatively, if there's a way to get the SQL text response (e.g. "UPDATE 126"), that would work too.

MrYoshiji · Accepted Answer · 2017-08-14 14:41:29Z

5

You can use cmd_tuples method:

sql = "UPDATE users SET updated_at = '#{DateTime.now}' WHERE id = 1"
ActiveRecord::Base.connection.execute(sql).cmd_tuples
# => 1

answered Aug 14, 2017 at 14:41

MrYoshiji

54.9k13 gold badges130 silver badges120 bronze badges

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

1 Answer 1