instance method `execute`

Ruby on Rails 6.1.7.10

Since v4.2.9 Last seen in v7.0.10

Available in: v4.2.9 v5.2.8.1 v6.0.6 v6.1.7.10 v7.0.10

Compare with:

execute(sql, name = nil)

Executes an SQL statement, returning a PG::Result object on success or raising a PG::Error exception otherwise. Note: the PG::Result object is manually memory managed; if you don’t need it specifically, you may want consider the exec_query wrapper.

Parameters

sql req
name opt = nil

Source

# File activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb, line 39
        def execute(sql, name = nil)
          if preventing_writes? && write_query?(sql)
            raise ActiveRecord::ReadOnlyError, "Write query attempted while in readonly mode: #{sql}"
          end

          materialize_transactions
          mark_transaction_written_if_write(sql)

          log(sql, name) do
            ActiveSupport::Dependencies.interlock.permit_concurrent_loads do
              @connection.async_exec(sql)
            end
          end
        end

Defined in activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb line 39 · View on GitHub · Improve this page · Find usages on GitHub

Defined in ActiveRecord::ConnectionAdapters::PostgreSQL::DatabaseStatements

Signature

Parameters