Sha256: 7ca7b37f51789242d04cf0fb145321fe1c2b1d48f38b13a781403bce7a1aa4f6
Contents?: true
Size: 810 Bytes
Versions: 5
Compression:
Stored size: 810 Bytes
Contents
# frozen_string_literal: true
require "cases/helper"
require "models/author"
require "models/post"
class Mysql2ExplainTest < ActiveRecord::Mysql2TestCase
fixtures :authors
def test_explain_for_one_query
explain = Author.where(id: 1).explain
assert_match %(EXPLAIN for: SELECT `authors`.* FROM `authors` WHERE `authors`.`id` = 1), explain
assert_match %r(authors |.* const), explain
end
def test_explain_with_eager_loading
explain = Author.where(id: 1).includes(:posts).explain
assert_match %(EXPLAIN for: SELECT `authors`.* FROM `authors` WHERE `authors`.`id` = 1), explain
assert_match %r(authors |.* const), explain
assert_match %(EXPLAIN for: SELECT `posts`.* FROM `posts` WHERE `posts`.`author_id` = 1), explain
assert_match %r(posts |.* ALL), explain
end
end
Version data entries
5 entries across 5 versions & 1 rubygems