August 2005 - Zope - Zope lists

SQL Problem
by Philip Beardmore 25 Aug '05

25 Aug '05

I'm having a really annoying SQL problem which I think (or hope) can easily be sorted but I'm not sure how to do it. I have a ZPT which is collecting data in a form - Both text boxes and checkboxes. The form then passes the variables on to a DTML Method which does a few bits of error checking then calls an Z SQL Method to insert the data. If all of the data is completed (i.e. each textbox and checkbox is ticked) then the form inserts the data exactly as it should. If not all checkboxes are ticked the page returns an error - This is due to the SQL Method trying to insert data which hasnt been passed to it. Below is my SQL Method: INSERT choices (userid, datetime, course, name, core1, core2, core3, core4, core5, choice1, choice2, choice3, choice4) VALUES ( <dtml-sqlvar userid type=string>, <dtml-sqlvar datetime type=string>, <dtml-sqlvar course type=string>, <dtml-sqlvar name type=string>, <dtml-sqlvar core1 type=string>, <dtml-sqlvar core2 type=string>, <dtml-sqlvar core3 type=string>, <dtml-sqlvar core4 type=string>, <dtml-sqlvar core5 type=string>, <dtml-sqlvar choice1 type=string optional>, <dtml-sqlvar choice2 type=string optional>, <dtml-sqlvar choice3 type=string optional>, <dtml-sqlvar choice4 type=string optional> ) Arguments are: userid datetime course name core1 core2 core3 core4 core5 choice1 choice2 choice3 choice4 Note: Choice1-4 are checkboxes and every other item is a textbox. Please help - Its doing my head in! Cheers and all the best Phil

2 1

RE: [Zope] Random Module
by Jim Abramson 25 Aug '05

25 Aug '05

You can keep all the modules/types/etc you want Zope to stop hassling you about into a single file, restart Zope, and enjoy life again. create a Product called whatever you like (we called ours 'GlobalModules')... our looks like this: in Products/GlobalModules: __init__.py # Global module assertions for Python scripts from Products.PythonScripts.Utility import allow_module from AccessControl import allow_module, allow_class, allow_type allow_module('re') import re allow_type(type(re.compile(''))) allow_type(type(re.match('x','x'))) allow_module('zipfile') import zipfile allow_class(zipfile.ZipFile) allow_class(zipfile.ZipInfo) ----END------ For you, obviously, you'll want to allow_module('random'), perhaps declare some of its own special types, etc... hth Jim > -----Original Message----- > From: zope-bounces(a)zope.org [mailto:zope-bounces@zope.org] On > Behalf Of Sam Boggess > Sent: Thursday, August 25, 2005 1:36 PM > To: zope(a)zope.org > Subject: [Zope] Random Module > > Why won't Zope let me call the random module? It's really > annoying to have to write an external method to call such a > simple tool. Is there a way around this? Thanks. > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) > >

1 0

Re: Stepper
by Chris Withers 25 Aug '05

25 Aug '05

Hi Gary, Gary Poster wrote: > Hey Chris. Ever on the lookout for better things to replace our code > (e.g., zasync), I took a look at Stepper. It looks nice and simple (as > per your company name, I suppose ;-). It's particularly nice that it > looks easier to set up than zasync. Thanks! :-) I like things simple, hence the company name and tag line ;-) > We primarily need zasync for frequent, user-requested async tasks fired > from within a browser. From poking around in Stepper I thought maybe > one could do that with a cron job kicking stepper and some other > tricks, "some other tricks" being something in ZODB that built up a queue for a Stepper step to process... > but it didn't seem that was a primary use case for you, because > I still think zasync would do a better job there. Indeed, Stepper is for doing "once a day" type stuff. It was originally developed to run sets of migration code, but is now going to be used to do checking of Link Objects, sending reminders about expired content, packing ZODB, etc. That said, I see no reason why it couldn't be used to meet your use case... > To be clear, Stepper does tasks zasync couldn't; oh? > and I think it would > be more appropriate for some of our zasync usages in the field, > particularly once you beef up the error handling. I'm curious about this... what needs beefing up? > The class design for > defining jobs is certainly prettier than what I did too, though > arguably both approaches have advantages. I might choose your approach > for a new take on zope_exec plugin, for instance, if I did more zasync > work. Hmmm, what's zope_exec? > In any case, to your knowledge, am I on the right track with my > analysis of what you have done? Yup, think so... > Does Stepper support frequent, > browser-requested async tasks, now or in your plans? Not really, that's not its focus. But, another product could easily be built to handle the "put jobs in a queue" thing and also supply a Stepper step. Maybe zasync could evolve to do just that and leave the actual offline task running (which is an admittedly pretty small task!) to Stepper? > I would have sent this to the zope mailing list if I subscribed; feel > free to cc responses there if you would like. Sure, I'll CC the zope list in for kicks :-) cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk

1 0

Job vacancy - Scotland
by Marc Burgauer 25 Aug '05

25 Aug '05

Hi Sharedbase has a vacancy for a Zope Web App programmer in a permanent position. We are based in: Hamilton, Scotland, Uk Sharedbase is specialising in on-line communities. Skills required (or sought) are: Zope (currently using 2.7) / Python 2.3.5 UNIX (mainly Solaris, FreeBSD; and less so OS X, Debian) PostgreSQL (7.3.x) / Psycopg GIS (mapserver) A complete job spec can be found at: http://www,sharedbase.com/jobs Salary range is between 20-30k Pound Sterling depending on skills and experience. Please contact me directly (marc(a)sharedbase.com) if you have questions or send your CV. If you lack SQL and GIS, but think you can pick this up quickly, give it at shot anyway. RECRUITERS: Please do not contact me unless you can send me a CV of a suitable candidate. I am posting here because the agencies we're working with are unable to find the right match. Cheers Marc -- Marc Burgauer Sharedbase Ltd 60 Dumfries Road Elvanfoot ML12 6TF http://www.sharedbase.com Tel: +44 (0) 870 765 5600 Fax: +44 (0) 1864 505 246 Mob: +44 (0) 7909 913 903 Company registration: SC226521 VAT registration: 789 7904 46 Registered office: 29 Brandon Street, Hamilton ML3 6DA

1 0

REQUEST.has_key does not find passed argument
by Santani Teng 25 Aug '05

25 Aug '05

Hello, I'm new to Zope, Python and DTML and could therefore use some help. I have a page in which I want to pass an argument to a new DTML method when clicking a link. The relevant snippet is: <a href="/contact?name_id:int=<dtml-var name_id>">Contact</a> So, when you click on "Contact" you should get a new window. The variable "name_id" is previously established on the page and shows up correctly when the pointer hovers over the link, i.e. the status bar at the bottom of the browser reads: http://server.website.edu/contact?name_id:int=3 However, the DTML code for the new page doesn't seem to find this value and returns a message telling me that no name was found. Because I am stuck, here is the virtual entirety of the code: <dtml-if "not REQUEST.has_key('name_id')"> No name was found. Please specify a name. <dtml-else> Thank you! The request has been made. </dtml-if> How can I get this page to recognize the passed argument so I can call a method with it? I have seen similar threads here on this topic but was unable to find a solution from reading them. I am also baffled by the fact that in large part I'm reusing the same code that seems to work perfectly in the same format on other pages (which I didn't write). This is probably something very simple, but I would really appreciate a hand. Thanks in advance, Santani

2 1

Zope 2.8.1 on Mac OS X tiger Server
by Garito 25 Aug '05

25 Aug '05

Hi all! Yesterday I install Zope 2.8.1 on a Mac OS X tiger Server and all goes ok The only question I can't configure is the automatic boot up I read some how-to's but they don't work At /System/Library/StartupItems I create a folder called Zope with 2 files: Zope with these contents: #!/bin/sh ## # Zope Web Application Server ## . /etc/rc.common StartService () { if [ "${ZOPESERVER=-NO-}" = "-YES-" ]; then ConsoleMessage "Starting Zope" /var/zope/sistes/bin/zopectl start fi } StopService () { ConsoleMessage "Stopping Zope" /var/zope/sistes/bin/zopectl stop } RestartService () { if [ "${ZOPESERVER=-NO-}" = "-YES-" ]; then ConsoleMessage "Restarting Zope" /var/zope/sistes/bin/zopectl restart fi } RunService "$1" and StartupParameters.plist with these content: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> <plist version="1.0"> <dict> <key>Description</key> <string>Zope web application server</string> <key>OrderPreference</key> <string>None</string> <key>Provides</key> <array> <string>Zope Server</string> </array> <key>Requires</key> <array> <string>Web Server</string> </array> </dict> </plist> With these 2 files zope doesn't start at boot time. For that question I try another StartupParameters.plist: { Description = "Zope WebServer"; Provides = ("Zope WebServer"); Requires = ("Web Server"); OrderPreference = "None"; Messages = { start = "Starting Zope WebServer Service"; stop = "Stopping Zope WebServer Service"; }; } but It doesn't work too Can anyone help me? Thanks a lot! -- Mis Cosas http://blogs.sistes.net/Garito/

4 10

SaneBrains 1.0.0 Released!
by Chris Withers 25 Aug '05

25 Aug '05

Stepper 1.0.0 Released! This is a framework for performing asynchronous tasks on Zope servers. It is written as a Zope Product and can be used in several different ways: - for running sequences of migration code from the console. - for running batch processes via cron - for unit testing pieces of migration code or batch processes - for sharing asynchronous code between multiple contexts such as a migration run and a plone customisation policy. It is compatible with both Windows and Unix. For more information, please see: http://www.simplistix.co.uk/software/zope/stepper cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk

1 1

Migration pains going to Zope 2.8
by Richard Jones 25 Aug '05

25 Aug '05

I can't instantiate out Product, which is a bit of a hurdle :) Our Product's registration looks like this (this function is invoked from the Product's __init__.py): def initialize(context): ''' Register the CGPublisher class ''' context.registerClass( CGPublisher, permission=Perm.ADD_CGPUBLISHERS, constructors = (addCGPublisherForm, addCGPublisher, addValues, getMode), icon='www/CGPublisher.gif', visibility='Global', ) Unfortunately, the addCGPublisherForm template can't access the "addValues" function. The specific error I get is: Error Type: Unauthorized Error Value: The container has no security assertions. Access to 'addValues' of (App.ProductContext.__FactoryDispatcher__ object at 0xb61d30cc) denied. I tried adding some module security declarations: security = ModuleSecurityInfo('Products') security.declarePublic('CGPublisher') security = ModuleSecurityInfo('Products.CGPublisher') security.declarePublic('addValues') security.declarePublic('getMode') to the initialize() function, but that didn't change anything. Any suggestions?

2 3

URL0 returns index_html not index.html
by Mark Barratt 24 Aug '05

24 Aug '05

Zope 2.7.4 on Debian DTML method index_html in the root says <dtml-var "_['index.html']"> A link in a page template to tal:attributes="href string:${context/REQUEST/URL0}/source.html where the page is addressed by [path]/ and is actually at [path]/index.html returns [path]/index_html/source.html I can vaguely see why this is happening. My question: is there a straightforward way of making the links (and error reports) return the actual page address? (I think I understand that 'actual' 'page' and 'address' are all metaphors which may be leading me into error... ) Thanks for any help/enlightenment. -- Mark Barratt

3 5

problem with adding an external method
by Scott Mann 24 Aug '05

24 Aug '05

Hi All, Sorry in advance for this newbie question. I've searched the archives and while I have learned a few things and tried a few things, I still have the same problem. I am attempting to add the external python module "nb_fetch" Doing so returns the error message: "Module /data/zope/testbed/initialzope/Extensions/nb_fetch.py, line 3, in ? ImportError: No module named nb_parse" where nb_parse is imported by nb_fetch. I have tried adding __init__.py into the Extensions directory. I have also made a number of attempts at adding directories to the PYTHONPATH, but no success. I have even put the imported modules (nb_parse, etc) into the lib/python subdirectory of the zope directory. Also, I restart zope every time I make a change. Any ideas? TIA Scott

3 2