December 2005 - Zope

Please help with DTML-in (newbie)
by Alric Aneron 29 Dec '05

29 Dec '05

Hello, I am new to Zope and DTML. I am trying to use a python script to call a Z SQL method. The python script also has a list that <dtml-in inside the ZSQL method interates over. so my python script: -----python script words = ['one', 'two'] context.REQUEST.set('wordlist', wordlist) rs = context.myzsqlmethod() return rs[0,2] -----z sql script: SELECT * FROM table WHERE <dtml-in words> column1 LIKE ('<dtml-var "'%'+sequence-item+'%'">' OR column2 LIKE '<dtml-var "'%'+sequence-item+'%'">') <dtml-unless sequence-end> AND </dtml-unless> </dtml-in> --------------- But it doesn't want to, gives me.. Error Type: NameError Error Value: name 'wordlist' is not defined I tried feeding the variable into the ZSQL arguments list, but i got something like "cannot concatenate a module with a str" Can anyone please help me? Thank you! --------------------------------- Yahoo! Shopping Find Great Deals on Holiday Gifts at Yahoo! Shopping

4 4

Re: [Zope] Change ZSQLMethod connection id
by Tino Wildenhain 29 Dec '05

29 Dec '05

Fabio schrieb: > Hi! > I solved (partially) my problem: very thanks. > > I studied acquisition and then I understood your example. > > I've another problem (the last, I hope): I call some ZSQLMethod from > Python scripts so I need to execute a command dynamically. > example > I need to execute > 'container.include.sql.%s.getX()' % container.REQUEST.SESSION['dbconn'] > > but 'exec' is not allowed. Does exist another way or I have to write: > if container.REQUEST.SESSION['dbconn'] == 'conn1': > container.include.sql.conn1.getX() > elif container.REQUEST.SESSION['dbconn'] == 'conn2': > container.include.sql.conn2.getX() > elif ... > > ? > > In ZPT pages I use python:path('python:container.%s.getX()' % var) without > problem but I don't knoe how do the same thing in a script python. > Well, thats just python - I'd suggest skimming thru the python tutorial at python.org at least. You reach objects by getattr(parent,attributename) And in Zope also via: parent[attributename] This should get you going I think. Regards Tino

1 0

mxODBC config probs for MSSQL
by Rob Jingle 29 Dec '05

29 Dec '05

This is an issue regarding the egenix mxODBC drivers for Zope to communicate with MSSQL.Iam having problems configuring th emxODBC on Zope.....Iam not being successfull in creating a connection to SQL server. The error iam getting is: *EGENIX.COM mxODBC Zope DA* Problem connecting to the database Connection string: Driver=SQL Server Connection pool entry: 0 Error message: ('IM003', 0, '[iODBC][Driver Manager]Specified driver could not be loaded', 8222) Any kind of help is appreciated. Thank you, Suhas

3 2

HTTP Post Handler In Zope
by Tom Purl 27 Dec '05

27 Dec '05

Hi everyone. I'm converting my personal web site from a Wordpress blog into a ZWiki wiki site. I transferred all of the content, and would like to create some "redirect pages" so that anyone visiting my old page url's would be redirected to their new home. So, if someone wanted to visit the following old, Wordpress url: http://mysite.com/?p=30 ...the would get redirected to this ZWiki page: http://mysite.com/SomePageName The problem is that I'm not sure how I can "catch" the old url requests. I tried creating a Script (Python) object named "?", but Zope didn't let me use that name. Does anyone have any idea as to how to do this? Any help at all would be greatly appreciated! Tom Purl

2 1

standard_error_message in ZPT
by Sam Boggess 27 Dec '05

27 Dec '05

Does anyone know if it possible to rewrite the standard_error_message in Page Templates? And if so how do you reference the objects within the error message? <p tal:content="here/error_value">error value</p> doesn't work. Thanks.

2 1

Zope Persistence (was: XML-RPC within ZOPE)
by Jan-Ole Esleben 27 Dec '05

27 Dec '05

Thanks; this is a problem we are well aware of. Our solution is to increase the amount of workers, obviously. However, I'm increasingly getting a feeling that for a rather big range of unlikely situations that are nonetheless to be expected, Zope doesn't work _at all_. In a WebServices setting, situations like the one I described, with one server calling back to another server within a call from that latter server and both not knowing anything about the implementation of the other, it would most certainly be extremely hard to foresee the exact setup of such situations and impossible to exclude them for persistent objects that actually _do_ change state (unlike mine). The solution is to not have state in your objects, and thus lose instantly most of what Zope is. However, as I see it, the problem is that what Zope actually _is_ (i.e. mostly the ZODB) is an unhealthy way of coupling data and implementation (which is _exactly_ why my implementation didn't work immediately). This of course comes from its origins in TTW development where there wouldn't actually have been many user made products. Please tell me if I'm wrong with my assumption above, and why. I'm not trying to be inflamatory, this just has me really worried. Ole 2005/12/15, Dieter Maurer <dieter(a)handshake.de>: > Jan-Ole Esleben wrote at 2005-12-11 19:10 +0100: > >Is it at all impossible to use XML-RPC _within_ a ZOPE architecture? > > In principle yes. > > Be careful however: it is easy to introduce deadlocks! > > When during request processing you call back into the same > Zope via XML-RPC, the calling out request will not complete > until the XML-RPC returns a result (this always holds for > calls, XML-RPC or other, to an external or internal server). > > Zope has a limited amount of workers (the default is 4) able > to execute requests. If there are no free workers, requests > have to wait for one. > > Now imagine that as many requests arrive as there are workers > and each of them wants to perform an XML-RPC against the > same Zope. Then you have a deadlock: none of the XML-RPC requests > will finish, because there are no free workers. An no worker > will ever become free again, because each of them waits for > its XML-RPC to finish. > > Therefore, you should directly call internal resources (rather > than use XML-RPC). > > > -- > Dieter >

4 8

Rakun XML Application Platform version 0.3.1 released
by Evrim Ozcelik 27 Dec '05

27 Dec '05

Hi, Rakun aims to integrate database applications into Plone. Currently, it makes existing databases accessible through Plone and supports business logic via scripts. The long-term goal is to provide an enterprise application development framework complete with detailed authorization, workflows, report generation etc. Rakun uses Formulator for specifying the database properties in Zope. It supports PostgreSQL, MySQL and SQLite. For additional information about the project, please visit the home page http://www.rakun.org/ -- Evrim Özçelik Computer Engineer Rakun Core Developer http://www.rakun.org/ +90 212 285 60 56 - 118

1 0

ZDaemon for wsgi server
by David Pratt 26 Dec '05

26 Dec '05

Hi I am looking at light wsgi servers to serve an app but want it to be started from command line and have the thread spun off so it stays running (instead of tying up a terminal until a interrupt is given). I was thinking that perhaps ZDaemon could do this since perhaps I could also get logging as as well and I would not have to potentially write the threading code. If this is reasonable, can someone give me a basic outline for doing this. I am interested in running the wsgiserver locally. Many thanks. Regards, David

3 3

Zope 3.2.0 beta 2 released!
by Stephan Richter 25 Dec '05

25 Dec '05

The Zope 3 development team is proud to announce Zope 3.2.0 beta 2. Zope 3 is the next major Zope release and has been written from scratch based on the latest software design patterns and the experiences of Zope 2. It is our opinion that Zope 3 is more than ready for production use, which is why we decided to drop the 'X' for experimental from the name. We will also continue to work on making the transition between Zope 2 and Zope 3 as smooth as possible. As a first step, Zope 2.8 includes Zope 3 features in the form of Five. This is a long term effort. We're not there yet. **You can't run Zope 2 applications in Zope 3.** Downloads http://zope.org/Products/Zope3 Installation instructions for both Windows and Un*x/Linux are now available in the top level 'README.txt' file of the distribution. The binary installer is recommended for Windows. Zope 3.2 requires Python 2.4.2 to run. You must also have zlib installed on your system. Most Important Changes Since 3.2b1 New features - Added an option to mkzopeinstance to create instances that use ZServer, rather than Twisted. - Changed the way returning large results is handled. Applications can now simply return files to the publisher. Bug Fixes - Added input buffering to the twisted integration - Fixed the plumbing in ZServer so that attempts to return large output efficiently using iterators can actually succeed. For a complete list of changes see the 'CHANGES.txt' file. Resources - "Zope 3 Development Web Site":http://dev.zope.org/Zope3 - "Zope 3 Dev Mailing List":http://mail.zope.org/mailman/listinfo/zope3-dev - "Zope 3 Users Mailing List":http://mail.zope.org/mailman/listinfo/zope3-users - IRC Channel: #zope3-dev at irc.freenode.net Acknowledgments Thanks goes to everyone that contributed. Enjoy! The Zope 3 Development Team

1 0

Zopezen.org
by Brian Sullivan 24 Dec '05

24 Dec '05

Anybody have any idea what has happened to zopezen.org? >From where I am sitting it has been awol for at least a day.

1 0