[Erp5-report] r25261 - /erp5/trunk/products/CMFActivity/skins/activity/
nobody at svn.erp5.org
nobody at svn.erp5.org
Thu Jan 22 14:08:25 CET 2009
Author: vincent
Date: Thu Jan 22 14:08:25 2009
New Revision: 25261
URL: http://svn.erp5.org?rev=25261&view=rev
Log:
Remove never passed parameters.
Modified:
erp5/trunk/products/CMFActivity/skins/activity/SQLDict_assignMessage.zsql
erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readMessageList.zsql
erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readUidList.zsql
erp5/trunk/products/CMFActivity/skins/activity/SQLDict_reserveMessageList.zsql
erp5/trunk/products/CMFActivity/skins/activity/SQLDict_setPriority.zsql
erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_assignMessage.zsql
erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql
erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_setPriority.zsql
Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLDict_assignMessage.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLDict_assignMessage.zsql?rev=25261&r1=25260&r2=25261&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLDict_assignMessage.zsql [utf8] (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLDict_assignMessage.zsql [utf8] Thu Jan 22 14:08:25 2009
@@ -7,9 +7,8 @@
class_name:
class_file:
</dtml-comment>
-<params>path
+<params>
processing_node
-method_id
uid
</params>
UPDATE message
@@ -17,14 +16,8 @@
processing_node=<dtml-sqlvar processing_node type="int">,
processing=0
WHERE
-<dtml-if uid>
uid IN (
<dtml-in uid><dtml-sqlvar sequence-item type="int"><dtml-if sequence-end><dtml-else>,</dtml-if></dtml-in>
)
-<dtml-else>
- processing_node = -1
- AND path = <dtml-sqlvar path type="string">
-<dtml-if method_id>AND method_id = <dtml-sqlvar method_id type="string"></dtml-if>
-</dtml-if>
<dtml-var sql_delimiter>
COMMIT
Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readMessageList.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readMessageList.zsql?rev=25261&r1=25260&r2=25261&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readMessageList.zsql [utf8] (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readMessageList.zsql [utf8] Thu Jan 22 14:08:25 2009
@@ -10,7 +10,6 @@
<params>path
method_id
processing_node
-priority
include_processing
to_date
offset:int=0
@@ -24,7 +23,6 @@
AND processing = 0
</dtml-if>
<dtml-if expr="processing_node is not None"> AND processing_node = <dtml-sqlvar processing_node type="int"> </dtml-if>
-<dtml-if priority> AND priority = <dtml-sqlvar priority type="int"> </dtml-if>
<dtml-if path>AND path = <dtml-sqlvar path type="string"> </dtml-if>
<dtml-if method_id> AND method_id = <dtml-sqlvar method_id type="string"> </dtml-if>
<dtml-if to_date> AND date <= <dtml-sqlvar to_date type="datetime"> </dtml-if>
Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readUidList.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readUidList.zsql?rev=25261&r1=25260&r2=25261&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readUidList.zsql [utf8] (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLDict_readUidList.zsql [utf8] Thu Jan 22 14:08:25 2009
@@ -7,19 +7,15 @@
class_name:
class_file:
</dtml-comment>
-<params>processing_node
+<params>
method_id
path
-to_date
order_validation_text
-group_method_id</params>
+</params>
SELECT uid FROM
message
WHERE
processing = 0
-<dtml-if expr="processing_node is not None"> AND processing_node = <dtml-sqlvar processing_node type="int"> </dtml-if>
<dtml-if method_id> AND method_id = <dtml-sqlvar method_id type="string"> </dtml-if>
<dtml-if path> AND path = <dtml-sqlvar path type="string"> </dtml-if>
-<dtml-if to_date> AND date <= <dtml-sqlvar to_date type="datetime"> </dtml-if>
<dtml-if order_validation_text> AND order_validation_text = <dtml-sqlvar order_validation_text type="string"> </dtml-if>
-<dtml-if group_method_id> AND group_method_id = <dtml-sqlvar group_method_id type="string"> </dtml-if>
Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLDict_reserveMessageList.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLDict_reserveMessageList.zsql?rev=25261&r1=25260&r2=25261&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLDict_reserveMessageList.zsql [utf8] (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLDict_reserveMessageList.zsql [utf8] Thu Jan 22 14:08:25 2009
@@ -11,7 +11,7 @@
to_date
count
group_method_id
-order_validation_text</params>
+</params>
UPDATE
message
SET
@@ -20,7 +20,6 @@
processing_node=0
AND date <= <dtml-sqlvar to_date type="datetime">
<dtml-if group_method_id> AND group_method_id = <dtml-sqlvar group_method_id type="string"> </dtml-if>
- <dtml-if order_validation_text> AND order_validation_text = <dtml-sqlvar order_validation_text type="string"> </dtml-if>
ORDER BY
priority, date, uid
<dtml-if count>
Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLDict_setPriority.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLDict_setPriority.zsql?rev=25261&r1=25260&r2=25261&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLDict_setPriority.zsql [utf8] (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLDict_setPriority.zsql [utf8] Thu Jan 22 14:08:25 2009
@@ -9,11 +9,9 @@
</dtml-comment>
<params>uid:list
priority
-date
retry
delay
-processing_node
-order_validation_text</params>
+</params>
UPDATE
message
SET
@@ -23,22 +21,11 @@
</dtml-if>
<dtml-if delay>
, date = DATE_ADD(UTC_TIMESTAMP(), INTERVAL <dtml-sqlvar delay type="int"> * (retry + 1) SECOND)
-<dtml-elif date>
- , date = <dtml-sqlvar date type="datetime">
</dtml-if>
<dtml-if retry>
, retry = retry + <dtml-sqlvar retry type="int">
</dtml-if>
WHERE
- 1 = 1
-<dtml-if uid>
- AND uid IN (
+ uid IN (
<dtml-in uid><dtml-sqlvar sequence-item type="int"><dtml-if sequence-end><dtml-else>,</dtml-if></dtml-in>
)
-</dtml-if>
-<dtml-if expr="_.getattr(_, 'processing_node', None) is not None">
- AND processing_node = <dtml-sqlvar processing_node type="int">
-</dtml-if>
-<dtml-if order_validation_text>
- AND order_validation_text = <dtml-sqlvar order_validation_text type="string">
-</dtml-if>
Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_assignMessage.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_assignMessage.zsql?rev=25261&r1=25260&r2=25261&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_assignMessage.zsql [utf8] (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_assignMessage.zsql [utf8] Thu Jan 22 14:08:25 2009
@@ -7,21 +7,16 @@
class_name:
class_file:
</dtml-comment>
-<params>path
+<params>
processing_node
-method_id
uid</params>
UPDATE message_queue
SET
processing_node=<dtml-sqlvar processing_node type="int">,
processing=0
WHERE
-<dtml-if path> path = <dtml-sqlvar path type="string">
-<dtml-else>
uid IN (
<dtml-in uid><dtml-sqlvar sequence-item type="int"><dtml-if sequence-end><dtml-else>,</dtml-if></dtml-in>
)
-</dtml-if>
-<dtml-if method_id> AND method_id = <dtml-sqlvar method_id type="string"></dtml-if>
<dtml-var sql_delimiter>
COMMIT
Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql?rev=25261&r1=25260&r2=25261&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql [utf8] (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql [utf8] Thu Jan 22 14:08:25 2009
@@ -10,7 +10,6 @@
<params>path
method_id
processing_node
-priority
to_date
offset:int=0
count:int=1000
@@ -20,7 +19,6 @@
WHERE
processing = 0
<dtml-if expr="processing_node is not None"> AND processing_node = <dtml-sqlvar processing_node type="int"> </dtml-if>
-<dtml-if priority>AND priority = <dtml-sqlvar priority type="int"> </dtml-if>
<dtml-if path>AND path = <dtml-sqlvar path type="string"></dtml-if>
<dtml-if method_id>AND method_id = <dtml-sqlvar method_id type="string"></dtml-if>
<dtml-if to_date> AND date <= <dtml-sqlvar to_date type="datetime"> </dtml-if>
Modified: erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_setPriority.zsql
URL: http://svn.erp5.org/erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_setPriority.zsql?rev=25261&r1=25260&r2=25261&view=diff
==============================================================================
--- erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_setPriority.zsql [utf8] (original)
+++ erp5/trunk/products/CMFActivity/skins/activity/SQLQueue_setPriority.zsql [utf8] Thu Jan 22 14:08:25 2009
@@ -10,7 +10,7 @@
<params>uid
priority
delay
-date</params>
+</params>
UPDATE
message_queue
SET
@@ -20,8 +20,6 @@
</dtml-if>
<dtml-if delay>
, date = DATE_ADD(UTC_TIMESTAMP(), INTERVAL <dtml-sqlvar delay type="int"> SECOND)
- <dtml-elif date>
- , date = <dtml-sqlvar date type="datetime">
</dtml-if>
WHERE
uid IN (
More information about the Erp5-report
mailing list