[Erp5-report] r11528 - in /erp5/trunk/products/ERP5/bootstrap/erp5_core: CatalogResultTable...
nobody at svn.erp5.org
nobody at svn.erp5.org
Thu Nov 30 11:13:39 CET 2006
Author: seb
Date: Thu Nov 30 11:13:37 2006
New Revision: 11528
URL: http://svn.erp5.org?rev=11528&view=rev
Log:
Add a new sql table: alarm. It will be used to store new alarm date instead of writing each time into the zodb
Added:
erp5/trunk/products/ERP5/bootstrap/erp5_core/SkinTemplateItem/portal_skins/erp5_core/Alarm_zGetAlarmDate.xml
erp5/trunk/products/ERP5/bootstrap/erp5_core/SkinTemplateItem/portal_skins/erp5_core/Alarm_zUpdateAlarmDate.xml
Modified:
erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogResultTableTemplateItem/result_table_list.xml
erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/revision
erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_method_id_list
erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_result_table_list
Modified: erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogResultTableTemplateItem/result_table_list.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogResultTableTemplateItem/result_table_list.xml?rev=11528&r1=11527&r2=11528&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogResultTableTemplateItem/result_table_list.xml (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogResultTableTemplateItem/result_table_list.xml Thu Nov 30 11:13:37 2006
@@ -1,4 +1,5 @@
<key_list>
+ <key>alarm</key>
<key>catalog</key>
<key>category</key>
<key>delivery</key>
Added: erp5/trunk/products/ERP5/bootstrap/erp5_core/SkinTemplateItem/portal_skins/erp5_core/Alarm_zGetAlarmDate.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_core/SkinTemplateItem/portal_skins/erp5_core/Alarm_zGetAlarmDate.xml?rev=11528&view=auto
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_core/SkinTemplateItem/portal_skins/erp5_core/Alarm_zGetAlarmDate.xml (added)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_core/SkinTemplateItem/portal_skins/erp5_core/Alarm_zGetAlarmDate.xml Thu Nov 30 11:13:37 2006
@@ -1,0 +1,175 @@
+<?xml version="1.0"?>
+<ZopeData>
+ <record id="1" aka="AAAAAAAAAAE=">
+ <pickle>
+ <tuple>
+ <tuple>
+ <string>Products.ZSQLMethods.SQL</string>
+ <string>SQL</string>
+ </tuple>
+ <none/>
+ </tuple>
+ </pickle>
+ <pickle>
+ <dictionary>
+ <item>
+ <key> <string>__ac_local_roles__</string> </key>
+ <value>
+ <none/>
+ </value>
+ </item>
+ <item>
+ <key> <string>_arg</string> </key>
+ <value>
+ <object>
+ <klass>
+ <global name="Args" module="Shared.DC.ZRDB.Aqueduct"/>
+ </klass>
+ <tuple/>
+ <state>
+ <dictionary>
+ <item>
+ <key> <string>_data</string> </key>
+ <value>
+ <dictionary>
+ <item>
+ <key> <string>alarm_date</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>uid</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ </dictionary>
+ </value>
+ </item>
+ <item>
+ <key> <string>_keys</string> </key>
+ <value>
+ <list>
+<string>uid</string>
+<string>alarm_date</string>
+ </list>
+ </value>
+ </item>
+ </dictionary>
+ </state>
+ </object>
+ </value>
+ </item>
+ <item>
+ <key> <string>allow_simple_one_argument_traversal</string> </key>
+ <value>
+ <none/>
+ </value>
+ </item>
+ <item>
+ <key> <string>arguments_src</string> </key>
+ <value> <string>uid\r\n
+alarm_date</string> </value>
+ </item>
+ <item>
+ <key> <string>cache_time_</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ <item>
+ <key> <string>class_file_</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>class_name_</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>connection_hook</string> </key>
+ <value> <string></string> </value>
+ </item>
+ <item>
+ <key> <string>connection_id</string> </key>
+ <value> <string>erp5_sql_connection</string> </value>
+ </item>
+ <item>
+ <key> <string>id</string> </key>
+ <value> <string>Alarm_zGetAlarmDate</string> </value>
+ </item>
+ <item>
+ <key> <string>max_cache_</string> </key>
+ <value> <int>100</int> </value>
+ </item>
+ <item>
+ <key> <string>max_rows_</string> </key>
+ <value> <int>1000</int> </value>
+ </item>
+ <item>
+ <key> <string>src</string> </key>
+ <value> <string encoding="cdata"><![CDATA[
+
+SELECT \n
+ alarm_date\n
+FROM\n
+ alarm\n
+WHERE\n
+ uid = <dtml-sqlvar uid type="int">
+
+]]></string> </value>
+ </item>
+ <item>
+ <key> <string>template</string> </key>
+ <value>
+ <object>
+ <klass>
+ <global name="SQL" module="Shared.DC.ZRDB.DA"/>
+ </klass>
+ <none/>
+ <state>
+ <dictionary>
+ <item>
+ <key> <string>__name__</string> </key>
+ <value> <string encoding="cdata"><![CDATA[
+
+<string>
+
+]]></string> </value>
+ </item>
+ <item>
+ <key> <string>_vars</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>globals</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>raw</string> </key>
+ <value> <string encoding="cdata"><![CDATA[
+
+SELECT \n
+ alarm_date\n
+FROM\n
+ alarm\n
+WHERE\n
+ uid = <dtml-sqlvar uid type="int">
+
+]]></string> </value>
+ </item>
+ </dictionary>
+ </state>
+ </object>
+ </value>
+ </item>
+ <item>
+ <key> <string>title</string> </key>
+ <value> <string></string> </value>
+ </item>
+ </dictionary>
+ </pickle>
+ </record>
+</ZopeData>
Added: erp5/trunk/products/ERP5/bootstrap/erp5_core/SkinTemplateItem/portal_skins/erp5_core/Alarm_zUpdateAlarmDate.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_core/SkinTemplateItem/portal_skins/erp5_core/Alarm_zUpdateAlarmDate.xml?rev=11528&view=auto
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_core/SkinTemplateItem/portal_skins/erp5_core/Alarm_zUpdateAlarmDate.xml (added)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_core/SkinTemplateItem/portal_skins/erp5_core/Alarm_zUpdateAlarmDate.xml Thu Nov 30 11:13:37 2006
@@ -1,0 +1,141 @@
+<?xml version="1.0"?>
+<ZopeData>
+ <record id="1" aka="AAAAAAAAAAE=">
+ <pickle>
+ <tuple>
+ <tuple>
+ <string>Products.ZSQLMethods.SQL</string>
+ <string>SQL</string>
+ </tuple>
+ <none/>
+ </tuple>
+ </pickle>
+ <pickle>
+ <dictionary>
+ <item>
+ <key> <string>__ac_local_roles__</string> </key>
+ <value>
+ <none/>
+ </value>
+ </item>
+ <item>
+ <key> <string>_arg</string> </key>
+ <value>
+ <object>
+ <klass>
+ <global name="Args" module="Shared.DC.ZRDB.Aqueduct"/>
+ </klass>
+ <tuple/>
+ <state>
+ <dictionary>
+ <item>
+ <key> <string>_data</string> </key>
+ <value>
+ <dictionary>
+ <item>
+ <key> <string>alarm_date</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>uid</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ </dictionary>
+ </value>
+ </item>
+ <item>
+ <key> <string>_keys</string> </key>
+ <value>
+ <list>
+<string>uid</string>
+<string>alarm_date</string>
+ </list>
+ </value>
+ </item>
+ </dictionary>
+ </state>
+ </object>
+ </value>
+ </item>
+ <item>
+ <key> <string>arguments_src</string> </key>
+ <value> <string>uid\r\n
+alarm_date</string> </value>
+ </item>
+ <item>
+ <key> <string>connection_id</string> </key>
+ <value> <string>erp5_sql_connection</string> </value>
+ </item>
+ <item>
+ <key> <string>id</string> </key>
+ <value> <string>Alarm_zUpdateAlarmDate</string> </value>
+ </item>
+ <item>
+ <key> <string>src</string> </key>
+ <value> <string encoding="cdata"><![CDATA[
+
+REPLACE INTO\n
+ alarm (uid, alarm_date)\n
+VALUES\n
+ (<dtml-sqlvar uid type="int">, <dtml-sqlvar alarm_date type="datetime">)
+
+]]></string> </value>
+ </item>
+ <item>
+ <key> <string>template</string> </key>
+ <value>
+ <object>
+ <klass>
+ <global name="SQL" module="Shared.DC.ZRDB.DA"/>
+ </klass>
+ <none/>
+ <state>
+ <dictionary>
+ <item>
+ <key> <string>__name__</string> </key>
+ <value> <string encoding="cdata"><![CDATA[
+
+<string>
+
+]]></string> </value>
+ </item>
+ <item>
+ <key> <string>_vars</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>globals</string> </key>
+ <value>
+ <dictionary/>
+ </value>
+ </item>
+ <item>
+ <key> <string>raw</string> </key>
+ <value> <string encoding="cdata"><![CDATA[
+
+REPLACE INTO\n
+ alarm (uid, alarm_date)\n
+VALUES\n
+ (<dtml-sqlvar uid type="int">, <dtml-sqlvar alarm_date type="datetime">)
+
+]]></string> </value>
+ </item>
+ </dictionary>
+ </state>
+ </object>
+ </value>
+ </item>
+ <item>
+ <key> <string>title</string> </key>
+ <value> <string></string> </value>
+ </item>
+ </dictionary>
+ </pickle>
+ </record>
+</ZopeData>
Modified: erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/revision
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/revision?rev=11528&r1=11527&r2=11528&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/revision (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/revision Thu Nov 30 11:13:37 2006
@@ -1,1 +1,1 @@
-203
+205
Modified: erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_method_id_list
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_method_id_list?rev=11528&r1=11527&r2=11528&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_method_id_list (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_method_id_list Thu Nov 30 11:13:37 2006
@@ -1,3 +1,4 @@
+erp5_mysql/z0_drop_alarm
erp5_mysql/z0_drop_catalog
erp5_mysql/z0_drop_category
erp5_mysql/z0_drop_compatibility
@@ -22,6 +23,7 @@
erp5_mysql/z0_uncatalog_predicate_category
erp5_mysql/z0_uncatalog_stock
erp5_mysql/z0_uncatalog_subject
+erp5_mysql/z_catalog_alarm_list
erp5_mysql/z_catalog_compatibility_list
erp5_mysql/z_catalog_delivery_list
erp5_mysql/z_catalog_fulltext_list
@@ -39,6 +41,7 @@
erp5_mysql/z_catalog_translation_list
erp5_mysql/z_clear_reserved
erp5_mysql/z_count_results
+erp5_mysql/z_create_alarm
erp5_mysql/z_create_catalog
erp5_mysql/z_create_category
erp5_mysql/z_create_compatibility
Modified: erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_result_table_list
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_result_table_list?rev=11528&r1=11527&r2=11528&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_result_table_list (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_result_table_list Thu Nov 30 11:13:37 2006
@@ -1,5 +1,6 @@
catalog
category
+alarm
delivery
full_text
item
More information about the Erp5-report
mailing list