class Baza::Driver::Mysql::Sql::Column

Constants

DATA_SQL_ALLOWED_KEYS

Attributes

data[R]

Public Class Methods

new(data) click to toggle source
# File lib/baza/driver/mysql/sql/column.rb, line 6
def initialize(data)
  @data = data
end

Public Instance Methods

sql() click to toggle source
# File lib/baza/driver/mysql/sql/column.rb, line 10
def sql
  data.each_key do |key|
    raise "Invalid key: '#{key}' (#{key.class.name})." unless DATA_SQL_ALLOWED_KEYS.include?(key)
  end

  raise "No type given." unless data[:type]
  type = data[:type].to_sym

  data[:maxlength] = 255 if type == :varchar && data[:maxlength].to_s.strip.empty?

  sql = "#{Baza::Driver::Mysql.quote_column(data.fetch(:name))} #{type}"
  sql << "(#{data[:maxlength]})" if data[:maxlength]
  sql << " PRIMARY KEY" if data[:primarykey]
  sql << " AUTO_INCREMENT" if data[:autoincr]
  sql << " NOT NULL" if data.key?(:null) && !data[:null]

  if data.key?(:default_func)
    sql << " DEFAULT #{data[:default_func]}"
  elsif data.key?(:default) && !data[:default].nil?
    sql << " DEFAULT #{Baza::Driver::Mysql.quote_value(data.fetch(:default))}"
  end

  sql << " COMMENT #{Baza::Driver::Mysql.quote_value(data.fetch(:comment))}" if data.key?(:comment)
  sql << " AFTER #{Baza::Driver::Mysql.quote_column(data.fetch(:after))}" if data[:after] && !data[:first]
  sql << " FIRST" if data[:first]
  sql << " STORAGE #{data[:storage].to_s.upcase}" if data[:storage]

  [sql]
end