[Erp5-report] r12739 - /spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/
nobody at svn.erp5.org
nobody at svn.erp5.org
Thu Feb 15 17:36:26 CET 2007
Author: yusei
Date: Thu Feb 15 17:36:19 2007
New Revision: 12739
URL: http://svn.erp5.org?rev=12739&view=rev
Log:
commit debian(unstable) packages.
Added:
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_assignMessage.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_clearProcessingFlag.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_delMessage.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_dropMessageTable.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_dumpMessageList.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_hasMessage.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_processMessage.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readMessage.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readMessageList.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readUidList.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_setPriority.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_timeShift.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_validateMessageList.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_writeMessage.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_writeMessageList.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_assignMessage.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_clearProcessingFlag.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_delMessage.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_dropMessageTable.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_dumpMessageList.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_hasMessage.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_processMessage.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readMessage.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readUidList.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_setPriority.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_timeShift.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_validateMessageList.zsql
spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_writeMessage.zsql
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_assignMessage.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_assignMessage.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_assignMessage.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_assignMessage.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,29 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>path
+processing_node
+method_id
+uid
+broadcast</params>
+UPDATE message
+SET
+ processing_node=<dtml-sqlvar processing_node type="int">,
+ processing=0
+WHERE
+<dtml-if uid>
+<dtml-in uid>uid = <dtml-sqlvar sequence-item type="int"><dtml-if sequence-end><dtml-else>
+ OR </dtml-if></dtml-in>
+<dtml-else>
+ path = <dtml-sqlvar path type="string">
+<dtml-if method_id>AND method_id = <dtml-sqlvar method_id type="string"></dtml-if>
+</dtml-if>
+<dtml-if broadcast>
+ AND broadcast = <dtml-sqlvar broadcast type="int">
+</dtml-if>
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_clearProcessingFlag.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_clearProcessingFlag.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_clearProcessingFlag.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_clearProcessingFlag.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,17 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>processing_node:int=-1</params>
+UPDATE
+ message
+SET
+ processing="0"
+WHERE
+ processing="1"
+ AND processing_node="<dtml-sqlvar processing_node type="int">"
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_createMessageTable.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,36 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params></params>
+CREATE TABLE `message` (
+ `uid` INT UNSIGNED NOT NULL auto_increment,
+ `date` datetime,
+ `path` VARCHAR(255),
+ `method_id` VARCHAR(255),
+ `processing_node` INT DEFAULT -1,
+ `processing` TINYINT DEFAULT 0,
+ `processing_date` datetime,
+ `priority` TINYINT DEFAULT 0,
+ `broadcast` TINYINT DEFAULT 0,
+ `group_method_id` VARCHAR(255) DEFAULT '',
+ `tag` VARCHAR(255),
+ `retry` TINYINT UNSIGNED NOT NULL DEFAULT 0,
+ `order_validation_text` VARCHAR(255),
+ `message` BLOB,
+ PRIMARY KEY (`uid`),
+ KEY `date` (`date`),
+ KEY `path` (`path`),
+ KEY `method_id` (`method_id`),
+ KEY `processing_node` (`processing_node`),
+ KEY `processing` (`processing`),
+ KEY `processing_date` (`processing_date`),
+ KEY `priority` (`priority`),
+ KEY `tag` (`tag`),
+ KEY `order_validation_text` (`order_validation_text`)
+) TYPE = InnoDB;
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_delMessage.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_delMessage.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_delMessage.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_delMessage.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,15 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>uid:list</params>
+DELETE FROM
+ message
+WHERE
+<dtml-in uid>uid = <dtml-sqlvar sequence-item type="int"><dtml-if sequence-end><dtml-else> OR </dtml-if>
+</dtml-in>
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_dropMessageTable.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_dropMessageTable.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_dropMessageTable.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_dropMessageTable.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,11 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params></params>
+DROP TABLE message
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_dumpMessageList.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_dumpMessageList.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_dumpMessageList.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_dumpMessageList.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,14 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:0
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params></params>
+SELECT * FROM
+ message
+ORDER BY
+ uid
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_hasMessage.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_hasMessage.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_hasMessage.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_hasMessage.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,20 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1
+max_cache:100
+cache_time:1
+class_name:
+class_file:
+</dtml-comment>
+<params>path
+method_id</params>
+SELECT count(path) as message_count FROM
+ message
+<dtml-if "path or method_id">
+WHERE
+<dtml-if path> 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>
+
+
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_processMessage.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_processMessage.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_processMessage.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_processMessage.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,17 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>uid</params>
+UPDATE message
+SET
+ processing_date = <dtml-sqlvar "_.DateTime()" type="datetime">,
+ processing = 1
+WHERE
+<dtml-in uid>uid = <dtml-sqlvar sequence-item type="int"><dtml-if sequence-end><dtml-else>
+ OR </dtml-if></dtml-in>
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readMessage.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readMessage.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readMessage.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readMessage.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,34 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:0
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>processing_node
+priority
+to_date
+to_processing_date
+group_method_id
+order_validation_text</params>
+SELECT DISTINCT * FROM
+ message
+WHERE
+ processing <> 1
+<dtml-if processing_node> 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 to_date>AND date <= <dtml-sqlvar to_date type="datetime"> </dtml-if>
+<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>
+
+GROUP BY
+ path, method_id
+ORDER BY
+ priority, date
+<dtml-if group_method_id>
+LIMIT 100
+<dtml-else>
+LIMIT 1
+</dtml-if>
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readMessageList.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readMessageList.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readMessageList.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readMessageList.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,40 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>path
+method_id
+processing_node
+priority
+to_processing_date
+include_processing</params>
+<dtml-if to_processing_date>UPDATE message
+SET
+ processing = 0
+WHERE
+ processing = 1
+AND
+ processing_date < <dtml-sqlvar to_processing_date type="datetime">
+
+<dtml-var "'\0'">
+
+</dtml-if>SELECT * FROM
+ message
+WHERE
+1 = 1
+<dtml-if expr="not(include_processing)">
+ AND processing <> 1
+</dtml-if>
+<dtml-if processing_node> 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>
+GROUP BY
+ path, method_id, processing_node, processing
+ORDER BY
+ priority, date
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readUidList.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readUidList.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readUidList.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_readUidList.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,23 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:10000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>processing_node
+method_id
+path
+to_date
+order_validation_text</params>
+SELECT uid FROM
+ message
+WHERE
+ processing <> 1
+<dtml-if processing_node> 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>
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_setPriority.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_setPriority.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_setPriority.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_setPriority.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,46 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>uid:list
+priority
+date
+retry
+delay
+processing_node
+order_validation_text</params>
+UPDATE
+ message
+SET
+ processing = 0
+<dtml-if priority>
+ , priority = <dtml-sqlvar priority type="int">
+</dtml-if>
+<dtml-if delay>
+ , date = DATE_ADD(NOW(), 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 (
+ <dtml-in uid>
+ uid = <dtml-sqlvar sequence-item type="int"><dtml-if sequence-end><dtml-else> OR </dtml-if>
+ </dtml-in>
+ )
+</dtml-if>
+<dtml-if processing_node>
+ 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>
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_timeShift.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_timeShift.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_timeShift.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_timeShift.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,25 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>delay
+processing_node
+retry</params>
+UPDATE
+ message
+SET
+ date = DATE_SUB(date, INTERVAL <dtml-sqlvar delay type="int"> SECOND),
+ processing_date = DATE_SUB(processing_date, INTERVAL <dtml-sqlvar delay type="int"> SECOND)
+<dtml-if retry>
+ ,retry = GREATEST(retry,<dtml-sqlvar retry type="int">) - <dtml-sqlvar retry type="int">
+</dtml-if>
+WHERE
+ 1 = 1
+<dtml-if processing_node>
+ AND processing_node = <dtml-sqlvar processing_node type="int">
+</dtml-if>
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_validateMessageList.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_validateMessageList.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_validateMessageList.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_validateMessageList.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,42 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>method_id
+message_uid
+path
+tag
+</params>
+SELECT
+ COUNT(DISTINCT uid) as uid_count
+FROM
+ message
+WHERE
+ processing_node >= -2
+<dtml-if method_id>
+ AND (
+<dtml-in method_id>
+ method_id = <dtml-sqlvar sequence-item type="string"><dtml-if sequence-end><dtml-else> OR </dtml-if>
+</dtml-in>
+ )
+</dtml-if>
+<dtml-if message_uid>AND uid = <dtml-sqlvar message_uid type="int"> </dtml-if>
+<dtml-if path>
+ AND (
+<dtml-in path>
+ path = <dtml-sqlvar sequence-item type="string"><dtml-if sequence-end><dtml-else> OR </dtml-if>
+</dtml-in>
+ )
+</dtml-if>
+<dtml-if tag>
+ AND (
+<dtml-in tag>
+ tag = <dtml-sqlvar sequence-item type="string"><dtml-if sequence-end><dtml-else> OR </dtml-if>
+</dtml-in>
+ )
+</dtml-if>
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_writeMessage.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_writeMessage.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_writeMessage.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_writeMessage.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,32 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>path
+method_id
+message
+priority
+broadcast
+date
+processing_node=-1
+group_method_id
+tag
+order_validation_text</params>
+INSERT INTO message
+SET
+ path = <dtml-sqlvar path type="string">,
+ <dtml-if date>date = <dtml-sqlvar date type="string">, <dtml-else>date = <dtml-sqlvar "_.DateTime()" type="datetime">, </dtml-if>
+ method_id = <dtml-sqlvar method_id type="string">,
+ processing_node = <dtml-sqlvar processing_node type="int">,
+ processing = -1,
+ priority = <dtml-sqlvar priority type="int">,
+ broadcast = <dtml-sqlvar broadcast type="int">,
+ group_method_id = <dtml-sqlvar group_method_id type="string">,
+ tag = <dtml-sqlvar tag type="string">,
+ order_validation_text = <dtml-sqlvar order_validation_text type="string">,
+ message = <dtml-sqlvar message type="string">
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_writeMessageList.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_writeMessageList.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_writeMessageList.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLDict_writeMessageList.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,38 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>path_list
+method_id_list
+message_list
+priority_list
+broadcast_list
+date_list
+processing_node_list
+group_method_id_list
+tag_list
+order_validation_text_list</params>
+INSERT INTO message
+(path, date, method_id, processing_node, processing, priority, broadcast, group_method_id, tag, order_validation_text, message)
+VALUES
+<dtml-in prefix="loop" expr="_.range(_.len(path_list))">
+<dtml-if sequence-start><dtml-else>,</dtml-if>
+(
+ <dtml-sqlvar expr="path_list[loop_item]" type="string">,
+ <dtml-if date_list><dtml-sqlvar expr="date_list[loop_item]" type="datetime"><dtml-else><dtml-sqlvar "_.DateTime()" type="datetime"></dtml-if>,
+ <dtml-sqlvar expr="method_id_list[loop_item]" type="string">,
+ <dtml-if processing_node_list><dtml-sqlvar expr="processing_node_list[loop_item]" type="int"><dtml-else>-1</dtml-if>,
+ -1,
+ <dtml-sqlvar expr="priority_list[loop_item]" type="int">,
+ <dtml-sqlvar expr="broadcast_list[loop_item]" type="int">,
+ <dtml-sqlvar expr="group_method_id_list[loop_item]" type="string">,
+ <dtml-sqlvar expr="tag_list[loop_item]" type="string">,
+ <dtml-sqlvar expr="order_validation_text_list[loop_item]" type="string">,
+ <dtml-sqlvar expr="message_list[loop_item]" type="string">
+)
+</dtml-in>
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_assignMessage.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_assignMessage.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_assignMessage.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_assignMessage.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,26 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>path
+processing_node
+method_id
+broadcast
+uid:int=0</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 = <dtml-sqlvar uid type="int"> </dtml-if>
+<dtml-if method_id> AND method_id = <dtml-sqlvar method_id type="string"></dtml-if>
+<dtml-if broadcast>
+ AND broadcast = <dtml-sqlvar broadcast type="int">
+</dtml-if>
+
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_clearProcessingFlag.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_clearProcessingFlag.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_clearProcessingFlag.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_clearProcessingFlag.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,17 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>processing_node:int=-1</params>
+UPDATE
+ message_queue
+SET
+ processing="0"
+WHERE
+ processing="1"
+ AND processing_node="<dtml-sqlvar processing_node type="int">"
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_createMessageTable.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,32 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params></params>
+CREATE TABLE `message_queue` (
+ `uid` int(11) NOT NULL auto_increment,
+ `date` datetime,
+ `path` VARCHAR(255),
+ `method_id` VARCHAR(40),
+ `processing_node` INT DEFAULT -1,
+ `processing` INT DEFAULT 0,
+ `processing_date` datetime,
+ `priority` INT DEFAULT 0,
+ `broadcast` INT DEFAULT 0,
+ `tag` VARCHAR(255),
+ `message` BLOB,
+ PRIMARY KEY (`uid`),
+ KEY `date` (`date`),
+ KEY `path` (`path`),
+ KEY `method_id` (`method_id`),
+ KEY `processing_node` (`processing_node`),
+ KEY `processing` (`processing`),
+ KEY `processing_date` (`processing_date`),
+ KEY `priority` (`priority`),
+ KEY `tag` (`tag`)
+) TYPE = InnoDB;
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_delMessage.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_delMessage.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_delMessage.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_delMessage.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,14 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>uid</params>
+DELETE FROM
+ message_queue
+WHERE
+ uid = <dtml-sqlvar uid type="int">
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_dropMessageTable.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_dropMessageTable.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_dropMessageTable.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_dropMessageTable.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,11 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params></params>
+DROP TABLE message_queue
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_dumpMessageList.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_dumpMessageList.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_dumpMessageList.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_dumpMessageList.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,17 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:0
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>path
+method_id
+processing_node
+priority</params>
+SELECT * FROM
+ message_queue
+ORDER BY
+ uid
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_hasMessage.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_hasMessage.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_hasMessage.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_hasMessage.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,19 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1
+max_cache:100
+cache_time:1
+class_name:
+class_file:
+</dtml-comment>
+<params>path
+method_id</params>
+SELECT count(path) as message_count FROM
+ message_queue
+<dtml-if "path or method_id">
+WHERE
+<dtml-if path> 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>
+
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_processMessage.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_processMessage.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_processMessage.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_processMessage.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,17 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>uid</params>
+UPDATE
+ message_queue
+SET
+ processing_date = <dtml-sqlvar "_.DateTime()" type="datetime">,
+ processing=1
+WHERE
+ uid = <dtml-sqlvar uid type="int">
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readMessage.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readMessage.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readMessage.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readMessage.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,22 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>processing_node
+priority
+to_date</params>
+SELECT * FROM
+ message_queue
+WHERE
+ processing <> 1
+<dtml-if processing_node> 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 to_date> AND date <= <dtml-sqlvar to_date type="datetime"> </dtml-if>
+
+ORDER BY
+ priority, date
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readMessageList.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,21 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>path
+method_id
+processing_node
+priority</params>
+SELECT * FROM
+ message_queue
+WHERE
+ processing <> 1
+<dtml-if processing_node>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>
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readUidList.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readUidList.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readUidList.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_readUidList.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,20 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:10000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>processing_node
+method_id
+path
+to_date</params>
+SELECT uid FROM
+ message_queue
+WHERE
+ processing <> 1
+<dtml-if processing_node> AND processing_node = <dtml-sqlvar processing_node type="int"></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>
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_setPriority.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_setPriority.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_setPriority.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_setPriority.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,20 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>uid
+priority
+date</params>
+UPDATE
+ message_queue
+SET
+ priority = <dtml-sqlvar priority type="int">,
+ processing = 0,
+ date = <dtml-sqlvar date type="datetime">
+WHERE
+ uid = <dtml-sqlvar uid type="int">
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_timeShift.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_timeShift.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_timeShift.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_timeShift.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,21 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>delay
+processing_node</params>
+UPDATE
+ message_queue
+SET
+ date = date - <dtml-sqlvar delay type="int">,
+ processing_date = processing_date - <dtml-sqlvar delay type="int">
+WHERE
+ 1 = 1
+<dtml-if processing_node>
+ AND processing_node = <dtml-sqlvar processing_node type="int">
+</dtml-if>
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_validateMessageList.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_validateMessageList.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_validateMessageList.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_validateMessageList.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,42 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:0
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>method_id
+message_uid
+path
+tag
+</params>
+SELECT
+ COUNT(DISTINCT uid) as uid_count
+FROM
+ message_queue
+WHERE
+ processing_node >= -2
+<dtml-if method_id>
+ AND (
+<dtml-in method_id>
+ method_id = <dtml-sqlvar sequence-item type="string"><dtml-if sequence-end><dtml-else> OR </dtml-if>
+</dtml-in>
+ )
+</dtml-if>
+<dtml-if message_uid>AND uid = <dtml-sqlvar message_uid type="int"> </dtml-if>
+<dtml-if path>
+ AND (
+<dtml-in path>
+ path = <dtml-sqlvar sequence-item type="string"><dtml-if sequence-end><dtml-else> OR </dtml-if>
+</dtml-in>
+ )
+</dtml-if>
+<dtml-if tag>
+ AND (
+<dtml-in tag>
+ tag = <dtml-sqlvar sequence-item type="string"><dtml-if sequence-end><dtml-else> OR </dtml-if>
+</dtml-in>
+ )
+</dtml-if>
Added: spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_writeMessage.zsql
URL: http://svn.erp5.org/spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_writeMessage.zsql?rev=12739&view=auto
==============================================================================
--- spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_writeMessage.zsql (added)
+++ spec/debian/erp5-cmfactivity/CMFActivity/skins/activity/SQLQueue_writeMessage.zsql Thu Feb 15 17:36:19 2007
@@ -1,0 +1,28 @@
+<dtml-comment>
+title:
+connection_id:cmf_activity_sql_connection
+max_rows:1000
+max_cache:100
+cache_time:0
+class_name:
+class_file:
+</dtml-comment>
+<params>path
+method_id
+message
+priority
+broadcast
+processing_node=-1
+date
+tag</params>
+INSERT INTO message_queue
+SET
+ path = <dtml-sqlvar path type="string">,
+ <dtml-if date>date = <dtml-sqlvar date type="string">, <dtml-else>date = <dtml-sqlvar "_.DateTime()" type="datetime">, </dtml-if>
+ method_id = <dtml-sqlvar method_id type="string">,
+ processing_node = <dtml-sqlvar processing_node type="int">,
+ broadcast = <dtml-sqlvar broadcast type="int">,
+ processing = -1,
+ priority = <dtml-sqlvar priority type="int">,
+ tag = <dtml-sqlvar tag type="string">,
+ message = <dtml-sqlvar message type="string">
More information about the Erp5-report
mailing list