[Dbix-class] Transaction depth problem

Hello there. When I run the attached script the call to txn_do() seems to create a transaction depth of two, so the insert is never actually committed. I see the insert in the MySQL log and the auto increment value of the primary key is increased, but the row of data is never actually inserted. I

Re: [Dbix-class] Updating foreign key does not reload related object

On Thu, Aug 02, 2007 at 09:00:19AM +1000, brett gardner wrote: > Matt S Trout wrote: > >On Wed, Aug 01, 2007 at 01:00:03PM +1000, brett gardner wrote: > > > >>I have a row object which has a field "venue_id" which is a foreign key > >>used in a belongs_to relationship "venue". > >> > >>When I do

Re: [Dbix-class] Transaction depth problem

On 8/3/07, Dave Cardwell <[EMAIL PROTECTED]> wrote: > Hello there. > > When I run the attached script the call to txn_do() seems to create a > transaction depth of two, so the insert is never actually committed. I > see the insert in the MySQL log and the auto increment value of the > primary key i

[Dbix-class] executing pl/sql block in dbic

How should I handle executing a pl/sql-block in dbic? Actually I think there should be 2 answers to this question: 1. If you just want to execute an arbitrary block of pl/sql, you should be able to call it from an DBIx::Class::Schema instance. 2. If you wanted to call a stored procedure, say