- Zope-Dev - Zope lists

Re: [Zope-dev] dtml-in: next-batches
by Brett Carter 08 Mar '01

08 Mar '01

I tried accessing keys off the 'data' object, and I just get an 'unathorized' error. -Brett >>>>> "Dieter" == Dieter Maurer <dieter(a)handshake.de> writes: Dieter> Brett Carter writes: >> I'm running Zope 2.2.2, and I'm trying to use the batching stuff for >> the dtml-in tag, however, I can't seem to access any attributes off >> the 'next-batches' or 'previous-batches' mapping object that's >> supposed to be available, with the attributes 'batch-start-index', >> 'batch-end-index', and 'batch-size'. >> .... >> I wrote an external method to dir the 'next-batches' object, and it >> seems the only attributes available are: >> ['data', 'items', 'query_string', 'start_name_re'] Dieter> The attributes your are looking for are in fact keys Dieter> of the mapping 'data'. Dieter> Dieter

2 1

ZSQl Cache
by Bryan Baszczewski 08 Mar '01

08 Mar '01

Anyone have an idea of what the optimal cache time is (all things considered .. "normal" circumstances) for a ZSQL query <= 50 rows? Does Zope tend to lag or suck too much memory at some point? Bryan Baszczewski Software Engineer/Technology Strategist 2s2i, Inc. www.2s2i.com phone: (703)534-9800 x-203 fax: (703)995-4866 "Because word of mouth has gone global, there's e-Intelligence from 2s2i."

1 0

(Newbie Alert)- How to change multiple properties from a selection list
by stefano.ciccarelli＠thewhitebird.com 08 Mar '01

08 Mar '01

Hi, I am trying to assign more than one property from a form selection list. I have a ZClass "Course Description" that holds ..a course description (title, learning objectives, agenda, prerequisites,link to docs,etc.) and another ZClass "Course session" that holds the course time and space related data(start date, end date, summary,location, etc.) Trainers create courses and course managers (CM) decide when and where to have these courses. Once the CM wants to set up a session, he adds a Course session, selects the course title from a selection list and decides when and where to have this course. The selection list is generated by a catalog search. What I would like to do, is the following: Since the title is not unique, what the CM really chooses is the Course id. Based on the selected id I would like to : copy the title property of the Course Description to the title property of Course Session. update the "link to Agenda" property of the Course Session with the path to the selected Course Description. I know how to do this singularly, but not all at hte same time. Any Idea? Here follows some code I am using for the selection list <th>Title of event</th> <td><select name="id1:int"> <dtml-in "Catalog(meta_type='Course Description')"> <OPTION value='<dtml-var data_record_id_>'><dtml-var title></OPTION> </dtml-in> </select> </td> Thank you very much, Stefano

1 0

RE: [Zope-dev] dtml-in: next-batches
by Bryan Baszczewski 08 Mar '01

08 Mar '01

I found this in some Zope documentation. It wont give you "1,2,3,4,5...10" it gives "(1-10)(11-20)(21-30)...". Monkey with it a little and you'll get it. Beware it will call your External Method or ZSQL as many times/10. <dtml-in expr="SOME_EXTERNAL_METHOD(REQUEST)" previous orphan=1 size=10 start=qs> <dtml-in previous-batches mapping> <dtml-unless sequence-start>, </dtml-unless> <a href="<dtml-var document_id><dtml-var sequence-query >qs=<dtml-var batch-start-number>"> (<dtml-var batch-start-number> - <dtml-var batch-end-number>)</a> </dtml-in> </dtml-in> <dtml-in expr="SOME_EXTERNAL_METHOD(REQUEST)" next orphan=1 size=10 start=qs> <dtml-in next-batches mapping> <dtml-unless sequence-start>, </dtml-unless> <a href="<dtml-var document_id><dtml-var sequence-query >qs=<dtml-var batch-start-number>"> (<dtml-var batch-start-number> - <dtml-var batch-end-number>)</a> </dtml-in> </dtml-in> <dtml-in expr="SOME_EXTERNAL_METHOD(REQUEST)" orphan=1 size=10 start=qs> <dtml-var sequence-index>)"> <dtml-var expr="_.getitem('sequence-item')[1]"> <dtml-var expr="_.getitem('sequence-item')[2]"> </dtml-in> -Bryan -----Original Message----- From: zope-dev-admin(a)zope.org [mailto:zope-dev-admin@zope.org]On Behalf Of Brett Carter Sent: Wednesday, March 07, 2001 6:34 PM To: zope-dev(a)zope.org Subject: [Zope-dev] dtml-in: next-batches 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 _______________________________________________ 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

FYI. I've removed my Base64 MIME encoding
by Johan Carlsson 07 Mar '01

07 Mar '01

FYI. I've removed my Base64 MIME encoding. Thanks to Dieter for alerting me to the problem. Regards, Johan Carlsson

1 0

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