Hi,
While fetching records from postgres database using DAL API we need to
decrypt some specific fields. These field names start with some specific
prefix (e.g. *kny_*). Is there any way that we could override DAL functions
to achieve this requirement?
Suppose we've following table:
*db.define_table('taxpayer',*
*Field('name'),*
*Field('tax', 'boolean'),*
*Field('designation'),*
*Field('kny_address'),
*
*Field('kny_phone'))*
So my this code:
*queryset = db(db.taxpayer)
*
*myorder = db.taxpayer.id *
*record_list = queryset.select(db.taxpayer.ALL, orderby = myorder)
*
executes this query, select * from taxpayer order by id
and I want to change it to: *select id, name, tax, designation,
decrypt(kny_address), decrypt(kny_phone).*
*
*
*
*
Thanks in advance.
--
