Ruby on Rails. Key value table for site configuration integrated with Active admin and formtastic forms

20120118012543_create_site_configuration.rb

# db/migrations/20120118012543_create_site_configuration.rb

class CreateSiteConfigurations < ActiveRecord::Migration
  def change
    create_table :site_configurations do |t|
      t.string  :key
      t.text    :value
      t.string  :form_type
      t.string  :form_collection_command

      t.timestamps
    end

    add_index :site_configurations, :key, unique: true
  end
end

index.html.haml

// app/views/admin/settings/index.html.haml

= semantic_form_for :update_site_configuration, :url => admin_site_configuration_path(0), :method => :put do |form|
  = form.inputs do
    - SiteConfiguration.all.each do |record|
      = form.input record.key.to_sym, as: record.form_type.to_sym, input_html: {value: record.value}, :include_blank => false, collection: (options_from_collection_for_select(eval(record.form_collection_command), 'id', 'to_s', record.value) if record.form_collection_command.present?)
  = form.buttons do
    = form.submit "Update Site Configuration"

site_configuration.rb

# app/models/site_configuration.rb

class SiteConfiguration < ActiveRecord::Base
  serialize :value

  class_attribute :settings
  self.settings = []

  def self.ensure_created
    self.settings.each do |setting|
      self.send(setting)
    end
  end

  def self.setting(name, default, form_type, form_collection_command="")
    class_eval <<-EOC
      self.settings << "#{name}"
      def self.#{name}
        @#{name} ||= self.find_or_create_by_key("#{name}", value: #{default}, form_type: "#{form_type}", form_collection_command: "#{form_collection_command}").value
      end
      def self.#{name}=(value)
        record = self.find_or_create_by_key("#{name}", value: #{default}, form_type: "#{form_type}", form_collection_command: "#{form_collection_command}")
        record.value = value
        record.save!
        @#{name} = value
      end
    EOC
  end

  # Define settings by listing them here
  setting :contact_page_id,           2,                      :select,  "Page.all"
  setting :top_menu_id,               1,                      :select,  "Menu.all"
  setting :customer_service_menu_id,  2,                      :select,  "Menu.all"
  setting :footer_menu_id,            3,                      :select,  "Menu.all"
  setting :notification_addresses,    "'[email protected]'",  :string

  # Ensure all the defaults are created when the class file is read
  self.ensure_created
end

site_configurations.rb

# app/admin/site_configurations.rb

ActiveAdmin.register SiteConfiguration do
  actions :only => [:index, :update]

  before_filter do
    @skip_sidebar = true
  end

  config.comments = false
  config.clear_action_items!

  controller do
    def index
      params[:action] = "Site Configuration" # for the active admin title
      render 'admin/settings/index', :layout => 'active_admin'
    end
    def update
      params[:update_site_configuration].each do |setting, value|
        SiteConfiguration.send("#{setting}=", value)
      end
      redirect_to :back, notice: "Settings Saved"
    end
  end

end

When defining a setting:

• name = name of the setting
• default = default value of the setting
• form_type = the formtastic type used when rendering the form in active admin (eg: :string, :select, :check_boxes, :hidden, etc)
• form_collection_command = the ruby command that will be run to generate an active relation that is used to define the collection offered as options when rendering the formtastic form. Use this for :select, :radio_buttons and :check_boxes.