Class: Qa::Authorities::Local::MysqlTableBasedAuthority

Inherits:
TableBasedAuthority show all
Defined in:
lib/qa/authorities/local/mysql_table_based_authority.rb

Instance Attribute Summary

Attributes inherited from TableBasedAuthority

#subauthority

Class Method Summary collapse

Instance Method Summary collapse

Methods inherited from TableBasedAuthority

#all, #find, #initialize

Methods inherited from Base

#all, #find, #full_record

Constructor Details

This class inherits a constructor from Qa::Authorities::Local::TableBasedAuthority

Class Method Details

.check_for_index ⇒ Object 



6
7
8
9
10
11
12
13
14
 
# File 'lib/qa/authorities/local/mysql_table_based_authority.rb', line 6

def self.check_for_index
  conn = ActiveRecord::Base.connection
  if table_or_view_exists? && conn.index_name_exists?(:qa_local_authority_entries, 'index_qa_local_authority_entries_on_lower_label_and_authority', :default).blank?
    Rails.logger.error "You've installed mysql local authority tables, but you haven't indexed the lower label.  Rails doesn't support functional indexes in migrations, so we tried to execute it for you but something went wrong...\n" \
      'Make sure your table has a lower_label column which is virtuall created and that column is indexed' \
      ' ALTER TABLE qa_local_authority_entries ADD lower_label VARCHAR(256) GENERATED ALWAYS AS (lower(label)) VIRTUAL' \
      ' CREATE INDEX index_qa_local_authority_entries_on_lower_label_and_authority ON qa_local_authority_entries (local_authority_id, lower_label)'
  end
end

Instance Method Details

#search(q) ⇒ Object 



16
17
18
19
 
# File 'lib/qa/authorities/local/mysql_table_based_authority.rb', line 16

def search(q)
  return [] if q.blank?
  output_set(base_relation.where('lower_label like ?', "#{q.downcase}%").limit(25))
end