Class: Baza::Driver::Mysql::Sql::CreateTable

Inherits:
Object
  • Object
show all
Defined in:
lib/baza/driver/mysql/sql/create_table.rb

Instance Method Summary collapse

Constructor Details

#initialize(args) ⇒ CreateTable

Returns a new instance of CreateTable.



2
3
4
5
6
7
 
# File 'lib/baza/driver/mysql/sql/create_table.rb', line 2

def initialize(args)
  @name = args.fetch(:name)
  @columns = args.fetch(:columns)
  @indexes = args[:indexes]
  @temporary = args[:temporary]
end

Instance Method Details

#sql ⇒ Object 



9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
 
# File 'lib/baza/driver/mysql/sql/create_table.rb', line 9

def sql
  sql = "CREATE"
  sql << " TEMPORARY" if @temporary
  sql << " TABLE #{Baza::Driver::Mysql::SEPARATOR_TABLE}#{Baza::Driver::Mysql.escape_table(@name)}#{Baza::Driver::Mysql::SEPARATOR_TABLE} ("

  first = true
  @columns.each do |col_data|
    sql << ", " unless first
    first = false if first
    col_data.delete(:after) if col_data[:after]

    sql << Baza::Driver::Mysql::Sql::Column.new(col_data).sql.first
  end

  if @indexes && !@indexes.empty?
    sql << ", "
    sql << Baza::Driver::Mysql::Sql::CreateIndexes.new(
      indexes: @indexes,
      create: false,
      on_table: false,
      table_name: @name
    ).sql.first
  end

  sql << ")"

  [sql]
end