January 2003 - Zope - Zope lists

RE: [Zope] Default ZClass constructor not working? (was: re: Zope .org feedba ck)
by Leeuw van der, Tim 15 Jan '03

15 Jan '03

I will try again with these 2, to double check, and I will also try importing them again... I can otherwise also send you the product that originally gave me the problem, from the zclass-howto. Thanks for the effort, --Tim -----Original Message----- From: Dieter Maurer [mailto:dieter@handshake.de] Sent: maandag 13 januari 2003 21:14 To: tim.leeuwvander(a)nl.unisys.com Cc: zope(a)zope.org Subject: RE: [Zope] Default ZClass constructor not working? (was: re: Zope .org feedba ck) Leeuw van der, Tim wrote at 2003-1-12 17:42 -0600: > Here is a very minimal product, with no dependancies, no funcionality, > nothing, just a constructor. (Not the product from the traceback I posted > earlier, but it has the same problem.) I imported your "zexp" (into "Control_Panel/Products"), got two new meta types in my "add list" ("zcTest" and "zcTest2") and could create instances for them without any problem. Unfortunately, this means: I cannot reproduce your problem. This Zope Goblin tries to avoid me... Dieter

2 1

Re: [Zope] Zope reference documentation?
by Dennis Allison 15 Jan '03

15 Jan '03

Is there a book or a place where I can find: a: a DTML programmer's reference, or an API reference, or a TAL reference which contains ALL the objects and methods available to any of these scripting languages? The Zope Book doesn't have such a reference. What it has is very limited and not for a beginner. Did you look at the API (Appendix A). While it probably is not everything you want, it will help. You also will find reading the code very helpful. Dieter's book in progress may also help. See http://www.dieter.handshake.de/pyprojects/zope/

1 0

dtml in structured text
by HP Knoll 15 Jan '03

15 Jan '03

Hi, In my products index_html I use structured text to show textual content like this: <dtml-var body_stx fmt=structured-text> When I enter text that should be formatted as _stx I can use structured-text and HTML or mix the two, but I can not use dtml (which would be very helpful). Is there a way to do this, or a workaround to use dtml-tags in my structured-text documents? I have plain Zope 2.6.0 (win) installed and would be very thankful for any hint ! Hans

2 1

AdaptableStorage and size of File.
by Andres Punning 15 Jan '03

15 Jan '03

I just installed the AdaptableStorage product. When I try to upload a bigger File (File Product), it gives an error. I did not try to find the exact size, but 120 KB uploads OK, but 130 KB does not. So, maybe 128 KB? Traceback (innermost last): Module ZPublisher.Publish, line 98, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 39, in call_object Module OFS.Image, line 59, in manage_addFile Module OFS.Image, line 424, in manage_upload Module OFS.Image, line 501, in _read_data Module ZODB.Transaction, line 222, in commit Module ZODB.Transaction, line 195, in commit Module ZODB.Transaction, line 256, in _commit_objects Module Products.AdaptableStorage.zodb.ASConnection, line 153, in commit Module Products.AdaptableStorage.zodb.ASStorage, line 195, in new_oid Module Products.AdaptableStorage.mapper_std.PathKeychainGenerator, line 27, in makeKeychain AttributeError: 'None' object has no attribute 'startswith' The file does not upload. I used Zope2-filesystem mapping exactly from the doc.txt The same files to ordinary ZODB upload OK. Zope is fresh install: Debug Information * Zope version: (Zope 2.6.0 (source release, python 2.1, linux2), python 2.1.3, linux2) * Python version: 2.1.3 (#1, Apr 9 2002, 22:27:11) [GCC 2.96 20000731 (Red Hat Linux 7.1 2.96-98)] * System Platform: linux2 What limits the size? Some parameter in the dbtab.conf? A. Punning

2 1

Page Template TAL tags: no HTML tag required
by Jon Whitener 15 Jan '03

15 Jan '03

Here's something useful about the Template Attribute Language I didn't know: TAL statements DO NOT NEED to be inside an HTML tag. They can be inserted in Zope Page Templates as their own, separate tag. Look at this ZPT code: <tal:spam define="name string:Hipple-Dee-Dipple"> Why, hello there, <tal:fish-slap replace="name" />! Nice to see you. </tal:spam> No HTML tags in there! The spam tag has an end tag, the fish-slap tag needs none. Steve Alexander explains: >Because of the way TAL uses XML namespaces, you can call an element "tal:whateveryoulike". All of its attributes will be in the 'tal:' namespace by default. So, you could say: > > <tal:foo tal:replace="name" /> > >Which is equivalent to > > <tal:bar tal:replace="name" /> > >Which is equivalent to > > <tal:baz replace="name" /> Shane Hathaway points out: >Attributes of a TAL tag default to the "tal:" namespace, so you don't have to write "tal:" more than once per tag. (In fact, if you use an xmlns attribute, you don't have to use a "tal:" prefix at all, but then you have to prefix everything else.) An example: <tal:mytag define="msg string:Good day!" condition="msg" content="msg" /> Godefroid Chapelle points to the documentation of this TAL feature: >http://www.zope.org/Documentation/Books/ZopeBook/2_6Edition/AdvZPT.stx#3-45 Steve Alexander shows how TAL syntax is similar to that of DTML (and ASP): >DTML: Hello <b><dtml-var name></b>, how are you? >ZPT: Hello <b><tal:tag replace="name"/></b>, how are you? > >In ZPT, one of the constraints is to use valid XML. <dtml-var name> is not valid xml, because "name" should be in quotes, and it should have an attribute name. Actually, <dtml-var name> is a short-hand for <dtml-var name="name">. So, without cheesy short-cuts: > >DTML: Hello <b><dtml-var name="name"></b>, how are you? >ZPT: Hello <b><tal:tag replace="name"/></b>, how are you? > >There's not so much difference now. Now I will stop using otherwise-useless <span> tags just to host my TAL statements! Jon Whitener Detroit Michigan USA

1 0

ZServer Apache restrict management ques
by AM 15 Jan '03

15 Jan '03

Hi, I have a Zserver running behind apache which I set up as per instructions in http://www.zope.org/Members/regebro/Zope_and_Apache I would like to restrict access to the management pages to a few IPs. Is there any way to do that?? Thanks. AM -- ================================================================== Aseem Mohanty Neurobehavioral Systems Inc, 828 San Pablo Ave, Albany, CA 94706 (R) 510 7696011 (M) 510 3014871 (O) 510 5279231 ================================================================== "I saw `cout' being shifted "Hello world" times to the left and stopped right there!!" -- Steve Gonedes ==================================================================

1 0

ZODB vs SQL
by aborel 15 Jan '03

15 Jan '03

In "Choosing to store data in SQL vs ZODB" located http://www.zope.org/Members/anthony/sql_vs_ZODB i read : "Will the data be frequently changing? If the data is going to be frequently changing, then it's not a good idea to put it in the ZODB. Every time the data changes, a new record will be appended to the Data.fs file - this could become a problem very quickly." Does that mean that the changes AND the old version of the object are kept in ZODB ? If it's true, is packing a good way to throw away the old versions of the object ? If Not, What are the good ways ? Well i hope that's my last question for today. Thanks Andre

6 7

Qslider reversal
by Patrick Stinson 15 Jan '03

15 Jan '03

is there a way to reverse the values of a QSlider in 2.3? eg. in vertical orientation, minValue is at the top, and maxValue is at the bottom. thanks, -P patrickkidd.com

2 1

undo machinery mysteries
by Jeff Sacksteder 15 Jan '03

15 Jan '03

Is there a way to protect objects from removal due to ZODB compaction and still maintain undo and revision history? You could consider the the opposite of a 'Temporary Folder'. For certain documents, I would like to keep ALL previous versions in the object store forever- superpersistant, if you will. The best way that I can think to approach this is to keep my superpersistant objects in a second ZODB and mount it in a folder in my primary ZODB. I could then compact my primary without losing old revisions of my files. Is there a better way to approach this?

3 3

RE: Zope and MySQL on Windows
by Deb B. 15 Jan '03

15 Jan '03

I came to this group today to see what I could find on a particular ZOPE/MySQL issue I'm having. It relates to this thread, somewhat. I hope someone can give me some insight. I have ZOPE installed on a WIN98 machine that is acting as a temporary server until we go through a complete network upgrade to Windows 2000 Server, et. al. I have a development workstation that is using Windows 2000 Professional. This machine is where I have installed MySQL. So, I have ZOPE on one machine and MySQL on the other. I installed the myODBC from mysql.com because I couldn't get any of the ZMySQLDA/MySQLdb products to work on any version of Windows (obviously it favors the Unix/Linux environment). Well, Windows is what I'm stuck with now. I created databases, set up my ODBC connections, set up my Z SQL Methods and SQL Forms (depending upon which databases I access) and can access the databases with beautiful results on my ZOPE pages......BUT.....the results are extremellllllllllllllllllllly slow in coming. Even small databases with just a few records take forever to come up even with the most basic of SQL statements using either SQL Forms (for example, my Purchase Order database): <dtml-var standard_html_header> <dtml-if CheckPermissions> <dtml-unless REFERER><dtml-call "REQUEST.set ('REFERER',HTTP_REFERER)"></dtml-unless> <dtml-unless sqf_edit_method><dtml-call "REQUEST.set ('sqf_edit_method','edit')"></dtml-unless> <h3>> <dtml-var title_or_id>: <dtml-var document_title> (List)</h3> <P> <a href="&dtml-URL2;/">Up</a> - <a href="&dtml-REFERER;">Back</a> - <a href="list?REFERER=&dtml-REFERER;">List</a> - <a href="add?REFERER=&dtml-REFERER;">Add</a> <br><br> <table CELLSPACING='&dtml-table_cell_spacing;'> <tr BGCOLOR='&dtml-internal_title_color;'> <th>P.O.#</th> <th>Order Date</th> <th>P.O. Vendor</th> <th>Items</th> <th>Terms</th> <th>Total</th> </tr> <dtml-call "REQUEST.set('bat_size',_.int(viewlistlen))"> <dtml-unless start_key><dtml-call "REQUEST.set('start_key',0)"></dtml- unless> <dtml-if "_.int(start_key)<0"><dtml-call "REQUEST.set ('start_key',0)"></dtml-if> <dtml-call "REQUEST.set('next_key',_.int(start_key))"> <dtml-call "REQUEST.set('flag',0)"> <dtml-call "REQUEST.set('q','select * from po2002 where autoid >= '+_.str(start_key)+' order by autoid asc')"> <dtml-try> <dtml-in "SQL(q=q)" size=bat_size> <dtml-if "_.int(next_key) < _.int(autoid)"> <dtml-call "REQUEST.set('next_key',autoid)"> </dtml-if> <tr valign="top" align="left" BGCOLOR='<dtml-if "_.int(flag) ==1">&dtml-internal_c1_color;<dtml-else>&dtml- internal_c2_color;</dtml-if>'> <td><a href="&dtml-sqf_edit_method;?edit_key=<dtml-var autoid>&REFERER=&dtml-REFERER;"><dtml-var autoid></a></td> <td><dtml-var order_date></td> <td><dtml-var vendor_name></td> <td><dtml-var items></td> <td><dtml-var terms></td> <td><dtml-var total></td> </tr> <dtml-call "REQUEST.set('flag',1-_.int(flag))"> </dtml-in> <dtml-except> <h1>General error</h1> <dtml-var errorinternalmethod> </dtml-try> </table>  <br> <a href="&dtml-URL0;?start_key=0&REFERER=&dtml-REFERER;">First</a> - <a href="&dtml-URL0;?start_key=<dtml-var "_.int(start_key)-_.int (bat_size)">&REFERER=&dtml-REFERER;">Prev</a> - <a href="&dtml-URL0;?start_key=<dtml-var "_.int (next_key)">&REFERER=&dtml-REFERER;">Next</a> <dtml-else> <dtml-var standard_html_header> </dtml-if> <dtml-var standard_html_footer> and then Z SQL Methods (for example, a document log database): Example 1: select * from yr2000 Example 2: SELECT * FROM yr2000 WHERE doc_author='JEF' I also tried to set up a search form so users can perform searches themselves instead of having to be limited to choosing from pre- constructed reports I provide them. It's daaaaaaaaaaaaaaawwwwwwwwwwwwwwwggggggggggggggg slowwwwwwwwwwwwwwwww though. I even went so far as to perform table structure tests on my MySQL databases to ensure I was optimizing them for the fastest performance. Any searches done through a MySQL client returns quick results but I want all of their access to these databases to be web- based (i.e., through ZOPE site). Help! Thanks. Deb --- In zope(a)yahoogroups.com, "Bryan Capitano" wrote: > There are several options to using Zope+MySQL on the same Windows box. I > have not done this in a production server environment, so I can't say how > well that would work. But for development purposes, it works just fine. > > I had some problems getting python-MySQL adapter to install on Windows and > recognize my python installation (because I was trying to install MySQLDA). > But there are two ways around this problem which I've learned: > (1) One is to install MyODBC (see www.mysql.com) and create a System ODBC > database for your MySQL database. Then install the MyODBCDA database adapter > for Zope (instead of MySQLDA). This allows you to talk to MySQL through an > ODBC bridge. This solution works like a charm. > (2) The second workaround is to install Python2.1.3 on your machine > separately from the Windows Zope installation. Then install the .exe > Mysql-Python package (www.sourceforge.net) Then copy the installed files to > the Zope/Python directory. Then install MySQLDa. This solution was provided > to me by another list member (hiren_hindocha@a...). > > > -----Original Message----- > From: zope-admin@z... [mailto:zope-admin@z...]On Behalf Of Greg & > Janet LINDSTROM > Sent: Saturday, November 02, 2002 7:41 AM > To: zope@z... > Subject: [Zope] Zope and MySQL on Windows > > > Greetings- > I have a fairly mature Python application which uses MySQL for the database. > I would like to switch over from a single machine application to a web based > app (and maybe even make some money!!), and thought Zope would be the > logical choice. The past 2 weeks have had me running through the examples > in the Zope book and the Zope "Bible", and I *think* I am ready to create a > project. Then I read the the creators of Zope do not reccommend using MySQL > with Zope on a Windows box. Rats! So... > 1. Is this still sound advice? > 2. If so, what other Open Source Database is out there. I really would > like data/time data types, so that would leave Gadfly out, right? Plus. my > database is getting fairly large (~5 Meg), so I'm not sure I want to load it > all in memory. > > Thanks for any advice you can supply! > Greg Lindstrom > Vilonia, Arkansas > --------------------------------- Do you Yahoo!? Yahoo! News - Today's headlines

3 9