- Zope - Zope lists

Re: [Zope] content-type weirdness (was: Redirect weirdness)
by Ken 03 Nov '02

03 Nov '02

Hi again, On Sat, 2 Nov 2002, I wrote: >Can I set a content-type header along with the redirect? >I've searched... >I wanted this to be automatic, and the only hint about the content-type would be from the string '.pdf' in the URL... > And where did 'contype' come from?? >>this is a good question Thanks! I'm still hoping for some enlightenment.. Again: External links on my page go to a script which builds the URL and does a RESPONSE.redirect. When the object of the redirect is a PDF, the script does not complete. It looks as if I need to set a content-type header at the same time, but how? And, out of curiosity, how does 'contype' get written to Z2.log as useragent for the failed calls? Thanks, Ken

2 1

Can I capture results from insert in Z SQL methods?
by Skip Montanaro 03 Nov '02

03 Nov '02

In a Z SQL method I want to create a row in a table which has several foreign keys. The method is going to create other rows in subsidiary tables with some of its inputs, then use their primary keys as foreign keys in the final insert. For example, a contact table has foreign keys referring to address and phone tables. The code looks something like begin; # voice phone insert into phone ( ... ); # fax insert into phone ( ... ); insert into address ( ... ); insert into contact ( name, email, address_id, phone, fax ) values ( ... ); commit; In the final insert I need row ids corresponding to rows I inserted in the phone and address tables. Can I capture them as a result returned from the earlier inserts or do I need to do a subselect in the last insert, like so: insert into contact ( name, email, address_id, phone, fax ) values ( <dtml-sqlvar name type="string">, <dtml-sqlvar email type="string">, (select max(id) from address where address1 = <dtml-sqlvar address1 type="string"> and address2 = <dtml-sqlvar address2 type="string"> and city = <dtml-sqlvar city type="string"> and state = <dtml-sqlvar state type="string"> and postal_code = <dtml-sqlvar postal_code type="string">), (select max(id) from phone where phone_area = <dtml-sqlvar phone_area type="string"> and phone_number = <dtml-sqlvar phone_number type="string"> and type = 'work'), (select max(id) from phone where fax_area = <dtml-sqlvar fax_area type="string"> and fax_number = <dtml-sqlvar fax_number type="string"> and type = 'fax') ); or do Z SQL methods support some other mechanism? I didn't see any examples of such stuff in the Zope Book. (I'm using the Psycopg DA, Zope 2.5.1.) Thanks, -- Skip Montanaro - skip(a)pobox.com http://www.mojam.com/ http://www.musi-cal.com/

5 5

Redirect weirdness
by Ken 03 Nov '02

03 Nov '02

Hi all, I wanted to see which of my links are getting clicked, so I made each links go to a little script which builds the url and then does a RESPONSE.redirect. This works fine for redirects to html pages, but gives a very odd result for PDFs. A new window opens as expected, the correct URL appears in the address bar but in the title bar at the top of the browser window is the address of my script, 'display source' is disabled (explorer), and in the Z2.log entry, the useragent signature is replaced by 'contype'. Evidently this has to do with the content-type of the page, but I am at a loss about what to do. Can I set a content-type header along with the redirect? I've searched... I wanted this to be automatic, and the only hint about the content-type would be from the string '.pdf' in the URL... Any explanations out there? And where did 'contype' come from?? Cheers, Ken

3 4

Re: [Zope] catching exceptions thrown by gadfly db
by Andy Todd 03 Nov '02

03 Nov '02

> Hi all, > > I am trying to catch and handle an exception thrown by the gadfly db. > My code is as follows: > <dtml-try> > <dtml-call = > expr=3D"sql_add_software(p_custName=3DcustName,swName=3DswName)"> > <dtml-except> > An error occurred. > Error type: <dtml-var error_type> > Error value: <dtml-var error_value> > </dtml-try> > > The error is thrown and caught (violation of a unique constraint), but > it still inserts the row in the DB. > > When I try to delete the identical rows, I get the following error: > > Error, exceptions.ValueError: list.remove(x): x not in list > > Any ideas? > > TIA, > > Miche=E1l Healy Michael, You have stumbled across a little feature in Gadfly. In essence, although an exception is raised the data still gets written to the database. What you need to do is capture the exception gadfly.store.StorageError and when it occurs issue a rollback. e.g. in Python; >>> db = gadfly.gadfly('myDb', 'myDbDir') >>> cursor = db.cursor() >>> try: ... cursor.execute("INSERT INTO table (col1, col2, col3) values (?, ?, ?)", val1, val2, val3) ... except gadfly.store.StorageError: ... db.rollback() I'm a bit new to Zope so hopefully some kind soul will help translate this to the appropriate DTML or other appropriate form. This has been logged as a bug with gadfly (see http://sourceforge.net/tracker/?func=detail&atid=100662&aid=632247&group_id… for details). Regards, Andy -- ---------------------------------------------------------------------- From the desk of Andrew J Todd esq - http://www.halfcooked.com

1 0

Writing a Script To Thumbnail Photos
by beno 03 Nov '02

03 Nov '02

Hi; I know it's easy to write a script that proportionally changes the width and height of jpegs, but can I programmatically change the size of the image at the same time? In other words, in Photoshop I can make thumbnails that are considerably lighter than the original photos. Can I do the same programmatically? Is that what PIL is for? If so, any heads up on available scripts? TIA, beno

3 4

ObjectManagerItem: does it exist?
by Paul Winkler 02 Nov '02

02 Nov '02

during chat on #zope I told somebody to have his class inherit from ObjectManagerItem. Then I went looking in the zope source and... it does not exist, as far as I can tell. $ cd /zope/Zope_software_home/ $ find . -name "*py" -exec grep -H "ObjectManagerItem" {} \; ./lib/python/Products/OFSP/help/DTMLDocument.py: 'OFSP.ObjectManagerItem.ObjectManagerItem', ./lib/python/Products/OFSP/help/DTMLMethod.py: __extends__=('OFSP.ObjectManagerItem.ObjectManagerItem',) ./lib/python/Products/OFSP/help/File.py: 'OFSP.ObjectManagerItem.ObjectManagerItem', ./lib/python/Products/OFSP/help/Folder.py: 'OFSP.ObjectManagerItem.ObjectManagerItem', ./lib/python/Products/OFSP/help/ObjectManagerItem.py:class ObjectManagerItem: That last one looks like a hit, but it's purely documentation, as the folder name suggests; there are only docstrings, no actual method code. I suspect the API reference intends to refer to OFS.SimpleItem.Item or OFS.SimpleItem.SimpleItem. -- Paul Winkler http://www.slinkp.com "Welcome to Muppet Labs, where the future is made - today!"

2 3

Server Won't Start--Any help?
by Chris A. Bruce 02 Nov '02

02 Nov '02

I am trying to start the server and I get the following error. The server will not respond to any http requests, it just hangs. Any ideas? [root@admin zope-sleeter.com]# /var/zope-inst/zope-sleeter.com/lib/python/ts_regex.py:15: DeprecationWarning: the regex module is deprecated; please use the re module import regex, regsub #, Sync /usr/local/lib/python2.1/regsub.py:15: DeprecationWarning: the regsub module is deprecated; please use re.sub() DeprecationWarning) ------ 2002-11-01T22:03:37 INFO(0) ZODB Opening database for mounting: '144910640_1023761487.549956' ------ 2002-11-01T22:03:37 INFO(0) ZODB Mounted database '144910640_1023761487.549956' at /temp_folder ------ 2002-11-01T22:03:38 INFO(0) ZExternalNews NewsManager[deactivate], ------ 2002-11-01T22:03:38 PROBLEM(100) ZODB Could not import class 'Connection' from module 'Products.ZPyGreSQLDA.DA' ------ 2002-11-01T22:03:39 INFO(0) ZExternalNews NewsChannel[deactivate], ------ 2002-11-01T22:03:39 INFO(0) ZExternalNews NewsChannel[deactivate], ------ 2002-11-01T22:03:39 INFO(0) ZExternalNews NewsChannel[deactivate], ------ 2002-11-01T22:03:39 PROBLEM(100) ZExternalNews Restarting ZExternalNewsManager AutoUpdate,even if object STILL exist, Channels------ 2002-11-01T22:03:39 ERROR(200) ZExternalNews Problem updating ZExternalNewsChannel '' (exceptions.AttributeError: _timestamp). Ignored. ------ 2002-11-01T22:03:39 INFO(0) ZExternalNews NewsChannel[setstate], ------ 2002-11-01T22:03:39 INFO(0) ZExternalNews NewsChannel[setstate], ------ 2002-11-01T22:03:39 INFO(0) ZServer HTTP server started at Fri Nov 1 14:03:39 2002 Hostname: 216.127.76.237 Port: 8080 ------ 2002-11-01T22:03:39 INFO(0) ZServer HTTP server started at Fri Nov 1 14:03:39 2002 Hostname: 216.127.76.237 Port: 8081 ------ 2002-11-01T22:03:39 INFO(0) ZServer FTP server started at Fri Nov 1 14:03:39 2002 Hostname: admin.webslate.com Port: 2121 ------ 2002-11-01T22:03:40 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x05f\x18' Traceback (innermost last): File /var/zope-inst/zope-sleeter.com/lib/python/ZODB/Connection.py, line 447, in setstate AttributeError: 'None' object has no attribute 'load' ------ 2002-11-01T22:03:40 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x05f\x18' Traceback (innermost last): File /var/zope-inst/zope-sleeter.com/lib/python/ZODB/Connection.py, line 447, in setstate AttributeError: 'None' object has no attribute 'load' ------ 2002-11-01T22:03:47 INFO(0) Script (Python) Some of your Scripts have stale code cached. Since Zope cannot use this code, startup will be slightly slower until these Scripts are edited. You can automatically recompile all Scripts that have this problem by visiting /manage_addProduct/PythonScripts/recompile of your server in a browser.

2 1

Passing parameters to obj found by path expressions in ZPT?
by Jeff Kowalczyk 02 Nov '02

02 Nov '02

Is there a way to pass parameters to the methods on objects referenced by path expressions? I'm trying to streamline an interactive formulator template that will retain the values between postbacks. <html><head><title>The title</title></head><body> <span tal:replace="structure request/form"> </span> <form name="sign_in" method="post" action="sign_in"> <tal:block define="global formErrors python:container.check_form('login')" /> <div tal:repeat="repeatform python: here.objectValues(['Formulator Form'])"> <h1 tal:content="repeatform/title"></h1> <div tal:repeat="repeatfield repeatform/get_fields"> <span tal:replace="structure repeatfield/title" />:<br> <span tal:condition="python:not request.has_key('field_password')" tal:replace="structure repeatfield/render" /><br> <span tal:condition="python:request.has_key('field_password')" tal:replace="structure repeatfield/render_from_request" /><br> <span tal:condition="python:request.REQUEST_METHOD == 'POST'" tal:content="structure python:formErrors[repeatfield]" tal:on-error="string:" style="color:red">error goes here</span> </div> </div> <p><input type="submit" value="Submit"></p> </form></body></html> Error Type: TALESError Error Value: exceptions.TypeError on render_from_request() takes exactly 2 arguments (1 given) in "standard:'repeatfield/render_from_request'", at line 16, column 7 A python expression should work better for parameters, but the object ids would be hardcoded. span tal:replace="structure python:container.myform.myfield.render_from_request(here.REQUEST)" /> But I can't monkey around with a getattr() for the form and field until I learn how to reference the repeat variables 'repeatfield' and 'repeatform' within python expressions, how do I do that? Any ideas on any of these fronts would be greatly appreciated. Thanks.

2 1

Programmatic creation/update of ZSQL methods
by Charlie Reiman 02 Nov '02

02 Nov '02

I've got about 60 or so ZSQL methods that I maintain in my Zope. Actually, I don't maintain them: our Oracle expert changes them then I have to translate them into DTML, split them into little chunks, and upload them into zope. Since I'm terribly lazy I've automated the DTMLification and the splitting. But the third step of uploading the ZSQL bodies is tricker. Currently I'm uploading them via FTP but this requires that the methods already exist (due to a lack of object type magic). I've also tried using xmlrpc but manage_addZSQLMethod does not seem to live on Folder so I'm not sure how I can call it. So my question is: How can I create ZSQL methods from an external program (a python script in this case)? I've got the body, the id, the destination, the connection id, the parameters... everything but a clue. I know about PUT_factory but I didn't have much luck with that either.

5 9

Zope and MySQL on Windows
by Greg & Janet LINDSTROM 02 Nov '02

02 Nov '02

Greetings- I have a fairly mature Python application which uses MySQL for the database. I would like to switch over from a single machine application to a web based app (and maybe even make some money!!), and thought Zope would be the logical choice. The past 2 weeks have had me running through the examples in the Zope book and the Zope "Bible", and I *think* I am ready to create a project. Then I read the the creators of Zope do not reccommend using MySQL with Zope on a Windows box. Rats! So... 1. Is this still sound advice? 2. If so, what other Open Source Database is out there. I really would like data/time data types, so that would leave Gadfly out, right? Plus. my database is getting fairly large (~5 Meg), so I'm not sure I want to load it all in memory. Thanks for any advice you can supply! Greg Lindstrom Vilonia, Arkansas

6 5