July 1999 - Zope - Zope lists

opinions needed on methods for file download...
by Tony McDonald 27 Jul '99

27 Jul '99

Hi, I have a situation where I have a lot of files in a unix directory. They are all 'labelled up' in an SQL database which holds data such as filename, date_uploaded, owner, version and mimetype. The output DTML is similar to this at the moment, where log_entries is some SQL that returns filename, mimetype and idnum, whilst dump_file is a simple external method that puts the right content-type header on the data and reads it out to the browser. <dtml-in log_entries> <tr> <td><a href=dump_file?filename=<dtml-var filename url_quote>&mimetype=<dtml-var mimetype url_quote>><dtml-var idnum></a></td> <td><dtml-var filename></td> <td><dtml-var mimetype></td> <td><dtml-var owner></td> <td><dtml-var uploaded></td> </tr> </dtml-in> The problem is that the URLs are really clunky and the file download name is always 'dump_file'. Does anyone have any other thoughts on how this might work? cheers tone ------ Dr Tony McDonald, FMCC, Networked Learning Environments Project http://nle.ncl.ac.uk/ The Medical School, Newcastle University Tel: +44 191 222 5888 Fingerprint: 3450 876D FA41 B926 D3DD F8C3 F2D0 C3B9 8B38 18A2

2 2

VersionBase?
by Phil Harris 27 Jul '99

27 Jul '99

Hi all, Just started looking at the Zope2 b1 and think I may have found a bug. If I create a Zope Draft and then try to do anything with it, even just opening it, I get this traceback: Traceback (innermost last): File C:\PROGRA~1\zope2b1\lib\python\ZPublisher\Publish.py, line 256, in publish_module File C:\PROGRA~1\zope2b1\lib\python\ZPublisher\Publish.py, line 145, in publish File C:\PROGRA~1\zope2b1\lib\python\ZPublisher\BaseRequest.py, line 289, in traverse File C:\PROGRA~1\zope2b1\lib\python\Products\OFSP\Draft.py, line 155, in __bobo_traverse__ (Object: qs) AttributeError: VersionBase The error as reported in the browser is: Zope Error Zope has encountered an error while publishing this resource. exceptions.AttributeError Sorry, a Zope error occurred. Any ideas? Phil phil(a)philh.org

1 0

RE: [Zope] Zope 2 ODBC date errors
by Jay, Dylan 27 Jul '99

27 Jul '99

You can either use the patch I sent before or edit DateTime.py to make sure it has the timezone included for your country. The table at the top has to include an entry that maps what python returns as the timezone name, to the GMT offset. > -----Original Message----- > From: Graham Chiu [mailto:anon_emouse@hotmail.com] > Sent: Monday, July 26, 1999 11:30 > To: zope(a)zope.org > Subject: Re: [Zope] Zope 2 ODBC date errors > > > In article > <D133051DBC4AD111B90800A0C969498391D592(a)natasha.auslabs.lucen > t.com>, Jay, Dylan <djay(a)lucent.com> writes > >Its that damm timezone problem in zope. If the python string > returned as > >your timezone is not known to zope it barfs. This problem > has been going on > >for months and I feel because it is something that only > effects non-american > >zope users there has not been enough effort into fixing it. > In fact I have > >fixed this bug and submitted it and am disappointed that it > has not made > >into the source yet as was promised. > >This is a show stopping bug. In certain countries any > application that uses > >dates from sql where a timezone is not supplied is going to crash!!! > > Is this something I can fix locally, or do I have to wait for the next > beta? > > ------- > Regards, Graham Chiu > gchiu<at>compkarori.co.nz >

1 0

ZOracleDA Weirdness
by Neill Cox 27 Jul '99

27 Jul '99

Hi, First of all the obligatory kudos to DC. What a cool product! Why did I ever bother with CGI?! Now for the problem: I'm using zope beta 1 to view Oracle Data Dictionary tables, and I have some strange behaviour. This code works fine <tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> But if I uncomment (add the # to) the DATA_PRECISION and/or DATA_SCALE columns Zope requests authorization before it will publish the DTML. The underlying select is: SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE NULLABLE FROM ALL_TABLES WHERE table_name = AND owner = I have carefully gone through the permissions on the object hierarchy and can't find a reason for Zope to be requesting authorization. The code works fine under Zope alpha 2. Even better this code works sometimes. It may have something to do with null values in the DATA_PRECISION and DATA_SCALE columns (as I write this I don't have access to the Oracle DB). Any suggestions as to why this is happening would be most welcome. Regards, Neill Cox -- +---------------------------------------------------------------------+ | Neill Cox | | Ingenious Software Pty Ltd Phone : +61 2 6258 4858 | | 35 Carlile St Fax : +61 2 6258 5737 | | Evatt ACT 2617 AUSTRALIA | +---------------------------------------------------------------------+

1 0

RE: [Zope] Serving multiple Zope domains on Apache?
by Alexander Staubo 27 Jul '99

27 Jul '99

Your patch does not work with Zope 2.0. I desperately need something to work with 2.0. I have not tried Andreas Kostyrka's subsiting folder patch, but it doesn't seem exactly "simple". I just want my rewrite rules to work, dammit. ;) -- Alexander Staubo http://www.mop.no/~alex/ "QED?" said Russell. "It's Latin," said Morgan. "It means, So there you bastard." --Robert Rankin, _Nostramadus Ate My Hamster_ >-----Original Message----- >From: Evan Simpson [mailto:evan@tokenexchange.com] >Sent: 21. juli 1999 20:49 >To: Alexander Staubo; zope(a)zope.org >Subject: RE: [Zope] Serving multiple Zope domains on Apache? > > >See: >http://www.zope.org/pipermail/zope/1999-June/006132.html > >I don't think you can get away without patching ZPublisher and >using rewrite >rules, but it's a *tiny* patch. I've been using this for several weeks >without a hitch, and it has been very nice to be able to type >"4am.com/manage" rather than "4am.com/Zope/4am/manage" (I also >rewrite to >Zope if a URL lacks periods). > >Between this and the template scheme we use, my web-design >partner is pretty >happy. > >now-if-Dreamweaver-only-did-WebDAV-ly y'rs >Evan Simpson >

2 1

RE: [Zope] Accessing the parent folder of a DTML document
by Alexander Staubo 27 Jul '99

27 Jul '99

Just refer to the properties directly. For example, if the parent folder has a property named "BirdSpecies", your document can refer to it thus: ! which might evaluate to something like: Albatross! Note that you may refer to the folder specifically, thus: ! Or, if the folder's name is Spam: ! Or:  !  There are about a hundred other ways, but how's this for starters? -- Alexander Staubo http://www.mop.no/~alex/ "QED?" said Russell. "It's Latin," said Morgan. "It means, So there you bastard." --Robert Rankin, _Nostramadus Ate My Hamster_ >-----Original Message----- >From: Carlos Henrique Bauer [mailto:bauer@atlas.unisinos.br] >Sent: 26. juli 1999 21:48 >To: zope(a)zope.org >Subject: [Zope] Accessing the parent folder of a DTML document > > >Hi, > >How do I get access from inside of a DTML document to the >properties of the >its parent folder ? > >Best regards, > > -- >Carlos Henrique Bauer > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://www.zope.org/mailman/listinfo/zope > >(To receive general Zope announcements, see: >http://www.zope.org/mailman/listinfo/zope-announce > >For developer-specific issues, zope-dev(a)zope.org - >http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

Re: Zope digest, Vol 1 #330 - 50 msgs
by Tres Seaver 27 Jul '99

27 Jul '99

> From: Alexander Staubo <alex(a)mop.no> > To: "Zope Mailing List (E-mail)" <zope(a)zope.org>, > "'Jim Fulton'" > <jim(a)digicool.com> > Subject: RE: [Zope] ANNOUNCE: XMLDocument 1.0a1 > Date: Mon, 26 Jul 1999 05:31:28 +0200 > > >-----Original Message----- > >From: Jim Fulton [mailto:jim@digicool.com] > >Sent: 25. juli 1999 14:13 > >To: Alexander Staubo > >Cc: Zope Mailing List (E-mail); 'Amos Latteier' > >Subject: Re: [Zope] ANNOUNCE: XMLDocument 1.0a1 > > > > > >Alexander Staubo wrote: > >> > >> Now all we need is an XSL processor so we can transform XML > >documents to > >> HTML etc. on the fly. Anybody know of a Python > >implementation of such a > >> gizmo? > > > >There are a couple. We plan to integrate FourThought's 4XSL > >with Zope. > > Thanks for the pointer. Unfortunately it only works on Unix, though. > > >I expect this will look like "XSL methods". > > Well, how would you invoke them? It would be appropriate, say, to have a > single folder's XML documents all point to one XSL style sheet. In fact, > since the XSL style sheet of a document can be defined in the XML itself > -- the syntax escapes me, but I believe it was an XML SI -- this > information could be used for overriding the "default" XSL style sheet. > > >Also node that *all* Zope objects support DOM at some level > >as of Zope 2.0 beta 1. > > Any examples of this? > > Alexander Staubo http://www.mop.no/~alex/ Guessing wildly, but I believe that you are thinking of XSL as meaning the "Document Type Definition" (DTD) for a given class of XML documents: the DTD defines the allowable elements/attributes for its class, and is normally referenced at the head of the document; it can be defined or overridden within the document itself. XSL is a slice-and-dice query/transformation language, based on the DSSSL beloved of SGML geeks (itself based on Scheme, I think). An XSL style-sheel _renders_ an XML document, just as DTML renders Zope objects. Frankly, the most exciting news about the XMLDocument is that I can put off learning XSL, and just use DTML and Python instead. -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

1 0

RE: [Zope] ZPygreSQL woes
by TFE MMS JARVIS JOHN 27 Jul '99

27 Jul '99

I found that getresult in pg.py was dumping core. It turns out that this is a known bug. According to http://www.druid.net/pygresql/ , it has been fixed in PyGreSQL version 2.4 The version that came with the DA is 2.3. -- John Jarvis > -----Original Message----- > From: TFE MMS JARVIS JOHN [SMTP:jarvis.sd082@ex.tel.co.jp] > Sent: Tuesday, July 27, 1999 10:56 AM > To: nathan frund; zope(a)zope.org > Subject: RE: [Zope] ZPygreSQL woes > > oh... > This query outright crashes Zope on my system! > <SNIP> > -- > John Jarvis > > > -----Original Message----- > > From: nathan frund [SMTP:ndf@rocketmail.com] > > Sent: Tuesday, July 27, 1999 2:04 AM > > To: Hannu Krosing > > Cc: zope(a)zope.org > > Subject: Re: [Zope] ZPygreSQL woes > > > > > > ---Hannu Krosing <hannu(a)trust.ee> wrote: > > > > > > ndf(a)rocketmail.com wrote: > > > > > > > > I've run into a problem with Zope with > > PostgreSQL. The query runs and > > > > runs and runs till all the memory on the server > > is used up and Zope > > > > falls over. > > > > > > I'm using it all the time with no major problems. > > > > > > Do the same queries run fine from psql ? > > > > > > > > Yea, even from from 'regular old Python' and with > > PGaccess. > > > > Here is the SQL that I used to create the table. > > ------------------------------- > > items.sql > > ------------------------------- > > CREATE TABLE items ( > > prodname char(20), > > retailPrice money, > > description char(80), > > prodVis char(80), > > IMpartNumber char(20), > > size float4, > > speed float4, > > color char(8), > > weight int8, > > height int8, > > width int8, > > onhand int8, > > reorder int8, > > discontinued boolean, > > supplier char(20), > > supplierPartNumber char(20), > > manufacturer char(16), > > cost money > > ); > > > > > > copy items from stdin using delimiters ','; > > "15"" 5VX 28mm",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004520,0,200 > > "17"" 7SP .28mm 1280x1024(1yrs > warr)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004190, > > 0,250 > > "17"" 70+ .28mm 1280x1024",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004120,0,300 > > ----------------------------------------------------- > > > > psql database < items.sql > > > > > > > > Python code that works. > > ------------------------------------------ > > > > from pg import * > > > > cnx=connect('database','localhost',5432) > > > > query=cnx.query('select * from items') > > print "\n" > > > > fields=query.listfields() > > print fields > > > > ------------------------------------------ > > > > > > > Schemas, row counts, queries executed ? > > > > > > The query with Zope is the same exact query with the > > python... "Select * from items" > > > > > > It stops even with only three rows in the database. > > The SQL above for me stops Zope and Postgres in their > > tracks. > > > > > > > Also OS, postgres and ZPygreSQLDA versions. > > > > > > I'm running Red Hat Linux 5.2 with kernel 2.2.9 > > Python 1.5.2 from Oliver Andrich's site. > > Postgres is version 6.4.2-5. > > ZPyGreSQLDA version is 0.3. > > Zope 2.0.0b1 and Zope 1.10.3 > > > > I also have python-PyGreSQL-2.3.2.rpm installed. I > > got it from rufus.w3.org. I removed it thinking that > > it conflicted or caused the problem. But removing it > > didn't seem to help so I reinstalled the package. > > > > > > I haven't tried yet but I'm going to write an > > external method and see if that works. > > > > > > I've put up a lot of info, thanks for your help. > > _________________________________________________________ > > DO YOU YAHOO!? > > Get your free @yahoo.com address at http://mail.yahoo.com > > > > > > _______________________________________________ > > Zope maillist - Zope(a)zope.org > > http://www.zope.org/mailman/listinfo/zope > > > > (To receive general Zope announcements, see: > > http://www.zope.org/mailman/listinfo/zope-announce > > > > For developer-specific issues, zope-dev(a)zope.org - > > http://www.zope.org/mailman/listinfo/zope-dev ) > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For developer-specific issues, zope-dev(a)zope.org - > http://www.zope.org/mailman/listinfo/zope-dev )

1 0

ZClass subclassing a File
by Bruce C. Dillahunty 27 Jul '99

27 Jul '99

OK, I have yet another one (thanks for all the answers so far...) I have a ZClass that has some properties, etc. I want it to be a subclass of other ZClasses that I have defined, and the "File" type provided by Zope. What I want is a "File" that Zope recognizes, so that I can load a file in, etc., but have the various properties/methods available also... can this be done? If I define my ZClass (say MSFile) as a subclass of MSFileHolder (which provides some generic file/image handling that I want to do), and a subclass of File, then it works as a File (I can never seem to see the Properties pages, etc. that I set... if I open the instantiation of the object in the management interface, I just see it as a "File"... its as if the other stuff doesn't exist. Am I way off base here? I can make my MSFileHolder be a "folderish" object (subclassing Object Manager) and put the file in there, but then I get into seperate objects, instead of just one object that has everything I want all in one place... Thanks for any pointers. Bruce -- Bruce C. Dillahunty Peachbush Enterprises bdillahu(a)mindspring.com

1 0

RE: [Zope] "Access contents information" and SQL Methods; bug?
by Alexander Staubo 27 Jul '99

27 Jul '99

I added the line in lib/python/Shared/DC/ZRDB/DA.py, line 435, as instructed -- with no change in behaviour. -- Alexander Staubo http://www.mop.no/~alex/ "QED?" said Russell. "It's Latin," said Morgan. "It means, So there you bastard." --Robert Rankin, _Nostramadus Ate My Hamster_ >-----Original Message----- >From: Brian Lloyd [mailto:Brian@digicool.com] >Sent: 26. juli 1999 15:24 >To: 'Alexander Staubo'; Zope Mailing List (E-mail) >Subject: RE: [Zope] "Access contents information" and SQL Methods; bug? > > >> I have an interesting problem with a part of a site that needs to be >> limited to privileged editors. Let's call this role "Editor". The >> problem is, unless I give the "Access contents information" >permission >> to the "Anonymous" role, SQL Method calls are not permitted, >even if I >> give _all_ permissions to the "Editor" role. >> >> It's that curious?  equals to my editor >> user (defined in folder somewhere above the restricted folder), and >>  gives me ['Editor']. Btw, >> I've disabled acquisiton of permissions on the restricted folder. >> >> Unless I give "Access contents information" to "Anonymous", the >> following traceback is emitted when authentication fails: >> >> For now, I'll enable "Access contents information" for the >"Anonymous" >> role, but in the long run I feel this is a bad solution. >> >> -- >> Alexander Staubo > >I think that this is a bug in permission registration. I've >added a fix that seems to do the trick in my test area - can >you try the following and let me know if this takes care of your >problem?: > >In the file lib/python/Shared/DC/ZRDB/DA.py, add the line: > >Globals.default__class_init__(DA) > >...right after the definition of the DA class, and do a >restart. This should make sure that the permissions are >registered correctly. > > > > > >Brian Lloyd brian(a)digicool.com >Software Engineer 540.371.6909 >Digital Creations http://www.digicool.com > > > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://www.zope.org/mailman/listinfo/zope > >(To receive general Zope announcements, see: >http://www.zope.org/mailman/listinfo/zope-announce > >For developer-specific issues, zope-dev(a)zope.org - >http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0