- Zope - Zope lists

Using an arbitrary connection on a ZSQL Method
by Andy McKay 10 May '01

10 May '01

Just did a useful hack I wanted share... Occasionally I find it useful to have one SQL Method that I can call with a different DB connection, programatically. For example I have a test and a live database. Using manage_editProperties each time of course means writing a new copy of the object. The following patch means that you can override the connection_id on the ZSQLMethod with CONNECTION_ID in REQUEST. This could be cleaned up a little of course but I found it useful in conjunction with session management. --- l:\lib\python\Shared\DC\ZRDB\DA.py Thu May 10 16:29:25 2001 +++ q:\lib\python\Shared\DC\ZRDB\DA.py Thu May 10 15:08:36 2001 @@ -457,11 +457,14 @@ if hasattr(self, 'REQUEST'): REQUEST=self.REQUEST else: REQUEST={} - try: dbc=getattr(self, self.connection_id) + if REQUEST is not None and REQUEST.has_key('CONNECTION_ID'): c_id = REQ UEST['CONNECTION_ID'] + else: c_id = self.connection_id + + try: dbc=getattr(self, c_id) except AttributeError: raise AttributeError, ( "The database connection <em>%s</em> cannot be found." % ( - self.connection_id)) + c_id)) try: DB__=dbc() except: raise 'Database Error', ( Cheers. -- Andy McKay.

1 0

<dtml-in> looping over lines in document
by Laurie Nason 10 May '01

10 May '01

Hi guys & gals, Is it possible to use <dtml-in> over a DTML method's text and get each line out one by one. I know there is a lines property but am not sure how or if it can be used in this context. The reason I am asking is that I am trying somehow to store my lookup values for my select boxes in one folder with each lookup having a separate DTML method containing the values. If anyone has a better idea, please let me know. Thanks, Laurie Laurie Nason Dept. of Biochemistry - N420 Baylor College of Medicine Houston. TX77030

2 1

History of DC and/or Zope
by Andy McKay 10 May '01

10 May '01

I'm looking for any documents about the history and beginning of Zope. (Searches on Zope.org have turned up nothing so far, still searching) I'm giving an intro to Zope talk to developers and wanted to quickly cover the history of Zope / DC etc. If there any suitable talks on this topic, pointers to those would be appreciated too :) Thanks. -- Andy McKay

5 5

RE: [Zope] Whatever happened to ... SQL Relay?
by Farrell, Troy 10 May '01

10 May '01

It's still at firstworks. His hosting co was acquired and he had to make a DNS change. You should be able to hit it sometime soon (next coupla days). I got it just fine. Troy -----Original Message----- From: Chris Gray [mailto:cpgray@library.uwaterloo.ca] Sent: Thursday, May 10, 2001 1:35 PM To: zope(a)zope.org Subject: [Zope] Whatever happened to ... SQL Relay? Does anyone know what happened to SQL Relay? The Sourceforge site says that the project moved back to www.firstworks.com but DNS searches say that that host doesn't exist. Chris

1 0

Re: [Zope] Batch-adding images with extra attribs
by Dieter Maurer 10 May '01

10 May '01

Etienne Labuschagne writes: > I have a lot of images that I must upload into Zope. I can probably use > FTP, but I have another problem. I add a copyright attribute to each image. I would use "load_site.py" (in the "utilities" subfolder of the Zope distribution) as a base and extend it with the property addition. Dieter

1 0

Re: [Zope] Adding an ExtFile from a web page
by Dieter Maurer 10 May '01

10 May '01

Andrei Cenja writes: > --=====================_58536290==_.ALT > Content-Type: text/plain; charset="us-ascii"; format=flowed Please do not post MIME messages! > .... > context.manage_addProduct['OFSP'].manage_addFile(id=<>, title=<>, file=<> ) > > and now I would like to do something equivalent with manage_addExtFile; > however, I constantly receive a key error > > Error Type: KeyError > Error Value: standard_html_header Apparently, the acquisition chain is broken. This could happen, if "manage_addExtFile" would be a DTML object. You should check the "signature" of "manage_addExtFile", i.e. what parameters it wants. Furthermore, we might help you better, if you include the traceback in your problem report. Dieter

1 0

Re: [Zope] view management screens
by Dieter Maurer 10 May '01

10 May '01

nuno writes: > Why the external methods need to have view management screens to run ? That seems to be special for your installation. I have never seen it. The call of our external methods (that we use intensively) are protected by view permissions. Only "manage_main" (to edit the methods) are protected by "View management screens". Dieter

1 0

Where are user created help files stored?
by Jason Cunliffe 10 May '01

10 May '01

Zope2.3.2 Win98se/Redhat6.2 I am upgrading the READMEs for a simple Zope Product. I clicked through the ZMI /Control_Panel/Products/ to add some help files. Very nice :-) An example where TTW simple editing really makes sense. I added two help pages for: 'install' and 'use' easily called like this: http://jasonic/Control_Panel/Products/BSDObject/Help/use Then I uploaded my Product folder to remote Linux setup. Works fine but my help files are not there :/ The principle seems obvious to me -help files belong in each Products own folder. Where are the help files kept? Various searches show lots of other help folders but not for my product. Am I doing something wrong or is the workflow for this not yet well developed? Seems like a another vote for a consistent basic Zope Product maintenance API like HiawathaZ[Zope Beans] ? http://www.pault.com/pault/prod/Hiawatha/HiawathaZ.html Also I am curious why does HiawathaZ proposal use separate non-python XML tools? thanks ./Jason ___________________________________________________________ Jason CUNLIFFE = NOMADICS['Interactive Art and Technology']

2 1

Re: [Zope] [ANN] ZShell 0.2
by Jason Cunliffe 10 May '01

10 May '01

Jerome Alet" <alet(a)unice.fr> wrote: > If you're interested I've put a 0.3 online at: > > http://cortex.unice.fr/~jerome/zshell/ This gets better all the time :-) I have learned so much already, just looking through your source. It makes a great Zope tutorial in unexpected ways. Thanks. > new commands: mkver, enter, leave, save, discard (versions) > and the powerful but not used at its full power until > variables are checked in: the "call" command ! > > there are also many bug fixes and the possibility to > call the method with a zshellscript argument containing the > list of commands to execute. Can you give an example to do this please. .................................... More wishlist suggestions for Zshell. <note> I aplologize only a little for this experiment in blatant featuritis. In many cases this is not rocketscience, but a apprades to be a matter of writing smart user-friendly wrappers around known zope tricks. The shell paradigm is very good and does nto really interfere with the nature of zope. Perhaps those with deeoper zen than me will see the catch. I beleive many of the practical workflow headaches of using Zope among different people[skills], can be solved by growing the Zope shell. It separates function from syntax in a very simple way. Logic is another question... If nothing else, I suspect zopeshell is more concise, and readable to more people out of the box. Also very extendable. A fascinating and useful experiment imho. </note> --------------------------- 1. MORE SHELL-LIKE BEHAVIOR I keep hitting return and expecting my code to happen. It's not just laziness. The RUN button breaks the familiar shell command line paradigm. I realise it is nice to have multiple lines, but I find it faster to type and keep typing, than have to jump back and forth to the mouse. One solution: SHIFT + ENTER => multiline entry ENTER => execute ----------------------------- 2. ZSHELL DTML UI SUGGESTIONS At the top of the page include all the wget commands as hyperlinks links. Clicking on a command displays the docstring for the command above/below the text area and also enters the comand and dummy argument string directly into the Zshell shell where one may edit. A checkbox option next to the textarea toggles the 'auto_insert' feature 'on' or 'off'. 'Off' displays just the docstring for the clicked command above the text area This kind of behavior and its display should be defined in any .zrc file and should be able to be invoked in the zshell. Thus display_commands # show hyperlinked zshell commands above text area auto_insert_off # jsut the man docstring auto_insert_on # insert commands and dummy args save_zrc [name] # save the present zshell dtml UI into .zrc file # [zodb/tinytable/properties?] load_zrc [name] # load a .zrc conifiguration DTML + ZSHELL Add a new tag so that Zshell commands can be run from DTML A trivial example might go like this: <dtml-zshell> mkdir ../artists/$newartist cd ../artists/$newartist adduser $newartist/QWERTY mkdir newprojects/outline wget http://www.newsartists_website.org/work/outline pwd ls </dtml-zshell> This would create a new folder for the value of $newartist, a [yet to implemented] zopeshell variable, which can also passed in by a form or some DTML Then add a newuser, and then upload load some HTML+graphics they already have prepared online somewhere else. ------------- 3. RESULTS Normal shell would return the results in the shell itself. I can see why in Zope this may not be often such a good idea. For example, making ls return a hypelinked table as you do is terrific idea. But I found that I quickly needcd to jump back and forth between repeat commadnds when usign zshell. What I was missing was being able to scroll up and down a familair shell windows, browse and cut''n'paste. A possible solution: Allow one to concatentate results to allow a single long scrolling one. This could be a callable 'zhell_session_RESULTS' DTMLmethod. I think this would allow one to be even more prodcutive in using Zshell to explore and manage a Zopesite. Presumably RESULTS connected to the machanism for history you are working on... As above, one shouldbe able to configure this from the shell and/or .zrc: RESULTS_join RESULTS_single RESULTS_off RESULTS_save [name] RESULTS_load [name] I suppose addressable RESULTS are instrinsic to any piping mechanism... and thus wildcards, 'ls', 'cp' etc.. ------------------ 4. cd Seems a little inconsistent at the moment partly becuase it does not resolve "/" I have a zshell in zope root "/" cd . Results: cd: New folder is / cd /images Results: cd: Incorrect path /images WARNING: Errors were encountered but cd images Results: cd: New folder is /images Both of the above should be valid. Perhaps you disagree.. Also for any CD command which is not valid, I suggest including a 'pwd' by default in the first line of the Results error message: <zshell> cd happy </zshell> Results: cd: Incorrect path happy WARNING: Errors were encountered --------------------- 5. mkdir improvements mkdir to handle a path option to complement cd from above mkdir needs option flags to match the manual setting in ZMI of the 2 checkboxes for Create public interface Create user folder mkdir newfolder -(p)ublic -(u)ser Not sure what syntax would be best for doing this when creating a nested mkdir: mkdir a/b/c/d -(p)ublic -(u)ser possibly: :set public+user attributes for all new folders :set public+user attributes for just the last folder Perhaps control it using a simple binary flag style. For example: mkdir a/b/c/d -p0110 -u1110 Set 'public' b and c only Add 'user' folders in a,b,c only -------------------- 6. cp Of course 'cp' should work across folders and also be able to paste in one line. Perhaps a lot of work. I don't know. And I hope zope acquisition logic does not mangle this. Needs to include wildcards of course cp ../../images/earthrise.jpg ../graphics/earthrise.jpg -------------------- 9. wildcards Obviously full Shell-type regular expressions, though desirable, might be a big deal. Some useful, obvious ones for ZopeShell wishlist whcih might be much easier I can think of: * *meta *date *date_since *date_before *size_under *size_over *owner *property Examples of wildcards using ls: ls *.jpeg # object whose names end with ".jpeg" ls *meta='Image' # objects of meta_type 'Image' ls *date='06-May-2001' # objects made on 6th May, 2001 ls *date='today' # object made today ls *date_since='01-05-2001' # objects made since 5th January ls *date_before='01-05-2001' # objects made before 5th January ls *size_under='50kb' # objects less than 50kb ls *size_over='500kb' # objects larger than 500kb ls *owner='nikola' # objects owned by nikola ls *property='description' # objects with a description property -------------------- 8. wget Very useful for all kinds of things Change the 'fname' code so that the default behavior is to save names under their original source names. If that id is already taken, then take action and rename. Include an flag for Zope wget to do auto renaming [like it is now]. syntax could perhaps be: wget args rename_meta # rename to append meta tag wget args rename_sub # rename to append subtype wget args rename_xyz # rename to apend _xyz # where _xyz are any continuous suffix string, "_bak" etc. 7. adduser This is going to be very cool but, meanwhile I am not not clear what to 'do' with adduser. At least until there is a Zshell mechanism to get and set permissions, and then pass them to the add user command. I confess I don't really understand Local Roles in Zope either yet :-( ..so I better shut just up and do some more homework. > * I can't make chown to work, do you have got any idea ? not yet.. cheers ./Jason ___________________________________________________________ Jason CUNLIFFE = NOMADICS['Interactive Art and Technology']

7 11

Re: ZCatalog & resource not found error
by Tim Moore 10 May '01

10 May '01

No, I'm afraid that's not it...the code below gives an attribute error, and I have other scripts where I call getObject on a brain object and have no problems...I think this and a few other methods on the brain objects were added in Zope 2.3. Even this fails: results = container.Catalog(meta_type='Broadcast', getStartTime=DateTime(), getStartTime_usage='range:min', sort_on='getStartTime') result = results[0] return result And the strange thing is that it's failing on the last line (i.e., the return statement). If I change that line to return a dummy string then there's no problem. I could swear that I had something analogous to this working before...is there a bug? I tried upgrading to 2.3.2, but that hasn't helped. :-( Chris McDonough <chrism(a)digicool.com> writes: > The objects returned in the sequence returned from > Catalog.searchResults are "brain" objects. These objects have no > default representation. This may be what you're looking to do: > > results = container.Catalog(meta_type='Broadcast', > getStartTime=DateTime(), > getStartTime_usage='range:min', > sort_on='getStartTime') > > result = results[0] > return container.Catalog.getObject(result) > > Tim Moore wrote: > > > > This python script: > > > > > > return results[0] > > > > produces this error when I click the 'Test' tab: > > > > Zope has encountered an error while publishing this resource. > > > > Resource not found > > > > Sorry, the requested Zope resource does not exist. > > Check the URL and try again. > > > > If I take the [0] part off and have it return the whole results list, > > I have no problems (it returns a list with two items). Weird. > > > > Any clues? (Zope 2.3.1 (binary release, python 1.5.2, win32-x86)) > > -- > > Tim Moore > > > > _______________________________________________ > > 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 ) > > _______________________________________________ > 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 ) > -- Tim Moore

2 1