Obviously, there is something big that I do not understand in the Adaptor/Factory/Factory::PerRequest question.
- I have the working db class posted before, called 'DB'
- Now I wrap it from this new model called 'DBWrapper'. And I call this one from the Controller.
- I need to configure the __PACKAGE__ to avoid compile errors from DBI. Configuration data must be present. I do not understand it, because this info should be replaced from the info coming from the request.
- The ACCEPT_CONTEXT sub really executes. I see the required info printed in the log (THEALIAS comes from Fastcgi/Nginx custom variable)

In the end it always query the db named "database_one" configured here, but it ignores the dynamic one from ACCEPT_CONTEXT. I tried also static values, but obviously there is something that I am doing very bad

Really lost.

package the_application::Model::DBWrapper;

use strict;
use warnings;

use parent 'Catalyst::Model::Factory::PerRequest';


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



use Moose;
use namespace::autoclean;
 
sub ACCEPT_CONTEXT {
    my($self, $c) = @_;
    
    # Current db name comes from fastcgi enviromental variable from Ng
+inx
    my $current_db = $c->engine->env->{THEALIAS}; 
    $c->log->debug('*** Reached ACCEPT_CONTEXT current db = ' . $curre
+nt_db);


    my $new = $self->meta->clone_object($self, 
        
        connect_info => {
            dsn => 'dbi:mysql:' . $current_db . ':the_domain.com',
            user => 'the_user',
            password => 'the_password',
            AutoCommit => q{1},
        }
    );
    return $new;        
}

1;
[download]