- Zope-Dev - Zope lists

zope + speed + persistant db
by Paul Mokbel 07 Sep '99

07 Sep '99

Hi, I have a few aching questions to ask.. Maybe some of you can bright some light on 'em.. 1) How fast is zope running as ZServer.. (is it fairly fast).. If I use an external python method, and 'import' python modules (if it was previously called), will it reload? or am I confused as to how zope works. 2) Does zope support persistant MySQL connections *THIS IS A MUST!*. Zope, php, mod_perl have some kind of support for persistant SQL connections.. In other words, if a previous connection to a DB was opened and not closed, it re-uses it automatically. It does increase performance.. 3) Does zope use medusa? If not, WHY!?!?!?! (so far, I'd say that medusa is perfect for the operation.. but maybe I'm wrong.. clarify) 4) As per the pcgi CGI wrapper that runs under any other web server: Is there a speed indifference compared to having the ZServer taking care of the http requests.. (pretty obvious, but is it marginal).. 5) To be frank, I am not interested in DTML; rather, I am interested in the python implementation and the possibility of using it for mission critical python CGIs. I previously wanted to implement Python into Boa (a fast httpd, and using it strictly for serving out Python CGI's without the forking of a process). Is this for me? or perhaps maybe httpdapy or pyapache.. I'm looking for performance more than ANYTHING! Thanks! /* "There are two major products that came out of Berkeley: LSD and Unix. We don't believe that to be a coincidence. " -BSD fortunes Paul Mokbel */

2 1

Re: [Zope-dev] Image.py modifications.
by Mauricio Souza 07 Sep '99

07 Sep '99

I found a function in the image class in Zope2 named "tag". You pass parameters and it converts to img tags in the code like:  = <img src=image height=20 width=20 border=0> this works, but i want that border=0 be a default property in my images... Okay? -- Mauricio Souza Lima <mauricio(a)hiper.com.br> Hiperlógica <http://hiper.com.br> Automação de web-sites | Website automation São Paulo | Brasil | Fone: +55-11-251-4894

1 0

RE: [Zope-dev] zope + speed + persistant db
by Michel Pelletier 07 Sep '99

07 Sep '99

> -----Original Message----- > From: Paul Mokbel [mailto:pm@webhosting.com] > Sent: Tuesday, September 07, 1999 10:45 AM > To: Zope-Dev(a)zope.org > Subject: [Zope-dev] zope + speed + persistant db > > > > Hi, > > I have a few aching questions to ask.. Maybe some of you can > bright some > light on 'em.. > > 1) How fast is zope running as ZServer.. (is it fairly > fast).. If I use an > external python method, and 'import' python modules (if it > was previously > called), will it reload? or am I confused as to how zope works. > How fast is Zope? Compared to what? External methods are reloaded when they are re-edited. If you change an external method and you want to reload it, just click on the method and click 'Edit'. This will reload the actual python from the filesystem. Modules are not reloaded on each hit. Zope is a large system. Confusion is understandable. Brian wrote a brand-new External Method How-To that might help: http://www.zope.org:18200/Documentation/How-To/ExternalMethods > 2) Does zope support persistant MySQL connections *THIS IS A MUST!*. > Zope, php, mod_perl have some kind of support for persistant SQL > connections.. In other words, if a previous connection to a > DB was opened > and not closed, it re-uses it automatically. It does increase > performance.. > Zope will reuse database connections very intelligently. > 3) Does zope use medusa? If not, WHY!?!?!?! (so far, I'd say > that medusa > is perfect for the operation.. but maybe I'm wrong.. clarify) > Yes Zope uses medusa as it's socket 'core'. The reasons why are very technical but very good reasons. medusa is a very important component of zope's performance story. > 4) As per the pcgi CGI wrapper that runs under any other web > server: Is > there a speed indifference compared to having the ZServer taking > care of the http requests.. (pretty obvious, but is it marginal).. > Yes. Apache and other CGI based systems fork a new process to invoke the pcgi wrapper. This fork system call is typically expensive. > 5) To be frank, I am not interested in DTML; rather, I am > interested in > the python implementation and the possibility of using it for mission > critical python CGIs. I previously wanted to implement Python > into Boa (a > fast httpd, and using it strictly for serving out Python > CGI's without the > forking of a process). Is this for me? or perhaps maybe httpdapy or > pyapache.. Zope provides more than just DTML, it provides gobs and gobs of very useful framework, including security, object abstractions, rich API, extensibility in several directions, Relation Object Integration, etc... If you don't need any of these things, or if you are going to roll-your-own framework, then don't use Zope. -Michel

1 0

Image.py modifications.
by Mauricio Souza 07 Sep '99

07 Sep '99

In my Zope 1 and Zope 2, i do a modification on the Image classes. I created a default property named border with the value 0 and when we call the __str__ function i put the 'border=0' inside the tag. I do that because i want to use the simple <a href></a> without getting terrible blue borders around my image. What you all think about that change to be implemented in future zope versions? -- Mauricio Souza Lima <mauricio(a)hiper.com.br> Hiperlógica <http://hiper.com.br> Automação de web-sites | Website automation São Paulo | Brasil | Fone: +55-11-251-4894

1 0

Moniker.py
by Sascha Matzke 07 Sep '99

07 Sep '99

Hello, I have a question to this class. Does it provide the ability to "link" an object anywhere in a zope-hierachy but retain the acquisition paths and so on ?? Sascha -- .-> Sascha Matzke - sascha(a)bespin.de - http://www.bespin.de -. | I wanna be the mover to real anarchy !!!!!!! | | ATR | `-- On this earth for 23 years, 329 days <----------------'

1 0

Hello, fellow Zopers - about the CIS..
by Eron 07 Sep '99

07 Sep '99

Greets. I am the developer of the CIS project, and, would like to give a quick notice to all: 1. 1. The CIS project is a project aiming at helping communities everywhere build their own civic networks (there is a report on this at CIS's website). It is very different from anything that might seem to be similar in design. I feel the documentation is coming along well, and a clear understanding of what it is can be gathered from it. Anyone with qustions will be warmly welcomed to contact me (and maybe point out somthing I have missed). 2. 2. The CIS project is NOT competing with Zope in anyway. One of the main things we are interested in is the Portal Toolkit - it seems like a very good design in be incorporated into the CIS. If, somewhere down the road, we are fortunate to extend it's capabilities beyond that existing now, we plan to make the developments available back to the Zope community. Remember, Zope is the CIS's framework, the Portal Toolkit an engine. We are not attempting to replace anything Zope is doing. Zope is good. Zope is great. That's why we chose it, dig? :-) Great, now we are all on the same level. Keep up the good work, guys!! Working for the good of mankind, Eron Lloyd (EarthTone)

1 0

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