Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask

Re: DB Connection using CGI::Application

by sundialsvc4 (Abbot)
on Apr 25, 2013 at 12:53 UTC ( #1030661=note: print w/replies, xml ) Need Help??

in reply to DB Connection using CGI::Application

Good morning .. did someone forget to log-in first?

The thing that I was trying to explain is simply how a CGI::Application process works.   An object that descends from that base class is instantiated, then you call its run() method.   During the object’s constructor, new(), and within run(), a series of method calls occur ... init, setup, page-handler, postrun, and so on.   This means that the object exists the entire time.   (And, once the CGI request is finished, everything goes away.)

This, therefore, is how you take care of your database-handles or anything else that you need to refer during the course of the request.   Simply store them as properties of your object:   $self->{'dbh_1'} = ... ;.   Set these up, say, in the appropriately-named setup() method.   Or write a short subroutine that instantiates them on-demand.   It’s entirely up to you.

Yes, there are plenty of plugins available.

Could you use param()?   Take a look at its implementation and you will see that the answer is obviously “yes.”   But you don’t have to, and, I tend to think, that’s not really “the designer’s intent.”

  • Comment on Re: DB Connection using CGI::Application

Replies are listed 'Best First'.
Re^2: DB Connection using CGI::Application
by Anonymous Monk on Apr 26, 2013 at 12:34 UTC

    Good morning .. did someone forget to log-in first? ..

    Clever trick, responding to someone else again, you're number one troll

    The thing that I was trying to explain is simply how ...

    Yes, like you keep explaining, you don't care what the question is, you simply ignore it and tangent on with irrelevant tangents -- one connection works, the other one doesn't -- must be request cycle .... nonsense

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1030661]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (5)
As of 2018-06-22 04:43 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (121 votes). Check out past polls.