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

Oleg Pronin syber.rus at gmail.com
Mon May 7 11:10:04 GMT 2007


To fetch the value you need to call
$obj->get_column('decrypted_field_name'),
not $obj->decrypted_field_name. See docs for info on how get
$obj->decrypted_field_name working too.


2007/5/7, Oleg Pronin <syber.rus at gmail.com>:
>
> For this to be done automatically,
> in your result source Employee:
>
> __PACKAGE__->resultset_attributes({
>      +select =3D> [ \"AES_DECRYPT(field_name,'password')" ],
>      +as     =3D> [qw/ decrypted_field_name /],
> });
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20070507/0d0=
625df/attachment.htm


More information about the Dbix-class mailing list