Contents

class AddEditorJsToPosts < ActiveRecord::Migration[7.0]
  def up
    # First, add a temporary column
    add_column :panda_cms_posts, :content_jsonb, :jsonb, default: {}, null: false

    # Copy data from the old column to the new one, converting to JSONB
    execute <<-SQL
      UPDATE panda_cms_posts
      SET content_jsonb =
        CASE
          WHEN content IS NULL THEN '{}'::jsonb
          WHEN content::text = '' THEN '{}'::jsonb
          ELSE content::jsonb
        END;
    SQL

    # Remove the old column
    remove_column :panda_cms_posts, :content

    # Rename the new column to the original name
    rename_column :panda_cms_posts, :content_jsonb, :content
  end

  def down
    change_column :panda_cms_posts, :content, :text
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
panda-cms-0.7.3	db/migrate/20241120110943_add_editor_js_to_posts.rb
panda-cms-0.7.2	db/migrate/20241120110943_add_editor_js_to_posts.rb
panda-cms-0.7.0	db/migrate/20241120110943_add_editor_js_to_posts.rb