[Catalyst] model connect info to come from YAML configuration file

[Juan Miguel Paredes]

On 12/5/06, Juan Miguel Paredes <juan.paredes at gmail.com> wrote:
> On 12/5/06, Hermida, Leandro <Leandro.Hermida at fmi.ch> wrote:
> > Hello,
> >
> > I remember seeing the question being asked before but I couldn't find it
> > in the archives.  How does one set up the model connect info to come
> > from the YAML configuration file?  Using the tutorial as an example, I
> > created the model file with the helper script myapp_create.pl:
> >
> > $ script/myapp_create.pl model MyAppDB DBIC::Schema MyAppDB
> > dbi:SQLite:myapp.db '' '' '{ AutoCommit => 1 }'
> >      exists "/root/dev/MyApp/script/../lib/MyApp/Model"
> >      exists "/root/dev/MyApp/script/../t"
> >     created "/root/dev/MyApp/script/../lib/MyApp/Model/MyAppDB.pm"
> >     created "/root/dev/MyApp/script/../t/model_MyAppDB.t"
> >
> > Inside MyApp::Model::MyAppDB:
> >
> > use strict;
> > use base 'Catalyst::Model::DBIC::Schema';
> >
> > __PACKAGE__->config(
> >     schema_class => 'MyAppDB',
> >     connect_info => [
> >         'dbi:SQLite:myapp.db',
> >         '',
> >         '',
> >         { AutoCommit => 1 },
> >
> >     ],
> > );
> >
> >
> > How would I then make all of the connect info dynamic and acquired from
> > the myapp.yml file?  In particular the db driver (sqlite, mysql, pg,
> > oracle), host, port, username, password, etc.
> >
> >
> > Leandro
> >
> >
> > _______________________________________________
> > List: Catalyst at lists.rawmode.org
> > Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
> > Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
> > Dev site: http://dev.catalyst.perl.org/
> >
> Hi, All!
>
> Currently, I have something like:
>
> __PACKAGE__->config(
>     schema_class => 'MyAppBD',
>     connect_info => [
>         MyApp->config->{'db'},
>         MyApp->config->{'db_user'},
>         MyApp->config->{'db_password'},
>         {AutoCommit => 1}
>     ],
> );
>
> Regards.
>

Sorry, _send_ hitted before time...

And in myapp.yml, something like:

db: dbi:Pg:dbname=mydb;host=myhost
db_user: myuser
db_password: mypass