- Zope - Zope lists

Newbie questions
by fowlertrainer＠anonym.hu 01 Dec '03

01 Dec '03

Hello Zope-Masters ! Please help me with some examples/answers ! 1.) I cannot show results of Z-SQL method. I see the examples on web, on tutorial, but... ZSQL method name: testgroup. select id,name from inst_group Under KInterBase Connection, the test show the results. But if I wrinte into index.html: ... <dtml-in testgroup> x <li><dtml-var id>: <dtml-var name></li> </dtml-in> ... then it is don't show the results. Why ? Every example do this way. I do it with another tables, and another databases (ex. Gadfly) to avoid possible IB errors/bugs. But no result. Why ? What I do wrong ? 2.) I want to process the result of zsql query under PythonScript (select * from xxx). How to I call this method from PythonScript ? How to I get the result rows ? Please show with an example ! 3.) There is an (K)InterBase Connection. I want to access the IB specials. These are: - start transaction/Commit/Rollback, more if possible - call stored procs - set the transactions isolation level How to I do it under Zope ? I have an examples ? 4.) If there are two requests in zope, and the scripts are have use (K)InterBase Connection, that the connection object is duplicated ? The ZSQL method objects are duplicated also ? So: the requests' processes are separated ? 5.) I wan to log in users under zope just like php. This is the logical scheme (pseudo): browser session handling on handler: if mainsession is empty: result= form username/pwd /form submit button elif: get submitted form check username/pwd if wrong: result=errorform else: mainsession set to(userid,username,otherdatas) result=mainform for logined user So: the login form is one the main form, but some menus are disabled. When user have been logined, the menus are enabled. The checking is based on ZSQL method (select check). The questions are: - how to I do it under Zope, to Zope use the Session ID like PHP, and how to I write the session datas to session variable(s); and how to load/get values from it ? - how to I force Zope to the logined user is set to an existing zope user (only one for all logined user). I don't want to duplicate the user management into zope, I want to use my usernames in my IB database. 6.) Under Zope I how to create/set an variable in PyScript what useable in DTML ? So how to set more DTML variables under PyScript ? (example: dtml_username='xxx'; dtml_func="8"; etc.) or only I do it only with one with this: <dtml-var expr="myscript"> myscript.return(vmi) ? 7.) If I write this: <dtml-var expr="myzsqlmethod"> I get all of results of the method ? 8.) What is the ZSQL method caching (1000 row)? Is this an data packet size ? How to I get more records ? Can you show an example (not the Book's Batch, please show another) ? 9.) How to I import XML file ? I export my zope folder in home. I want to use another site. But I cannot do import. I try with these variations: c:\test.xml file://localhost/C:/test.xml Thanx for any help, examples, links. But please: don't say to I read the main book, every day I do, but my special questions I cannot found in it. KK -- Best regards, fowlertrainer mailto:fowlertrainer@anonym.hu

3 2

python test_largefile.py - File size limit exceeded -
by Chuck Aamdi 01 Dec '03

01 Dec '03

I tried running this python script on my development server and it run ok. but when I shutdown and run the test_largefile.py on my deployed Zope it read as below. [zope@aquarius test]$ python test_largefile.py create large file via seek (may be sparse file) ... File size limit exceeded [zope@aquarius test]$ Regards Chuck -- Chuck Amadi, ICT Systems Programmer, Brecon Beacons National Park Authority Direct Line: 01874 620440 FAX: 01874 622574 EMAIL: chuck.amadi(a)breconbeacons.org _______________________________________ \ \ \ Chuck Amadi,ICT Systems Programmer \ __________ | \ \ / \___-=O`/|O`/___| \ . \_______\ / | / ) / / `/-==__ _/__|/__=--| / / * \ | | / / (o) /______________________________________/ Nid yw'r farn a fynegir gan anfonwr y neges hon o anghenraid yn adlewyrchu barn Awdurdod Parc Cenedlaethol Bannau Brycheiniog. Neges yw hon a fwriadwyd ar gyfer y derbynnydd/derbynyddion yn unig ac fe'i hanfonir yn gyfrinachol; os ydych yn ei dderbyn mewn camgymeriad, a fyddech gystal %/1??iso8859-15?â rhoi gwybod i ni (yn it(a)breconbeacons.org) ac yna dil%/1??iso8859-15?ëwch bob copi. The views expressed by the sender of this message don't necessarily represent those of Brecon Beacons National Park Authority. This message is intended for the addressee(s) only and is sent in confidence; if you receive it in error, please can you let us know (at it(a)breconbeacons.org) and then destroy all copies. --------------------------------------------------------------------------- Brecon Beacons National Park Authority takes every care to keep its network free from viruses. All emails are scanned and verified virus-free by Sophos Anti-Virus software. *** IT IS THE RECIPIENTS RESPONSIBILITY TO CHECK ALL MESSAGES FOR VIRUSES ***

2 1

Posible memory leak?
by Gabriel Genellina 01 Dec '03

01 Dec '03

At 27/11/2003 21:17, you wrote: >I added a step in my manage_addTopic() script like >this to make a local reference to the "View" attrib I'm >trying to acquire: > >ob = Topic(...) >ob.ViewAlias = self.View >self._setObject(id, ob) >ob = self._getOb(id) > >View is a PersistentMapping, so I presume it will act like >a normal mutable Python object (so when I make changes >to its contents, they'll show up in the alias). I'll have >to test this, anyway, to make sure, of course. > >In the __setstate__ method, Topic computes using the >ViewAlias which is a local attribute: > >for view in self.ViewAlias.keys(): > #... do some stuff with this view info > pass Is this correct? Or there is a memory leak here? In a previous post http://mail.zope.org/pipermail/zope/2002-January/107054.html Max M maxm(a)mxm.dk said: >If your item is subclassing persistent you should expect them to stay in >the zodb. And then you should not add them to a list in your own >product, but create a subclass of ObjectManager and use the _setObject() >method to add the item instances. > >Else your item class should not subclass persistent. > >If you want to do it your way by adding item instances to a list in your >product you should also be aware that every time your product is >changed, or even one of the item instances, the whole object is written >to the Data.fs again. Leading to a bloated Data.fs ... if you don't pack >it regularly. > >But doing something like that with that many objects is the wrong way to >use the zodb. From this and other sources I've been told *not* to store a Persistent object as an attribute of another object, as this would cause a memory leak. But maybe a PersistentMapping is specially crafted? I dont see anything special in its source. Perhaps the enlightened people could explain the rules to avoid memory leaks... Gabriel Genellina Softlab SRL

4 6

base href
by Ian Bicking 01 Dec '03

01 Dec '03

I'm having a problem with LocalFS, HTML files, and the <base href> that gets added to pages. But I feel, at its source, Zope is just being nuts. HTTPResponse.insertBase inserts <base href> to pages; in turn, this base is set in HTTPResponse.setBase, where it ensures that the base always ends in "/". This causes paths to grow, as leaf pages (non-directory pages) get treated like directories. This is annoying in normal Zope objects, but LocalFS objects don't seem to acquire parents, so the extra elements in the URL that point to a LocalFS are just broken. While these growing URLs seem to be a persistent problem for many people in Zope, I assume there is a way that the paths *should* work. What do people do to get rid of these? Is there a way to keep HTTPResponse from adding a <base href> at all? (I could add "" to pages to trick insertBase into thinking the tag has already been added, but that's obviously a bad hack) -- Ian Bicking | ianb(a)colorstudy.com | http://blog.ianbicking.org

3 4

How to replace catalogaware base class with catalogpathaware in a Zclass?
by Yurj 01 Dec '03

01 Dec '03

How to replace catalogaware base class with catalogpathaware in a Zclass? Calogaware has path problem with virtual host monster... ________________________________________________ Message sent using ALFANET Caorle WEBMAIL 1.0

2 1

automated response
by Tom Herman 01 Dec '03

01 Dec '03

I will be on the road and unable to access email until Thursday (12/4). I will be checking voicemail, so please call me if your message is urgent (603-478-3166 x20). Otherwise, Renee should be able to help you (Renee(a)interlocken.org) Thanks, -tj

1 0

Streaming video/audio through a Zope site
by Etienne Labuschagne 01 Dec '03

01 Dec '03

Hi there, What are possible solutions for offering streamed resources on a Zope site? I was thinking of running Zope behind Apache and get some other product to handle the streamed content. That way Zope serves content the usual way and the links to the streamed content points to the streaming media server software (all behind Apache, so it "looks" like it is coming from the same site). Does this solution sound viable, and are there any suggestions on the software to use as the streaming server - preferably Linux, not too expensive and something that streams a well known format and which can work with Apache. Any suggestions? Thanks Etienne

4 3

Re: [Zope] Add file
by lmcdonnell＠iwon.com 01 Dec '03

01 Dec '03

Hi, Thanks, yes you are right this a subset of users and passwords should be used. I need to think about how they check for space. I am hoping that most of their files are small. Most will be images and wave files. Thanks again. Larry--- On Mon 12/01, The Count < the.count(a)count0.dyndns.org > wrote:From: The Count [mailto: the.count(a)count0.dyndns.org]To: lmcdonnell(a)iwon.comDate: Mon, 01 Dec 2003 16:10:03 +0100Subject: Re: [Zope] Add fileOn Mon, 1 Dec 2003 08:56:00 -0500 (EST), wrote:> What do I need to do to place "Add File" as a link on the menu.You could create an object with a proxy setting of "manager" and make it create the File,but are you sure you wish to upload files given by anybody accessing your server?I guess you have a files/upload/index_html or somesuch displaying a form with action="do_the_upload", then that do_the_upload would have to be assigned manager-proxy-setting;that means it acts as though it were a Manager, even though "Anonymous User" is requesting it.Some form of authentication would be HIGHLY advisable!At least limit the size of possible uploads (form attribute) and better still check for diskspace beforehand;BTW what'd be the most elegant way to find out available diskspace?? External Method?-- The CountEnjoy Your Web! _______________________________________________

1 0

Add file
by lmcdonnell＠iwon.com 01 Dec '03

01 Dec '03

Hi, I need to find a way to my users have access to the "Add File" feature. The users do not login. I have them using index_html documents as their way to navigate through the menus. What do I need to do to place "Add File" as a link on the menu. If someone can point me in the right direction or to an example that would be great. Thanks in advance. Larry _______________________________________________

1 0

Re: [Zope] ZPT and CSS
by Andre Meyer 01 Dec '03

01 Dec '03

Something else must be wrong here. It works find as long as the style information is inside the zpt page, but referring to an external css file does not work for me. I found quite some references that this is not possible with zpt, only with dtml. Others claim it can be done. What is the secret behind doing this? On Sun, 2003-11-30 at 19:51, Tino Wildenhain wrote: > Hi Andre, > > Andre Meyer wrote: > > Dear Tino > > > > Thanks for your answer. I did indeed expect normal HTML and ZPT/Zope > > generate HTML to behave the same. However, when I open the same HTML > > file using "Open File..." in Mozilla it displays correctly using the CSS > > file which is in the same folder (~/zope/lib/python/Products/mlib/zpt). > > When I view this same HTML file through Zope > > (http://localhost:8080/music/index_html) it does not use the CSS file. > > Viewing both sources in Mozilla reveals that Zope inserts a base tag. > > That results in Mozilla not finding the CSS file. > > How can this be prevented? Or what is the right way to do it? > > As I said: you give a full qualified path to the resource, > e.g. <link rel="stylesheet" type="text/css" href="/mlib/zpt/mlib.css"/> > > This is always recommended because Zope is not a regular file based > web server but an object publisher! > > Regards > Tino Wildenhain > > > > > Here is what I have so far: > > > > ~/zope/lib/python/Products/mlib/zpt/index_html.zpt > > ============== > > <!DOCTYPE html > > PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" > > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> > > <html> > > <head metal:define-macro="head"> > > <link rel="stylesheet" type="text/css" href="mlib.css"/> > > <title>Music Library</title> > > </head> > > <body bgcolor="white"> > > <div metal:define-macro="header"> > > <table border="0" cellspacing="0" cellpadding="6" > > width="100%"><tr><td bgcolor="#a0a0ff"><h1 > > tal:content="here/title_or_id">Title</h1></td></tr></table><br/> > > </div> > > ... > > ============== > > ~/zope/lib/python/Products/mlib/zpt/mlib.css > > ============== > > h1 > > { > > background-color: yellow; > > color: #666699; > > text-decoration: blink; > > } > > > > table > > { > > background-color: red; > > } > > ... > > > > On Sun, 2003-11-30 at 14:06, Tino Wildenhain wrote: > > > >>Hi Andre, > >> > >>Andre Meyer wrote: > >> > >>>Hi Zopers > >>> > >>>Trying to improve my ZPT pages I wanted to make use of Cascading Style > >>>Sheets (CSS). While the styles in my CSS file are properly rendered when > >>>I open the HTML file directly in the browser (Mozilla 1.4.1) they > >>>completely disappear when I view the same page through Zope!!! > >>>What is Zope doing? May it be that the CSS cannot be located because of > >>>the base url inserted by Zope? > >> > >>Beside possible and intended by you manipulations of the HTML > >>structure by means of TAL there is no difference between > >>The HTML you put in and the HTML you get out. > >> > >>After all, you can use "view source" in your web browser to check. > >> > >>As for links to embedded resources (images, scripts, styles) > >>you would preferably use root-relative links. That is: > >>links starting with / > >>Its not because it would not work - since it would work > >>with relative links quite well - you avoid multiple > >>versions appear in caches because of Zopes > >>acquisition. > >> > >>So, just check what you put in and what you really get back. > >>See if the mime-type of your CSS file is correct or > >>change it otherwise. > >> > >>We all use CSS with Zope since its definitively the way to go :) > >> > >>Regards > >>Tino Wildenhain > >> > > > > > >

2 1