January 2000 - Zope - Zope lists

Obtaining column names when using ZSQL method
by Nerlich, Andrew 11 Jan '00

11 Jan '00

Warning: Zope newbie alert I would like to be able to take a ZSQL method like select * from customer and generate a table or form of column name/value pairs like name john smith age 35 title programmer without having to feed Zope the column names explicitly. Such a facility would IMHO be very useful for generation of prototype document templates from RDBMS tables. I thought something like (the SQL above is in a ZSQL method called lookup_customer): <table border> <dtml-in lookup_customer size=50 start=query_start> <dtml-in sequence-item> <tr> <td><dtml-var sequence-key></td> <td><dtml-var sequence-item></td> <tr> </dtml-in> </dtml-in> might do the job, but it fails with a type error "unsubscriptable object" on the sequence-key line. sequence-index will work instead of sequence-key. On rereading the DTML Reference (and using a good deal of guesswork) it appears that sequence-key may only apply to "pure" Zope objects and not extend to SQL-type objects. Can anyone help me with this? Also, is there a way through DTML or Python to find out the type (varchar, number, etc) of each column? Zope has access to at least some of this info, otherwise search interfaces would not work on select * queries. TIA. Andrew Nerlich Strategic Operating Solutions Pty Ltd (02) 9966 8707 0418 407 833 ajn(a)sosos.com.au

1 0

mailing list digest problems?
by George Runyan 11 Jan '00

11 Jan '00

I'm getting two digests/day. one w/ ~ 50-60 msgs and another ~ 10 messages. today i got one digest @ 11:48AM CST and the second and smaller digest @ 2PM CST. george runyan grunyan(a)emerging.com

1 0

Missing Module sha when installing Zope from Source.
by Don Undeen 11 Jan '00

11 Jan '00

Hi there, I've been trying for a while to install MySQL, Python, Zope, MySQLdb, and ZMySQLDA. All from source. I've started with a fresh install of Redhat 6.1. I want to use Zope with my MySQL databases. I'm sure there are many of you out there doing the same thing. Was anyone documented teh whole procedure from start to finish? I installed Linux without Python, then got py152.tgz, unpacked and installed. I've gotten MySQL unpacked and installed from source as well. Beyond that, I'm at a loss as to how to proceed. In Trying to install Zope next, by running "python w_pcgi.py" (or "python wo_pcgi.py" gives the same result) I get the following error (after it spends some time compiling): [... successful compiling results deleted] gcc -fpic -DXML_NS -Iexpat/xmlparse -Iexpat/xmltok -g -O2 -I/usr/include/python1.5 -I/usr/include/python1.5 -DHAVE_CONFIG_H -c ./expat/xmltok/xmlrole.c gcc -fpic -DXML_NS -Iexpat/xmlparse -Iexpat/xmltok -g -O2 -I/usr/include/python1.5 -I/usr/include/python1.5 -DHAVE_CONFIG_H -c ./expat/xmltok/xmltok.c gcc -shared pyexpat.o xmlparse.o hashtable.o xmlrole.o xmltok.o -o pyexpat.so make clean rm -f *.o *~ chmod 0711 /usr/local/APPS/Zope-2.1.2-src/var Traceback (innermost last): File "wo_pcgi.py", line 116, in ? if __name__=='__main__': main(sys.argv[0]) File "wo_pcgi.py", line 107, in main import zpasswd; zpasswd.write_access(home, user, group) File "/usr/local/APPS/Zope-2.1.2-src/zpasswd.py", line 90, in ? import sys, string, sha, binascii, whrandom, getopt, getpass, os ImportError: No module named sha Why would I be missing this? Is there more to getting the development version of python installed than just py152.tgz? Maybe if I can get Zope installed properly, I can make sense of some of the other errors I get when trying to install MySQLdb.py, etc.... Also, I have MySQL 3.22.39 installed. Is this going to create a problem with the Zope adapters? Is it my imagination, or should this be easier? Thanks for your help. Feel free to respond to this message in a personal email, or to this group, or both. Don Undeen dundee(a)gator.net

1 0

How to use a variable in a <dtml-with > statement
by Lucas Hofman 11 Jan '00

11 Jan '00

Stimulated by the quick reply on my previous question the next: Situation is an object tree like this main-\ \- 01 \- 02 \- 03 \- 04 >From a method in main I would like to refer to one of its subdirectories dependend on the value of a variable. I can't find the right syntax for the <dtml-with > statement. Thanks for helping me out. -- Lucas Hofman

2 1

RE: [Zope] adding instance w/o management access
by Michel Pelletier 11 Jan '00

11 Jan '00

> -----Original Message----- > From: Timothy Wilson [mailto:wilson@visi.com] > Sent: Tuesday, January 11, 2000 12:47 PM > To: Michel Pelletier > Cc: Zope listserv > Subject: RE: [Zope] adding instance w/o management access > > > On Tue, 11 Jan 2000, Michel Pelletier wrote: > > > > What I ended up doing is to set the permissions on my factory > > > so that 'Use > > > factories' is mapped to 'Add News Articles' (my ZClass). That > > > seemed to > > > work. Is this a bad solution? > > > > Nope, keep in mind that whomever can add news articles can use *any* > > factory. > > I thought that the permission mapping I did applied only to that > particular factory. You're saying that it's global? If so, then my > solution is not the best. Nope you're right, sorry. > BTW, I'm looking all around, but I can't find the screen to set proxy > roles. DTML Methods and Documents have a 'proxy' tab. By 'factory' I didn't think you were talking about a Factory, but a method that does a factoryish type thing. -Michel

1 0

How can I improve error messages?
by Gustin Kiffney 11 Jan '00

11 Jan '00

OK, I've been hammered for the past couple of days because I was witless enough to use 'client' and 'id' as field names in SQL methods. I should have known better, I suppose, but that's the point of being a newbie - you DON'T know better, and really, you can't. Here's the super-uninformative error message I was getting: Error: TypeError: keyword parameter redefined SQL: Could not render the query template! And the HTML source indicated only that the problem was with my sql method - which I knew, because I'd been testing it over and over again, making unhelpful changes, hoping the magic cave would open and this ridiculous query would run. I grepped through the ZOPE source and apparently the phrase 'keyword parameter redefined' is emitted by Python, not Zope. Looking now through the Zope Quick Reference Guide there appear to be many names I can't use, which is OK, but a more robust system would tell me more about what went wrong. I guess this is a rap against Python more than Zope, but could these error messages possibly be extended to say something like ERROR: TypeError: 'client' keyword parameter redefined Or maybe could Zope trap this kind of error rather than letting Python handle it, which really doesn't generate extremely lucid error messages as a rule anyway? That would have saved the drywall in my office which has many head-shaped dents in it right now.

1 0

RE: [Zope] adding instance w/o management access
by Michel Pelletier 11 Jan '00

11 Jan '00

> -----Original Message----- > From: Timothy Wilson [mailto:wilson@visi.com] > Sent: Tuesday, January 11, 2000 12:38 PM > To: Michel Pelletier > Cc: Zope listserv > Subject: RE: [Zope] adding instance w/o management access > > > On Tue, 11 Jan 2000, Michel Pelletier wrote: > > > Give your factory method a 'proxy role' of manager. This > way, someone > > with non-manager privledges can do things like add instances only if > > they call your method the way you want them to. > > What I ended up doing is to set the permissions on my factory > so that 'Use > factories' is mapped to 'Add News Articles' (my ZClass). That > seemed to > work. Is this a bad solution? Nope, keep in mind that whomever can add news articles can use *any* factory. -Michel

2 1

newbie question: Adding DTML Document in a 'subdirectory'
by Lucas Hofman 11 Jan '00

11 Jan '00

Can anyone tell me how to (in DTML) create a document in any other location as the script containing the manage_addDTMLDocument statement? i.e. manage_addDTMLDocument('id','title','contents') generates a document named id on the same level as the method containing the statement. However, I would like to have it 2 levels down in the 'tree'. Thanks for any suggestions, Lucas Hofman -- PGS Seres tel: +47 67514059 PO Box 354 fax: +47 67526506 N-1324 Lysaker Norway

2 1

RE: [Zope] adding instance w/o management access
by Michel Pelletier 11 Jan '00

11 Jan '00

Give your factory method a 'proxy role' of manager. This way, someone with non-manager privledges can do things like add instances only if they call your method the way you want them to. -Michel > -----Original Message----- > From: Timothy Wilson [mailto:wilson@visi.com] > Sent: Monday, January 10, 2000 9:12 PM > To: Zope listserv > Subject: [Zope] adding instance w/o management access > > > Hi everyone, > > I've got a certain role assigned to people who I want to be > able to create > an instance of a ZClass. I don't want them to have access to the > management screen however. I'm having trouble figuring out what > combination of permissions will do it. Does anyone have a suggestion? > Currently I have a link that points to the 'NewsArticle_factory' for > creating instances of my News ZClass. I'm not even sure if that's the > proper way to do it. I do know that everything works > perfectly if you have > the Manager role. > > -Tim > > -- > Timothy Wilson | "The faster you | Check out: > Henry Sibley H.S. | go, the shorter | http://slashdot.org/ > W. St. Paul, MN, USA | you are." | http://linux.com/ > wilson(a)visi.com | -Einstein | http://www.mn-linux.org/ > > > _______________________________________________ > 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 ) >

2 1

Acquisition acting wierd
by Itamar Shtull-Trauring 11 Jan '00

11 Jan '00

We have the following folder structure /-| |-standard_html_header | |-all_about/- | | | |-standard_html_header | | |-foods/----- | |-cheese http://zope:8080/foods/all_about/cheese or http://zope:8080/all_about/foods/cheese should acquire standard_html_header from all_about, not from the root folder. But instead the stand_html_header from the top level is displayed. What's wrong here? -- Itamar S.T. itamars(a)ibm.net

2 1