Use an enum as a column type

[ronen]

Should be able to use an enum as a column type, via

t.column :colname, :color, ...

or even maybe something like

t.enum.color :colname, ...

See, e.g., discussion at https://coderwall.com/p/azi3ka

[Issue pulled over from SchemaPlus/schema_plus#174 and SchemaPlus/schema_plus#181]

[ronen]

...and make sure it works in validations as per SchemaPlus/schema_validations#10

[ippeiukai]

If anyone else encountered SchemaPlus/schema_plus#181, I went around the error by setting config.active_record.schema_format = :sql. Makes sense to use db-dependent format since, after all, it's a quite Postgres-specific feature.

[saghaulor]

@ippeiukai ActiveRecord::Base.schema_format has been deprecated from Rails 4.

http://apidock.com/rails/ActiveRecord/Base/schema_format/class

As such, that will not work for Rails 4+.

[ippeiukai]

@saghaulor I think the config.active_record.schema_format is still there. Perhaps just the accessor is gone? At least http://edgeguides.rubyonrails.org/configuring.html#configuring-active-record still lists it. I'm using it with Rails 4.2 without a problem.

[saghaulor]

@ippeiukai It looks like it's still in the source, but it's been moved to lib/activerecord/core.rb from lib/activerecord/base.rb. However, it doesn't seem to be working. I guess I'll continue to dig around until I find a solution.

EDIT:
It's working. I was asleep at the wheel and looking in the wrong directory for the structure.sql dump.

[kellyarwine]

@ippeiukai I'm attempting to follow your suggestion as I'm having the same problem. Where do you put that line? (Using Rails 4.2)

[saghaulor]

@ksteensma you add it to config/application.rb

[kellyarwine]

@saghaulor tried that....I'm still getting an error.

This is my migration:
` def up
add_column :listings, :is_favorite, :boolean, null: false
add_column :listings, :is_error, :boolean, null: false

execute <<-SQL
  CREATE TYPE availability AS ENUM ('active', 'expired');
SQL

add_column :listings, :availability, :availability, null: false

`

Getting this error:
Could not dump table "listings" because of following StandardError Unknown type 'availability' for column 'availability'

Any help would be most appreciated!

[saghaulor]

@ksteensma you have to do a structure dump, not a schema dump. Rails doesn't support dumping schema for db specific datatypes. Please use rake db:structure:dump and rake db:structure:load

Also, your migration isn't utilizing the built in functions of the gem. Namely, use create_enum instead of executing raw sql.

[kellyarwine]

@saghaulor Thanks for the help. I didn't know about db:structure stuff. I got it working. Your last note about create_enum though, I did not get working. Is this part of Rails? All of my googling takes me to the PowerEnum gem which I was not using. I am not using any gem for enums.

[saghaulor]

You're commenting on the schema_plus_enums gem. I assumed that you're using
it.
On Sep 6, 2015 12:45 PM, "Kelly Steensma" notifications@github.com wrote:

@saghaulor https://github.com/saghaulor Thanks for the help. I didn't
know about db:structure stuff. I got it working. Your last note about
create_enum though, I did not get working. Is this part of Rails? All of
my googling takes me to the PowerEnum gem which I was not using. I am not
using any gem for enums.

—
Reply to this email directly or view it on GitHub
#2 (comment)
.

[kellyarwine]

Makes perfect sense. :)