Ticket #36: openguides-setup-db

#!/usr/bin/perl

use strict;
use warnings;

use OpenGuides::Config;

my $config_file = shift or die "Must specify config file on command line!";

if ( ! -r $config_file ) {
    die "Config file specified is not readable: $!";
}

my $config = OpenGuides::Config->new( file => $config_file);

# Initialise the database if necessary.
my $dbname = $config->dbname;
my $dbuser = $config->dbuser;
my $dbpass = $config->dbpass;
my $dbhost = $config->dbhost;
my $dbtype = $config->dbtype;

my %cgi_wiki_exts = ( postgres => "Pg",
                      mysql    => "MySQL",
                      sqlite   => "SQLite" );

my %dbd_exts = ( postgres => "Pg",
                 mysql => "mysql",
                 sqlite => "SQLite" );

my $cgi_wiki_module = "CGI::Wiki::Setup::" . $cgi_wiki_exts{$dbtype};
my $dbd_module = "DBD::" . $dbd_exts{$dbtype};

eval "require $dbd_module";

if ($@) {
    print "The DBD module is probably not installed;\n";
    print "we won't set up the database now.\n";
    exit 0;
}

eval "require $cgi_wiki_module";

if ($@) {
    print "The DBD module is probably not installed;\n";
    print "we won't set up the database now.\n";
    exit 0;
}
    
print "Checking database schema...\n";
{
    no strict 'refs';
    &{$cgi_wiki_module . "::setup"}( $dbname, $dbuser, $dbpass, $dbhost );
}