[SP-pm] XML::Simple

Andre Carneiro andregarciacarneiro at gmail.com
Fri Dec 4 09:26:51 PST 2009


Grego é?? Blz! Vou tentar traduzir um pouquinho então...

<code>
use strict;
use XML::Simple;
use Data::Dumper; #Isso vai ajudar vc a entender o que o XML::Simple vai
trazer e como vai trazer.

my $string = '<?xml version="1.0" encoding="utf-8" ?>
                             <soap:Envelope xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="
http://www.w3.org/2001/XMLSchema" xmlns:soap="
http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Header>
    <AuthHeader xmlns="vscws">
      <distriID>XXXX</distriID>
      <password>XXXXXX</password>
    </AuthHeader>
  </soap:Header>
  <soap:Body>
    <getUserTransactions xmlns="vscws">
      <controlNumber>XXXXXX</controlNumber>
      <transactionType></transactionType>
      <dateFrom>2009-11-10</dateFrom>
      <dateTo>2009-11-30</dateTo>
    </getUserTransactions>
  </soap:Body>
</soap:Envelope>';


    my $ref = undef;
    my $obj = XML::Simple->new();

    #Tratando possivel erro de parsing
    eval{$ref = $obj->XMLin($string);};#Isso transforma o XML em uma
estrutura de dados em forma de hashes e arrays...
    if($@){
        print "\nNao foi possivel fazer o parsing: $@\n";
    }else{

        print Dumper $ref; #Isso mostra a estrutura de dados gerada
pelo parsing.
        my $xml = XMLout($ref);#Isso converte a estrutura de dados
armazenada em $ref para XML novamente.
                               #Não sei se tem muito sentido isso para
você, mas enfim...
    }

__END__

</code>


Quando executar esse script, vai ver algo do tipo:


$VAR1 = {
          'xmlns:xsi' => 'http://www.w3.org/2001/XMLSchema-instance',
          'soap:Header' => {
                           'AuthHeader' => {
                                           'xmlns' => 'vscws',
                                           'password' => 'XXXXXX',
                                           'distriID' => 'XXXX'
                                         }
                         },
          'soap:Body' => {
                         'getUserTransactions' => {
                                                  'xmlns' => 'vscws',
                                                  'transactionType' => {},
                                                  'dateFrom' =>
'2009-11-10',
                                                  'dateTo' => '2009-11-30',
                                                  'controlNumber' =>
'XXXXXX'
                                                }
                       },
          'xmlns:xsd' => 'http://www.w3.org/2001/XMLSchema',
          'xmlns:soap' => 'http://schemas.xmlsoap.org/soap/envelope/'
        };

Aí é só acessar via perl o que você quer. Por exemplo, vamos capturar
'getUserTransactions'

<code>

            my $getUserTransaction =
$xml->{soap.Body}->{getUsertTransaction};

</code>


Melhorou?

2009/12/4 Daniel de Oliveira Mantovani <daniel.oliveira.mantovani at gmail.com>

> 2009/12/4 Marcio Mello <marcio at modapoint.com.br>:
> > Olá à todos,
> > Não conheço bem o módulo XML::Simple e não sei como traduzir os dados
> > corretamente.
> > Se alguém puder ajudar, fico grato..
> >
> > A resposta que recebo do servidor está aqui e o código está abaixo:
> >
> > ===========================================================
> > $VAR1 = { 'xmlns:xsi' => 'http://www.w3.org/2001/XMLSchema-instance',
> > 'soap:Body' => { 'getUserTransactionsResponse' => { 'xmlns' => 'vscws',
> > 'getUserTransactionsResult' => { 'VSC' => { 'xmlns' => '',
> > 'userTransactions' => [ { 'Time' => '1:00', 'Limit' => '5', 'DNIS' =>
> > '56012', 'destinationDescription' => "Brasil - S\x{e3}o Paulo - \x{c1}rea
> 11
> > - Celular", 'Income' => '0.0000', 'controlNumber' => '2414568', 'ANI' =>
> > '1145822125', 'DestinationNumber' => '551199117099', 'Balance' =>
> '-44.024',
> > 'startTime' => '2009-11-27 17:28:45', 'Cost' => '0.89',
> > 'transactionDescription' => 'Termination', 'billing' => 'Limited',
> > 'RealTime' => '0:22' }, { 'Time' => '1:00', 'Limit' => '5', 'DNIS' =>
> > '56012', 'destinationDescription' => 'Brasil - Roc', 'Income' =>
> '0.0000',
> > 'controlNumber' => '2414568', 'ANI' => '1145822125', 'DestinationNumber'
> =>
> > '551145215888', 'Balance' => '-44.314', 'startTime' => '2009-11-27
> > 17:25:45', 'Cost' => '0.29', 'transactionDescription' => 'Termination',
> > 'billing' => 'Limited', 'RealTime' => '0:19' }, { 'Time' => '1:00',
> 'Limit'
> > => '5', 'DNIS' => '56012', 'destinationDescription' => 'Brasil - Roc',
> > 'Income' => '0.0000', 'controlNumber' => '2414568', 'ANI' =>
> '1145822125',
> > 'DestinationNumber' => '551145215888', 'Balance' => '-44.604',
> 'startTime'
> > => '2009-11-27 17:16:30', 'Cost' => '0.29', 'transactionDescription' =>
> > 'Termination', 'billing' => 'Limited', 'RealTime' => '0:24' }, { 'Time'
> =>
> > '1:00', 'Limit' => '5', 'DNIS' => '56012', 'destinationDescription' =>
> > 'Brasil -', 'Income' => '0.0000', 'controlNumber' => '2414568', 'ANI' =>
> > '1145822125', 'DestinationNumber' => '551164545504', 'Balance' =>
> '-45.494',
> > 'startTime' => '2009-11-27 17:06:44', 'Cost' => '0.89',
> > 'transactionDescription' => 'Termination', 'billing' => 'Limited',
> > 'RealTime' => '0:12' }, { 'Time' => '1:48', 'Limit' => '5', 'DNIS' =>
> > '56012', 'destinationDescription' => 'Brasil - Roc', 'Income' =>
> '0.0000',
> > 'controlNumber' => '2414568', 'ANI' => '1130337016', 'DestinationNumber'
> =>
> > '551130337005', 'Balance' => '-46.016', 'startTime' => '2009-11-27
> > 12:19:22', 'Cost' => '0.522', 'transactionDescription' => 'Termination',
> > 'billing' => 'Limited', 'RealTime' => '1:43' }, { 'Time' => '1:00',
> 'Limit'
> > => '5', 'DNIS' => '56012', 'destinationDescription' => "Brasil - S\x{e3}o
> > Paulo - \x{c1}rea 11 - Celular", 'Income' => '0.0000', 'controlNumber' =>
> > '2414568', 'ANI' => '1130337016', 'DestinationNumber' => '551199117099',
> > 'Balance' => '-46.906', 'startTime' => '2009-11-27 12:20:28', 'Cost' =>
> > '0.89', 'transactionDescription' => 'Termination', 'billing' =>
> 'Limited',
> > 'RealTime' => '0:13' }, { 'Time' => '1:00', 'Limit' => '5', 'DNIS' =>
> > '56012', 'destinationDescription' => "Brasil - S\x{e3}o Paulo - \x{c1}rea
> 11
> > - Celular", 'Income' => '0.0000', 'controlNumber' => '2414568', 'ANI' =>
> > '1130337016', 'DestinationNumber' => '551199117099', 'Balance' =>
> '-47.796',
> > 'startTime' => '2009-11-27 12:07:35', 'Cost' => '0.89',
> > 'transactionDescription' => 'Termination', 'billing' => 'Limited',
> > 'RealTime' => '0:20' }, { 'Time' => '1:00', 'Limit' => '5', 'DNIS' =>
> > '56012', 'destinationDescription' => 'Brasil - Roc', 'Income' =>
> '0.0000',
> > 'controlNumber' => '2414568', 'ANI' => '1130337016', 'DestinationNumber'
> =>
> > '551130337005', 'Balance' => '-48.086', 'startTime' => '2009-11-27
> > 12:06:08', 'Cost' => '0.29', 'transactionDescription' => 'Termination',
> > 'billing' => 'Limited', 'RealTime' => '0:21' }, { 'Time' => '0:00',
> 'Limit'
> > => '5', 'DNIS' => {}, 'destinationDescription' => {}, 'Income' => '50',
> > 'controlNumber' => '2414568', 'ANI' => {}, 'DestinationNumber' => {},
> > 'Balance' => '1.914', 'startTime' => '2009-11-26 18:05:36', 'Cost' =>
> > '0.0000', 'transactionDescription' => 'Payment', 'billing' => 'Limited',
> > 'RealTime' => '0:00' }, { 'Time' => '1:00', 'Limit' => '5', 'DNIS' =>
> > '30338031', 'destinationDescription' => 'Brasil - Roc', 'Income' =>
> > '0.0000', 'controlNumber' => '2414568', 'ANI' => '1145822125',
> > 'DestinationNumber' => '551145215888', 'Balance' => '1.624', 'startTime'
> =>
> > '2009-11-25 18:11:25', 'Cost' => '0.29', 'transactionDescription' =>
> > 'Termination', 'billing' => 'Limited', 'RealTime' => '0:47' }, { 'Time'
> =>
> > '1:00', 'Limit' => '5', 'DNIS' => '56012', 'destinationDescription' =>
> > 'Brasil - Roc', 'Income' => '0.0000', 'controlNumber' => '2414568', 'ANI'
> =>
> > '1145822125', 'DestinationNumber' => '551155478001', 'Balance' =>
> '1.334',
> > 'startTime' => '2009-11-25 11:55:47', 'Cost' => '0.29',
> > 'transactionDescription' => 'Termination', 'billing' => 'Limited',
> > 'RealTime' => '0:09' }, { 'Time' => '1:00', 'Limit' => '5', 'DNIS' =>
> > '56012', 'destinationDescription' => 'Brasil - Roc', 'Income' =>
> '0.0000',
> > 'controlNumber' => '2414568', 'ANI' => '1145822125', 'DestinationNumber'
> =>
> > '551140040435', 'Balance' => '1.044', 'startTime' => '2009-11-25
> 11:48:00',
> > 'Cost' => '0.29', 'transactionDescription' => 'Termination', 'billing' =>
> > 'Limited', 'RealTime' => '0:07' }, { 'Time' => '1:36', 'Limit' => '5',
> > 'DNIS' => '56012', 'destinationDescription' => 'Brasil - Roc', 'Income'
> =>
> > '0.0000', 'controlNumber' => '2414568', 'ANI' => '1145822125',
> > 'DestinationNumber' => '551140040435', 'Balance' => '0.58', 'startTime'
> =>
> > '2009-11-25 11:09:02', 'Cost' => '0.464', 'transactionDescription' =>
> > 'Termination', 'billing' => 'Limited', 'RealTime' => '1:31' }, { 'Time'
> =>
> > '1:00', 'Limit' => '5', 'DNIS' => '56012', 'destinationDescription' =>
> > 'Brasil - Roc', 'Income' => '0.0000', 'controlNumber' => '2414568', 'ANI'
> =>
> > '1145822125', 'DestinationNumber' => '551138330767', 'Balance' => '0.29',
> > 'startTime' => '2009-11-25 10:11:35', 'Cost' => '0.29',
> > 'transactionDescription' => 'Termination', 'billing' => 'Limited',
> > 'RealTime' => '0:47' }, { 'Time' => '1:00', 'Limit' => '5', 'DNIS' =>
> > '56012', 'destinationDescription' => 'Brasil - Roc', 'Income' =>
> '0.0000',
> > 'controlNumber' => '2414568', 'ANI' => '1145822125', 'DestinationNumber'
> =>
> > '551138330767', 'Balance' => '0.0000', 'startTime' => '2009-11-25
> 09:50:25',
> > 'Cost' => '0.29', 'transactionDescription' => 'Termination', 'billing' =>
> > 'Limited', 'RealTime' => '0:52' } ], 'Val' => { 'UserID' => '2414568' },
> > 'STATUS' => '0' } } } }, 'xmlns:xsd' => '
> http://www.w3.org/2001/XMLSchema',
> > 'xmlns:soap' => 'http://schemas.xmlsoap.org/soap/envelope/' };
> > =====================================================================
> >
> > use LWP::UserAgent;
> > use HTTP::Request;
> > use XML::Simple;
> > use Data::Dumper;
> >
> > my $message = '<?xml version="1.0" encoding="utf-8"?>
> > <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> > xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
> >   <soap:Header>
> >     <AuthHeader xmlns="vscws">
> >       <distriID>XXXX</distriID>
> >       <password>XXXXXX</password>
> >     </AuthHeader>
> >   </soap:Header>
> >   <soap:Body>
> >     <getUserTransactions xmlns="vscws">
> >       <controlNumber>XXXXXX</controlNumber>
> >       <transactionType></transactionType>
> >       <dateFrom>2009-11-10</dateFrom>
> >       <dateTo>2009-11-30</dateTo>
> >     </getUserTransactions>
> >   </soap:Body>
> > </soap:Envelope>';
> >
> > my $length = length($message);
> >
> > my $userAgent = LWP::UserAgent->new();
> > my $request = HTTP::Request->new(POST =>
> > 'http://200.XXX.XXX.XX:90/ws.asmx' <http://200.XXX.XXX.XX:90/ws.asmx%27>
> );
> > $request->header(SOAPAction => '"vscws/getUserTransactions"');
> > $request->content_type("text/xml; charset=utf-8");
> > $request->content_length($length);
> > $request->content($message);
> >
> > my $response = $userAgent->request($request);
> >
> >   #
> >   # Parseando o resultado (XML) do servidor
> >   #
> >   my $ref = XMLin( $response->content ) or die $!;
> >   my $xml = XMLout( my $hashref );
> >
> >   for ( my $i = $#{ $ref->{getUserTransactions} }; $i > 0; $i-- ) {
> >
> >       $startdate = "${ $ref->{getUserTransactions} }[$i]->{startTime}";
> >       $origem    = "${ $ref->{getUserTransactions} }[$i]->{ANI}";
> >       $destino   = "${ $ref->{getUserTransactions}
> > }[$i]->{DestinationNumber}";
> >       $descrip   = "${ $ref->{getUserTransactions}
> > }[$i]->{destinationDescription}";
> >       $duration  = "${ $ref->{getUserTransactions} }[$i]->{Time}";
> >       $cost      = "${ $ref->{getUserTransactions} }[$i]->{Cost}";
> >
> >    $tabelaprint .= "
> >      <tr>
> >       <td><p align=\"center\"><font face=\"Arial\"
> > size=\"1\"><b>$startdate</b></font></td>
> >       <td><p align=\"center\"><font face=\"Arial\"
> > size=\"1\">$origem</font></td>
> >       <td><p align=\"center\"><font face=\"Arial\"
> > size=\"1\"><b>$destino</b></font></td>
> >       <td><p align=\"center\"><font face=\"Arial\"
> > size=\"1\"><b>$descrip</b></font></td>
> >       <td><p align=\"center\"><font face=\"Arial\"
> > size=\"1\">$duration</font></td>
> >       <td><p align=\"center\"><font face=\"Arial\"
> > size=\"1\">$cost</font></td>
> >    </tr>
> >    ";
> >   }
> >
> > if($response->code == 200) {
> >   print "$tabelaprint";
> > }
> > else {
> >  print $response->error_as_HTML;
> > };
> Outra coisa, você está fazendo o parser do content, e depois que você
> termina você verifica se ele está ok ?
>
> É ao contrário!
>
> die unless $response->code == 200
> #Agora você faz o parser aqui!!!
>
> Você precisa de um carro para chegar em uma cidade, depois disso você
> vai queima-lo, o que seria certo:
> 1 - Checar o motor antes de partir ?
> 2 - Checar o motor depois que você chegou e não precisa mais do carro ?
>
>
>
>
>
>
>
>
> > Obrigado.
> > Marcio Mello.
> > marcio at modapoint.com.br
> > _______________________________________________
> > SaoPaulo-pm mailing list
> > SaoPaulo-pm at pm.org
> > http://mail.pm.org/mailman/listinfo/saopaulo-pm
> >
>
>
>
> --
> Existe dois tipos de pessoas, as que reclamam a vida inteira do que
> fazem, e as que fazem o que nasceram para fazer.
> _______________________________________________
> SaoPaulo-pm mailing list
> SaoPaulo-pm at pm.org
> http://mail.pm.org/mailman/listinfo/saopaulo-pm
>



-- 
André Garcia Carneiro
Analista/Desenvolvedor Perl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/saopaulo-pm/attachments/20091204/82ded685/attachment-0001.html>


More information about the SaoPaulo-pm mailing list