Re: Class::DBI connect info from file?


There's more than one way to do things
	PerlMonks

Re: Class::DBI connect info from file?

by jest (Pilgrim)

on Jan 21, 2004 at 22:15 UTC ( [id://323041]=note: print w/replies, xml )

Need Help??

in reply to Class::DBI connect info from file?

I keep my connection info in a config file, so I'll have something like library.site.conf that includes

DB_NAME         = library
DB_HOST         = localhost
DB_USER         = username
DB_PASS         = password
[download]

Then, in my base DBI package, I have:

package MyDatabase::DBI;
use base qw(Class::DBI::mysql);
my %config;
use Config::General;
my $conf = new Config::General(
  -ConfigFile => '/usr/local/configfiles/library.site.conf',
  -InterPolateVars => 1
                              );
%config = $conf->getall;

my $dsn = "DBI:mysql:host=$config{DB_HOST};database=$config{DB_NAME}";
my $db_user = $config{DB_USER};
my $db_pass = $config{DB_PASS};

__PACKAGE__->set_db('Main', $dsn, $db_user, $db_pass);
# etc.
[download]

There are a ton of similar ways to do this.