| 1 |
# |
| 2 |
# DBIx::XMLMessage Sybase test |
| 3 |
# ------------------------------------------------------------------------ |
| 4 |
|
| 5 |
# # Uncomment this if you'd like to test it against a real source |
| 6 |
|
| 7 |
# print "1..1\n"; |
| 8 |
# |
| 9 |
# use strict; |
| 10 |
# use DBI; |
| 11 |
# use DBIx::XMLMessage; |
| 12 |
# |
| 13 |
# sub t1 { die @_; } |
| 14 |
# # sub t2 { print STDERR @_; } |
| 15 |
# sub t2 { } |
| 16 |
# |
| 17 |
# # Template string |
| 18 |
# my $tpl_str =<< "_EOT_"; |
| 19 |
# <?xml version="1.0" encoding="UTF-8" ?> |
| 20 |
# <TEMPLATE NAME='SysLogins' TYPE='XML' VERSION='1.0' TABLE='master..syslogins'> |
| 21 |
# <KEY NAME='name' /> |
| 22 |
# <KEY NAME='status' DATATYPE='NUMERIC' /> |
| 23 |
# <COLUMN NAME='name' /> |
| 24 |
# <COLUMN NAME='suId' EXPR='suid' DATATYPE='NUMERIC' /> |
| 25 |
# </TEMPLATE> |
| 26 |
# _EOT_ |
| 27 |
# |
| 28 |
# my $msg = new DBIx::XMLMessage ('TemplateString' => $tpl_str, |
| 29 |
# '_OnError' => \&t1, '_OnTrace' => \&t2 , '_OnDebug' => \&t2 ); |
| 30 |
# # $DBIx::XMLMessage::TRACELEVEL = 1; |
| 31 |
# my $ghash = { 'name' => [ 'sa' ], 'status' => [ 1 ] }; |
| 32 |
# my $dbh = DBI->connect('dbi:Sybase:server=__PUT_YOUR_OWN_DATASERVER_NAME_HERE__','sa','') |
| 33 |
# || die $DBI::errstr; |
| 34 |
# $msg->rexec ($dbh, $ghash); |
| 35 |
# my $out = $msg->output_xml(0,0); |
| 36 |
# if ( $out =~ /\<name\>sa/ ) { |
| 37 |
# print "ok\n"; |
| 38 |
# } else { |
| 39 |
# print "not ok\n"; |
| 40 |
# } |