[Erp5-report] r13572 - in /erp5/trunk/bt5/erp5_banking_core: CatalogMethodTemplateItem/port...

nobody at svn.erp5.org nobody at svn.erp5.org
Thu Mar 22 16:56:42 CET 2007


Author: seb
Date: Thu Mar 22 16:56:05 2007
New Revision: 13572

URL: http://svn.erp5.org?rev=13572&view=rev
Log:
added specific z_create_stock

Added:
    erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.catalog_keys.xml
    erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.xml
Modified:
    erp5/trunk/bt5/erp5_banking_core/bt/revision
    erp5/trunk/bt5/erp5_banking_core/bt/template_catalog_method_id_list

Added: erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.catalog_keys.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.catalog_keys.xml?rev=13572&view=auto
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.catalog_keys.xml (added)
+++ erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.catalog_keys.xml Thu Mar 22 16:56:05 2007
@@ -1,0 +1,5 @@
+<catalog_method>
+ <item key="sql_clear_catalog" type="int">
+  <value>1</value>
+ </item>
+</catalog_method>

Added: erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.xml?rev=13572&view=auto
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.xml (added)
+++ erp5/trunk/bt5/erp5_banking_core/CatalogMethodTemplateItem/portal_catalog/erp5_mysql_innodb/z_create_stock.xml Thu Mar 22 16:56:05 2007
@@ -1,0 +1,212 @@
+<?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/>
+                        </value>
+                    </item>
+                    <item>
+                        <key> <string>_keys</string> </key>
+                        <value>
+                          <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></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>
+              <none/>
+            </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>z_create_stock</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># Host:\n
+# Database: test\n
+# Table: \'stock\'\n
+#\n
+CREATE TABLE `stock` (\n
+  `uid` BIGINT UNSIGNED NOT NULL,\n
+  `node_uid` BIGINT UNSIGNED,\n
+  `section_uid` BIGINT UNSIGNED,\n
+  `payment_uid` BIGINT UNSIGNED,\n
+  `function_uid` BIGINT UNSIGNED,\n
+  `project_uid` BIGINT UNSIGNED,\n
+  `mirror_section_uid` BIGINT UNSIGNED,\n
+  `mirror_node_uid` BIGINT UNSIGNED,\n
+  `resource_uid` BIGINT UNSIGNED,\n
+  `quantity` real ,\n
+  `date` datetime,\n
+  `total_price` real ,\n
+  `portal_type` VARCHAR(255),\n
+  `simulation_state` varchar(255) default \'\',\n
+  `variation_text` VARCHAR(255),\n
+  `sub_variation_text` VARCHAR(255),\n
+  KEY `uid` (`uid`),\n
+  KEY `quantity` (`quantity`),\n
+  KEY `section_uid` (`section_uid`),\n
+  KEY `mirror_section_uid` (`mirror_section_uid`),\n
+  KEY `mirror_node_uid` (`mirror_node_uid`),\n
+  KEY `node_uid` (`node_uid`),\n
+  KEY `payment_uid` (`payment_uid`),\n
+  KEY `function_uid` (`function_uid`),\n
+  KEY `project_uid` (`project_uid`),\n
+  KEY `resource_uid` (`resource_uid`),\n
+  KEY `simulation_state` (`simulation_state`),\n
+  KEY `resource_node_uid` (`resource_uid`, `node_uid`),\n
+  KEY `resource_section_node_uid` (`resource_uid`, `section_uid`, `node_uid`, `simulation_state`)\n
+) TYPE = InnoDB;\n
+</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># Host:\n
+# Database: test\n
+# Table: \'stock\'\n
+#\n
+CREATE TABLE `stock` (\n
+  `uid` BIGINT UNSIGNED NOT NULL,\n
+  `node_uid` BIGINT UNSIGNED,\n
+  `section_uid` BIGINT UNSIGNED,\n
+  `payment_uid` BIGINT UNSIGNED,\n
+  `function_uid` BIGINT UNSIGNED,\n
+  `project_uid` BIGINT UNSIGNED,\n
+  `mirror_section_uid` BIGINT UNSIGNED,\n
+  `mirror_node_uid` BIGINT UNSIGNED,\n
+  `resource_uid` BIGINT UNSIGNED,\n
+  `quantity` real ,\n
+  `date` datetime,\n
+  `total_price` real ,\n
+  `portal_type` VARCHAR(255),\n
+  `simulation_state` varchar(255) default \'\',\n
+  `variation_text` VARCHAR(255),\n
+  `sub_variation_text` VARCHAR(255),\n
+  KEY `uid` (`uid`),\n
+  KEY `quantity` (`quantity`),\n
+  KEY `section_uid` (`section_uid`),\n
+  KEY `mirror_section_uid` (`mirror_section_uid`),\n
+  KEY `mirror_node_uid` (`mirror_node_uid`),\n
+  KEY `node_uid` (`node_uid`),\n
+  KEY `payment_uid` (`payment_uid`),\n
+  KEY `function_uid` (`function_uid`),\n
+  KEY `project_uid` (`project_uid`),\n
+  KEY `resource_uid` (`resource_uid`),\n
+  KEY `simulation_state` (`simulation_state`),\n
+  KEY `resource_node_uid` (`resource_uid`, `node_uid`),\n
+  KEY `resource_section_node_uid` (`resource_uid`, `section_uid`, `node_uid`, `simulation_state`)\n
+) TYPE = InnoDB;\n
+</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/bt5/erp5_banking_core/bt/revision
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/bt/revision?rev=13572&r1=13571&r2=13572&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/bt/revision (original)
+++ erp5/trunk/bt5/erp5_banking_core/bt/revision Thu Mar 22 16:56:05 2007
@@ -1,1 +1,1 @@
-161
+163

Modified: erp5/trunk/bt5/erp5_banking_core/bt/template_catalog_method_id_list
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_banking_core/bt/template_catalog_method_id_list?rev=13572&r1=13571&r2=13572&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_banking_core/bt/template_catalog_method_id_list (original)
+++ erp5/trunk/bt5/erp5_banking_core/bt/template_catalog_method_id_list Thu Mar 22 16:56:05 2007
@@ -3,6 +3,7 @@
 erp5_mysql_innodb/z_catalog_object_list
 erp5_mysql_innodb/z_catalog_stock_list
 erp5_mysql_innodb/z_create_catalog
+erp5_mysql_innodb/z_create_stock
 erp5_mysql_innodb/z_related_default_site
 erp5_mysql_innodb/z_related_destination_payment
 erp5_mysql_innodb/z_related_translated_simulation_state_title




More information about the Erp5-report mailing list