[Erp5-report] r18060 - in /erp5/trunk/products/ERP5/bootstrap/erp5_core: CatalogDateTimeKey...

[nobody at svn.erp5.org]

Author: ivan
Date: Thu Dec  6 15:58:05 2007
New Revision: 18060

URL: http://svn.erp5.org?rev=18060&view=rev
Log:
Define all possible SQL DateTime columns as DateTime Keys. 
This will make sure that if in a query we will render UTC value rather than locat datetime value. That way we will have consistent queries (by default all DateTime values are saved as UTC in ERP5).

Added:
    erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogDateTimeKeyTemplateItem/
    erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogDateTimeKeyTemplateItem/datetime_key_list.xml
Modified:
    erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/revision
    erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_datetime_key_list

Added: erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogDateTimeKeyTemplateItem/datetime_key_list.xml
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogDateTimeKeyTemplateItem/datetime_key_list.xml?rev=18060&view=auto
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogDateTimeKeyTemplateItem/datetime_key_list.xml (added)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_core/CatalogDateTimeKeyTemplateItem/datetime_key_list.xml Thu Dec  6 15:58:05 2007
@@ -1,0 +1,33 @@
+<key_list>
+ <key>alarm.alarm_date</key>
+ <key>alarm_date</key>
+ <key>catalog.creation_date</key>
+ <key>catalog.modification_date</key>
+ <key>creation_date</key>
+ <key>date</key>
+ <key>delivery.start_date</key>
+ <key>delivery.start_date_range_max</key>
+ <key>delivery.start_date_range_min</key>
+ <key>delivery.stop_date</key>
+ <key>delivery.stop_date_range_max</key>
+ <key>delivery.stop_date_range_min</key>
+ <key>inventory.date</key>
+ <key>inventory_stock.date</key>
+ <key>inventory_stock.mirror_date</key>
+ <key>item.date</key>
+ <key>mirror_date</key>
+ <key>modification_date</key>
+ <key>movement.start_date</key>
+ <key>movement.stop_date</key>
+ <key>predicate.start_date</key>
+ <key>predicate.start_date_range_max</key>
+ <key>predicate.start_date_range_min</key>
+ <key>start_date</key>
+ <key>start_date_range_max</key>
+ <key>start_date_range_min</key>
+ <key>stock.date</key>
+ <key>stock.mirror_date</key>
+ <key>stop_date</key>
+ <key>stop_date_range_max</key>
+ <key>stop_date_range_min</key>
+</key_list>

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=18060&r1=18059&r2=18060&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/revision (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/revision Thu Dec  6 15:58:05 2007
@@ -1,1 +1,1 @@
-632
+633

Modified: erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_datetime_key_list
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_datetime_key_list?rev=18060&r1=18059&r2=18060&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_datetime_key_list (original)
+++ erp5/trunk/products/ERP5/bootstrap/erp5_core/bt/template_catalog_datetime_key_list Thu Dec  6 15:58:05 2007
@@ -1,0 +1,31 @@
+alarm.alarm_date
+alarm_date
+catalog.creation_date
+catalog.modification_date
+creation_date
+date
+delivery.start_date
+delivery.start_date_range_max
+delivery.start_date_range_min
+delivery.stop_date
+delivery.stop_date_range_max
+delivery.stop_date_range_min
+inventory.date
+inventory_stock.date
+inventory_stock.mirror_date
+item.date
+mirror_date
+modification_date
+movement.start_date
+movement.stop_date
+predicate.start_date
+predicate.start_date_range_max
+predicate.start_date_range_min
+start_date
+start_date_range_max
+start_date_range_min
+stock.date
+stock.mirror_date
+stop_date
+stop_date_range_max
+stop_date_range_min