- Zope - Zope lists

Re: problem with ZODB
by Tres Seaver 09 May '05

09 May '05

JV Singh wrote: > I am using Gadfly. - the one that comes with Zope... For testing whether it > would work or not... OK, I just created a folder, 'gadfly_test', in a Zope 2.7 site, and added a ZGadflyConnection, 'gadfly', using the 'demo' connection. On its "Test" tab, I executed the following: - Create the table create table EMPLOYEE( emp_id varchar(25) , first_name varchar(25) , last_name varchar(25) , salary integer ) - Add a row with no Unicode: insert into EMPLOYEE( emp_id, first_name, last_name, salary ) values( 'aaa', 'J. Random', 'Hacker', 100000) - Add a row with pasted Unicode (note that this is going to get encoded on the way in): insert into EMPLOYEE( emp_id, first_name, last_name, salary ) values( 'bbb', 'Étienne', 'Jones', 100000) - Selected all values: select * from EMPLOYEE - Selected the non-unicode value out successfully: select * from EMPLOYEE where first_name='J. Random' - Selected the value out successfully: select * from EMPLOYEE where first_name='Étienne' (the expected row is returned) I would eliminate the possibility of a Gadfly encoding bug by testing the RDBMS you actually want to use (MySQL, PostgreSQL, etc.). If you can reproduce the problem, including the steps you take and the actual SQL you are using, then submit a collector issue: http://www.zope.org/Collectors/Zope Tres.

1 0

Encoding of the query that zope passed to the RDBMS
by JV Singh 09 May '05

09 May '05

Specifically, how do i make sure that the query that zope passes on to the underlying RDBMS is in utf-8 ?? On 5/9/05, JV Singh <jvsing(a)gmail.com> wrote: > > Thanks for the reply. > I am using Gadfly. - the one that comes with Zope... For testing whether > it would work or not... > > On 5/9/05, Tres Seaver < tseaver(a)palladion.com> wrote: > > > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > JV Singh wrote: > > > > > I have been a silent member of the list mostly.. There is a slight > > problem > > > that needs to be addressed rather urgently... > > > The thing is that though unicode strings can be input and retrieved > > into the > > > database through Zope.. > > > For example, for the table EMPLOYEE<emp_id, first_name, last_name, > > salary> > > > the query select * from EMPLOYEE where emp_id = 3 (some number) works > > > but > > > select * from EMPLOYEE where first_name= 'some unicode string' doesn't > > > > > work... > > > > > > I'd appreciate some input on this.. > > > > First, the Subject: line of your post is misleading: if you are using > > SQL, then the problem is unrelated to ZODB. > > > > You need to verify that whatever underlying RDBMS you are using can > > support the query, first, using its own query interface. Once you know > > what the syntax for that looks like, then work out how to make your > > DTML-based SQL method generate that. > > > > Tres. > > -----BEGIN PGP SIGNATURE----- > > Version: GnuPG v1.2.5 (GNU/Linux) > > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org > > > > iD8DBQFCf0zq+gerLs4ltQ4RAlnkAJ9UZA86AZFlxijpGpSqdDCbj6Wn1ACgmT42 > > N0BzBRjBCWDUBGljFNvs6M0= > > =M+JU > > -----END PGP SIGNATURE----- > > > >

2 1

problem with ZODB
by JV Singh 09 May '05

09 May '05

Hello Everyone.. I have been a silent member of the list mostly.. There is a slight problem that needs to be addressed rather urgently... The thing is that though unicode strings can be input and retrieved into the database through Zope.. For example, for the table EMPLOYEE<emp_id, first_name, last_name, salary> the query select * from EMPLOYEE where emp_id = 3 (some number) works but select * from EMPLOYEE where first_name= 'some unicode string' doesn't work... I'd appreciate some input on this.. --JV.

3 2

Is it possible to extend Zopes WebDAV authentication?
by mark hellewell 08 May '05

08 May '05

Hello! I'd like a little help, please :) I have a site that uses PluggableUserFolders for its acl_users. The web-based portion of the login process locks out a user after 3 unsuccessfull attempts at the password and i'd like to be able to do something similar for users who try to connect via WebDAV. I'm sure something like this should be possible but am uncertain where to begin. Is it possible to override the authentication methods used by WebDAV? If so what are those methods? I'd be grateful for any help and insight into this problem! Many thanks, Mark

5 10

Find a object in a zope list
by Allen Huang 08 May '05

08 May '05

I have a fold and I used objectValues['Image'] to make a array list of images. I have rename each image using AUTHENTICATED_pic.jpg and want to use an if statement to find the image with the same name in the array list. Can someone tell how?? Is there a findObject function or something?? --------------------------------- Yahoo! Mail Stay connected, organized, and protected. Take the tour

3 2

RE: [Zope] RSS feed: post-processing?
by MILLER Eva 07 May '05

07 May '05

Hi, OK, let me see if I can do that... I've already figured out that a python script/external method solution is what I'm after. But how to make it work? Anyone know about Greasemonkey in Firefox? Basically, it embeds a handy link in Web pages that have ISBN numbers in them (unique identifier for a book). When you configure Greasemonkey right, it checks for the book in your local catalog and returns a link to that book in your local library catalog. The trick is to use the same idea, but inside of Plone with an RSS feed that displays current bestsellers or other book-related stuff where there's an ISBN included. Here's the sort of python script I need, to the best of my knowledge, though the first function I can't use (it checks against an Amazon Wishlist--I don't want anything to be dependent on Amazon or a particular browser). Jon Udell provided it, and he's the one who wrote the LibraryLookup bookmarklet that does something similar to what I want: import amazon, re, urllib2 wishes = amazon.searchByWishlist('BNQ1T3SLPJS7'); def rss( items ): return """<rss version="0.91"> <channel> <title>LibraryLookup reminders</title> <link>http://www.amazon.com</link> <description>Remind me when books on my Amazon wishlist become available at the library</description> %s </channel> </rss> """ % items def isAvailable ( isbn ): url = 'http://ksclib.keene.edu/search/i=%s' % isbn page = urllib2.urlopen(url).read() return re.search ( 'AVAILABLE', page ) is not None items = '' for wish in wishes: isbn = wish.Asin if ( ( re.match( '\d{7,9}[\d|X]', isbn ) is not None) and isAvailable(isbn) ): items += """ <item> <title>%s</title> <link>%s</link> <description>%s</description> </item>\n """ % ( wish.ProductName, wish.URL, wish.Authors.Author ) output = rss ( items ) name = 'libraryReminders.xml' f = open(name,'w') f.write(output) f.close() -------------------------------------------------------- So, I need to simplify this script (get rid of the wishlist stuff), create an external method for it, then figure out how to get the template in CMFSin to call the external method. I've never done any of this before (which probably explains why I have a hard time describing my problem better). The CMFSin template I need to alter looks like this, and I'm not sure exactly where or how to call the method: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-US" lang="en-US" metal:use-macro="here/main_template/macros/master" i18n:domain="plone"> <metal:block fill-slot="base"> <tal:block tal:define="dummy python:request.set('disable_border', 1)" tal:replace="nothing"> Disable the tabs </tal:block> </metal:block> <div metal:fill-slot="main" tal:define="true python: 1; false python: 0; verbose python: 1; sin here/sin_tool; m request/synmap; results python:sin.sin(m); Batch python:modules['Products.CMFPlone'].Batch; b_start python:request.get('b_start',0); "> <div class="contentHeader"> <h1 tal:content="m">Title or id</h1> </div> <tal:block tal:define="batch python:Batch(results, 15, int(b_start), orphan=1)">  <div metal:use-macro="here/batch_macros/macros/navigation" /> <dl tal:repeat="obj batch"> <dt><a href="#" tal:attributes="href obj/link" tal:content="structure obj/title"/>  <span tal:condition="python: obj.get('date') or nothing" tal:content="python: (obj['date'])"/></dt> <dd><span tal:condition="python: verbose and obj.get('description') or nothing" tal:replace="structure obj/description"/>  </dd> </dl>  <div metal:use-macro="here/batch_macros/macros/navigation" /> </tal:block> <p tal:condition="not: results" i18n:translate="description_no_items_in_feed"> There are currently no items in this feed. </p> </div> </html> -----Original Message----- From: Chris Withers [mailto:chris@simplistix.co.uk] Sent: Monday, April 04, 2005 6:12 AM To: MILLER Eva Cc: zope(a)zope.org Subject: Re: [Zope] RSS feed: post-processing? Sorry Eva, You'll need to explain your problem more succintly for people to be able to help. If you really do need to scrape the urls from the text, then a combination of python's xml handling and regular expressions is probably what you're after, best done in an external method and not a python script... cheers, Chris MILLER Eva wrote: > Hello, > > I've been puzzling over something but can't figure out a solution. I > have an RSS feed providing the content behind all the links on this > page: http://demo.plinkit.org/interestsideas/goodreads/booklists. > > There's a nice bookmarklet tool in the world called LibraryLookup that > lets you check whether a book you find on Amazon or something is in > your library's catalog by scraping up the ISBN and launching an ISBN > catalog search. It's a javascript, really. I thought I would adapt this > > to create a little add-on for the stuff the bestsellers RSS brings > back > > to my site. What I need to do is pluck out the ISBNs in the links on a > page like this one: > http://demo.plinkit.org/interestsideas/goodreads/sinList?synmap=Hardcove > rFiction > > The ISBNs are all in the URLs for the book titles > ("isbn=Some10digitNumberHere"). How would I look for a piece of text in > > that shape, i.e., isbn=5893193390, then, if it's there, copy and paste > that piece of information into the LibraryLookup javascript I have. The > > end result should be that, if there's an ISBN in a feed result, an > extra link > appears for each entry that says something like "Check the catalog," > which you can click to look that book up in your own library's catalog. > > I've been staring at the template that formats the RSS feed to figure > out whether any TAL expression would work for this. I've been playing > with a short Python script, then wondering how to call it within that > template, but I think I have to use regular expressions to do it. > > I'm sorry to be so lost on this, but I guess I am. I'd love to do > something cool like this for our little Plinkit libraries. Can anyone > help? I'll take anything from a broad strategy to actual code snippets > (I'm a terrible programmer but a good librarian). > > Thanks > Eva the Librarian > > > > ---------------------------------------------------------------------- > -- > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk

2 1

A memory leak in Zope, PageTemplateFile and macros?
by Marco Bizzarri 07 May '05

07 May '05

Hi all. While debugging an application of us I suspected we had a memory leak, so I started with the usual divide et impera approach, trying to figure where exactly was the problem. I therefore started removing all code from inside the main templates in our system, so that I could figure where the problem was. The surprise was that even if I removed all the code, still I was able to see the memory footprint of the zope server raise as new requests arrived. I'm using ab from Apache project to test. I've devised a very simple product which shows the problem, which I include. I tested this with python 2.3.4 and Zope 2.7.6 Test string was: ab2 -A admin:admin -n 100 http://localhost:8080/LeakPT1/start_html Regards Marco

2 3

Security framework troubles
by Anders Bruun Olsen 07 May '05

07 May '05

Hi, I am attempting to make a zope product (a custom book-database for use by my employer) and of course want to secure it. I have added this code to my class: security = ClassSecurityInfo() security.setDefaultAccess("deny") security.declareProtected("View Bookbase", "index_html") security.declareProtected("View Bookbase", "standard_page") security.declareProtected("View management screens", "manage_main") And also of course InitializeClass(Bookbase) When the template tries to access container/title an access denied expection is raised. With VerboseSecurity I get this explanaition: Unauthorized: The container has no security assertions. Access to 'title' of (Bookbase at /bookbase) denied. What exactly am I missing here? It works if I do setDefaultAccess("allow"), but I don't want to allow access by default and then just deny for those I know I want to deny access to. I want it the other way around. -- Anders -----BEGIN GEEK CODE BLOCK----- Version: 3.12 GCS/O d--@ s:+ a-- C++ UL+++$ P++ L+++ E- W+ N(+) o K? w O-- M- V PS+ PE@ Y+ PGP+ t 5 X R+ tv+ b++ DI+++ D+ G e- h !r y? ------END GEEK CODE BLOCK------ PGPKey: http://random.sks.keyserver.penguin.de:11371/pks/lookup?op=get&search=0xD4D…

3 2

Debugging product init with zopectl?
by Konrad Rokicki 07 May '05

07 May '05

Hi all, I'm new to Zope, getting started with the "minimal" project (http://www.zope.org/Members/maxm/HowTo/minimal_01) For whatever reason, minimal doesn't work out of the box. That would be fine except that when I start Zope with zopectl it reports status as fine and the process runs, but I don't get any logs generated and I can't connect to the server. But, if I use runzope I can see what's wrong and the server dies immediately: File "/var/lib/zope/zope-test/Products/minimal/__init__.py", line 8, in initialize constructors = ( AttributeError: manage_addMinimalForm My concern isn't this error, which I fixed by importing the function explicitly. But why did I have to use runzope to see this? Shouldn't zopectl inform me that the server is completely broken? By the way, I'm using a standard Gentoo installation of Zope, and I haven't changed any options from defaults. Could someone please tell me if this is expected behavior? Should I be using runzope in a screen or something? Thanks, Konrad

5 5

utf-8 vs. unicode question(s)
by Jürgen Herrmann 07 May '05

07 May '05

hi out there! there's been some discussion about utf-8 vs. unicode strings on the list lately. i'd like to ask if my gained understandings are correct und thus possibly make it clear to others also. i have set my python default encoding to utf-8, i always send http responses from zope as utf-8 (by setting the header like this: tal:define="dummy python:request.RESPONSE.\ setHeader('Content-Type','text/html;; charset=utf-8')" ) so if i'd like to use unicode strings in my zope applications, it's still necessary to convert request variables to unicode by using unicode(REQUEST.foo, 'utf-8'), right? as far as i understodd, the conversion back to utf-8 is handled automagically by zope (if the abovementioned header is set), also correct? thanks in advance for your answers! regards, juergen herrmann _______________________________________________________________________ >> XLhost.de - eXperts in Linux hosting << Juergen Herrmann Weiherweg 10, 93051 Regensburg, Germany Fon: +49 (0)700 XLHOSTDE [0700 95467833] Fax: +49 (0)721 151 463027 ICQ: 27139974 - IRC: #XLhost@quakenet WEB: http://www.XLhost.de

3 2