Catalyst and DBI

Uragan has asked for the wisdom of the Perl Monks concerning the following question:

Hi all! I use Catalyst and DBI. I want to connect my database only in one place. But now every model has it's own connection and I must write in config file params(dsn, username, password) for every model, like this:

<Model::Name_of_model>
    dsn DBI:mysql:name_of_database
    user username
    password user_password
</Model::Name_of_Model>
[download]

I must do it for every model. Is it possible to do it only once and in one place? And that each model would take these params.

Comment on Catalyst and DBI Download Code

Replies are listed 'Best First'.
Re: Catalyst and DBI by Anonymous Monk on Jul 04, 2011 at 06:56 UTC
http://search.cpan.org/~bobtfish/Catalyst-Manual-5.8007/lib/Catalyst/Manual/Tutorial/08_Testing.pod#SUPPORTING_BOTH_PRODUCTION_AND_TEST_DATABASES	[reply]
Re: Catalyst and DBI by trwww (Priest) on Jul 04, 2011 at 18:58 UTC
How did you create your model? I ask because if you're having to add in connection info for each model class then you're doing it wrong. You only need to set the database configuration in one place. See: Catalyst::Model::DBIC::Schema	[reply]
Re^2: Catalyst and DBI by Uragan (Initiate) on Jul 04, 2011 at 20:41 UTC
I don't use DBIx. I use Catalyst::Model::DBI. When I create a model, I write next: `./app_create.pl model Name_of_Model DBI:mysql:auth username password` In this case dsn, username and password pass into the model configuration. So each model has it's own configuration (the same). Without this configuration model can not connect to database. I use DBI, because I must write live queries without any ORM. I now thar it's wrong write configuration in every model and when every model connects to DB separately, but I can not understand, how I can do only one connection and write connection params in one place(((	[reply] [d/l]
Re^3: Catalyst and DBI by Solo (Deacon) on Aug 25, 2011 at 09:28 UTC
I use DBI, because I must write live queries without any ORM... But now every model has it's own connection... Do you need more than one DBI model per database, and if so, why? --Solo -- You said you wanted to be around when I made a mistake; well, this could be it, sweetheart.	[reply]
Re: Catalyst and DBI by brainbuz (Novice) on Sep 08, 2011 at 15:16 UTC
Re: Catalyst and DBI by sundialsvc4 (Abbot) on Jul 04, 2011 at 12:50 UTC
As an aside, not directly related to Catalyst but worth bringing up anyway, I recently “discovered” DBIx::Connector ... “`DBIx::Connector` provides a simple interface for fast and safe `DBI` connection and transaction management. Connecting to a database can be expensive; you don't want your application to re-connect every time you need to run a query. The efficient thing to do is to hang on to a database handle to maintain a connection to the database in order to minimize that overhead. `DBIx::Connector` lets you do that without having to worry about dropped or corrupted connections.” It made a very dramatic speed difference to the kludgy old app that I am busy rehabilitating, and stood up quite well to initial stress-tests.	[reply]

Back to Seekers of Perl Wisdom