Ted Zlatanov wrote:
I realize much of this question belongs to database-specific domains,
but here goes: I want RDBO insert operations to be faster. I need to
load thousands of records per second into a database. I'm using
PostgreSQL, and everything works correctly. The extra DB operations
Ted Zlatanov wrote:
I couldn't find an example in the docs of how to set up
Rose::DB::Object::Loader with a properly pluralizing convention manager.
I tried the following, but I keep getting a class called Currencie
from a table called currencies for example. I must be missing
something.
Quoting John Siracusa [EMAIL PROTECTED]:
explicit_null
That's closer, but it feels like even less of a complete description
than undef_sets_null.
Perhaps it should involve 'default' somehow? undef_ignores_default or
something?
adam
Now that i've slept i'm wondering if the underlying problem might be
related to the way that defaults are handled in RDBO. That's one thing
that differs between the tables used in the original tests and the table
in the test i submitted.
Adam
[EMAIL PROTECTED] wrote:
With this patch,
Quoting John Siracusa [EMAIL PROTECTED]:
Did you use the Loader to make these classes? MySQL tends to offer up
empty string default values for non-null character columns, and the
Loader dutifully reflects that, having no way to distinguish between
legitimate empty string default values that
`),
UNIQUE KEY `user_name` (`user_name`),
UNIQUE KEY `email` (`email`),
KEY `location_id` (`location_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8
EOF
$dbh-do(EOF);
INSERT INTO `users` VALUES
(1,'adam','Adam','Prime','[EMAIL PROTECTED]','ddd',1,'2006-12-28
06:14:05','2007-08
With this patch, everything + my failing test passes. I'm not sure if
this is a good idea or a bad idea though. In my test that fails $_ is
defined as an empty string (as far as i can tell) for some reason,
instead of as undef as i would expect. There's probably an underlying
bug
Quoting Peter Karman [EMAIL PROTECTED]:
Adam,
Glad you are working on this too. Perhaps we can join forces.
Certainly. I've only really started using Rose about a month ago, so
i'm not sure how much use i'll be, but you never know ;)
I started something similar here:
I've been fooling around with this idea for the last couple of days
and I was wondering if I could get some feedback from the list.
Basically, what I've got working right now is a subclass of Loader,
which creates all the RDBO .pm files (obviously), as well as RHTMLO
'stubs' that contain
I find myself needing to bootstrap a bunch of Rose-based apps. Ideally, I'd
like to be able to run a script like:
make_rose_garden.pl --db db_name --host some.where --prefix MyGarden
and I would get RDBO .pm files, RHTMLO .pm files and some integrated
validation
glue, all generated
10 matches
Mail list logo