Contents

class Baza::Driver::Mysql::Sql::Column
  DATA_SQL_ALLOWED_KEYS = [:type, :maxlength, :name, :primarykey, :autoincr, :default, :comment, :after, :first, :storage, :null, :renames].freeze

  attr_reader :data

  def initialize(data)
    @data = data
  end

  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::SEPARATOR_COLUMN}#{Baza::Driver::Mysql.escape_column(data.fetch(:name))}#{Baza::Driver::Mysql::SEPARATOR_COLUMN} #{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.sqlval(data.fetch(:default))}"
    end

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

    [sql]
  end
end

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
baza-0.0.35	lib/baza/driver/mysql/sql/column.rb
baza-0.0.34	lib/baza/driver/mysql/sql/column.rb
baza-0.0.33	lib/baza/driver/mysql/sql/column.rb
baza-0.0.32	lib/baza/driver/mysql/sql/column.rb
baza-0.0.31	lib/baza/driver/mysql/sql/column.rb
baza-0.0.30	lib/baza/driver/mysql/sql/column.rb
baza-0.0.29	lib/baza/driver/mysql/sql/column.rb
baza-0.0.28	lib/baza/driver/mysql/sql/column.rb