June 1999 - Zope - Zope lists

RE: [Zope] A single value from SQL
by Rob Page 05 Jun '99

05 Jun '99

> Right. Essentially I want to treat the SQL method like a function call > which returns a value and not a list. Two points... First, all SQLMethods return lists. This eliminates the need to test if the result from a ZSQLMethod is a value or a list in DTML every single time you use a ZSQLMethod object -- this is a Win. Of course, your point about wanting to cleanly get at what you know to be a single row (e.g., SELECT MAX) is a very common one. I'll poke around and see what I see -- IMO, you and Oleg are right, there should be (probably is) a way to grab the data directly. --Rob

1 0

RE: error in docs
by Rob Page 05 Jun '99

05 Jun '99

Daniel: > There's an error at > http://www.zope.org/Documentation/Guides/ZSQL/ZSQL-HTML/ZSQL.h > tml#pgfId-930972 > > that is confusing: Thanks for the report! I've added to the Zope Comunity's Bug Collector at: http://www.zope.org/Collector/299/view I suspect that the change will be incorporated into a near-future version of the document. Our main source of bugs (software and docs) is the Collector. Any time yo find something that isn't just right, please get it into the Collector so it has good visibility! Tks, --Rob

1 0

RE: [Zope] A single value from SQL
by Rob Page 05 Jun '99

05 Jun '99

> So there isn't a way to directly call one ZSQLMethod from > another, then. I just tried this (and it worked!) with a simple Gadfly database: SELECT * FROM employees WHERE age =    where sqlSelectOldestAge: ---------------------------- SELECT MAX(age) AS oldest_age FROM employees --Rob

3 2

RE: [Zope] A single value from SQL
by Rob Page 05 Jun '99

05 Jun '99

> What I'm really trying to do here is: > > select * from some_table where some_column = (select max(some_column) > from another_table) > > but MySQL doesn't support nested selects (yet). > > I'm quite confident there's a way to do this -- I was reading about > direct traversal -- but I can't quite grasp it. <UNTESTED> ZSQLMethod1 ------------- SELECT MAX(some_column) AS fred FROM another_table ZSQLMethod2 ------------- SELECT firstname, lastname, email FROM some_table WHERE some_column =  DTMLMethod1 -------------   ,     </UNTESTED> --- I'd bet there's a way of doing _something_ like (I know I'm missing a sequence-item in here somewhere...) :   which would be more elegant if harder to read... --Rob

2 1

A single value from SQL
by Daniel M. Drucker 05 Jun '99

05 Jun '99

(Yes, I'm asking a lot of questions. Hopefully the answers to the more interesting ones can eventually make their way into documentation...) I want to do something like this pseudo_sql_method: select * from some_table where some_column =  other_sql_method looks like this: select max(some_column) from another_table The point being that other_sql_method is guaranteed to return a single value. I want to take that single value and directly interpolate it into the text of pseudo_sql_method. What I'm really trying to do here is: select * from some_table where some_column = (select max(some_column) from another_table) but MySQL doesn't support nested selects (yet). I'm quite confident there's a way to do this -- I was reading about direct traversal -- but I can't quite grasp it. Daniel Drucker

1 0

ANN: Experimental zope->static html mirror external method
by Dr. Ross Lazarus 05 Jun '99

05 Jun '99

Anyone needing to write a static html rendition of a zope site to a file system is welcome to try a very rough pre-alpha external method. fileme.py and fileme.txt are available via anonymous ftp at rossl.gmp.usyd.edu.au - or ftp://rossl.gmp.usyd.edu.au/ if you need to use a web browser. A more stable product will eventually appear. Please only try this release if you like to live dangerously....wget is safer and can probably do a better job. Bug reports, fixes and constructive comments to rossl(a)med.usyd.edu.au

1 0

Changing default new document contents
by Mitchell Marks 05 Jun '99

05 Jun '99

(I swear, I read the answer to this earlier today, but now cannot track it down.) Is there a document or method which gets copied or instantiated to provide what's put into a new document (or method) by default? I mean the  <h2></h2> <p> This is the  Document. </p>  To put it the other way around, can I modify or replace that, for a folder, by saving the different version under a reserved name id? And expect that then subsequent new documents anywhere under that folder will start out with my modified starter text. Somewhere I got the idea that dtcTemplate was the reserved name, but that doesn't seem to work. Thanks, Mitch Marks -- Mitchell Marks (773) 702-6041 AAC-010A CUIP: Chicago Public Schools / Univ. of Chicago Internet Project http://cuip.uchicago.edu/cuip Restore ``Under City Stone'' mural, 55th at Lake Park underpass!

2 2

What are the differences between DTML Document and DTML Method?
by T. C. Huang 05 Jun '99

05 Jun '99

Hi, Maybe this is a FAQ, but it does appear in the documents about Zope I've ever seen. Any one would like to make me clear? Thanks! T.C. Huang

1 0

Re: [Zope] FYI: Portal Toolkit Slides and Demo available
by Simon Michael 04 Jun '99

04 Jun '99

"Andrew M. Kuchling" <akuchlin(a)mems-exchange.org> writes: > programming. (But without automatic reloading of ExternalMethods, The above is easy to hack in, btw, and was darn useful to me when debugging methods. I think I posted about it on this list way back.

1 0

RE: [Zope] Running ZopeHTTPServer and PCGI together = a bad thing ?
by Michel Pelletier 04 Jun '99

04 Jun '99

> -----Original Message----- > From: Tony McDonald [mailto:tony.mcdonald@ncl.ac.uk] > Sent: Thursday, June 03, 1999 4:05 AM > To: Michel Pelletier; Zope List > Subject: RE: [Zope] Running ZopeHTTPServer and PCGI together = a bad > thing ? > > > >Yes there is some rather expensive forking overhead that > must be done to > >get from Apache to the Zope long running process. This is startup > >overhead only, once the connection gets to Zope the 'time to > complete' > >will be identical. > > Is this a fork for *every* request, eg every link I select. In that > case, isn't it pretty expensive overall? > A wafer-thin CGI program is forked for every request, this is used to connect up Apache and the Zope long running process. So yes, this expensive fork happens for every request. It's no different, however, then other CGI overhead. One of these days, someone is going to write a mod_pcgi module for Apache, and take that expensive fork out. For light loads, it's really not noticeable, but for heavy loads, one fork per request gets heavy. ZServer is noticably faster in this regard than Apache. > > I've used bbb.py from the Zope 2 distribution to create XML > transactions for 0.. 9211505 and 11844613... 11847812 (but that still > leaves 9211505..11844613 in limbo) > > unnh... so what are my options now? > Well, first realize that corruption is corruption, there may be no way to get some of your info back from the lala lands. If two process writes conflicted with each other, one wins, and one looses (often the winner however does not win completely, but leave a corrupted record behind). > 1) Chop the database at location 11844613 (but then what about the > junk at 9211505) Hmm.. first off, does it crash your Zope when you try and use it correctly? I would try wacking off the last 3K or so bytes starting at the last corrupted record, and then try exporting some stuff out, look for the point in managing the site where it breaks, this is probably where it encouters the broken record. > 2) export as much as possible to .bbe files and reimport into a clean > database? If you can export these objects, try this at least to preserve your information somewhere. > 3) use the bbb.py from the Zope 2 distribution to get transactions in > XML (but then how do I recreate the database - bbb.py doesn't mention > creation of a database)? Uh yeah, the whole XML thing isn't complete yet. The dump to XML is really for database inspection, not manipulation or transportation, for the moment. This will probably change. -Michel > 4) give up? ... nope, that's not an option. Zope is just so > damn useful. > > I hate to say this, but HELP! > Tone

5 4