April 2000 - Zope - Zope lists

SQL methods in __init__
by Dr. Ross Lazarus 19 Apr '00

19 Apr '00

It can be done! Have a look at the code for Piers Lauder's Survey Product. It does a whole heap of sql business when you add an instance of the surveycreator.... I have it here if you can't find it on http://classic.zope.org:8080/Download/Contrib - some problem with our proxy server right now so I can't get there... > Garion wrote: > I'm gonna try to explain what I'm trying do, since I'm sure the above > isn't too clear.. Frustration has set in... > > I have a folder off my root folder that I'll call MyWebSite... In > MyWebSite, I have a MySQL Connection defined... When I add an instance > my new product, I want it to save various bits into tables off the MySQL > Connection, and use the LAST_INSERT_ID for the ID of the object.. > -- Dr Ross Lazarus Associate Professor and Sub-Dean for Information Technology Faculty of Medicine, Room 126A, A27, University of Sydney, Camperdown, NSW 2006, Australia Tel: (+61 2) 93514429 Mobile: +61414872482 Fax: (+61 2) 93516646 Email: rossl(a)med.usyd.edu.au

1 0

calling DTML from DTML doesn't render
by Jon Delheimer 19 Apr '00

19 Apr '00

I have these objects: lib/py/hello (Python Method) contains: return "Hello, World" lib/dtml/indirect (DTML Method) contains: <dtml-return "lib.py.hello()"> test (DTML Method) contains: <dtml-var "lib.dtml.indirect"> When I view test, it shows: <dtml-return "lib.py.hello()"> I expect it to show: Hello, World! Why is this happening?

1 0

This document's folder's URL?
by Nolan Darilek 19 Apr '00

19 Apr '00

I've recently restructured my Zope site in order to take advantage of acquisition by moving page-specific code into other methods while leaving site-wide formatting in standard_html_header and footer. I'm running into a problem, though. I have a menu DTML method which contains page-specific sidebars. Though this menu often changes, it would be great if I could use acquisition to minimize the number of menu methods. However, if I have a folder in which a menu method from a parent is acquired, I can't think of a way to make URLs absolute. Right now I'm doing: <a href="../">Home</a><br> ... But, it's quite obvious what happens in descendants; ../ no longer links to my homepage, and none of the relative links work. So, is there a variable or method which creates an absolute link to the folder in which the current document resides, thus allowing me to use acquisition and avoid modifying menus whenever my structure deepens? So, I could do something like: <a href="<dtml-var folder_url>/articles/">Articles</a><br> and have that code work, no matter how many levels down 'menu' is acquired?

5 6

RE: [Zope] MySql and Auto_increment
by Luis Cortes 19 Apr '00

19 Apr '00

I don't know what it means by KeyError, but if I change my zsqlmethod to: select last_insert_id() I still get the key error, like so: Error, exceptions.KeyError: unhandled SQL used: select last_insert_id() Traceback (innermost last): File /var/zope/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /var/zope/lib/python/ZPublisher/Publish.py, line 179, in publish File /var/zope/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: sqlInsertTest) File /var/zope/lib/python/ZPublisher/Publish.py, line 165, in publish File /var/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_test) File /var/zope/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: manage_test) File /var/zope/lib/python/Shared/DC/ZRDB/DA.py, line 331, in manage_test (Object: sqlInsertTest) File /var/zope/lib/python/Shared/DC/ZRDB/DA.py, line 312, in manage_test (Object: sqlInsertTest) File /var/zope/lib/python/Shared/DC/ZRDB/DA.py, line 430, in __call__ (Object: sqlInsertTest) File /var/zope/Products/ZMySQLDA/db.py, line 191, in query KeyError: (see above) I have a hunch that it is trying to interpret the last_insert_id as a python or dtml function or variable, but I am not experienced enough in zope to know how to debug that. On Tue, 18 Apr 2000, you wrote: >> I'm running 2.1.4 on a development server. I haven't bothered testing with >> 2.1.6. What's the key of the KeyError are you getting? >> _______________________ >> >> Ron Bickers >> Logic Etc, Inc. >> rbickers(a)logicetc.com >> >> >> > -----Original Message----- >> > From: Luis Cortes [mailto:lcortes@pollak.com] >> > Sent: Tuesday, April 18, 2000 2:17 PM >> > To: Ron Bickers >> > Subject: RE: [Zope] MySql and Auto_increment >> > >> > >> > Ron, >> > >> > I am using ZOPE 2.1.6 and the version of MySQL is Ver 9.38 >> > Distrib 3.22.30, >> > for pc-linux-gnu (i686). I suspect it might actually be a Zope >> > issue since I >> > can run the inserts and selects fine in MySQL directly. >> > >> > What version of Zope are you running?? >> > >> > Thanks for the Help, >> > Luis. >> > >> > >> > >> > On Tue, 18 Apr 2000, you wrote: >> > >> Hmmm... >> > >> >> > >> What is the key from the KeyError? It says "see above", which >> > is in HTML at >> > >> the top of the page. >> > >> >> > >> What version of MySQL and ZMySQLDA are you using? I'm using >> > this technique >> > >> in a couple places and it works fine. >> > -- ====================================================== Luis Cortes Pollak EPD (915) 621-6113 ======================================================

2 1

FTP uploading and properties
by Mike Orr 19 Apr '00

19 Apr '00

I had always thought that if you uploaded a DTML Document via FTP in place of an existing one, it would wipe out the document's properties. But when I tried it just now, it didn't. Is it safe to use FTP to upload changes to documents without losing the properties? On a related note, I'm designing a Product representing an article. It will have a "body" attribute/property containing a "large" amount of text, and smaller fields for the title, author, etc. Our writers will want to edit the body with an external editor, but set the other attributes only via the web. Are there any special methods I can put in my Product class to trap FTP PUT/GET requests and pass only the "body" value in and out? Or should I just make my Product look like a DTML Document with extra properties? -- -Mike Orr, mso(a)mso.oz.net -or- mso(a)oz.net (permanent: mso(a)jimpick.com) http://mso.oz.net/ English * Esperanto * Russkiy * Deutsch * Espan~ol

1 0

Re: [Zope] Anyone using ZDiscussions?
by Tres Seaver 18 Apr '00

18 Apr '00

Chris Withers <chrisw(a)nipltd.com> > Organization: NIP > To: Zope Mailing List <zope(a)zope.org> > Subject: Re: > > > There are really basic and before I go and create my own I want to make sure > > that no one has done anything else. > > I think ZDiscussion are based on Confera. Which from what I understand is now 'bad' because it's so > old. Squishdot is based on this and problems have now started emerging because Squishdot is also > very old and doesn't do its indexing in the 'new ways' ;-) > > Recommendations in the past have included the KM|Net News product and of course the PTK. > You might like to consider these... >From MikeP's SoftwareProduct: http://www.zope.org/Members/MikeP/ZDiscussions Z Discussions 0.1.0 contains three products: **ZDBase** -- ZDBase contains the common base classes the other two products are built on top of. It does not register any object types that you can instantiate in Zope, but you can subclass them with Python or ZClasses. This Product must be installed for either of the other two Products to work. **ZDConfera** -- ZDConfera is the souped-up drop-in compatible replacement for Confera. It is a Python Product, so no addiitonal installation beyond extracting the archive is required. **Z Discussions** -- Z Discussions is the new, improved, legacy-free, Z Class threaded discussion object. If ZDiscussions does not sharpen your knives, put the starch back in your shirt and the ZIP back in your marriage, return the unused portion for a full refund! Tres. -- ========================================================= Tres Seaver tseaver(a)digicool.com tseaver(a)palladion.com

1 0

Re: [Zope] Newbie question: ZCatalog 'summary' meta-data
by Tres Seaver 18 Apr '00

18 Apr '00

Curtis Matthews <cmatthews(a)cpcus.com> wrote: > Please find it in your heart to enlighten a newbie. :) > > I've been able to find a lot of helpful documentation about how to use > ZCatalogs and search interfaces, but one thing that has eluded me is the > 'summary' meta-data feature. All I've been able to find out about this is > it's supposed to store the first few hundred characters of a text document > so that they can be displayed on a results report. > > I now have a catalog of about 100+ DTML Documents, and every time I search > it, the "summary" column of the results report is empty. I'm confused. I > assumed ZCatalog builds this summary automatically...does it? If not, what > extra stuff do I have to do to make it so? > > Any troubleshooting suggestions would be appreciated. The catalog has index for 'summary', because CatalogAware objects expose a 'summary' attribute (a method, actually) which performs as you describe. Unfortunately, DTMLDocument is *not* dervied from CatalogAware, and so has no such method. This gap accounts for other infelicitous (non)interaction between DTMLDocuments and ZCatalogs: DTMLDocuments are not automagically added/removed from the catalog when they are created/deleted, for instance. A workaround is to add a PythonMethod or ExternalMethod named 'summary' as a peer of your Catalog, defined so (assuming an EM): def summary( self, num=200 ): """Return a summary of the string form of the object.""" text=str( self ) n=min(num, len(text)) return text[:n] Note that the "string form" of a DTML document is the unrendered source, which may not be very useful to look at -- most will start off with '<dtml-var standard_html_header>...' and go downhill from there. You can, of course, tweak the summary code to return any property, or even a concatenated set of properties (like PrincipiaSearchSource does). Tres. -- ========================================================= Tres Seaver tseaver(a)digicool.com tseaver(a)palladion.com

1 0

CVS PTK and IOError?
by Mario Lang 18 Apr '00

18 Apr '00

Hello. I just checked out the current version of the PTK base and Demo product from CVS. I copied the files as stated in the readme.txt, and my products appear ok (not broken). When I invoke the Wizard (Portal) and fill in the information, after submitting the final page (Finish) I get a Zope IOError. Any idea what could cause this? Cya Mario

2 1

Jobs: Web wizards @ criticalpublics.com
by critical＠criticalpublics.com 18 Apr '00

18 Apr '00

Our job announcement (following) may be of interest to the Zope community, since Zope with Python is one of our foremost candidates for applications prototyping (and possibly also delivery). As we are currently starting a fasttrack web communications project for a major public sector client, perhaps one of you Zope/Python heads could be tempted to spend this summer in Greece? The core of the project is to architect, design and implement a very large information / community site, leveraging and further developing components implementing generic functionalities. As you'll see, the announcement is for regular staff positions, but in the context of this project we could live with a short term relationship, especially if we get to work with talented and results-oriented individuals! If you're interested, and can be available say from mid-May onwards, drop us a note and we can take it from there. Best, Costis PS. Santorini and Myconos are only 30' away by flight, and Athens summer life is, should I say, fun. The project is hard work, but we don't always work on weekends!! ANNOUNCEMENT FOLLOWS: criticalpublics.com is seeking WEB APPLICATIONS PROGRAMMERS, to be based in the office of Critical Publics SA, its subsidiary in Athens, Greece. Your mission: * To develop and implement large-scale, database-driven web applications for major clients, using standards-based methodologies and tools. * To produce technical briefs and possibly manage outsourcing of overflow work to freelance programmers. * To ensure perfect operation of our Intranet and Internet applications. You are: * A highly motivated Internet programming / systems wizard, able to produce functioning, well-documented applications using major web scripting languages. Your skills include: * A minimum of two years of proven experience in one of the major scripting languages (Perl, Python etc.) or equivalent experience in C, C++ or Java programming. * One year of Oracle or SQL Server applications programming and administration experience. * One year of Javascript, Flash/Shockwave and serious HTML coding experience. * One year of Linux /Unix system administration experience. * Solid overall knowledge of scripting, servers, cross browser support, databases, dynamic web applications and access logging. * An ability to complete programming assignments from detailed specification and design through to actual installation and operation. Additionally, you may be familiar with: * Web information architecture, usability and hypermedia design methodologies. * Object-oriented analysis and design methods and tools. * SGML and/or XML-based information standards, applications and tools. If accepted, you will be able to: * Work in the best area of Greater Athens, 20' by train to the Central Railway Station. * Be part of an international, creative, multidisciplinary team. * Enjoy the nicest lifestyle within the EMU zone of the European Union. You will be offered an attractive remuneration, plus benefits and bonuses, depending on your qualifications. If you fit the above description and are interested, send your Curriculum Vitae, prior work testimonials, links and other supporting evidence of your technical experience, to the following email address: mailto:webwizard@criticalpublics.com. criticalpublics.com is a new US company offering innovative technology and communication solutions for the practice of Investor, Media, Employee and Public Relations. Through our subsidiary in Athens, Greece, we work for blue-chip clients in South Europe, the Near and the Middle East.

1 0

zope fastcgi protocol error
by Scott Thomason 18 Apr '00

18 Apr '00

thilo, a few months ago you posted http://lists.zope.org/pipermail/zope-dev/2000-February/003202.html about an intermittent fastcgi protocol error. I'm just setting up zope with fastcgi and i am experiencing the same problem. i restarted zope, and the problem went away. my socket is located in /tmp/fcgi/, so i'm wondering if it needs to be moved out of the temp directory or ??? What did you do to fix this problem? ---scott

3 3