November 2000 - Zope

DTML and SQL question...
by zope 13 Nov '00

13 Nov '00

Hi. I want to test if there is some data in a table. If so, I want to perform some action, otherwise I wan't to print out a message. (<dtml-if>..<dtml-else>..</dtml-if>) My SQL statement is something like: Select count(*) from my_table where my_field = something What DTML code do I need to perform that if-statement? Something like the following does not work :-( <dtml-if "genericSQL(SQLStatement='Select count(*) from my_table where my_field = \'0\'') == 0"> YES! There's some data! <dtml-else> no records found! </dtml-in> Thanks for any help. Greetings, Marc Ludwig Luxembourg

3 2

Calling obj. in index_html
by jimbo 13 Nov '00

13 Nov '00

Hi Andy, Sorry to question you, but from what I understand <dtml-with "ftp"> <dtml-var index_html> </dtml-with> is "Bad Andy" Should be <dtml-with ftp> <dtml-var index_html> </dtml-with> Seems he wants to call the object and not the string right? I'm just testing if I learned anything about Zopemantics yet. -Jimbo

1 0

Monkeying with the Zope database
by Steve Jibson 13 Nov '00

13 Nov '00

I've been toying with the Zope database and I'm probably alomst to the point where I know enough to be dangerous. I am trying to make a few changes to the stuff in the Zope database without actually running Zope. Here's what I'm tring to do: 1 - Create a new user in the top level acl_users folder 2 - import a file "login.zexp" into the top level folder (login.zexp has been copied to the import directory) Here's some code I've written: ------------------ import sys sys.path.insert(0, '/home/zope/lib/python') import Zope appRoot = Zope.DB.open().root()['Application'] # create a new user appRoot['acl_users']._doAddUser(name='ThisWebSiteIsMine-SoThere', password='pw', roles=['Manager'], domains=[]) get_transaction().commit() # login as that user owner = appRoot['acl_users'].getUserById('ThisWebSiteIsMine-SoThere') Zope.AccessControl.SecurityManagement.newSecurityManager(None, owner) # import login.zexp and take ownership appRoot.manage_importObject('login.zexp', set_owner=1) get_transaction().commit() ------------------ Here's the resulting traceback: ------------------ Traceback (innermost last): File "go.py", line 22, in ? appRoot.manage_importObject('login.zexp', set_owner=1) File "/home/zope/lib/python/OFS/ObjectManager.py", line 526, in manage_importObject self._setObject(id, ob, set_owner=set_owner) File "/home/zope/lib/python/OFS/ObjectManager.py", line 267, in _setObject object.manage_fixupOwnershipAfterAdd() File "/home/zope/lib/python/AccessControl/Owned.py", line 273, in manage_fixupOwnershipAfterAdd self.changeOwnership(user) File "/home/zope/lib/python/AccessControl/Owned.py", line 166, in changeOwnership new=ownerInfo(user) File "/home/zope/lib/python/AccessControl/Owned.py", line 297, in ownerInfo db=user.aq_inner.aq_parent AttributeError: aq_inner ------------------ It appears to be dying while trying to set the ownership. There's a good chance that I'm going about this all the wrong way (I'm new at this stuff). Any help to fix up what I've tryed or new ways to approach the problem will be appreciated. Thanks, Steve

1 0

Re: Advanced search in ZCatalog (Micha)
by michael Kobald 13 Nov '00

13 Nov '00

Hi, I played with ZCatalog and ZClasses a time ago. Due to the fact that ZCatalog can Index all Objects - You Can Index a Method, .....!!! This Methods can be External-, Phython-, or DTML-Methods. But they have to return something to the catalog (DTML-RETURN Tag). You can give this method a name like "PrincipiaSearchSource" or what the hell you think of. In my case I index about 10 different ZClass, 100 Instances of them, with a PythonMethod called text_inhalt (text_contents) Param: self Code return string.join((self.id, self.inhalt), '; ') Or in an subclass return string.join((self.id, self.teaser, self.gericht, self.keys, self.art, self.norm, self.parteien), '; ') Be warned you can use a DTML Method and return something with the dtml-return tag, but this is not working very well within a ZCLass, !!! ?????? P.S.: If you want to call a resultObject (e.g. a ZClass) directly through Zope/DTML/Python use the PyMethod "fetchObj" much cooler than only via catalog.getpath (which is link /hfg/kkjk/) to do somthing like this: <dtml-in mein> ****Result from a canned search <dtml-call "REQUEST.set('meineURL',fetchObj(_,Catalog.getpath(_.int(_['sequence-item']) )))">****convert /parent/child to an real object parent.child <dtml-var meineURL> *** points to a ZClass [Base:Renderable] calling the Object/Class directly, which renders itself </dtml-in> use something like this: Python Method: fetchObj Param: _,fetchStr, attr=None obj = _ for p in string.split(fetchStr, '/'): obj = obj[p] if attr is None: return obj else: return render(_.getattr(obj, attr)) Greetings from Heidelberg Michael Kobald

1 0

RE: [Zope] Advanced search in ZCatalog
by Menard.Jean-Francois＠hydro.qc.ca 13 Nov '00

13 Nov '00

Usually, I use an external method returning a string containing the text from all the fields I want to search on, and I index THAT field in the Catalog. It works great! Jean-François Ménard Intranet DPAS Pratiques d'affaires et orientations * (514) 840-3000 poste 3939 * (514) 840-5585 * menard.jean-francois(a)hydro.qc.ca * 855 Ste-Catherine est, 6e étage Montréal, Qué. H2L 4P5 -----Message d'origine----- De : daniel dias [mailto:diask8@yahoo.com.br] Envoyé : lundi 13 novembre 2000 12:51 À : ZopeList Objet : [Zope] Advanced search in ZCatalog Hi! I´m trying to discover how to make a ZCatalog perform queries on several "fields" (as in the property sheets) of the cataloged objects, but with no sucess. I´d like to execute queries using a "or" chain of tokens, to be applied on several fields of the cataloged objects, given that each field has a priority in the search results. Any ideas on how to implement this? I´ve tried several approaches with absolutely no sucess, and I´m pretty stuck, so any help will be welcome. Thanks, Daniel Dias ________________________________________________________________________ Do You Yahoo!? Crie o seu e-mail grátis do Yahoo! Mail com 6 Megabytes livres! http://mail.yahoo.com.br _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

3 2

RE: [Zope] help
by Farrell, Troy 13 Nov '00

13 Nov '00

You need to add a user. The superuser cannot own any objects inside zope. Go to the folder called acl_users and add a user with manager permissions. Close all copies of your browser. Open a new one and login as the new user. Then you will be able to add objects. See also: http://www.zope.org/Members/michel/ZB/ Troy -----Original Message----- From: Padrino [mailto:mpena@mpsnet.com.mx] Sent: Monday, November 13, 2000 1:24 PM To: zope(a)zope.org Subject: [Zope] help Well I Installed Zope But When I Want To Add A Folder Or A File The Next Mesagge Apearse to me Well I have This Permitions in every file of the zope 777 nobody:nobody With Red Hat 6.2 Zope Error Zope has encountered an error while publishing this resource. Error Type: SuperCannotOwn Error Value: Objects cannot be owned by the superuser Troubleshooting Suggestions The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. Traceback (innermost last): File /root/src/Zope-2.2.2-src/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /root/src/Zope-2.2.2-src/lib/python/ZPublisher/Publish.py, line 187, in publish File /root/src/Zope-2.2.2-src/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook File /root/src/Zope-2.2.2-src/lib/python/ZPublisher/Publish.py, line 171, in publish File /root/src/Zope-2.2.2-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_addFolder) File /root/src/Zope-2.2.2-src/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_addFolder) File /root/src/Zope-2.2.2-src/lib/python/OFS/Folder.py, line 116, in manage_addFolder File /root/src/Zope-2.2.2-src/lib/python/OFS/ObjectManager.py, line 267, in _setObject (Object: ApplicationDefaultPermissions) File /root/src/Zope-2.2.2-src/lib/python/AccessControl/Owned.py, line 271, in manage_fixupOwnershipAfterAdd (Object: Traversable) SuperCannotOwn: (see above) Well I Will Be Waiting your Answer thanks For Your Help Sincerly Manuel Alejandro Peña Sànchez _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

Calling obj. in index_html
by Jason C. Leach 13 Nov '00

13 Nov '00

hi, I have an external fs object called ftp, in a folder called ftp. I had to put it in the folder so I could add users and what not. I would like to call the object in my index_html so I can do: http://www.bla.com/ftp rather than http://www.bla.com/ftp/ftp Can somone help w/ the dtml call? Thanks, j. ...................... ..... Jason C. Leach ... University College of the Cariboo. ..

2 1

Re: [Zope] help
by Pavel 13 Nov '00

13 Nov '00

-----Original Message----- From: Padrino <mpena(a)mpsnet.com.mx> To: zope(a)zope.org <zope(a)zope.org> Date: 13 íîÿáðÿ 2000 ã. 22:40 Subject: [Zope] help > Error Type: SuperCannotOwn > Error Value: Objects cannot be owned by the superuser ^^^^^^^^^^^^^^^^^^^^^^^^^^ this is the answer (: create a new user, login as the newly created user and try to do what you wanted. regards -- pashah

1 0

Advanced search in ZCatalog
by daniel dias 13 Nov '00

13 Nov '00

Hi! I´m trying to discover how to make a ZCatalog perform queries on several "fields" (as in the property sheets) of the cataloged objects, but with no sucess. I´d like to execute queries using a "or" chain of tokens, to be applied on several fields of the cataloged objects, given that each field has a priority in the search results. Any ideas on how to implement this? I´ve tried several approaches with absolutely no sucess, and I´m pretty stuck, so any help will be welcome. Thanks, Daniel Dias ________________________________________________________________________ Do You Yahoo!? Crie o seu e-mail grátis do Yahoo! Mail com 6 Megabytes livres! http://mail.yahoo.com.br

2 1

DatabaseAdaptor Problem
by Claudio Biasiolo 13 Nov '00

13 Nov '00

Hi I'm having trouble to use a database adaptor. I attempted to use gvibDA for interbase but I got a python error (in a previous mail) so I tried with MySql but make procedure didn't find a mysql.h . My question is: where can I find this file? Is there anyone who can help me for interbase? Thank you Claudio Biasiolo Web Developer cbiasiolo(a)veniceplaza.net VenicePlaza S.p.A. Padova, Italy

1 0