[Dbix-class] automatically applying db-functions on specific fields

[quarky at quantentunnel.de]

Hi,

hope this is not too much a newby question, but it really bugs me.

I have a table with encrypted information in one field. Actually it is encrypted with the aes_encrypt function of mysql. I would like to use this function to automatically encrypt and decrypt the values in this field using the database function, but I do not find any hook where I can attach the function to DBIx::Class. I imagine it to work just automatically everytime I insert, update or read values.

Any suggestions? (In the unlikely event, that someone might know how to emulate aes_encrypt by using perl on the client side, I would appreciate this information too, but I am still interested in usage of db-functions on fields anyways)

Best Regards
Wolfgang Warner

-- 
"Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail