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;
24 use Data::Dumper;
26 print "START\n";
27 my $res;
28 my $db_name;
30 $db_name = "/var/lib/gosa-si/fai.db";
31 if (-e $db_name) {
32 print "\n############################################################\n";
33 my $table_name = "fai_server";
34 print "$db_name\n";
35 print "$table_name\n";
37 my $sqlite = GOSA::DBsqlite->new($db_name);
38 my $col_names = $sqlite->get_table_columns($table_name);
39 print join(', ', @{ $col_names } )."\n" ;
40 my $answer = $sqlite->show_table($table_name);
41 print $answer."\n";
42 }
44 $db_name = "/var/lib/gosa-si/fai.db";
45 if (-e $db_name) {
46 print "\n############################################################\n";
47 my $table_name = "fai_release";
48 print "$db_name\n";
49 print "$table_name\n";
51 my $sqlite = GOSA::DBsqlite->new($db_name);
52 my $col_names = $sqlite->get_table_columns($table_name);
53 print join(', ', @{ $col_names } )."\n" ;
54 my $answer = $sqlite->show_table($table_name);
55 print $answer."\n";
56 }
58 print "\nFINISH\n";