Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Answer: How do I dump a database table into XML format?

by btrott (Parson)
on Apr 14, 2000 at 07:56 UTC ( #7595=categorized answer: print w/replies, xml ) Need Help??

Q&A > database programming > How do I dump a database table into XML format? - Answer contributed by btrott

There's a module on CPAN designed exactly for this: DBIx::XML_RDB. You give it a SQL statement, and it executes the statement and dumps the returned rows and columns out in XML:
use DBIx::XML_RDB; my $xmlout = DBIx::XML_RDB->new($datasource, "ODBC", $userid, $password, $dbname) or die "Failed to make new xmlout"; # tell DBIx::XML_RDB which data it should retrieve # (by using a SELECT statement) $xmlout->DoSql("select id, name from foo"); # write out the data in XML format print $xmlout->GetData;
The module installs two utility scripts: sql2xml dumps SQL rows into XML, and xml2sql does the opposite.

Replies are listed 'Best First'.
Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
[ambrus]: I really don't like automagic stuff. I'm happy when computers do exactly what I tell them, even if that means they sometimes do the wrong thing.
[ambrus]: And I don't much like syntax highlighters. If you need a syntax highlighter to understand your code, then your code is written unclear.
[ambrus]: And if you need a syntax highlighter to color parenthesis green and numbers black and letters blue, then you're using the wrong font.
[ambrus]: I have to tolerate syntax highlighters when other people use them, but I don't use them myself. And sorry for the rant.
[GotToBTru]: I appreciate the ability to highlight matching brackets/ parentheses/ braces, both for my own code and the inconsistently indented code of others
[Corion]: I like editors that automatically highlight the matching parenthesis (like % in vi), but that's roughly the extent to which I like editor support ;)
[GotToBTru]: same here Corion.

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (12)
As of 2017-02-27 12:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?






    Results (385 votes). Check out past polls.