- Zope - Zope lists

calling (SQL) methods dynamically from External methods
by Philipp Auersperg 21 Aug '00

21 Aug '00

What I want to do is calling a SQL method given its name as string, so I first have to get the method out of the self.__dict__ and then call it. I need that for calling the SQL methods dynamically for example out of an URL string. The problem: ------------------ when I call the method like that it does not find its database connection, it seems that it cannot access other members of 'self' When I call the SQL Method directly everything works (see full example below after the line) Interesting fact: When retrieving the method object with "m=self.dbTest" and then with "m1=self.__dict__['dbTest']" "print m,m1" show the same string but "m==m1" results to false! What am I doing wrong? There seems something mixed up with namespaces, but I am too solly to solve it :( any help appreciated Philipp Auersperg (zwork) --------------------------------------- def callSQLMethod(self,REQUEST): m1=self.__dict__['dbTest'] #get method via dict , #dbTest is a normal Z SQL method like 'select * from test' # it uses the db connection 'mysql_test' rs=m1(self) #then the called method #does not find the database #connection ------------------------------------------------------------------------------------ full example def callSQLMethod(self,REQUEST): rs=self.dbTest() #normal call, works - of course m=self.dbTest #first get method, then call it rs=m(self) #that works too m1=self.__dict__['dbTest'] #get method via dict print 'Methods',m,m1,m==m1 #m and m1 print the same #name but are not equal!! rs=m1(self) #then the called method #does not find the database #connection ----------------------------------------------------- Error message: The database connection mysql_test cannot be found. Traceback (innermost last): File /usr/local/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/Zope-2.1.4-linux2-x86/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /usr/local/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: callSQLMethod) File /usr/local/Zope-2.1.4-linux2-x86/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: callSQLMethod) File /usr/local/Zope-2.1.4-linux2-x86/lib/python/Products/ExternalMethod/ExternalMethod.py, line 248, in __call__ (Object: callSQLMethod) (Info: ((<Folder instance at 8607e58>, <h3>form</h3><table></table><h3>cookies</h3><table><tr valign="top" align="left"><th>tree-s</th><td>eJyLjlZ3hANPW3UdhWgkEXdXdJFQA1v1WDAAAK2tDwA</td></tr><tr valign="top" align="left"><th>sql_pref__cols</th><td>80</td></tr><tr valign="top" align="left"><th>dtpref_cols</th><td>65</td></tr><tr valign="top" align="left"><th>sql_pref__rows</th><td>20</td></tr><tr valign="top" align="left"><th>dtpref_rows</th><td>15</td></tr></table><h3>other</h3><table><tr valign="top" align="left"><th>BASE5</th><td>http://192.7.2.21:8080/Test/Stream/getRecords/callSQLMethod</td></tr><tr valign="top" align="left"><th>AUTHENTICATION_PATH</th><td></td></tr><tr valign="top" align="left"><th>sql_pref__rows</th><td>20</td></tr><tr valign="top" align="left"><th>dtpref_rows</th><td>15</td></tr><tr valign="top" align="left"><th>BASE3</th><td>http://192.7.2.21:8080/Test/Stream</td></tr><tr valign="top" align="left"><th>URL3</th><td>http://192.7.2.21:8080/Test</td></tr><tr valign="top" align="left"><th>URL0</th><td>http://192.7.2.21:8080/Test/Stream/getRecords/callSQLMethod</td></tr><tr valign="top" align="left"><th>BASE1</th><td>http://192.7.2.21:8080</td></tr><tr valign="top" align="left"><th>URL2</th><td>http://192.7.2.21:8080/Test/Stream</td></tr><tr valign="top" align="left"><th>URL4</th><td>http://192.7.2.21:8080</td></tr><tr valign="top" align="left"><th>BASE0</th><td>http://192.7.2.21:8080</td></tr><tr valign="top" align="left"><th>URL1</th><td>http://192.7.2.21:8080/Test/Stream/getRecords</td></tr><tr valign="top" align="left"><th>SERVER_URL</th><td>http://192.7.2.21:8080</td></tr><tr valign="top" align="left"><th>tree-s</th><td>eJyLjlZ3hANPW3UdhWgkEXdXdJFQA1v1WDAAAK2tDwA</td></tr><tr valign="top" align="left"><th>URL</th><td>http://192.7.2.21:8080/Test/Stream/getRecords/callSQLMethod</td></tr><tr valign="top" align="left"><th>AUTHENTICATED_USER</th><td>phil</td></tr><tr valign="top" align="left"><th>BASE2</th><td>http://192.7.2.21:8080/Test</td></tr><tr valign="top" align="left"><th>dtpref_co valign="top" align="left"><th>sql_pref__cols</th><td>80</td></tr><tr valign="top" align="left"><th>BASE4</th><td>http://192.7.2.21:8080/Test/Stream/getRecords</td></tr><tr valign="top" align="left"><th>URL0</th><td>http://192.7.2.21:8080/Test/Stream/getRecords/callSQLMethod</td></tr><tr valign="top" align="left"><th>URL1</th><td>http://192.7.2.21:8080/Test/Stream/getRecords</td></tr><tr valign="top" align="left"><th>URL2</th><td>http://192.7.2.21:8080/Test/Stream</td></tr><tr valign="top" align="left"><th>URL3</th><td>http://192.7.2.21:8080/Test</td></tr><tr valign="top" align="left"><th>URL4</th><td>http://192.7.2.21:8080</td></tr><tr valign="top" align="left"><th>BASE0</th><td>http://192.7.2.21:8080</td></tr><tr valign="top" align="left"><th>BASE1</th><td>http://192.7.2.21:8080</td></tr><tr valign="top" align="left"><th>BASE2</th><td>http://192.7.2.21:8080/Test</td></tr><tr valign="top" align="left"><th>BASE3</th><td>http://192.7.2.21:8080/Test/Stream</td></tr><tr valign="top" align="left"><th>BASE4</th><td>http://192.7.2.21:8080/Test/Stream/getRecords</td></tr><tr valign="top" align="left"><th>BASE5</th><td>http://192.7.2.21:8080/Test/Stream/getRecords/callSQLMethod</td></tr></table><h3>environ</h3><table><tr valign="top" align="left"><th>HTTP_ACCEPT_ENCODING</th><td>gzip, deflate</td></tr><tr valign="top" align="left"><th>channel.creation_time</th><td>966817971</td></tr><tr valign="top" align="left"><th>SERVER_PROTOCOL</th><td>1.1</td></tr><tr valign="top" align="left"><th>SERVER_PORT</th><td>8080</td></tr><tr valign="top" align="left"><th>PATH_INFO</th><td>/Test/Stream/getRecords/callSQLMethod</td></tr><tr valign="top" align="left"><th>HTTP_HOST</th><td>192.7.2.21:8080</td></tr><tr valign="top" align="left"><th>REQUEST_METHOD</th><td>GET</td></tr><tr valign="top" align="left"><th>PATH_TRANSLATED</th><td>/Test/Stream/getRecords/callSQLMethod</td></tr><tr valign="top" align="left"><th>HTTP_COOKIE</th><td>dtpref_rows="15"; dtpref_cols="65"; sql_pref__rows="20"; sql_pref__cols="80"; tree-s="eJyLjlZ3hANPW3UdhWgk valign="top" align="left"><th>SCRIPT_NAME</th><td></td></tr><tr valign="top" align="left"><th>SERVER_SOFTWARE</th><td>Zope/Zope 2.1.4 (binary release, python 1.5.2, linux2-x86) ZServer/1.1b1</td></tr><tr valign="top" align="left"><th>HTTP_ACCEPT_LANGUAGE</th><td>de-at</td></tr><tr valign="top" align="left"><th>HTTP_ACCEPT</th><td>image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/msword, application/vnd.ms-powerpoint, */*</td></tr><tr valign="top" align="left"><th>REMOTE_ADDR</th><td>192.7.2.2</td></tr><tr valign="top" align="left"><th>HTTP_REFERER</th><td>http://192.7.2.21:8080/Test/Stream/getRecords/callSQLMethod/manage_main?</td></tr><tr valign="top" align="left"><th>SERVER_NAME</th><td>magnix.philosoft.at</td></tr><tr valign="top" align="left"><th>GATEWAY_INTERFACE</th><td>CGI/1.1</td></tr><tr valign="top" align="left"><th>HTTP_USER_AGENT</th><td>Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)</td></tr><tr valign="top" align="left"><th>CONNECTION_TYPE</th><td>Keep-Alive</td></tr></table>), {}, None)) File /usr/local/Zope-2.1.4-linux2-x86/Extensions/BlueWire.py, line 105, in callSQLMethod (Object: ElementWithAttributes) File /usr/local/Zope-2.1.4-linux2-x86/lib/python/Shared/DC/ZRDB/DA.py, line 384, in __call__ (Object: dbTest) AttributeError: (see above)

3 2

SQL trees...
by Mayers, Philip J 21 Aug '00

21 Aug '00

Excellent. That answers that. I'm loath to ask this, since it's supposedly a FAQ, but I'm having trouble with the tree... Following: http://www.zope.org/Members/anthony/tree-coding-tricks I've got: <dtml-let network="'0/0'"> <dtml-tree id=network branches_expr="network_children(parentnet=network)"> <b><dtml-var network></b> <dtml-var descr> </dtml-tree> </dtml-let> The SQL query is working - "test"ing network_children will give the correct hierarchy. However, the tree generated looks like this: 192.168/16 192.168/16 192.168/16 10/8 172.20/16 10/8 192.168/16 10/8 172.20/16 172.20/16 192.168/16 10/8 172.20/16 10/8 <etc> Basically, the tree only seems to ever contain the top-level (children of the root of the tree). The children of all the nodes is... another copy of the root top-level nodes! Whu?!? A search for several variations of "SQL tree" in all the relevant list/site archives didn't seem to help. Any ideas? Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+ -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: 21 August 2000 15:23 To: Mayers, Philip J Cc: 'zope(a)zope.org' Subject: Re: [Zope] dtml-let and quoting(?) or forcing to string "Mayers, Philip J" wrote: > <dtml-let network="0/0"> > <dtml-tree id=network branches_expr="network_children(parentnet=network)"> > <b><dtml-var network></b> <dtml-var descr> > </dtml-tree> > </dtml-let> Anything in a DTML tag that's inside "" is python, usually ;-) So, your dtml-let should be: <dtml-let network="'0/0'"> which is kinda yucky, don't you think? cheers, Chris _______________________________________________ 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 )

2 1

Indirect method lookup?
by Jeff Hoffman 21 Aug '00

21 Aug '00

Hello, I am trying to build a simple framework that is going to use "events" to callback into higher level logic. Specifically, I am creating a "Text Field" that represents an HTML form field. Its validate() method needs to call whatever method is specified in its validateHandler property (which is a string). My validate() method is a PythonMethod. Before I can call the event handler, I need to get ahold of the method object. I have tried all of the following and gotten nothing but KeyErrors/AttributeErrors: _.getitem(self.validationHandler) _[self.validationHandler] self[self.validationHandler] self.getitem(self.validationHandler) getattr(self, self.validationHandler) etc. It is important to note that the method I am looking for, the one named by the string property, is not defined in the field class itself. I need to rely on acquisition to find it; it is defined in one of the containers of the field object. I know this has to be simple; I must be missing something. Anyone care to share some clue? --Jeff --- Jeff K. Hoffman 704.849.0731 x108 Chief Technology Officer mailto:jeff.hoffman@goingv.com Going Virtual, L.L.C. http://www.goingv.com/

1 0

Renderable-ZClass-0.2 enquiry
by Jean Jordaan 21 Aug '00

21 Aug '00

Hi all Is 'Renderable-ZClass-0.2' (aka "Lalo's excellent RenderableZClass" [1]) from 1999/11/04 the latest version of this? Are there any reports from people using it? Does anyone out there perhaps have a private homegrown 0.99 version? -- Jean Jordaan -- technical writer -- Mosaic Software -- Zope 2.1.6 on WinNT and W2K .. [1] http://www.zope.org/Members/tseaver/STX_Document/README

1 0

RE: [Zope] Newbie Question (Content Manager Tutorial)
by Chris McDonough 21 Aug '00

21 Aug '00

There is a proposal something like this in the works. > -----Original Message----- > From: Steve Drees [mailto:drees@the-bridge.net] > Sent: Monday, August 21, 2000 11:11 AM > To: Chris McDonough > Cc: Zope User Maillist > Subject: RE: [Zope] Newbie Question (Content Manager Tutorial) > > > > With the advent of Zope 2.2, the first thing you need to do > is to create a > > management user. You cannot use the 'superuser' to manage > content. I > > know this is a little unfamiliar, but, for now, just > suspend disbelief and > > create another user with the 'Manager' role (by visiting > the acl_users > > User Folder and adding a user). Then quit the browser, and > log in as the > > user you created. You'll then be able to follow the cmg. > > > Couldn't the zope install be modified to prompt for a > 'Manager' username and > password > and then create that account from the outset? >

1 0

Cannot "uncheck" boolean properties in 2.2b3
by Ron Bickers 21 Aug '00

21 Aug '00

In 2.2b3, after setting a boolean property to "checked", it will not save when trying to "uncheck" it. I reported this to the Collector already (751). As a workaround, you can just delete it and readd it since it defaults to unchecked. _______________________ Ron Bickers Logic Etc, Inc. rbickers(a)logicetc.com

2 2

Looping through a folder's contents...
by jiva＠devware.com 21 Aug '00

21 Aug '00

I would like to loop through the contents of a folder, and the contents of the subfolders of that folder. I know I can do this to a singular level by doing something like: <dtml-in "subfolder.objectValues('Folder')"> <dtml-var title> </dtml-in> Should give me a list of the titles of all the subfolders of the folder called "subfolder". So, once I get there, how do I loop through the subobjects of each of those folders? In other words, I have a subfolder inside of the folder called "subfolder" and I want to see the contents of that folder. How do I do it? -- IBM Pollyanna Principle: Machines should work. People should think.

4 7

Pages Half Rendering :(
by Chris Withers 21 Aug '00

21 Aug '00

Hi, I experienced the same weird intermittent problem yesterday that I have had on odd ocassions over the last eight months. Basically, Zope 2.1.6 returns only half a page. By that I mean if I view source, the HTML just stops at some point through the page. The point depends on the actual time, it varies... clicking reload means you get more or less of the page than last time. All very odd... what makes it worse is that it happens intermittently under certain cirumstances that I can't pin down. Yesterday was on a page that performed a ZCatalog search and returned a table of the results. It worked fine from here at NIP, but when I tried at home over dialup I got the problem. That said, I've had the same thing happen a few times in the past here at NIP, mainly where pages were raising exceptions and the error wasn't getting displayed, just some half-rendered HTML... all very confusing :S Also, totally bizarely, one of our clients had problems on the same page. Searching works fine here from NIP and at home over DSL for some NIP employees. I was trying over dialup from home but had the problem I already metnioned. However, whatever the client searched for, he got no results. The page rendered fine but it was the paeg saying 'no results could be found matching youur query'. If anyone else has experienced anything liek either of these problems, or has any idea as to what may be going on, I'd love to hear it :S cheers, Chris

3 2

dtml-let and quoting(?) or forcing to string
by Mayers, Philip J 21 Aug '00

21 Aug '00

All, I've just setup a test Zope installation. So far, very impressive. I'm using a Postgresql database containing a network hierarchy (basically, a table with a "network" column, and a "parentnet" column). I'm trying to display this with a tree view, using the following DTML: <dtml-let network="0/0"> <dtml-tree id=network branches_expr="network_children(parentnet=network)"> <b><dtml-var network></b> <dtml-var descr> </dtml-tree> </dtml-let> Where the network "0/0" is the pseudo-parent of every other network. The problem is, python (or DTML, I don't know) interprets this as a divide by zero, and it fails. The other alternative "0.0.0.0/0" also fails: Expression (Python) Syntax error: invalid syntax , for tag <dtml-let network="0.0.0.0/0">, on line 15 of test_html (I'm doing all this through the web management interface). I'm not familiar with Python (yet - the book is on it's way) but in the command-line interpreter, this works fine: >>> "0.0.0.0/0" '0.0.0.0/0' >>> "0/0" '0/0' >>> I need to cast the value to dtml-let to a string. How? I know how to do this in Perl/C/Java/Pascal, but it's not obvious to me why this isn't working. Yours, dumbly.... Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+

2 1

Broken Site Access and domain name capitalization?
by J. Atwood 21 Aug '00

21 Aug '00

I just started messing around with some of my Domain names trying caps in the name and broke right through the Site Access product. So my question is to I have to add all the variants of the domain name to the virtual_host method or is there a way to simply lowercase the HTTP_HOST before checking it? Anyone done this or shall I forge ahead? Thanks, J

2 3