March 2002 - Zope - Zope lists

Testing ZSQL Methods that take lists as parameters
by Smith, Neil 07 Mar '02

07 Mar '02

Is there some way to enter a list into a field on the test page of a Z Sql Method? I've tried putting stuff like [1,2,3] (1,2,3) etc, but it is always just passed to the SQL method as a string. It would be nice to be able to test without having to manually set up some test methods to call them with a list parameter. Neil ********************************************************************** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of the information contained in it. If you have received this e-mail in error, please notify postmaster(a)npower.com (UK 01384 275454) and delete it immediately from your system. Neither Npower nor any of the other companies in the Innogy group from whom this e-mail originates accept any responsibility for losses or damage as a result of any viruses and it is your responsibility to check attachments (if any) for viruses. Npower Limited Registered office: Windmill Hill Business Park, Whitehill Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277 This e-mail may be sent on behalf of a member of the Innogy plc group of companies. **********************************************************************

1 0

Re: [Zope] Zope user limit?
by mick polo 07 Mar '02

07 Mar '02

DOES ANY ONE KNOW OF A MULTITHREADED DATABASE ADAPTOR FOR WINDOWS98? Gadfly just can't handle it. . I'm about to switch to apache mySql - this zope thing ain't workin out . . :( DARN because I love Zope so much ... pity.. thankX in advance :) >Ummm.. gadfly is not at all optimal for this. ;-( I don't believe gadfly >is threaded at all.. but I haven't really investigated. Gadfly >is great as >a demonstration/testing/play-around database, but it sounds like you >probably need a "real" database. Since I don't do windows... >I >>can't really recommend anything specific.. there are probably other >folks on the list who can suggest a good one. >good luck! -steve On Tuesday, March 5, 2002, at 06:44 PM, mick polo wrote: Steve wrote: What database adaptor are you using? Is it running fully threaded? How many threads have you given Zope to work with? There is a "-t" option on the startup script you can adjust. How big a query are you performing? --- I am using the ZgadflyDA adaptor. I'm not sure if that's fully threaded. on the "-t" option i've given zope a 100 threads to work with, which should be more than enough seeing there's only ~20 users using it at a time "Advanced" caching facility may help you to get higher throughput. --- Is setting the cache Higher or Lower better for throughput? Thanx heaps. Mike _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com

3 2

easy regular expression for URL fixup
by Ed Colmar 07 Mar '02

07 Mar '02

Hey! I'm working up a quick re to give me the folder above a webpage... For instance: ### I want: http://www.the.net/bigfolder/ ### import re url = "http://www.the.net/bigfolder/somepage.html" htmlfile = re.compile("/\w*\.html") htmlfile.match(href_url) if htmlfile: folder_url = htmlfile.sub(href_url, "/") For some reason I cannot get my re to do this right... I goit a bunch of hits while searching that indicated many people were having trouble with re in 2.2 python. Is this the case? Anyone know what the syntax is to compile that re? TIA -ed-

3 5

Help with accesssing session information
by Karl Munroe 07 Mar '02

07 Mar '02

I need help with finding out how do I use sessions in zope from asp I can use the Session object to track a user with the SessionId identifying the users unique session on the server. I was looking at the API reference and came up with the fillowing : **************************************************************************** ********************* module SessionInterfaces Session API See Also Transient Object API class SessionDataManagerErr Error raised during some session data manager operations, as explained in the API documentation of the Session Data Manager. This exception may be caught in PythonScripts. A successful import of the exception for PythonScript use would need to be: from Products.Sessions import SessionDataManagerErr class BrowserIdManagerInterface Zope Browser Id Manager interface. A Zope Browser Id Manager is responsible for assigning ids to site visitors, and for servicing requests from Session Data Managers related to the browser id. getBrowserId(self, create=1) If create=0, returns a the current browser id or None if there is no browser id associated with the current request. If create=1, returns the current browser id or a newly-created browser id if there is no browser id associated with the current request. This method is useful in conjunction with getBrowserIdName if you wish to embed the browser-id-name/browser-id combination as a hidden value in a POST-based form. The browser id is opaque, has no business meaning, and its length, type, and composition are subject to change. Permission required: Access contents information Raises: BrowserIdManagerErr if ill-formed browser id is found in REQUEST. isBrowserIdFromCookie(self) Returns true if browser id comes from a cookie. Permission required: Access contents information Raises: BrowserIdManagerErr. If there is no current browser id. isBrowserIdNew(self) Returns true if browser id is new. A browser id is new when it is first created and the client has therefore not sent it back to the server in any request. Permission required: Access contents information Raises: BrowserIdManagerErr. If there is no current browser id. **************************************************************************** ********************** Where can I find more documentation? Is there anyway I can make use of these modules and classes by calling them from dtml method or document? I can probably use these to simulate tracking by session, am I too wishful in my thinking? The problem is I do not want to install a product with user management such as Cookieuser folder. I am currently using zope 2.3.3.....wanted to wrk with this one, I am going to upgrade soon. Thanks in advance. Karl Munroe Email : mun_rok(a)yahoo.com, mun_rok(a)hotmail.com Tel: (876)3654340 _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

2 2

Re: UnboundLocalError with FSCounter 1.2
by marc lindahl 07 Mar '02

07 Mar '02

Yikes! I have no idea, really... I simply mofidied the normal product to be settable from the ZMI. I'm CC'ing the list, maybe the original authors or someone else has a clue.... > From: John_Knutson(a)candle.com > Date: Thu, 7 Mar 2002 14:22:01 +0000 > To: marc(a)bowery.com > Subject: UnboundLocalError with FSCounter 1.2 > > Marc, > > I'm using your FSCounter 1.2 product and it appears to work fine. However, > after changing a property on one of the counters (to add a IP address to > the exclusion list) I got the message UnboundLocalError on every access to > the page with the counter in it. Considering it's displayed from > standard-html-footer, it happens all the time. > > I managed to get over the problem by undoing the changes but I'm a bit > concerned that it will happen at other times. > > Is this behaviour expected? Should I never update properties? If that's the > case, is it safe to delet and recreate a counte with the same name if I > need to change something? > > I welcome your advice. > > Cheers, > John > > John Knutson > Business Development Manager, BSM, Europe > Telephone: +44-1276-414836 > Mobile: +44-7770-816157 > Home office: +44-1962-844719

1 0

storing binary data in an external database
by Bryan C. Andregg 07 Mar '02

07 Mar '02

I need to be able to store images and the like in a postgres table. It would seem that <dtml-sqlvar> isn't going to be what I want because there isn't a type definition for what I want (the data isn't exactly a string, right?). I'm reading in the file contents using REQUEST['file'].read(), which works great for ascii text files, but not binaries. Any help appreciated. -- Bryan C. Andregg Duke University Medical Center Programmer Dept. of Anesthesiology e <bryan.andregg(a)duke.edu> p +1 919 684 6201

3 3

Sql Blender errors
by Richard Hewison 07 Mar '02

07 Mar '02

Sql Blender used to work okay with Zope 2.4.3 under SuSE Linux 7.3 Professional, but now when we try and 'build' we get the following error in the ZMI: Unexpected tag, for tag <dtml-comma>, on line 2 of <string> Traceback (innermost last): File /opt/Zope-2.4.3/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /opt/Zope-2.4.3/lib/python/ZPublisher/Publish.py, line 187, in publish File /opt/Zope-2.4.3/lib/python/Zope/__init__.py, line 226, in zpublisher_exception_hook File /opt/Zope-2.4.3/lib/python/ZPublisher/Publish.py, line 171, in publish File /opt/Zope-2.4.3/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_build) File /opt/Zope-2.4.3/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_build) File /opt/Zope-2.4.3/lib/python/Products/SQLBlender/SQLBlender.py, line 194, in manage_build File /opt/Zope-2.4.3/lib/python/Products/ZSQLMethods/SQL.py, line 140, in manage_addZSQLMethod (Object: employees_sql) File /opt/Zope-2.4.3/lib/python/Shared/DC/ZRDB/DA.py, line 179, in __init__ (Object: INSERT) File /opt/Zope-2.4.3/lib/python/Shared/DC/ZRDB/DA.py, line 246, in manage_edit (Object: INSERT) File /opt/Zope-2.4.3/lib/python/DocumentTemplate/DT_String.py, line 413, in cook (Object: <string>) File /opt/Zope-2.4.3/lib/python/DocumentTemplate/DT_String.py, line 243, in parse (Object: <string>) File /opt/Zope-2.4.3/lib/python/DocumentTemplate/DT_String.py, line 285, in parse_block (Object: <string>) File /opt/Zope-2.4.3/lib/python/DocumentTemplate/DT_String.py, line 131, in parse_error (Object: <string>) Document Template Parse Error: (see above) We did recently install a binary version of MySQL for Linux v3.23.49-a without removing in any way the previous rpm of MySQL forLinux v3.23.47-1 (mainly because we don't have any idea how to uninstall!). MySQL still works okay, but when Zope is run (with ./start -D &) we see the following errors that may or may not be related to our problem: ------ 2002-03-05T15:28:15 PROBLEM(100) Init Ambiguous name for method of Products.mysqlUserFolder.mysqlUserFolder.mysqlUs erFolder: "manage_main" != "manage_contents" ------ 2002-03-05T15:28:15 PROBLEM(100) Init Ambiguous name for method of Products.mysqlUserFolder.mysqlUserFolder.mysqlUs erFolder: "manage_main" != "manage_contents" ------ Anyone got any ideas what we've done wrong? Richard H.

1 0

Join the Zope team
by Brian Lloyd 07 Mar '02

07 Mar '02

Hi all, Zope Corp. is looking to add a Project Manager / Technical Lead to our team. You can find a full description of the position here: http://www.zope.com/Corporate/CareerOpportunities/ The position is roughly 50 / 50 engineering and project management. In addition to planning and executing customer engagements, you will be working with team members and management to develop and deliver high quality solutions. The ideal candidate will have: - Deep technical knowledge of Zope / CMF and Python, and experience building high-quality production systems with these tools - Experience managing software projects for internal and external customers - Strong planning, requirements anaysis and documentation skills - Experience managing the full lifecycle of a software project from inception to delivery and support If you are interested in working with us, please send your resume and salary requirements in .pdf format to careers(a)zope.com. Brian Lloyd brian(a)zope.com Software Engineer 540.361.1716 Zope Corporation http://www.zope.com

1 0

ZSQL and DTML question
by Mitch Pirtle 07 Mar '02

07 Mar '02

Hi everyone, I cannot figure out how to do something the Zope way(TM). Basically, PHP lets you call a query and act on it conditionally, e.g. "if the query returns data do A, if not then do B". How is this done best within Zope? For example, I got really used to returning a recordset (query) as an HTML table. But only IF the recordset returned more than 0 rows. If the query had an empty result, then I would instead print "<p>No records found.</p>" or something like that. I know there's a better and easier way in Zope, I just don't know how -;^>= Can someone kindly point me in the right direction? -- Mitch Pirtle Corporate Security Officer Kühne & Nagel Management AG Tel: +41 1 786 96 45 Fax: +41 1 786 95 95

3 4

is the return list of an SQL Method a string list
by Gostnerr 07 Mar '02

07 Mar '02

Hello, i have wirtten a python script like this get_all_cities return a list of cities from a SQL database table: the problem ist, that the if condition is never true ( but there exists the Citiy 'new york' in the table) have anybody an idea why this does not work ?? roswitha ----------------------------------------------- for x in get_all_cities : if x =='New York' : do something

2 1