March 2007 - Zope - Zope lists

need help to solve zgadfly database issue
by mukhtar wani 15 Mar '07

15 Mar '07

Hi Every Body, CASE 1. 1) I have created one page template which contains one form after submit i inserted the form values in to zgadfly database table as given below Using External Methods. connection = gadfly.gadfly(dbName,dbPath) cursor = connection.cursor() cursor.execute("insert into tablename(....)) connection.commit() connection.close() 2) Now to read this information i created . i) Z SQL Method ii) Z Search Interface. (used page template option) But when i view the page it is not showing the valuse which i have recently inserted, i need to restart the ZOPE server to get these changes reflected. What i mean i Z SQL there is statement "select * from table" but without zestarting the server it is not pulling the valuse inserted in tables. CASE 2. now i tried second option to read data from tables. instead of creating page template, i wrote External Method, in which i created html page systax like this connection = gadfly.gadfly(dbName,dbPath) cursor = connection.cursor() cursor.execute("select * from table_name) rc=cursor.fetchall() connection.commit() connection.close() return rc if i visit the page, zope is hanging, on status bar it is showing messahe waiting........... did any body face this problem , and can help me. for both operations i am using External Methods. Thanks in advance Mukhtar ____________________________________________________________________________________ Bored stiff? Loosen up... Download and play hundreds of games for free on Yahoo! Games. http://games.yahoo.com/games/front

2 1

how to do this?
by javi lopez 15 Mar '07

15 Mar '07

Hello everyone and thaks for your help: I have this things: Zdatabase Conection zsql method Controller page template(form) Controller python script(call zsql method) controller validator page template it´s a form, it stores email and comments in database and it works. I need put all this inside a product i did, and when I have to push a button from a page template (of the product), show me the form, i fill in it, and it stores data in db. Can i do it?Can you help me please?Thanks

2 1

Get paid for spending your summer improving Zope!
by Philipp von Weitershausen 15 Mar '07

15 Mar '07

The Zope Foundation has been accepted as a mentoring organization in this year's Google Summer of Code project. That means chosen students who want to hack on one of the Zope projects (Zope 2, Zope 3, ZODB, CMF, grok, ...) this coming summer will get paid USD 4,500 if they successfully complete a project. What can you work on? --------------------- See project suggestions at http://wiki.zope.org/zope3/SummerOfCode2007. You may also come up with your own suggestions. Who can apply? -------------- Anybody eligible for the GSoC program. See http://code.google.com/support/bin/answer.py?answer=60279&topic=10730. How do I apply? --------------- You may apply until March 24th through the GSoC webapp. See http://code.google.com/support/bin/answer.py?answer=60306&topic=10727 for more info. If you have any questions, feel free to ask questions on the gsoc(a)zope.org (http://mail.zope.org/mailman/listinfo/gsoc) mailinglist. -- http://worldcookery.com -- Professional Zope documentation and training

1 0

Re: [Zope] adding files and folder in a object during generation
by Allen Huang 15 Mar '07

15 Mar '07

Could anyone give me any examples? ----- Original Message ---- From: Andreas Jung <lists(a)zopyx.com> To: Allen Huang <swapp0(a)yahoo.com>; Zope <zope(a)zope.org> Sent: Thursday, March 15, 2007 1:23:14 PM Subject: Re: [Zope] adding files and folder in a object during generation --On 14. März 2007 22:18:06 -0700 Allen Huang <swapp0(a)yahoo.com> wrote: > I created an external product using python to creates a folderish object. > During object instantiation by manage_addProduct(self, id, > ......): > I wish to add a couple of empty files and folder. Such tasks belong into manage_afterAdd() or should be implemented using the lately introduced event-based notification mechanism. -aj ____________________________________________________________________________________ TV dinner still cooling? Check out "Tonight's Picks" on Yahoo! TV. http://tv.yahoo.com/

2 1

adding files and folder in a object during generation
by Allen Huang 15 Mar '07

15 Mar '07

I created an external product using python to creates a folderish object. During object instantiation by manage_addProduct(self, id, ......): I wish to add a couple of empty files and folder. I tried self.manage_addFolder('folderID', , 'folderName') but it just create a folder outside of the object. I tried id.manage_addFolder('folderID', , 'folderName') but id is a str and does not have manage_addFolder I tried self.getitem(id).manage_addFolder('folderID', , 'folderName') _.getitem(id) is a method I frequently used in DTML but it didn't work in python. what expression do I use to replace with self so ZOPE will create folders and files in the newly generated object? ____________________________________________________________________________________ Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. http://autos.yahoo.com/green_center/

2 1

Unauthorized error with ZCatalog
by Jonathan 14 Mar '07

14 Mar '07

I have some "trusted code" (an external method) which is doing a ZCatalog search: sRes = targetFolder.Catalog({'PrincipiaSearchSource' : self.REQUEST['searchText']}) But this is causing the following error: Traceback (innermost last): Module ZPublisher.Publish, line 115, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 41, in call_object Module OFS.DTMLMethod, line 144, in __call__ - <DTMLMethod at /Playwiser/WUI/SearchPublicPosts> - Physical Path: /Playwiser/WUI/SearchPublicPosts Module DocumentTemplate.DT_String, line 476, in __call__ Module DocumentTemplate.DT_Let, line 75, in render Module DocumentTemplate.DT_Util, line 196, in eval - __traceback_info__: document_id Module <string>, line 1, in <expression> Module Products.ExternalMethod.ExternalMethod, line 232, in __call__ - __traceback_info__: (('SearchPublicPosts',), {}, None) Module /apps/Zope-2.9.2/Extensions/playwiser-1.0.py, line 718, in ProcessControl Module <string>, line 1, in ? Module /apps/Zope-2.9.2/Extensions/playwiser-1.0.py, line 6819, in subSearchPublicPosts Module Products.ZCatalog.CatalogBrains, line 86, in getObject Module OFS.Traversable, line 238, in restrictedTraverse Module OFS.Traversable, line 209, in unrestrictedTraverse - __traceback_info__: ([], '0000000001') Module AccessControl.ImplPython, line 563, in validate Module AccessControl.ImplPython, line 461, in validate Module AccessControl.ImplPython, line 808, in raiseVerbose Unauthorized: Your user account does not have the required permission. Access to '0000000001' of (BTreeFolder2 at /Playwiser/PublicForums/0000000000/0000000000) denied. Your user account, Anonymous User, exists at /acl_users. Access requires one of the following roles: ['Manager']. Your roles in this context are ['Anonymous']. This error is being generated because the containing folders ( /Playwiser/PublicForums/0000000000/0000000000) require 'Manager' privileges to access and the external method is being run from an 'Anonymous' method. I do not want users to be able to access the folders or content directly (hence the 'Manager' restrictions), I only want users to access the content of these folders via the external method routines (so that I can control inputs, searching and display). The problem code in CatalogBrains.py is: line 60: def getObject(self, REQUEST=None): ... line 85: try: line 86: target = parent.restrictedTraverse(path[-1]) line 87: except ConflictError: line 88: raise Is there any way to get Zope to treat my external method as if it had 'Manager' access privilege so that the restrictedTraverse call doesn't generate the "Unauthorized" error? (ie. in python scripts you can set a proxy role, but I don't know of anything similar for external methods). Any and all ideas appreciated! Jonathan

3 3

accessing the user search using mxODBC adapter
by michael nt milne 14 Mar '07

14 Mar '07

Hi We're having issues getting a user listing back from a SQL server database using the default Plone user search. We have the mxODBC adapter all working for login but not for the user search. Does anyone have experience of issues here? Is it an issue with the user folder or is a ZSQL required? Thanks -- michael

2 4

'int' object has no attribute 'objectValues'
by tonylabarbara＠aol.com 14 Mar '07

14 Mar '07

When I rewrite the command to tal:replace "batch" and surf to it, it displays the object values of every object in the quotes folder. That's what inspired me to measure the len. So, "batch" is not a number, but "num" is, and I've proven this by having the scriptlet print out that number. AJ says I shouldn't call all those objectValues into memory. Okay, what's a way around that? I just need the number ;) TIA, Tony -----Original Message----- From: lists(a)zopyx.com To: maciej.wisniowski(a)coig.katowice.pl; tonylabarbara(a)aol.com Cc: zope(a)zope.org Sent: Tue, 13 Mar 2007 1:50 AM Subject: Re: [Zope] 'int' object has no attribute 'objectValues' --On 12. März 2007 23:25:59 +0100 Maciej Wisniowski <maciej.wisniowski(a)coig.katowice.pl> wrote: >> <span tal:define="batch here/quotes/objectValues; num python:len(batch)"> >> <p tal:replace="python:here.randomNumber(num)" /> >> </span> > Check what here/quotes is evaluating to. Seems that it is int. > > In addition there is no need to call objectValues just to determine the number of all objects within a container. objectValues() will load *all objects* of the folder *into memory*. Don't do that. -aj ________________________________________________________________________ AOL now offers free email to everyone. Find out more about what's free from AOL at AOL.com.

2 1

Lost user credentials
by Garito 13 Mar '07

13 Mar '07

Hi all! Some days ago I send to the list a question about a problem losting user credentials In my code I don't use nothing about security and nothing is changed on zmi's security tab But when I launch a method (Borrar if you remember) the user who launches the action is anonymous not the logged one Can you point me what is happening? Thanks! -- Mis Cosas: http://blogs.sistes.net/Garito

5 15

RE: [Zope] Redirecting
by Mark, Jonathan (Integic) 13 Mar '07

13 Mar '07

tonylabarbara(a)aol.com wrote: """Ugh. JS redirects create problems with the search engines. What I really want to do is "fill the hole in the doughnut",""" The Ajax way to do that is by using the DOM to change the node dynamically behind the scenes. A recent article on Reddit showed that, indeed, Google ignores Javascript redirects. By the way, the major buzz on Reddit.com is for Python (yay!) and Ruby. Within Python the major buzz is for Django. Other Python frameworks, including Zope, don't get mentioned. We may be heading towards a statis in which the lion's share of Python web framework development is done in Django. That is in some ways good for Zope, however, No one knows whether Grok will come along and compete with Django, but in the meantime Django is keeping Python's profile high. Perhaps Django is holding the door open for Grok.

1 0