[Dbix-class] Access to the database connection object

Matt S Trout dbix-class at trout.me.uk
Mon Jun 19 14:36:36 CEST 2006


brett gardner wrote:
> Is there anyway to get access to the database connection object used by 
> Storage to run a literal sql command.
> 
> I have an extremely complicated SQL query that involving a left join on 
> a sub query, and then multiple exists on sub queries that I cannot for 
> the life of me get to work using SQL::Abstract.

Hey, no fair! You never gave *us* a chance to get it work using SQL::Abstract :)

Send details of the query please. The answer *may* be "yeah ok, get the dbh" 
but even if it is for now I have a subselects branch brewing (hopefully for 
08) I can add this to the torture tests for.

-- 
      Matt S Trout       Offering custom development, consultancy and support
   Technical Director    contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

+ Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +



More information about the Dbix-class mailing list