September 1999 - Zope-Dev

Need help mucking about with Products
by Evan Simpson 04 Sep '99

04 Sep '99

I've got a Zope 1.10.3 installation (to be Zope 2 Real Soon Now). I like to put certain functions (like tuple, map, list, and filter) into the standard namespace '_'. Up to now, I've patched DT_Utils to do this, but it's a maintenance PITA. I decided to try making a Product which would reach over and insert the functions, but it doesn't seem to work. It's just a directory under Products containing the following code in '__init__.py' (yes, there's an '__init__.pyc' too). # MoreBuiltins/__init__.py __doc__='''More Builtins Product Initialization''' __version__='$Revision: 0.1 $'[11:-2] classes=() meta_types=() methods={} misc_={} __ac_permissions__=() from DocumentTemplate.DT_Utils import TemplateDict d = TemplateDict.__dict__ # Test insertion d['whizzo']='chocolate' The Product appears in the Product management folder, but  gives an AttributeError. Help?

1 1

Reading an external database using a zope ZSQL method
by Jim Penny 04 Sep '99

04 Sep '99

This is meant to document what was done. I did not see anything in the mailing list that asked quite this question. The Question: How can a database be accessed from an external method? To make the discusion more concrete, I will assume that there is a ZSQL method available called sql_test, and that it takes one argument, request_number. The table at hand has entries request_number:int, description:text, item:text, qty:int Half of the answer is so blindingly easy that I would never have found it without the help of Martijn Pieters who said. use sql_test(request_number=actual_parameter) i.e. res=sql_test(request_number=44) I could at this point see the activity on the database engine, so I knew that I had been set on the one true path. But what is res? Grubbing around in python, I did a bunch of dir operations. I do mean a bunch, as I seem to be particularly dense today. dir[res] yields: ['__items__', '_class', '_data', '_data_dictionary', '_names', '_nv', '_parent', '_schema']" After more grubbing around, it turns out that there are three particularly interesting portions of this object. res._data_dictionary.items() yields: [('request_number', {'width': 14, 'name': 'request_number', 'type': 't'}), ('description', {'width': 11, 'name': 'description', 'type': 't'}), ('qty', {'width': 3, 'name': 'qty', 'type': 't'}), ('item', {'width': 4, 'name': 'item', 'type': 't'})] res._schema.items() yields: [('request_number', 0), ('description', 2), ('qty', 3), ('item', 1)] res._data is indexable. len(res._data) is the number of rows returned. res._data[0] is the beginning row of the returned value. res._data[len(res._data - 1) is the last row. Each row is indexable, and the schema tells us the name of each row. So in my case: res._data[0][0] is the value of request_number of the first returned row, res._data[0][1] is the value of item of the first returned row, res._data[0][2] is the value of description of the first returned row, res._data[0][3] is the value of qty of the first returned row, etc. A careful reader might look at the _data_dictionary entries and be concerned about width. Do I really want item to be only 4 wide? This is in fact a problem of the Postgres DA. The DA does not return the actual width of each entry; it returns the width of the name. I suspect that this cannot be corrected. But this is beside the point. To recap. Make a ZSQL method, as usual. In the external method, just call the method, using keyword arguments. Use the ._schema structure of the result to decode the order and names of row elements. Use the ._data structure of the result to find the actual data. ._data is a two dimension array. Like much of Zope, quite easy once you see it done. Martijn also deserves credit for the second half of the answer. Most of my real hard determined grubbing was as a result of a comment of his, that mostly gave away the answer without any detail. Hey Martijn, were you a math professor in another life? ;-) Jim Penny

2 1

more external database trouble
by Jim Penny 03 Sep '99

03 Sep '99

I want to thank Martijn one more time. But, I am still confused. Here is where I am at. Recap. Question1: how do I invoke a ZSQLmethod named sql_test with argument sequence_number from an external method. Answer1; (thanks Martijn). Well, try sql_test(sequence_number=value). Argh. So blindingly easy. Question 2: OK, so that get me a result. How do I interpret it? Martijn answerered: >Returned is a list of row objects, and each row object is just a dumb class >with the different columns converted to class attributes. >So you test for the length of the result, loop through it like any list and >access attributes on the list objects, including list.__dict__.keys() for a >list of attributes. I still do not understand, although I am sure it is my density that is the problem. OK, I set a=sql_test(sequence_number=value) sql_test has body select * from sample_room_list_item where sales_request_number = <dtml-sqlvar sales_request_number type=int> Now I start grubbing around with attributes of a. I find all of these facts: dir(a)=['__items__', '_class', '_data', '_data_dictionary', '_names', '_nv', '_parent', '_schema']", " dir(a.__items__)=['append', 'count', 'extend', 'index', 'insert', 'pop', 'remove', 'reverse', 'sort'] dir(a._class)=['DESCRIPTION', 'ITEM', 'LOCATION_QTY', 'QTY_DESIRED', 'SALES_REQUEST_NUMBER', '__add__', '__basicnew__', '__comp__', '__doc__', '__getattr__', '__getitem__', '__getslice__', '__getstate__', '__init__', '__len__', '__module__', '__mul__', '__record_schema__', '__reduce__', '__setattr__', '__setitem__', '__setslice__', '__setstate__'] dir(a._data)=['append', 'count', 'extend', 'index', 'insert', 'pop', 'remove', 'reverse', 'sort'] dir(a._data_dictionary)=['clear', 'copy', 'get', 'has_key', 'items', 'keys', 'update', 'values'] dir(a._names)=['append', 'count', 'extend', 'index', 'insert', 'pop', 'remove', 'reverse', 'sort'] dir(a._nv)=[] dir(a._parent)=['__ac_local_roles__', '_objects', 'finalize_changes', 'id', 'index_html', 'sql_add_sample_room_items', 'sql_delete', 'sql_test', 'sql_update_sample_room_request', 'test', 'title'] dir(a._schema)=['clear', 'copy', 'get', 'has_key', 'items', 'keys', 'update', 'values'] dir(a._class.ITEM)=['_n'] dir(a._class.ITEM._n)[] Some parts look real familiar (like _parent, and _class). But I still have not been able to get my grubby little fingers on the actual data! Help me Mr. Wizard! Thanks. Jim Penny str(a._class.ITEM._n)=item")

1 0

Finding a sub string using _.string.find
by Jason Spisak 03 Sep '99

03 Sep '99

Zopists, I am trying to check an see if an email address has an @ sign in it as a hack way of determining validity. I checked the dtml ref guide, and found the find(S,SUB[,START]) method of the string module. I am having me luck geting it to process. I have an variable int the namespace called 'email_address' (original, huh) I then try to call a conditional like so:  It's not valid!  It is!  It can't parse the DTML because of a Python syntax error. I am probably misunderstanding the way to call the find method of the string mocule. Any ideas? Jason Spisak

2 2

nisUserFolder
by Will Fife 03 Sep '99

03 Sep '99

I would like to announce the imediate availability of the nisUserFolder product. This nisUserFolder product is heavily based off of the etcUserFolder product, with probably only 30 or 40 lines of code that are different between the two products. Anyways, it is available at http://www.zope.org:18200/Members/zazen/nisUserFolder Happy zopeing everyone. ps. If someone would be kind enough to post this to the zope(a)zope.org list, It would be appreciated. --------========================================================-------- Phone: (949) 581-1700 Will Fife http://www.techfuel.com Pager: (949) 451-9443 System Engineer will(a)techfuel.com --------========================================================--------

2 1

Calling a DTML method from python?
by David Kankiewicz 03 Sep '99

03 Sep '99

Hi Zope/Python gurus, What's the fastest/quickest way to get into zope and run a DTML method? I am attempting my first product and need to call a method inside my ZClass product / which may or may not call python products... What modules do I need to import and can someone go over simple example? DTMLmethod Sweeps through ZCatalog files and creates a ZClass instance with the current(soon to be old) variables in them.. (I might change these to python but not right now) etc... pythonproduct.py import "what? to access DTML methods" ZPublisher? client? etc.? def storeState(): some_imported_module's_invoking_method(DTMLmethod, args) ?? BTW: zope.org beta site has a bad how-to link to the "adding ZClass instances programmatically". It goes to the homepage. (looks like tazzzzz might have removed it?) TIA, David

1 1

Re: [Zope-dev] How to invoke a Z SQL method from python
by Martijn Pieters 03 Sep '99

03 Sep '99

At 18:37 3-9-99 , Jim Penny wrote: >Sorry to bother you again, but how do I get at the results? >I.e., I can see that a=self.sql_test(request_number=44) is >triggering a SQL query. But now I can't figure out the >number of rows selected, the size, or the contents of the rows. > >Thanks in advance, and I promise I won't bother you again for a month! Just keep bothering the list =) It is weekend for me now.. =) Returned is a list of row objects, and each row object is just a dumb class with the different columns converted to class attributes. So you test for the length of the result, loop through it like any list and access attributes on the list objects, including list.__dict__.keys() for a list of attributes. -- Martijn Pieters, Web Developer | Antraciet http://www.antraciet.nl | T: +31 35 7502100 F: +31 35 7502111 | mj(a)antraciet.nl http://www.antraciet.nl/~mj | PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 ---------------------------------------------

1 0

How to invoke a Z SQL method from python
by Jim Penny 03 Sep '99

03 Sep '99

Hi, I have to model some legacy forms. They are tricky enough and the user's picky enough that I am not going to be able to use HTML as the source language. So I want to drop to TeX. I have tucked the data for the form away in an external database. How do I execute a query against a ZSQL method from python. In particular, I have a ZSQL method sql_test, that has a single argument request_number. Mucking about in python, I can see by program def test(self, request_number): return request_number, dir(self.sql_test): that sql_test has structure: ['__ac_local_roles__', '_arg', '_col', '_v_brain', '_v_cache', 'arguments_src', 'connection_id', 'id', 'src', 'template', 'title'] But, I don't see anything in sight that actually causes the query to be invoked. Could someone give an example, or point me to the general area of the source code in which a ZSQL method is invoked? Thanks. Jim Penny

2 1

thread safety in external methods
by Robin Becker 03 Sep '99

03 Sep '99

How do I do thread safety inside an External method. I want to access a global singleton as def __ZGA(): if not hasattr(sys.modules['__main__'],'__ZGA'): #unsafe here... Z=ZGA_calculator() # initialise things to do with Z sys.modules['__main__'].__dict__['__ZGA']=Z return sys.modules['__main__'].__dict__['__ZGA'] the problem is controlling access to sys.modules['__main__'].__dict__['__ZGA']. I can't have a global lock inside my external method as I get a different environment with each call (which is why I need the singleton in the first place). It would be sufficient for my purposes if I could guarantee to get certain code run just once at startup time. Do I have to make a product or is there some easier way to do this. -- Robin Becker

3 7

ts_regex.py broken in Z2.0 final? was [Zope] Announce: Confera 1.3.1
by Andreas Kostyrka 03 Sep '99

03 Sep '99

On Thu, 2 Sep 1999, Nick Garcia wrote: > Looks good here! I guess this means I don't have to look into it after > all ;) Well, it doesn't look to well here. Actually, the fix I've did, I understand, I've switched from the old regsub to the threadsafe regex module. Now this, I don't understand, it seems like the ts_regex.py is broken for gsub. The offending line in Confera.py is: body =split(ts_regex.gsub(crlf,'\n',body),'\n') Which seems to make quite sense to me. Traceback (innermost last): File /home/zopebot/redhat/BUILD/Zope-2.0.0-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /home/zopebot/redhat/BUILD/Zope-2.0.0-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /home/zopebot/redhat/BUILD/Zope-2.0.0-src/lib/python/Zope/__init__.py, line 201, in zpublisher_exception_hook File /home/zopebot/redhat/BUILD/Zope-2.0.0-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /home/zopebot/redhat/BUILD/Zope-2.0.0-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: addMessage) File /home/zopebot/redhat/BUILD/Zope-2.0.0-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: addMessage) File /home/zopebot/zope/Products/Confera/Confera.py, line 568, in addMessage File /home/zopebot/redhat/BUILD/Zope-2.0.0-src/lib/python/ts_regex.py, line 109, in __call__ File /var/tmp/mze-python-root/opt/mtg/lib/python1.5/regsub.py, line 38, in gsub AttributeError: (see above) Andreas -- Andreas Kostyrka | andreas(a)mtg.co.at phone: +43/1/7070750 | phone: +43/676/4091256 MTG Handelsges.m.b.H. | fax: +43/1/7065299 Raiffeisenstr. 16/9 | 2320 Zwoelfaxing AUSTRIA

2 1