[Dbix-class] sqlt bug in parser?

2007-12-02 Thread John Goulah
It seems that if you have a primary key that is a foreign key to another table, the parser is not adding the constraint for the belongs_to rel. It seems this happens in lib/SQL/Translator/Parser/DBIx/Class.pm at about line 154 on the compare_relationship_keys call. I'm not sure what the proper fi

Re: [Dbix-class] calling delete in a resultset with a join

2007-12-02 Thread Jonas Alves
On Dec 2, 2007 1:51 PM, Zbigniew Lukasiak <[EMAIL PROTECTED]> wrote: > Hi Jonas, > > On Nov 29, 2007 11:35 AM, Jonas Alves <[EMAIL PROTECTED]> wrote: > > Hello all, > > > > I', triyng to call delete in a resultset with a join. like this: > > > > $schema->resultset('Movie')->search( > >

Re: [Dbix-class] calling delete in a resultset with a join

2007-12-02 Thread Zbigniew Lukasiak
Hi Jonas, On Nov 29, 2007 11:35 AM, Jonas Alves <[EMAIL PROTECTED]> wrote: > Hello all, > > I', triyng to call delete in a resultset with a join. like this: > > $schema->resultset('Movie')->search( > { 'category.update_flag' => 'old' }, > { join => 'category' } > )->delete;

[Dbix-class] [solved] Re: Error on updating a row in a rewritten view doesn't work

2007-12-02 Thread Mario Minati
On Sunday 02 December 2007 00:17:52 you wrote: > I have got a problem updating a view ;-) > > The class was working smoothly as long as I used the table ('company') > itself to crud the data. > > Now I switched to a view with the following rules: > > CREATE OR REPLACE RULE company__view__ins_instea

Re: [Dbix-class] autosetup of dbic classes from master dbic class possible?

2007-12-02 Thread Mario Minati
On Sunday 02 December 2007 01:19:05 Jess Robinson wrote: > On Thu, 29 Nov 2007, Mario Minati wrote: > > Hello, > > > > I'm developing an intranet application with Catalyst an postgresql. As > > deleted (and old) records needed to be accesible I created the following > > db structure: > > > > table: