- Zope - Zope lists

[Fwd: SQL Inserts and Unique keys]
by Timothy Grant 14 Dec '99

14 Dec '99

Sorry folk, I had an e-mail problem and lost the contents of my Zope folder, so I don't know whether there was a reply to this or not. Anyway, any help would be greatly appreciated. Timothy Grant wrote: > > Hi folk, > > Got a client actually paying me some real money to do a Zope project for > them! It is my first one that is not "internal use only." > > Anyway, I've had to go on the education fast track again, I got Zope > lashed up to PostgreSQL and all works beautifully and I'm very pleased. > Something else I am very pleased about is the quality of material on > this list, I have over 10,000 messages archived, and it has been an > invaluable source of information, thanks to each and every one of you > who have answered many Zope/SQL questions for me and don't even know it. > > Now my question, I have a table that has a unique key. When I attempt to > do an insert of a duplicate key from Zope, I simply get a "the form has > no data" error, how can I handle/trap this condition from within Zope? > > -- > Stand Fast, > tjg. > > Timothy Grant tjg(a)exceptionalminds.com > Chief Technology Officer www.exceptionalminds.com > Red Hat Certified Engineer office (503) 246-3630 > Avalon Technology Group, Inc. fax (503) 246-3124 > >>>>>>>>>>Exceptional Minds, Innovative Products<<<<<<<<<< -- Stand Fast, tjg. Timothy Grant tjg(a)exceptionalminds.com Chief Technology Officer www.exceptionalminds.com Red Hat Certified Engineer office (503) 246-3630 Avalon Technology Group, Inc. fax (503) 246-3124 >>>>>>>>>>Exceptional Minds, Innovative Products<<<<<<<<<<

1 0

connectionIsValid
by Daniel G. Rusch 14 Dec '99

14 Dec '99

The following works just peachy: <dtml-if "Database.connected()"> Yes <dtml-else> No </dtml-if> Why doesn't this work? <dtml-if "Database.connectionIsValid()"> Yes <dtml-else> No </dtml-if> What is the syntax of connectionIsValid; am I doing something incorrect? Thanks, DR

1 0

a newbie question... access control
by David M. Cannon 14 Dec '99

14 Dec '99

Hi all, A real newbie question; I'll try to keep it short. I've followed the tutorial where 'Stan' is setting up some simple site, and tried to do a little shortcutting and changed the details so I could see if I really understood what was going on, and have run into a baffling (to me) glitch: I'm running as the site superuser, but am getting an access control error: "You are not authorized to access <em>manage_changeProperties</em>." I suspect I'm missing something real obvious, but I don't know any good ways to chase down the problem yet. Any pointers? What are the common ways of chasing down problems like this? (I am trudging through the code, but surely I don't need to know it all before I can deal with a problem like this one. I'm having a hard time trying to figure out where to start.) Let me know if I haven't provided enough information... Thanks! Dave Cannon dmcannon(a)cdr.stanford.edu -=-=-=-=-=-=-= traceback follows: You are not authorized to access <em>manage_changeProperties</em>. <!-- Traceback (innermost last): File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 198, in publish_module File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 112, in publish File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 112, in publish File /usr/local/Zope/lib/python/ZPublisher/mapply.py, line 104, in mapply (Object: email_build2) File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 101, in call_object (Object: email_build2) File /usr/local/Zope/lib/python/OFS/DTMLMethod.py, line 133, in __call__ (Object: email_build2) File /usr/local/Zope/lib/python/DocumentTemplate/DT_String.py, line 393, in __call__ (Object: email_build2) File /usr/local/Zope/lib/python/DocumentTemplate/DT_With.py, line 130, in render (Object: manage_clone(email_template2,REQUEST['new_id'],REQUEST)) File /usr/local/Zope/lib/python/DocumentTemplate/DT_Util.py, line 323, in eval (Object: manage_changeProperties( e_from=REQUEST['new_e_from'], e_subject=REQUEST['new_e_subject'] ))

1 0

changing the default index_html
by Maarten Slaets 14 Dec '99

14 Dec '99

How do I do this? (I want to put in something like: <ul> <dtml-in "PARENTS[0].objectValues()"> <dtml-if expr="id=='index_html'"> <dtml-else> <li><a href="<dtml-var absolute_url>"><dtml-var id></a></li> </dtml-if> <dtml-else> Nothing in folder. </dtml-in> </ul> ) -- Maarten Slaets Web Developer KPNQwest Belgium http://www.fonky.com/vcard/MaartenSlaets/

3 5

example from ZODB How-To
by Jens Linge 14 Dec '99

14 Dec '99

Dear all, I tried the example MySimpleZODBApp class from the ZODB how-to (http://www.zope.org/Members/michel/HowTos/ZODB-How-To) but couldn't get it running. The Python code for the external method is: import Persistence import ZODB class Person(Persistence.Persistent): """A Persistent Person""" def __init__(self, name, age): self.name = name self.age = age class MySimpleZODBApp: """ A simple application object that manages persistent object's of the 'Person' class. """ def __init__(self, file='Data.fs'): """ Create a database, connect to it and get the root object out of it. """ self.db = ZODB.DB(ZODB.FileStorage(file)) self.connection = self.db.open() self.root = self.connection.root() if not len(root): self.root['billy'] = Person('Billy', 77) # normally Zope will handle transactions, # but in this special case, we need to # commit the transaction to save the new # persistent object get_transaction().commit() def addPerson(self, name, age): """ Adds a 'Person' to the database """ if self.root.has_key(name): raise 'PersonAllReadyExists', "They're allready there" else: self.root[name] = Person(name, age) get_transaction().commit() def delPerson(self, name): """ Deletes a 'Person' from the database """ if self.root.has_key(name): del self.root[name] get_transaction().commit() else: raise 'NoSuchPerson', 'Who?' In the line: self.db = ZODB.DB(ZODB.FileStorage(file)) I added a missing ) in the end. I used the following external method: def createDB(self, REQUEST): """ create an instance of MySimpleZODBApp """ testDB = MySimpleZODBApp() I called it from zope via dtml: <dtml-var "createDB(REQUEST)"> However, when loading the page, I get the following traceback: Zope has encountered an error while publishing this resource. Error Type: TypeError Error Value: call of non-function (type module) Traceback (innermost last): File /local/zope/Zope-2.0.1-linux2-x86/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /local/zope/Zope-2.0.1-linux2-x86/lib/python/ZPublisher/Publish.py, line 179, in publish File /local/zope/Zope-2.0.1-linux2-x86/lib/python/Zope/__init__.py, line 201, in zpublisher_exception_hook (Object: ElementWithAttributes) File /local/zope/Zope-2.0.1-linux2-x86/lib/python/ZPublisher/Publish.py, line 165, in publish File /local/zope/Zope-2.0.1-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: copy_of_index_html) File /local/zope/Zope-2.0.1-linux2-x86/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: copy_of_index_html) File /local/zope/Zope-2.0.1-linux2-x86/lib/python/OFS/DTMLDocument.py, line 166, in __call__ (Object: copy_of_index_html) File /local/zope/Zope-2.0.1-linux2-x86/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: copy_of_index_html) File /local/zope/Zope-2.0.1-linux2-x86/lib/python/DocumentTemplate/DT_Util.py, line 321, in eval (Object: createDB(REQUEST)) File <string>, line 0, in ? File /local/zope/Zope-2.0.1-linux2-x86/lib/python/Products/ExternalMethod/ExternalMethod.py, line 253, in __call__ (Object: createDB) (Info: ((<h3>form</h3><table> ... ... (several lines deleted) ... </table>,), {}, None)) File /local/zope/zope/Extensions/booking.py, line 143, in createDB (Object: ElementWithAttributes) File /local/zope/zope/Extensions/booking.py, line 31, in __init__ TypeError: (see above) line 143 is the line where I instantiate MySimpleZODBApp: MSTEST = MySimpleZODBApp() line 31 is the line in the constructor of MySimpleZODBApp: self.db = ZODB.DB(ZODB.FileStorage(file)) I don't know what went wrong. Did anyone try this example? I had a quick look at the sources, but couldn't figure out the error. I also tried it on a different machine running Zope 2.0, but got the same traceback. Thank you in advance. Jens -- Jens Linge phone: +49 6221 387140 EMBL, Nilges Group fax: +49 6221 387517 Meyerhofstr. 1 www: http://www.linge.de D-69012 Heidelberg priv: +49 6221 169139

1 0

RE: [Zope] RE: [Zope-dev] Getting a printout of my Zope Applicati on
by Michel Pelletier 14 Dec '99

14 Dec '99

> -----Original Message----- > From: Rik Hoekstra [mailto:RikHoekstra@bigfoot.com] > Sent: Tuesday, December 14, 1999 10:52 AM > To: Michel Pelletier; Rob Page; 'Clayton Miller' > Cc: zope(a)zope.org > Subject: RE: [Zope] RE: [Zope-dev] Getting a printout of my Zope > Application > > > > > > > > > -----Original Message----- > > > From: Rob Page [mailto:rob.page@digicool.com] > > > Sent: Monday, December 13, 1999 9:36 PM > > > To: 'Clayton Miller' > > > Cc: 'zope(a)zope.org' > > > Subject: [Zope] RE: [Zope-dev] Getting a printout of my Zope > > > Application > > > > > > > > > Hi Clayton: > > > > > > > I have been wondering (while developing my first Zope > > > > application), is there > > > > a way to get a printout of all of my objects' source? > > > > I just feel better having a hard copy of my entire > > > > application lying around. > > > > > > You could Export the site (or Folder) from the > Import/Export tab into > > > XML. > > > > And then you could feed that XML right back IN to Zope and render it > > real pertty with a style sheet. > > > > Sick. > > > > Hm, except that when I import an exported product back into > ZOpe it fails > with the following traceback: I'm not sure what is causing this, but what I meant was to take the exported XML and upload it into an XML Document object. Someone should however look at this. -Michel > > Zope Error > Zope has encountered an error while publishing this resource. > > Error Type: TypeError > Error Value: ('not enough arguments; expected 2, got 1', , ()) > > > <snip> > > > Traceback (innermost last): > File C:\Program > Files\WebSite\lib\python\ZPublisher\Publish.py, line 214, > in publish_module > File C:\Program > Files\WebSite\lib\python\ZPublisher\Publish.py, line 179, > in publish > File C:\Program Files\WebSite\lib\python\Zope\__init__.py, > line 202, in > zpublisher_exception_hook > (Object: ElementWithAttributes) > File C:\Program > Files\WebSite\lib\python\ZPublisher\Publish.py, line 165, > in publish > File C:\Program > Files\WebSite\lib\python\ZPublisher\mapply.py, line 160, > in mapply > (Object: manage_importObject) > File C:\Program > Files\WebSite\lib\python\ZPublisher\Publish.py, line 102, > in call_object > (Object: manage_importObject) > File C:\Program > Files\WebSite\lib\python\OFS\ObjectManager.py, line 478, > in manage_importObject > (Object: ElementWithAttributes) > File C:\Program > Files\WebSite\lib\python\ZODB\ExportImport.py, line 216, > in importFile > File C:\Program > Files\WebSite\lib\python\ZODB\ExportImport.py, line 318, > in importXML > File C:\Program > Files\WebSite\lib\python\ZODB\ExportImport.py, line 283, > in importFile > TypeError: (see above) > > > Rik > >

1 0

RE: [Zope] comparing variables ??
by Michel Pelletier 14 Dec '99

14 Dec '99

> -----Original Message----- > From: Greg Ward [mailto:gward@cnri.reston.va.us] > > AUTHENTICATED_USER.getUserName() is what you're looking for here. > > Or, if you don't happen to know the name of the method, you > can just use > the standard Python function for getting an object's string > representation. In straight Python, this would be > > str (AUTHENTICATED_USER) > > but in DTML's bastard offshoot of Python, it's > > _.str (AUTHENTICATED_USER) It's probably a better idea for future compatability to use the API and call getUserName. -Michel

1 0

manage_addImage does not work
by Eduardo Fernandez Corrales 14 Dec '99

14 Dec '99

Hello, I am trying to add an image to a folder, from the local filesystem. I fill the form with the Id, Title and Image fields but after clicking on "Add" nothing happens, the browser just waits. My logs show no sign of activity until I click some other link. Then I get this: xxx.xx.xxx.xx - - [14/Dec/1999:18:06:46 +0100] "POST /Testfolder/manage_addProduct/OFSP/manage_addImage HTTP/1.0" 400 2083 The Zope process shows no sign of CPU locking, or any other abnormal behaviour. What could be happening? Thanks in advance. -- Eduardo Fernández Corrales eduardo(a)sistelnet.es Sistelnet Integraciones Telemáticas - http://www.sistelnet.es

1 0

Job Announcement -- University of Pittsburgh Medical Center
by Jim Harrison 14 Dec '99

14 Dec '99

We're looking for a Web developer--ideally a Zope developer--to fill a permanent position in our information systems group in the Department of Pathology at the University of Pittsburgh Medical Center. Please contact me directly if you're interested or for additional details. The text of the official advertisement is as follows: -------------- Position: Systems Analyst II The Information Services Division of the UPMC Health System is recruiting a talented web professional to reorganize and support web sites for the Department of Pathology, managing them as part of a distributed electronic publishing environment. Our site is currently one of the largest national Medical Pathology sites, with about 700,000 hits per month, and includes an intranet which serves over a dozen hospitals in southwest Pennsylvania. Candidates should have a minimum of a masters degree in computer science or a bachelor's degree and 2-3 years experience in Web development, and strong working knowledge of HTML/HTTP, JavaScript, CGI development, Perl or Python, Web server management, Web-database connectivity and Windows NT server management. Experience with distributed authorship systems such as Zope or Frontier is preferred. Experience with Unix/Linux and relational database management would be a plus. -------------- Reference URLs: http://path.upmc.edu/ http://apiii.upmc.edu/ Jim Harrison ________________________________________________________________________ James H. Harrison, Jr., MD, PhD Associate Director of Pathology Informatics, Department of Pathology Faculty Member in Residence, Center for Biomedical Informatics University of Pittsburgh Health System C920 PUH, 200 Lothrop Street Pittsburgh, PA 15213 jhrsn(a)pop.pitt.edu | voice: 412-647-5529 | fax: 412-647-9588 "If you want sense, you'll have to make it yourself!!"-Norton Juster ________________________________________________________________________

1 0

ANNOUNCE: Zope 2.1.1 has been released
by Brian Lloyd 14 Dec '99

14 Dec '99

Hi all, Zope 2.1.1 has been released. This is a bug-fix release that includes fixes for better handling of multiple-write conflicts, undo-related problems and problems that prevented certain third-party Zope products such as Squishdot from working. For more information, see the file CHANGES.txt in the doc directory of the distribution. As always, you can get the 2.1.1 release from Zope.org: http://www.zope.org/Products/Zope/2.1.1/ Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0