Affected strings for ActiveRecord :: Base.connection.execute using Postgres

Question

Is there a way to get the number of rows affected as a result of an SQL operation with ActiveRecord::Base.connection.execute?

I found this answer for MySQL adapters, but it does not work with Postgres.

Alternatively, if there is a way to get an SQL text response (for example, “UPDATE 126”), this will also work.

Answer 1

You can use the method cmd_tuples:

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

Documentation: http://www.rubydoc.info/gems/pg/0.17.1/PG%2FResult:cmd_tuples