- Zope - Zope lists

Still. Zope date datatype and TimeZone formatting problems.
by Felipe Barousse Boue 26 May '05

26 May '05

Zopistas: I am experiencing the same problem you described by Mr. Hong Yuan in his post a few from last March. I have Zope 2.7.4, python 2.3.4 and PostgreSQL 8.0 and psycopg as DB adapter. All my dates stores in postgresql are WITHOUT timezone and my linux is set for the "America/Mexico City" time zone. All works fine at the OS and python level but not within Zope, it behaves as Mr. Hong Yuan describes in the post. I have noticed that Zope, when getting the data coming from postgresql (the date) always takes it to be at midnight in GMT time zone. While formatting the date for presentation, it doesn't take into account the OS TZ settings, it just assumes data (from postgresql) is at midnight in GMT and mangles it. If the TZ variable is set on the zope.conf file, it actually adds hours to the date (as like moving east), having first during the day having the "date ok" but a wrong time and, later on the day, the date goes wrong because of that timezone difference. If the TZ is not set in the zope.conf file it substracts hours from the date data from postgresql, effectively moving the date on day before, because it assumed midnight GMT. Doing further experiments I have noticed that when the data type passed to Zope is "date" (not "datetime" or "timespamp", only date) then Zope misbehaves with the TZ, assuming it is on GMT and not taking into account the overall system (Operating system) time zone settings. I have seen posts discussing this issue as far back as 2001. Has it been solved already ? Is it worth getting into the Zope code and trying to fix it and submit a patch ? Or its already deprecated ? or...? I believe it is still a huge bug the the Zope/Python date time handling routines, I am correct with this appreciation? Any comments are most than welcome. Felipe > Dieter Maurer wrote: > > >Hong Yaun wrote at 2005-3-14 21:43 +0800: > > > > > >>... > >>However, I find that strftime returns a value that is not the same time > >>as the original one, very likely due to some behind-scene timezone > >>adjustment, which I don't understand and don't know how to control. The > >>following PythonScript code is an illustration of my problem: > >> > >> > > > >A bug recently discussed some time ago in the mailing > >list. Please search the archive... > > > > > > > Thanks Dieter for the pointers. After reading through the thread and the > DateTime code, I finally find that this is a different bug. > > My Linux server has its local time zone set to Asia/Shanghai, which has > the abbreviation 'CST', standing for China Standard Time (GMT+8). > > ws1:~# date > Thu Mar 17 17:54:08 CST 2005 > > Unfortunately, the same abbreviation is also used for US Central > Standard Time (GMT-6) and zope takes this as the default. So in python I > get the following test results: > > >>> from DateTime import DateTime > >>> a = DateTime('2005-01-01 17:00') > >>> a > DateTime('2005/01/01 17:00:00 US/Central') > >>> a.strftime('%Y-%m-%d %H:%M:%S %Z') > '2005-01-02 07:00:00 CST' > > In zope version prior to 2.7.4, DateTime.strftime doesn't respect > timezone, so I did't see the error in my application. After upgrade to > 2.7.4 however, the difference surfaced. > > By the way, this only happens when I am initializing DateTime object > from a string, e.g. from a timestamp field in database. When DateTime is > constructed with the system time, the error doesn't occur: > >>> a=DateTime() > >>> a > DateTime('2005/03/17 17:42:36.380 US/Central') > >>> a.strftime('%Y-%m-%d %H:%M:%S %Z') > '2005-03-17 17:42:36 CST' > > How can I fix this? > > -- > HONG Yuan > Homemaster Trading Co., Ltd. > No. 601, Bldg. 41, 288 Shuangyang Rd. (N) > Shanghai 200433, P.R.C. > Tel: +86 21 55056553 > Fax: +86 21 55067325 > E-mail: hongyuan at homemaster.cn

5 5

Using LocalFs in a form embedded in our application
by Simon ALEXANDRE 25 May '05

25 May '05

Hi, We are developing a web based application using Zope as webserver. One of our expected features consists in uploading a zip file on the server and after that to unzip it. Our pages are designed using zpt. I would like to include in one of my pages a simple form allowing to select a file in the client machine and to upload it on the server (in a dedicated directory, not in the zope DB). I have installed LocalFS. I try with a form like that in my code (copy/paste from the source code provided by localFS in zope): <form action="manage_upload" method="post" enctype="multipart/form-data"> <input type="file" name="file" size="25"/> <input class="form-element" type="submit" value="Add"/> </form> But nothing happen when I clic on the 'add' button. No upload, no error. NB: this form is encapsulated in a macro (already encapsulated in a form), is it the cause of the problem? Someone have an idea?? Thanks in advance Here is the source code of the macro which encapsulates the form: ---------- <tr metal:define-macro="Macro_ImportFileSystem"> <td colspan=5> <table cellspacing=0 cellpadding=0 width="100%" align="center"> <tr height="10px"><td/></tr> <tr> <td align="center"> <table cellpadding=0 cellspacing=0 width="350px" align="center" tal:define="paths here/GetCurrentFolderContent"> <tr><td colspan=3>Files and/or folders to import<img src="Images/Mandatory"/></td></tr> <tr height="3px"><td colspan=3/></tr> <tr height="1px" bgcolor="#CCFF60"><td colspan=3/></tr> <tr height="25px"> <td colspan=3> <input type="image" src="Images/ParentFolder" name="gui_OnChdirpp" style="border-width: 0;background-color:#FFFFFF;width: auto;height: auto" tal:condition="python: (session['projectCurrentFolder'] not in ('/', '\\')) and (session['user'] != 'anon')"/>  You are in <span tal:replace="session/projectCurrentFolder">Current dir</span> </td> </tr>  <tr> <form action="manage_upload" method="post" enctype="multipart/form-data"> <input type="file" name="file" size="25"/> <input class="form-element" type="submit" value="Add"/> </form> </tr>  <tr tal:repeat="path paths"> <span tal:define="rowBgColor python:here.Shared.GetInfo('rowColor', paths.index(path))"> <td tal:define="pathType python: here.GetPathType(path[0])" tal:condition="python: session['user'] != 'anon'"> <input type="image" style="border-width: 0;background-color:#FFFFFF;width: auto;height: auto" tal:condition="python: pathType == 'Folder'" tal:attributes="src python: 'Images/%s' % pathType; name python: 'gui_OnChdir_%s' % path[0]"> <img tal:condition="python: pathType != 'Folder'" tal:attributes="src python:'Images/%s' % pathType"/> </td> <td tal:attributes="bgcolor rowBgColor"> <input type="checkbox" tal:attributes="style python:'border-width: 0;;background-color:%s' % here.Shared.GetInfo('rowColor', paths.index(path)); checked python:here.IsInImportInfo(path[0]); name python:'cbfc_'+path[0]; disabled python:session['user'] == 'anon'"> </td> <td tal:attributes="bgcolor rowBgColor" tal:condition="python: path[1]" tal:content="python: path[0]" width="100%"> </td> <td tal:attributes="bgcolor rowBgColor" tal:condition="python: not path[1]" tal:content="python: path[0] + ' [removed]' " width="100%"> </td> </span> </tr> <tr tal:condition="not: paths"> <td colspan=3><i>The folder is empty.</i> </td> </tr> <tr height="3px"><td colspan=3/></tr> <tr height="1px" bgcolor="#CCFF60"><td colspan=3/></tr> <tr tal:condition="python: session['mode'] == 'Update'"> <td colspan=3 align="right">Do not update files and folders  <input type="checkbox" name="pjIgnorePaths" style="border-width: 0;background-color:#FFFFFF" tal:attributes="checked session/projectKeepOriginalInfo; disabled python:session['user'] == 'anon'"> </td> </tr> </table> </td> </tr> </table> </td> </tr> Simon ALEXANDRE

2 1

RE: [Zope] Underscoring Inaugural Address
by Dan Pozmanter 25 May '05

25 May '05

Hey, I am working on a subversion interface for zope, and our repositories are rife with files like "__init__.py". I ended up using the query string work around (but just for files). Best, Dan -----Original Message----- From: Chris Withers [mailto:chris@simplistix.co.uk] Sent: Tuesday, May 24, 2005 8:46 AM To: Dan Pozmanter Cc: Paul Winkler; zope(a)zope.org Subject: Re: [Zope] Underscoring Inaugural Address Dan Pozmanter wrote: > Is sort of do, since the final object is a wrapper around a unique path. > > What about messing aroound with the url? > > Is there a way to have it show: > > http://foo.com/__init__.py > Maybe I missed something, but why are you intent on serving such bizare urls? cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk

2 1

Hiding HTML URL
by Allen Huang 25 May '05

25 May '05

I just want to show my root URL address whenever people browse into other pages of my site. How do I do this in dtml or python script or external method?? --------------------------------- Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more.

7 11

How to use ParsedXML
by Jason Leach 25 May '05

25 May '05

hi, If I have a ParsedXML document with the following: <?xml version="1.0"?> <faq title="A Sample FAQ"> <entry> <question>To be or not to be?</question> <answer>That is the question.</answer> </entry> <entry> <question>The question of life the universe and everything?</question> <answer>42</answer> </entry> </faq> >From a page template, how to I access the questions and answers? So I can start displaying the XML document content. I tried various forms of: <p tal:content="here/myxmldoc/entry/question"></p> I'd also like to use it through acquisition if possible. Make a method that views and entry and then call in on my document? But no luck. Thanks, Jason.

2 1

ZSyncer and ZEO
by Dennis Allison 25 May '05

25 May '05

Does ZSyncer have any problem with Zope/ZEO systems? I have some anecdotal evidence of problems as we migrate to a multiheaded Zope/ZEO systems architecture. Is there any difficult using ZSyncer between a Zope and a Zope/ZEO combination. Are there problems syncing between Zope 2.6.X and Zope 2.7.X systems? All the systems run ZSyncer 0.5.1.

4 11

ZODB question
by Pascal Peregrina 25 May '05

25 May '05

Hi, In a Zope / Zeo configuration (2.7.6), is there a way, on the Zope instance, to know when the database (Zeo) was last packed ? Thanks. Pascal ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************

4 3

No ZMI - panic!!!!
by John Poltorak 25 May '05

25 May '05

I'm trying to update a Zope site which I set up some time ago but can't get the ZMI to start up. Any ideas on what to do? When I try to acccess http://mysite:8080/ I get - Zope Site Error. How do I force a login prompt or include a login in the URL? If this is a FAQ, please tell me which Q to look under. -- John

2 1

newbie question
by Barry Drake 25 May '05

25 May '05

I'm getting an error in CMFCore.utils in the _mergedLocalRoles function. The error is: Exception Type TypeError Exception Value can only concatenate tuple (not "list") to tuple I modify utils.py, after saving a copy, in order to obtain diagnostic output. Then I delete utils.pyc, after saving a copy, in order to force a recompile (even used compilezpy.py for this a couple of times). Zope never seems to use the new version. Also, I added comments ahead of the line where the error occurs so that the line number should be higher than the original error line number. But, it's always the same. I suspect that I have a fundamental misunderstanding of how Zope uses code in the Products directory. Is Zope storing all the compiled byte code in the data.fs file? Is there a way to force Zope to use new code? Also, the previous developer removed the Control Panel putting Plone as the root of everything. How can I get information that the Control Panel usually provides? System: Zope 2.7.1, Plone 2.0.5, Python 2.3.4, Red Hat 7.2 Thank you. Barry Drake The traceback: Traceback (innermost last): Module ZPublisher.Publish, line 101, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 39, in call_object Module Products.CMFFormController.ControllerPageTemplate, line 80, in __call__ Module Products.CMFFormController.BaseControllerPageTemplate, line 39, in _call Module Products.CMFFormController.ControllerBase, line 243, in getNext Module Products.CMFFormController.Actions.TraverseTo, line 36, in __call__ Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 39, in call_object Module Products.CMFFormController.ControllerPythonScript, line 159, in __call__ Module Shared.DC.Scripts.Bindings, line 306, in __call__ Module Shared.DC.Scripts.Bindings, line 343, in _bindAndExec Module Products.PythonScripts.PythonScript, line 323, in _exec Module None, line 19, in pag_edit - <ControllerPythonScript at /Plone/pag_edit used for /Plone/Members/bldrake/privLinks.pag> - Line 19 Module Products.CMFDefault.Document, line 192, in edit Module Products.CMFCore.CMFCatalogAware, line 69, in reindexObject Module Products.CMFCore.CatalogTool, line 262, in reindexObject Module Products.CMFCore.CatalogTool, line 235, in catalog_object Module Products.ZCatalog.ZCatalog, line 528, in catalog_object Module Products.ZCatalog.Catalog, line 381, in catalogObject Module Products.PluginIndexes.common.UnIndex, line 240, in index_object Module Products.PluginIndexes.KeywordIndex.KeywordIndex, line 61, in _index_object Module Products.PluginIndexes.KeywordIndex.KeywordIndex, line 94, in _get_object_keywords Module Products.CMFCore.CatalogTool, line 63, in allowedRolesAndUsers THE FOLLOWING ERROR SHOULD BE ON LINE 216 NOW, BUT HASN'T MOVED FROM THE ORIGINAL. Module Products.CMFCore.utils, line 215, in _mergedLocalRoles TypeError: can only concatenate tuple (not "list") to tuple

3 2

RE: [Zope] Re: Modifying __bases__
by Dan Pozmanter 25 May '05

25 May '05

Yes, this definitely makes sense. Which is why monkey patching is never used lightly, but also why clean code and good documentation are so necessary. Any code is difficult to maintain when it is murky, undocumented, and the developer lacks the relevant historical background. In any case, I'll pass this on to the fellow who is muddling about with User Objects. Many Thanks, Dan -----Original Message----- From: zope-bounces+dan=siteworx.com(a)zope.org [mailto:zope-bounces+dan=siteworx.com@zope.org] On Behalf Of Derrick Hudson Sent: Wednesday, May 25, 2005 9:55 AM To: zope(a)zope.org Subject: [Zope] Re: Modifying __bases__ On Fri, May 20, 2005 at 05:10:30PM -0400, Dan Pozmanter wrote: | Out of curiosity, I've noticed the word "evil" attached to patching of | various and monkey kinds. Not "bad", or "unwise", but "evil", | implying a morality associated with the act. I think it is used mainly to give added emphasis to lessons learned from painful experience. As Paul reported, hours can be wasted tracing the wrong code trying to understand what is happening. | What is morally wrong with modifying live objects in a dynamic | language to achieve desired functionality? The problem is maintainability. When you dynamically rewrite the code, the code is then very difficult to follow, verify, and modify. It is even harder for someone else to maintain the code because they don't have the historical background to rememeber where , what and why the code is dynamically changed. | The idea is "I want to modify the zope core in a way that survives | version to version, yet does not impose a specific use case on all | zope users". The good pattern for handling this is to create a new class that extends the core classes that provide almost the functionality you want. Then, in your part of the database, create an instance of your class instead of the built-in core class. Specifically for your case, extend the basic UserFolder class to create instances of your custom User class instead of the built-in one. It would be good if the UserFolder allowed you to parameterize it so you could simply say "use this User class", but in the absence of that foresight, you can extend the UserFolder clas. HTH, -D -- Whoever loves discipline loves knowledge, but he who hates correction is stupid. Proverbs 12:1 www: http://dman13.dyndns.org/~dman/ jabber: dman(a)dman13.dyndns.org

1 0