Re^2: Change DBI database on runtime

[miguelele]

Wow!, isn't it overkill just for a string with the name of the database?, a name that (yes or yes) must be used in each request?

It seems strange that I can't split up the connection data from the schema itself

I have been looking for info on the plugins you mention. Thank you!! and Factory::PerRequest seems to be a solution, but info is very schematic. I am still learning from tutorials!!!

What i have is this model:

package the_application::Model::DB;

use strict;
use base 'Catalyst::Model::DBIC::Schema';

__PACKAGE__->config(
    schema_class => 'the_application::Schema',
    
    connect_info => {
          dsn => 'dbi:mysql:database_one:the_domain.com',
        user => 'the_user',
        password => 'the_password',
        AutoCommit => q{1},
    }
);

1;

- How can I wrap it using Factory::PerRequest and change "dsn" on the fly from a Controller?

Regards