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