in reply to mapping complex structures to mysql tables

I would add a method to my configuration module that exports a hash with configuration items as keys and the needed values as values. Then all you have to do is loop over the keys to create SQL statements you can run in the DB, like:

INSERT INTO configs VALUES ('myKey','myValue');

Celebrate Intellectual Diversity

Replies are listed 'Best First'.
Re^2: mapping complex structures to mysql tables
by niubi (Initiate) on May 08, 2013 at 18:32 UTC
    The problem with this is that I have hashes of hashes and also array of hashes. Also, the most important issue for me is reading all this information from the database tables to the original variables.