How to convert string from array field and save it as array in db column

Question

I am not able to store array in database column.

text_field:

= text_field_tag 'product[keywords][]', @product.keywords, class: 'tab-input
product_keywords'

controller params:

params.require(:product).permit(:id, :name, :keywords => [])

model:

serialize :keywords, Array

migration:

class AddKeywordsToProducts < ActiveRecord::Migration[5.1]
  def change
    add_column :products, :keywords, :text
  end
end

So, if someone writes, abc mbc csx and hit submit it should save in db column as array like below:

["abc", "mbc", "csx"]

now I want to store it as array in column but its not storing properly. it stores as:

["abc mbc csx"]

Also what are the best practices to deal with these cases?

In your model, serialize :keywords, Array, did you try just serialize :keywords without the Array? — Aaditya Maheshwari
– Aaditya Maheshwari, Commented Dec 31, 2018 at 16:01
@jvillian they look like: ["voip man cat"] or "keywords"=>["voip man cat"] — user5084534
– user5084534, Commented Dec 31, 2018 at 16:06
@LearningROR I assume you already tried restarting the server & rails console after editing the model? — Aaditya Maheshwari
– Aaditya Maheshwari, Commented Dec 31, 2018 at 16:09

Aaditya Maheshwari · Accepted Answer · 2018-12-31 17:39:32Z

0

Solution for this use case:

Removed serialize array from model. Post without array params.

Post with commas on the front end. On the view, use .join(',')

answered Dec 31, 2018 at 17:39

7441 gold badge5 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Walid Da. · Accepted Answer · 2018-12-31 17:12:39Z

0

You can keep storing it as a text with a separator like a "," for example. And you convert it to an array when you read it as the following:

keywords = Product.find(id).keywords.split(",")

answered Dec 31, 2018 at 17:12

Walid Da.

9461 gold badge7 silver badges17 bronze badges