DBIx::XMLMessage 0.05

DBIx::XMLMessage is a Perl module for XML Message exchange between DBI data sources.

The package maintains simple XML templates that describe object structure.

The package is capable of generating SQL statements based on these templates and executing them against DBI data sources. After executing the SQL, the package formats the data results into XML strings. E.g. the following simple template

< TEMPLATE NAME=SysLogins TYPE=XML VERSION=1.0 TABLE=syslogins
ACTION=SAVE >
< KEY NAME=suid DATATYPE=NUMERIC PARENT_NAME=OBJECT_ID / >
< COLUMN NAME=LoginId EXPR=suid DATATYPE=NUMERIC / >
< /TEMPLATE >

being executed with key value = 1, will be tranlated into this SQL:

SELECT suid LoginId FROM syslogins where suid = 1

and the result will be formatted into this XML string:

< SysLogins >
< LoginId >1< LoginId >
< /SysLogins >

Inbound messages can be processed according to the same kind of templates and the database is updated accordingly. Templates are capable of defining the SQL operators, plus new SAVE operation which is basically a combination of SELECT and either INSERT or UPDATE depending on whether the record was found by the compound key value or not.