DB接続情報をyamlファイルへ

モデルファイルに直接書く場合

lib/Myapp/Model/MyappDB.pm :

 package Myapp::Model::MyappDB;
 use strict;
 use base 'Catalyst::Model::DBIC::Schema';
 
 __PACKAGE__->config(
     schema_class => 'MyappDB',
     connect_info => [
         'dbi:Pg:dbname=testdb;host=192.168.0.1',
         'taro',
         'pass',
      ],
 );

DB接続情報をyamlファイルへ移す

myapp.yml:

 db: dbi:Pg:dbname=testdb;host=192.168.0.1
 db_user: taro
 db_password: pass

lib/Myapp/Model/MyappDB.pm:

 package Myapp::Model::MyappDB;
 
 use strict;
 use base 'Catalyst::Model::DBIC::Schema';
 
 __PACKAGE__->config(
     schema_class => 'MyappDB',
     connect_info => [
         Myapp->config->{db},
         Myapp->config->{db_user},
         Myapp->config->{db_password},
     ],
 );