Re: [RDBO] form validation and RDBO

2007-10-23 Thread Christopher H. Laco
Peter Karman wrote: On 10/23/2007 11:29 AM, Bill Moseley wrote: lib/My/Thing.pm lib/My/Thing/Form.pm Is that one form for each table kind of mapping? I might have multiple forms for each table (or groups to tables) and they are more related to the specific request (update user profile

Re: [RDBO] form validation and RDBO

2007-10-23 Thread Christopher H. Laco
Bill Moseley wrote: [snip] Yep, although I prefer to use English as the key to the language files instead of an ID. Easier to understand when looking at specific validation code. I can also fall back to using the ID (the English error message) if the lookup fails in the language file.

Re: [RDBO] form validation and RDBO

2007-10-23 Thread Christopher H. Laco
Bill Moseley wrote: On Tue, Oct 23, 2007 at 02:12:08PM -0400, Christopher H. Laco wrote: Bill Moseley wrote: [snip] Yep, although I prefer to use English as the key to the language files instead of an ID. Easier to understand when looking at specific validation code. I can also fall back

Re: [RDBO] Bizarre. New PC. Everything faster except Rose which is5X slower!

2007-04-20 Thread Christopher H. Laco
James Masters wrote: That is a suggestion of experience, thanks. I've analysed just done this and the results are not what you ( I) probably expected. I've tried all 4 combinations of server against mysql server. Numbers = secs. ServerMysql ServerDBI Rose Old

Re: [RDBO] Debian Rose

2007-03-19 Thread Christopher H. Laco
Jeff Chimene wrote: Jonathan Vanasco wrote: Try installing Scalar::Util by hand, or from a CPAN shell -- that module and a few others don't seem to like being installed as dependencies by many modules. few perl modules make it to debian packages, fewer are timely. debian was notorious

Re: [RDBO] Transactions, ACID etc.

2007-03-16 Thread Christopher H. Laco
Perrin Harkins wrote: On 3/16/07, James Masters [EMAIL PROTECTED] wrote: Just wondering - does Rose deal with transactions, rollbacks etc. under the hood (or under the bonnet as we say in England) and is therefore ACID compliant? You really don't need any help from your object-relational

Re: [RDBO] Transactions, ACID etc.

2007-03-16 Thread Christopher H. Laco
Perrin Harkins wrote: On 3/16/07, Christopher H. Laco [EMAIL PROTECTED] wrote: Totally a side tangent, but when you start using your schema classes from RDBO/DBIC/CDBI in things like Catalyst as Models, and maybe using many of them at the same time in one transaction, that whole Just use

Re: [RDBO] Transactions, ACID etc.

2007-03-16 Thread Christopher H. Laco
Perrin Harkins wrote: On 3/16/07, Christopher H. Laco [EMAIL PROTECTED] wrote: My point is, there's no sane way to do a big jumble of code in one DB transaction without having to go code diving for a dbh to work against, ala 'local $dbh-{AutoCommit} and such. So you're saying that one

Re: [RDBO] Transactions, ACID etc.

2007-03-16 Thread Christopher H. Laco
I guess I'm just spoiled by other languages sometimes. A certain MS Java ripoff language can do transactions over an entire 'app domain'. So any db call, to any db, multiple dbs, and file actions, or anything that supports transactions act as part of one global transaction automatically, without

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

2007-01-15 Thread Christopher H. Laco
parameters beyond just type and domain are passed. (Suggested by Christopher H. Laco) * Fixed a bug that prevented foreign keys with columns that use reserved words from being auto-initialized correctly. (Reported by Clayton Scott) * Improved DSN parsing. Woohoo

Re: [RDBO] Rose::DB connection problems

2006-12-21 Thread Christopher H. Laco
John Siracusa wrote: On 12/21/06, Christopher H. Laco [EMAIL PROTECTED] wrote: I'm going to put the svn version in my PREREQ. Any idea when this version will make it to CPAN? I wasn't planning on releasing until January, but I can release Rose::DB earlier if you want. (Of course, I'm

[RDBO] Rose::DB connection problems

2006-12-20 Thread Christopher H. Laco
Time to float this to list, rather than being a pita on IRC. :-) I'm trying to work R::DB objects where I need to create objects with their own values, rather than relying things predefined in the registry. (people tell Handel what dsn to use with its schema, and Handel doesn't know connection

Re: [RDBO] Rose::DB connection problems

2006-12-20 Thread Christopher H. Laco
Even more confusing to me is that if I just set a database name, it doesn't even connect: Rose::DB-register_db( domain = 'handel', type = 'default', driver = 'SQLite' ); my $db = Rose::DB-new( domain = 'handel', type = 'default', database =

[RDBO] delete_objects + cascade?

2006-12-15 Thread Christopher H. Laco
When deleting an object, one can pass the cascade option so it will delete all child objects in a relationship. In my case, passing cascade to the cart object, will delete the cart and all of it's related items: $cart-delete(cascade = 1); Is there a way to do this same thing when delete

Re: [RDBO] delete_objects + cascade?

2006-12-15 Thread Christopher H. Laco
John Siracusa wrote: On 12/15/06, Christopher H. Laco [EMAIL PROTECTED] wrote: When deleting an object, one can pass the cascade option so it will delete all child objects in a relationship. In my case, passing cascade to the cart object, will delete the cart and all of it's related items

Re: [RDBO] delete_objects + cascade?

2006-12-15 Thread Christopher H. Laco
John Siracusa wrote: On 12/15/06, Christopher H. Laco [EMAIL PROTECTED] wrote: Will cascade work if I load the carts with just their pk/fk columns, and set with_objects to {} so they don't load the items? I think you mean [], not {} (actually, it'd be better to just omit the with_objects

Re: [RDBO] Filtering relationship data

2006-12-12 Thread Christopher H. Laco
If you want to do ad-hoc queries with filters, either use the Manager directly, or create your own object methods that wrap the appropriate manager calls: package Cart; ... sub get_items { my($self, %args) = @_; # Clause that links items to this cart