![[tokkee]](http://tokkee.org/images/avatar.png){kind=avatar}
index 04a1f29c575d0a5ea1c1b22047aa147afb104617..d8942c9e6b1c629b1b3e714134a981d19ed8631d 100644 (file)
use GOSA::DBsqlite;
use MIME::Base64;
-my $op_hash = {
- 'eq' => '=',
- 'ne' => '!=',
- 'ge' => '>=',
- 'gt' => '>',
- 'le' => '<=',
- 'lt' => '<',
-};
BEGIN{}
END{}
# 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;
- }
- &main::daemon_log("open_socket to: $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;
+# }
+# &main::daemon_log("open_socket to: $PeerAddr", 7);
+# return $socket;
+#}
#=== FUNCTION ================================================================
#===============================================================================
sub process_incoming_msg {
my ($crypted_msg) = @_ ;
- &main::daemon_log("Got message $crypted_msg", 8);
if( (not(defined($crypted_msg))) || (length($crypted_msg) <= 0)) {
&main::daemon_log("function 'process_incoming_msg': got no msg", 7);
return;
my $out_cipher = &create_ciphering($gosa_passwd);
$out_msg = &encrypt_msg($out_msg, $out_cipher);
-
return $out_msg;
}
my $xml = "<xml>";
- while ( my ($hit, $hash) = each %{ $db_res } ) {
- $xml .= "\n<answer$hit>";
+ my $len_db_res= keys %{$db_res};
+ for( my $i= 1; $i<= $len_db_res; $i++ ) {
+ $xml .= "\n<answer$i>";
+ my $hash= $db_res->{$i};
while ( my ($column_name, $column_value) = each %{$hash} ) {
$xml .= "<$column_name>";
my $xml_content;
$xml .= $xml_content;
$xml .= "</$column_name>";
}
+ $xml .= "</answer$i>";
- $xml .= "</answer$hit>";
}
$xml .= "</xml>";
## CORE FUNCTIONS ############################################################
-sub get_where_statement {
- my ($msg, $msg_hash)= @_;
- my $error= 0;
-
- my $clause_str= "";
- if( 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;
-}
-
-
-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 query_jobdb {
my ($msg) = @_;
my $msg_hash = &transform_msg2hash($msg);
my $table= $main::job_queue_table_name;
my $where= &get_where_statement($msg, $msg_hash);
my $limit= &get_limit_statement($msg, $msg_hash);
- my $sql_statement= "SELECT $select FROM $table $where $limit";
+ my $orderby= &get_orderby_statement($msg, $msg_hash);
+ my $sql_statement= "SELECT $select FROM $table $where $orderby $limit";
# execute db query
my $res_hash = $main::job_db->select_dbentry($sql_statement);