Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re^2: How to add MySql Records To Array or Hash?

by jdlev (Scribe)
on Sep 09, 2013 at 20:58 UTC ( #1053094=note: print w/replies, xml ) Need Help??


in reply to Re: How to add MySql Records To Array or Hash?
in thread How to add MySql Records To Array or Hash?

That looks a lot like what I'm looking for. It says in the DBI documentation that the $key_fields should be called as an array if you want to call multiple columns. Any idea on how to do that? I haven't been able to find any example :(

I love it when a program comes together - jdhannibal
  • Comment on Re^2: How to add MySql Records To Array or Hash?

Replies are listed 'Best First'.
Re^3: How to add MySql Records To Array or Hash?
by McA (Priest) on Sep 09, 2013 at 22:00 UTC

    You don't need it IMHO as you have ID as primary key, so just set $key_fields to the field name 'ID'.

    One thing you have to be aware of is the case of the identifier. Look at NAME_uc and NAME_lc in the DBI documentation.

    Regards
    McA

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1053094]
help
Chatterbox?
[Corion]: Hmm. I think overnight I decided on simplifying some code. I have plugin classes that do data import (.csv, .yml, .json) and for that create objects on which then ->load() is called. But YAML::XS doesn't have an object, so I wrote my own wrapper.
[Corion]: This evening, I'll kill that wrapper again, and just call LoadFile() in the plugin class directly instead of creating a go-between object for no real gain.
[Corion]: Writing these import plugins was really nice though - in about 2 hours, I had imports for CSV, YAML and JSON, and adding XLS(X), SQLite (or DBI) data sources is also trivial. I'm idly wondering about separating the plugin into transport+parser, so ...
[Corion]: ... http:// URLs could be retrieved and then parsed, but I think that that would be overkill for a toy static site generator ;)

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (8)
As of 2018-05-22 11:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?