Contents

class Maintenance < ActiveRecord::Base
  # Set table name to "change_logs"
  set_table_name 'change_logs'

  private

  # Save maintenance details when options
  def self.update_maintenance_record_with(option={})
    record = Maintenance.new(option)
    record.field_type = get_field_type(option[:table_name],option[:attribute_name]) unless option[:action].eql?('DELETE')
    record.created_at = Time.now
    record.save
  end

  # return the lastest version number for this change
  def self.get_version_number(id,table_name)
    latest_version = Maintenance.maximum(:version,:conditions=>['record_id = ? and table_name = ?',id,table_name])
    return latest_version.nil? ? 1 : latest_version.next
  end

  def self.get_field_type(table_name,field_name)
    return 'Error' if table_name.blank?||field_name.blank?
    ActiveRecord::Base.connection.columns(table_name).each do |field|
      return field.sql_type if field.name.eql?(field_name)
    end
  rescue
    return 'Error'
  end

end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
change_log-0.0.4	lib/change_log/maintenance.rb
change_log-0.0.3	lib/change_log/maintenance.rb
change_log-0.0.2	lib/change_log/maintenance.rb