We're really in need of a feature that would implement $rdbo->load(
for_update => 1 ) and translate that into code that does what MySQL does
when you "SELECT FOR UPDATE". Any possibility that might make it into
the next release???
Pretty please? I'll even hack code for it if you want me to,
] Code for Generating RDBO's for All Tables
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
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. I'm wondering if there's something that will
create all the
Never mind. It was a bug in my override of the load() method within
Bill::DB::Object::Acct (didn't shift from @_ before calling
$self->SUPER::load(@_).
My bad! Many apologies!
-- Jeff Horn
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeff
I have a table that has a unique key on (encrypt_ver_num, e_acct_num,
pay_type_id) and a primary key of (acct_id).
The following code:
#!/usr/bin/perl
use Bill::DB::Object::Acct;
use Data::Dumper;
my $acct = Bill::DB::Object::Acct->new( pay_type_id => 1, e_acct_num =>
'c8923a1e7de803ac73372d64
In MySQL 5.0.40-enterprise-gpl-log I run the following:
CREATE TABLE `foo` (
`foo_id` bigint(10) NOT NULL auto_increment,
`nullable_int` bigint(10) default NULL,
`nullable_varchar` varchar(10) default NULL,
PRIMARY KEY (`foo_id`)
);
insert into foo (foo_id) values (1);
mysql> select *
I have a table with several encrypted attributes. I'd like to add methods
to my RDBO for that table that can take cleartext for each of those fields
and set the encrypted value or get the cleartext for a field from the
current encrypted value.
In order to speed this up (I actually need to connect
I'm trying to simulate named SEQUENCES (a la Oracle or Postgres) in MySQL
(InnoDB). I have a table sequences with attributes name (varchar) and value
(integer). Conceptually, I'd like to do this
my $seq_name = 'foo';
my $db = $seq->db;
$db->begin_work;
$seq->load( name => $seq_name );
my $value
I need to get the value of Now() from the database server (as opposed to the
server on which my perl script is running) and wanted to know if there is a
quick and elegant way to get that value in a Rose-y way (as opposed to
dropping down to DBI). Just want to make sure I haven't missed such a
feat
I have a database table in which several columns are all functions of a
single sixteen digit number. Some of them are subsets of digits, others are
encryptions of the number, etc.
Is there a way in RDBO to override things so that I can get all the
individual values of the columns, but can prevent
10 matches
Mail list logo
