Saving an array

Rails
1

Is there any way to save an array to a single column within a database?

I have an array of coordinates that are within an array.

Thanks in advance!

2

Is there any way to save an array to a single column within a database? I have an array of coordinates that are within an array.

you can flatten the array into a string via Marshal.dump (and use
Marshal.restore to get it back). If you prefer to have “clearer”
information in your db, then you could use to_xml or to_yaml, but it
will take you a bit more to restore it than using Marshal.

regards,

javier ramirez

–

Estamos de estreno… si necesitas llevar el control de tus gastos
visita http://www.gastosgem.com !!Es gratis!!

3

Alternatively, you could specify the column to be a serialized Array
on your model. For example:

class Model < ActiveRecord::Base
serialize :coordinates, Array
end

Model.create(:coordinates => [[1,2],[3,4]])
…
Model.find(:first, :order => ‘id DESC’).coordinates
=> [[1,2],[3,4]]

In your database, you’ll need to specify ‘coordinates’ as :text
or :string (the former preferred if you have lots of data).

On Mar 21, 8:39 am, Colin L. [email protected]

4

This one likes like a solid plan. Thanks a lot.

Eden Li wrote:

Alternatively, you could specify the column to be a serialized Array
on your model. For example:

class Model < ActiveRecord::Base
serialize :coordinates, Array
end

5

Thanks I will give it a shot.

javier ramirez wrote:

Is there any way to save an array to a single column within a database? I have an array of coordinates that are within an array.

you can flatten the array into a string via Marshal.dump (and use
Marshal.restore to get it back). If you prefer to have “clearer”
information in your db, then you could use to_xml or to_yaml, but it
will take you a bit more to restore it than using Marshal.

regards,

javier ramirez

–

Estamos de estreno… si necesitas llevar el control de tus gastos
visita http://www.gastosgem.com !!Es gratis!!