module Sequel::Cubrid::DatabaseMethods

# File lib/sequel/adapters/shared/cubrid.rb, line 13
def database_type
  :cubrid
end

# File lib/sequel/adapters/shared/cubrid.rb, line 17
def indexes(table, opts=OPTS)
  m = output_identifier_meth
  m2 = input_identifier_meth
  indexes = {}
  metadata_dataset.
    from(:db_index___i).
    join(:db_index_key___k, :index_name=>:index_name, :class_name=>:class_name).
    where(:i__class_name=>m2.call(table), :is_primary_key=>'NO').
    order(:k__key_order).
    select(:i__index_name, :k__key_attr_name___column, :is_unique).
    each do |row|
      index = indexes[m.call(row[:index_name])] ||= {:columns=>[], :unique=>row[:is_unique]=='YES'}
      index[:columns] << m.call(row[:column])
    end
  indexes
end

# File lib/sequel/adapters/shared/cubrid.rb, line 38
def schema_parse_table(table_name, opts)
  m = output_identifier_meth(opts[:dataset])
  m2 = input_identifier_meth(opts[:dataset])

  pks = metadata_dataset.
    from(:db_index___i).
    join(:db_index_key___k, :index_name=>:index_name, :class_name=>:class_name).
    where(:i__class_name=>m2.call(table_name), :is_primary_key=>'YES').
    order(:k__key_order).
    select_map(:k__key_attr_name).
    map{|c| m.call(c)}

  metadata_dataset.
    from(:db_attribute).
    where(:class_name=>m2.call(table_name)).
    order(:def_order).
    select(:attr_name, :data_type___db_type, :default_value___default, :is_nullable___allow_null).
    map do |row|
      name = m.call(row.delete(:attr_name))
      row[:allow_null] = row[:allow_null] == 'YES'
      row[:primary_key] = pks.include?(name)
      row[:type] = schema_column_type(row[:db_type])
      [name, row]
    end
end

# File lib/sequel/adapters/shared/cubrid.rb, line 34
def supports_savepoints?
  false
end

# File lib/sequel/adapters/shared/cubrid.rb, line 64
def tables(opts=OPTS)
  _tables('CLASS')
end

# File lib/sequel/adapters/shared/cubrid.rb, line 68
def views(opts=OPTS)
  _tables('VCLASS')
end