instance method exec_query

Ruby on Rails 4.2.9

Since v4.0.13 Last seen in v5.2.8.1

Available in: v4.0.13 v4.1.16 v4.2.9 v5.2.8.1

Signature

exec_query(sql, name = nil, binds = [])

No documentation comment.

Parameters

sql req
name opt = nil
binds opt = []
Source
# File activerecord/lib/active_record/connection_adapters/sqlite3_adapter.rb, line 276
      def exec_query(sql, name = nil, binds = [])
        type_casted_binds = binds.map { |col, val|
          [col, type_cast(val, col)]
        }

        log(sql, name, type_casted_binds) do
          # Don't cache statements if they are not prepared
          if without_prepared_statement?(binds)
            stmt    = @connection.prepare(sql)
            begin
              cols    = stmt.columns
              records = stmt.to_a
            ensure
              stmt.close
            end
            stmt = records
          else
            cache = @statements[sql] ||= {
              :stmt => @connection.prepare(sql)
            }
            stmt = cache[:stmt]
            cols = cache[:cols] ||= stmt.columns
            stmt.reset!
            stmt.bind_params type_casted_binds.map { |_, val| val }
          end

          ActiveRecord::Result.new(cols, stmt.to_a)
        end
      end

Defined in activerecord/lib/active_record/connection_adapters/sqlite3_adapter.rb line 276 · View on GitHub · Improve this page · Find usages on GitHub

Defined in ActiveRecord::ConnectionAdapters::SQLite3Adapter

Type at least 2 characters to search.

↑↓ navigate · open · esc close