February 2001 - Zope

DCOracle and chars over 128
by Shai Berger 22 Feb '01

22 Feb '01

Hi, I have been too busy to actually read the list in the last two weeks, but I thought I'd share with you my latest finding about ZOracleDA/DCOracle: In some circumstances (we suspect the LANG setting at the time of build) it chops 128 (the most significant bit) off characters inserted into the database as strings. In our case, it turned a  (trademark) character into a  (sometimes reported as ^Y). Since the latter is not a valid character in many sets, this caused severe problems in our related systems. We also had not-so-severe problems with ® (registered trademark, I think) turning into . ("."), because the latter is a common printable. We have two very similar installations of Zope with Oracle, one of them displayed this malicious behaviour, and the other didn't. As far as we could see, the only difference between the two is that in the computer which does modify characters users get (by default) a LANG=POSIX, and on the well-behaved one LANG=en_US. Oh, of course, the details: Zope 2.2.5 binary, ZOracleDA 2.1, DCOracle 1.3.2, Oracle 8.0.5, Linux. (Please cc me on replies; as I said, I don't really read the list very attentively these days). Have fun, Shai.

1 0

URL based access (was: [Zope] <dtml-if> question)
by Dieter Maurer 22 Feb '01

22 Feb '01

Hans de Wit writes: > .... > <dtml-let foto="'/Cis/fotos/afoto.jpg'"> > > <dtml-if expr="_.getitem('foto')"> Keep in mind: You cannot use URL-strings to access objects, neither as DTML name nor as parameter to "getitem"! In both contexts, they will be interpreted as an atomic name. Whenever you want to access an object through an URL, you will use "restrictedTraverse" (if the URL describes a physical path) or "REQUEST.resolve_url" (for virtual URL's). With these remarks, you can use: <dtml-if "_.hasattr(restrictedTraverse('/Cis/fotos'),'afoto.jpg')"> Dieter

1 0

Re: [Zope] devel/production syncronization
by Dieter Maurer 22 Feb '01

22 Feb '01

Gary Lowder writes: > .... The ZCVSMixin might help you. Dieter

1 0

Re: [Zope] Problem using AUTHENTICATED_USER
by Dieter Maurer 22 Feb '01

22 Feb '01

=?iso-8859-1?q?J=E9r=F4me=20Loisel?= writes: > I am somewhat unable to check whether or not the user has manager access to > some object object. The following does not work as expected: > > <dtml-if "AUTHENTICATED_USER.has_role('Manager', _.getitem('.news'))"> > <P>Blah.</P> > </dtml-if> > > Instead of getting a true result if the user has manager acces to the .news > item (a folder), I get a true result if the user has manager access to his > context. I do not understand what "his context" means. Nevertheless, I will make some remarks. Perhaps, they are of help: * "has_roles(roles,object)" will return "true", when the user globally has one of the roles in "roles" * it will return "true", when the user has one of the roles as a local role in an ancestor of "object" * There might be a bug in "AccessControl.User.User.getRolesInContext": the "__ac_local_roles__" are not looked up in the object itself but in its "aq_inner" (if it exists). I am not sure, however, whether this makes a difference, probably not. > Related question: How do I access AUTHENTICATED_USER from Python? AUTHENTICATED_USER is a REQUEST member. Depending in what kind of Python you are, you could use something like: self.REQUEST.AUTHENTICATED_USER (External Method) or context.REQUEST.AUTHENTICATED_USER (Python Script) or REQUEST.AUTHENTICATED_USER (if REQUEST passed as parameter) Dieter

1 0

Dtml doc or Zclass? [newbie]
by Philippe J 22 Feb '01

22 Feb '01

Hello, (I'm still looking for some good docs about zope way of thinking. The zope book is great btw) Let's imagine I'd like to add a keywords property to every dtml documents I have in my site. Do I need to add some "keywords" property to each dtml document I have? Shouldn't it be better to first create a zclass based on a dtml doc with this property already defined (with default values for example), and use this in place of the standard dtml docs. This may be problem as the site would not be standard. I'd like to still have standard dtml docs with added properties. Can I create a special management screen in order to let managers create new docs and edit existing ones? Is it needed? Or am I missing something with dtml-doc? It is quite important, because I want to make the work well at the beginning, else it will be a pain to change every doc because I didn't plan enough. Sorry for the simple question, if anyone could answer and point me to the right docs... Thanks ! Philippe Jadin

1 0

Re: [Zope] DTML and Lists
by Dieter Maurer 22 Feb '01

22 Feb '01

Leonardo Mota writes: > I'd pretty much a newbie at Zope and running into some problems. I > have to make a <dtml-tree> with it's branches being fetched from a > database, that's already done but I also need to carry a variable with > the whole hierarchy to the last leaf of the tree. Are you sure, you need this? It is somewhat against the philosophy of the tree tag. > ... > Reading <dtml-tree>'s docs I've found a list that carries what I > want, "tree-state", but I have no idea on how to access list's members > on DTML. I've tried <dtml-var tree-state[0]> with no success. "tree-state" is a sequence. Thus, in principle, you can access it with the subscription syntax. However, subscription will only work inside Python expressions. As you use it, the "[0]" will be interpreted as part of the single name "tree-state[0]". Try <dtml-var expr="_['tree-state'][0]"> Be warned however, the structure is quite complex. Personally, I was not yet able to understand it. Dieter

1 0

ZCatalog Highlights for Zope 2.3
by Chris Withers 22 Feb '01

22 Feb '01

This documents: http://www.zope.org/Members/Caseman/ZCatalog_for_2.3 ...is really handy for finding out the cool new featrues of ZCatalog in Zope 2.3 Many thanks to Caseman :-) Chris

2 1

What's involved in writing a DA (for Ingres)?
by Hamish Lawson 22 Feb '01

22 Feb '01

I'd like to have a Zope DA for Ingres II (on Solaris), and since I haven't come across an existing one, I'm thinking of attempting to write my own (!), building it on top of a DB-API-compliant Python module for Ingres that I've got hold of. I've grabbed the "How to Write a DA" document; is there anything else that would be useful? Are there any particular existing DAs that it would be worthwhile to look at for guidance? Hamish Lawson ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie

2 1

Re: [Zope] mozilla (was KDE's Konqueror)
by Andrew Williams 22 Feb '01

22 Feb '01

>> it runs much faster than before. I'm really looking >>forward to the >>.9 and >> 1.0 releases. Hear, hear to the mozilla team. > >0.8 is faster compared to .7, or even netscape6.x >however, back button dont work (in zope management >interface). and >copy/paste works when it wants to work. dang. >is it just me? No, it is not just you. I have had pretty good luck with .6 albeit a little slow opening/closing. Mozilla .7 runs *much* faster, but I've also been having problems with the "back" button, and not just in the Zope management screens. One other thing I've noticed is that when copy/paste does work, it doesn't keep any of the formatting (I love indented code). Really really aggravating. So... at home I use IE 5.0 on my home pc and at work I use Mozilla .8 on my laptop. Andrew ___________________________________________________________________________ Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot.

2 1

RE: [Zope] quick question - database connections in python methods & return types?
by Randall F. Kern 22 Feb '01

22 Feb '01

The query result is a tuple, with two items. The first item in the tuple is a list of dictionaries, which describe each column. These dictionaries have values for 'name', 'type', 'null', and 'width'. These values came from MySQL, as meta-information about the query results. The second item in the outermost tuple contains the actual data. This is a list of rows, each row is a tuple that has a value for each column, in the same order as the column description dictionaries. So yes, the result is a combination of tuple, list, and dictionary. If these types are confusing, I would suggest reading some of the material on www.python.org. Sample query result: id | title ----|--------- 1 | john 2 | greg Written in python as a "result object": result = ( [ {'name': 'id', 'type': 'NUMBER', 'null': 'NOT NULL', 'width': 4}, {'name': 'title', 'type': 'STRING', 'null': 'NOT NULL', 'width': -1} ], [ (1, 'john'), (2, 'greg') ] ) -Randy > -----Original Message----- > From: Lee [mailto:lee.reilly@ntlworld.com] > Sent: Wednesday, February 21, 2001 4:26 PM > To: zope(a)zope.org > Subject: [Zope] quick question - database connections in > python methods > & return types? > > > Hi there, > > I have a quick question that I need answered concerning the > return types > of SQL queries executed in Python methods. > > I am querying/updating a database using Python methods as follows: > > -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ > # make a database connection string > try: > db_conn = self.MySQL_database_connection() > except Exception: > return "A connection to the database could not be made. <a > href='./'> > Recover</a>." > > try: > SQL = "some SELECT query" > result=db_conn.query(SQL) > except Exception: > return "The class could not be created.<a href='./'> Recover</a>." > -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ > > When this is executed and I "return result[1]" it outputs the > data in a > format like: > > [(1, 16, 9, 1)] > > * return result[0] gives me: > [{'name': 'PRACTICALS', 'type': 's', 'null': None, 'width': None}, > {'name': 'TUTORIALS', 'type': 's', 'null': None, 'width': None}, > {'name': 'ASSIGNMENTS', 'type': 's', 'null': None, 'width': None}, > {'name': 'BONUS', 'type': 's', 'null': None, 'width': None}] > > - the exact details aren't neccessary here I think. At first I had > problems trying to use this data i.e. parse it an store it in > an array, > list, etc. but I overcome that by by first converting "result" to a > string using `result[1]`. > > I was just wondering how to classify the original return type? It is > *not* a list, tuple, array or combination of either so what is it? > > I'm writing a report on my project you see and I can't say that my > method returns an *cough* *cough* value ;-) > > Thanks very much in advance if you can help. > > Cheers, > > Lee > > > _______________________________________________ > 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