- Zope-Dev - Zope lists

Properties in DTML Document
by Ze Octavio 05 Mar '99

05 Mar '99

Hello Zopians, I updated my version of Zope and have a nice surprise, the DTML Document ! Thanxs very much Zope's developers for this new fearture. When I saw that fearture I started to change my project, I had to migrate the properties from folders to new DTML Documents, ok, no problem. But I had one new problem. I have to call an lines property from a DTML Document but I am having an error and I already tried to fix that problem but was not sucessfull. Lets see the code (the part with problem):  <select name="myselect">   'Here is a Property from an atual folder 'Here I split a string from pr_days <OPTION VALUE="" 'Here is the problem SELECTED  >    </select>  pr_months is a lines Property in 2000.htm DTML Document but is not working. The error message is:  Somedoby have an idea ? Thanxs ! Ze Octavio

2 2

External method pulling data from an SQL method?
by julian＠zereau.net 05 Mar '99

05 Mar '99

I am using PostgreSQL's array system for a "categories" field in a database, it return records in a format like: '{"foo"}' '{"foo","bar"}' '{"foo"}' I am trying to extract the list of unique categories - in this example: ["foo","bar"] This would be a complete nuisance to do in DTML. I have decided to read the SQL method's results into an external method and edit them there - but first I need to know how to call a SQL method without the "in" DTML tag. Or maybe there is a simpler solution to all this, for any PostgreSQL gurus out there?? --- Julian Morrison Programmer (Zereau Ltd)

2 1

RE: [Zope-dev] External method pulling data from an SQL method?
by Michel Pelletier 05 Mar '99

05 Mar '99

> -----Original Message----- > From: julian(a)zereau.net [mailto:julian@zereau.net] > Sent: Friday, March 05, 1999 9:31 AM > To: zope-dev(a)zope.org > Subject: [Zope-dev] External method pulling data from an SQL method? > > > I am using PostgreSQL's array system for a "categories" field > in a database, it > return records in a format like: > '{"foo"}' > '{"foo","bar"}' > '{"foo"}' > > I am trying to extract the list of unique categories - in > this example: > ["foo","bar"] > > This would be a complete nuisance to do in DTML. I have > decided to read the SQL > method's results into an external method and edit them there > - but first I need > to know how to call a SQL method without the "in" DTML tag. > An SQL method is like any other method. If you want to call it from an external method, you could try this: <untested>  ... def myExternalMethod(self): self.mySQLMethod() </untested> This is just a sketch, but I hope you get the idea. You don't need the #in tag to call an SQL method, you can even call it with a #var tag, if you don't mind the output. -Michel > Or maybe there is a simpler solution to all this, for any > PostgreSQL gurus out > there?? > > --- > Julian Morrison > Programmer (Zereau Ltd) > > _______________________________________________ > Zope-Dev maillist - Zope-Dev(a)zope.org > http://www.zope.org/mailman/listinfo/zope-dev >

1 0

RE: [Zope-dev] Programmatically accessing Z SQL Methods
by Paul Everitt 05 Mar '99

05 Mar '99

Mike wrote: > myself having trouble getting started. Here's a deal: If I > get a boost up the > learning curve with a few answers, I'll put it in a How-To > once I understand > it all. Instead of answering the question (which with my IQ would be something like, "use a crescent wrench"), I'll instead suggest a counter-deal with the ZDP crowd. As you guys start moving over the ground of filling in the gaping holes in the Zope docs, you'll come up with things you can answer and things you can't. The lack of a Product API reference doc is a perfect example. I propose that you guys go ahead an collect the questions and then once a week I'll get some time from the folks here to answer the questions. Thoughts? --Paul

2 1

Mea Culpa!
by Tres Seaver 05 Mar '99

05 Mar '99

Aiyah! <sound of gnashing teeth> I got too quick on the trigger, and sent my reply to Joe VanAndel's post without editing the digest title. Tres.

1 0

Re: Zope-Dev digest, Vol 1 #2 - 8 msgs
by Tres Seaver 05 Mar '99

05 Mar '99

> Message: 2 > To: zope-dev(a)zope.org, amos(a)aracnet.com > Subject: [Zope-dev] bug: ZOPE FAQ product failing on starship.python.net > Reply-To: vanandel(a)ucar.edu > Date: Thu, 04 Mar 1999 08:59:40 -0700 > From: Joe Van Andel <vanandel(a)atd.ucar.edu> > > I'm trying to use the FAQ module to build a FAQ area for Numeric > Python. starship.python.net is running Zope-1.10.2 . > > I've simply created a few categories and sample FAQs, for testing. The > last thing I did was to create a 'faqmaster' user, so I could let NumPy > email list subscribers add/edit FAQ entries. But now, the FAQ module > seems broken (see below for details) > > Any ideas on how to fix this? > > Right now, the URL > http://starship.python.net:9673/crew/vanandel/NumPy/ > > yields "System Unavailable", with a backtrace of: > > Error type: > Error value: isCategory > > traceback (innermost last): > File /home/zope/Zope-1.10.2-src/lib/python/ZPublisher/Publish.py, line 877, in publish_module > File /home/zope/Zope-1.10.2-src/lib/python/ZPublisher/Publish.py, line 590, in publish > (Info: crew/vanandel/NumPy/) > File /home/zope/Zope-1.10.2-src/lib/python/OFS/DTMLMethod.py, line 155, in __call__ > (Object: index_html) > File /home/zope/Zope-1.10.2-src/lib/python/OFS/DTMLMethod.py, line 151, in __call__ > (Object: index_html) > File /home/zope/Zope-1.10.2-src/lib/python/DocumentTemplate/DT_String.py, line 513, in __call__ > (Object: index_html) > File /home/zope/Zope-1.10.2-src/lib/python/TreeDisplay/TreeTag.py, line 154, in render > (Object: a tree tag) > File /home/zope/Zope-1.10.2-src/lib/python/TreeDisplay/TreeTag.py, line 244, in tpRender > (Object: Navigation) > File /home/zope/Zope-1.10.2-src/lib/python/TreeDisplay/TreeTag.py, line 331, in tpRenderTABLE > (Object: Navigation) > AttributeError: (see above) > You are not alone -- I had to back out the UserFolder / security on my FAQ object on starship, too. -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

1 0

Re: [Zope] special characters
by John Eikenberry 04 Mar '99

04 Mar '99

On Thu, 4 Mar 1999, John Eikenberry wrote: > This leads to a followup question/request for the group. > > 'manage_addProperty' calls various converters from ZPublisher.Converters > to format the properties values. Shouldn't html_quote be used when > formatting strings and text? This would be trivial to change. Would this > cause some problem I don't realize? If not, I'd like to add this to the > Collector for the next version. (Switched over to zope-dev to reply to myself.) After a bit more digging, I found some weirdness in Zope/lib/python/OFS/properties.dtml  <input type="text" name=":" size="35" value="">  <input type="text" name=":string" size="35" value=""> 'string' is in the first list, this is probably a bug considering it has its own #elif and this case does the correct formatting. The 'text' type don't have the html_quote format thought, and they probably should to. So, is it's probably better to format this stuff here (on the way to the display) rather than on the way to storage. I'll probably enter this one in the Collector. I'll test it a bit first. --- John Eikenberry [jae(a)kavi.com - http://taos.kavi.com/~jae/] ______________________________________________________________ "A society that will trade a little liberty for a little order will deserve neither and lose both." --B. Franklin

1 0

Programmatically accessing Z SQL Methods
by Mike Pelletier 04 Mar '99

04 Mar '99

I've got a pretty solid understanding of how to get around Zope from the Product API point of view, and there is good documentation on using Z SQL Methods from the DTML point of view. I'm finding myself in the grey overlapping area, and there isn't a lot of documentation yet. I'm finding myself having trouble getting started. Here's a deal: If I get a boost up the learning curve with a few answers, I'll put it in a How-To once I understand it all. I would like the user to select the Database Connection when my Product is being added. When the Product installs itself, I want it to check the database it's been passed for the existance of a particular table. If it does not exist, I want to create said table and do some initial populating. So far my scheme for doing this involves adding a Z SQL Method to the current folder, putting some SQL in it, running it, putting some SQL in it, running it, etc, etc, and then removing it when I'm done. This seems like a stupid way to go about things. I'd much rather just be able to take my connection and submit some SQL programmatically. So, I guess question is simply, "How do I submit an SQL query, starting from a connection_id?" Thanks, Mike. -- --- | Mike Pelletier Work: 519-746-1607 /opeware! | Software Developer Home: 519-725-7710 --- | mike(a)zopeware.com Fax: 519-746-7566 http://www.zopeware.com | Zopeware is not endorsed by Digital Creations

2 1

Re: [Zope-dev] FAQ Submission
by Philip Aylesworth 04 Mar '99

04 Mar '99

>Michel's use of a debug flag is cool. Only, are you aware of Z_DEBUG_MODE I have seen mention of this. How do I use it? Do I just setenv Z_DEBUG_MODE 1? > try: n=string.atoi(n) > except: pass > if n: Globals.DevelopmentMode=1 > I am not up to speed on Python yet. Does this mean that it is expecting Z_DEBUG_MODE to be set to an integer? Does the value mean anything? Phil A ------------------------------------------ Philip Aylesworth zopelist(a)regalint.com Regal International

1 0

RE: [Zope-dev] FAQ Submission
by Michel Pelletier 04 Mar '99

04 Mar '99

> -----Original Message----- > From: Amos Latteier [mailto:amos@aracnet.com] > Sent: Thursday, March 04, 1999 1:28 PM > To: Pavlos Christoforou > Cc: zope-dev(a)zope.org > Subject: Re: [Zope-dev] FAQ Submission > > > At 12:32 PM 3/4/99 -0500, you wrote: > > > > > > >I think Skip provided a better way to deal with this, but I > am not sure if > >it has made it in the official DocumentTemplate release. > > Michel's use of a debug flag is cool. Only, are you aware of > Z_DEBUG_MODE > (aka BOBO_DEBUG_MODE, aka __bobo_debug_mode__)? It's purpose > is exactly > things like this. It gives more informative errors, and > should make all > objects that care operate in debug mode. > > For example, I believe that HTMLFiles should check for this > and reload it's > content if it is set. > > Check out this snippet of code from Main.py > > for n in 'Z', 'BOBO': > if os.environ.has_key('%s_DEBUG_MODE' % n): > n=string.lower(os.environ['%s_DEBUG_MODE' % n]) > if n=='no' or n=='off': continue > try: n=string.atoi(n) > except: pass > if n: Globals.DevelopmentMode=1 > > Now you know how to check for debug mode in your own objects, > check for > 'DevelopmentMode' > > -Amos > I think we're talking about two different methods. In my code... def defaultDocFile(self, id, title, file): f=open('%s/Products/Notmail/%s.dtml') % (SOFTWARE_HOME, file)) file=f.read() f.close() self.manage_addDocument(id, title, file) (which BTW Amos, YOU contributed to NotMail months and months ago before the Great Open Sourcing ;) ...how does the Document object know, after the fact (remember this method is called from __init__) where it's content came from? The path and file pointer are discared after this function returns. Unless the Document instance added by manage_addDocument is telepathic, I can see how it would know where it came from. I can see where in the case where DTML is called like so: amethod = HTMLFile('filename', globals()) The Z_DEBUG_MODE comes in handy, but the manager is never given the option to edit the contents of the Document after the object is created without changing the file on disk, which would change the return values of *all* the returned methods (like 'amethod' above) and effectively change the look of ever instance of the Product in Zope. Different instances of the NotMail Product (the one where my code snips came from) can all edit their own interfaces, because defaultDocFile loads the documents off of disk and puts them into the NotMail Folder. At this point they are unrelated to the files on disk. I think? If this is the case (I think it is) then my original post was a correct method (altough my original post was probably nowhere near clear enough about it). If the Product author wants to return a document loaded at __init__ time into a folder with defaultDocFile she can just: def amethod(blah, bler, REQUEST=None) ... return self.id_of_document(self, REQUEST) With this method, if a Product is a folder it can contain it's own UI, independent of any other instance of the object's UI, and independent of the contents of the DTML in the Products directory on disk. Because this Document object is independent of the contents of the file on disk, the reload_docs method in my original post is used to delete each Document, and reload it from disk, without having to delete/recreate the NotMail object, which gets REALLY old quick when I'm changing my DTML alot. All of this aside, I should not have my own 'debug' attribute but should sniff for Z_DEBUG_MODE instead. I'll try and wrassle up a clearer post for the list. (BTW, both of these methods, the common way and the Product-containing-it's-own-UI way, are detailed extensively in The Zen of Zope). For a hands on example of this method, check out NotMail sources. Confera also does a similar thing (but doesn't offer the ability to reload it's interface) -Michel > > > > _______________________________________________ > Zope-Dev maillist - Zope-Dev(a)zope.org > http://www.zope.org/mailman/listinfo/zope-dev >

1 0