[Catalyst] getting database handles and run arbitrary SQL

[theshz]

Hi, I'm new to Catalyst, just went through the Tutorial, everything worked =
fine. But for my reporting application (part of a bigger application where =
CRUD will be more often), I need to run some complicated querries. I did fi=
nd the "Arbitray SQL" article in DBIx's FAQ, but I don't even know how to g=
et to DBIx, if that's the right way, more specifically, =


Is it possible to get the database handle and run SQL directly as in DBI? I=
 read that from Schema I can get its storage, which is the db handle. But f=
rom a Controller, how do I get the schema object, or the db handle? If the =
DBIx is the correct way to go (which seems a lengthy way to "just" run a qu=
ery), do I do $c->model('Some::Model')->resultset....?

Thanks.

Z.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20080924/3e048=
c7f/attachment.htm