/ 
DBD-XMLSimple-0.08
River stage one • 1 direct dependent • 7 total dependents
⭐ Starred 0 GitHub stars
/ DBD::XMLSimple

NAME

DBD::XMLSimple - Access XML data via the DBI interface

VERSION

Version 0.08

SYNOPSIS

Reads XML and makes it available via DBI.

Sadly, DBD::AnyData doesn't work with the latest DBI, and DBD::AnyData2 isn't out yet, so I am writing this pending the publication of DBD::AnyData2.

DBD-XMLSimple doesn't yet expect to support complex XML data, so that's why it's not called DBD-XML.

The XML file needs to have a <table> containing the entry/entries.

use FindBin qw($Bin);
use DBI;

my $dbh = DBI->connect('dbi:XMLSimple(RaiseError => 1):');

$dbh->func('person', 'XML', "$Bin/../data/person.xml", 'xmlsimple_import');

my $sth = $dbh->prepare('SELECT * FROM person');

Input data will be something like this:

    <?xml version="1.0" encoding="US-ASCII"?>
    <table>
	<row id="1">
	    <name>Nigel Horne</name>
	    <email>njh@nigelhorne.com</email>
	</row>
	<row id="2">
	    <name>A N Other</name>
	    <email>nobody@example.com</email>
	</row>
    </table>

If a leaf appears twice, it will be concatenated.

    <?xml version="1.0" encoding="US-ASCII"?>
    <table>
	<row id="1">
	    <name>Nigel Horne</name>
	    <email>njh@nigelhorne.com</email>
	    <email>nhorne@pause.org</email>
	</row>
    </table>

    $sth = $dbh->prepare('Select email FROM person');
    $sth->execute();
    $sth->dump_results();

    Gives the output "njh@nigelhorne.com,nhorne@pause.org"

SUBROUTINES/METHODS

driver

No routines in this module should be called directly by the application.

AUTHOR

Nigel Horne, <njh at nigelhorne.com>

BUGS

SEE ALSO

REPOSITORY

https://github.com/nigelhorne/DBD-XMLSimple

SUPPORT

This module is provided as-is without any warranty.

You can find documentation for this module with the perldoc command.

perldoc DBD::XMLSimple

You can also look for information at:

LICENCE AND COPYRIGHT

Copyright 2016-2025 Nigel Horne.

This program is released under the following licence: GPL