- Zope - Zope lists

skinscript and ZSQL
by Aaron Payne 17 Dec '00

17 Dec '00

Hi all, I'm trying to use Gadfly as storage for a Zpatterns rack. With the following skinscript trigger I can view records in the database. But I can't insert a new one. WHEN OBJECT ADDED CALL sqlInsertProduct() WITH QUERY lookup_product(client_name=self.id) COMPUTE client_name,email,rate,last_payment,primary,services Where: sqlInsertProduct is a zsql method. args: client_name email rate last_payment primary services Query template: INSERT INTO clienttracker_table (client_name, email, rate, last_payment, primary, services) VALUES ( '<dtml-var client_name>', '<dtml-var email>', '<dtml-var rate>', '<dtml-var last_payment>', '<dtml-var primary>', '<dtml-var services>' ) lookup_product is a zsql method. args: client_name Query template: select * from clienttracker_table where <dtml-sqltest client_name type=string> client_name,email,rate,last_payment,primary,services are fields of the table clienttracker_table and properties of the dataskin. If I remove "=self.id" from the trigger I am able to add a record to the db through the trigger. Without "=self.id" in the trigger I am unable to view the records in the db. I noticed in a post today that said ... you should probably choose some attribute other than 'id' as the attribute to check for your DataSkin. The 'id' attribute is always there... Objects are loaded by accessing attribute client_name and I still get the "object already exists" error. Questions: -Should I just create the record directly with the zsql method? That would defeat the purpose of using ZPatterns. -How do I eliminate the "already exists" error Zope version: Zope 2.2.1 Python version: 1.5.2 System Platform: freebsd4 -Aaron

2 2

Re: [Zope] ZCatalog raises index out of range exception error
by Dieter Maurer 17 Dec '00

17 Dec '00

Stefan H. Holek writes: > Do you have a SiteRoot-ed environment? I believe I saw this error when > trying to use the Catalog in a SiteRoot-ed folder... > > No solution, sorry ;) We use the Catalog together with a SiteRoot without problems. I remove the host part of the URL before I index the object. Dieter PS: Sorry! After writing, I recognized that we make only restricted use of SiteRoots: we just change the host part but not the path part. As a result, the URL's only differ in the host part. The locally (wrt. the host) absolute URL's of an object are equal for all virtual domains. Therefore, removing the host part works out restricted use. The general case, where the path part is different for each virtual host, is more difficult. I would probably go for a separate catalog for each virtual host and ensure that the URL's with which the objects are indexed are the URL's for this virtual host. This may require, that indexing is done in this same virtual host environment.

1 0

Re: [Zope] Manage tar-file and store them externally
by Dieter Maurer 17 Dec '00

17 Dec '00

rgoestenmeier(a)web.de writes: > This is a multi-part message in MIME format. > > ------=_NextPart_000_00BC_01C0676C.125CBB90 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable Please do not send MIME messages to this list! > I cant to manage Files (.tar, ...) on this Website. Why not? What happens. > ... > Additionally i want to keep the file seperatly on an filesystem and not = > in the Zope Object Repository. You may look at the third party Zope products "ExternalFile" and "LocalFS". Can can search for them via zope.org. Dieter

1 0

Re: [Zope] Generating HTML and SQL from results of Describe Table queries.
by Dieter Maurer 17 Dec '00

17 Dec '00

Lloyd Kvam writes: > .... > T. J. Mannos has written > how to apply wrappers to html to turn them into DTML Documents. I could not > find any equivalent description for Z SQL Methods. A Z SQL Method uses a template (in fact a DTML template with additional commands) to construct a command (in fact a sequence of commands) to a database from the arguments provided and its context. Thus, you have 2 options: 1. if your operations fall into well defined classes easily described by a DTML template with arguments, then you define a Z SQL method for each of these templates. e.g. Arguments: TableName ColumnName ColumnType Template: MODIFY <dtml-var TableName> ADD COLUMN <dtml-var ColumnName> <dtml-var ColumnType> 2. otherwise, you define a very general Z SQL method Arguments: command Template: <dtml-var command> and build your "command" with any appropriate tool (e.g. an external method or Python script) and pass it as a parameter. Be *VERY* careful, not to make such a Z SQL method accessible from the Internet, as it allows very malicious operations on your system! You will probably go for option 1. Dieter

1 0

Re: [Zope] Upload file size
by Dieter Maurer 17 Dec '00

17 Dec '00

diego(a)magicwebdesign.com.br writes: > There's a way to get the size of a file uploaded in a form before write it? I am not sure, what type of object is used at the base of "FileUpload" objects (to give them there file like behaviour). If this a "cStringIO" objects, they may have a "len" attribute. This means, you could use "your_uploaded_file.len" to get the length. Otherwise, you could try: file.seek(0,2) # positions at the end len= file.tell() # tells the current position (i.e. the length) file.seek(0,0) # positions at the start That's Python code. You can do something equivalent in several DTML commands. Dieter

1 0

GUF incompatible with 2.2.4?
by Steve Drees 16 Dec '00

16 Dec '00

Has anybody gotten GUF working on 2.2.4? -- Steve Drees SysAdmin/Software Developer/Web Geek/Chief Bottle Washer "A problem well-stated is a problem half-solved." http://www.christianmp3zone.com/savanna

1 0

sql query results -> DTML method problem
by Lee Reilly CS1997 16 Dec '00

16 Dec '00

Hi, I have a TINY problem, which I think there is a simple solution too... but for the life of me, I can't find it! I'd be grateful if someone could point me in the right direction. I have a database setup containing details of classes, students & lecturers. The user is prompted to enter a class code (a unique key) which is used to query the database and return the class title. Simple. A DTML method prompts me for the class code -- I enter 52.139 and it posts to a method 'enterClassCodeAction', below. #1 <dtml-var standard_html_header> #2 <h2>Confirm</h2> #3 <p>You entered <i><dtml-var class_code></i></p> #4 #5 <p> #6 Our records show that <dtml-var class_code> is called #7 #8 <dtml-in expr="findClassTitle(code=52.139)"> #9 <dtml-var title> #10 </dtml-in> #11 #12 #13 </p> #14 <dtml-var standard_html_footer> ^ The method works fine when the class code is manually inserted (line #8) but when I try to pass the variable from the previou post, held in <dtml-var class_code> I have probs. <dtml-in expr="findClassTitle(code=<dtml-var class_code>)"> *** syntax error findClassTitle is a ZSQL method for returning the class title given a class code: select title from classes where <dtml-sqltest code op=eq type=float> Hmm... anyone see the problem? Thanks a lot :) - Best regards, Lee

2 3

Two problems regarding security, and eval in zope 2.2.4
by Manuel Amador (Rudd-O) Gerente de desarrollo Alpha 16 Dec '00

16 Dec '00

Hello everyone, I\'m having a little bit of trouble: http://boeing:8080/manage_access <- traceback of the manage_Access view in the ROOT folder Traceback (innermost last): File /usr/lib/python1.5/site-packages/ZPublisher/Publish.py, line 222, in publish_module File /usr/lib/python1.5/site-packages/ZPublisher/Publish.py, line 187, in publish File /usr/share/zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: ApplicationDefaultPermissions) File /usr/lib/python1.5/site-packages/ZPublisher/Publish.py, line 171, in publish File /usr/lib/python1.5/site-packages/ZPublisher/mapply.py, line 160, in mapply (Object: manage_access) File /usr/lib/python1.5/site-packages/ZPublisher/Publish.py, line 112, in call_object (Object: manage_access) File /usr/share/zope/lib/python/AccessControl/Role.py, line 255, in manage_access (Object: ApplicationDefaultPermissions) File /usr/share/zope/lib/python/App/special_dtml.py, line 120, in __call__ (Object: access) File /usr/lib/python1.5/site-packages/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: access) File /usr/lib/python1.5/site-packages/DocumentTemplate/DT_With.py, line 146, in render (Object: _.namespace(valid_roles=valid_roles())) File /usr/lib/python1.5/site-packages/DocumentTemplate/DT_In.py, line 630, in renderwob (Object: permission_settings) File /usr/share/zope/lib/python/AccessControl/Role.py, line 182, in permission_settings (Object: ApplicationDefaultPermissions) File /usr/share/zope/lib/python/AccessControl/Role.py, line 177, in <lambda> TypeError: (see above) that was problem number one. problem number two. I\'d like to take the contents of a variable, and they being the name of an image object, render it on the web page as an IMG SRC, just like a <dtml-var image_id>. I know this could be done with external python scripts and eval. But so far all i get is integeroverflows. any ideas? please cc: me because I\'m a little bit busy. Thanks =) ---------------------------------------------------------- Universidad Federico Santa Maria - Campus Guayaquil Enviado por: www.usm.edu.ec/computacion

1 0

LoginManager and SSL client authentication
by Mayers, Philip J 16 Dec '00

16 Dec '00

All, LoginManager is now working well... We've got a bespoke application for storing our (very large) user account database here. One field a user can have is a crypted unix password (which I'm currently using to authenticate users). The other thing that can exist is the Subject or SubjectAltName of an SSL certificate suitable for client web authentication. I'd like some users (who are *not* technically strong) to have access to the web frontend without having to type a password - they have had a visit from a member of staff to install a client certificate, and just "point and go". How would I go about making LoginManager authenticate them on the basis of the certificate subject? Apache will validate the certificate for me (by passing a valid CA cert to it's configuration) and I'm running over PCGI, so by the time we get into Zope, we can "TRUST" the SSL_CLIENT_S_DN and SSL_CLIENT_I_DN values passed in. What's the next step? Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+

3 2

Re: [Zope] sql query results -> DTML method problem
by Pavel V. Piankov 16 Dec '00

16 Dec '00

>#8 <dtml-in expr="findClassTitle(code=52.139)"> you might wanna try either <dtml-in expr="findClassTitle(code=_['class_code'])"> or <dtml-in expr="findClassTitle(code=_.getitem('class_code'))"> ><dtml-in expr="findClassTitle(code=<dtml-var class_code>)"> *** syntax >error regards. -- pashah

1 0