August 2001 - Zope - Zope lists

ZSQL, Python Script, number of records
by Milos Prudek 07 Aug '01

07 Aug '01

Hi, To check whether a record exists I'm using this: exist (ZSQL method): SELECT count(*) as I FROM ... WHERE ... ; Python Script: for x in exist(m_id=m_id): if x.i==0: print "no data" else: print "there are some data" This works... but it's strange to use "for" for it... is there a simpler method? Just an "if", wthout "for"? I tried to adapt the "exist" ZSQL to show a column from the table: exist2 (ZSQL method): SELECT count(*) as I, fname FROM ... WHERE ... ; It fails and it recommends to put "fname" into GROUP BY. So: exist3 (ZSQL method): SELECT count(*) as I, fname FROM ... WHERE ... GROUP BY fname; That works but IMHO it's a very ugly hack and it may breed trouble later on. Is there a more elegant way to get both values and number of values using a single ZSQL method? -- Milos Prudek

2 2

Re: [Zope] ZSQL, Python Script, number of records
by Shai Berger 07 Aug '01

07 Aug '01

Hi Milos, > To check whether a record exists I'm using this: > > exist (ZSQL method): > SELECT count(*) as I FROM ... WHERE ... ; > > Python Script: > for x in exist(m_id=m_id): > if x.i==0: > print "no data" > else: > print "there are some data" > > This works... but it's strange to use "for" for it... is there a simpler > method? Just an "if", wthout "for"? > if exist(m_id=m_id)[0][0]: ... or if exist(m_id=m_id)[0].i: ... The object returned by a ZSQL method is a list of rows. The fields of the row can be accessed either by name (as attributes of the row) or by number. > I tried to adapt the "exist" ZSQL to show a column from the table: > exist2 (ZSQL method): > SELECT count(*) as I, fname FROM ... WHERE ... ; > > It fails and it recommends to put "fname" into GROUP BY. So: > exist3 (ZSQL method): > SELECT count(*) as I, fname FROM ... WHERE ... GROUP BY fname; What you seem to miss is that an SQL query always returns a set of rows of uniform structure. That is, you cannot have "a value and a list of values". In your specific case, the situation is much simpler. The number of items is the number of rows returned. So, exist4(ZSQL method): SELECT fname FROM ... WHERE...; In your python script: names = exist4(m_id=m_id) if(not names): # if there is no data, names is an empty list print "no data" else: for name in names: ... You can get the number of names as len(names). HTH, Shai.

2 1

:records and value assignment in Python Script
by Milos Prudek 07 Aug '01

07 Aug '01

Struggling with the ":records" form construct... I have a "writers" object that contains fname and lname text fields. It looks like this: [fname: "Chris", lname: "McDonough", fname: "John", lname: "Malkovich"] I need to add a new text field, auth, and I need to compute and assign it's value during the form processing. Adding new field was not that difficult: I just changed the form and added <input type="hidden" name="auth" value="">. I don't know how I would add a new field using Python... but it is not important right now. But how can I change the value? I tried this inside Python Script: for w in writers: print w.auth # this is OK. w.auth="x" # this fails with "attribute-less object (assign or del)". -- Milos Prudek

3 3

Re: [Zope] SSL + ProxyPass + Zope question...
by Stephan Goeldi 07 Aug '01

07 Aug '01

><dtml-if "URL[:5] == 'http:'"> ><dtml-call "RESPONSE.redirect('https:' + URL[5:])"> ><dtml-return "'REDIRECTING.. to secure port.. '"> ></dtml-if> When I now want: <dtml-if "Zope-Management-Interface"> <dtml-call "RESPONSE.redirect('https:' + URL[5:])"> <dtml-return "'REDIRECTING.. to secure port.. '"> </dtml-if> What will I have to put in the part "Zope-Management-Interface"? _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

4 3

RE: [Zope] a problem with "skip_unauthorized"
by Sylvain Boureliou 07 Aug '01

07 Aug '01

Hi, No, it's not a problem with my "publish" method, this code works with an older zope. It's perhaps a bug with zope 2.4, like says Joachim Werner. The solution? Use a bloc try-except in the dtml-in tag? it's not clean. Sylvain > > I use zope 2.4.0 and i have a problem with "skip_unauthorized". > > I want to publish some documents, but obviously, anonymous users are not > > allowed to view administrator's documents. > > So i use "skip_unauthorized" in the "in" tag, but an error is raised : > > You are not authorized to access xxx > > Which means that "skip_unauthorized" does not work !. I dont understand. > > Have you an idea ? > > > > <dtml-in "arch_actualites.objectValues('doc')" reverse sort="Date" > > skip_unauthorized> > > <dtml-var "publish('actutitle','actucontent',_['html_resume'],1)"> > > </dtml-in> >"dtml-in" checks "object access", an operation usually >protected by "Access contents information" and sometimes >by "View". If it fails, the "skip_unauthorized" would take >effect and omit the element. >Your "publish" method, however, may need different permissions. >In this case, you would get an "Unauthorized" later in your "publish". >If you need different permissions, you could use "ZopeFind" >to filter objects that do not have the required permissions. >Dieter _______________________________________________ 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

RE: [Zope] Passing arguments with hyperlinks
by Ron Bickers 07 Aug '01

07 Aug '01

> -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of > I have a ZSQL Method that takes an argument (teamid). I want to > pass this argument using a hyperlink. The idea is to click on a > Firm's name and be taken to a detail that includes all the team > members for that project. The data all comes from an existing > Access database. All I need is the teamid, but obviously it is > different for each row. I was thinking <a href="<dtml-var > ProjTeamMembers teamid=<dtml-var FirmTeamID>"><dtml-var > FirmName></a>. But I don't think this will work. > ProjTeamMembers is the dtml Method that calls the ZSQL method > using a <dtml-in>. What is the proper approach to this problem? > Is there a good way to store a bunch of info about rows returned > from a ZSQL Query. I've briefly heard of pluggable brains,but.... Hi Michael, You can create links like this: <a href="ProjTeamMembers?teamid=&dtml-FirmTeamId;"><dtml-var FirmName></a> When you click on it, ProjTeamMembers will be run with the variable 'teamid' in the namespace. When you call your ZSQL method, you just pass it the argument, as in: <dtml-in expr="myZSQLMethod(teamid=teamid)"> ...display team member... </dtml-in> This should give you what you're looking. You don't need pluggable brians for this. _______________________ Ron Bickers Logic Etc, Inc.

3 2

How to clean a vocabulary
by Rogerio Atem de Carvalho 06 Aug '01

06 Aug '01

Hi, do vocabulary objects delete a word that is not referenced anymore (I don´t think so)? If not, how can I programatically clean a vocabulary object inside a ZCatalog, I mean, delete all (or some specific) words that are not in use anymore? One more question: is there a size limit or number of objects limit one can store in a folder hierarchy, or the limit for Zope is only the data.fs limit? regards, Rogerio Atem

1 0

a problem with "skip_unauthorized"
by Sylvain Boureliou 06 Aug '01

06 Aug '01

Hi ! I use zope 2.4.0 and i have a problem with "skip_unauthorized". I want to publish some documents, but obviously, anonymous users are not allowed to view administrator's documents. So i use "skip_unauthorized" in the "in" tag, but an error is raised : You are not authorized to access xxx Which means that "skip_unauthorized" does not work !. I dont understand. Have you an idea ? <dtml-in "arch_actualites.objectValues('doc')" reverse sort="Date" skip_unauthorized> <dtml-var "publish('actutitle','actucontent',_['html_resume'],1)"> </dtml-in> Thanks. Sylvain

3 2

[Q] Problem with copying files
by Asko Seeba 06 Aug '01

06 Aug '01

Hi, Another beginner question. I'm using Zope 2.4.0. I try to make a web page, where some files should be copied from one folder to another according to client request. I didn't find any method from DTML API reference for that. Then I tried to find some help from Python scripting, but found frome Zope Help System at Script (Python)->API Reference->PythonScript, that because of security considerations Python Scripts are not allowed to access to the Zope server's file-system. So, are there any possibility to build a Zope application that copies files on server side from one folder to another. -- Asko Seeba

2 1

Creating class instances brings up strange login dialog
by Andy Bulka 06 Aug '01

06 Aug '01

Python script objects seem not to allow 1. the creation of instances of my own custom classes e.g. Class AA: 2. the use of __init__ constructor methods or anything starting with __ Restriction #1 is a rather extreme limitation that isn't mentioned clearly anywhere in my reading, which includes the tutorials and the zope book. The zope book mentions only the security limitations and import library limitations. Why isn't the inability to create class instances mentioned? Or am I running into a neewbee problem? Running the same python code as zope external methods works fine. thanks for any help, -Andy Bulka

2 1