Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re: Object Oriented Pattern help

by bjelli (Pilgrim)
on May 12, 2001 at 13:57 UTC ( #79931=note: print w/replies, xml ) Need Help??

in reply to Object Oriented Pattern help

I know you want to program the stuff for yourself, but you might get some ideas by reading code:

There is a module Class::DBI that helps you create a Class that is closly linked to one Table in a Database.

It reuses the DB connection, and there is a function set_sql to generate reusable sql-statements (and statement handles).

Brigitte    'I never met a chocolate I didnt like'    Jellinek

Replies are listed 'Best First'.
Re: Re: Object Oriented Pattern help
by thefid (Friar) on May 12, 2001 at 19:09 UTC
    The module Class::DBI was exactly what I was looking for... thanks!

    Like koolade suggested, it may not be a good idea to open a database connection for every object, since I may have the case where a query for guests may return up to 100 objects. It looks like this module is efficient in that respects using the module Ima::DBI where it states:

    Holds off opening a database connection until necessary. While Ima::DBI is informed of all your database connections and SQL statements at compile-time, it will not connect to the database until you actually prepare a statement on that connection. This is obviously very good for programs that sometimes never touch the database. It's also good for code that has lots of possible connections and statements, but which typically only use a few. Kinda like an autoloader.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (4)
As of 2018-03-19 02:09 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (231 votes). Check out past polls.