[RDBO] Rose::DB::Object - load() should not depend upon sth-rows()

2007-08-08 Thread Philip Dye
load() should not depend on the value of $sth-rows() being greater than zero after a successful fetch() given the inconsistent behavior described in the DBI documentation: rows http://search.cpan.org/%7Etimb/DBI/DBI.pm#___top $rv = $sth-rows; Returns the number of rows affected by

[RDBO] Extending Rose::DB::Object::Helpers

2007-08-08 Thread Kevin McGrath
I was messing around with extending Rose::DB::Object::Helpers trying to add a column_values_as_xml function. The problem I ran into involved adding my new function to the 'all' export tag. To add my new function I had to create my own export_tags function that listed all of the current functions

Re: [RDBO] Extending Rose::DB::Object::Helpers

2007-08-08 Thread Jonathan Vanasco
Kevin- I usually get the effect you want in a slightly different way a) I have Oasis::Model::Asset::Object::Helpers b) but I might also have Oasis::Model::Asset::Object::Helpers_SpecifcNameHere c) when i need a function in a rose object, i just stuff

Re: [RDBO] help specifying a default datetime with SQLite and RDBO::Loader

2007-08-08 Thread John Siracusa
On 8/7/07 5:12 PM, George Hartzell wrote: If I change Rose::DB::SQLite::validate_datetime_keyword so that it'll accept 'current_timestamp' Yeah, I should do that... then the value gets inserted literally into the table. it probably also needs to be inlined (i.e., unquoted) I'd like to be

Re: [RDBO] Rose::DB::Object - load() should not depend upon sth-rows()

2007-08-08 Thread John Siracusa
On 8/8/07 10:55 AM, Philip Dye wrote: $rv = $sth-rows; Returns the number of rows affected by the last row affecting command, or -1 if the number of rows is not known or not available. In SVN, I changed in from: if($rows 0) to if($rows 0 || $rows == -1) which