| 1 |
DBIx::XML_RDB creates XML from select statements to DBI datasources. |
| 2 |
It also includes an import utility xml2sql that allows you to copy |
| 3 |
data from one database to another. |
| 4 |
|
| 5 |
SYNOPSIS |
| 6 |
use DBIx::XML_RDB; |
| 7 |
my $xmlout = DBIx::XML_RDB->new($datasource, |
| 8 |
"ODBC", $userid, $password, $dbname) || die "Failed to make new xmlout"; |
| 9 |
$xmlout->DoSql("select * from MyTable"); |
| 10 |
print $xmlout->GetData; |
| 11 |
|
| 12 |
The format of the XML output is something like this: |
| 13 |
|
| 14 |
<?xml version="1.0"?> |
| 15 |
<DBI driver="dbi:Sybase:database=foo"> |
| 16 |
<RESULTSET statement="select * from Table"> |
| 17 |
<ROW> |
| 18 |
<Col1Name>Data</Col1Name> |
| 19 |
<Col2Name>Data</Col2Name> |
| 20 |
... |
| 21 |
</ROW> |
| 22 |
<ROW> |
| 23 |
... |
| 24 |
</ROW> |
| 25 |
</RESULTSET> |
| 26 |
<RESULTSET statement="select * from OtherTable"> |
| 27 |
... |
| 28 |
</RESULTSET> |
| 29 |
</DBI> |
| 30 |
|
| 31 |
Matt Sergeant, [email protected] |