[Gllug] Perl Objects

[Nick Mailer]

On Fri, 2002-03-15 at 11:52, Jackson, Harry wrote:
> Hi all
> 
> Having played with Perl a while now I hate the shell ;-). Only Joking.
> 
> I have been doing some rummaging around inside Oracle using Perl and have
> found that it is quicker to write a script in Perl to produce reports than
> it is in SQL at least in my case. 

I've found that too. It's why I am happy to use MySQL for things that it
shouldn't be possible to use it for - I just want my RDBMS to give me
the data and give it quickly - I can handle everything else from Perl
which, frankly, is much better at fine grained referential checks than
any SQL kludge I've seen ;-)

> What I would like to do is have a set of
> scripts which can be called from another script and depending on the
> parameters passed they will create files of data by running some SQL against
> the database. These files can then be butchered by me to create the reports.
> I am trying to make it so that I can write scripts similar to the following
> 
> I am not completely sure as to the best way to do something like this but I
> do need a shove into which area of Perl is built for this kind of work. I do
> not need an example as I find Perl quite easy to pick up (at least so far).
> Is Objects the way to go or is it better to create scripts that carry out
> the tasks. 

Yes. You need three books. Damian Conway's Object Oriented Perl book,
the DBI::DBD book and the data munging book. With those three, your Perl
will be in your oyster.


-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug