liquid_feedback_frontend

diff model/event_processed.lua @ 1309:32cc544d5a5b

Cumulative patch for upcoming frontend version 4
author bsw/jbe
date Sun Jul 15 14:07:29 2018 +0200 (2018-07-15)
parents
children
line diff
     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/model/event_processed.lua	Sun Jul 15 14:07:29 2018 +0200
     1.3 @@ -0,0 +1,22 @@
     1.4 +EventProcessed = mondelefant.new_class()
     1.5 +EventProcessed.table = 'event_processed'
     1.6 +
     1.7 +function EventProcessed:get_last_id()
     1.8 +  
     1.9 +  local event_processed = self:new_selector()
    1.10 +    :optional_object_mode()
    1.11 +    :for_update()
    1.12 +    :exec()
    1.13 +    
    1.14 +  local last_event_id = 0
    1.15 +  if event_processed then
    1.16 +    last_event_id = event_processed.event_id
    1.17 +  end
    1.18 +  
    1.19 +  return last_event_id
    1.20 +  
    1.21 +end
    1.22 +
    1.23 +function EventProcessed:set_last_id(id)
    1.24 +  db:query{ "INSERT INTO event_processed (event_id) VALUES (?) ON CONFLICT ((1)) DO UPDATE SET event_id = EXCLUDED.event_id", id }
    1.25 +end

Impressum / About Us