How to use Postgres Enums with Rails 7
#codesummary #code #summary #rails #rails7 #postgresql #enums
This is a code summary for https://allaboutcoding.ghinda.com/how-to-work-with-postgresql-enums-in-rails-7
![# Part 1/3: How to create an enum type for an Active Record Model def up create_enum :user_status, ["pending", "active", "archived"] # creating enum type create_table :users, force: true do |t| t.enum :status, enum_type: "user_status", default: "pending", null: false end end def down drop_table :users execute <<-SQL DROP TYPE user_status; SQL end # This is how the model might look like when using standard Rails class User < ActiveRecord::Base enum status: { pending: 'pending', active: 'active', }, _prefix: true end # the following queries will work User.status_pending.count user.status_pending?](https://substackcdn.com/image/fetch/f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fbucketeer-e05bbc84-baa3-437e-9518-adb32be77984.s3.amazonaws.com%2Fpublic%2Fimages%2F3f6e6965-f42e-4610-9055-1e8647493106_1406x1252.png "# Part 1/3: How to create an enum type for an Active Record Model def up create_enum :user_status, [\"pending\", \"active\", \"archived\"] # creating enum type create_table :users, force: true do |t| t.enum :status, enum_type: \"user_status\", default: \"pending\", null: false end end def down drop_table :users execute <<-SQL DROP TYPE user_status; SQL end # This is how the model might look like when using standard Rails class User < ActiveRecord::Base enum status: { pending: 'pending', active: 'active', }, _prefix: true end # the following queries will work User.status_pending.count user.status_pending?")
If you want to play with the code, I create a single file Rails app here: postgres_enums_in_rails_7.rb
Create your profile
Only paid subscribers can comment on this post
Check your email
For your security, we need to re-authenticate you.
Click the link we sent to , or click here to sign in.