- Zope - Zope lists

urgent python questrion: DCOracle
by Andy Pahne 05 Jul '00

05 Jul '00

hi, tehre, how to call an oracle8 stored procedure from python? i do not understand this buffer s***t. yours, Andy Pahne ap@net22 net22 GmbH Bad Meinberger Strasse 1 32760 Detmold Tel.: 05231 - 580 640

1 0

problem with ZopeFind and objectValues
by Jerome Alet 05 Jul '00

05 Jul '00

Hi, please could someone explain me why when accessing the same zope site anonymously: <dtml-in "objectValues(['Folder'])"> <dtml-var id> - <dtml-var title> </dtml-in> works as expected and displays a list of id and titles of the current folder's subfolders, but <dtml-in "ZopeFind(this(), obj_metatypes=['Folder'])"> <dtml-var id> - <dtml-var title> </dtml-in> gives me the following error: """Unauthorized You are not authorized to access id.""" If I set a proxy role of manager to this dtml-method that doesn't change anything, it still doesn't work. If I log in as superuser both work the same (Zope 2.1.6). In fact I want to do a ZopeFind with search_sub set to 1 to recurse all subfolders from the current one. Is there any other method to do it, or should I set a particular parameter to a particular value (not found how to really use ZopeFind in ZQR, the sample is far too short IMHO). How can I restrict a search in Zcatalog to the current folder and its subfolders ? Jerome ALET - alet(a)unice.fr - http://cortex.unice.fr/~jerome Faculte de Medecine de Nice - http://noe.unice.fr - Tel: 04 93 37 76 30 28 Avenue de Valombrose - 06107 NICE Cedex 2 - FRANCE

2 2

DCOracle question again
by David A Lipsky 05 Jul '00

05 Jul '00

About a week ago, I asked a question about dcoracle (Included below). I got one response suggesting that I not use a cursor. However, I need a cursor to return several (lots) of rows from the database in one stored procedure call. I can't do this by adding extra non-cursor parameters. If anyone has any other ideas, I'd appreciate the help. -David Lipsky > I was wondering if you could help me with a problem I've been having > with DCOrale, connecting to Oracle8i. > > > import DCOracle > > conn = DCOracle.Connect(...) > > curs = conn.cursor() > conn.procedures.some_stored_procedure(curs) > curs.fetchall() > > curs = conn.cursor() > conn.procedures.some_other_stored_procedure(curs) > curs.fetchall() > > > some_stored_procedure and some_other_stored_procedure > return different rowtypes. > > Either the second call throws the following error, or > it returns the wrong set of columns (it will return only > those columns that were returned in the first call): > > > Traceback (innermost last): > File "<stdin>", line 1, in ? > File "/usr/lib/python1.5/DCOracle/ociProc.py", line 134, > in __call__ > for c in iocursors: c._describe() > File "/usr/lib/python1.5/DCOracle/ociCurs.py", line 130, > in _describe > if rc!=1007: self._error() > File "/usr/lib/python1.5/DCOracle/ociCurs.py", line 109, in _error > raise error, (rc, oci_.OracleErrorMessage(self._c.lda, rc)) > oci.error: (1003, 'ORA-01003: no statement parsed') > > > Explicitly closing the cursor between the calls doesn't seem to help, > nor does reusing the same cursor. The only way I've been able to call > two stored procedures in this way is by closing the connection itself > between calls. > > Any advice or help you can give would be greatly appreciated! If I've > sent this to the wrong address, please forward it to someone > who can help. > Thank you! > > > -David Lipsky > Openmind Commonsense > MIT Media Lab >

1 0

File referencing and LocalFS
by Spicklemire, Jerry 05 Jul '00

05 Jul '00

Hi Rogerio >1)Folders names are directly related to string fields >in a MySQL database which use spaces between words (eg >New York), but folders names don't use spaces (eg >NewYork). How can I skip spaces from database fields to >make them refer to these folders (eg New York --> >NewYork)? I python it's just : foldername = string.join(colname, '') using a "blank" ('') between each string, in other words, with no delimiter. So, in Zope it's something like : <dtml-call "REQUEST.set('foldername',_.string.join(colname, ''))"> assuming you've already assigned "colname" from a ZSQL Method. 2)Using LocalFS, can I do something like <dtml- >var "localfsObject['<dtml-var par1>'].['<dtml-var >par11>'], where par1 and par11 are folder names (after >skiping spaces)? According to the Local FS docs*, this would be : <dtml-var "localfsObject['par1']['par11']"> Keep in mind that inside a dtml tag you can refer to objects by name, without redundant dtml tags, and even without the quotes, if you're not calling a method of the object : <dtml-var localfsObject> Good Luck, Jerry S. * http://www.zope.org/Members/jfarr/HowTo/DTML_with_LocalFS

1 0

The story with 900 files/Zope hanging..
by Jonathan Desp 05 Jul '00

05 Jul '00

That's weird, maybe it's a bug, or maybe zope is not powerful enough, but when I'm copying and pasted http://zope.atomasoft.com/resumebank/addPostingForm/manage_workspace then change the url in netscape for --> http://www.atomasoft.com/resumebank/addPostingForm then be able to see my page I'm working on, then a problem appear, I mean zope stop, I cannot browse inside zope and I can't browse inside www.atomasoft.com/etc.. No one here know a patch for that problem ? no one here is smart enough in zope(because I'm not) for solving that problem ? Here you can read what David said, maybe it's a clue: David Elkins wrote: > > > what I can do against a hung process ? because it was ok, but now it's > > still not working. > > You might want to insert all those 900 files into a version of Zope > running on one of your local machines. Make sure it all works, then upload > the Data.fs. > > I have _no_ idea why Zope keeps hanging and becomes unavailable. It might > be that there are _tons_ of files all in one directory, which makes access > time very slow. > > David -- Very truly yours, <><><><><><><><><><><><><><> Jonathan Desp Atoma Matter will become Software http://www.atoma.f2s.com <><><><><><><><><><><><><><>

2 1

What's wrong with this code?
by Luke Tymowski 05 Jul '00

05 Jul '00

Hello, When: <dtml-unless renderedheader> <dtml-call "REQUEST.set('renderedheader',1)"> blah blah </dtml-unless> Is put in the standard_html_header object it behaves correctly: I want my standard header and footer objects to render when pages containing them are published. I don't want my standard header and footer objects to render when When that same code is put in the standard_html_footer object it never is published. If I preview just the standard_html_header it works. If I preview just the standard_html_footer it works. If I create a simple page like: <dtml-var standard_html_header> <p>This is some text.</p> <dtml-var standard_html_footer> The footer doesn't get published. I'm sure it's something obvious, but I've spent a few hours going through everything I can find and haven't got anywhere. thanks, Luke

3 2

RE: [Zope] Authentication, Anonymous and Public
by Brian Lloyd 05 Jul '00

05 Jul '00

> > A user that does not log in, i.e. a user you know nothing of, > > gets the "Anonymous" role automatically (at least with "acl_users"). > > A logged in user may not get the "Anonymous" role. > > > > This does not provide additional security, because this > > user may simply shut down his browser and access the page again > > as anonymous user. > > On the other hand, it may result in surprises: suddenly (after > > a log on) I can no longer do things that I was able to do > > before the log on. > > > > I think, this should be changed. > > I agree, and I've said so, many times before ;-) > > Chris Guys - I'm looking at the security code, and the intent is that if 'Anonymous' is in the roles required to access an object, the user is allowed (even though he may not have been given the 'Anonymous' role explicitly). This appears to be the case both in 2.1.x and the new 2.2.x security policy - I've been trying to replicate the problem you are referring to but I must be missing something. My test case was: o create a user 'test', giving him only 'test_role' o create a dtml document object with default security (anonymous has 'View' permission) o give users with 'test_role' 'View mgmt screens' on the dtml document. o in a new browser, visit doc/manage to force login as 'test' with 'test_role' o try to view the doc normally ('View' is only given to anonymous), which works as expected Can you give me a scenario that shows the problem so that I can reproduce it? (walk me through what objects to create, what permissions to give, how to try to access them). This should be done with standard built-in User/UserFolders if possible. Thanks! Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

2 1

Database Adaptors and security and query()
by Cary O'Brien 05 Jul '00

05 Jul '00

Couple of things came up trying to use the current PostgreSQL da and zope 2.2b3. I am working on a ZClass that lets you define and create tables in a database, so I needed to execute some generated sql [1]. 1) I couldn't access the query() method of the connection unless I added our friend __allow_access_to_unprotected_subobjects__=1 to the DB class defined in ZPyGreSQLDA/db.py Is this ok? 2) Re calling query(). The query method only returns a tuple used to create a Results object (which dtml-in would like). So I added a method to return a real live Results object def query_result(self,query_string, max_rows=9999999): return Results(self.query(query_string, max_rows)) Which does what I want. Is this ok? Is this a good idea? 3) I went down several wrong paths until I realized that it seems as if dtml-methods can't return anything but strings. Is this right? 4) Grumble. I had a lot of trouble with the interaction between Results returning data as tuples, and dtml-in handling tuples of 2 differently than everything else. Create a table with 3 columns, everything works. Create a table with two columns, things dont work. Is there access to list() anywhere? -- cary [1] I know, I can hear you saying "Use ZSQLMethods" but 1) You can't subclass them, and b) You can't put one inside a ZClass without a dummy connection.

1 0

Customizing error template?????????????
by Vikas Mahajan 05 Jul '00

05 Jul '00

hello everbody I want to customize the error page in my application and almost succeeded in it by changing the standard_error_messages template. But the problem is that i am not able to get rid of the python errors which are generated by default in the error template. Does anybody know how to avoid them . with regards Vikas

1 0

oracle8 and cursors
by Andy Pahne 05 Jul '00

05 Jul '00

hi, there, i've been using oracle8 with zope succesfully for a while. now my database programmer came up with a solution for a certain problem, which "we cannot solve with an easy select statement". he told me, that we are gonna have to use db-cursors instead. i must admit that i have heard the therm cursor before, but i am not sure how to use them with zsql-methods. my question is fairly simple: is there any difference in handling cursors with zsql-methods in comparison to handling 'simple' select-statements? can i use <dtml-in "..."</dtml-in> to iterate over the result sets? I read DCOracle.txt which comes along with DCOracle-Product, but I do not understand it very well. Any recommended readings? Andy Pahne ap@net22 net22 GmbH Bad Meinberger Strasse 1 32760 Detmold Tel.: 05231 - 580 640

2 1