November 2006 - Zope

Database connectors
by Roberto Edwins 22 Nov '06

22 Nov '06

Could somebody tell me how to close/open a database connection through python instructions? Thanks in advance...

9 25

Windows Releases of Zope 2.x finally up to date!
by Chris Withers 22 Nov '06

22 Nov '06

Hi All, After much excellent work from Sidnei da Silva at Enfold Systems and a tiny bit of leg work by myself, I'm please to announce the following Windows binary releases are now available for download from http://www.zope.org/Products: - Zope 2.9.5 - Zope 2.9.6 - Zope 2.10.0 - Zope 2.10.1 Many thanks to Sidnei and Enfold for making this happen! cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk

3 2

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