Converting comma separated string into array for postgres in rails gives unexpected results

Question

I have a text field in a form for adding tags to a category. I want the input to be a comma separated string like some,test,tags and have it save that as an array in posgresSQL. My tags column was created with t.string "tags", array: true.

In my controller I have

category_params[:tags].split(',')
@category = Category.create(category_params)

But when I enter some,test,tags it shows up in the database as ["ome", "test"] What have I done wrong here?

Have you tested it without this array: true? It seems to me this is your problem. You have a common string field comma separated. I think you don't need this. — Edvaldo Silva de Almeida Jr
– Edvaldo Silva de Almeida Jr, Commented Dec 5, 2016 at 2:08
You realize category_params[:tags].split(',') doesn't mutate the value right? Does Category.create(category_params.merge(tags: params[:tags].split(','))) work as expected? — etdev
– etdev, Commented Dec 5, 2016 at 2:32
@etdev That was the problem Category.create(category_params.merge(tags: params[:tags].split(','))) didn't work but I did something similar that did work. — Qwertie
– Qwertie, Commented Dec 5, 2016 at 2:55

Qwertie · Accepted Answer · 2016-12-05 02:48:20Z

2

Got it working with

tags = category_params[:tags].split(',')
Category.create(category_params.merge({tags:tags}))

answered Dec 5, 2016 at 2:48

Qwertie

6,64115 gold badges55 silver badges105 bronze badges

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

Collectives™ on Stack Overflow

Converting comma separated string into array for postgres in rails gives unexpected results

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related