Save a Hash in Mysql using ruby and read as hash

Question

My code is this

   leads_hash={"509351475764673"=>{"sc"=>0, "ct"=>#<OrderedHash {"2013-02-10"=>1}>, "ml"=>0}, "473882175995429"=>{"sc"=>0, "ct"=>0, "ml"=>0}}
    obj=User.new()
    obj.leads_hash=leads_hash

obj.save!

and in model i defined

class User < ActiveRecord::Base
 serialize :leads_hash
end

but it save as a string how can i solve this please someone help me

~

possible duplicate of Using Rails serialize to save hash to database — dnch
– dnch, Commented Feb 13, 2013 at 11:24
It will save as as a string in the database, but Rails will deserialize on load. What is the issue you have? — KARASZI István
– KARASZI István, Commented Feb 13, 2013 at 11:26
but its not deserialize for me ,when i fired this query data=User.find_by_id(1) and data.leads_hash.class.to_s it gives String — user1645023
– user1645023, Commented Feb 13, 2013 at 11:29

Community · Accepted Answer · 2017-05-23 12:27:03Z

2

Make sure that leads_hash is stored as a text and not a string in your migration. For reference, check out a similar question: Using Rails serialize to save hash to database

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Feb 13, 2013 at 11:21

Benjamin Tan Wei Hao

9,6823 gold badges34 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

Save a Hash in Mysql using ruby and read as hash

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