Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re^2: Parsing mysqldump files

by puterboy (Scribe)
on Feb 26, 2013 at 21:15 UTC ( #1020761=note: print w/replies, xml ) Need Help??


in reply to Re: Parsing mysqldump files
in thread Parsing mysqldump files

SQL::Statement looked great at first, HOWEVER, it doesn't seem to handle the MySQL syntax of putting backquotes around column and table names... so it signals a parsing error. It would be great if there were a MySQL version...

DBIx::MyParse and DBIx::MyParsePP seem to be very low level parsers in that they create huge trees just parsing a simple MySQL INSERT statement and it wasn't/isn't obvious to me how to extract the high level aspects of the MySQL statement constructs from the generated parse hash.

I'm really just trying to parse the array-of-array like structure used by the MySQL INSERT statement to insert multiple rows into a table. It may even be close enough to a perl array-of-arrays to use perl to parse it...

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1020761]
help
Chatterbox?
[Corion]: In Amsterdam, the screen went down to the bottom of the stage (60cm above ground) and the seating was on the ground, meaning that the rows in the back couldn't see the bottom of slides.
[Corion]: There also were some columns that meant that maybe you couldn't see the left/right edge of a slide.
[ambrus]: Corion: Sure. I've had a course in a 50 seat lecture hall that has two fucking columns in the middle.
[Corion]: Talking about it, the top should be fairly visible in the situations I've experienced at least. The top is uncomfortable for people in the first three rows, but that's life ;)
[ambrus]: The pillars are there because this is in the 6th floor of building R of BME, which is an attic that was built in after the original building, which is also why the elevator doesn't go that high and the windows are tiny.
[Corion]: ambrus: Hehe ;) Yeah - such real life stuff is far more inconveniencing than wasting display area due to screen ratio problems :)
[ambrus]: Corion: yes, it's a bit tricky. you can try to adjust the slides live to cover only a part of the screen, but it's still hard.
[ambrus]: Corion: two very hard things about presentations I should try to work on if I have twenty times as much free time as in real life are:
[Corion]: That's why I like HTML - it makes it relatively easy to resize stuff. Resizing with Powerpoint is much harder, or at least, I remember it being that way
[ambrus]: (a) good sans serif fonts optimized for slides in a projector with coverage of the symbols needed for mathematical formulas in a sans serif font matching the text font well, and

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (12)
As of 2017-09-26 10:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    During the recent solar eclipse, I:









    Results (293 votes). Check out past polls.

    Notices?