#
#= 日本語名取得クラス
#-------------------------------------------------------------------------------
#++
module Comm
  module Tool
    class Jname
      def self.get_table_japanese_name(table_name)
        ret = ActiveRecord::Base.connection.execute("SHOW TABLE STATUS LIKE '#{table_name}'")
        tmp = ""
        ret.each {|x| tmp = x.last }
        ret.free
        return tmp
      end
      
      def self.get_column_japanese_name(table_name, column_name=nil)
        tmp = {}
        ret = ActiveRecord::Base.connection.execute("SHOW FULL COLUMNS FROM #{table_name}")
        ret.each {|x| tmp[x.first] = x.last }
        ret.free
        return column_name ? tmp[column_name] : tmp
      end
    end
  end
end