Class: SqliteIndexChecker

Inherits:
IndexChecker show all
Defined in:
lib/uses_index/index_checkers/sqlite.rb

Instance Method Summary collapse

Methods inherited from IndexChecker

for_adapter

Instance Method Details

#check(query, expected_index, connection = ActiveRecord::Base.connection) ⇒ Object 



4
5
6
7
 
# File 'lib/uses_index/index_checkers/sqlite.rb', line 4

def check(query, expected_index, connection = ActiveRecord::Base.connection)
  sql = query.to_sql
  check_sql(sql, expected_index, connection)
end

#check_sql(sql, expected_index, connection = ActiveRecord::Base.connection, binds: nil) ⇒ Object 



9
10
11
12
13
14
15
 
# File 'lib/uses_index/index_checkers/sqlite.rb', line 9

def check_sql(sql, expected_index, connection = ActiveRecord::Base.connection, binds: nil)
  sql = substitute_binds(sql, binds, connection) if binds
  explain_sql = "EXPLAIN QUERY PLAN #{sql}"
  result = connection.execute(explain_sql)
  plan = result.map { |row| row.values.join(' ') }.join(' ')
  plan.downcase.include?(expected_index.downcase)
end