Closed lucernae closed 4 years ago
refresh materialized view
statement in separate trigger functions. If we do it like that, the next trigger will continue while the previous trigger has not been committed. So, it has to be done on a single trigger function. Like this: https://github.com/inasafe/inasafe-fba/pull/59/files#diff-f7922711dfd5dd4143055eeeacadb3b2mv_non_flooded_buildings
on hazard_event
update. We don't need to update those statistics, because it doesn't change on hazard_event
insert/updateother
building categories. @timlinux @NyakudyaA, we need to decide what to do with this.Looking good thanks: Only comment is to use inasafe prefix rather than fbf as I plan to make this platform a response based one too...
This PR will involve DB trigger tests which consists of:
To make sure our processing pipeline is complete, and within expected completion time.