- Zope - Zope lists

dynamically change sql query in zope?
by Alexander Tuchacek 09 Oct '01

09 Oct '01

hallo, i would like to dynamically change the search where field in the sql query in zope. when i do this, zope interpretes the variable FIELD as string. is there a way to dynamically change a sql query? thanks for any help, alex -------------- FIELD S_TITLE1 select * from Annotation WHERE <dtml-sqlvar FIELD type=string> = <dtml-sqlvar S_TITLE1 type=string>

2 1

how to create a exUserFolder from Script ?
by Achim Domma 09 Oct '01

09 Oct '01

Hi, I have written a folderlike class in pyton. In my own manage_addMyProduct class I want to create an instance of exUserFolder. How can I do that ? I tried import Products.exUserFolder Products.exUserFolder.manage_addexUserFolder( c,'zodbAuthSource','zodbPropSource','basicMemberSource',1,600 ) but it does not work. It get the following error : 'Products.exUserFolder' module has no attribute 'manage_addexUserFolder' greetings Achim

2 1

Getting to properties in products?
by Etienne Labuschagne 09 Oct '01

09 Oct '01

Hi all, How do I access "class variables" (properties defined in the folder of my Product - I know it is not strictly speaking class variables!) when I am rendering my class' add form? Each product must render a list of checkboxes in the add form to define parameters of the instance. I want to store that list of choices in a list in the product and then build the html when the product is added. That way I can easily change the list without having to write a lot of HTML code every time. Here is what I have done so far: I have the following product: Control_Panel\Products\Indicator In that folder (the product folder) I have a property that is called Pressures (a list of items) (ControlPanel->Products->Indicator->Properties Tab) This means that Pressure is a class-ish variable (actually a creation-time variable, or whatever). I have a method in that folder called renderPressures (Control_Panel\Products\Indicator\renderPressures) which I want to use to render the list of pressures in the add form with checkboxes etc. When rendering the addform for a user to add a new indicator (non Zope management interface) I do it as follows in Python script: return context.manage_addProduct['Indicator'].Indicator_addForm(context) This means that context is passed to the Indicator_addForm and that <dtml-var renderPressures> will not work since it is "bound" to context, so I use <dtml-var "manage_addProduct['Indicator'].renderPressures()"> instead. renderPressures contains something like pressures = context.getProperty('Pressures') (also tried container.getProperty('Pressures') ) but that returns None and pressures = context.manage_addProduct['Indicator'].getProperty('Pressures') also returns None Thanks Etienne

1 0

use & threadsafety of MySQLdb in Zope if not using DA?
by sean.upton＠uniontrib.com 09 Oct '01

09 Oct '01

I am working on a generic toolkit for a user registration system that requires a toolkit/API for abstracting relational database access to a MySQL-based user profile database; I do this with a class that handles all the business logic of my application's core toolkit and data-access functionality. The toolkit is written in Python using MySQLdb and will be used by automation utilities, a proxy authorization system, and also within Zope via a python product I am writing. Since I'm doing this in order to have a unified API among all my apps using this database, but without the help of a DA, I'm wondering how I would go about creating a database connection object via my API in a way that works with Zope. My concerns are: 1 - I don't know how I would instantiate the object within my Zope folderish container object... The setup is usually simple in Python, I just create the DB object, which opens the DB connection in its __init__()... I'm wondering how I could create something like this 2 - I'm not sure how to make this thing thread-safe? I realize that I would need to deal with the fact that multiple threads of Zope couldn't access/use the same connection object... I guess what I am trying to figure out, is how I would have non-persistent connection objects instantiated for each thread inside Zope upon Zope startup within my product code. I'm not even sure where to start, or if I'm going about this the wrong way; I would prefer not to have to rewrite my data API classes to work with a DA... thoughts? Sean ========================= Sean Upton Senior Programmer/Analyst SignOnSanDiego.com The San Diego Union-Tribune 619.718.5241 sean.upton(a)uniontrib.com =========================

2 1

upload without form as ExtDocument...how???
by Vineet.Ahuja＠de.abb.com 09 Oct '01

09 Oct '01

Dear all, I am trying to upload an extDocument which is located on my system without using the form but only using an external python script.(I am doing it because I have about 500 msworld files and i want to create a loop in test.py.(and I dont want to use Form)Please Help me! test.py:- def testext(self): f = open ("vin.doc","rb") dataread=f.read() fname='myvineet123' self.manage_addProduct['ExtDocument'].manage_addExtDocument(id=fname, title='t2', file=dataread) f.close() return dataread Above is my external python script.And I am calling the external method in the script below:- testpy.py:- for object in context.objectValues(['Folder']): if object.hasProperty('visible') and object.visible: context.testext(object) Now as I run testpy.py from zope i get the following error message:- Error Type: TypeError Error Value: open() argument 1 must be string without null bytes, not string Traceback (innermost last): File C:\zopewebs\lib\python\ZPublisher\Publish.py, line 223, in publish_module File C:\zopewebs\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\zopewebs\lib\python\Zope\__init__.py, line 226, in zpublisher_exception_hook (Object: LockableItem) File C:\zopewebs\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\zopewebs\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: testpy) File C:\zopewebs\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: testpy) File C:\zopewebs\lib\python\Shared\DC\Scripts\Bindings.py, line 324, in __call__ (Object: testpy) File C:\zopewebs\lib\python\Shared\DC\Scripts\Bindings.py, line 354, in _bindAndExec (Object: testpy) File C:\zopewebs\lib\python\Products\PythonScripts\PythonScript.py, line 363, in _exec (Object: testpy) (Info: ({'script': <PythonScript instance at 019A79D8>, 'context': <Folder instance at 019D6D00>, 'container': <Folder instance at 019D6D00>, 'traverse_subpath': []}, (), {}, None)) File Script (Python), line 3, in testpy (Object: guarded_getattr) File C:\zopewebs\lib\python\Products\ExternalMethod\ExternalMethod.py, line 274, in __call__ (Object: testext) (Info: ((<Folder instance at 0122A5A8>,), {}, None)) File C:\zopewebs\Extensions\test.py, line 5, in testext (Object: LockableItem) File C:\zopewebs\lib\python\Products\ExtDocument\ExtDocument.py, line 41, in manage_addExtDocument (Object: LockableItem) File C:\zopewebs\lib\python\Products\ExtFile\ExtFile.py, line 371, in manage_file_upload (Object: CatalogAware) File C:\zopewebs\lib\python\Products\ExtFile\ExtFile.py, line 466, in _copy (Object: CatalogAware) TypeError: (see above) Can you kindly tell me where i am going wrong?? Best Regards, Vineet Ahuja

3 2

How do I "compile only" install?
by Gary Algier 09 Oct '01

09 Oct '01

How do I "compile only" during installation? I have no C compile on my web server. How do I do the compile step only on another system and what do I need to copy to the web server. I don't need (or want) the sources on the web server. There does not seem to be any sort of division of labor. I want to be able to "make" on one system and "make install" on another. Even better "make binary-dist" on the development system and then just copy some tar file, etc. to the web server. Also, in doc/INSTALL.txt it says: If you are impatient, the following commands should get you up and running with Zope 2 using ZServer and ZODB 3 on Unix: python w_pcgi.py and later: If you want to try out Zope in the simplest fashion using ZServer, then run the script wo_pcgi: python wo_pcgi.py and later: If you want to use PCGI and an existing web server run w_pcgi: python w_pcgi.py It tells me that w_pcgi.py is for a standalone environment, then later it is contradicted and tells me it is for a CGI environment. Which is which? I tried using -h with these and they tell me nothing; they just ignore it. -- Gary Algier, WB2FWZ gary.algier(a)ulticom.com +1 856 787 2758 Ulticom Inc., 1020 Briggs Rd, Mt. Laurel, NJ 08054 Fax:+1 856 866 2033 A self-addressed envelope would be addressed "envelope."

2 3

is dtml thread safe.
by kapil thangavelu 09 Oct '01

09 Oct '01

subject says it all. i'm thinking about using dtml outside of zope in a multithreaded program and was curious if dtml execution is thread safe?

2 1

Re: Simple Login-Form
by Juan Garcia Garcia 09 Oct '01

09 Oct '01

Hi, >maybe it's just (or something) ... I want to build a plain and simple >form for users to authenticate ... how would I do something like that? There are many products for Zope to make what you want: LoginManager, etcUserFolder, Generic User Folder(GUF), ... I'm using currently the last one but i don't understand at all yet. I have a form with two fields (Login and Password): <INPUT TYPE="TEXT" NAME="_gufauth_name" SIZE="20"> <INPUT TYPE="PASSWORD" NAME="_gufauth_password" SIZE="20"> and a submit button: <INPUT TYPE="SUBMIT" NAME="_gufauth_submit" VALUE="Conectar"> I think that the names of the input fields are essential for the authentication. In some DTML Methods of the GUF you must write the users, their roles and domains, and check for their passwords. I'm using to do this a database in PostgreSQL. After all, i suggest you to visit the next web page if you are going to use this product finally: http://www.zope.org/Members/hippy/GUF_SQL_crypt It is an example very good to understand and make it works. I hope this information is useful for you. Bye.

2 2

need help to buid a "small ads" feature
by spy2＠netcourrier.com 09 Oct '01

09 Oct '01

Hi ! I don't know very well Zope and its products. But I want to create a "small ads" feature on my site. With it, the users could post and reply to ads. Do you know an existing product which could help me build this feature ? Thanks for your help...

1 0

thanks for participating on my diploma
by Neunreither, Isabelle 09 Oct '01

09 Oct '01

Hi, in three days, i will have my last oral examination for my diploma about zope and xml. i want to thanks all people who had participated to my work and all who filled out my form. at this time, my diploma is only written in german. i will try as soon as possible to publish it on the web (i hope next week) and to translate a part of it in english and in french (i'm sure not next week :-) ). thanks a lot. Isabelle Neunreither konsylo Messeler-Park-Strasse 74 64291 DARMSTADT Fon: 0 6150 866 196 Fax: 0 6150 866 197 email: in(a)konsylo.com

1 0