would it be possible to reserve a namespace within rose db objects
for user use?
i need to cache some calculated data in an object for use over
multiple calls
it would be nice if there were a prefix or a set var in
rose::db::objects that could officially be safe to use
ie, no official stu
I probably should be able to figure this out on my
own, but if I'm barking up the wrong tree, I don't
want to spend the time, and searching hasn't helped.
I want to update a row in the table using the result
of a subselect as a value in one round trip.
In DBI, I would do this:
prepare( 'update m
this is what i am working with so far and works ok if all rows have
the same encryption key:
package RM::DB::Column::AESCrypt;
use base 'Rose::DB::Object::Metadata::Column::Blob';
sub select_sql {
my $self = shift;
my $value = q{AES_DECRYPT(body, 'SECRET')};
return $va
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 yo
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 special crypt key?
On Feb 28, 2007, at 1:47 PM, John Siracusa wrote:
> On 2/28/07, Michael Reece <[EMAIL PROTECTED]> 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 feeling daring, this API is still not public, but I'm pretty
sure it still works:
http://www.mail-archive.com/[email protected]/msg00710.
is it possible to inflate/deflate columns using mysql functions via
RDBO?
that is, consider the following behavior:
mysql> create table special ( id int auto_increment primary key,
secret blob ) ;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into special (secret) values (AES_ENCRYPT('
