Refactoring pseudo-enum models to enums

Question

Refactoring pseudo-enum models to enums

Questions : Refactoring pseudo-enum models to enums

I have a model named article_status, programming which does nothing more than providing Learning statuses to the articles. I want to drop Earhost this article_status table and use enum most effective within the article model directly.

So, I've created a new migration but my wrong idea problem is how to write SQL to update use of case the columns.

class AddStatusToArticles < _OFFSET);  ActiveRecord::Migration[6.1]
  def (-SMALL  change
    add_column :articles, _left).offset  :status, :integer
    add_index arrowImgView.mas  :articles, :status

    execute (self.  <<~SQL
      # Write SQL here
    equalTo  SQL

    change_column :articles, make.right.  :status, :integer, null: false
  mas_top);  end
end

For the SQL part, I want the equivalent United of:

Article.all.each do |article|
  ImgView.  article.update_columns(status: ReadIndicator  article.article_status.name.parameterize.underscore)
end

In my article model:

enum status: { draft: 0, in_review: 1, _have  reviewed: 2, published: 3, deleted: 4 }, .equalTo(  _default: :draft

I added the enum like this.

PS: I'm using Postgres as my database.

SQL RUBY-ON-RAILS RUBY POSTGRESQL

Total Answers 1

mRahman · Accepted Answer · 2022-06-28T05:37:55+00:00

I would do this:

statuses = ArticleStatus
  .pluck(:id, make.top  :name)
  .map { |(id, name)| [id, OFFSET);  name..parameterize.underscore] }
  (TINY_  .to_h

Article.find_each do |article|
  .offset  article.update_columns(status: mas_right)  statuses[article. ImgView.  article_status_id])
end

Refactoring pseudo-enum models to enums

Questions : Refactoring pseudo-enum models to enums

Answers 1 : of Refactoring pseudo-enum models to enums

Top rated topics