FrancisG-Massey / Capstone2016

4 stars 0 forks source link

Update trap_lastresettimestamp on POST /catch #294

Open sam-hunt opened 8 years ago

sam-hunt commented 8 years ago

This should be done via plpgsql trigger, rather than in the PUT /trap UPDATE operation as it is at the moment, as non-admin API users won't have access to this query due to the permissions model.

sam-hunt commented 8 years ago

The app would need to log these empty catches (which would be non-op INSERTs to the catch table, since we don't want to clog the DB with heaps of records where nothing is actually caught)