Re: [Dbix-class] Re: as_subselect_rs-delete bug?

2012-07-11 Thread fREW Schmidt
On Wed, Jul 11, 2012 at 12:38 AM, Toby Corkindale t...@dryft.net wrote: If it helps, the SQL I would have expected would be something like: DELETE FROM step USING stage WHERE step.stage_id = stage.id AND stage.name = 'Final' AND step.file_id = ? Although now

Re: [Dbix-class] Re: as_subselect_rs-delete bug?

2012-07-11 Thread Rob Kinyon
On Wed, Jul 11, 2012 at 6:11 AM, fREW Schmidt fri...@gmail.com wrote: I wrote a test that confirms it, but it actually has no where clause at all when I test it, which is even scarier. Before we go ahead confirming failures and making fixes, let's step back and discuss exactly what

[Dbix-class] The Definitive Guide to Catalyst ... p. 165 listing all users and their roles

2012-07-11 Thread Robyn Jonahs
Hi, I am working through the chapter in the book to learn about many to many relationship bridges. I have made it through the chapter up to the last part where it has us list all users and their roles. Page 165 in Chapter 6. This is the template file root/authusers/list.tt html head titleAll

Fwd: [Dbix-class] Re: as_subselect_rs-delete bug?

2012-07-11 Thread fREW Schmidt
Hey all, So after having a conversation with rob regarding as_subselect_rs, I think we should probably make -delete's and -update's from RS's like this die, at least by default. The reason being that -as_subselect_rs makes the rs be based on a non-introspectible sql string, a runtime view

[Dbix-class] many_to_many data access

2012-07-11 Thread Robyn Jonahs
Hi, I was trying to get some many_to_many data into a FormFU select element but I am having trouble. I think that it is time to ask the pros for help. I was staying similar to the online tutorial. In my add and edit sub routines, I have the following code (similar to the online tutorial)

[Dbix-class] many_to_many relationships in an app like the Catalyst tutorial with FormFU

2012-07-11 Thread Robyn Jonahs
(I don't think that this went through... sorry if it is a double post) Hi, I was trying to get some many_to_many data into a FormFU select element but I am having trouble. I think that it is time to ask the pros for help. I was staying similar to the online tutorial. In my add and edit sub

Re: [Dbix-class] Re: as_subselect_rs-delete bug?

2012-07-11 Thread Toby Corkindale
On 11 July 2012 23:35, Rob Kinyon rob.kin...@gmail.com wrote: On Wed, Jul 11, 2012 at 6:11 AM, fREW Schmidt fri...@gmail.com wrote: I wrote a test that confirms it, but it actually has no where clause at all when I test it, which is even scarier. Before we go ahead confirming failures and

Re: [Dbix-class] Re: as_subselect_rs-delete bug?

2012-07-11 Thread fREW Schmidt
On Wed, Jul 11, 2012 at 8:14 PM, Toby Corkindale t...@dryft.net wrote: On 11 July 2012 23:35, Rob Kinyon rob.kin...@gmail.com wrote: On Wed, Jul 11, 2012 at 6:11 AM, fREW Schmidt fri...@gmail.com wrote: I wrote a test that confirms it, but it actually has no where clause at all when I