How (replace | create) an enumeration field on rail 2.0 routes?

Question

I would like to create an enum field with sone migration, which I do, I tried searching on google but cannot find a way to do this in migration

The only thing I found is

t.column :status, :enum, :limit => [:accepted, :cancelled, :pending] 

but it looks like the above code only works on rails 1.xxx, and since I am running rails 2.0

this is what i tried but it fails

 class CreatePayments < ActiveRecord::Migration def self.up create_table :payments do |t| t.string :concept t.integer :user_id t.text :notes t.enum :status, :limit => [:accepted, :cancelled, :pending] t.timestamps end end def self.down drop_table :payments end end 

So, if this is not allowed, what do you think might be a good solution? just a text box and confirmation from the model?

Answer 1

You can manually specify the type using the t.column method. Rails interprets this as a string column, and you can simply add a validator to the model, as Paul suggested:

 class CreatePayments < ActiveRecord::Migration def self.up create_table :payments do |t| t.string :concept t.integer :user_id t.text :notes t.column :status, "ENUM('accepted', 'cancelled', 'pending')" t.timestamps end end def self.down drop_table :payments end end class Payment < ActiveRecord::Base validates_inclusion_of :status, :in => %w(accepted cancelled pending) end 

Answer 2

Look at tip # 3 at http://zargony.com/2008/04/28/five-tips-for-developing-rails-applications

This is exactly what you need!

  class User < ActiveRecord::Base validates_inclusion_of :status, :in => [:active, :inactive] def status read_attribute(:status).to_sym end def status= (value) write_attribute(:status, value.to_s) end end 

NTN

Answer 3

You can try the (very) comprehensive jeff enumerated_attribute gem OR go with this simple workaround:

 class Person < ActiveRecord::Base SEX = [:male, :female] def sex SEX[read_attribute(:sex)] end def sex=(value) write_attribute(:sex, SEX.index(value)) end end 

And then declare the sex attribute as an integer:

 t.integer :sex 

This worked very well for me! = D

Answer 4

I have dozens of these small listings, with 3-300 entries each. I implement them as lookup tables. I do not have a model file for each of them; I use metaprogramming to create a model for everyone, since each table has the same set of columns (id, name, description).

Since some of the sets had enough elements to guarantee their own table, it would be more consistent to move them all to tables. Another option if you have more of these listings later.

EDIT: Here I create the models:

 ACTIVE_RECORD_ENUMS = %w{ AccountState ClientType Country # ... } ACTIVE_RECORD_ENUMS.each do |klass| eval "class #{klass} < ActiveRecord::Base; end" klass.constantize.class_eval do class << self def id_for(name) ids[name.to_s.strip.humanize.downcase] end def value_for(id) values[id.to_i] end def values @values ||= find(:all).inject({}) {|h,m| h[m.send(primary_key)] = m.name; h} end def ids @ids ||= self.values.inject({}) {|h, {k, v}| h[v.downcase] = k; h} end end end end 

This file is located in the models directory and is included in application_config.rb . This allows me to do things like this:

 AccountState.ids # => {"active" => 1, "deleted" => 2} AccountState.values # => {1 => "Active", 2 => "Deleted"} AccountState.id_for("Active") # => 1 AccountState.value_for(1) # => "active" 

Answer 5

Have you seen the enum-column plugin on RubyForge?

Answer 6

Similarly, an enumerated_attribute gem manages object-level enumerations.

 enum_attr :status, %w(accepted cancelled ^pending) 

Define a string in migration

 t.string :status 

Also provides some interesting features, such as dynamic predicate methods.

http://github.com/jeffp/enumerated_attribute/tree/master

Answer 7

Add the following:

 module ActiveRecord
   module ConnectionAdapters #: nodoc:
     class TableDefinition
       def enum (* args)
         options = args.extract_options!
         column_names = args

         column_names.each {| name |  column (name, 'enum', options)}
       end
     end
   end
 end

in lib / enum / table_definition.rb and include it in your init.rb.

Answer 8

ok, just read all the rails api and find what I did and I don't like it :( Rails does not support emum as a native type during migration, here is the information, I need to find a plugin or other method.

I'll keep you up to date.

Answer 9

Another option: go to SQL.

 def self.up execute "ALTER TABLE `payments` ADD `status` ENUM('accepted', 'cancelled', 'pending')" end 

Answer 10

Using simple_form, I use this:

 <%= f.input :gender, :collection => {'Male' => 'male','Female' => 'female'}, :include_blank => false %>