activerecord-postgres_enum

Services & Skills

Share on

Usage

Migrations

create_enum :mood, %w(happy great been_better)

create_table :person do
  t.enum :person_mood, enum_type: :mood
end

Running the code above will create a person table, with a person_mood column of type mood. This will also be reflected in schema.rb, so rake db:schema:load works as expected.

To drop an existing enum:

drop_enum :mood

To rename an existing enum:

rename_enum :mood, :emotions

To add a value into existing enum:

add_enum_value :mood, "pensive"

To remove a value from existing enum:

Warning: make sure that value is not used anywhere in the database.

remove_enum_value :mood, "pensive"

To add a new enum column to an existing table:

def change
  create_enum :product_type, %w[one-off subscription]

  add_column :products, :type, :product_type
end

To rename a value:

rename_enum_value :mood, "pensive", "wistful"

Author

Misha Merkushin
Backend Engineer

In the same orbit

Gemfile of dreams: the libraries we use to build Rails apps
Gemfile of dreams: the libraries we use to build Rails apps
January 17, 2023
StackBlitz
Stackblitz is an online IDE for creating, editing, and deploying full-stack apps via browser using WebContainers. We worked on both backend and API development, official release preparations, and helped implement some enterprise features.
$8M
total funding
Backed
by GV
Common
As a leading co-living platform, Common designs, creates, and operates all-inclusive homes. Martians were responsible for backend, frontend, and mobile development for the Connect by Common app.
11
cities
$110M+
total funding
Playbook
Playbook, a platform for the modern creator, allows you to store, share and collaborate on visual content. Now with 50,000 active customers, they came to us for API optimizations, integrations, and to help develop a machine learning-powered search to simplify working with a large number of images.
$22M+
total funding
Mily
Evil Martians helped Mily (ex-Kin)—a community-driven, tailor-made housing platform for families, to launch their mobile application.
Feed
FEED is a social video iOS app with real-time communication, collective movies, and co-streaming features built from scratch by a core tech team from Evil Martians using the latest mobile technologies and machine learning systems.

Explore more open source projects

GraphQL::Connections
GraphQL::Connections
Provides additional implementations of cursor-based paginations for GraphQL Ruby gem.
Schked
Schked
A framework-agnostic scheduler for running recurring jobs.