March 2000 - Zope - Zope lists

Re: [Zope] Zope hanging: internal ZODB error?
by Michel Pelletier 24 Mar '00

24 Mar '00

Please continue to CC the list on this thread. Darran Edmundson wrote: > > Thanks for the prompt response Michel. > > >Update your Catalog and this will go away. > > Currently I don't have root access to the Zope > machine and can't kill a runaway process - so if > it's Friday evening and Zope needs a reboot, I'm > stuffed until Monday morning. Needless to say, > I took your advice with great trepidation - and > it worked :-) > > Is the problem here that my publicationCatalog > was out of synch with the ZODB? No. > I really need > to know why this happened to avoid it in > future. So do I. Several people have reported this bug, but I cannot reproduce it. No one has been able to reproduce it or tell me how to reproduce it, therefore, I cannot fix it. The only thing I can tell you is that it has to do with ZClasses that catalog themselves and that it happens rarely and that updating your catalog allways fixes it. I suspect it has to do with poorly engineered ZClasses. > I don't dare execute the dtml below > again out of work hours when I can ask the sysadmin > for a restart. I'll try it again Monday and > report back. > > >> <dtml-with jdl124> > >> <dtml-with publications> > >> <dtml-in "objectValues()"> > >> <dtml-var id> > >> </dtml-in> > >> </dtml-with> > >> </dtml-with> > > > >Hmmm... where is this method? Is it in jd1124? > > Which method? The method that contains this code. You are probably experiencing some sort of infinite loop. -Michel

2 2

ZCrawler?
by Michael Sanborn 24 Mar '00

24 Mar '00

Does anyone know whether there's a Zope product or combination of products that could be used to create a full text search index on a given category of the Open Directory Project (ODP/DMOZ)? Say, if I have a web site dedicated to Garden Gnomes, is there some way that I could index every site listed in the Garden Gnomes category at ODP and provide a search interface for my visitors? I suppose I could settle for what ODP does already, but text searching would be cooler.

1 0

Fw: [Zope] How can I get the fieldname in a dtml-in sqlquery tag
by Jim Sanford 24 Mar '00

24 Mar '00

I use an external python function to return the SQL result set. here it is: ( I reference it as an external method called getRes in Zope) --------------------------------------- def doPySQL(self, zQry) : tvar1 = 'res=self.'+zQry exec tvar1 return res._schema.items() ---------------------------------------- This function returns a set of key/value pairs that are the column_name/column number Here is the dtml document I used for testing: (UserSettings returns info for a user) ------------------------- <html><head><title>Test</title></head><body> <dtml-with "_.namespace(t1=getRes('Your_Query_Name_Here()'))"> <dtml-var "_.len(t1)"> Columns <dtml-var "_.str(t1)" html_quote> <dtml-in t1> <dtml-var "_.str(_['sequence-key'])"> = <dtml-var "_.str(_['sequence-item'])"> </dtml-in> </dtml-with> </body></html> ______________________________ This code will give you a listing of column names and values sorted by column name for every record returned by the SQL Query: -------------------------- <html><head><title>Test</title></head><body> <dtml-with "_.namespace(t1=Your_Query_Name_Here(),t2=getRes('Your_Query_Name_Here()'))"> <hr> <dtml-in t1> <dtml-in t2 sort=sequence-item> <dtml-var "_['sequence-key']"> = <dtml-var "_.getitem(_['sequence-key'])" html_quote> </dtml-in><hr> </dtml-in> </dtml-with> </body></html> __________________________________________________________________ Jim Sanford . Database Engineer / \ / Accelerated Technology, Inc. / / 720 Oak Circle Drive East / / \ Mobile, AL 36609 / / \ Voice: 334-661-5770 fax: 334-661-5788 / \ E-Mail: jsanford(a)atinucleus.com Web: http://www.atinucleus.com Nucleus. All You NEED in an RTOS. Royalty Free __________________________________________________________________ ----- Original Message ----- From: jens ebaer <jensebaer(a)hotmail.com> To: <zope(a)zope.org> Sent: Friday, March 24, 2000 11:04 AM Subject: [Zope] How can I get the fieldname in a dtml-in sqlquery tag Hello all I have the problem that i want to get the fieldnames of database. code is like this <dtml-in sqlquery> Here i want to read out the fieldnames (colums) </dtml-in> -------------------------------------------------------------------- database: Fieldnames: Name Age Birthday ....... <- how can get the fieldnames? Peter 21 1979 ........ -------------------------------------------------------------------- maybe that doesn´t work with the dtml-in tag but maybe someone know a simple solution. Thank you Jens ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com _______________________________________________ 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

Printing system in Zope
by Jason Spisak 24 Mar '00

24 Mar '00

Felipe, i had the ned for this too at the start of my current project. I actually have the fortune of having a smart printer. If I shoot a pdf via lpr, it just prints it. It's an HP 4050. lpr -P HP4050_raw myfile.pdf works fine. So I was just writing an external method to slap that document to my printer. But I stopped thinking about this because we decided online delivery of all documents was okay and other things took priority. If you wanted to print more than just plain text, I guess the mime type would have to have a "printer" application sort of, or filter just like they have "viewers". -- Jason Spisak 444(a)hiretechs.com

1 0

Clever about object updating
by Jason Spisak 24 Mar '00

24 Mar '00

Michel, > Do some benchmarks, ZODB is very fast if you are a little more clever > about how you change your objects. Is there a place where we developers can learn what "clever" means in this regard. I would love to know what i can do as a developer to gain speed when changing my objects. What are some of the secrets? All my best, -- Jason Spisak 444(a)hiretechs.com -- Jason Spisak 444(a)hiretechs.com

1 0

Newbie question: using backing files.
by Michael T. Richter 24 Mar '00

24 Mar '00

I have a situation where there are some HTML files which I do not control that I would like to open up to access through my Zope server. I don't want to import these HTML files as Zope objects because these files will frequently be edited and updated in place and I want any changes made to these HTML sources to be immediately reflected in Zope as they occur. I also don't want to just use a URL to access them because a) the end-users shouldn't be aware that they're exiting Zope scope for these items and b) no URL could possibly point to these files since they're actually stored in a revision control system through a "view" (in essence, a virtual local directory tree). So what this basically boils down to is this: I'd like to take a URL like this... http://my.intranet.site/Documentation/ComponentSpecs/MyComponent.html ...and have the logic behind it conform roughly to the following pseudocode: 1. Switch to "/viewdir/source/component/MyComponent/doc". 2. Open the file "ComponentSpec.html". 3. Serve up the contents of that file to the user. The user should see no visible signs that the data comes from outside of the Zope environment. I've already investigated using an external method to accomplish some of this. For example I served up an outside file in almost exactly the way I wanted to accomplish this using code like the following: def testMethod(): s = "" f = open("/viewdir/[...]/ComponentSpec.html", "r") for l in f.readlines(): s = s + l[:-1] return s Indeed this does EXACTLY what I want. (In any production version of this--this was only a quick'n'dirty hack--I'd be doing some significant caching and version checking. But the example gets the drift across.) The only problem is that I can't figure out how to translate a URL like the one I provided above into a method call like testMethod("MyComponent"). (The documentation on these things is a bit... spare.) So does anybody out there have any suggestions? I'm not afraid to get my hands dirty with Python (it being my scripting language of choice for the past 4+ years) and I'm not afraid to learn Stupid DTML Tricks. I just don't know enough Zope yet to even be dangerous.

2 1

PropertySheets again (QUEST)
by Oscar Picasso 24 Mar '00

24 Mar '00

Hi, As I didn't receive any answer from my previous message, I guess it wasn't very clear. How can I get a list of property.ids, property.types of a ZClass propertysheet from outside the product containing my ZClass. I tried a lot of things but i hit a wall. Thanks

1 0

Re: OFF TOPIC: printing learning python e-matter
by David Ascher 24 Mar '00

24 Mar '00

> I intend to get from fatbrain the e-matter edition of the Learning Python > book. Can someone comment their experience with this format? > > The problem is that they mention that e-matter works only on windows > platforms, and I want to know if it is possible to print the book so that > I can use it while working my computer, which does not run windows. I haven't bought the eMatter edition of Learning Python =), but I did by the Eff-bot's guide. I was able to print it fine, although personally I prefer nicely bound books to large amounts of single-sided A4/letter pages with too much whitespace around the borders. Also, know that some folks have had problems with eMatter's distribution schemes, especially those with non-US installations of Windows, from what I gather. Luckily, I hear that fatbrain's technical support helps folks get past these issues. On the positive side, I do like the ability to search PDF files. --David Ascher PS: Even more off-topic, and shameless promotion: Learning Python is now available in German (Einf\"uhrung in Python) and French (Introduction \'a Python). ObZope: Overheard at the SD2000 conference: """I figure that learning about Python and Zope has already paid for the conference. We were going to buy product X, which costs $10,000, and now I learned about Zope, which is free. It cost my company $10,000 to send me and my buddy here, so they're coming out even."""

1 0

Printing from Zope
by Felipe E. Barousse Boue 24 Mar '00

24 Mar '00

Hello all: Not sure if this has been asked before, probably yes, but haven't been able to find anything yet. Does any of you has been able to print from a Zope application to a printer attached to the same machine where Zope is running, in my case it's a Red Hat Linux 6.1 box. I need to print from Zope with a specific printing format (like invoices, receipts, etc). This will be done on always the same Intranet and printing will be controlled from the Linux spooling system. If you can copy your comments to me by email besides the mail list, it'd be great. ,Any help is appreciated, thanks in advance. Felipe Barousse

8 8

How can I get the fieldname in a dtml-in sqlquery tag
by jens ebaer 24 Mar '00

24 Mar '00

Hello all I have the problem that i want to get the fieldnames of database. code is like this <dtml-in sqlquery> Here i want to read out the fieldnames (colums) </dtml-in> -------------------------------------------------------------------- database: Fieldnames: Name Age Birthday ....... <- how can get the fieldnames? Peter 21 1979 ........ -------------------------------------------------------------------- maybe that doesn´t work with the dtml-in tag but maybe someone know a simple solution. Thank you Jens ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0