- Zope - Zope lists

Transactions
by Daniel Fairs 11 Jun '01

11 Jun '01

Hi, Reading some of the recent emails on Zope's transaction engine, something popped into my head which isn't mentioned in the book. How visible are Zope's transactions? I'm talking about the difference between read committed, read uncommitted and serializable transactions that you get in relational databases. I'm guessing that objects in Zope which participate in transactions can see changes made during that transaction? Is it possible to change this, so other transactions can read uncommitted data? Clearly, this isn't so important on smaller sites - but what happens when you start using Zope in high-transaction-volume sites? I'm just curious... ;) Cheers, Dan _________________________________________________________________ Daniel Fairs | daniel.fairs(a)spiderplant.net | www.spiderplant.net

2 1

ZSql Method with like.
by After Dark 11 Jun '01

11 Jun '01

How should I do to use 'like' with ZSql Method? Similar to the example: Ex.: SELECT field1 FROM table WHERE field2 LIKE '%test%' I tryed this: --> arq is an argument select field1 from table where field2 like '%<dtml-sqlvar arg type=string>%' Then I get this: select field1 from table where field2 like '%'agx'%' I need to put the char '%' with the var. Thanks. -- --Ricardo Kohler Costa ________________________________________________ Don't E-Mail, ZipMail! http://www.zipmail.com/

3 2

ZCatalog eliminate duplicate
by Andreas Muenster 11 Jun '01

11 Jun '01

Hi everybody ! I just have 2 simple questions: How do I avoid getting duplicate Results in a ZCatalog query like this <dtml-let res="Catalog(body=search_text)+Catalog(PrincipiaSearchSource=search_text)+Ca talog(title=search_text)+Catalog(id=search_text)"> and how can i filter out unauthorized documents: e.g.: <dtml-in res size=50 start=query_start skip_unauthorized> doesnt work if i filter it out with dtml code in the <dtml-in res ...> statement how can I then change the counter ? Otherwise if 49 documents are unauthorized just one will show up. Thx in Advance Andreas Muenster

1 0

DTML abc?
by Arjan de Knegt 10 Jun '01

10 Jun '01

All, I just have a tiny little DTML question that I can't seem to solve: Some of my object ID's contain dot's, e.g. "NicePicture.jpg". Yes, I do know Zope doesn't need (or want?) the use of extension like "jpg" in object ID's , but I have my reasons to do so. Now I simply would like to render this object with dtml-var. Al DTML syntaxes I can think of result in Zope errors, propably because Zope thinks the ".jpg" part is an object method instead of part of the object ID? Can anyone point me in the right direction? Regards, Arjan.

3 3

Re: [Zope] Unique IDs
by Tres Seaver 10 Jun '01

10 Jun '01

> "Daniel Fairs" <daniel.fairs(a)spiderplant.net> >> And additionally - instead of using hashes - >> just to use a timestamp? > > > The key thing I need is unpredictability - hence my originally wanting to > use md5 as the last step in the generation. The 'usual' way to do this is to > seed the random number generator with the current time, pull a number out of > that and then do an md5 on it. I've got a number of options now, I'll look > at them > > However, this doesn't answer the first part of my original question - why is > Zope asking me for further credentials when I try to use the md5 module? I'm > guessing md5 is in the security sin bin along with re and other stuff... but > why md5? It isn't a "sin bin"; TTW-scripting (PythonScripts, and, in 2.4, DTML) have a "deny by default" access policy for Python modules; you can "bless" the md5 module using a "patch-style" product, as described in the PythonScript product's README ('lib/python/Products/PythonScripts/README.txt'). You can use an ExternalMethod, if you prefer not to go this route. Tres. -- =============================================================== Tres Seaver tseaver(a)digicool.com Digital Creations "Zope Dealers" http://www.zope.org

1 0

Re: [Zope] Bug tracking product
by Tres Seaver 10 Jun '01

10 Jun '01

Gitte Wange <gitte(a)mmmanager.org> wrote > I am looking for a bug tracking product for Zope that also can contain > feature requests. Everybody should be able to enter bugs and/or feature > requests. > > Does suck a product exists ? http://www.zope.org/Members/klm/TrackerWiki/FrontPage Tres. -- =============================================================== Tres Seaver tseaver(a)digicool.com Digital Creations "Zope Dealers" http://www.zope.org

1 0

transaction control from Zope to Postgresql?
by Reinoud van Leeuwen 10 Jun '01

10 Jun '01

Hello world, I am in need for a way to explicitely contral transaction behaviour for a group of inserts in a postgresql database. The DTML script I use first inserts a header record and after that some detail records. The postgresql function that does the inserts might return an errorstring. So I tried the following code (simplified for readability) <dtml-try> <dtml-call "sql_to_insert_head_record (some_parameters)"> <dtml-in "a_loop_over_detail_lines"> <dtml-if "check_detail_line"> <dtml-raise required_attribute_missing> errormessage </dtml-raise> </dtml-if> <dtml-call "sql_to_insert_detail_line"> <dtml-if "check_returncode"> <dtml-raise inserterror> error inserting! </dtml-raise> </dtml-if> </dtml-in> <dtml-except> insert failed (error: <dtml-var error_value>) <dtml-else> object added to database </dtml-try> What I would like to do is that all the SQL executed between dtml-try and dtml-except is rolled back when the exception is raised. I tried sending "begin" and "rollback" to the database, but that does not work because Zope sends some transaction control by itself. I tried getting get_transaction().begin() and get_transaction().abort() to work, but I cannot reach that function from dtml not python script. Anyone has some clues to spare? Have a nice weekend, Reinoud

2 1

RE: [Zope] Sharing Database connections and/or methods between Zo pes?
by Schmidt, Allen J. 10 Jun '01

10 Jun '01

Well, with my limited Python, that is easier said than done. Something to shoot for though. Thanks Andy!!! Allen -----Original Message----- From: Andy McKay [mailto:andym@ActiveState.com] Sent: Tuesday, June 05, 2001 1:19 PM To: Schmidt, Allen J.; zope(a)zope.org Subject: Re: [Zope] Sharing Database connections and/or methods between Zopes? Here's how I would do it: Write a python script that calls your SQL and transfer the results into a list of dicts and returns that. You can then call the python script through xml-rpc and can hence parse the results. Cheers. -- Andy McKay. ----- Original Message ----- From: "Schmidt, Allen J." <aschmidt(a)nv.cc.va.us> To: "'Andy McKay'" <andym(a)ActiveState.com>; "Schmidt, Allen J." <aschmidt(a)nv.cc.va.us>; <zope(a)zope.org> Sent: Tuesday, June 05, 2001 10:05 AM Subject: RE: [Zope] Sharing Database connections and/or methods between Zopes? > Don't even care about slow at this point! Just the functionality.... > > So I can assume then that remote access of ZSQL methods is not possible?? > > > Seems like ZEO is the answer for everything! <8^) > > If anyone can think of a reason why this would not work, please drop a note. > If this is considered OT then jsut email me directly. > > -----Original Message----- > From: Andy McKay [mailto:andym@ActiveState.com] > Sent: Tuesday, June 05, 2001 1:09 PM > To: Schmidt, Allen J.; zope(a)zope.org > Subject: Re: [Zope] Sharing Database connections and/or methods between > Zopes? > > > Ah well thats the point of a database of course, is you can share it. You > could concont some other solution with other stuff but you might find it > slow. > > This sound like a perfect job for ZEO. > > Cheers. > -- > Andy McKay. > _______________________________________________ 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 )

2 1

Re: Zope docs (was Re: [Zope] I was wondfe)
by Oliver Bleutgen 10 Jun '01

10 Jun '01

>> > > I think folks need to start becoming more specific when >> > they say "Zope >> > > isn't well documented". > Let me add my own piece... > imho zope is quite well documented. I mean, if you need to find a function > name and it's use, you'll allways find it in a few minutes. If you need a > dtml reference, you'll find it. If you need to learn python, well, buy a > book / see the online site. > Even the zope api is not poorly documented. (just tried docfinder of > Dieter - it's a great tool) > The feeling of people when they say zope is not well documented is > probably > not because there is lack of "traditional" documentation. > What is really needed is implementations examples of canonical problems. I think there are many examples already there, it's just sometimes hard to find them (and to be sure these examples are "done right"). Perhaps we need something like the open directory project (dmoz.org) for some elements of zope documentation. OTOH, perhaps we already have an effort like this with the ZDP. Only - my impression is it doesn't seem to work very well, perhaps it's too ambitious. One thing which I have missed often lately was a more fine grained categorization of the howtos on zope.org similar to that for the products. I just joined zope.org so I'm not clear about whats technically possible with such an account, but if there's need I would look into starting some smallish project that makes it possible for the community to do that on ourselves. But I admit, I think such functionality would better fit as a core component of zope.org, but that would mean work for DC. Also the possibility to comment/rate on products and howtows would be nice, as would be a fulltext search on all howtos. cheers, oliver

1 0

How to remove zope.pcgi from URL (in IIS)?
by Satheesh Babu 10 Jun '01

10 Jun '01

Hello, I'm trying to run Zope behind IIS, in PCGI mode. It works reasonably except that I can never login to management interface. (I can do so by using ZServer directly). However, my current problem is that Zope sites have an URL like http://mysite.com/cgi-bin/zope.pcgi/blahblah Is there a way in IIS to make it look like http://mysite.com/blahblah or even http://mysite.com/biggerblah/blahblah ? So far I was using Apache where this is easy with ProxyPass. Now, (at least for some time) I'm stuck with IIS. I went through the solution where you use a 404.asp page that does some sort of proxying. Any other solutions? We've a big static site served by IIS and some ASP. For the moment, I must use the same server machine for Zope too. And most corporate firewalls block ports other than 80. That is why I'm trying to front end Zope with IIS. Many thanks in advance V. Satheesh Babu http://vsbabu.csoft.net "Power corrupts. PowerPoint corrupts absolutely."

2 1