[RDBO] $object-related_iterator

2007-07-06 Thread Michael Reece
i've skimmed the docs again and don't see it, but is there an easy way to generate _iterator methods for one-to-many relationships? --- michael reece :: software engineer :: [EMAIL PROTECTED] - This SF.net email

[RDBO] Rose::DB::Object::Column::Serialize?

2007-06-19 Thread Michael Reece
i am looking to freeze/thaw (or yaml, doesn't really matter..) unblessed data structures into a mysql column. has anyone already written a Column class that handles this transparently? --- michael reece :: software engineer :: [EMAIL PROTECTED

Re: [RDBO] augmenting ManyToMany default_auto_method_types

2007-06-11 Thread Michael Reece
On Jun 11, 2007, at 9:22 AM, John Siracusa wrote: On 6/11/07 12:14 PM, Michael Reece wrote: method_types = [ Rose::DB::Object::Metadata::Relationship::ManyToMany- default_auto_method_types(), 'count' ], }, Try: add_methods = [ 'count' ], fantastic, thanks. i am

Re: [RDBO] Namespace for 3rd-party RDBO modules

2007-05-23 Thread Michael Reece
On May 23, 2007, at 10:48 AM, John Siracusa wrote: On 5/23/07 12:53 PM, Jonathan Vanasco wrote: On May 23, 2007, at 9:36 AM, John Siracusa wrote: Does anyone have any good ideas for a namespace for module that augment or extend RDBO, but that are not part of the official RDBO

[RDBO] cascading Manager queries

2007-05-17 Thread Michael Reece
in Collection.pm, i have sub count_assets { my $self = shift; return CollectionAsset::Manager-get_collection_assets_count( require_objects = ['asset'], query = [ collection_id = $self- collection_id, @_ ], ); } sub

[RDBO] sort_by computed/aggregate column

2007-05-15 Thread Michael Reece
to get_objects_from_sql, but are there any other suggestions? --- michael reece :: software engineer :: [EMAIL PROTECTED] - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express

Re: [RDBO] sort_by computed/aggregate column

2007-05-15 Thread Michael Reece
On May 15, 2007, at 10:57 AM, Michael Reece wrote: here is what i tried: my $active = $self-get_groups( distinct= 1, select = [ 't1.*', 'COUNT(DISTINCT t3.asset_id) as temp_asset_count' ], multi_many_ok = 1, require_objects

Re: [RDBO] sort_by computed/aggregate column

2007-05-15 Thread Michael Reece
On May 15, 2007, at 11:32 AM, John Siracusa wrote: On 5/15/07, Michael Reece [EMAIL PROTECTED] wrote: but the generated query contains ORDER BY t1.temp_asset_count DESC and i can't seem to get the t1. not added to the ORDER BY clause. i know i can resort to get_objects_from_sql

[RDBO] re-using relationships with extra conditions

2007-05-11 Thread Michael Reece
://search.cpan.org/~tmtm/Class- DBI-v3.0.16/lib/Class/DBI.pm#Limiting ) 3. am i missing some other RDBO magic that would make this easier? --- michael reece :: software engineer :: [EMAIL PROTECTED] - This SF.net email is sponsored by DB2

Re: [RDBO] re-using relationships with extra conditions

2007-05-11 Thread Michael Reece
i forgot about that new feature! upgraded and tested, works great! On May 11, 2007, at 12:18 PM, John Siracusa wrote: On 5/11/07, Michael Reece [EMAIL PROTECTED] wrote: 1. is there a way to pull that off with 'one to one' type relationship so i can drop the subroutine? Not unless you add

[RDBO] auto_prime_caches, or common custom Metadata

2007-03-08 Thread Michael Reece
) to the base class (say, My::RDBO)? --- michael reece :: software engineer :: [EMAIL PROTECTED] - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share

Re: [RDBO] auto_prime_caches, or common custom Metadata

2007-03-08 Thread Michael Reece
? On Mar 8, 2007, at 4:15 PM, Michael Reece wrote: my $dbh isn't available at the time that mod_perl starts up. after a couple hours of debugging, i figured out that i need to pass auto_prime_caches = 0, to __PACKAGE__-meta-setup(...) however, i have a lot of classes. is there a way

Re: [RDBO] unexpected fetchrow_array in scalar context

2007-03-07 Thread Michael Reece
On Mar 7, 2007, at 12:17 PM, John Siracusa wrote: On 3/7/07, Michael Reece [EMAIL PROTECTED] wrote: this was causing me problems (always getting counts of 1) because my DBI abstraction layer re-implements fetchrow_array, only ever returning a list. Well there's your problem :) indeed

Re: [RDBO] inflating/deflating columns using mysql functions

2007-02-28 Thread Michael Reece
making some progress, but it appears select_sql doesn't get triggered when fetching lazy=1 columns. On Feb 28, 2007, at 1:47 PM, John Siracusa wrote: On 2/28/07, Michael Reece [EMAIL PROTECTED] wrote: is it possible to inflate/deflate columns using mysql functions via RDBO? If you're

Re: [RDBO] inflating/deflating columns using mysql functions

2007-02-28 Thread Michael Reece
from the object, which does not appear to be passed to these subs? On Feb 28, 2007, at 2:13 PM, Michael Reece wrote: this looks very promising! but what args are passed to select_sql, etc? that is, from RM::DB::Column::AESCrypt sub select_sql, how can i inspect the row/object to use its

Re: [RDBO] Last call before 0.761

2007-02-21 Thread Michael Reece
Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object --- michael reece :: software engineer :: [EMAIL PROTECTED] - Take Surveys. Earn Cash. Influence the Future of IT Join

[RDBO] incorrect column type for double precision?

2007-02-20 Thread Michael Reece
in a postgres table, i have a column lat| double precision the column definitions spit out from $class-meta- perl_class_definition interpreted this as lat= { type = 'scalar', length = 8 }, but RDBOM carps get_objects() - Vinq::RDBO::Image: Value for lat()

[RDBO] overloading Rose::DB-dbh

2007-02-08 Thread Michael Reece
trying every which way to make Rose::DB::Object(s) always use my custom global $dbh, package Vinq::RDB::MySQL; use base 'Rose::DB'; use Vinq::Globals qw( $dbh ); __PACKAGE__-use_private_registry; __PACKAGE__-register_db(driver = 'mysql'); sub dbh { $dbh } sub driver {

[RDBO] timezone for magical 'now' value in datetime columns

2007-02-08 Thread Michael Reece
objects created by Rose::DB::Object? --- michael reece :: software engineer :: [EMAIL PROTECTED] - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology

[RDBO] auto_initialize from custom $dbh

2007-02-06 Thread Michael Reece
i am getting the following error when trying to auto_initialize a table class from a custom $dbh: Could not auto-retrieve primary key columns for class My::Junk - no primary key info found for catalog '' schema '' table 'junk' the table is very simple: mysql create table junk ( junk_id

Re: [RDBO] Rose::DB::Object thingy like class::dbi's set_sql?

2006-11-28 Thread Michael Reece
___ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object --- michael reece :: software engineer :: [EMAIL PROTECTED] - Take