index bc5458af4a1d4d88e49e4bfb01d8395f579bbea2..93ff49d7a66b72e2fd26eb916a75483da16c3d28 100644 (file)
use Exporter;
@ISA = qw(Exporter);
-@EXPORT = qw(create_xml_hash send_msg_hash2address get_content_from_xml_hash add_content2xml_hash create_xml_string encrypt_msg decrypt_msg create_ciphering transform_msg2hash send_msg);
+@EXPORT = qw(create_xml_hash send_msg_hash2address get_content_from_xml_hash add_content2xml_hash create_xml_string encrypt_msg decrypt_msg create_ciphering transform_msg2hash get_time send_msg get_where_statement get_select_statement get_update_statement get_limit_statement get_orderby_statement);
use strict;
use warnings;
use MIME::Base64;
use XML::Simple;
+my $op_hash = {
+ 'eq' => '=',
+ 'ne' => '!=',
+ 'ge' => '>=',
+ 'gt' => '>',
+ 'le' => '<=',
+ 'lt' => '<',
+};
BEGIN {}
my $xml = new XML::Simple();
-
-sub process_incoming_msg {
- return;
-}
-
sub daemon_log {
my ($msg, $level) = @_ ;
&main::daemon_log($msg, $level);
}
-##=== FUNCTION ================================================================
-## NAME: logging
-## PARAMETERS: level - string - default 'info'
-## msg - string -
-## facility - string - default 'LOG_DAEMON'
-## RETURNS: nothing
-## DESCRIPTION: function for logging
-##===============================================================================
-#my $log_file = $main::log_file;
-#my $verbose = $main::verbose;
-#my $foreground = $main::forground;
-#sub daemon_log {
-# # log into log_file
-# my( $msg, $level ) = @_;
-# if(not defined $msg) { return }
-# if(not defined $level) { $level = 1 }
-# if(defined $log_file){
-# open(LOG_HANDLE, ">>$log_file");
-# if(not defined open( LOG_HANDLE, ">>$log_file" )) {
-# print STDERR "cannot open $log_file: $!";
-# return }
-# chomp($msg);
-# if($level <= $verbose){
-# print LOG_HANDLE "$level $msg\n";
-# if(defined $foreground) { print $msg."\n" }
-# }
-# }
-# close( LOG_HANDLE );
-##log into syslog
-## my ($msg, $level, $facility) = @_;
-## if(not defined $msg) {return}
-## if(not defined $level) {$level = "info"}
-## if(not defined $facility) {$facility = "LOG_DAEMON"}
-## openlog($0, "pid,cons,", $facility);
-## syslog($level, $msg);
-## closelog;
-## return;
-#}
-
-
#=== FUNCTION ================================================================
# NAME: create_xml_hash
# PARAMETERS: header - string - message header (required)
target => [$target],
$header => [$header_value],
};
- #daemon_log("create_xml_hash:", 7),
- #chomp(my $tmp = Dumper $hash);
- #daemon_log("\t$tmp", 7);
return $hash
}
sub transform_msg2hash {
my ($msg) = @_ ;
-
my $hash = $xml->XMLin($msg, ForceArray=>1);
+
+ # xml tags without a content are created as an empty hash
+ # substitute it with an empty list
+ eval {
+ while( my ($xml_tag, $xml_content) = each %{ $hash } ) {
+ if( 1 == @{ $xml_content } ) {
+ # there is only one element in xml_content list ...
+ my $element = @{ $xml_content }[0];
+ if( ref($element) eq "HASH" ) {
+ # and this element is an hash ...
+ my $len_element = keys %{ $element };
+ if( $len_element == 0 ) {
+ # and this hash is empty, then substitute the xml_content
+ # with an empty string in list
+ $hash->{$xml_tag} = [ "none" ];
+ }
+ }
+ }
+ }
+ };
+ if( $@ ) {
+ $hash = undef;
+ }
+
return $hash;
}
# RETURNS: nothing
# DESCRIPTION: ????
#===============================================================================
-sub send_msg_hash2address {
- my ($msg_hash, $address, $passwd) = @_ ;
-
- # fetch header for logging
- my $header = @{$msg_hash->{header}}[0];
-
- # generate xml string
- my $msg_xml = &create_xml_string($msg_hash);
-
- # fetch the appropriated passwd from hash
- if(not defined $passwd) {
- if(exists $main::known_daemons->{$address}) {
- $passwd = $main::known_daemons->{$address}->{passwd};
- } elsif(exists $main::known_clients->{$address}) {
- $passwd = $main::known_clients->{$address}->{passwd};
-
- } else {
- daemon_log("$address not known, neither as server nor as client", 1);
- return 1;
- }
- }
-
- # create ciphering object
- my $act_cipher = &create_ciphering($passwd);
-
- # encrypt xml msg
- my $crypted_msg = &encrypt_msg($msg_xml, $act_cipher);
-
- # opensocket
- my $socket = &open_socket($address);
- if(not defined $socket){
- daemon_log("cannot send '$header'-msg to $address , server not reachable",
- 5);
-
- if (exists $main::known_clients->{$address}) {
- if ($main::known_clients->{$address}->{status} eq "down") {
- # if status of not reachable client is already 'down',
- # then delete client from known_clients
- &clean_up_known_clients($address);
-
- } else {
- # update status to 'down'
- &update_known_clients(hostname=>$address, status=>"down");
-
- }
- }
- return 1;
- }
-
- # send xml msg
- print $socket $crypted_msg."\n";
-
- close $socket;
-
- daemon_log("send '$header'-msg to $address", 1);
-
- daemon_log("$msg_xml", 5);
-
- #daemon_log("crypted message:",7);
- #daemon_log("\t$crypted_msg", 7);
-
- # update status of client in known_clients with last send msg
- if(exists $main::known_daemons->{$address}) {
- #&update_known_daemons();
- } elsif(exists $main::known_clients->{$address}) {
- &main::update_known_clients(hostname=>$address, status=>$header);
- }
-
- return 0;
-}
+#sub send_msg_hash2address ($$$){
+# my ($msg_hash, $address, $passwd) = @_ ;
+#
+# # fetch header for logging
+# my $header = @{$msg_hash->{header}}[0];
+#
+# # generate xml string
+# my $msg_xml = &create_xml_string($msg_hash);
+#
+# # create ciphering object
+# my $act_cipher = &create_ciphering($passwd);
+#
+# # encrypt xml msg
+# my $crypted_msg = &encrypt_msg($msg_xml, $act_cipher);
+#
+# # opensocket
+# my $socket = &open_socket($address);
+# if(not defined $socket){
+# daemon_log("cannot send '$header'-msg to $address , server not reachable", 5);
+# return 1;
+# }
+#
+# # send xml msg
+# print $socket $crypted_msg."\n";
+#
+# close $socket;
+#
+# daemon_log("send '$header'-msg to $address", 1);
+# daemon_log("message:\n$msg_xml", 8);
+# return 0;
+#}
#=== FUNCTION ================================================================
# value - list - for all other keys in xml hash
# DESCRIPTION:
#===============================================================================
-sub get_content_from_xml_hash {
- my ($xml_ref, $element) = @_ ;
- #my $result = $main::xml_ref->{$element};
- #if( $element eq "header" || $element eq "target" || $element eq "source") {
- # return @$result[0];
- #}
- my @result = $xml_ref->{$element};
- return \@result;
-}
+#sub get_content_from_xml_hash {
+# my ($xml_ref, $element) = @_ ;
+# #my $result = $main::xml_ref->{$element};
+# #if( $element eq "header" || $element eq "target" || $element eq "source") {
+# # return @$result[0];
+# #}
+# my @result = $xml_ref->{$element};
+# return \@result;
+#}
#=== FUNCTION ================================================================
# DESCRIPTION: crypts the incoming message with the Crypt::Rijndael module
#===============================================================================
sub encrypt_msg {
- my ($msg, $my_cipher) = @_;
- if(not defined $my_cipher) { print "no cipher object\n"; }
- $msg = "\0"x(16-length($msg)%16).$msg;
- my $crypted_msg = $my_cipher->encrypt($msg);
- chomp($crypted_msg = &encode_base64($crypted_msg));
- return $crypted_msg;
+# my ($msg, $my_cipher) = @_;
+# if(not defined $my_cipher) { print "no cipher object\n"; }
+# {
+# use bytes;
+# $msg = "\0"x(16-length($msg)%16).$msg;
+# }
+# $msg = $my_cipher->encrypt($msg);
+# chomp($msg = &encode_base64($msg));
+#
+# # there are no newlines allowed inside msg
+# $msg=~ s/\n//g;
+#
+# return $msg;
+ my ($msg, $key) = @_;
+ my $my_cipher = &create_ciphering($key);
+ {
+ use bytes;
+ $msg = "\0"x(16-length($msg)%16).$msg;
+ }
+ $msg = $my_cipher->encrypt($msg);
+ chomp($msg = &encode_base64($msg));
+ # there are no newlines allowed inside msg
+ $msg=~ s/\n//g;
+ return $msg;
+
}
# DESCRIPTION: decrypts the incoming message with the Crypt::Rijndael module
#===============================================================================
sub decrypt_msg {
- my ($crypted_msg, $my_cipher) = @_ ;
- $crypted_msg = &decode_base64($crypted_msg);
- my $msg = $my_cipher->decrypt($crypted_msg);
+# my ($msg, $my_cipher) = @_ ;
+#
+# if(defined $msg && defined $my_cipher) {
+# $msg = &decode_base64($msg);
+# }
+# $msg = $my_cipher->decrypt($msg);
+# $msg =~ s/\0*//g;
+# return $msg;
+ my ($msg, $key) = @_ ;
+ $msg = &decode_base64($msg);
+ my $my_cipher = &create_ciphering($key);
+ $msg = $my_cipher->decrypt($msg);
$msg =~ s/\0*//g;
return $msg;
}
# RETURNS: socket IO::Socket::INET
# DESCRIPTION: open a socket to PeerAddr
#===============================================================================
-sub open_socket {
- my ($PeerAddr, $PeerPort) = @_ ;
- if(defined($PeerPort)){
- $PeerAddr = $PeerAddr.":".$PeerPort;
- }
- my $socket;
- $socket = new IO::Socket::INET(PeerAddr => $PeerAddr,
- Porto => "tcp",
- Type => SOCK_STREAM,
- Timeout => 5,
- );
- if(not defined $socket) {
- return;
- }
- &daemon_log("open_socket:", 7);
- &daemon_log("\t$PeerAddr", 7);
- return $socket;
+#sub open_socket {
+# my ($PeerAddr, $PeerPort) = @_ ;
+# if(defined($PeerPort)){
+# $PeerAddr = $PeerAddr.":".$PeerPort;
+# }
+# my $socket;
+# $socket = new IO::Socket::INET(PeerAddr => $PeerAddr,
+# Porto => "tcp",
+# Type => SOCK_STREAM,
+# Timeout => 5,
+# );
+# if(not defined $socket) {
+# return;
+# }
+# &daemon_log("open_socket: $PeerAddr", 7);
+# return $socket;
+#}
+
+
+sub get_time {
+ my ($seconds, $minutes, $hours, $monthday, $month,
+ $year, $weekday, $yearday, $sommertime) = localtime(time);
+ $hours = $hours < 10 ? $hours = "0".$hours : $hours;
+ $minutes = $minutes < 10 ? $minutes = "0".$minutes : $minutes;
+ $seconds = $seconds < 10 ? $seconds = "0".$seconds : $seconds;
+ $month+=1;
+ $month = $month < 10 ? $month = "0".$month : $month;
+ $monthday = $monthday < 10 ? $monthday = "0".$monthday : $monthday;
+ $year+=1900;
+ return "$year$month$monthday$hours$minutes$seconds";
+
}
&add_content2xml_hash($out_hash, $key, $value);
}
}
+ my $out_msg = &create_xml_string($out_hash);
+ return $out_msg;
+}
+
+
+sub get_where_statement {
+ my ($msg, $msg_hash) = @_;
+ my $error= 0;
+
+ my $clause_str= "";
+ if( (not exists $msg_hash->{'where'}) || (not exists @{$msg_hash->{'where'}}[0]->{'clause'}) ) {
+ $error++;
+ }
+
+ if( $error == 0 ) {
+ my @clause_l;
+ my @where = @{@{$msg_hash->{'where'}}[0]->{'clause'}};
+ foreach my $clause (@where) {
+ my $connector = $clause->{'connector'}[0];
+ if( not defined $connector ) { $connector = "AND"; }
+ $connector = uc($connector);
+ delete($clause->{'connector'});
+
+ my @phrase_l ;
+ foreach my $phrase (@{$clause->{'phrase'}}) {
+ my $operator = "=";
+ if( exists $phrase->{'operator'} ) {
+ my $op = $op_hash->{$phrase->{'operator'}[0]};
+ if( not defined $op ) {
+ &main::daemon_log("Can not translate operator '$operator' in where ".
+ "statement to sql valid syntax. Please use 'eq', ".
+ "'ne', 'ge', 'gt', 'le', 'lt' in xml message\n", 1);
+ &main::daemon_log($msg, 8);
+ $op = "=";
+ }
+ $operator = $op;
+ delete($phrase->{'operator'});
+ }
+
+ my @xml_tags = keys %{$phrase};
+ my $tag = $xml_tags[0];
+ my $val = $phrase->{$tag}[0];
+ push(@phrase_l, "$tag$operator'$val'");
+ }
+ my $clause_str .= join(" $connector ", @phrase_l);
+ push(@clause_l, $clause_str);
+ }
+
+ if( not 0 == @clause_l ) {
+ $clause_str = join(" AND ", @clause_l);
+ $clause_str = "WHERE $clause_str ";
+ }
+ }
+
+ return $clause_str;
+}
+
+sub get_select_statement {
+ my ($msg, $msg_hash)= @_;
+ my $select = "*";
+ if( exists $msg_hash->{'select'} ) {
+ my $select_l = \@{$msg_hash->{'select'}};
+ $select = join(' AND ', @{$select_l});
+ }
+ return $select;
+}
- &send_msg_hash2address($out_hash, $to);
+
+sub get_update_statement {
+ my ($msg, $msg_hash) = @_;
+ my $error= 0;
+ my $update_str= "";
+ my @update_l;
+
+ if( not exists $msg_hash->{'update'} ) { $error++; };
+
+ if( $error == 0 ) {
+ my $update= @{$msg_hash->{'update'}}[0];
+ while( my ($tag, $val) = each %{$update} ) {
+ my $val= @{$update->{$tag}}[0];
+ push(@update_l, "$tag='$val'");
+ }
+ if( 0 == @update_l ) { $error++; };
+ }
+
+ if( $error == 0 ) {
+ $update_str= join(', ', @update_l);
+ $update_str= "SET $update_str ";
+ }
+
+ return $update_str;
+}
+
+sub get_limit_statement {
+ my ($msg, $msg_hash)= @_;
+ my $error= 0;
+ my $limit_str = "";
+ my ($from, $to);
+
+ if( not exists $msg_hash->{'limit'} ) { $error++; };
+
+ if( $error == 0 ) {
+ eval {
+ my $limit= @{$msg_hash->{'limit'}}[0];
+ $from= @{$limit->{'from'}}[0];
+ $to= @{$limit->{'to'}}[0];
+ };
+ if( $@ ) {
+ $error++;
+ }
+ }
+
+ if( $error == 0 ) {
+ $limit_str= "LIMIT $from, $to";
+ }
+
+ return $limit_str;
+}
+
+sub get_orderby_statement {
+ my ($msg, $msg_hash)= @_;
+ my $error= 0;
+ my $order_str= "";
+ my $order;
+
+ if( not exists $msg_hash->{'orderby'} ) { $error++; };
+
+ if( $error == 0) {
+ eval {
+ $order= @{$msg_hash->{'orderby'}}[0];
+ };
+ if( $@ ) {
+ $error++;
+ }
+ }
+
+ if( $error == 0 ) {
+ $order_str= "ORDER BY $order";
+ }
+
+ return $order_str;
}
1;