* xyon <[EMAIL PROTECTED]> [080326 15:00]:
> On Wed, 2008-03-26 at 14:37 -0700, Marc Mims wrote:
> > * xyon <[EMAIL PROTECTED]> [080326 14:10]:
> > > I am trying to wrap my head around using "inflate_column" to
> > > decrypt/encrypt AES Encrypted data from within a MySQL database, but
> > > have not found any examples on Google. Also, below is an attempt to
> > > figure out how to run raw SQL queries with DBIx::Class.
> >
> > You don't want inflate_column. See DBIx::Class::EncodedColumn.
> >
> > (xyon, sorry for the dup reply... I failed to do a list-reply the first
> > time)
> >
>
> Thank you for the pointer, it definitely looks like a smoother/cleaner
> approach.
>
> I've browsed through the documentation, and am not seeing anything
> referring to AES encryption, however. Is there a way to extend the
> encryption algorithms to use MySQL native AES?
Actually, I haven't dealt with that particular problem. Perhaps
Crypt::OpenSSL::AES or Crypt::Rijndael can be used as the digest_class
with appropriate encode_args. It may require creating a subclass??
The reason I warned you away from inflate_column is that it expects to
inflate from a string to an object and deflate from an object to a
string. It doesn't handle string to string transformations.
-Marc
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
