SQLDict_timeShift.zsql 646 Bytes
Newer Older
1 2
<dtml-comment>
title:
3
connection_id:cmf_activity_sql_connection
4 5 6 7 8 9
max_rows:1
max_cache:0
cache_time:0
class_name:
class_file:
</dtml-comment>
10
<params>delay
11 12
processing_node
retry</params>
13 14 15
UPDATE
  message
SET
16
  date = DATE_SUB(date, INTERVAL <dtml-sqlvar delay type="int"> SECOND),
Sebastien Robin's avatar
Sebastien Robin committed
17
  processing_date = DATE_SUB(processing_date, INTERVAL <dtml-sqlvar delay type="int"> SECOND)
18
<dtml-if expr="retry is not None">
Sebastien Robin's avatar
Sebastien Robin committed
19
  ,retry = GREATEST(retry,<dtml-sqlvar retry type="int">) - <dtml-sqlvar retry type="int">
20
</dtml-if> 
21 22
WHERE
  1 = 1
23
<dtml-if expr="processing_node is not None">
24
  AND processing_node = <dtml-sqlvar processing_node type="int">
25
</dtml-if>