Class: Baza::Driver::Pg::CreateIndexSqlCreator

Inherits:
Object
  • Object
show all
Defined in:
lib/baza/driver/pg/create_index_sql_creator.rb

Instance Method Summary collapse

Constructor Details

#initialize(args) ⇒ CreateIndexSqlCreator

Returns a new instance of CreateIndexSqlCreator.



2
3
4
5
6
 
# File 'lib/baza/driver/pg/create_index_sql_creator.rb', line 2

def initialize(args)
  @db = args.fetch(:db)
  @indexes = args.fetch(:indexes)
  @create_args = args.fetch(:create_args)
end

Instance Method Details

#create_sql(index_data, args) ⇒ Object 



18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
 
# File 'lib/baza/driver/pg/create_index_sql_creator.rb', line 18

def create_sql(index_data, args)
  sql = ""
  sql << "CREATE" if args[:create] || !args.key?(:create)

  if index_data.is_a?(String) || index_data.is_a?(Symbol)
    index_data = {name: index_data, columns: [index_data]}
  elsif index_data[:name].to_s.strip.empty?
    index_data[:name] = name_from_table_and_columns(args[:table_name] || name, index_data.fetch(:columns))
  end

  raise "No columns was given on index: '#{index_data.fetch(:name)}'." if !index_data[:columns] || index_data[:columns].empty?

  sql << " UNIQUE" if index_data[:unique]
  sql << " INDEX #{@db.quote_index(index_data.fetch(:name))}"

  if args[:on_table] || !args.key?(:on_table)
    sql << " ON #{@db.quote_table(args.fetch(:table_name))}"
  end

  sql << " ("

  first = true
  index_data.fetch(:columns).each do |col_name|
    sql << ", " unless first
    first = false if first
    sql << @db.quote_column(col_name)
  end

  sql << ")"
end

#name_from_table_and_columns(table_name, column_names) ⇒ Object 



14
15
16
 
# File 'lib/baza/driver/pg/create_index_sql_creator.rb', line 14

def name_from_table_and_columns(table_name, column_names)
  "index_on_#{table_name}_#{column_names.join("_")}"
end

#sqls ⇒ Object 



8
9
10
11
12
 
# File 'lib/baza/driver/pg/create_index_sql_creator.rb', line 8

def sqls
  @indexes.map do |index_data|
    create_sql(index_data, @create_args)
  end
end