Class: SearchCraft::ViewHashStore

Inherits:
ActiveRecord::Base
  • Object
show all
Defined in:
lib/searchcraft/view_hash_store.rb

Overview

Stores the sha265 hash of the SQL used to create each view. This allows the Builder to determine if a view needs to be recreated. We don’t want to use ActiveRecord Migrations, instead want the view to be automatically recreated when any Builder’s #view_select_sql SQL changes.

The view SQL hashes are stored in a table named search_craft_view_hash_stores, which is automatically created by SearchCraft.

Class Method Summary collapse

Class Method Details

.changed?(builder:) ⇒ Boolean

Returns:

  • (Boolean) 


22
23
24
25
26
27
28
 
# File 'lib/searchcraft/view_hash_store.rb', line 22

def changed?(builder:)
  setup_table_if_needed!

  view_sql_hash = builder.view_sql_hash
  view_hash_store = exists?(builder: builder)
  !view_hash_store || view_hash_store.view_sql_hash != view_sql_hash
end

.exists?(builder:) ⇒ Boolean

Returns:

  • (Boolean) 


30
31
32
33
34
 
# File 'lib/searchcraft/view_hash_store.rb', line 30

def exists?(builder:)
  setup_table_if_needed!
  connection.schema_cache.data_source_exists?(builder.view_name) &&
    find_by(view_name: builder.view_name)
end

.reset!(builder:) ⇒ Object 



36
37
38
39
 
# File 'lib/searchcraft/view_hash_store.rb', line 36

def reset!(builder:)
  view_hash_store = find_by(view_name: builder.view_name)
  view_hash_store&.destroy!
end

.setup_table_if_needed! ⇒ Object 



41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
 
# File 'lib/searchcraft/view_hash_store.rb', line 41

def setup_table_if_needed!
  return if table_exists?

  # TODO: store its own sha265 hash in a table,
  # so we can detect if it changes during development
  # and recreate table if table is empty -- just in case

  # Migrate table
  create_table_sql = <<~SQL
    CREATE TABLE #{table_name} (
      id serial primary key,
      view_name varchar(255) not null,
      view_sql_hash varchar(255) not null,
      created_at timestamp not null default now(),
      updated_at timestamp not null default now()
    );
  SQL
  ActiveRecord::Base.connection.execute(create_table_sql)
  reset_column_information
end

.update_for(builder:) ⇒ Object 



15
16
17
18
19
20
 
# File 'lib/searchcraft/view_hash_store.rb', line 15

def update_for(builder:)
  setup_table_if_needed!
  view_sql_hash = builder.view_sql_hash
  view_hash_store = find_or_initialize_by(view_name: builder.view_name)
  view_hash_store.update!(view_sql_hash: view_sql_hash)
end