- Zope - Zope lists

Re: [Zope] Zope Recordset Object
by jpenny＠ykksnap-america.com 16 Jun '06

16 Jun '06

http://mail.zope.org/pipermail/zope-dev/1999-September/001414.html The only auxiliary structure I ever use is names, i.e. n2i = {} res = container.foo_zsql() nms = res.names() for i in range(len(nms)): n2i[nms[i]] = i Then I can address by name as in res[i][n2i['column_name']] jim > Hello, > I have a ZSQL Method, which is called by my python > script. > However, I am curious as to what type of object is > returned when that call is made. > It's some sort of a recordset (or resultset) object > that behaves like a list...it doesn't seem to be a > dictionary object though, but I can't find any object > reference on it. I tried using rs.keys() but it says > that method doesn't exist in that class. > Does anyone have a member function list (object > reference ) that's associated with this resultset or > can tell me what kind of object is returned? > I gave up on google, couldn't find anything on it. > > Thank you in advance! >

1 0

Zope Recordset Object
by Alric Aneron 16 Jun '06

16 Jun '06

Hello, I have a ZSQL Method, which is called by my python script. However, I am curious as to what type of object is returned when that call is made. It's some sort of a recordset (or resultset) object that behaves like a list...it doesn't seem to be a dictionary object though, but I can't find any object reference on it. I tried using rs.keys() but it says that method doesn't exist in that class. Does anyone have a member function list (object reference ) that's associated with this resultset or can tell me what kind of object is returned? I gave up on google, couldn't find anything on it. Thank you in advance! __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

3 2

Efficiency of "Script (Python)" versus External Method
by Andrew Hedges 16 Jun '06

16 Jun '06

Is there a difference in the efficiency of a function as a "Script (Python)" Zope object versus an External Method? The use case is that I need to run a fairly simple function (an implementation of the Levenshtein distance algorithm) over a result set in the range of 30-40k records. Are the two implementations close enough that I should just not worry about it or would you expect I would see a significant difference between the two? Thanks, -Andrew ----- andrew(a)clearwired.com / http://clearwired.com

2 1

allow access to fileobject depending on role
by leandros van den berg 15 Jun '06

15 Jun '06

Hello, I'm having trouble with the precondition field of a fileobject. I've got a fileobject (a PDF-file) and its precondition field states myPrecondition, which is a DTML Method and its code is: <dtml-with "REQUEST['PARENTS'][0]"> <dtml-if expr="_.SecurityGetUser().has_role(['Bobo']) != 1"> <dtml-raise Unauthorized></dtml-raise> </dtml-if> </dtml-with> (source: http://www.zopelabs.com/cookbook/1016369692) The PDF-file should only be displayed when an user has role Bobo. If the user doesn't have the role, an user authentication screen (login screen) is displayed. The Method only works when the browser cache is empty or the file hasn't been openend yet by an user with Bobo-role. I'll explain the situations, both are on localhost. Situation I: - Browser cache is empty. - User without Bobo-role logs in and opens the PDF-file by entering its URL in the browser and gets the login screen. So far so good. Situation II: - User with Bobo-role logs in and opens the PDF-file by entering its URL in the browser and the file is being displayed. - Close browser. - User without Bobo-role logs in and opens the PDF-file by entering its URL in the browser and the file is being displayed. Not so good. The user without Bobo-role in situation II should get a login screen. Apparently because the file is in the browser cache, the user is authenticated. Does anybody know a solution to this problem or some other solution for allowing access to a fileobject depending on the role an user has? Note: Using the security setting and assigning roles is not an option because the fileobject is recreated every night. Kind regards, Leandros -- The Netherlands

4 5

debug with ipython
by thomas desvenain 15 Jun '06

15 Jun '06

hello, is it possible to use zopectl debug with ipython ? if yes, how ? thanks thomas

3 3

ERROR Zope Could not import Products.ZMySQLDA
by Jeremiah Foster 15 Jun '06

15 Jun '06

Hello, I am trying to get Zope to connect to a MySQL database. I am having trouble tracking down why it will not connect. The error message on the web page produces only six hits in Google; http://www.google.com/search?q=The+database+connection +MySQL_database_connection+cannot+be +found.&start=0&ie=utf-8&oe=utf-8&client=firefox&rls=org.mozilla:en-US:unofficial Here is the Zope debugging error message from zopectl fg; (Complete debugging information is below.) ImportError: cannot import name ImmutableSet Does anyone have any recommendations on how I can solve this? Thanks very much, Jeremiah Complete debugging output: -------------------------------- /usr/local/www/zopeserver/bin/runzope -X debug-mode=on 2006-06-14 16:14:53 INFO ZServer HTTP server started at Wed Jun 14 16:14:53 2006 Hostname: 0.0.0.0 Port: 8080 2006-06-14 16:14:53 INFO Zope Set effective user to "zope" 2006-06-14 16:14:53 INFO DocFinderTab Applied patch version 0.5.2. 2006-06-14 16:14:53 INFO IngeniWeb NOTICE global_symbols.py:22:Wed Jun 14 16:14:53 2006: 'Starting /usr/local/www/zopeserver/Products/GroupUserFolder at 4 debug level' /usr/local/www/Zope28/lib/python/OFS/Application.py:695: DeprecationWarning: Non-ASCII character '\xe1' in file /usr/local/www/zopeserver/Products/Localizer/__init__.py on line 1, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details product=__import__(pname, global_dict, global_dict, silly) /usr/local/www/zopeserver/Products/Localizer/__init__.py:161: SyntaxWarning: argument named None def evaluateText(self, expr, None=None): /usr/local/www/zopeserver/Products/Localizer/__init__.py:97: DeprecationWarning: Non-ASCII character '\xe1' in file /usr/local/www/zopeserver/Products/Localizer/Accept.py on line 2, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details from Accept import AcceptCharset, AcceptLanguage /usr/local/www/zopeserver/Products/Localizer/__init__.py:285: DeprecationWarning: Non-ASCII character '\xe1' in file /usr/local/www/zopeserver/Products/Localizer/Localizer.py on line 2, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details import Localizer, LocalContent, MessageCatalog, LocalFolder /usr/local/www/zopeserver/Products/Localizer/Localizer.py:35: DeprecationWarning: Non-ASCII character '\xe1' in file /usr/local/www/zopeserver/Products/Localizer/LocalFiles.py on line 2, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details from LocalFiles import LocalDTMLFile /usr/local/www/zopeserver/Products/Localizer/LocalFiles.py:34: DeprecationWarning: Non-ASCII character '\xe1' in file /usr/local/www/zopeserver/Products/Localizer/Utils.py on line 2, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details from Utils import lang_negotiator /usr/local/www/zopeserver/Products/Localizer/Localizer.py:36: DeprecationWarning: Non-ASCII character '\xe1' in file /usr/local/www/zopeserver/Products/Localizer/MessageCatalog.py on line 2, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details from MessageCatalog import MessageCatalog /usr/local/www/zopeserver/Products/Localizer/MessageCatalog.py:39: DeprecationWarning: Non-ASCII character '\xe9' in file /usr/local/www/zopeserver/Products/Localizer/zgettext.py on line 4, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details from zgettext import parse_po_file /usr/local/www/zopeserver/Products/Localizer/MessageCatalog.py:41: DeprecationWarning: Non-ASCII character '\xe1' in file /usr/local/www/zopeserver/Products/Localizer/LanguageManager.py on line 2, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details from LanguageManager import LanguageManager /usr/local/www/zopeserver/Products/Localizer/LanguageManager.py:33: DeprecationWarning: Non-ASCII character '\xe1' in file /usr/local/www/zopeserver/Products/Localizer/Gettext.py on line 2, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details from Gettext import dummy as N_ /usr/local/www/zopeserver/Products/Localizer/__init__.py:285: DeprecationWarning: Non-ASCII character '\xe1' in file /usr/local/www/zopeserver/Products/Localizer/LocalContent.py on line 2, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details import Localizer, LocalContent, MessageCatalog, LocalFolder /usr/local/www/zopeserver/Products/Localizer/LocalContent.py:33: DeprecationWarning: Non-ASCII character '\xe1' in file /usr/local/www/zopeserver/Products/Localizer/LocalPropertyManager.py on line 2, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details from LocalPropertyManager import LocalPropertyManager, LocalProperty /usr/local/www/zopeserver/Products/Localizer/LocalPropertyManager.py:36: DeprecationWarning: Non-ASCII character '\xe1' in file /usr/local/www/zopeserver/Products/Localizer/LocalAttributes.py on line 2, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details from LocalAttributes import LocalAttribute, LocalAttributesBase /usr/local/www/zopeserver/Products/Localizer/__init__.py:285: DeprecationWarning: Non-ASCII character '\xe1' in file /usr/local/www/zopeserver/Products/Localizer/LocalFolder.py on line 2, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details import Localizer, LocalContent, MessageCatalog, LocalFolder /usr/local/www/zopeserver/Products/Localizer/__init__.py:288: DeprecationWarning: Non-ASCII character '\xe1' in file /usr/local/www/zopeserver/Products/Localizer/GettextTag.py on line 2, but no encoding declared; see http://www.python.org/peps/pep-0263.html for details from GettextTag import GettextTag 2006-06-14 16:14:53 INFO QuickLinks Patch manage_main to work with QuickLinks 2006-06-14 16:14:54 ERROR Zope Could not import Products.ZMySQLDA Traceback (most recent call last): File "/usr/local/www/Zope28/lib/python/OFS/Application.py", line 695, in import_product product=__import__(pname, global_dict, global_dict, silly) File "/usr/local/www/zopeserver/Products/ZMySQLDA/__init__.py", line 91, in ? import DA File "/usr/local/www/zopeserver/Products/ZMySQLDA/DA.py", line 92, in ? from db import DB File "/usr/local/www/zopeserver/Products/ZMySQLDA/db.py", line 99, in ? from MySQLdb.converters import conversions File "/usr/local/lib/python2.3/site-packages/MySQLdb/__init__.py", line 34, in ? from sets import ImmutableSet ImportError: cannot import name ImmutableSet Traceback (most recent call last): File "/usr/local/www/Zope28/lib/python/Zope2/Startup/run.py", line 56, in ? run() File "/usr/local/www/Zope28/lib/python/Zope2/Startup/run.py", line 21, in run starter.prepare() File "/usr/local/www/Zope28/lib/python/Zope2/Startup/__init__.py", line 98, in prepare self.startZope() File "/usr/local/www/Zope28/lib/python/Zope2/Startup/__init__.py", line 257, in startZope Zope2.startup() File "/usr/local/www/Zope28/lib/python/Zope2/__init__.py", line 47, in startup _startup() File "/usr/local/www/Zope28/lib/python/Zope2/App/startup.py", line 44, in startup OFS.Application.import_products() File "/usr/local/www/Zope28/lib/python/OFS/Application.py", line 672, in import_products import_product(product_dir, product_name, raise_exc=debug_mode) File "/usr/local/www/Zope28/lib/python/OFS/Application.py", line 695, in import_product product=__import__(pname, global_dict, global_dict, silly) File "/usr/local/www/zopeserver/Products/ZMySQLDA/__init__.py", line 91, in ? import DA File "/usr/local/www/zopeserver/Products/ZMySQLDA/DA.py", line 92, in ? from db import DB File "/usr/local/www/zopeserver/Products/ZMySQLDA/db.py", line 99, in ? from MySQLdb.converters import conversions File "/usr/local/lib/python2.3/site-packages/MySQLdb/__init__.py", line 34, in ? from sets import ImmutableSet ImportError: cannot import name ImmutableSet

3 2

Re: [Zope] ERROR Zope Could not import Products.ZMySQLDA
by Jonathan 15 Jun '06

15 Jun '06

Please keep your posts on the list... ----- Original Message ----- From: "Jeremiah Foster" <jeremiah.foster(a)theclickstore.se> To: "Jonathan" <dev101(a)magma.ca> Sent: Wednesday, June 14, 2006 10:43 AM Subject: Re: [Zope] ERROR Zope Could not import Products.ZMySQLDA > On Wed, 2006-06-14 at 10:29 -0400, Jonathan wrote: >> ----- Original Message ----- >> From: "Jeremiah Foster" <jeremiah.foster(a)theclickstore.se> > >> > ImportError: cannot import name ImmutableSet > >> 1) make sure you installed ZMySQLDA using the same version of python that >> your Zope installation uses (it looks like you are using Zope 2.8.x so >> you >> should be using python 2.3.4 or 2.3.5) > > > I have made sure to use python2.3 when I compiled. I specified the full > path just to make sure. :) Did you use python 2.3 or python 2.3.4 (or 2.3.5)? This may make a difference. Is the ZMySQLDA product installed ok? Check the icon in the ZMI - Control Panel - Product Management folder (it should not show a broken product icon). You can also check the ZMI - Add list, there should be a 'Z MySQL Database Connection' entry in the list. Jonathan

3 2

Re: [Zope] filter messages at startup
by thomas desvenain 15 Jun '06

15 Jun '06

i mean i would like to filter warning/error messages that appears in console when starting zope server or debugger in order to ignore those i'm not interested with for the moment for instance : [root@biow3 tests]# /zope/test/bin/zopectl debug Starting debugger (the name "app" is bound to the top-level Zope object) 2006-06-13 13:48:34 WARNING Init Class Products.CMFCore.PortalContent.PortalContent has a security declaration for nonexistent method 'manage_FTPget' 2006-06-13 13:48:34 WARNING Init Class Products.CMFCore.PortalContent.PortalContent has a security declaration for nonexistent method 'manage_FTPget' etc 2006/6/13, Andreas Jung <lists(a)zopyx.com>: > > > > --On 13. Juni 2006 11:28:51 +0200 thomas desvenain > <thomas.desvenain(a)gmail.com> wrote: > > > hello, > > > > is it possible to filter messages at zope startup/debug, as we can do > with > > logs ? > > > > What does that mean? What is the usecase? > > -aj > > -- > ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany > Web: www.zopyx.com - Email: info(a)zopyx.com - Phone +49 - 7071 - 793376 > E-Publishing, Python, Zope & Plone development, Consulting > > >

6 11

sessions in an iframe
by henk laloli 14 Jun '06

14 Jun '06

Hello, I am using a session object to store a query string. The query string is used for a reload of the same query with two parameters changing their value when the user reorders a table column. This works fine under Zope 2.9.3 in Mozilla. The page on which this query string is stored en taken up again is in an iframe. The iframe html resides on a Zope server, the parents website's computer is a different one, but in the same domain. Now under Firefox the session object still can be referenced, but in Internet Explorer the page in the iframe does not reference the session object properly. It once records it and then adds the changing parameters to it,doubling them and making the SQL query run into an error. The url is: http://www.volkstellingen.nl/nl/gemeenten/ where after a search you can reorder table columns by clicking on the headers. The problem does not occur in IE when the page is used on its own, only when it is used in an iframe. The question then is: can it be that IE restricts the session behaviour in this situation? How can I solve it? Here is the code in a PythonScript, that is called in the search results html page. directionDict = {'gemeente':'gm_direction','provincie':'prov_direction', 'begindatum':'bd_direction','einddatum':'ed_direction','amsterdamse_code':'ac_direction'} if request.SESSION.has_key('firstquery'): if request.has_key('sort'): #user sorts column without a new query if request.richting == 'ASC': value = directionDict[request.sort] request.set(value, 'DESC') #put all other columns on ASC for k,v in directionDict.items(): if k != request.sort: request.set(v, 'ASC') else: value = directionDict[request.sort] #put all columns on ASC for v in directionDict.itervalues(): request.set(v, 'ASC') else: #user does a new query, session object exists del request.SESSION['firstquery'] query = request.QUERY_STRING first = request.SESSION['firstquery']=query for v in directionDict.itervalues(): request.set(v, 'ASC') else: #first query query = request.QUERY_STRING first = request.SESSION['firstquery']=query for v in directionDict.itervalues(): request.set(v, 'ASC') -- Henk Laloli

2 3

Zope will not allow access after IP address change
by Jeremiah Foster 14 Jun '06

14 Jun '06

Hello, I cannot seem to access the zope management interface on one of our machines after we moved it to another ISP. All the software is the same, the machine is the same, the only things changed are; 1. /etc/hosts 2. hostname 3. IP address Is there some security or other mechanism in zope that prevents zope from starting? Thanks, Jeremiah

4 9