Mercurial > dive4elements > framework
diff ChangeLog @ 229:328ef982d768
When an artifact is touched the collections which contain the artifact are touched, too.
artifacts/trunk@1631 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 31 Mar 2011 08:58:42 +0000 |
| parents | dd977fb7552e |
| children | fbd57d2eeaef |
line wrap: on
line diff
--- a/ChangeLog Thu Mar 31 08:42:53 2011 +0000 +++ b/ChangeLog Thu Mar 31 08:58:42 2011 +0000 @@ -1,3 +1,22 @@ +2011-03-31 Sascha L. Teichmann <sascha.teichmann@intevation.de> + + * artifact-database/doc/schema-h2.sql, artifact-database/doc/schema-pg.sql: + Added a trigger on artifacts. If an artifact is changed the last_access + timestamp of the collections in which the artifact is in are updated, too. + Needs testing! + + - In PostgreSQL it is done by a trigger written in plpgsql. So don't + forget to the language to the database! + + - In H2 it is done by a trigger written in Java, because H2 does not + offer a script level trigger support. + + * artifact-database/src/main/java/de/intevation/artifactdatabase/h2/CollectionAccessUpdateTrigger.java: + The H2 trigger. + + * artifact-database/src/main/resources/sql/org-h2-driver.properties: + Added the statement which is executed if the trigger fires. + 2011-03-31 Ingo Weinzierl <ingo@intevation.de> * artifact-database/src/main/java/de/intevation/artifactdatabase/ArtifactDatabaseImpl.java: