On 2/28/07 7:39 PM, Michael Reece wrote:
> On Feb 28, 2007, at 2:13 PM, Michael Reece wrote:
>> this looks very promising! but what args are passed to select_sql,
>> etc? [...]
Right now, the args are the column metadata object, the db object, and the
table name.
> any suggestions on how to get
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('
