July 1999 - Zope - Zope lists

RE: [Zope-dev] Serious bug with gadfly transactions?
by Rob Page 28 Jul '99

28 Jul '99

If you use relational databases with Zope, please read: In the context of Database Adapters, Zope 2 introduces two new things: (a) concurrency (b) a different (better, faster, cheaper.. um, well still free) approach to transactions EACH Database Adapter has to be modified so that it addresses (a) above. This will be done according to the Levels detailed in an earlier post. To briefly recap: o Level 1 DA -- you must run Zope2 in single-threaded mode o Level 2 DA -- "thunked.." transactions are serialized inside the DA code o Level 3 DA -- fully threaded A different and largely unrelated issue is how the DA interacts with Zope's transaction machinery (i.e., (b) above). With the exception of a Sybase DA we are working internally for a consulting customer we have not made any progress (internally) on this. This will cause the behavior Martijn describes below. A DA can be Level 3, high-speed, long-range, low-drag and still not be integrated with the new transaction machinery. Conversely, a DA can be integrated into the new transaction machinery and require Zope be run in single threaded mode. I _guarantee_ that today, we will make a Database Adapater status page available on the Zope site. --Rob > -----Original Message----- > From: Martijn Pieters [mailto:mj@antraciet.nl] > Sent: Wednesday, July 28, 1999 7:36 AM > To: Zope Development > Subject: [Zope-dev] Serious bug with gadfly transactions? > > > I'm looking for confirmation on this: > > In Zope 2.0b1 (and the latest CVS): > > - When using a gadfly database, nothing is committed, ever. > When shutting down Zope, all transactions to gadfly are > aborted, and all > data is gone. > > - When doing multiple SQL update/insert/create calls, and > making an error > in any but the first call leaves any previous call in the DB, > they are not > rolled back. > So, when, in one request, you do an insert and an update, and > the update > raises an error, the insert is not rolled back. > > Does anyone else see this? > > -- > Martijn Pieters, Web Developer > | Antraciet http://www.antraciet.nl > | Tel: +31-35-7502100 Fax: +31-35-7502111 > | mailto:mj@antraciet.nl http://www.antraciet.nl/~mj > | PGP: > http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 > ------------------------------------------ > > _______________________________________________ > Zope-Dev maillist - Zope-Dev(a)zope.org > http://www.zope.org/mailman/listinfo/zope-dev > > (To receive general Zope announcements, see: > http://www.zope.org/mailman/listinfo/zope-announce > > For non-developer, user-level issues, > zope(a)zope.org, http://www.zope.org/mailman/listinfo/zope ) >

2 1

RE: [Zope] wrong value for integer variable?
by Donald Holten 28 Jul '99

28 Jul '99

It just hung up again, and this time without the manage_changeProperty line. Donner

1 0

RE: [Zope] wrong value for integer variable?
by Donald Holten 28 Jul '99

28 Jul '99

Something very interesting... I changed the code as you said, and, as I sort of figured, it didn't work (only because I saw that python has no way to convert strings to ints). But in the process I found something else. If you'll note, on my previous message I had the line: <!dtml-call "manage_changeProperty(numtemp = numtemp + 1)"> On the message you sent me, you had: <dtml-call "manage_changeProperty(prop = prop + 1)"> Note the exclamation mark I added. I added it because, without it, Zope can't find manage_changeProperty. For a little while things seemed to be working, except the error I was getting. But then Zope hung indefinitely (over 20 minutes) for loading a page, so we killed the python process. Upon further testing, I discovered that my line would sort of work when viewing index_html once. If I pressed "change" on index_html without changing anything after that first viewing, Zope would once again hang indefinitely (taking up 98% of the CPU while it was at it). Donner

1 0

Zope in schools
by Tim Wilson 28 Jul '99

28 Jul '99

Hi *, I'm going to be building a Web site for my high school science department over the next few weeks, and I'd like to get some suggestions from this group. I'm one of the teachers BTW, working on this site as part of my M.Ed. I am so impressed with Zope. I can envision lots of ways to use it to create a site that will keep my students coming back and provide an additional way to communicate with their parents about our courses. I've been following this listserv for a few weeks now, reading some docs, and thinking, but I want to ask: If you were going to create a Web site for a high school science department (the coolest such Web site every conceived :-), how would you utilize Zope? Think big! I hope your comments can help me identify and prioritize features that would have maximum affect on my students' learning. -Tim -- Timothy D. Wilson "A little song, a little dance, University of MN, chem. dept. a little seltzer down your wilson(a)chem.umn.edu pants." -Chuckles the Clown Phone: (612) 625-9828 as eulogized by Ted Baxter

3 3

Re: [Zope] Any recommendations on folder and content organization?
by Andrew M. Kuchling 28 Jul '99

28 Jul '99

Michael Wang-Helmke writes: >have to look at all of the SQL methods. What I would like is some way >to have a folder just for SQL methods that is below the root and some >way to refer to this folder from anywhere below the root. What I've done is have a top-level folder named 'sql', and put all the queries in it. So if retrieve_use is one query, you can call it with   ... whatever ...   I think  would work, too, though I haven't verified that. In an ExternalMethod that accepts a self argument, you can then refer to self.sql.retrieve_user(REQUEST=REQUEST, arg1=X, arg2=Y, ...). -- A.M. Kuchling http://starship.python.net/crew/amk/ I won't eat any cereal that doesn't turn the milk purple. -- Bill Watterson, _The Authoritative Calvin and Hobbes_

1 0

Re: Zope in schools
by Butch Landingin 28 Jul '99

28 Jul '99

In my searches for web-collaboration software (as part of my research for new features which might be incorporated into Squishdot), I found this website, www.blackboard.com, which sells a high-priced commercial product, but you could probably glean a lot of ideas from it which can easily be re-implemented in Zope. HTH. Best Regards, Butch Landingin butchland(a)yahoo.com _____________________________________________________________ Do You Yahoo!? Free instant messaging and more at http://messenger.yahoo.com

1 0

RE: [Zope] formatting date values.
by Rob Page 28 Jul '99

28 Jul '99

> I've been wondering how one can format with the var tag a > date value as > DD.MM.YYYY or DD/MM/YYYY? Enclosed is snippet of UNSUPPORTED, NOT-IN-CVS, CAVEAT EMPTOR, YMMV code that you might be able to put in DateTime.py _Possibly_ with Jim's blessing and a little documentation tweak these _might_ get into CVS... [Did I hedge enough?] # New formats def aDotIntlDate(self): """Return a string representing the object\'s value in the format: 21.03.1999""" return '%.2d.%.2d.%.4d' % ( self._day, self._month, self._year) def aSlashIntlDate(self): """Return a string representing the object\'s value in the format: 21/03/1999""" return '%.2d/%.2d/%.4d' % ( self._day, self._month, self._year) you would then use something like:  or  To answer a related question, we are considering mechanisms by which the process for adding new: o time expressions o timezones o currency expressions etc., is much less dependent on the current patch-the-code mechanism and would thereby let people _easily_ define their own date and currency formats without having to repatch their software every time a release is made. Of course, the Z2 alpha and beta process has taken some attention away from this. I would encourage you to join the Zope Internationalization Project (ZIP). --Rob

2 2

RE: Real world stress-testing
by Butch Landingin 28 Jul '99

28 Jul '99

-----Original Message----- From: Michel Pelletier [mailto:michel@digicool.com] > I'd be curious to find out if he had a high system load average, or if he felt most of his lag > was due to network congestion, or both. <snip> Again, from one of the /. entries by Bruce : > It's spending 90% of its time in Python. This is no surprise for a Pentium 120, it's time to > make a trip to Fry's for a better CPU/motherboard, I guess. The 768K bit-per-second line is not > being saturated. Plus its using Squishdot -- which is pretty pre-alpha and has'nt been optimized at all... I know, I wrote it... There's probably a big bottleneck in the way it's building the list of articles which may/may not account for its slowness... I haven't done any profiling on it, which I probably need to do before I recommend it for production use... but I guess some people like to live on the *_bleeding_* edge ;^) A-little-bit-just-too-Real-world-stress-testedly-yours, Butch butchland(a)yahoo.com _____________________________________________________________ Do You Yahoo!? Free instant messaging and more at http://messenger.yahoo.com

1 0

Any recommendations on folder and content organization?
by Michael Wang-Helmke 28 Jul '99

28 Jul '99

hi all, I'm developing an in-house bug database in Zope with bugs stored in an external SQL database. I'm writing many many ZSQLMethods and I'm beginning to wonder if there is a better way to organize how I'm storing them. I'm ending up with many SQL methods at my top level because all decendant things in folders may need to refer to them. But this is cluttering up my navigation through my Folders because I have to look at all of the SQL methods. What I would like is some way to have a folder just for SQL methods that is below the root and some way to refer to this folder from anywhere below the root. root | --- SQLMethods | --- sub folder 1 | |___sub sub folder 1 | --- sub folder 2 All of the sub folders should be able to reference stuff in SQLMethods. Any ideas? thanks very much, Michael Wang-Helmke

2 1

Newbie question about trees
by Carlos Henrique Bauer 28 Jul '99

28 Jul '99

Hi, I want to define a tree where branches_expr is not equal to "objectValues('Folder')". In fact a folder should appear in the tree just if one of its attributes is equal to a certain value. How can it be done? Best regards, -- Carlos Henrique Bauer

2 1