[Dbix-class] Per column filter

Pedro Melo melo at simplicidade.org
Thu Jun 18 12:18:14 GMT 2009


Hi,

I'm wrapping DBIx::Class over a legacy database that uses the  
iso-8859-1 charset internally. My app expects all perl strings as utf8.

I'm trying to write an extension to DBIC that decodes the value from  
the DB into utf8, and does the reverse when I insert/update data. At  
first I tried to use the InflateColumn as the base of this, but it  
expects a DB -> Object / Object -> DB flow, and cannot support the DB - 
 > scalar / scalar -> DB (at least not on the deflate part).

I was wondering if anybody has any ideas/suggestions on how to do this  
inside DBIC. I would prefer not to manually encode/decode data I get  
from the DB.

Basically a setup like the current InflateColumn but that allows  
scalars to be processed on the deflate step would work, like a filter.

Thanks in advance,
-- 
Pedro Melo
Blog: http://www.simplicidade.org/notes/
XMPP ID: melo at simplicidade.org
Use XMPP!





More information about the DBIx-Class mailing list