Replaced $0 by $prg

[gosa.git] / gosa-si / tests / sqlite-check.pl

diff --git a/gosa-si/tests/sqlite-check.pl b/gosa-si/tests/sqlite-check.pl
index 94d19847f200ede4ee9259f5faabf39ae54233a0..b9752be258381f4337b932ad0814b2a60fd71b42 100755 (executable)
--- a/gosa-si/tests/sqlite-check.pl
+++ b/gosa-si/tests/sqlite-check.pl
@@ -28,7 +28,7 @@ my $res;
 my $db_name;
 
     
-$db_name = "/var/lib/gosa-si/gosa-si-server_jobs.db";
+$db_name = "/var/lib/gosa-si/jobs.db";
 if (-e $db_name) {
     print "\n############################################################\n";
     my $table_name = "jobs";
@@ -42,7 +42,7 @@ if (-e $db_name) {
 }
 
 
-$db_name = "/var/lib/gosa-si/gosa-si-server_known_clients.db";
+$db_name = "/var/lib/gosa-si/clients.db";
 if (-e $db_name) {
     print "\n############################################################\n";
 #    $db_name =~ /\/([^\/]*?)\.db$/;
@@ -59,7 +59,7 @@ if (-e $db_name) {
 }
 
 
-$db_name = "/var/lib/gosa-si/gosa-si-server_known_server.db";
+$db_name = "/var/lib/gosa-si/servers.db";
 if (-e $db_name) {
     print "\n############################################################\n";
 #    $db_name =~ /\/([^\/]*?)\.db$/;
@@ -76,7 +76,7 @@ if (-e $db_name) {
 }
 
 
-$db_name = "/var/lib/gosa-si/gosa-si-bus_known_server.db";
+$db_name = "/var/lib/gosa-si/bus-server.db";
 if (-e $db_name) {
     print "\n############################################################\n";
 #    $db_name =~ /\/([^\/]*?)\.db$/;
@@ -91,6 +91,19 @@ if (-e $db_name) {
     print $answer."\n";
 }
 
-
+$db_name = "/var/lib/gosa-si/bus-clients.db";
+if (-e $db_name) {
+    print "\n############################################################\n";
+#    $db_name =~ /\/([^\/]*?)\.db$/;
+#    my $table_name = $1;
+    my $table_name = "bus_known_clients";
+    print "$db_name\n";
+    print "$table_name\n";
+    my $sqlite = GOSA::DBsqlite->new($db_name);
+    my $col_names = $sqlite->get_table_columns($table_name);
+    print join(', ', @{ $col_names } )."\n" ;
+    my $answer = $sqlite->show_table($table_name);
+    print $answer."\n";
+}
 
 print "\nFINISH\n";