[Erp5-dev] start_date on non-movement object

[Łukasz Nowak]

Hello,

On 2008-03-25, 09:37:11
bartek <bartek at erp5.pl> wrote:

(...)
> What are the results of:
> 
> context.portal_catalog(portal_type='Person', price=123, src__=1)
> context.portal_catalog(portal_type='Person', start_date='2001/01/01' 
> src__=1)
> kw = {'portal_type':'Person', 'persondata.start_date':'2001/01/01', 
> 'src__':1}
> context.portal_catalog(**kw)

I've used 'birth_name' as another property on Person object.

Look at attached test.py - script used to create result.txt

I see - it is correctly quering catalog.

But look at this:

mysql> select * FROM persondata;
+------+---------------------+------------+
| uid  | start_date          | birth_name |
+------+---------------------+------------+
| 6599 | 1979-09-12 22:00:00 | young      |
| 6899 | 1939-12-02 23:00:00 | old        |
+------+---------------------+------------+
2 rows in set (0.00 sec)

And it does not matter, if I set start_date from UI or by
object/setStartDate?value=1979/09/13 or
object/setStartDate?value=1939/12/03


From zope those dates are printed with repr in scripts - and they look
correctly in ZODB. So - might it be, that I've created this table not
correctly?

I've attached zsql used to create and catalog values.

Using revision 18850. Thanks for pointing out this testing scenario -
more things become clear.

Regards,
Luke

-- 
Łukasz Nowak R&D Ventis http://www.ventis.com.pl/
tel: +48 32 768 16 85 fax: +48 32 392 10 61
``Use the Source, Luke...'' I am only craftsman.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.py
Type: text/x-python
Size: 1199 bytes
Desc: not available
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20080325/4c5b4b1b/attachment.py>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: result.txt
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20080325/4c5b4b1b/attachment.txt>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: z_catalog_persondata_list.zsql
Type: application/octet-stream
Size: 727 bytes
Desc: not available
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20080325/4c5b4b1b/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: z_create_persondata.zsql
Type: application/octet-stream
Size: 231 bytes
Desc: not available
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20080325/4c5b4b1b/attachment-0001.obj>