December 2000 - Zope

multiple selects are not allowed
by Diny van Gool 15 Dec '00

15 Dec '00

Hi, I want to execute multiple SQL statements in one SQL-Method. In the mailinglist archives i found the answer but when i try it i get an error: Error, exceptions.ValueError: multiple selects are not allowed I used a simple Z SQL Method query (Zope 2.2.2) just to try: select * from GENEESM_DIER <dtml-var sql_delimiter> select * from TOED_WIJZE What am i doing wrong? Diny DIVA, Faculty of Veterinary Medicine Utrecht University, The Netherlands http://www.vet.uu.nl

4 4

Zope.org RSS file
by Andy McKay 15 Dec '00

15 Dec '00

The Zope news RSS file has a '&' which rdf doesnt like.... http://www.zope.org/SiteIndex/news.rss -- Andy McKay, Developer. ActiveState.

2 1

Re: Converting Python Methods to Python Scripts
by Itai Tavor 15 Dec '00

15 Dec '00

>Hi, > >I was wondering if anyone is planning to add automated migration of >Python Methods to Python Scripts (maybe with Zope 2.3 final)? Or >maybe there's something like this in there already that I missed? > >Anyway, for now I created a simple hack to do this - it's not >pretty, but it works. In case anyone's interested, this is how to do >it: ><...snip...> Oops, bug. It didn't work in ZClasses. And while I was fixing that, I modified it so that if you select more than one object all will be converted and you'll get back to the object list. A bug in a hack. How embarrassing. Here's the new External Method. Still-hoping-anybody-cares-about-this, Itai from Products.PythonScripts.PythonScript import PythonScript from string import strip from urllib import quote def PythonMethod2Script(self, ids, REQUEST, RESPONSE): for method_id in ids: method_id = strip(method_id) method = self._getOb(method_id) if method.meta_type != 'Python Method': raise 'AppError', 'Selected object is not a Python Method' title = method.title params = method._params if not type(method._body) == type(''): body = method._body.read() else: body = method._body self.manage_renameObject(method_id, method_id+'X') id = self._setObject(method_id, PythonScript(method_id)) script = self._getOb(method_id) script.ZPythonScript_setTitle(title) script.ZPythonScript_edit(params, body) if len(ids) == 1: return RESPONSE.redirect('%s/%s/manage' % (REQUEST['URL1'], quote(method_id))) else: return RESPONSE.redirect('%s/manage' % REQUEST['URL1']) -- Itai Tavor "Je sautille, donc je suis." C3Works itai(a)c3works.com - Kermit the Frog "If you haven't got your health, you haven't got anything"

1 0

Re: [Zope] How to debug access denials?
by Dieter Maurer 15 Dec '00

15 Dec '00

Stephane Bortzmeyer writes: > Indeed. What am I supposed to do with that? Why is the 'title' > property of the object unauthorized? (The object itself is viewable by > Anonymous.) I would expect "AccessContentsInformation" is relevant to access properties. > .... > I had to drop most of my DTML methods for the experimental sites I use > to "sell" Zope to other people, they're too hard to use. DTML methods > brings me back to sendmail.cf editing: great in theory but only a few > people (after an agreement with the devil?) can do what they want with > it. I read from that, that you do not use DTML objects. For *them*, access to attributes is granted for the "View" permission. Apparently, this is not true for all objects. Dieter

2 1

RE: [Zope] What version of Python Methods - no - Scripts for 2.2.4?
by Itai Tavor 15 Dec '00

15 Dec '00

Ron Bickers wrote: >I got PythonScripts running on 2.2.4 after doing the following: > >1) Install PythonScripts from CVS just like any other Product. > >2) Add these lines to lib/python/AccessControl/__init__.py: > >from SecurityInfo import ClassSecurityInfo, ModuleSecurityInfo >from SecurityInfo import ACCESS_PRIVATE >from SecurityInfo import ACCESS_PUBLIC >from SecurityInfo import ACCESS_NONE >from SecurityInfo import secureModule > >3) Add the CVS version of SecurityInfo.py to lib/python/AccessControl/ > >It works in my limited testing, but I have no idea if something is badly >broken that just hasn't shown itself yet. I also had to add OFS/Cache.py from the CVS for this to work. -- Itai Tavor "Je sautille, donc je suis." C3Works itai(a)c3works.com - Kermit the Frog "If you haven't got your health, you haven't got anything"

2 2

Converting Python Methods to Python Scripts
by Itai Tavor 15 Dec '00

15 Dec '00

Hi, I was wondering if anyone is planning to add automated migration of Python Methods to Python Scripts (maybe with Zope 2.3 final)? Or maybe there's something like this in there already that I missed? Anyway, for now I created a simple hack to do this - it's not pretty, but it works. In case anyone's interested, this is how to do it: * Create the following External Method at the top level of Zope, named M2S: from Products.PythonScripts.PythonScript import PythonScript from string import strip def M2S(self, ids, REQUEST): method_id = type(ids) == type('') and ids or ids[0] method = self._getOb(method_id) if method.meta_type != 'Python Method': raise 'HackError', 'Selected object is not a Python Method' title = method.title params = method._params if not type(method._body) == type(''): body = method._body.read() else: body = method._body self.manage_renameObject(method_id, method_id+'X') id = self._setObject(method_id, PythonScript(method_id)) script = self._getOb(method_id) script.ZPythonScript_setTitle(title) script.ZPythonScript_edit(params, body) return REQUEST.RESPONSE.redirect('%s/%s/manage' % (REQUEST['URL1'], method_i d)) * Edit lib/python/OFS/main.dtml. Find these lines: <dtml-if "AUTHENTICATED_USER.has_permission('Import/Export objects', this())"> <INPUT TYPE="SUBMIT" NAME="&dtml-id;/manage_importExportForm:method" VALUE="Ex port..."> </dtml-if> After them add this line: <INPUT TYPE="SUBMIT" NAME="M2S:method" VALUE="Convert Python Method to Script" * Repeat the last step for lib/python/Products/PlugIns/www/main.dtml * To use, check a Python Method in the management interface and click "Convert Python Method To Script". If you check more than one method, only the first one will be converted. * A new Python Script will be created, using the same id of the original Python Method. The old method will remain, with an 'X' added to its id. After the conversion you'll be redirected to the editing interface of the new script. Hope this is useful to anyone. It could probably be made much nicer, but why bother. Itai -- Itai Tavor "Je sautille, donc je suis." C3Works itai(a)c3works.com - Kermit the Frog "If you haven't got your health, you haven't got anything"

1 0

Volunteer internship for Zope programmer
by Fred Wilson Horch 15 Dec '00

15 Dec '00

Dear kind Zope folks, If you are * computer literate, * interested in programming or already a programmer, * looking for a volunteer opportunity or an independent study project, * eager to publish code and work on a development team, and * able to invest a few hours a week between January and May 2001 reading, writing and documenting open source object-oriented web application software (specifically Java, C and Python code for Zope running on Linux), you may be interested in the attached announcement. Thanks for the bandwidth, Fred Wilson Horch mailto:fhorch@ecoaccess.org Executive Director, EcoAccess http://ecoaccess.org/ P.O. Box 2823, Durham, NC 27715-2823 phone: 919.419-8354 Spring 2001 EcoAccess Technology Associate Internship EcoAccess, a public charity working to enhance public understanding of our natural environment, is offering a volunteer Technology Associate internship program for people seeking the opportunity to enhance their software development skills. Selected Technology Associates will receive a loaner Linux system to allow them to develop free open source software for the EcoAccess database-backed web site. Designed for Associates who have some programming experience, the internship runs from January 8 through May 4. Our software is published on SourceForge and licensed under the General Public License. How to Apply The internship is open to anyone who has any programming experience or training, with preference to those residing in the Triangle area of North Carolina. Apply by e-mail to Fred Wilson Horch, Executive Director internship(a)ecoaccess.org Please include the following information: * Your name * Preferred e-mail address * A summary of your education and relevant work experience, if any * Your experience with open source software, if any * Your other time commitments between January and May If we are interested in working with you, we will request a code sample before making a decision whether to accept you into the program. More About the Internship Our Technology Associates will learn how to develop for Zope, a leading Open Source web application server. Part of the internship will be devoted to learning and improving Zope itself, including documenting aspects of its interfaces. The other part will be devoted to writing applications in Python, Java and C to support the charitable EcoAccess project. Technology Associates must have at least dial-up Internet connectivity. Four interns who are in the Triangle area of North Carolina (Raleigh-Durham-Chapel Hill) can receive fully-configured development machines for use during the internship. (Associates may also use their own Linux machines if they prefer.) The loaner machines are best described as tomorrow's software running on yesterday's hardware. Our Technology Associates will get hands-on experience building object-oriented transactional web applications. Specifically, our Associates will write programs in Java, C and Python that run on Linux and use PostgreSQL databases. This internship is made possible through the generosity of several members of the Triangle Linux Users Group (TriLUG) who donated the hardware for our loaner machines. We appreciate the help! (Announcement revision 1.0 2000-12-14 10:21)

1 0

default values in forms
by Olaf Zanger 15 Dec '00

15 Dec '00

hi there, i'd like to send default values for an data update with the link to the form like <a href="adr_change_frm?f_id=<dtml-var id>&f_name=<dtml-var name>">c</a> unfortunately name may contain spaces. i found out that spaces may be replaced by "+" in the link, but how do i get the "+" into the <dtml-var ...> statement? thanks for help olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Zanger Nusch Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +41-76-572 9782 mailto:info@soli-con.com mailto:olaf.zanger@soli-con.com http://www.soli-con.com

6 6

Re: [Zope] stupid file upload question
by Dieter Maurer 14 Dec '00

14 Dec '00

Joh Johannsen writes: > But it says: "In you python external method you can now reference > REQUEST.form['attached_file'] as a normal file. You can > perform things such as read() on the object. " > > Now in my Python external method, I can reference things like: > > REQUEST.form['attached_file'].filename > > and that is fine. > > But what is the syntax for actually reading the file? From the above > quote I thought it was as simple as > x=REQUEST.form['attached_file'].read() but that doesn't work... Please tell us, how it does not work (in fact, it should work): Did you get an attribute error (read) or was the result wrong? You must use the 'enctype="multipart/form-data"' and 'method=post' form parameter to upload files. Did you do that? Dieter

2 3

RE: [Zope] site structure
by Farrell, Troy 14 Dec '00

14 Dec '00

If you are like me, you like to keep your standard_html_[header,footer] fairly stock. I have started including dtml-method components in my pages like this: <dtml-var name="standard_html_header"> <dtml-var name="top_navbar"> *CONTENT HERE* <dtml-var name="bottom_navbar"> <dtml-var name="standard_html_footer"> Though, I have a difficult situation: If I understand correctly, definition of JavaScript functions belongs in the <head> tags. Does anyone know how to do this? Troy -----Original Message----- From: Jan H. Haul [mailto:jan@haul.de] Sent: Thursday, December 14, 2000 12:17 PM To: Nuno Goncalves Cc: Oleg Broytmann; Zope(a)zope.org Subject: Re: [Zope] site structure Nuno Goncalves wrote: > > > On Thu, 14 Dec 2000, Nuno Goncalves wrote: > > > How can we define a structure for an entire site with Zope ? > > > for example i want that all the site's pages have a table with 3 > > > colums. it's kind of a template for the web site ! > > > > Using standard_html_header and standard_html_footer in every Document on > > your site... > But that way if i want to change the structure, i have to change on every > page. > My ideia was to create a template(3 colums) where i add objects (dtml > documents). > If i want to change the site structure to 2 colums i only change the > template ! > > Nuno > That is *exactly* what standard_dtml_header and ...footer are for. Together, they *are* your template. You *include* these in every document (using the <dtml-var standard...> tag. They'll show up in your documents at run time. Put the default template into the root folder and all your DTML documents will acquire it. In a sub-folder, you can either do nothing (then the acquired header and footer will be used), or override these with a folder-specicic template. See the Zope book, it explains it pretty well. Jan _______________________________________________ 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