March 2001 - Zope-Dev

Saving attributes for a DataSkin
by Johan Carlsson 07 Mar '01

07 Mar '01

Hi, I'm having some trouble figuring out how to write a method and a skinscript to save attributes of a DataSkin. Specialist is the LoginManager. DataSkin is: class EasyGroupUser(LoginUser): ... def getRoles(self): ... def getDomains(self): ... def authenticate(self, password, request): ... SkinScripts are: WITH QUERY sql_getUserFor(username=self.id) COMPUTE username, password, challenge_question, challenge_answer, admin_email WHEN OBJECT CHANGED STORE password, challenge_question, challenge_answer, admin_email USING sql_changeUser( username=self.id, newpassword=password, challenge_question=challenge_question, challenge_answer=challenge_answer, admin_email=admin_email, oldpassword=OLD['oldpassword'] ) SAVING oldpassword = password Current Attribute Handling: admin_email Getters: SkinScript, line 1 Setters: SkinScript, line 10 Deleters: SkinScript, line 10 challenge_answer Getters: SkinScript, line 1 Setters: SkinScript, line 10 Deleters: SkinScript, line 10 challenge_question Getters: SkinScript, line 1 Setters: SkinScript, line 10 Deleters: SkinScript, line 10 password Getters: SkinScript, line 1 Setters: SkinScript, line 10 Deleters: SkinScript, line 10 The getter works alright, but when trying to set attributes (that supposedly would be handle by the setter) with the following Script (Python) I get the following error: ## Script (Python) "changeUser" ##bind container=container ##bind context=context ##bind namespace=self ##bind script=script ##bind subpath=traverse_subpath ##parameters=username,password,challenge_question,challenge_answer,admin_email ##title= ## user = context.getItem(username) user.password=password user.challenge_question=challenge_question user.challenge_answer=challenge_answer user.admin_email=admin_email ERROR MESSAGE: Error Type: TypeError Error Value: attribute-less object (assign or del) So what am I doing wrong here? Any clues appreciated. TIA/Johan Carlsson

1 0

dtml-in: next-batches
by Brett Carter 07 Mar '01

07 Mar '01

Does anybody have an example of how to use the supposed next-batches mapping returned by dtml-in? I'm trying to build a google-like pageing feature into my application, so we just show the first 5 results, then have a link to each next page, ie "1,2,3,4..." Thanks, -Brett

1 0

Re: [Zope-dev] Attribute providers for Specialists
by Dieter Maurer 07 Mar '01

07 Mar '01

Johan Carlsson writes: > SGksDQpBcyBJIHVuZGVyc3RhbmQgaXQgU3BlY2lhbGlzdCBjYW4ndCBnZXQgdGhlcmUgYXR0cmli > dXRlcyBmcm9tIGEgcHJvdmlkZXI/DQoNCkZvciBpbnN0YW5jZSwgdGhlIExvZ2luTWFuYWdlciBr > .... If you would not post MIME messages, I would be able to read your posts. I know what I get is base64 encoded. And I know, how to decode it, in principle. But it takes considerable effort. I would only do it, if I would know beforehand how interesting your post is. As it stands now, I just discard your messages.... Dieter

1 0

[OT] Zope Designer For Hire
by Michael R. Bernstein 07 Mar '01

07 Mar '01

Hi all, I realize this is a little off-topic, but I figured I'd give it a shot anyway. I am a Zope-savvy web-designer that has recently been 'downsized', and I'm looking for a new employer. I'm located in Las Vegas, NV, and would prefer not to relocate, but would be open to telecommuting. Resume and URL's available on request. Please reply off-list. And now, back to your regularly scheduled program. Thank you, Michael Bernstein.

1 0

RE: [Zope-dev] RE: ZODBC problem
by Bryan Baszczewski 07 Mar '01

07 Mar '01

Alan, I am having a similar lock-out problem while performing a complex query on SQL Server 2K. All other hits cannot connect until the query returns the results. My research has so far taken me here: http://www.zope.org/Members/petrilli/DARoadmap Which is telling me I am probably using at most a Level-2 DA with my ZODBC. And then here: http://www.zope.org/Members/djay/ZmxODBC/ZmxODBC_0_0_2.tgz/README Which is a Level-3 mxZODBC DA (multithreaded). If anyone sees a problem with what I am about to do, let me know. What do you think? -----Original Message----- From: zope-dev-admin(a)zope.org [mailto:zope-dev-admin@zope.org]On Behalf Of Capesius, Alan Sent: Wednesday, March 07, 2001 12:31 PM To: zope(a)zope.org Cc: zope-dev(a)zope.org Subject: [Zope-dev] RE: ZODBC problem Thanks Dieter, I was kinda looking for a solution, I reviewed the mailing lists but do not see any solutions. I've done some more testing here: Summary: The user selects an involved financial report. The report takes about 55 seconds for Zope to prepare. The first second is the SQL server request and reply. The remaining time is Zope processing (dual 200mhz NT box). My queries are SELECT JOINS. No tables are modified at the server. The problem I see here is that Zope/ZODBCDA is holding the connection to SQL open via ODBC until all processing is complete and then issuing an SQL statement: IF @@TRANCOUNT>0 COMMIT TRAN Zope could free up this connection after one second. (at least in this case) Until Zope does the commit, other users are locked out. For read only queries, there is no need to have the request under transaction control. In any case, Zope should be able to early release the SQL connection and then process on the results. Certainly increasing processor speed will mask this problem and provide better response to users, but I'm hoping for a real fix. Thanks, Alan Network Monitor trace Wed 03/07/01 10:51:50 c:\cap1.TXT Frame Time Src MAC Addr Dst MAC Addr Protocol 1 4.413 006008F6062B COMPAQ851F04 TCP 2 4.413 006008F6062B COMPAQ851F04 TCP 3 4.413 006008F6062B COMPAQ851F04 TCP [....] 193 5.072 006008F6062B COMPAQ851F04 TCP 194 5.073 COMPAQ851F04 006008F6062B TCP 195 5.090 COMPAQ851F04 006008F6062B TCP 196 5.090 006008F6062B COMPAQ851F04 TCP 197 5.090 006008F6062B COMPAQ851F04 TCP 198 5.091 COMPAQ851F04 006008F6062B TCP 199 5.109 COMPAQ851F04 006008F6062B TCP 200 5.127 COMPAQ851F04 006008F6062B TCP // SQL server goes idle after this // python DTML processing occurs here 201 10.834 006008F6062B COMPAQ851F04 TCP // not sure what this is, Data is 0xA8 202 10.834 COMPAQ851F04 006008F6062B TCP // reply, data is empty // page returns to user at 60 second mark // then Zope closes the connection 203 60.385 COMPAQ851F04 006008F6062B TCP SQL: IF @@TRANCOUNT>0 COMMIT TRAN 204 60.386 006008F6062B COMPAQ851F04 TCP 205 60.601 COMPAQ851F04 006008F6062B TCP >Capesius, Alan writes: > > ... > > with further testing I > > have determined that the Zope server itself is not locking up, but rather > > requests to the database (MS SQL7 via ZODBCDA) seem to be queueing up. >My memory tells me faintly that such an issue has already been >discussed in the mailing lists (zope, zope-dev). >When I remember right, ZODBCDA synchronizes all database requests >--> searchable list archives... >Dieter _______________________________________________ Zope-Dev maillist - Zope-Dev(a)zope.org http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )

1 0

RE: ZODBC problem
by Capesius, Alan 07 Mar '01

07 Mar '01

Thanks Dieter, I was kinda looking for a solution, I reviewed the mailing lists but do not see any solutions. I've done some more testing here: Summary: The user selects an involved financial report. The report takes about 55 seconds for Zope to prepare. The first second is the SQL server request and reply. The remaining time is Zope processing (dual 200mhz NT box). My queries are SELECT JOINS. No tables are modified at the server. The problem I see here is that Zope/ZODBCDA is holding the connection to SQL open via ODBC until all processing is complete and then issuing an SQL statement: IF @@TRANCOUNT>0 COMMIT TRAN Zope could free up this connection after one second. (at least in this case) Until Zope does the commit, other users are locked out. For read only queries, there is no need to have the request under transaction control. In any case, Zope should be able to early release the SQL connection and then process on the results. Certainly increasing processor speed will mask this problem and provide better response to users, but I'm hoping for a real fix. Thanks, Alan Network Monitor trace Wed 03/07/01 10:51:50 c:\cap1.TXT Frame Time Src MAC Addr Dst MAC Addr Protocol 1 4.413 006008F6062B COMPAQ851F04 TCP 2 4.413 006008F6062B COMPAQ851F04 TCP 3 4.413 006008F6062B COMPAQ851F04 TCP [....] 193 5.072 006008F6062B COMPAQ851F04 TCP 194 5.073 COMPAQ851F04 006008F6062B TCP 195 5.090 COMPAQ851F04 006008F6062B TCP 196 5.090 006008F6062B COMPAQ851F04 TCP 197 5.090 006008F6062B COMPAQ851F04 TCP 198 5.091 COMPAQ851F04 006008F6062B TCP 199 5.109 COMPAQ851F04 006008F6062B TCP 200 5.127 COMPAQ851F04 006008F6062B TCP // SQL server goes idle after this // python DTML processing occurs here 201 10.834 006008F6062B COMPAQ851F04 TCP // not sure what this is, Data is 0xA8 202 10.834 COMPAQ851F04 006008F6062B TCP // reply, data is empty // page returns to user at 60 second mark // then Zope closes the connection 203 60.385 COMPAQ851F04 006008F6062B TCP SQL: IF @@TRANCOUNT>0 COMMIT TRAN 204 60.386 006008F6062B COMPAQ851F04 TCP 205 60.601 COMPAQ851F04 006008F6062B TCP >Capesius, Alan writes: > > ... > > with further testing I > > have determined that the Zope server itself is not locking up, but rather > > requests to the database (MS SQL7 via ZODBCDA) seem to be queueing up. >My memory tells me faintly that such an issue has already been >discussed in the mailing lists (zope, zope-dev). >When I remember right, ZODBCDA synchronizes all database requests >--> searchable list archives... >Dieter

1 0

Attribute providers for Specialists
by Johan Carlsson 07 Mar '01

07 Mar '01

Hi, As I understand it Specialist can't get there attributes from a provider? For instance, the LoginManager knows about roles and domains, I would like to get this from attributes but I don't want to be able to get them from an attribute provider. In that way I can make a GUI interface that doesn't know about the storage, and it could be changes as easy as rewrite my Skinscripts. Well almost anyway. So is there a way to get Specialists, and specially LoginManager to get there attribute from a provider? TIA/Johan Carlsson

1 0

Announcement: CMF 1.0 beta released
by Tres Seaver 06 Mar '01

06 Mar '01

We are pleased to "release version 1.0 beta", http://cmf.zope.org/download/CMF-1.0beta of the Zope Content Management Framework (CMF). Please review the "release notes":../README.txt and the "known issues":../ISSUES.txt. >From the README: What is the CMF? The Zope Content Management Framework provides a set of services and content objects useful for building highly dynamic, content-oriented portal sites. As packaged, the CMF generates a site much like the Zope.org site. The CMF is intended to be easily customizable, in terms of both the types of content used and the policies and services it provides. Resources * The CMF "dogbowl" site, "http://cmf.zope.org":http://cmf.zope.org. * The mailing list, zope-ptk(a)zope.org. List information and online signup are available at: http://lists.zope.org/mailman/listinfo/zope-ptk. Archives of the list are at: http://lists.zope.org/pipermail/zope-ptk. Tres. -- =============================================================== Tres Seaver tseaver(a)digicool.com Digital Creations "Zope Dealers" http://www.zope.org

2 1

Implementing ZPattern: Containment
by Johan Carlsson 06 Mar '01

06 Mar '01

Hi, How could containment be implemented with ZPatterns. Container -n-----1- ContainedItem -n-----1- ContainedSubItem I suppose there would be a Containter Specialist containing a ContainerItem Specialist. But Specialists retrieve objects by IDs so there would also be a list of ContainerItem ID in the Container object. Are there any other way to do it, for instance keeping a list of object references that would be retrieve from the ContainerItem Specialist by a attribute provider in the Containter Specialist? But I still need the list of IDs don't I or how else would the ContainerItem Specialist know what objects to return? TIA, Johan Carlsson

2 2

Re: [Zope-dev] Possible 'bad' with Client.py and urllib
by Dieter Maurer 06 Mar '01

06 Mar '01

Chris Withers writes: > .... urllib & Client block Zope .... That would suggest a bug in Python's socket implementation: its "makefile().read" method would not release the global interpreter lock. Dieter

2 3