index b80039b62ed529901c69d5eb61d1cf9444b059d9..5ecbe49a9855eaf70a9c678793967b06a261da01 100755 (executable)
use strict;
use warnings;
-use GOSA::DBsqlite;
+use GOSA::DBmysql;
use Data::Dumper;
print "START\n";
-my $res;
-my $db_name;
-
+my $table_name = "jobs";
-$db_name = "/var/lib/gosa-si/jobs.db";
-if (-e $db_name) {
- print "\n############################################################\n";
- my $table_name = "jobs";
- 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 "\n############################################################\n";
+print "$table_name\n";
+
+my $dbh = GOSA::DBmysql->new('gosa_si', '127.0.0.1', 'gosa_si', 'gosa');
+
+my $col_names = $dbh->get_table_columns($table_name);
+print join(', ', @{ $col_names } )."\n" ;
- print join(', ', @{ $col_names } )."\n" ;
- my $answer = $sqlite->show_table($table_name);
- print $answer."\n";
-}
+my $answer = $dbh->show_table($table_name);
+print $answer."\n";
print "\nFINISH\n";