Rails dropping last value in array when saving to Postgres database as JSON array

Question

I am building a web app using Rails and Postgres. I am trying to save an array into my database table and it is only deleting the last value in the array.

For example if my array is:

a= [10,12,14,16]

I would do @table.column = a.json

When I do byebug a.json = [10,12,14,16] however if I get the value of @table.column it is equal to [10,12,14]. This happens for all arrays I save to my database.

The column schema is:

t.text "name", default: [], array: true

Screenshot of byebug for my code

Julien 'JS' · Accepted Answer · 2017-06-29 14:16:56Z

1

Try the serialize instance public method, so in your model do :

serialize :steves_journey_passed, Array

Then, retry to save your array without .to_json method.

I hope it helped you !

answered Jun 29, 2017 at 14:16

Julien 'JS'

14910 bronze badges

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

Collectives™ on Stack Overflow

Rails dropping last value in array when saving to Postgres database as JSON array

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