[Helma-user] difficult object relational mapping

Joshua Paine joshua at papercrown.org
Wed Mar 5 19:23:43 CET 2008


Anton,

AFAIK, this isn't possible with Helma's ORM. Either add another column 
to your entries table with the most recent update date (a small 
denormalization that you might well end up making anyway for performance 
reasons) or create and use a view that simulates a table like the above 
with all the necessary triggers to make Helma's belief that it's a 
genuine table not lead to disaster.

If you go the first route and add a column, you could keep it updated 
either with a trigger pretty easily, I'd think. And you can mark it 
read-only for Helma to ensure nothing tries to set it directly.

-Joshua


More information about the Helma-user mailing list