From 791275fb68a81061eee5cac3daccc06cbb6f2d27 Mon Sep 17 00:00:00 2001
From: rettenbe <rettenbe@594d385d-05f5-0310-b6e9-bd551577e9d8>
Date: Wed, 23 Apr 2008 10:24:10 +0000
Subject: [PATCH] change function get_where_statement, to handle the  INTEGER
 column id

git-svn-id: https://oss.gonicus.de/repositories/gosa/trunk@10642 594d385d-05f5-0310-b6e9-bd551577e9d8
---
 gosa-si/modules/GosaSupportDaemon.pm | 7 ++++++-
 gosa-si/tests/client.php             | 6 +++---
 2 files changed, 9 insertions(+), 4 deletions(-)

diff --git a/gosa-si/modules/GosaSupportDaemon.pm b/gosa-si/modules/GosaSupportDaemon.pm
index 0560933c1..a14d5def0 100644
--- a/gosa-si/modules/GosaSupportDaemon.pm
+++ b/gosa-si/modules/GosaSupportDaemon.pm
@@ -264,7 +264,12 @@ sub get_where_statement {
                 my @xml_tags = keys %{$phrase};
                 my $tag = $xml_tags[0];
                 my $val = $phrase->{$tag}[0];
-                push(@phrase_l, "$tag$operator'$val'");
+				# integer columns do not have to have single quotes besides the value
+				if ($tag eq "id") {
+						push(@phrase_l, "$tag$operator$val");
+				} else {
+						push(@phrase_l, "$tag$operator'$val'");
+				}
             }
             my $clause_str .= join(" $connector ", @phrase_l);
             push(@clause_l, "($clause_str)");
diff --git a/gosa-si/tests/client.php b/gosa-si/tests/client.php
index 4348bea9c..dafcce5cd 100755
--- a/gosa-si/tests/client.php
+++ b/gosa-si/tests/client.php
@@ -10,7 +10,7 @@ for($count = 1; $count <= $zahl; $count++)
 {
 
   $sock = new Socket_Client("127.0.0.1","20081",TRUE,1);
-  $sock->setEncryptionKey("secret-gosa-password");
+  $sock->setEncryptionKey("UldOjon9gra");
 
   if($sock->connected()){
 
@@ -21,7 +21,7 @@ for($count = 1; $count <= $zahl; $count++)
     #$data = "<xml> <header>job_ping</header> <source>GOSA</source> <target>00:01:6c:9d:b9:fa</target> <macaddress>00:01:6c:9d:b9:fa</macaddress><timestamp>19700101000000</timestamp> </xml>";
 
     # jobdb delete
-    #$data = "<xml> <header>gosa_delete_jobdb_entry</header> <source>GOSA</source> <target>GOSA</target> <where><clause><phrase><id>1</id></phrase></clause></where></xml>";
+    $data = "<xml> <header>gosa_delete_jobdb_entry</header> <source>GOSA</source> <target>GOSA</target> <where><clause><phrase><id>3</id></phrase></clause></where></xml>";
 
     # smbhash
     #$data = "<xml> <header>gosa_gen_smb_hash</header> <source>GOSA</source><target>GOSA</target><password>tester</password></xml>";
@@ -99,7 +99,7 @@ for($count = 1; $count <= $zahl; $count++)
 
     #########
     # Kerberos test query
-    $data = "<xml> <header>gosa_krb5_list_principals</header> <target>00:01:6c:9d:b9:fa</target> <source>GOSA</source></xml>"; 
+    #$data = "<xml> <header>gosa_krb5_list_principals</header> <target>00:01:6c:9d:b9:fa</target> <source>GOSA</source></xml>"; 
 
     $sock->write($data);
     $answer = "nothing";
-- 
2.30.2