Re: [Dbix-class] DBIx::Class::Relationship::CascadeActions::delete(): Not in database

2013-03-27 Thread David Cantrell
On Wed, Mar 27, 2013 at 06:02:27AM +1100, Peter Rabbitson wrote: > From https://metacpan.org/module/DBIx::Class::Row#delete > :: If you delete an object within a txn_do() (see "txn_do" in > :: DBIx::Class::Storage) and the transaction subsequently fails, the > :: result object will remain marked

Re: [Dbix-class] how to empty a Table? when there is no primary key

2013-03-27 Thread David Cantrell
On Wed, Mar 27, 2013 at 06:12:49AM +1100, Peter Rabbitson wrote: > On Mon, Mar 25, 2013 at 03:57:45PM +, David Cantrell wrote: > > I've always thought that this is something that should be handled by the > > database, not by DBIx::Class - or at least that it should be something > > that you hav

Re: [Dbix-class] DBIx::Class::Relationship::CascadeActions::delete(): Not in database

2013-03-27 Thread Peter Rabbitson
On Wed, Mar 27, 2013 at 12:30:03PM +, David Cantrell wrote: > > Eeuuww! > > I would thunk that in_storage should be "rolled back" too. > How would you implement that? (as in how would the perl logic actually look) ___ List: http://lists.scsys.co

Re: [Dbix-class] how to empty a Table? when there is no primary key

2013-03-27 Thread demerphq
On 26 March 2013 20:12, Peter Rabbitson wrote: > On Mon, Mar 25, 2013 at 03:57:45PM +, David Cantrell wrote: >> On Mon, Mar 25, 2013 at 11:58:31AM +1300, Paul Findlay wrote: >> > > I tried to use delete_all, but there is no primary key in the table so >> > > it failed. what else can i do? >>

Re: [Dbix-class] how to empty a Table? when there is no primary key

2013-03-27 Thread demerphq
On 27 March 2013 13:33, David Cantrell wrote: > On Wed, Mar 27, 2013 at 06:12:49AM +1100, Peter Rabbitson wrote: >> On Mon, Mar 25, 2013 at 03:57:45PM +, David Cantrell wrote: >> > I've always thought that this is something that should be handled by the >> > database, not by DBIx::Class - or a

Re: [Dbix-class] DBIx::Class::Relationship::CascadeActions::delete(): Not in database

2013-03-27 Thread David Cantrell
On Wed, Mar 27, 2013 at 11:49:53PM +1100, Peter Rabbitson wrote: > On Wed, Mar 27, 2013 at 12:30:03PM +, David Cantrell wrote: > > Eeuuww! > > I would thunk that in_storage should be "rolled back" too. > How would you implement that? (as in how would the perl logic actually > look) in the cod

Re: [Dbix-class] DBIx::Class::Relationship::CascadeActions::delete(): Not in database

2013-03-27 Thread Rob Kinyon
On Wed, Mar 27, 2013 at 6:54 AM, David Cantrell wrote: > On Wed, Mar 27, 2013 at 11:49:53PM +1100, Peter Rabbitson wrote: > > On Wed, Mar 27, 2013 at 12:30:03PM +, David Cantrell wrote: > > > Eeuuww! > > > I would thunk that in_storage should be "rolled back" too. > > How would you implement t

Re: [Dbix-class] DBIx::Class::Relationship::CascadeActions::delete(): Not in database

2013-03-27 Thread Peter Rabbitson
On Wed, Mar 27, 2013 at 01:54:00PM +, David Cantrell wrote: > On Wed, Mar 27, 2013 at 11:49:53PM +1100, Peter Rabbitson wrote: > > On Wed, Mar 27, 2013 at 12:30:03PM +, David Cantrell wrote: > > > Eeuuww! > > > I would thunk that in_storage should be "rolled back" too. > > How would you imp

Re: [Dbix-class] Sybase users needed to test a DBIC::Storage::Sybase::ASE change

2013-03-27 Thread Matthew Phillips
Hey Riba, as an update to this: I've got sybase up and running on my VM, but can't get the damn DBD compiled against it. I'll keep you posted if I figure it out. Starting to see what you meant by 'massive bitch'. Cheers, Matt On Sat, Mar 23, 2013 at 10:15 AM, Peter Rabbitson wrote: > Hi! > > Cu

Re: [Dbix-class] Sybase users needed to test a DBIC::Storage::Sybase::ASE change

2013-03-27 Thread Brian Fraser
On Sat, Mar 23, 2013 at 11:15 AM, Peter Rabbitson wrote: > Hi! > > Currently the dev team does not have an easy access to a Sybase ASE > server (properly installing and configuring one is a massive bitch). If Gendered language, man. I know you didn't mean it as an insult to anyone, but it costs u