August 2003 - Zope - Zope lists

LocalFS - large files / broken connections
by David Siedband 17 Aug '03

17 Aug '03

I'm using LocalFS as a repository for uploading files. Many files are relatively large, perhaps in the 10-20 Meg range. Is the file cached by Zope and then written to the filesystem all at once or is it written to the filesystem in incrementally? From the product code below, it looks like it it writing directly to the path location... What happens if someone is uploading a file and their net connection is broken? How would this be handled? Could this result in a partial file being cached somewhere that needs to be purged or perhaps a write process that needs to be killed off? Thanks, -- David Here's what I think is the relevant code from the product... def manage_upload(self, file, id='', action='manage_workspace', REQUEST=None): """Upload a file to the local file system. The 'file' parameter is a FileUpload instance representing the uploaded file.""" if hasattr(file,'filename'): filename=file.filename else: filename=file.name if not id: if '/' in filename: id=filename[string.rfind(filename,'/')+1:] elif '\\' in filename: id=filename[string.rfind(filename,'\\')+1:] elif ':' in filename: id=filename[string.rfind(filename,':')+1:] else: id=filename try: self._checkId(id,1) except: raise 'Upload Error', MessageDialog( title='Invalid Id', message=sys.exc_value, action ='manage_main') path = self._getpath(id) if os.path.exists(path): self.manage_overwrite(file, path, REQUEST) else: self._write_file(file, path) if REQUEST: return MessageDialog( title='Success!', message='Your file has been uploaded.', action=action)

2 1

Missing Variable
by Simon Faulkner 17 Aug '03

17 Aug '03

How can I make a variable default to a value? if country is passed in my the URL (show_depot?country=France) then request/country is France and that's great but if the ZPT is called with no country ie just it's URL show_depot then I would like to set a variable country="Manager" Any pointers... Simon

2 1

How do I exclude a specific item from a tal:repeat
by Jordan Carswell 17 Aug '03

17 Aug '03

How do I exclude a particular item from being returned from the following statement. I have a file i use with a particular name and I don't want it to show up in my listing... tal:repeat="obj python:here.getFolderContents(suppressHiddenFiles=1)" Any suggestions are gratefully accepted! Jordan Carswell, Web Graphic Designer Houston Community College-Northwest

3 2

management process does not work for me
by Marcus Bergmann 17 Aug '03

17 Aug '03

Hello, the management process which restarts Zope after a crash does not work for me. On Unix the default behaviour is to create a management process if the option '-Z1' or '-Zyes' in the 'start' script is not given. My Zope instance wasn't restarted after a crash and I can't find such a process after a restart by hand. To get sure, I added '-Zyes' to the 'start' file and restarted Zope once again. But 'ps -efa' shows only the normal Zope processes. Zope version: 2.6.1 OS: SunOS 5.8 Anyone got an idea? Thanks, Marcus P.S. Sorry, our webmailer doesn't supports reply-to ;-(

1 0

zsqlmethod and inserting count(*) value blues
by Iñigo Serna 17 Aug '03

17 Aug '03

Hi, I have a problem with a zsqlmethod. In mysql client command line next works: ------------------ mysql ------------------- mysql> select @n := count(*) from tbl; mysql> insert into tbl2 values (@n+1, 'data'); -------------------------------------------- But This identical zsqlmethod does not: ---------------- ZSQLMETHOD ---------------- select @n:= count(*) from tbl; insert into tbl2 values (@n+1, 'data'); -------------------------------------------- This is the error message I get: ------------------ Error ------------------ Error, _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';\ninsert into tbl2 values ( @n + 1, 'data)' ; ________________________________________________________________________ -SQL used: select @n:=count(*) from tbl; insert into tbl2 values (@n+1, 'data'); -------------------------------------------- I've achieved the functionality I want with next code: ---------------- ZSQLMETHOD ---------------- insert into tbl values ( <dtml-var "_.len(getMessages()) + 1">, 'data' ) -------------------------------------------- where getMessages is a simple zsqlmethod containing "select * from tbl", but I suppose there is a better way to do it. Any ideas? Thanks in advance, Iñigo Serna PS: I'm using next versions: Linux 2.4.20, Zope 2.6, MySQL-4.0.14, MySQL-python 0.9.2

2 1

jokes
by Raymond & Carol Wakefield 17 Aug '03

17 Aug '03

I would like to get joke from you. Thanks

1 0

More failed attempts with python
by Bill Hewitt 17 Aug '03

17 Aug '03

Hello again folks... Below is what I have written in attempting to dynamically construct a variable name, then retrieve the value of the variable from the namespace in python. If anyone can tell me how, I'd appreciate it... WPH ----------------------------------------------------------- # Example code: # Import a standard function, and get the HTML request and response objects. from Products.PythonScripts.standard import html_quote request = container.REQUEST RESPONSE = request.RESPONSE # Here I am trying to # dynamically generate a property name (b) from a parameter called type and a string "color" newstring="%scolor" % (type) # Next I want to # retrieve the *value* for preferredcolor by evaluating the string I created in the variable newstring # I cant seem to get this to work...... preferredcolor=container.newstring # finally I print.... print type+" {" print " background-color:"+preferredcolor+";" print " background-image: url(\"" print " background-repeat: " print " font-family: " print " color: " print " font-size: " print " margin-top: " print " margin-bottom: " print " margin-left: " print " margin-right: " print " }" return printed -------------------------------------------------------------

2 1

Returning the parent of a document
by hpinson＠indepthl.com 16 Aug '03

16 Aug '03

In Page Templates, how would I return the parent object, in this case a folder, of getURL results? For example: <a href="#" tal:attributes="href result/getURL" tal:content="result/title">Item Title</a> returns - 'http://mysite.org/myfolder/content.htm' What I need returned is the URL of the folder that contains this document, which is: 'http://mysite.org/myfolder' Thanks for any ideas. Harlow Pinson Indepth Learning Email: hpinson(a)indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678

1 0

Connection pooling in Mysql
by Dennis Allison 16 Aug '03

16 Aug '03

It's beginning to look like I need to do connection pooling for MySQL. A quick google turned up mxODBC from www.egenix.com which looks on-point but has a fairly hefty license fee for our systems organization ($100/zope instance). Anyone have any experience with the product? What other products are available? Also, wht's the threading behavior of the current MySQL database adaptors? I assume that database transactions are handled as critical sections and so threads block concurrent transactions. Is that correct? (Andy ... )

1 0

How do I get DocumentTemplate to work?
by Bill Hewitt 16 Aug '03

16 Aug '03

I'm trying to switch over to python from DTML...... I've got a python Script (to see what DocumentTemplate does) that looks like the following: from DocumentTemplate import HTML template_source = """ <html> <head> <title> <dtml-var title_or_id></title> </head> <body> <dtml-var content> </body> </html> """ template_method = HTML(template_source) results = template_method(title="ThisDocument!", content="This is cool!!!!" ) But, when I try to run it, I get: Error Type: ImportError Error Value: import of "HTMLFile" from "DocumentTemplate" is unauthorized. You are not allowed to access HTMLFile in this context What is it I'm doing wrong? TIA, WPH

2 1