1 #!/usr/bin/perl
2 #===============================================================================
3 #
4 # FILE: DBD-SQlite.pl
5 #
6 # USAGE: ./DBD-SQlite.pl
7 #
8 # DESCRIPTION:
9 #
10 # OPTIONS: ---
11 # REQUIREMENTS: ---
12 # BUGS: ---
13 # NOTES: ---
14 # AUTHOR: (), <>
15 # COMPANY:
16 # VERSION: 1.0
17 # CREATED: 20.12.2007 08:54:52 CET
18 # REVISION: ---
19 #===============================================================================
21 use strict;
22 use warnings;
23 use GOSA::DBsqlite;
26 sub daemon_log {}
27 print "START\n";
28 my $res;
29 my $db_name;
32 $db_name = "/var/lib/gosa-si/messaging.db";
33 if (-e $db_name) {
34 print "\n############################################################\n";
35 my $table_name = "messaging";
36 print "$db_name\n";
37 print "$table_name\n";
38 my $sqlite = GOSA::DBsqlite->new($db_name);
39 my $col_names = $sqlite->get_table_columns($table_name);
40 print join(', ', @{ $col_names } )."\n" ;
41 my $answer = $sqlite->show_table($table_name);
42 print $answer."\n";
43 }
45 print "\nFINISH\n";