July 1999 - Zope - Zope lists

Re: [Zope] ZODB and quotas
by michel＠digicool.com 05 Jul '99

05 Jul '99

Andreas Kostyrka <andreas(a)mtg.co.at> writes: > On 1 Jul 1999 michel(a)digicool.com wrote: > > > It might be possible, note that it would have the same limitations as > > du: it would 'wake up' (activate from the Object Store) all objects to > > guage their size, and then there is the question of previous object > > versions, should you consider the size of previous versions in the > > Object Database? > > Interesting questions. I've been thinking more on the side of the ISP > hosting Zope sites. It's not a question if the site takes 20.0 or 20.1MB, > but it's a difference if it's 20MB or 160MB. > > Previous Versions should probably not count, as they disappear when the > database is packed, right? > Yep. Of course, this is quickly solved by making 'accumlate previous vesions' an option. Someone might want to know the absolute total of all of their object, including previous versions. Taking this discusion a level further, it might even be nice to be able to just 'pack' a subfolder, so someone who has reached their quota can free up some space by cleaning out older versions. Of couse, a more privledged user could override that by packing 'above' their folder. -Michel > Andreas > -- > Win95: n., A huge annoying boot virus that causes random spontaneous system > crashes, usually just before saving a massive project. Easily cured by > UNIX. See also MS-DOS, IBM-DOS, DR-DOS, Win 3.x, Win98.

2 1

Re: [Zope] ZODB and quotas
by michel＠digicool.com 05 Jul '99

05 Jul '99

Andreas Kostyrka <andreas(a)mtg.co.at> writes: > Hi! > > I've been wondering how well ZODB deals with disk full conditions? > Is it reasonable to put one Zope account quotas? > > (Side note: Is there any way to do something equivalent to ``du'' with > Zope? Finding out how much storage is used by some Subfolder, > even if not very accurate would be probably a "good thing". > It might be possible, note that it would have the same limitations as du: it would 'wake up' (activate from the Object Store) all objects to guage their size, and then there is the question of previous object versions, should you consider the size of previous versions in the Object Database? -Michel > Andreas > -- > Win95: n., A huge annoying boot virus that causes random spontaneous system > crashes, usually just before saving a massive project. Easily cured by > UNIX. See also MS-DOS, IBM-DOS, DR-DOS, Win 3.x, Win98. > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev )

4 4

ZODB and quotas
by Andreas Kostyrka 05 Jul '99

05 Jul '99

Hi! I've been wondering how well ZODB deals with disk full conditions? Is it reasonable to put one Zope account quotas? (Side note: Is there any way to do something equivalent to ``du'' with Zope? Finding out how much storage is used by some Subfolder, even if not very accurate would be probably a "good thing". Andreas -- Win95: n., A huge annoying boot virus that causes random spontaneous system crashes, usually just before saving a massive project. Easily cured by UNIX. See also MS-DOS, IBM-DOS, DR-DOS, Win 3.x, Win98.

2 1

mySQL image addition
by Phil Grove 05 Jul '99

05 Jul '99

hi all, has anyone used mySQL to hold a number of images uploaded using Zope? If so how can it be done, i have tried using the normal INSERT statments into a BLOB field in the database but it only seems to insert a strange instances string?? Any ideas would be appreciated. P. --------------------------------------------------------------------- Phil Grove phil.grove(a)flg21.com Web Development 0113 2949494 flg21 http://www.flg21.com ---------------------------------------------------------------------

2 1

RE: [Zope] Pluggable brains?
by Alexander Staubo 05 Jul '99

05 Jul '99

Uh, so "pluggable brains" _is_ the ability for Zope to return records as instances of a user-definable class? It may be a vivid term, but descriptive it ain't. :-) I have a related question. I need to post-process a query result set using Python; I simply want to (a) go through each record and add (or set) a column, and (b) reorder the records. Can you give me a simple example of how to do this? As far as I can see, records returned by SQL Methods are instances of a special class "r" which descends from Record, Acquisition.Implicit and an optional user-defined class (the "brain", I guess). It seems that when such an instance is created, each column is set as an attribute on the instance. If so, I guess I can simply put the records into a list, add my column as a vanilla Python attribute, and reorder them as I wish, and then return them for use in DTML? Correct? -- Alexander Staubo http://www.mop.no/~alex/ "Reality is that which, when you stop believing in it, doesn't go away." --Philip K. Dick >-----Original Message----- >From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of >Phillip J. Eby >Sent: 5. juli 1999 02:20 >To: Alexander Staubo; Zope Mailing List (E-mail) >Subject: Re: [Zope] Pluggable brains? > > >At 01:07 AM 7/5/99 +0200, Alexander Staubo wrote: >>Could somebody explain the concept of pluggable brains? I have come >>across this phrase more than once, and I still don't know >what it is. Is >>there any documentation on this? >> >>Is it by any chance related to an SQL Method's ability to >represent data >>records with Python classes? > >Yes. Sorry for the term, I picked it up from Jim Fulton back >when it was >an about-to-be-added feature for Principia/Aqueduct. As with so many >Fultonisms, it's vivid and tends to stick in one's >(non-pluggable) brain. > > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://www.zope.org/mailman/listinfo/zope > >(For developer-specific issues, use the companion list, >zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

2 1

Zope startup problem
by Joerg Wittenberger 04 Jul '99

04 Jul '99

Hello folks, I'm new to zope and so am I to python. But as zope seems to implement some things I dreamed up long ago I'm goint to learn both now. First I'd like to try a bit, but I ran into a startup problem: ------------------- $ python z2.py -d 127.0.0.1 zdeamon: Sun Jul 4 23:23:39 1999: Houston, we have forked zdeamon: Sun Jul 4 23:23:39 1999: Hi, I just forked off a kid: 6779 zdeamon: Sun Jul 4 23:23:39 1999: Houston, we have forked Traceback (innermost last): File "z2.py", line 319, in ? exec "import "+MODULE in {} File "<string>", line 1, in ? File "/home/jerry/build/Zope-2.0.0a3-src/lib/python/Zope/__init__.py", line 10, in ? import ZODB, ZODB.FileStorage, ZODB.ZApplication File "/home/jerry/build/Zope-2.0.0a3-src/lib/python/ZODB/FileStorage.py", line 154, in ? import struct, time, os, bpthread, string, base64 ImportError: No module named base64 zdeamon: Sun Jul 4 23:23:39 1999: Aiieee! 6779 exited with error code: 256 ------------------- Any clue? My python is version1.5.2 but came binary - might I miss something standard? Thanks /Jerry PS: Please at least Cc your reply to me - I'm offline now and not yet subscribed to the zope list.

1 0

Earth to Digital Creations!
by Alexander Staubo 04 Jul '99

04 Jul '99

I am still struggling with core dumps trying to run Zope 2.0.0a3 under Linux 2.2. Could somebody please assist? -- Alexander Staubo http://www.mop.no/~alex/ "`This must be Thursday,' said Arthur to himself, sinking low over his beer, `I never could get the hang of Thursdays.'" --Douglas Adams, _The Hitchhiker's Guide to the Galaxy_

3 2

Re: [Zope] newbie question
by Tony McDonald 04 Jul '99

04 Jul '99

> Thanks for your help Tony/Bill > > I'm making progress with this but have a few more questions: > > 1. I've just worked out I need to pass two parameters to the second query > (branch and customer no). If I hardcode the branch no into the SQL method and > pass only the customer number it works, but how do I pass both variables? I've > tried using a + and & between the two variables as below but no joy. > > <tr> > <td><a href="linktest02?Branch=&linktest02?Customer="</a> >  / </td> > > <td></td> > <td></td> > </tr> > Alexander has given you the good stuff about URL encoding etc... > > 2. Tony - in your edit_me object : > >  >  > > I can't work out where the expr=find_staff_number ties into all the other > code, is it another separate query like find_staff? > > Apologies for that, it is a separate query, the single argument is staff_number select staff_number, title, forename, surname, department, job_title, tel_no, fax_no, email from staff where staff_number = '' order by surname asc > 3. In the find_staff query: > >  > > Is "search_field=search_type, search_item=search_term" using named fields > from your database or is it just a general piece of code I can use as is? > Again, more apologies here. The find_staff object is a ZSQL method too: arguments are 'search_field search_item' (no , between them) select staff_number, title, forename, surname, department, job_title, tel_no, fax_no, email from staff where  like  order by surname asc If you look closely, you'll see that we're using Zope to tell the SQL query what field to search on (ie, is search_field = 'tel_no' and search_item = '%0191%' the query is actually: select staff_number, title, forename, surname, department, job_title, tel_no, fax_no, email from staff where tel_no like '%0191%' order by surname asc (this can be really useful!) The ZSQL query uses the arguments search_field and search_item, but is passed the Zope variables search_type and search_term. Within the HTML <FORM> we have [1]: <a href="display_all_staff?search_term=a%">A</a> <a href="display_all_staff?search_term=b%">B</a> etc. This part of the code allows all staff whose surname begins with 'a', 'b' etc. to be displayed easily. we also have a popup menu, allowing the user to select what field to search on: <select name=search_type> <option value="surname" selected>Lastname <option value="forename">Firstname <option value="department">Department <option value="title">Title <option value="job_title">Job Title <option value="tel_no">Telephone <option value="fax_no">Fax <option value="email" >Email </select> This is where the Zope variables search_field and search_term are defined. We also have another input type <input type=text name=searchit> Which is used for free-form text entry (ie a query that is more complex than the ones in [1]) If the person has put something in the searchit input (ie they want a more complex lookup), we need to do some Zope Voodoo..    All this does is to create a new variable 'search_term' to '%' + value of search_it +'%' ready for the ZSQL method. Zope2 has a *much* nicer way of doing this, but let's not muddy the water too much. Some more Voodoo is needed to make sure that the two arguments we send to the ZSQL method are defined;       Then we call the ZSQL method;  ...  > Really appreciate your help as I've been given two weeks to put together a > demonstration intranet and I've never seen Zope (or anything else before) and > only have the User Guides for help. Major learning curve!! Thanks > > Jenny Stick with it! - Zope has some weird ways of doing things it's true, but some things it does are quite beautiful (what a word to use when describing software! :) - and just wait until you get the hang of Acquisition...awesome. Grab hold of the How-To docs and scour them, get hold of the archives of the mailing list, ask questions here and don't forget that if you have a budget for setting up this demo, then you can call on the DC people who will help you set up a killer intranet demo! HTH Tone,

1 0

RE: [Zope] RE: Thread subjects
by Alexander Staubo 04 Jul '99

04 Jul '99

Sorry for posting a private email to the Zope list. I have NO IDEA how it got here -- a case of premature senility, perhaps. -- Alexander Staubo http://www.mop.no/~alex/ "Reality is that which, when you stop believing in it, doesn't go away." --Philip K. Dick >-----Original Message----- >From: Alexander Staubo [mailto:alex@mop.no] >Sent: 4. juli 1999 03:07 >To: Zope Mailing List (E-mail) >Subject: [Zope] RE: Thread subjects > > >They forecast "three weeks" until the beta will be available. > >The alpha is already apparently quite stable, this despite the >fact that >I have not yet gotten the alpha working on our Linux box yet. :-/ I >strongly believe it has something to do with our setup rather than Zope >itself, but it's hard to tell. > >Zope does not really change any functionality as much as it brings new >stuff. And even on that point the two biggest changes are: > >- a better object database system, with support for multiple database >backends (such as Microsoft SQL Server or Oracle) and concurrency >(meaning several people can view a page exactly >simultaneously; this may >surprise you, but that isn't possible in earlier releases!). >- support for classes (which is already in the 1.11.0 preview release >I'm working with; a let me tell you, that's one really stable preview >release!) > >The big thing that _does_ change things comes with the Portal Toolkit, >but again this is simply about new features that we can exploit but -- >until it does arrive -- have to implement ourselves. Mostly this >involves memberships. And we can certainly implement all that without >ZPT for the beta, I think. > >Does this help? > >-- >Alexander Staubo http://www.mop.no/~alex/ >"Reality is that which, when you stop believing in it, doesn't go >away." >--Philip K. Dick > >>-----Original Message----- >>From: slavine(a)post.harvard.edu [mailto:slavine@post.harvard.edu] >>Sent: 4. juli 1999 02:49 >>To: Alexander Staubo >>Subject: RE: Thread subjects >> >> >>How long until "Zope 2" is fully up and running (I forget >what you keep >>calling this new Zope thing). I'd hate to work things out and >>then have to >>change them all around because of new functionality. >> >> > > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://www.zope.org/mailman/listinfo/zope > >(For developer-specific issues, use the companion list, >zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

RE: Thread subjects
by Alexander Staubo 04 Jul '99

04 Jul '99

They forecast "three weeks" until the beta will be available. The alpha is already apparently quite stable, this despite the fact that I have not yet gotten the alpha working on our Linux box yet. :-/ I strongly believe it has something to do with our setup rather than Zope itself, but it's hard to tell. Zope does not really change any functionality as much as it brings new stuff. And even on that point the two biggest changes are: - a better object database system, with support for multiple database backends (such as Microsoft SQL Server or Oracle) and concurrency (meaning several people can view a page exactly simultaneously; this may surprise you, but that isn't possible in earlier releases!). - support for classes (which is already in the 1.11.0 preview release I'm working with; a let me tell you, that's one really stable preview release!) The big thing that _does_ change things comes with the Portal Toolkit, but again this is simply about new features that we can exploit but -- until it does arrive -- have to implement ourselves. Mostly this involves memberships. And we can certainly implement all that without ZPT for the beta, I think. Does this help? -- Alexander Staubo http://www.mop.no/~alex/ "Reality is that which, when you stop believing in it, doesn't go away." --Philip K. Dick >-----Original Message----- >From: slavine(a)post.harvard.edu [mailto:slavine@post.harvard.edu] >Sent: 4. juli 1999 02:49 >To: Alexander Staubo >Subject: RE: Thread subjects > > >How long until "Zope 2" is fully up and running (I forget what you keep >calling this new Zope thing). I'd hate to work things out and >then have to >change them all around because of new functionality. > >

1 0