[Dbix-class] How to arrange common-cache result sets

Michael Gray mjg17 at eng.cam.ac.uk
Wed Jun 7 15:50:38 CEST 2006


I'm hoping a quick(?) query now will save me some time and digging.
I have a number of tables in my application which are essentially lookup 
tables.  These are slow-changing but not static.  An example is 'domain' 
which contains valid domains for the site
 10 => eng.cam.ac.uk
 20 => vlan.eng.cam.ac.uk
 etc.

What I'd like to do is set up my DBIC schema class for such a table such
that there's a common cache, and that a call to 

 schema()->resultset('domain')

returns a resultset which makes use of the common cache.   How might I 
best go about this?

At the same time, I'd like to arrange that any insert, delete or update 
on 'domain' invalidates the common cache.  What are the best hooks for 
doing this?

Thanks in advance for any pointers.

-- 
Michael



More information about the Dbix-class mailing list