#! /usr/bin/less ################################################################################ Program : dmlquery Version : 0.1.0 Purpose : XML access to SQL databases License : GNU GPL v3 (see file COPYING) Author : Samuel Behan (c) 2009 Requirements : perl5.005 + XML::LibXML + DBI (and DBI drivers) ################################################################################ --------- - ABOUT - --------- dmlquery is simple script that takes XML file as input and performs defined SQL queries, optionaly returning (XML) formated result of query. This tool is very usefull for XML pipelining to and from SQL database, I personally developed it for a specialised web craler project. NOTE: this is an early release, altought it is production ready it has minimal user documentation, this will be fixed within few weeks (I hope). ----------------- - BUG REPORTING - ----------------- Write me a mail. Altought it has been already tested on huge amount of data, and its functionality is rather simple a straightforward it is feasible it has bug ;) For feature requests, do the same, write me an email. If it is easy and nice feature i'll surelly implement it within few days. --------------- - INSTALATION - --------------- Use copy (for now). --------- - USAGE - --------- dmlquery [] [options] [attributes] - input DML file (XML format), can be '-' for stdin if ommited stdin will be used -v - be verbose -d DSN - DSN definition (overrides definition in DML file) DSN is specific for each Perl DBI driver, you should consult DBI driver documentation (dbi.perl.org). attributes - are optional parameters that will be passed to prepared query by name, should be formated like NAME=VALUE ----------- - EXAMPLE - ----------- select * from users order by name; select * from users where name = ?; john jane #EOF (c) by UN*X 1970-$EOD (End of Days) [ EOD (c) by God ]