August 2000 - Zope - Zope lists

Re: [Zope] SQL question...I think
by Dieter Maurer 29 Aug '00

29 Aug '00

George writes: > .... > I know how to insert data in to the table, > search and such. I can not find any info on how to embed the data in my > dtml-html code to show it to the world..... Because, you can already search, you do already embed data in dtml-html to show it to the world. You just do not yet realized it.... Okay, one step further: * In your "Available Objects", you will find an entry Z Search Interface. Add it to a folder! It will ask for a connection id, and id for the search form and the report. * The report presents search results to the world. It is a DTML method. Look at it, look at the DTML documentation, try to understand "dtml-in" and its parameters. * Change the report by removing columns (the columns, you do not want to show). * Play with the "size" and the "orphan" (these are <dtml-in> arguments). * If you still do not yet get, what you want (then you will already have high requirements), then notice the following facts: - the result of an Z SQL method behaves like a sequence - "_.len" gives its length, i.e. the number of hits - "...[i]" gives you the "i"th hit - each hit behaves as an object with the columns as attributes Do not be frustrated, if you do not get this handled at the first trial. Dieter

1 0

Re: [Zope] REQUEST.form.set ???
by Dieter Maurer 29 Aug '00

29 Aug '00

Brian Withun writes: > Is it possible for DTML to create or modify a form value? It is possible to extend any dictionary, especially "REQUEST.form". You use the dictionary "update" method as in <dtml-call "REQUEST.form.update({'a':1, 'b':2})"> It will, however, not work as you might expect. This is because the DTML namespace *does not* look into "REQUEST.form" but into the dictionary "REQUEST.other". During "REQUEST" construction, the "other" dictionary is updated with the "form" dictionary. Therefore, you see form variables, too, in the DTML namespace. However, later updates to "REQUEST.form" are not automatically propagated to "REQUEST.other" (and therefore not seen via the DTML namespace). You can use <dtml-call "REQUEST.other.update({'a':1, 'b':2})"> or (as someone else suggested) "REQUEST.set". Dieter

1 0

"Automatic" creation of searchable documents from Oracle DB tables
by Chris Beaumont 29 Aug '00

29 Aug '00

Hi Kapil, (and fellow Zopatistas) Well, it's been difficult, but I finally feel as if I'm on the verge or understanding this a bit better.. Thank you for taking the time to explain this. I would think, it's a fairly simple thing I'm trying to do. Hehehe.. Famous last words.. huh? So, anyway, I've been staying up till 2 am almost every night trying to absorb as much of this as I can, but I have an (extensive) web development, but not a programmer's background, and I'm very much a Zope newbie, so I need to ask you some more questions.. I hope you don't mind.. You can get a feel for what I am talking about by looking at any of the programs or workshops on the website I manage, www.msri.org. Currently, I'm doing this site by rendering these fields of info through templates into static pages in Frontier, but I'd like to transition to Zope. (Its the old webmaster's dream of the "self-maintaining site" *LOL*) So here's where I'm at so far.. I have built an Oracle 7 database to hold the event info.. Everything fine there, everything works.. now for the fun stuff.. I have several tables in this "event" section of the database, programs, workshops and talks. (there actually is one other table for other kinds of events) Each kind of event is treated somewhat differently in the schema. It's a very simple setup with nothing exotic going on.. Logically, a given workshop is usually tied to a program..and a given talk is usually tied to a parent workshop. I have been successful in setting up the basic web-database interaction. I made the basic insert and query forms that are described in the ZSQL Users Guide, and as I said in my previous posting my next goal is to be able to create separate documents from the data in the individual records that are inserted into the tables.. I'd like to be able to search them along with the other Zope documents on the site, at once, (using a ZCatalog..hopefully) I also need to be able to quickly build several different kinds of automatically-maintained lists from SQL queries that home in on various subsets of the event data. (Ultimately, this system will be expanded to handle "people" data, which will involve some very large lists of people spanning over 20 years, so this system needs to have decent performance with large datasets...But, even then, the result set of a given query will always be quite small..) Starting with (on the insert record side) I have an SQL Method for each event type that describes the permissable arguments, and the code describing the multi-field insert. (I have a sequence and trigger already working on the database side of things that implements a unique ID -the primary key- for each new program, so the ID is not one of the arguments passed through the ZSQL Method..should I change this? - I could do this some other way..) I also have another SQL method for each type of event that does a select * from <event_type> so that I can implement pulldowns in the select form for the child workshops of a program. (This is really nice and is one of the reasons I think Zope will be great for building a highly useable web interface to this database, widgets like this make it easy to keep referential integrity..) Then, one (in the case of the event types without possible "parents") or both of the SQL Methods are called in an DTML Document input form. When the form is submitted a DTML Method is triggered, which right now only shows an acknowledging thank you to the person who submits the information. So, if I understand you correctly, **I should then use that action to create a class that is tied to the primary key of the database table. Is there an example somewhere of this RDBMS table-keyed "automatic" creation of ZClasses or DTML documents?* I think ZClasses would be preferable because there are several kinds of event pages I'd like to generate for each kind of event.. (for example, sometimes we have short-term housing information we want to show, and a few weeks before a given event, as more information becomes available, I'd like to be able to have it added .. For example, as an event time nears, I almost always have to put up schedules of the talks in a given workshop..) Anyway, if you have the time and can think of any handy pointers to documentation or relevant examples, Id appreciate it.. But even if not, you already have given me a good start.. It shouldn't be very hard, but even though I've been putting in a lot of time searching, finding information has been difficult for me.. The closest I could find to what I want to do is the (very) few snippets of information available about "pluggable brains". But there isn't even a HOWTO on this, a question that should be a common question.. If anyone has any pointers for a beginner. I'd be really grateful.. Thank you.. Chris I really appreciate your help.. Chris cbeaumon(a)msri.org >Some considerations. > >1. Duplicating data is bad. > >2. Let the RDMBS do as much of the processing as possible. > > >A possible solution (TMTOWTDI): > > >create a dtml method 'create event'. its basically an encapsulation to >simulate triggers. in this method make your call to the insertion of the >data into the sql db. after that call you can create a ZClass or DTML >document with the property that stores the primary key of the data >record in the DB (if you do it as a dtml doc, you either want to clone, >or pass its body, check out the ZQR). this is your basic association of >your objects and the sql data. in a dtml method that lives above your >objects have a body that basically calls a retrieval sql on the db which >takes an arg for the id. The body of your dtml doc/ZClass(index_html) >calls this method for presentation of its data passing its property as >an arg. you can arrange your objects in whatever heirarchy you want as >they will acquire the dtml method and the sql methods for presentation >(or put it in the zclass). For deletion create a similiar trigger >encapsulation method, delete row, delete object. > > >caveat. DON't use this to display lots of events on a page (hideous >performance). you're much better off going to the db directly and >grabbing all the results you need perhaps with python brain for extra >presentation info. > > >Cheers > >Kapil >

3 2

[ANN] FSSession-0-4-2
by Pavlos Christoforou 29 Aug '00

29 Aug '00

Hello Zopistas FSSession 0-4-2 is available at: http://www.zope.org/Members/gaaros/FSSession FSSession 0-4-2 corrects a bug on Windows platforms where os.rename fails if the renamed file already exists. This version has also been tested under many "unusual" situations (calling FSSession twice, two users having the same SessionUID) and it seems to be very robust. Regards Pavlos

1 0

Re: [Zope] CatalogAware
by Dieter Maurer 29 Aug '00

29 Aug '00

Yapo =?ISO-8859-1?Q?S=E9bastien?= writes: > I use objects from a class which inherits from CatalogAware. > The objects index themselves into the ZCatalog but I get strange results = > when I try to search in this ZCatalog... The problem is solved after = > reindexing the object via the reindex_object() method but this works = > only for manage_edit ... I can't index my object properly in the = > manage_add method (I get the same problem) This is a bug, I recently found in "GlobbingLexicon". It may be, too, in a normal "Lexicon". The collector (URL:http://classic.zope.org/Collector) contains a patch for "GlobbingLexicon". The patch is applied in Zope 2.2.1. Dieter

1 0

Re: [Zope] Problem with SiteAccess 1.0.1
by Dieter Maurer 29 Aug '00

29 Aug '00

William JOYE writes: > I have some minor problems with SiteAccess 1.0.1 and Zope 2.1.6 + hotfix. > > 1. When click on the folder that contain SiteRoot, I need to enter again > login and password. Why ? > 2. When I delete an object, I have always an script error message. Why ? We use SiteAccess 1.0.1 with Zope 2.1.6 and do not see your problems. I know, this does not answer your questions, but it may give you hope that the problem is not in SiteAccess per se, but in the way you are using it. Dieter

1 0

Re: [Zope] updating only zCatalog ?
by Dieter Maurer 29 Aug '00

29 Aug '00

Philipp Dunkel writes: > I'd like to use it for my Products, but I don't have the time now to port > everything to the new zope version. > Is it possible to only use the new catalog and which files do I have to > change/update ? It is possible. You would use the folder "SearchIndex" from Zope 2.2 and the attached patch. Dieter ..................................................................... diff -u ../ZopeCVS/lib/python/Products/ZCatalog/Vocabulary.py lib/python/Products/ZCatalog/Vocabulary.py --- ../ZopeCVS/lib/python/Products/ZCatalog/Vocabulary.py Sat Aug 19 15:56:53 2000 +++ lib/python/Products/ZCatalog/Vocabulary.py Sat Aug 19 15:58:13 2000 @@ -128,7 +128,7 @@ 'help': ('ZCatalog', 'Vocabulary_Query.stx')}, ) +Item.manage_options - +AccessControl.Role.RoleManager.manage_options + #+AccessControl.Role.RoleManager.manage_options ) __ac_permissions__=( diff -u ../ZopeCVS/lib/python/Products/ZCatalog/ZCatalog.py lib/python/Products/ZCatalog/ZCatalog.py --- ../ZopeCVS/lib/python/Products/ZCatalog/ZCatalog.py Sat Aug 19 15:56:42 2000 +++ lib/python/Products/ZCatalog/ZCatalog.py Sat Aug 19 15:58:48 2000 @@ -101,7 +101,7 @@ from SearchIndex import UnIndex, UnTextIndex from Vocabulary import Vocabulary import IOBTree -from AccessControl import getSecurityManager +#from AccessControl import getSecurityManager manage_addZCatalogForm=HTMLFile('addZCatalog',globals()) @@ -614,9 +614,9 @@ class td(TemplateDict): - - def validate(self, inst, parent, name, value, md): - return getSecurityManager().validate(inst, parent, name, value) + pass + #def validate(self, inst, parent, name, value, md): + #return getSecurityManager().validate(inst, parent, name, value) def expr_match(ob, ed, c=InstanceDict, r=0): e, md, push, pop=ed diff -u ../ZopeCVS/lib/python/Products/ZCatalog/__init__.py lib/python/Products/ZCatalog/__init__.py --- ../ZopeCVS/lib/python/Products/ZCatalog/__init__.py Fri Jun 9 03:22:14 2000 +++ lib/python/Products/ZCatalog/__init__.py Sun Aug 20 07:42:25 2000 @@ -109,6 +109,6 @@ context.registerBaseClass(ZCatalog.ZCatalog) context.registerBaseClass(CatalogAwareness.CatalogAware) - context.registerHelp() - context.registerHelpTitle('Zope Help') + #context.registerHelp() + #context.registerHelpTitle('Zope Help') diff -u ../ZopeCVS/lib/python/Products/ZCatalog/addZCatalog.dtml lib/python/Products/ZCatalog/addZCatalog.dtml --- ../ZopeCVS/lib/python/Products/ZCatalog/addZCatalog.dtml Sat Jul 29 11:24:43 2000 +++ lib/python/Products/ZCatalog/addZCatalog.dtml Sun Aug 20 07:51:21 2000 @@ -6,7 +6,10 @@ <BODY BGCOLOR="#FFFFFF" LINK="#000099" VLINK="#555555"> <H2>Add Catalog</H2> +<dtml-comment> <dtml-var "HelpSys.HelpButton('ZCatalog_Add.stx', 'ZCatalog')"> +</dtml-comment> + <FORM ACTION="manage_addZCatalog" METHOD="POST"> <TABLE CELLSPACING="2">

1 0

Re: [Zope] unauthorized when accessing /manage in zope 2.2.1
by Dieter Maurer 29 Aug '00

29 Aug '00

Philipp Dunkel writes: > I have a Zope Product that makes use of different nested classes. > When I create an instance of this product I always get an > "unauthorized" error when clicking the instance in the management interface > (=accessing <instance>/manage) > even if I am logged in as a manager or superuser. Looks like a Zope bug. However, you must at least include the traceback in order for us to say more. Probably, you must even package your Zope Product and give it away, such that someone of us can analyse your problem in detail. Dieter

1 0

Re: [Zope] dedicated folder for each user
by Dieter Maurer 29 Aug '00

29 Aug '00

Vincent writes: > is it possible to creat automatically a folder with the name of the logged > user ? Yes! In general, you can do anything programmatically that you can do with the management interface. Because Zope is open source, you can learn from the management interface, how to do it. You take the following steps: * locate the source for the form that asks you for the required information. In your case, this will probably be a "*.dtml" file in the OFS folder. * Usually, the form "action" tells you the function/method that performs the operation (after the form is submitted). Sometimes, the function/method is given by the button name or button value (if the name end in ":method"). * If you are lucky (most of the time, you will), then the function/method is documented in the object reference (-> zdp.zope.org) the Zope 2.2 online help or the interface Wiki (-> zope.org -> WikiCentral). * If you are not lucky, you can derive the function/method interface from the form variables. The request object contains variables for each (most of the) form input element (maybe with ":<type>" suffixes stripped and executed). For your special task, you must also know, that the logged in user is described by "AUTHENTICATED_USER" and that this object has a method "getUserName". Dieter

1 0

Re: ZOPE Python edit debug cycle
by Chui Tey 29 Aug '00

29 Aug '00

"Phlip" <phlip_cpp(a)my-deja.com> wrote in message news:8oefpc$ve8$1@nnrp1.deja.com... > Newsgroupies. > > I installed ZOPE on Win32, and noticed it came with a bunch of > "Products"; each a kind of "soft driver" written in some language > (typically Python) to drive the ZObject space & build Web pages. > > Then I tried to edit a py file and see the new output. I had to use > this sequence to see my tiny change: > > make the change > save the change > Stop the ZOPE service > Start the ZOPE service > Refresh the ZOPE Web page > Inspect the change. > > If I had a syntax error, ZOPE throws it away and I never get to read > it. > Tips: #1. Start with -D option #2. Use the PythonWin to run your changes through a tab nanny. (Side note: edit.com messes up the tabs in the python code badly, use notepad if you really have to), before restarting. #3. Run from command line instead of a service #4. just before where you changed the python code, insert import pdb pdb.set_trace() Have a look through the python debugger docos if you're not familiar. This way you can step through your code. Setting breakpoints? download the latest pdb.py/bdb.py from sourceforge, otherwise setting breakpoints is hard. #5. you might be able to reload modules if your changes are small. > The inner question: How, in ZOPE land, do you ask it to refresh its > concepts of all the Python files without stopping and restarting the > service? > > The outer question: What does a healthy edit/debug cycle look > like? > #1. Get as much of your code working without Zope first. #2. Fix as much code as you can before restarting. With Zope, really you lose a lot of the interactivity in debugging code the python way. > -- > Phlip > ======= http://users.deltanet.com/~tegan/home.html ======= > > > Sent via Deja.com http://www.deja.com/ > Before you buy. I've copied this in to the Zope.org mailing list. See you there!

1 0