[RDBO] delete_prices()

2007-03-09 Thread Peter Karman
When I define a relationship in my (mythical) Product class called 'prices' (as per the Tutorial), I get all kinds of magic methods for free. So in addition to the usual: $product-delete; $product-save; I can also do: $product-prices($price_id); # replace all prices with

Re: [RDBO] related objects omitted/restricted by Rose::DB::Object::Manager during query

2007-03-09 Thread John Siracusa
On 3/9/07, Jud [EMAIL PROTECTED] wrote: my $result = My::Project::Manager-get_projects ( query = [ 'employees.name' = 'jud', ], with_objects = [ 'employees' ], ); I get the expected results (1 item in the test case). However, when I look at the list of employees for

Re: [RDBO] delete_prices()

2007-03-09 Thread Jonathan Vanasco
On Mar 9, 2007, at 10:01 AM, Peter Karman wrote: But I don't get this magical method: $product-delete_prices($price_id); The only delete_ function I use is the manager method delete_ http://search.cpan.org/~jsiracusa/Rose-DB-Object-0.763/lib/Rose/DB/

Re: [RDBO] delete_prices()

2007-03-09 Thread John Siracusa
On 3/9/07, Peter Karman [EMAIL PROTECTED] wrote: But I don't get this magical method: $product-delete_prices($price_id); which would be equivalent to: sub delete_prices { my $self = shift;# Product my $price_id = shift; my @keep = grep { $_-id ne $price_id }

[RDBO] on_set trigger bug

2007-03-09 Thread Cory Bennett
I think this is a bug anyway, but it could be a usage error. When using an on_set trigger, the return value from the setter is always an empty-string, but the set seems to still be working. In my attached test example I have an object with a column data, and a column more_data, the more_data

Re: [RDBO] delete_prices()

2007-03-09 Thread Peter Karman
Jonathan Vanasco scribbled on 3/9/07 9:35 AM: On Mar 9, 2007, at 10:01 AM, Peter Karman wrote: But I don't get this magical method: $product-delete_prices($price_id); The only delete_ function I use is the manager method delete_

Re: [RDBO] on_set trigger bug

2007-03-09 Thread John Siracusa
On 3/9/07, Cory Bennett [EMAIL PROTECTED] wrote: I think this is a bug anyway, but it could be a usage error. When using an on_set trigger, the return value from the setter is always an empty-string, but the set seems to still be working. Yep, it was a bug. Fixed in SVN. Thanks for the

Re: [RDBO] delete_prices()

2007-03-09 Thread Peter Karman
John Siracusa scribbled on 3/9/07 9:45 AM: On 3/9/07, Peter Karman [EMAIL PROTECTED] wrote: But I don't get this magical method: $product-delete_prices($price_id); which would be equivalent to: sub delete_prices { my $self = shift;# Product my $price_id = shift;

Re: [RDBO] related objects omitted/restricted by Rose::DB::Object::Manager during query

2007-03-09 Thread John Siracusa
On 3/9/07, Jud Dagnall [EMAIL PROTECTED] wrote: I would expect that regardless of how the query was constructed, any results (projects) returned would be accurate, meaning that they would reflect the the state of things in the database at the time that the query was executed. But what you're

Re: [RDBO] related objects omitted/restricted by Rose::DB::Object::Manager during query

2007-03-09 Thread Jud Dagnall
Hey John- Thanks for the quick and detailed reply. See my comments inline: On 09/03/07 10:30 -0500, John Siracusa [EMAIL PROTECTED] wrote: What you seem to want is all projects with all their employees, where at least one of the employees' names is 'jud'. Or, in more SQL-like parlance, all

Re: [RDBO] [bug] Loader (for Postgresql?) picks up bad sequence names

2007-03-09 Thread John Siracusa
On 3/4/07, Randal L. Schwartz merlyn@stonehenge.com wrote: After running Loader, I got: sequence = 'foo_bar' but when it tried to use that to insert a record, Pg barfed. Fix was to manually edit all Loader-generated files to be: sequence = 'foo_bar' Can you post a test case for