- Zope - Zope lists

Upload files in Zope and store elsewhere
by Marius Kjeldahl 22 Mar '00

22 Mar '00

After some helpful advice, I have been successful in uploading files (images) to Zope. Now I am trying to stuff the uploaded images in a MySQL database, but am not able to access the image data. If I try to stuff the image data "raw" into the database by declaring a image:string parameter to the ZSQL Method and <dtml-sqlvar image> in the ZSQL code I get a string like "<ZPublisher.HTTPRequest.FileUpload instance at 87956214>". Another approach I have tried was <dtml-var image fmt=sql-quote>, but this complains about the image being an instance and not a string. Another approach has been to access the actual "raw" image data using image.data in various combinations, but I have not gotten this to work anywhere (contrary to what it seems other people have managed to do), see this http://www.egroups.com/group/zope/26227.html? posting. Looking through Image.py I see quote a few methods for accessing the image as a "web" object through the use of URL. Internally, Image.py uses the data attribute extensively, but I have not been able to access this from within DTML (and I guess this has to do with data not being listed in either the properties or permission sections of Image.py). My final try will probably be to resort to using an External method to get access to the "full" Image.py object (including data), but I was hoping to avoid this. Has anybody done this (uploading in Zope and storing the data outside of Zope) successfully? If so, please give me a hint.. Thanks, Marius Kjeldahl

3 4

worldpilot PIM
by mindlace 22 Mar '00

22 Mar '00

Zopistas & worldpiloteers, I've got worldpilot set up and running just fine. Now I'm interested in trying to get the collaborative features of worldpilot working, since despite having several IMAP users, the TODO, Calendar, etc. only allow me to select one user (the current one.) Thanks, Ethan Fremen -- http://mindlace.net __________________ mindlace(a)imeme.net I don't want The Truth but I wouldn't mind a Big Analogy.

2 2

Names containing colons?
by Skip Montanaro 22 Mar '00

22 Mar '00

In my web page input forms I've been using field names like "radius:int" so Zope will coerce variables to the proper type. This works fine on the server. Unfortunately, if I have a JavaScript function on my web page to do form input validation, how do I reference that object? Is there some alternate naming scheme that will allow Zope to do the type cast and allow references from JavaScript? Should I just forego the :int stuff altogether and do the coercion explicitly? Thx, -- Skip Montanaro | http://www.mojam.com/ skip(a)mojam.com | http://www.musi-cal.com/

2 1

RE: [Zope] Server Sizing
by Stephan Richter 22 Mar '00

22 Mar '00

So ProxyPass is 20 % faster. Cool. I will try that. Regards, Stephan -- Stephan Richter - (901) 573-3308 - srichter(a)cbu.edu CBU - Physics & Chemistry; Framework Web - Web Design & Development PGP Key: 735E C61E 5C64 F430 4F9C 798E DCA2 07E3 E42B 5391

1 0

sqlsession and postgresql
by Shortie Lo 22 Mar '00

22 Mar '00

i have installed sqlsession product and only change sqlSessionCreate as insert into sessions ( session ) values ( nextval('sessions_session_seq') :: varchar ) i have tried code block from How-To: Using SQLSession. everything seems to work except <dtml-call "SESSION.clear()">. traceback: Traceback (innermost last): File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /home3/local/src/Zope-2.1.5-src/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: SESSION.clear()) (Info: SESSION) File <string>, line 0, in ? File /usr/local/src/Zope-2.1.6-src/lib/python/Products/SQLSession/SQLSession.py , line 172, in clear File /home3/local/src/Zope-2.1.6-src/lib/python/Shared/DC/ZRDB/DA.py, line 408, in __call__ (Object: sqlDeleteValue) File /home3/local/src/Zope-2.1.5-src/lib/python/Shared/DC/ZRDB/Aqueduct.py, line 186, in _argdata (Object: sqlDeleteValue) Bad Request: (see above) -- 'Life is like boxes of chocolate, Forrest. You never know what you're gonna get.' -- Forrest Gump (1994) Lo Chung-Chang (shortie) shortie(a)ms14.hinet.net http://shortie.vbc.com.tw/ ICQ#27118251 Kaohsiung.Taiwan.Roc.Earth.Solar.Galaxy.Universe

1 0

RE: [Zope] Server Sizing
by Stephan Richter 22 Mar '00

22 Mar '00

>i agree on apache increasing your performance when serving static >files (for instance images), but wouldn't url rewriting and the proxy >pass module of apache be an even better solution? i just switched from >PCGI to the Rewrite/Proxypass combo because of the additional overhead >of PCGI. Mmmhh, I have to have a look. Okay, I just read the the little tutorial. Does it really speed things up? I guess SSL should not be hard using this solution. I will be thinking about it. Anyone else? Regards, Stephan -- Stephan Richter - (901) 573-3308 - srichter(a)cbu.edu CBU - Physics & Chemistry; Framework Web - Web Design & Development PGP Key: 735E C61E 5C64 F430 4F9C 798E DCA2 07E3 E42B 5391

2 1

sqlsession and postgresql
by 羅春長 22 Mar '00

22 Mar '00

0 *H÷ 010 +0 *H÷ $Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: 7bit i have installed sqlsession product and only change sqlSessionCreate as insert into sessions ( session ) values ( nextval('sessions_session_seq') :: varchar ) i have tried code block from How-To: Using SQLSession. everything seems to work except <dtml-call "SESSION.clear()">. traceback: Traceback (innermost last): File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /home3/local/src/Zope-2.1.5-src/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/OFS/DTMLMethod.py, line 150, in __call__ (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: sessiontest) File /home3/local/src/Zope-2.1.5-src/lib/python/DocumentTemplate/DT_Util.py, line 335, in eval (Object: SESSION.clear()) (Info: SESSION) File <string>, line 0, in ? File /usr/local/src/Zope-2.1.6-src/lib/python/Products/SQLSession/SQLSession.py , line 172, in clear File /home3/local/src/Zope-2.1.6-src/lib/python/Shared/DC/ZRDB/DA.py, line 408, in __call__ (Object: sqlDeleteValue) File /home3/local/src/Zope-2.1.5-src/lib/python/Shared/DC/ZRDB/Aqueduct.py, line 186, in _argdata (Object: sqlDeleteValue) Bad Request: (see above) -- 'Life is like boxes of chocolate, Forrest. You never know what you're gonna get.' -- Forrest Gump (1994) Lo Chung-Chang (shortie) shortie(a)ms14.hinet.net http://shortie.vbc.com.tw/ ICQ#27118251 Kaohsiung.Taiwan.Roc.Earth.Solar.Galaxy.Universe 00 ÆdÕ§@Áœ;Ûå®'Ó$%0 *H÷ 0_10 UUS10U VeriSign, Inc.1705U.Class 1 Public Primary Certification Authority0 980903000000Z 030903235959Z0·10U HiTRUST, Inc.10UVeriSign Trust Network1G0EU>www.verisign.com/repository/RPA Incorp. by Ref.,LIAB.LTD.(c)981301U*HiTRUST Class 1 CA - Individual Subscriber00 *H÷ 0ÑAUÙÀŒŸîaí²®ÇxÔH°tì ée:þÚžœñIè:µ:÷%sy7ÑLSäâ × ³9>^¿sCy|Dÿ¹€Òm\d»ÔÞ~z@RÕGËºsµçè_qºmšÖ8ß÷žrgû]%Æcû=i£|0z0 `HøB0GU @0>0<`HøE0-0++www.verisign.com/repository/RPA0U0ÿ0U0 *H÷ Ø² ùÓ«àF,{v-QÍ,{}íxz¹äËfIÃxXŸ°ø¢µ|ÃZOí4(WóÃM3+»ín|B£N|osëw2&ÈèPœCÜA¶ò¢aÎ;¶vÈÛñèLõ7šz?µá0n0× _$dP[ºûÓnMf%%0 *H÷ 0·10U HiTRUST, Inc.10UVeriSign Trust Network1G0EU>www.verisign.com/repository/RPA Incorp. by Ref.,LIAB.LTD.(c)981301U*HiTRUST Class 1 CA - Individual Subscriber0 000322000000Z 010405235959Z0<10U VeriSign, Inc.1=0;U4www.hitrust.com.tw/RPA Incorp. by Ref.,LIAB.LTD(c)981'0%UAuthenticated by HiTRUST, Inc.1'0%UMember, VeriSign Trust Network10UPersona Not Validated1402U+Digital ID Class 1 - Microsoft Full Service10U SHORTIE LO1%0# *H÷ shortie@ms14.hinet.net00 *H÷ 0¡œž²Ü»NT)q6µ_ri£$Ze° DäÇT#ÖSTOÈÖ}8ÌÿGE+ jRâYùh$ÉØâeèÄðRõá¡o~7LØ¬r`Iðé©SM-=GuÉR3ëŽ` Ñx`oJžøç}ò64Vµj}Q£ò0ï0 U00FU ?0=0;`HøE0,0*+https://www.hitrust.com.tw/RPA0 `HøB0 `HøExvd4652bd63f2047029298763c9d2f275069c7359bed1b059da75bc4bc9701747da5d2f6141beadb2bd2e89206bd63f0d611499fa3ba45fcf3ea450c0 *H÷ ÏteV4Îìÿ¡"òpø¶p7"Dô×q*_¬€cü;ÙŸ¢%ïšTàva§Þ£ö* õ¬Óü-Œ²&" 2F»üß]éäkºVFïÎ0ÕEÿ Ô,ú»J±çáHrœl{ëK@Çåê7@ÄÕ1ò0î0Ì0·10U HiTRUST, Inc.10UVeriSign Trust Network1G0EU>www.verisign.com/repository/RPA Incorp. by Ref.,LIAB.LTD.(c)981301U*HiTRUST Class 1 CA - Individual Subscriber_$dP[ºûÓnMf%%0 + {0 *H÷ 1 *H÷ 0 *H÷ 1 000322121950Z0# *H÷ 1¡®#áG{Àc»Ö/0< *H÷ 1/0-0+0 *H÷ (0+0 *H÷ 0Ý +71Ï0Ì0·10U HiTRUST, Inc.10UVeriSign Trust Network1G0EU>www.verisign.com/repository/RPA Incorp. by Ref.,LIAB.LTD.(c)981301U*HiTRUST Class 1 CA - Individual Subscriber_$dP[ºûÓnMf%%0 *H÷ |¢#í£µBŽñ¡ÛAØÉÉð²S)Üæª6ÕÉœ-_ò8¥Ol×d(}\îì±Š6üNte;Ozöóé?Ðiðñ:Ýæ.¿ªí#±a¡o×7Të¯wF£]êðäç:É8)=Gã€S:¡û«lÐWWý

1 0

Weird ZSQL Method thing...
by Chris Withers 22 Mar '00

22 Mar '00

Hi, This is weird, I've got a solution but I don't know why I need to use it... I have a DTML Document that uses two ZSQL Methods, something like: <dtml-in item> ...the item ZSQL method returns cid... <dtml-var cid> <dtml-in case> ...the case ZSQL method takes cid as a required parameter </dtml-in> </dtml-in> Now, using this returns an error: Bad Request: [cid] which I've grown accustomed to seeing when a requried parameter is missing. However, if I dtml-comment out the second dtml-in, it works fine and the correct cid is displayed by the dtml-var. The only way I can get it to work is to make the second dtml-in look like: <dtml-in case(cid=cid)> I really don't understand why I need to do this and why the 'case' ZSQL method doesn't just pick up cid from the current namespace... Any ideas? Chris

5 11

RE: [Zope] Server Sizing
by Baker, Dennis (sjmr) 22 Mar '00

22 Mar '00

As far as multiprocessing goes, if I were to run a MySQL database on the same server (serving primarily to Zope) then the multiprocessor config would be a very big performance boost wouldn't it? What about Memory? Again with MySQL. I suppose I should have mentioned it right of. Our main goal is to serve up pages from a database that will be about 500MB-1GB in size. There will be very little information which will be cachable, almost all of the queries are unique. Johan Carlsson wrote: > > > > Beyond that, what do you suggest. Is memory more important than > > processor speed? Is it important to go with a Multi-processor > > server or will Zope/Linux take advantage of a multi processor setup? > > Zope, more correctly Python will not take advantage > of a dual processor. Yes it will, it just won't scale exactly two fold. In almost all Python wrapped C calls, the C code releases the interpeter lock as often as possible, this allways happens, for example, when doing I/O or when calling database library routines. Two processors will give you a noticable benefit. Four or more will probably not. Further, Zope will not be the only process running, so a dual gives you the usual benefits, like doing a compile on one thing without killing your website. > I probably seriously consider buying a ZEO solution > from DC. > I don't know, but a ZEO solution might solve the > problem with 100 continuous concurrent users > writing to the ZODB? ZODB FileStorage was not designed to be write intensive, the goal is to provide a mid-write high-read solution, this solution satisfies 99.9% of all web site needs. You would be surprised how much money you have to pay to Oracle to get, for example, their high write-write distributed database solutions (its in the six figures). ZEO is a distributed storage, but in the end it depends on a mechanism that actual writes the data somewhere. In the stock case, this is a FileStorage. If you want high-write intensity, consider a BerkeleyStorage (which works fine as the backend for ZEO) or offload alot of your high-write intensive data to a relational database. -Michel

3 2

Re: [Zope] dtml-in variables not available to called methods?
by Tres Seaver 22 Mar '00

22 Mar '00

Michel Pelletier <michel(a)digicool.com> wrote: > > Chris Withers wrote: > > > > > Scope. if you also did:- > > > > > > <dtml-call "REQUEST.set('cid',cid)"> > > > > > > It would work too. The dtml-in variables are not available to sub-methods, > > > this surprised me at first too, but, you get used to it :-) > > > > If this is true, it's really counterintuitive and should be changed if > > at all possible. > > This is not true. > > Method A: > > <dtml-with "_(bob='uncle')"> > <dtml-var B> > </dtml-with> > > Method B: > > <dtml-var bob> > > _will_ print 'uncle'. > > > If it's specific to ZSQL methods or in otherwise confusing situations, > > then there's even more reason to change it... > > It is specific to ZSQL Methods, they create their own fresh namespace. > There may be a good reason, I can't think of one. It seems to me that all this would require is passing the "_" namespace in place of the REQUEST when calling the ZSQLMethod -- am I missing something? Values found in the REQUEST would still be found, but would be overridden by any intermediate namespaces (e.g., from dtml-in, dtml-with, or dtml-let). -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

2 1