- Zope - Zope lists

MySQL Transaction/Locking/etc
by Terry Hancock 11 Dec '02

11 Dec '02

Hi All, Twice now I've come into what must be a fairly common problem when using SQL databases in Zope: I simply want MySQL to give me a unique identifier and I need to retrieve what its value is to continue using the correct record. The MySQL side of this is very straightforward -- I just make an AUTO_INCREMENT field and use LAST_INSERT_ID() to get what its value was. I'm less sure how safe this is in Zope -- the whole point being, of course, that when running multi-threaded, another thread *could* stick another record into the table, so that LAST_INSERT_ID() comes up with the wrong value. As a perhaps naive attempt to handle this in a previous application (for which the consequences of an error were not too severe), I simply used the threading module and acquired a lock -- I'm hoping that this will keep at least any threads within my current Zope process from interfering. (Please forgive my ignorance of threads if this betrays a deep misunderstanding! Corrections will be much appreciated. ;-)). I can however, picture installations with more than one Zope *process* running, but accessing the same database, which would presumeably allow collisions under high loads. :-( I tried using MySQL's table-locking mechanism to do this, but the lock would cause *all* my queries to fail -- including the ones that I was supposed to be protecting. Since each ZSQL method can only do one query, I couldn't figure out how to run a batch of them. MySQL can do transactional tables nowadays, but I'm not sure if they would actually make sense for this application -- this "get a unique new record id" function is the only thing I really need to do this way. And I'm not even sure that transactions would be proof against this (would transactions stop the LAST_INSERT_ID() being incremented in the middle of the transaction? It doesn't seem like it would actually violate the transaction model to do that). There doesn't seem to be much on the Zope website or in the ZDG about how to deal with this situation (or perhaps I don't know what to search for). Has anyone else solved it? Is the thread-locking solution adequate, or is there a better way? Any suggestions? Thanks, Terry -- Terry Hancock ( hancock at anansispaceworks.com ) Anansi Spaceworks http://www.anansispaceworks.com "Some things are too important to be taken seriously"

3 2

Re: [Zope] Session length
by Dennis Allison 11 Dec '02

11 Dec '02

> > Is there anyway to use the Session Data Manager or a related component to > measure the length of a session? What I actually would like is an event that > fires the moment a session expires and one that fires the moment a session > is initiated (well, the last thing you could do by inserting something in > the session and checking whether it already was there). > The session_data object (in the temp folder) has hooks for session start and stop. These hooks are also available through the API. Read the Zope Book (2nd edition -- on-line) about sessions for more info.

1 0

Comprehensive IIS setup
by Martin, Greg (CSC) 11 Dec '02

11 Dec '02

Is there a comprehensive guide somewhere for installing Zope with IIS? I'm trying to install Zope (and eventually squishdot). I find the instructions for doing so a bit vague. Thanks \\Greg <\\Greg> ************************************************************************** This e-mail and any files transmitted with it may contain privileged or confidential information. It is solely for use by the individual for whom it is intended, even if addressed incorrectly. If you received this e-mail in error, please notify the sender; do not disclose, copy, distribute, or take any action in reliance on the contents of this information; and delete it from your system. Any other use of this e-mail is prohibited. Thank you for your compliance.

3 2

Calling sql method from FS product
by Ruslan Spivak 11 Dec '02

11 Dec '02

Hello zope users, need your help: how to call sql method from the filesystem product? should i create this sql method through the web before, or is it possible to call sql directly from product code? Your help is very, very appreciated. Thanks in advance. Best regards, Ruslan mailto:alienoid@is.lg.ua

3 2

ASCII decoding error
by Carlos Alberto Micucci 11 Dec '02

11 Dec '02

I', developing a new product and when I'm navigate the manage_edit page and submitt, this error ocurred: Error Type: UnicodeError Error Value: ASCII decoding error: ordinal not in range(128) I've not idea about this, but in my Zope 2.5 instalation does not ocurred. Can you help me? Thanks. Ing. Carlos Alberto Micucci. Camino a los Reartes km 41/2. Villa General Belgrano. Córdoba. Casilla de correo nro. 30 (5194) Te.: 03546-463508

1 0

localfs
by Coanda, Mihai 11 Dec '02

11 Dec '02

Hi, I'm a new user for LocalFS product. I have a form <form method="POST" action="processForm_localFS" enctype="multipart/form-data"> File or Image: <input type="file" name="filex" value="" /> <br /> <input type="submit" name="save" value="Upload" /> </form> and this is evaluated by the following DTML Method processForm_localFS : <dtml-call "REQUEST.set('new_id', ZopeTime().strftime('%Y%m%d%H%M%S'))"> <dtml-if filex> <p>Variable "filex" exists and has the value "<dtml-var "_.str(REQUEST.filex)">".</p> </dtml-if> <dtml-var REQUEST> <dtml-comment> <dtml-call "testerx.manage_upload( filex, new_id )"> where testerx is a LocalFS object. This returns: ============ Variable "filex" exists and has the value "". form filex <ZPublisher.HTTPRequest.FileUpload instance at e41414> How can I find the name and the path of the filex? Please can you send me some samples (or a link) about how can be used this LocalFS product? Kind regards Mihai

2 1

Audio tracks about Zope
by Jerome Alet 11 Dec '02

11 Dec '02

Hi, On November 23 2001, there was a Zope meeting at Net4Any Paris, with Paul Everitt. As announced here : http://www.zope.org/Documentation/ZWN/ZWN-2001-12-03 parts of this meeting were recorded in MP3 format and made available from the links listed here : http://www.comlounge.net/pipermail/eurozope/2001-November/001085.html These tracks are still available, as well as the zopeintro-1.mp3 and zopeintro-2.mp3 situated at the same place. Since I plan to modify this audio server's config this week, please download the files if you want to keep them elsewhere, otherwise they'll be deleted probably on Friday or without further notification. Thanks in advance. Jerome Alet

2 2

Re: [Zope] MySQL Transaction/Locking/etc
by Michael Long 11 Dec '02

11 Dec '02

I believe that your premise that ZSQL can only do one query is false. I am able to handle this exact situation (using postgres) with the following in a single ZSQL method: insert into mytable(id,col1,col2) values(nextval('seq_id'),val1, val2); select curval('seq_id'); This will cause the ZSQL method to return the newly inserted id to you and this all happens within a single transaction. -mike > Hi All, > Twice now I've come into what must be a fairly common problem when using SQL > databases in Zope: I simply want MySQL to give me a unique identifier and I > need to retrieve what its value is to continue using the correct record. > > The MySQL side of this is very straightforward -- I just make an > AUTO_INCREMENT field and use LAST_INSERT_ID() to get what its value was. > > I'm less sure how safe this is in Zope -- the whole point being, of course, > that when running multi-threaded, another thread *could* stick another record > into the table, so that LAST_INSERT_ID() comes up with the wrong value. As a > perhaps naive attempt to handle this in a previous application (for which the > consequences of an error were not too severe), I simply used the threading > module and acquired a lock -- I'm hoping that this will keep at least any > threads within my current Zope process from interfering. (Please forgive my > ignorance of threads if this betrays a deep misunderstanding! Corrections > will be much appreciated. ;-)). > > I can however, picture installations with more than one Zope *process* > running, but accessing the same database, which would presumeably allow > collisions under high loads. :-( > > I tried using MySQL's table-locking mechanism to do this, but the lock would > cause *all* my queries to fail -- including the ones that I was supposed to > be protecting. Since each ZSQL method can only do one query, I couldn't > figure out how to run a batch of them. > > MySQL can do transactional tables nowadays, but I'm not sure if they would > actually make sense for this application -- this "get a unique new record id" > function is the only thing I really need to do this way. And I'm not even > sure that transactions would be proof against this (would transactions stop > the LAST_INSERT_ID() being incremented in the middle of the transaction? It > doesn't seem like it would actually violate the transaction model to do that). > > There doesn't seem to be much on the Zope website or in the ZDG about how to > deal with this situation (or perhaps I don't know what to search for). Has > anyone else solved it? Is the thread-locking solution adequate, or is there > a better way? > > Any suggestions? > > Thanks, > Terry > > -- > Terry Hancock ( hancock at anansispaceworks.com ) > Anansi Spaceworks http://www.anansispaceworks.com > > "Some things are too important to be taken seriously" > > _______________________________________________ > 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

WebDAV Functionality Question
by Patrick Hresko 11 Dec '02

11 Dec '02

Hello, I have Zope (2.5.1) installed and have the WebDAV server set up ( -W 8088) and working. I am using win2k web folders to connect to the webdav server. I can connect and browse just fine, but I get an error when I try copy a file from my win2k box to the server. Has anyone found a way around this. Thanks. Patrick

5 9

creating z-class in folder
by Jorg E. Rødsjø 11 Dec '02

11 Dec '02

I am trying to create a z-class (which resides in a product I have made) in a given folder through a python script. My syntax is obviously wrong (since it is not working), but alas I cannot find out what it is.. anyone? context.manage_addProduct['productName'].manage_z-class-constructor("spam") -jorg

2 2