- Zope - Zope lists

RE: [Zope] Zope question (while using Plone)
by Christopher A. Nethery 21 Nov '06

21 Nov '06

Thanks Maciej! That really clarifies things for me. Per your last question, I am building a custom page template in the ZMI of my PLONE instance. Should I be approaching this in a different way? Thanks and best regards, Chris -----Original Message----- From: Maciej Wisniowski [mailto:maciej.wisniowski@coig.katowice.pl] Sent: Tuesday, November 21, 2006 3:43 PM To: Christopher A. Nethery Cc: zope(a)zope.org Subject: Re: [Zope] Zope question (while using Plone) > ZSQL Method Arguments: > > ---------------------- > > start_date, end_date > > <div tal:repeat="result here/DBTestQueryMethod"> So... where are the arguments? ;) You need something like: > <div tal:repeat="result python:here.DBTestQueryMethod(start_date='date1', end_date='date2')"> If I can advise, then use three objects: 1. index_html - Script(Python) 2. body - ZPT 3. DBTestQueryMethod - ZSQLMethod index_html may be something like: --------------------------------------- results = [] if request.has_key('start_date'): start_date = request.get('start_date', None) end_date = request.get('end_date', None) results = context.DBTestQueryMethod(start_date=start_date, end_date=end_date) body = context.body return body(results=results) --------------------------------------- and in body use: --------------------------------------- <form action="index_html> (...) </form> <div tal:define="results python: path('options/results|nothing') or []" tal:repeat="row results"> your table </div> --------------------------------------- But where is Plone here?? -- Maciej Wisniowski

2 1

Zope question (while using Plone)
by Christopher A. Nethery 21 Nov '06

21 Nov '06

Hello, I am trying to create a page template in the ZMI that functions in the following way: 1) Page contains two entry fields 2) The values from the entry fields become arguments for a ZSQL method 3) The results of executing the ZSQL method are output to the same page, below the initial entry form When I test my page template, I receive a NameError, indicating that name 'start_date' is not defined. I would assume that I need to use dtml tags or define two tal variables, but I am unsure about how to implement them. Here is what I have, so far: ZSQL Method (DBTestQueryMethod): ------------ select FIRST_NAME, LAST_NAME from EMPLOYEES WHERE HIRE_DATE BETWEEN <dtml-sqlvar "start_date" type=string> AND <dtml-sqlvar "end_date" type=string> (I know, I won't get the entire range with this query) ZSQL Method Arguments: ---------------------- start_date, end_date Page Template: -------------- <html> <head> <title tal:content="template/title">The title</title> </head> <body> <h1 id="title" tal:content="template/title">This is where the main heading goes</h1> <form action="output.html" method="get"> Please Enter Start Date: <input type="string" name="start_date" width="30" value=""> Please Enter End Date: <input type="string" name="end_date" width="30" value=""> <input type="SUBMIT" name="SUBMIT" value="OK"> </form> <table border=0> <tr> <th>First Name</th> <th>Last Name</th> </tr> <div tal:repeat="result here/DBTestQueryMethod"> <tr> <td><span tal:replace="result/FIRST_NAME ">FIRST_NAME goes here</span></td> <td><span tal:replace="result/LAST_NAME"> LAST_NAME goes here</span></td> </tr> </div> </table> </body> </html> Page Property ------------- dynamicContent boolean I would be very grateful for any direction you could provide me with. Thanking you in advance, Chris

2 2

Re: [Zope] Zope Alternative
by madwal 21 Nov '06

21 Nov '06

delete of lista madwal(a)ig.com.br

2 1

Zope Alternative
by Hafeliel 21 Nov '06

21 Nov '06

I realize that this post might cause a bit of anxiety, and so I apologize for that in advance. However, despite all the blood, sweat, and tears that we've all poured into Zope over the years, Zope has yet to make a signifigant market penetration. If you could, please take a moment to surf on over to http://zopereplacement.wikidot.com/ As you probably guessed, that's a wiki set up to discuss where we went right, where we went wrong, and what we could do to make a product that industry is more apt to embrace. What do you guys honestly think? Is this a good idea? Bad? ____________________________________________________________________________________ Want to start your own business? Learn how on Yahoo! Small Business. http://smallbusiness.yahoo.com/r-index

15 35

Python Database API
by Robert (Jamie) Munro 21 Nov '06

21 Nov '06

Is it possible to get to the python Database API through a database connector in zope? I'd like to use things like cursor.executemany(sql,seq_of_parameters) to make lots of queries run a lot faster. I'm using Psycopg if that makes any difference. Robert (Jamie) Munro

4 4

[ANN] Zope 2.9.6 released
by Andreas Jung 21 Nov '06

21 Nov '06

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, on behalf of Zope Corporation and the Zope community I am pleased to announce the release of Zope 2.9.6. You can download it from http://www.zope.org/Products/Zope/2.9.6/ Some new features of Zope 2.9: - ZODB 3.6 - Five 1.3 - integration for Zope 3 events for object creation and deletion - Zope 3 i18n integration for page templates For more information on what is new in this release, see the CHANGES.txt files for the release: http://www.zope.org/Products/Zope/2.9.6/CHANGES.txt Please bring all the bugs you have found to the Zope bugtracker: "http://collector.zope.org/Zope":http://collector.zope.org/Zope For more information on the available Zope releases, guidance for selecting the right distribution and installation instructions, please see: http://www.plope.com/Books/2_7Edition/InstallingZope.stx Supported Python versions: Zope 2.9 requires Python 2.4.3+ (2.4.2 is still acceptable). Older Python versions are no longer supported. Also Python 2.5 is not supported. - -- Andreas Jung (andreas at zopyx dot com) -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (Darwin) iD8DBQFFYqlWCJIWIbr9KYwRAhCIAJ94XskbtB1NWIiXxWKwNzAsNecc7gCeM3SN NQfQz88RRtvkkyydBVljmIE= =OvXy -----END PGP SIGNATURE-----

1 0

[ANN] Zope 2.10.1 released
by Andreas Jung 21 Nov '06

21 Nov '06

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, on behalf of Zope developer community I am pleased to announce the release of Zope 2.10.1. You can download Zope 2.10.1 from: http://www.zope.org/Products/Zope/2.10.1/ Some new features of Zope 2.10: - ZPT implementation based on Zope 3 - experimental WSGI and Twisted integration - Zope 3.3, Five 1.5 integration - clock server - lots of minor improvements and fixes - replaced several Zope 2 modules with their sister implementation of Zope 3 For more information on what is new in this release, see the CHANGES.txt files for the release: http://www.zope.org/Products/Zope/2.10.1/CHANGES.txt Please bring all the bugs you have found to the Zope bugtracker: http://collector.zope.org/Zope For more information on the available Zope releases, guidance for selecting the right distribution and installation instructions, please see: http://www.plope.com/Books/2_7Edition/InstallingZope.stx Supported Python versions: Zope 2.10 requires Python 2.4.3+ (Python 2.4.2 is still acceptable). Older Python versions are no longer supported. Using Python 2.5 is also *unsupported*. - -- Andreas Jung -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (Darwin) iD8DBQFFYqh0CJIWIbr9KYwRAp3RAJ9AqK+wM+kCFrHfgNtblGgmw9pSPgCfaKXs bAMLVD7yiWhLlTOXIKOozkI= =+9J5 -----END PGP SIGNATURE-----

1 0

Re: [Zope] Database connectors
by Wilton Alencar 20 Nov '06

20 Nov '06

Hi, I am Wilton Alencar. Good news from Jean and Maciej Yeah....it´s true...I received the email from Maciej, but until now I hadnt time to work in the component. I would like to receive the improvements from maciej and work over. Actually, I am in a consulting that probably will use ZcdOracleDA ....and finally I will have time to work and test (in fact) the product. Thanks Jean and Maciej.... Maciej, if you can send me your code I would like to study it. I will put the code after revision in sourceforge or google and post in list. Thanks a lot. TOM (my nickname) -- Att, Wilton Souza Alencar www.tom.pro.br

2 1

Re: [Zope] Persistent object in volatile dictionary on a per thread basis
by Martijn Pieters 20 Nov '06

20 Nov '06

Please keep this on the list; the collective list community far outsmarts just me, so give them a chance to give input too. On 20 Nov 2006, at 14:29, Marco Bizzarri wrote: >> Yes, it is perfectly legal. All attributes starting with _v are >> considered volatile and won't be persisted, including dictionaries >> stored as such attributes. > > Sorry, I did not explain well: I'm not using _v_ attributes (because > they are not transactional, basically). You cannot have both transactional and volatile, as transactions only apply to ZODB-stored (persistent) attributes. >> > Is it possible to have the dreaded error, i.e. >> > >> > exceptions.RuntimeError >> > Shouldn't load state for 0x01254260 when the connection is closed >> >> That error would not be connected to _v volatile attributes, as they >> are skipped when storing and are therefor not present when loading. >> The error has to do with a closed ZODB database connection instead, >> for whatever reason. > > I usually get this kind of error when I store a reference to a > persistent object in a non persistent attribute, like a dictionary > definied at module level, and then try to access it from a different > thread... Yes, you should not store persistent attribute references outside of the ZODB object tree. Store paths instead, then resolve the path after retrieving it in whatever thread you are in. -- Martijn Pieters

1 0

Persistent object in volatile dictionary on a per thread basis
by Marco Bizzarri 20 Nov '06

20 Nov '06

Hi all. I would like to know if it can be considered safe to keep an object in a volatile (i.e. non persistent) dictionary, one for each thread. Is it possible to have the dreaded error, i.e. exceptions.RuntimeError Shouldn't load state for 0x01254260 when the connection is closed Thanks for your support. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/

3 2