moduleUtilsmoduleMySQL# 字段的备注字典defcolumn_commentsresult=show_columns(self.column_names)result.inject({}){|h,arr|h.merge(arr[0]=>arr[8])}.symbolize_keysend# 指定字段名的备注defcomment_of(field)field=field.to_sreturn""unlessself.column_names.include?(field)result=show_columns(field)result[0][8]endprivatedefshow_columns(field)condition_sql=iffield.is_a?(Array)"IN ('"+field.join("', '")+"')"else"= '#{field}'"endsql="SHOW FULL COLUMNS FROM `#{self.table_name}` WHERE FIELD "<<condition_sql# 自行根据需求,进行修改result=Rails.cache.fetch(sql)doself.connection.execute(sql).to_aendendendendunlessActiveRecord::Base.respond_to?(:column_comments)ActiveRecord::Base.send:extend,Utils::MySQLputs'_'*88+'Utils::MySQL'end