[CAY-1465] Triggering removeGroup on update/delete/insert query

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0, 3.1M1
• Fix Version/s: Undefined future
• Component/s: Core Library
• Assignee: Unassigned
• Reporter: Evgeny Ryabitskiy
• Created: 14/Jul/10 09:12
• Updated: 29/Sep/14 19:52

Description

It can be useful for this case:

I have 2 selects (NamedQueries) for table Artists, which have SHARED
cache policy:

MyArtistsSelectQuery1 from group ArtistsTableGroup:
select * from Artists where isModern = 0

MyArtistsSelectQuery2 from group ArtistsTableGroup:
select * from Artists where isModern = 1

And one insert:
MyArtistsInsertQuery1
insert into Artists values (....) .....

Select NamedQueries are marked by properties in XML
<property name="cayenne.GenericSelectQuery.cacheStrategy"
value="SHARED_CACHE"/>
<property name="cayenne.GenericSelectQuery.cacheGroups"
value="ArtistsTableGroup"/>

So, I would like to mark insert query as trigger for cache group
removingin SHARED cache, like implicit execution of:
domain.getQueryCache().removeGroup("ArtistsTableGroup");
after successful insert.

some property like:
<property name="cayenne.GenericSelectQuery.removeGroups"
value="ArtistsTableGroup"/>

I think it can be very useful.