- Zope - Zope lists

RE: [Zope] Python/DBI/ODBC/Zope
by Schmidt, Allen J. 06 Jul '01

06 Jul '01

There is a version of dbi.dll that lives in ZOPE/bin/lib/win32 We can run this from the command line while in the EXTENSIONS folder of the Zopesite. How can we tell Zope to run using the one from inside itself? And not the one in the Python20/win32 folder? I moved the dbi.dll from bin/lib/win32 and it makes no difference. How does Python see the file to import if it is only a a DLL file? -----Original Message----- From: Thomas B. Passin [mailto:tpassin@mitretek.org] Sent: Friday, July 06, 2001 10:42 AM To: zope(a)zope.org Subject: Re: [Zope] Python/DBI/ODBC/Zope [Schmidt, Allen J] > We have a Python program that reads a URL, rips it apart and dumps the > pieces into an ODBC connected database. Works fine from the command line. > > If we try to add this into Zope as an External Method, it states it cannot > find the dbi component. import dbi uses a dbi.dll in Windows. > > This was developed on 2.1 Python but the dbi module exists in Zopes 1.52 > Python so I am not sure where the problem is. > > Your development installation of python probably has a different python path than the Zope installation, that's why it isn't being found. You need to add its location to the python path that Zope uses, one way or another. Use its location in you development tree as a guide,a nd try to put in in the equivalent location in Zope. You can add to the Zope search path by: 1) Adding a set pythonpath=... statement to the batch file that starts Zope 2) add a xxx.pth file to the Zope python directory - put the path to the file on a single line in the .pth file 3) Hack z2.py to add the path to sys.path Or you can try copying the file to the python library directory where other similar files already live. Of course, what you do will depend on how the existing code specifies the location of the dbi.dll, but this should be enough for you to work it out. One final possibility is that Zope is finding the version compiled for Python 2.1. You would get some kind of an import error if that happens. You have to make sure that your external method is using the version compiled for Python 1.5.2. Cheers, Tom P _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

WHY ? -- Performace in serving large media files from ZODB vs from external file system
by Sedat Yilmazer 06 Jul '01

06 Jul '01

Hi Zopers In the performance for large image files discussion Dieter Wrote > Both will be quite slow when servered by ZServer. What could be the reason for being "slow". Since the files are large, the setup time can be ignored ( time to locate the object) Once the object is found only thing that remains is the reading the file from DB ( should be a plain read) and push it to the connection. I do not see a reason for beeing slow on the db read once the data is located inside the DB. Data may or may not be in a continuous block as in the file system. I see no code / decode or copmress/decompress in the process. So why should the ZServer be slow? Do I miss something here? IMHO moving some stuff from zope for minimal performance reasons breaks zope OOWEB idea! Sedat Yilmazer Kibele Iletisim Sis. ve Serv. Ltd. -----Original Message----- From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Dieter Maurer Sent: Thursday, July 05, 2001 1:48 AM To: Dirksen Cc: zope(a)zope.org Subject: Re: [Zope] Performace in serving large media files from ZODB vs from external file system Dirksen writes: > Judging only from response time, throughput handling, download speed, which way to serve > large files has better performance, from ZOSB or as external file by LocalFS product? Both will be quite slow when servered by ZServer. With LocalFS, you can them serve however with a standard WWW server, e.g. Apache. Dieter _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

4 5

Space in column name with ZODBC
by Loren Stafford 06 Jul '01

06 Jul '01

I'm trying to create an ODBC interface to an existing (MSAccess) database that has spaces in its column names. My ZSQL looks like this... select * from "Applicant Database" <dtml-sqlgroup where> <dtml-sqltest LastName op=like column="Last Name" type=string> <dtml-and> <dtml-sqltest FirstName op=like column="First Name" type=string> </dtml-sqlgroup> ...but it generates this error... File D:\Intranet\Zope224\lib\python\Products\ZODBCDA\db.py, line 198, in query sql.error: ('37000', -3100, "[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(Last Name like 'A'\012 and First Name like ''\012)'.") There's a lot of garbage in that generated SQL, but at least I'd expect to see the column names quoted or something. Is there a trick to it? Or am I trying to do something impossible? Or is there a bug in ZODBC? -- Thanks -- Loren

3 3

NameError problem with sequence-number
by Kevin L 06 Jul '01

06 Jul '01

Hello, I can run the following code which runs fine: <dtml-in "_.range(0,5)"> <dtml-var sequence-number> </dtml-in> However adding quotes around sequence-number always gives me an error "Error Type: NameError Error Value: sequence". <dtml-in "_.range(0,5)"> <dtml-var "sequence-number"> </dtml-in> I need to use sequence-number inside of a python expression. Can anyone explain how to do this? thanks -Kevin __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/

5 5

Problem redirecting from standard_error_message
by Peter Hernberg 06 Jul '01

06 Jul '01

Having moved our website to zope, there are a number of pages that have different URLs now. I've written a little script that checks the urls returns the new url if the page has moved. Then I edited standard_error_message as follows: <dtml-let new_path="temp.translate(REQUEST['URL'])"> <--- returns the new url <dtml-if "error_type=='NotFound' and new_path"> <dtml-call "RESPONSE.setStatus('MovedPermanently')"> <dtml-call "RESPONSE.setHeader('Location', new_path)"> <--- As per rfc, this tells the client where the page has moved to <html> <body> This page has moved <a href="<dtml-var new_path>">here</a>. </body> </html> <dtml-else> ...normal standard_error_message... </dtml-if> </dtml-let> This doesn't work. The Location gets set, but the status is still 404 (which means the browsers won't automatically be redirected to the new page). This code works in a regular dtml method, but standard_error_message seems to be doing some magic which prevents the call to RESPONSE.setStatus() from working. Is there a way around this? Is there a better way to do this? Or did I miss something obvious (again:)? ===== Peter Hernberg According to Securityportal.com, I'm an "ironic and humorous... security expert." Ain't it cool? http://www.securityportal.com/articles/ramen20010119.printerfriendly.html "You must pass this message on in the next 72 hours or you will have bad luck. This mantra will come true even if you aren't superstitious!!!!" --from a forwarded email __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/

2 1

DTML_TREE loaded from a database.
by Rubinstein Fredrik 06 Jul '01

06 Jul '01

Hi there, I have an dtml-tree that is loaded from a database table. >From the table I get keyvalues and what method to be called. I try something like this. <dtml-let object_nkl="0"> <dtml-tree id=object_nkl branches_expr="hierarki_search(parent_nkl=object_nkl)"> <a href=?object_nkl= TARGET="Right"><dtml-var name></a> </dtml-tree> However when I look at this in the browser the part with the "object_nkl" is lost. Is there someone out there with some tips ? Cheers Fred.

2 1

How to set default roles to 'View management screens' permission
by Dirksen 06 Jul '01

06 Jul '01

Hi, I want to set some default roles so that they can view the management screen of my object. How to do that? Cheers Dirksen __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/

2 1

simple question! connection string... err...
by Hugo Ramos 06 Jul '01

06 Jul '01

Yellow ppl, simple question: what's the fucking connection string syntax for a foxpro database? :-) regards ===== Hugo Ramos - hugo(a)zopers.org ZopersORG - http://zopers.org/ ===== Do not meddle in the affairs of programmers, for they are easy to annoy, and have all the source code!!!

1 0

Adding an external method
by Gitte Wange 06 Jul '01

06 Jul '01

Hello, I am trying to add an external metod (used in a CMF Calendar example) but it fails. Now I'm not into these external methods (and I am not sure it's the best solution) but I just want to see how this example works. The method file is named monthRange.py and I have placed it in /usr/local/Zope/Extensions it contains this code: from DateTime import DateTime def monthRange( dt ): """ Return a pair of DateTime values representing the earliest and latest times in the month in which 'dt' falls. """ y, m, d = dt.year(), dt.month(), dt.day() first = DateTime( y, m, 1 ) last = first - 1 + DateTime._month_len[dt.isLeapYear() ][ m ] return first.earliestTime(), last.latestTime() I have filled in these values in the add form in ZMI: Id: monthRange Module Name: monthRange Function Name: monthRange I get this error when I try to add it: Error Type: SyntaxError Error Value: invalid syntax And this traceback: Traceback (innermost last): File /usr/local/Zope-2.3.2-linux2-x86/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /usr/local/Zope-2.3.2-linux2-x86/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/Zope-2.3.2-linux2-x86/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook File /usr/local/Zope-2.3.2-linux2-x86/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/Zope-2.3.2-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_addExternalMethod) File /usr/local/Zope-2.3.2-linux2-x86/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_addExternalMethod) File /usr/local/Zope-2.3.2-linux2-x86/lib/python/Products/ExternalMethod/ExternalMethod.py, line 131, in manage_addExternalMethod File /usr/local/Zope-2.3.2-linux2-x86/lib/python/Products/ExternalMethod/ExternalMethod.py, line 179, in __init__ (Object: monthRange) File /usr/local/Zope-2.3.2-linux2-x86/lib/python/Products/ExternalMethod/ExternalMethod.py, line 202, in manage_edit (Object: monthRange) File /usr/local/Zope-2.3.2-linux2-x86/lib/python/Products/ExternalMethod/ExternalMethod.py, line 209, in getFunction (Object: monthRange) File /usr/local/Zope-2.3.2-linux2-x86/lib/python/App/Extensions.py, line 217, in getObject (Info: ('/usr/local/Zope-2.3.2-linux2-x86/Extensions/monthRange.py', 'monthRange')) SyntaxError: (see above) Well it looks like it finds the file. To me it looks like there is a syntax error in the add of the external method. or is the syntax error in the python code ? I haven't debugged this kind of scripts before so I hope there is someone who can help me :-) Regards, -- Gitte Wange Jensen Sys Admin, Developer and a lot more MMmanager.org Aps, Denmark Phone: +45 29 72 79 72 Email: gitte(a)mmmanager.org Web: www.mmmanager.org Quote of the day: Unix is user friendly; it's just a little paticular about which users it is friendly to.

5 6

Python/DBI/ODBC/Zope
by Schmidt, Allen J. 06 Jul '01

06 Jul '01

We have a Python program that reads a URL, rips it apart and dumps the pieces into an ODBC connected database. Works fine from the command line. If we try to add this into Zope as an External Method, it states it cannot find the dbi component. import dbi uses a dbi.dll in Windows. This was developed on 2.1 Python but the dbi module exists in Zopes 1.52 Python so I am not sure where the problem is. Thanks Allen

2 1