March 2000 - Zope - Zope lists

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

Find/Replace?
by Mario Lang 22 Mar '00

22 Mar '00

Hi. I am wondering if I can do a search/replace in the ZODB for e.g. every DTML Document (just like search, but with a replace-with field)? Is there anything planned or under development? This would be rather useful to easily use Acquisition with content imported from HTML files. Someone could replace a menubar (which appears in all files the same) just with the <dtml-var ...> call and create a DTML method which holds this content. CYa, Mario <mlang(a)delysid.org>

1 0

Parameter puzzle
by Mark Andrew 22 Mar '00

22 Mar '00

Hi Zopistas while trying to make gtk's (very useful) Boring Product (slightly more) interesting, I came across the following (for me) strange behaviour. manage_ methods seem to always have "REQUEST=None" as their last parameter. If I remove the "=None" from manage_edit then I notice no difference, so the actual parameter is presumably being passed. However if remove the complete formal parameter (and the reference to REQUEST in the body of the method) def manage_edit(self, title): """does this really need a doc string?""" self.title = title # if REQUEST is not None: # return MessageDialog( # title = 'Edited', # message = "Properties for %s changed." % self.id, # action = './manage_main', # ) then everything still works ! Why is python not complaining about a parameter mismatch ? I promise to publish a Howto on making Boring more Interesting when this madness is over. Thanks in advance Mark -- BOSCH Telecom - UC-PN/ECC1 - Kleyerstr. 94 - D-60326 Frankfurt a M fon:+49 69 7505-6346 mailto:mark.andrew@fr.bosch.de fax:+49 69 7505-6168 http://SoftTech.fr.bosch.de (Bosch Only)

2 1

indexing and searching for a date
by Anders Holmbech Nielsen 22 Mar '00

22 Mar '00

Hi, As I found out - you can not index numbers and therefore not search for dates using the zCatalog. But I was wondering 'bout workarounds. I thougt maybe if I could change the bobo_modification_date to one of my own. That I could search for. But that seems like a pretty crappy workaround... Ideas.... anyone ??? Has anyone modified the Zope index method to also index numbers ?? Regards ------------------------------------------------- Anders Holmbech Nielsen | Tlf: (+45) 70 22 56 00 Software Engineer | Fax: (+45) 70 22 57 00 Integrator Uniware A/S | http:/www.integrator.dk

3 3

Zope : Load_site features request
by Sin Hang Kin 22 Mar '00

22 Mar '00

Load_site is a greate product. I am using it to upload a brunch of files to zope now, I found I have an idea : In order to make the uploaded zope more alive, I would like the load_site to make everyfile in the original archive an folder in zope, with index.html representing the structure of the original html file. And all the contents goes to obj1, obj2, .... reside on the same folder. For example, Index_html : <dtml-var standard_header> <body><p><dtml-var object1></p><table><tr><td><dtml-var object2></tr></td></table> </body> <dtml-var standard_footer> This would make the resulting zope site more close to the zen of Zope. I am not very good in python but please give me some hints to made this modification. Will you make the change? Rgs, Kent Sin

1 0

sequence-item naming
by Ken Kinder 22 Mar '00

22 Mar '00

I am trying to use a call like this: <dtml-in assignments> <dtml-call "foo(var=sequence-item)"> </dtml-in> But it gives me Name Error: sequence. Two questions: (1) Why are there -'s in variable names? (2) How do I get around that? -- Ken Kinder 303.381.7631

5 4

Alternating Cols or Colors
by Ken Kinder 22 Mar '00

22 Mar '00

Does anyone know an elegant way (or a way at all) to alternate what color rows in a table are or to alternate which column a cell is on? A less-than-elegant solution would be to somehow assign a variable 1, check and see if it's on 1, show one color, set it to 2, show the second color, etc... But I'm not sure what I'm doing wrong with dtml-let to do that: <dtml-let c="1"></dtml-let> .. ? -- Ken Kinder 303.381.7631

4 3

Sybase: How generate id keys? (surrogate keys)
by Hung Jung Lu 22 Mar '00

22 Mar '00

Hi, How do people generate id keys (surrogate primary keys) in Sybase+Zope? There are some recommended ways of doing it in Sybase with stored procedures but I can't run stored procedures in Sybase. I am looking at heavy-traffic strategies. So I need something slightly better than a simple increment table for the keys. Any recommendations? Thanks in advance. Hung Jung ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

2 1