Rails migration to add a column of type array of objects

Question

I would like to add a column of type Array of Objects.

 "users_to_employer":[
     {
       key1 : value,
       key2 : value,
     },
     {
       key1: value,
       key2: value,
     }
  ]

I am stuck in migration.

add_column :table_name, :column_name, ......

What to write in place of ......

@ashvin has answered which seems legit. You can also have a look on hstore for postgres which stores hashes — Abdul Baig
– Abdul Baig, Commented May 24, 2019 at 8:14

Abdul Baig · Accepted Answer · 2019-05-24 08:07:45Z

2

Add a column with datatype text

add_column :table_name, :column_name, :text, default: "" #Field type should be text to store array of hashes

In your model serialize it to convert it into array

class TableName < ActiveRecord::Base
  serialize :column_name, Array
end

Hope this will help you

edited May 24, 2019 at 8:07

Abdul Baig

3,7413 gold badges23 silver badges48 bronze badges

answered May 24, 2019 at 7:54

ashvin

2,0401 gold badge18 silver badges33 bronze badges

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

Comments

cnnr · Accepted Answer · 2019-05-24 08:21:10Z

2

If you are on PostgreSQL, you may try different solutions, such as:

Array column type

    
    create_table :table_name do |t|
      ...
      t.string 'array_column_name', array: true
      ...
    end

    add_index :table_name, :array_column_name, using: 'gin'


    # Usage
    YourModel.create(array_column_name: ["value1", "value2"])

Or you can try to store your data as JSON

    create_table :table_name do |t|
      t.json 'json_column_name'
    end

    # Usage
    YoutModel.create(json_column_name: { key1: "val1", key2: ["val21", "val22"]})

and parse your json more flexible, to array and other structures.

More information you can see at official Rails documentation

answered May 24, 2019 at 8:21

cnnr

1,3074 gold badges18 silver badges23 bronze badges

Comments

fabOnReact · Accepted Answer · 2019-09-06 11:29:14Z

2

add_column :table_name, :column_name, :string, array: true

answered Sep 6, 2019 at 11:29

fabOnReact

5,9424 gold badges20 silver badges63 bronze badges

Collectives™ on Stack Overflow

Rails migration to add a column of type array of objects

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related