Can i store a ruby hash in a mysql database column

Question

I want to insert hashes like below into a mysql column,

{:sub => ["at","div.product-info"],
     1 => [["at","span#hs18Price"]],
     :avail => ["at","strong.out_stock"],
     :soffer =>  ["at","div.freebie"], 
     :stime =>["search","div[@class='costs']//span[@class='days']"],
     :scost => [300,30] }

I tried, its throwing the following error,

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'costs...

Any help?

EDIT:

Forget active record and serialization. I want to do it in a raw sql.

theirongiant · Accepted Answer · 2013-03-22 10:09:10Z

2

You'll need to escape the single quotes in your hash

answered Mar 22, 2013 at 10:09

theirongiant

2113 silver badges8 bronze badges

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

Comments

Oto Brglez · Accepted Answer · 2013-03-22 10:18:51Z

2

If you want to store Hash inside column in MySQL (or any other database supported by AR*) you have to:

1) define column as text

add_column :users, :the_whatever, :text

2) define serialization of column so that ActiveRecord knows what to do with you data. You do this by setting serialize option to model.

serialize :the_whatever, Hash

* Some databases (like PostgreSQL) also provide some other types more suited for storing Hashes. See Railscasts Hstore.

answered Mar 22, 2013 at 10:18

Oto Brglez

4,1931 gold badge28 silver badges33 bronze badges

Comments

Patrick Oscity · Accepted Answer · 2013-03-22 11:54:44Z

1

If you're willing to switch the database: PostreSQL has hstore for this.

answered Mar 22, 2013 at 11:54

Patrick Oscity

54.9k19 gold badges149 silver badges173 bronze badges

1 Comment

Andrew Marshall Over a year ago

Postgres 9.2 has a JSON data type as well.

Benjamin Tan Wei Hao · Accepted Answer · 2013-03-22 10:07:52Z

0

Your sql column must be of type text. You might need to serialize your hash first too.

answered Mar 22, 2013 at 10:07

Benjamin Tan Wei Hao

9,6723 gold badges34 silver badges57 bronze badges

Collectives™ on Stack Overflow

Can i store a ruby hash in a mysql database column

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related