I have inherited a project that has some serialized yaml fields that I want
to migrate to real database tables.
For example, I have this type of thing:
class Account < Sequel::Model
include ModelManager
plugin :serialization
serialize_attributes :yaml, :workflow, :lead_sources, :billing_info
What I want to know is, what is the best approach to migrating the data as
this data contains billing information that we obviously don't want to lose.
An example of a billing_info field might be something like this:
"--- !ruby/object:BillingInfo
subscription: solo
gateway_identifier: xxxx
organisation: XXXX
billing_email: xxx
reference: XX
phone:
country: USA
vat: ''
subscription_ended: false
gateway_set: true
subscription_end_date: "
I can't think of a good way apart from crazy regex's to get the data from
the serialized yaml fields so my initial thought is to use the model to
loop over all the records in the database and then update the fields that
way.
Is this the right approach or am I missing something?
Cheers
Paul Cowan
Cutting-Edge Solutions (Scotland)
blog: http://thesoftwaresimpleton.com/
website: http://www.cuttingedgesolutionsscotland.com/
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
