[RDBO] meta / setup design

2007-11-16 Thread Jonathan Vanasco
John- Would you mind elaborating on how __PACKAGE__-meta and -setup work? I was working on new ways to automagically call/include my rose objects ( ie: include an entire perl namespace at once, not each individual file ) and hijack the setup registry to push some information elsewhere.

Re: [RDBO] Wanted: Perl programmers (Boston, MA)

2007-11-16 Thread Jonathan Vanasco
On Nov 14, 2007, at 3:56 PM, John Siracusa wrote: On Nov 14, 2007 2:59 PM, Darren Duncan [EMAIL PROTECTED] wrote: Or I see something about a company that does online gambling. That's the one :) This position requires does require occasionally lifting up to 20 (twenty) pounds I don't

[RDBO] Install Error

2007-10-13 Thread Jonathan Vanasco
Anyone else get this when updating? t/setup...NOK 3/4 # Failed test 'ROSEDBRC 2' # in t/setup.t at line 22. # got: 'localhost' # expected: 'othervalue' # Looks like you failed 1 test of 4. t/setup...dubious Test returned status 1 (wstat

[RDBO] has_loaded_related issue

2007-08-11 Thread Jonathan Vanasco
using .765 has_loaded_related ( helpers ) keeps returning false, when the related item is loaded via a manager with_objects call ( and i know its via a data::dumper profile ) $obj= $class-load( with_objects=['subclass'] ); print this always returns false .

Re: [RDBO] has_loaded_related issue

2007-08-11 Thread Jonathan Vanasco
for writing with_objects instead of with. it was correct on my code, just not on the posting. // Jonathan Vanasco Founder/President - FindMeOn Fonder/CEO - RoadSound

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] feature request - is not

2007-07-09 Thread Jonathan Vanasco
On Jul 9, 2007, at 11:34 AM, John Siracusa wrote: I've added is/is_not operators to QueryBuilder in SVN. Give them a spin and let me know if they do what you want. awesome. will test tonight can't wait to rid the 'clauses' sections from my managers. // Jonathan Vanasco

Re: [RDBO] math::bigint pg

2007-07-09 Thread Jonathan Vanasco
will print the current state of the obj to STDERR. comes up as a 0 every time. looking at the pg table , it inserts a 0 as well, not an undef. i must be doing something blatantly wrong here -- and someone will notice it just looking at the class setup. i hope so. // Jonathan Vanasco

[RDBO] math::bigint pg

2007-07-08 Thread Jonathan Vanasco
, and it is not a 'not_null' col suggestions? - Jonathan Vanasco - findmeon.com / RoadSound.com Sent from my iPhone - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control

Re: [RDBO] on the fly fields

2007-06-24 Thread Jonathan Vanasco
would be: my $names= myapp::names::manager-load_names(); foreach my $name ( @{$names-blessed_class_sort_method() } ) { #do something. } // Jonathan Vanasco

Re: [RDBO] Separate Read and Write Database Connections

2007-06-24 Thread Jonathan Vanasco
On Jun 20, 2007, at 12:16 AM, David Lloyd wrote: Is it possible to have separate read and write database connections in Rose::DB::Object? For example, I might have read to: read.db.com ...and...write to: write.db.com ...is it possible to get any updates/deletes and inserts (and

Re: [RDBO] Code for Generating RDBO's for All Tables

2007-06-15 Thread Jonathan Vanasco
On Jun 15, 2007, at 6:40 PM, Jeffrey Horn wrote: I'm wondering if there's any code out there that will generate Rose::DB::Object's for all tables in a database. I have my own makeshift version which will do it for a given table, and the loop to simply iterate through tables isn't bad.

Re: [RDBO] Code for Generating RDBO's for All Tables

2007-06-15 Thread Jonathan Vanasco
On Jun 16, 2007, at 1:11 AM, Jeffrey Horn wrote: Aw shucks! You guys think of everything! :) Thanks! This is exactly what I was looking for! -- Jeff Horn i think thats pretty much straight from the docs i just converted a micro-app to rose last night, and had that handy ;)

Re: [RDBO] wishlist - better error message for incompatible type situation

2007-06-06 Thread Jonathan Vanasco
On Jun 5, 2007, at 8:36 AM, John Siracusa wrote: I made some changes to the error messages in SVN, but I could make them better if you could give me a concrete example of a call that produces an error for you, and what you'd like the error to be instead. Again, I think I need to see an

[RDBO] getter/setters for relationships

2007-06-04 Thread Jonathan Vanasco
= b-new(); $a-b( $b ); right now i'm using the relationship name, because it works. but thats not the best way. do column_accessor_value_pairs/column_mutator_value_pairs work for relation names too? can we have a seperate relation function ? // Jonathan Vanasco

Re: [RDBO] getter/setters for relationships

2007-06-04 Thread Jonathan Vanasco
On Jun 4, 2007, at 12:35 PM, John Siracusa wrote: Yes, and it works the same way as for columns. Like columns, relationships and foreign keys have N named method types created on their behalf. Examples of method type names are get, get_set, get_set_on_save, find, count, etc. There are

[RDBO] wishlist - better error message for incompatible type situation

2007-06-04 Thread Jonathan Vanasco
. in order to trace, i find myself opening 1 file to see which function i'm calling, then i get to open the manager file it would be even neater if rose could just infer/guess something or bypass this -- since rose uses bind variables, there shouldn't be any trickery needed. // Jonathan

Re: [RDBO] Streamlining documentation

2007-06-03 Thread Jonathan Vanasco
sorry this took so long to respond -- been too busy on the business side of work, little time for code. On May 18, 2007, at 2:21 PM, John Siracusa wrote: I think it's pretty clear given that the table definition is right above it, and contains: UNIQUE(product_id, region) ok. that

Re: [RDBO] bug - similar names kill with_objects calls

2007-06-01 Thread Jonathan Vanasco
code and pglog -- and it gave every indication rose wasn't. Then other sections started failing with random code and modules. I have no idea WTF happened. // Jonathan Vanasco

[RDBO] bug - similar names kill with_objects calls

2007-05-31 Thread Jonathan Vanasco
a lookup hash to map t1_available_api_application_keys to the t1 object and column when creating objects // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | SyndiClick.com

Re: [RDBO] bug - similar names kill with_objects calls

2007-05-31 Thread Jonathan Vanasco
please disregard the last question. additional troubleshooting showed that , somehow , perl on that dev box is completely corrupted. reinstalling *everything* seems to have fixed it after we tested the same app on another server.

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

2007-05-23 Thread Jonathan Vanasco
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 distribution? The first thing that springs to my mind is: Rose::DBx::* At first I really liked

Re: [RDBO] Streamlining documentation

2007-05-18 Thread Jonathan Vanasco
defined names. thats my documentation gripe of the week :) // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | SyndiClick.com

Re: [RDBO] cascading Manager queries

2007-05-17 Thread Jonathan Vanasco
On May 17, 2007, at 3:12 PM, Michael Reece wrote: here is a bit of ugliness that hints at what i am after: I think i do some similar stuff, so I'll give my advice -- which you may be better off to not take ;) I never use 'make manager methods'. i started it as a memory saver because i

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

2007-05-11 Thread Jonathan Vanasco
at the manager class ? http://search.cpan.org/~jsiracusa/Rose-DB-Object-0.764/lib/Rose/DB/ Object/Manager.pm i think that should handle everything you need. // Jonathan Vanasco

[RDBO] feedback? related_index

2007-05-05 Thread Jonathan Vanasco
I'm making quite a bit of custom rose functions for my projects , and looking for feedback on some that i think would be useful if rolled back into Rose::DB::Helpers the newest one is related_index related_index takes a rose object and creates an internal hash to quickly access specific

Re: [RDBO] ANNOUNCE: Rose::DB::Object 0.764 released

2007-05-04 Thread Jonathan Vanasco
, or just suggestions. its even longer than you think: at the least, you missed documenting the strip() feature in the changelog! // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | SyndiClick.com

Re: [RDBO] Datatype generator

2007-05-02 Thread Jonathan Vanasco
On May 2, 2007, at 1:54 PM, John Siracusa wrote: You can do this already, more or less, by making your own My::EmailColumn class based on Rose::DB::Object::Metadata::Column, then mapping that class to a type name using meta-column_type_class(email = 'My::EmailColumn'). Then, in your class

Re: [RDBO] Release soon

2007-05-01 Thread Jonathan Vanasco
On May 1, 2007, at 3:08 PM, Derek Watson wrote: I feel like I'm repeating work here -- I've got a similar set of functions that serialize and restore trees of objects, only I'm doing this in a very specific way, keeping only what I want from specific classes (not reusable). What are the

Re: [RDBO] Release soon

2007-04-30 Thread Jonathan Vanasco
On Apr 30, 2007, at 4:37 PM, John Siracusa wrote: Even though there are a bunch of things on my short-term list that I haven't gotten to, the change list is already quite large and I want to cut a release soon (it will be 0.764). Is there any feature that I previously mentioned I'd get to

[RDBO] feature request - is not

2007-04-30 Thread Jonathan Vanasco
i'd like to see an is not operator something like: '!NAME' = undef# COLUMN IS NOT NULL under postgres, booleans behave as such: example table create table test ( id integer not null , is_selected boolean ); insert into test ( id , is_selected ) values ( 1 , NULL

Re: [RDBO] Delays

2007-04-27 Thread Jonathan Vanasco
On Apr 27, 2007, at 10:25 AM, John Siracusa wrote: Sorry for any delays in responding to RDBO issues or email. We just had a baby (our second) and things will likely be a bit hectic here for a while... :) Congrats! // Jonathan Vanasco

Re: [RDBO] Rose internals question

2007-04-26 Thread Jonathan Vanasco
On Apr 26, 2007, at 6:18 PM, Jonathan Vanasco wrote: e) when restoring an object, I'm trying to figure out how stuff the foreign keys and relationships. i can bring them up as new objects just fine, but there aren't really any rose methods for stuffing one into an object

Re: [RDBO] (wishlist) Distributed Key Support

2007-04-23 Thread Jonathan Vanasco
My only concern was how portable the solution would be. Theoretically, Rose could add enough value to make it work regardless of the database. For example, right now, our version of MySQL silently truncates values not in an enum list and add the empty string into enum fields. Rose

Re: [RDBO] Scratchpad Space in RDBOs???

2007-04-20 Thread Jonathan Vanasco
On Apr 20, 2007, at 11:06 AM, John Siracusa wrote: On 4/19/07, Jonathan Vanasco [EMAIL PROTECTED] wrote: Would it be terribly difficult to port: Rose::DB::Object::MixIn into Rose::Object::MixIn and then just having Rose::DB::Object::MixIn be a subclass of Rose::Object

Re: [RDBO] object caching functionality

2007-04-18 Thread Jonathan Vanasco
On Apr 18, 2007, at 10:22 AM, John Siracusa wrote: On 4/17/07, Jonathan Vanasco [EMAIL PROTECTED] wrote: Though that can be handled using a strip helper alone too -- we'd just need an unstrip() function that builds back in a db object and metadata I don't think that'd be necessary

Re: [RDBO] object caching functionality

2007-04-18 Thread Jonathan Vanasco
with regex hell for now // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | SyndiClick.com

[RDBO] 4 key map table advice sought

2007-04-16 Thread Jonathan Vanasco
I have a 4 key map table , and its confusing me how to do this in rose. Rose Tutorial: Products id , name Colors id , name Product2Color product_id , color_id My Setup Adds in a 'user' fkey + time to track the assignment of

Re: [RDBO] Read-only objects

2007-04-16 Thread Jonathan Vanasco
obj and just change the table name in the package meta. Which would give you a RODB obj that will always fail on DB writes. Granted, that only works on DBs that support VIEW // Jonathan Vanasco

[RDBO] object caching functionality

2007-04-16 Thread Jonathan Vanasco
I'm going to need to cache my objects into memcached , and looking for options. the quickdirty way would be to just use storable. i think cache::memcached should be able to bring back the entire object structure -- including nested objects has anyone done this? pros / cons ? my other

[RDBO] using functions

2007-04-13 Thread Jonathan Vanasco
is there a way to get Rose to search based on functions? ie: bad SELECT * FROM useraccount WHERE email = ? good SELECT * FROM useraccount WHERE lower(email) = lower(?) the second query will be optimized by the postgres planner to search on this

Re: [RDBO] Possible to use load() to get a exclusive lock???

2007-04-10 Thread Jonathan Vanasco
use a function or stored procedure to emulate that better? also, if you're worried about concurrency, why not just stuff your rose objects with a dbh that is in a transaction and handle stuff that way ? // Jonathan Vanasco

Re: [RDBO] Read-only objects

2007-04-06 Thread Jonathan Vanasco
On Apr 6, 2007, at 10:01 AM, John Siracusa wrote: On 4/5/07, Jonathan Vanasco [EMAIL PROTECTED] wrote: Any chance of these features being pushed back into rose? The first thing you're likely to see is support for triggers on save, insert, update, and delete because overriding some of those

Re: [RDBO] Read-only objects

2007-04-06 Thread Jonathan Vanasco
to have my cake and eat it too. // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | SyndiClick.com

Re: [RDBO] Read-only objects

2007-04-04 Thread Jonathan Vanasco
call me lazy-- I just use a bad db handle for all things rose, then have a custom method that pulls a read-only or read/write handle from a db factory as needed. ie, they'll always fail on save, insert, update because they don't have the db permissions

Re: [RDBO] Loader: request and doc change

2007-04-02 Thread Jonathan Vanasco
the shell manager classes created for all my modules, but i don't use the default manager methods . i fill that class with custom calls as needed. I just regex it out in 5 seconds, but I think thats marginally useful to others. perhaps not. // Jonathan Vanasco

[RDBO] loader dies if pg table has unique index when make_modules is called

2007-04-01 Thread Jonathan Vanasco
Lots of messages like this: Could not auto-retrieve unique keys for class X::RoseDB::Object::X - No columns found for relation id 174592, column numbers 0 at /Library/Perl/5.8.6/Rose/DB/Object/ Metadata/Auto/Pg.pm line 111. at /Library/Perl/5.8.6/Rose/DB/Object/Loader.pm line 889

Re: [RDBO] loader dies if pg table has unique index when make_modules is called

2007-04-01 Thread Jonathan Vanasco
On Apr 2, 2007, at 1:31 AM, Jonathan Vanasco wrote: Lots of messages like this: Could not auto-retrieve unique keys for class X::RoseDB::Object::X - No columns found for relation id 174592, column numbers 0 at /Library/Perl/5.8.6/Rose/DB/Object/ Metadata/Auto/Pg.pm line 111

[RDBO] Loader: request and doc change

2007-04-01 Thread Jonathan Vanasco
doc change: with_managers seems to default to true , it should be listed as such feature request: it would be nice if a variation of with_managers could be called , that did not create: __PACKAGE__-make_manager_methods('useraccount');

Re: [RDBO] Best way to do multiple calls to database

2007-03-29 Thread Jonathan Vanasco
mod_perl, it might make sense to play around with the cache version of rose objects. rose is *really nice* under mod perl. it sucks a ton of memory for all the pregeneration of sql , but if flys s fast once its running. John addressed the rest. // Jonathan Vanasco

Re: [RDBO] Best way to do multiple calls to database

2007-03-29 Thread Jonathan Vanasco
On Mar 29, 2007, at 4:07 PM, James Masters wrote: So when you say startup, does this mean upon Apache startup or upon your script startup? I can see that if it's in Apache's memory before a script even runs, that would be hugely performance enhancing. apache startup. there's no point on

Re: [RDBO] Best way to do multiple calls to database

2007-03-27 Thread Jonathan Vanasco
situation or have extremely complex joins. // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple Web Personality Disorder | Web Identity Management and 3D Social Networking

Re: [RDBO] Sequence Support

2007-03-20 Thread Jonathan Vanasco
the nextval later aborts. This means that aborted transactions may leave unused holes in the sequence of assigned values. setval operations are never rolled back, either. // Jonathan Vanasco

Re: [RDBO] Sequence Support

2007-03-20 Thread Jonathan Vanasco
On Mar 20, 2007, at 7:02 PM, Jud wrote: On 20/03/07 18:57 -0400, Jonathan Vanasco [EMAIL PROTECTED] wrote: ok. its on my list right after the debugger module :) If you're actually putting together a debug module, I'd put in a request for a simple way to turn on all debugging in Rose

Re: [RDBO] Debian Rose

2007-03-19 Thread Jonathan Vanasco
___ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object // Jonathan Vanasco

Re: [RDBO] Transactions, ACID etc.

2007-03-16 Thread Jonathan Vanasco
perfect sense: transactions are a part of application logic , not orms logic // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | SyndiClick.com

Re: [RDBO] Transactions, ACID etc.

2007-03-16 Thread Jonathan Vanasco
from a factory class that my entire application uses. As needed, I have a function that rose reset the db with a write dbh from the factory. it works exceedingly well for a clustered db environment. // Jonathan Vanasco

Re: [RDBO] Transactions, ACID etc.

2007-03-16 Thread Jonathan Vanasco
On Mar 16, 2007, at 1:12 PM, Randal L. Schwartz wrote: package My::RDBO; use base Rose::DB::Object; use strict; sub init_db { our $cached_db ||= do { require My::RDB; # my Rose::DB subclass My::RDB-new; } } 1; mine relies heavily

Re: [RDBO] delete_prices()

2007-03-09 Thread Jonathan Vanasco
the tables, classes, and columns in accordance with the expectations of the convention manager.) The resulting vendor() and delete_vendor() methods behave exactly the same as the methods created on behalf of the foreign key definition. // Jonathan Vanasco

Re: [RDBO] safe namespace for user data in rose objects ?

2007-03-01 Thread Jonathan Vanasco
. // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | SyndiClick.com | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple Web

Re: [RDBO] Customising R:D:O:Loader generated methods

2007-02-21 Thread Jonathan Vanasco
never happen though ! ) , everything that hits rose is consolidated in the DataObject tree all the hooks , pre processing / whatever can also happen within update modules in DataObject its not a better solution, but it works :) // Jonathan Vanasco

Re: [RDBO] New Manager argument forms

2007-02-18 Thread Jonathan Vanasco
On Feb 17, 2007, at 10:17 PM, Danial Pearce wrote: Why would you think that? The first example is passing a hash, the second is passing a hashref. The bulk of CPAN modules i've been using lately have been taking a hash or hashref as input equally. and i thought rose did something

Re: [RDBO] New Manager argument forms

2007-02-16 Thread Jonathan Vanasco
] ) get_query( [ a = 1, b = 2 ] ) // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | SyndiClick.com

[RDBO] some db parameter questions

2007-02-08 Thread Jonathan Vanasco
db 'operational' data and metadata seems to be nicely stashed away to 'private' styled names, while column names are plaintext. thanks, // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | SyndiClick.com

Re: [RDBO] some db parameter questions

2007-02-08 Thread Jonathan Vanasco
, and noticed that all of the rose stuff had some sort of prefix -- except db // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | SyndiClick.com

Re: [RDBO] some db parameter questions

2007-02-08 Thread Jonathan Vanasco
the var is this: sub db ... $self-{'db'} = $new_db; $self-{'dbh'} = undef; ... // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | SyndiClick.com

Re: [RDBO] some db parameter questions

2007-02-08 Thread Jonathan Vanasco
. they do nothing but consume memory :) // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | SyndiClick.com

Re: [RDBO] some db parameter questions

2007-02-08 Thread Jonathan Vanasco
On Feb 8, 2007, at 5:58 PM, John Siracusa wrote: On 2/8/07 5:54 PM, Jonathan Vanasco wrote: Er, that's a it already is a get/set method in the latest version. http://search.cpan.org/~jsiracusa/Rose-DB-Object/lib/Rose/DB/ Object.pm#dbh Oh, *that* dbh :) That's some old, probably now

Re: [RDBO] overloading Rose::DB-dbh

2007-02-08 Thread Jonathan Vanasco
::Object instead of Rose::DB::Object. My system is different, I keep a 'bad' dbh by default and stuff a valid dbh manually after i get a read/write/config dbh from a factory class. // Jonathan Vanasco

[RDBO] idea for new object manager functionality

2007-02-08 Thread Jonathan Vanasco
it could be pretty neat. opinions ? // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple Web Personality Disorder | Web Identity Management and 3D Social Networking

Re: [RDBO] Additional where criteria in left outer joins

2007-02-07 Thread Jonathan Vanasco
not as nice as having more control, but it works well. // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | SyndiClick.com

Re: [RDBO] New find method type for one-to-many relationships

2007-01-30 Thread Jonathan Vanasco
On Jan 30, 2007, at 7:48 PM, John Siracusa wrote: Given that this method will always be called with arguments, and that those arguments can change per-call, how can there be any expectation that the results will be saved internally? How would such a feature even work? it wouldn't -- i

Re: [RDBO] hi Rose::DB developers, quick design question (if i may...)

2007-01-18 Thread Jonathan Vanasco
! // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple Web Personality Disorder | Web Identity Management and 3D Social Networking

Re: [RDBO] hi Rose::DB developers, quick design question (if i may...)

2007-01-18 Thread Jonathan Vanasco
On Jan 19, 2007, at 12:26 AM, Danial Pearce wrote: On 1/19/07, Jonathan Vanasco [EMAIL PROTECTED] wrote: VIEWs are great, because they work out essentially as tables -- so you can create ROSE DB objects for selecting (though not inserting) Sure you can do inserting. You can either do

Re: [RDBO] Unexpected column defaults in MySQL

2007-01-17 Thread Jonathan Vanasco
actually do what you expect it to when turned on. // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple Web Personality Disorder | Web Identity Management and 3D Social Networking

Re: [RDBO] hi Rose::DB developers, quick design question (if i may...)

2007-01-17 Thread Jonathan Vanasco
the ManyToMany relationship http://search.cpan.org/~jsiracusa/Rose-DB-Object/lib/Rose/DB/Object/ Metadata/Relationship/ManyToMany.pm // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple

Re: [RDBO] ANNOUNCE: Rose::DB::Object 0.759 released

2007-01-16 Thread Jonathan Vanasco
is this explained in more detail? Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple Web Personality Disorder | Web Identity Management and 3D Social Networking

Re: [RDBO] Known Issues Between RDBO, Apache2::Reload, and ModPerl::PerlRun?

2007-01-13 Thread Jonathan Vanasco
is __PACKAGE__-meta-initialize( replace_existing= 1 ); in each of your rdbo classes, after everything has been described, *might* help. without an actual error message, its a wild stab. // Jonathan Vanasco

[RDBO] insignificant error/behaviour found

2007-01-11 Thread Jonathan Vanasco
is wrong. // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple Web Personality Disorder | Web Identity Management and 3D Social Networking

[RDBO] helper function request

2007-01-11 Thread Jonathan Vanasco
| db_value - a| hi | undef === // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple Web

Re: [RDBO] helper function request

2007-01-11 Thread Jonathan Vanasco
// Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple Web Personality Disorder | Web Identity Management and 3D Social Networking

Re: [RDBO] standard technique for handling RO and RW database handles?

2007-01-08 Thread Jonathan Vanasco
makes sense. and if you have more than 1 db connection, the current implementation makes the most sense: there are too many cases to consider when deciding which db handle to use. // Jonathan Vanasco

Re: [RDBO] Quick Rose-y way to get value of Now() from the database

2006-12-29 Thread Jonathan Vanasco
to query the time you could also try creating a new rose::db::object class of sql helper items with 'result' as the only column-- then give it a manager class and have functions select your 'result' into the 'result' field. // Jonathan Vanasco

[RDBO] timestamp operations

2006-12-15 Thread Jonathan Vanasco
i don't know if this would be doable... current: $roseObj-timestamp_action('NOW()'); $roseObject-save; print $roseObj-timestamp_action ; \\NOW desired: $roseObj-timestamp_action('NOW()'); $roseObject-save; print

Re: [RDBO] timestamp operations

2006-12-15 Thread Jonathan Vanasco
explicit function ( cola = cola+colb ) ) d- would reload if the above conditions were met its not a simple solution. i wouldn't expect rose to be able to even handle anything like this for years - if ever. i just wanted to bring up the scenarios for discussion // Jonathan Vanasco

Re: [RDBO] timestamp operations

2006-12-15 Thread Jonathan Vanasco
On Dec 15, 2006, at 1:39 PM, John Siracusa wrote: Why is being in a transaction relevant? Unless the specific isolation level is known, I don't think it tells us anything. that's entirely true. - Take Surveys. Earn

Re: [RDBO] (no subject)

2006-12-09 Thread Jonathan Vanasco
be to use a DB trigger on insert , that would just populate all of the fields // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple Web Personality Disorder | Web Identity Management

Re: [RDBO] Manager classes?

2006-12-06 Thread Jonathan Vanasco
On Dec 6, 2006, at 1:40 PM, John Siracusa wrote: All of those things are perfectly possible. The downside to all of them is namespace pollution. The recommended approach, with separate ::Manager classes, gives each manager its own namespace in which to add custom methods. Putting manager

Re: [RDBO] How to do locking with RDBO?

2006-12-05 Thread Jonathan Vanasco
On Dec 5, 2006, at 5:42 PM, Perrin Harkins wrote: This can also be done in a one-shot, without needing to explicitly lock anything: UPDATE foo SET id = id+1 WHERE nice catch. i wasn't even thinking of sql. i was just trying to consolidate the original example. // Jonathan

Re: [RDBO] SET support for MySQL

2006-11-16 Thread Jonathan Vanasco
On Nov 16, 2006, at 2:16 AM, James Masters wrote: I use ENUM sometimes. It seemed like a straightforward thing to me (although I think either MySQL or my interface to it seems to have trouble with an enum option of the empty string). Leaving aside portability, what bad design patterns

Re: [RDBO] possible bug fix ( more like a fix for bugs in other places ) + suggestion

2006-10-25 Thread Jonathan Vanasco
, $hashref ) i'd just really like to see that functionality there - its really useful when you need to edit the yaml, init from storable or another ORM, and its the handy inverse of column_value_pairs // Jonathan Vanasco

Re: [RDBO] turning off / handling DBI pings?

2006-10-24 Thread Jonathan Vanasco
be the default object, but with some overridden connect args ) but that is probably well outside of the scope of what John wants rose to handle, and I'm not even sure that's what is going on. On Oct 9, 2006, at 2:57 PM, Jonathan Vanasco wrote: This is an odd issue... I'm using Rose::DB

[RDBO] possible bug fix ( more like a fix for bugs in other places ) + suggestion

2006-10-24 Thread Jonathan Vanasco
I've been going a bit crazy with the to/from yaml for serialization I noticed that YAML::Syck / JSON::Syck can sometimes have a blank line in it, which can screw the parser up, and then the rose reader This will fix it: next unless $column; where? Rose::DB::Object::Helpers

Re: [RDBO] turning off / handling DBI pings?

2006-10-24 Thread Jonathan Vanasco
, ive got a bastardized system where I cut to/from yaml and hashrefs, to coerce stuff in dirty, but it works. // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | FindMeOn.com - The cure for Multiple Web Personality

[RDBO] how do i turn auto_prime_caches off under mod_perl?

2006-10-20 Thread Jonathan Vanasco
I just wanted to bench the difference... auto_prime_caches is a class method, can't seem to find a way to toggle it globally - Using Tomcat but need to do more? Need to support web services, security? Get stuff done

Re: [RDBO] Elegant way to generically query a table?

2006-10-15 Thread Jonathan Vanasco
On Oct 14, 2006, at 9:58 PM, John Siracusa wrote: I think they key piece of knowledge you're missing is that a call like: $objs = My::Whatever::Manager-get_whatevers(...); is exactly equivalent to: $objs = Rose::DB::Object::Manager-get_objects( object_class =

[RDBO] setting up a new object with a related child ?

2006-10-13 Thread Jonathan Vanasco
I have essentially an inherited table... Class A col 1 col 2 col 3 Class B col 11 PRIMARY KEY REFERENCES col 1 col 12 col 13 Rose has them in a 1:1 relationship Loading is fine

Re: [RDBO] setting up a new object with a related child ?

2006-10-13 Thread Jonathan Vanasco
Right now I have this: $classAB= Rose::DB::Object::Manager-get_objects( object_class= A with_objects= ['B'], query= [ id= $kw_args{'id'} ,

Re: [RDBO] setting up a new object with a related child ?

2006-10-13 Thread Jonathan Vanasco
On Oct 13, 2006, at 4:09 PM, John Siracusa wrote: Then why not just do this: $a = A-new(id = 123); $b = B-new(id = 123); $a-b($b); $a-save; # save A and its associated B That's actually exactly what I wanted. I couldn't figure out if rose supported that or not.

[RDBO] install docs suggestion

2006-10-09 Thread Jonathan Vanasco
the install process has this bit of text: ## WARNING: Almost all the tests in this module distribution need to connect ## to a database in order to run. The tests need full privileges on this ## database: the ability to create and drop tables, insert, update, and delete ## rows, create

  1   2   >