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 



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
48
49
50
 
# File 'lib/baza/driver/pg/create_index_sql_creator.rb', line 21

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.sep_index}#{@db.escape_index(index_data.fetch(:name))}#{@db.sep_index}"

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

  sql << " ("

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

  sql << ")"
end

#name_from_table_and_columns(table_name, column_names) ⇒ Object 



17
18
19
 
# File 'lib/baza/driver/pg/create_index_sql_creator.rb', line 17

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
13
14
15
 
# File 'lib/baza/driver/pg/create_index_sql_creator.rb', line 8

def sqls
  sqls = []
  @indexes.each do |index_data|
    sqls << create_sql(index_data, @create_args)
  end

  sqls
end