Sha256: 6d3f1ae196e078431287bc959d1596dbb19ad5256c2be89ca83968c8ab8ec6cc
Contents?: true
Size: 833 Bytes
Versions: 4
Compression:
Stored size: 833 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
4 entries across 4 versions & 1 rubygems