- Zope - Zope lists

Re: [Zope] How can I upload files to mySQL
by Dieter Maurer 20 Jun '00

20 Jun '00

> I am using Zope and mySQL and want to load up text and Images to text or = > blob fields. > > How can I upload file content to TEXT (plain text)=20 > and BLOB (images: jpg, gif) using DTML? I can answer only part of your question. Uploaded files are "ZPublisher.FileUpload" objects which you can find in the REQUEST object under the form field name. They have a "read" method returning the content as a string. Placing the string into a text field should be straight forward (same way you did it up to now). I do not know, how MySQL wants to receive BLOB values, though. Dieter

1 0

Re: [Zope] sifting through python sub-objects
by Dieter Maurer 20 Jun '00

20 Jun '00

ed colmar writes: > I've succesfully gotten the catalog to work (thanks everyone!), but in > doing so, I've created a problem. Squishdot uses this code like this in > order to add an item: > > id=self.createId() # make a datestamp id > msg=PromoterPost(id,title) > msg=msg.__of__(self) # ??? > self.setItem(id,msg) # set the item > > This code is incompatible with the catalog. As far as I can tell because > The catalog likes to see id's as strings, As far as I know the sources, ZCatalog expects its fields to be either simple objects (strings, numbers, dates, ...) or be callable with the result a simple object. > but I don't think the object gets > completely added to the zope fs either. What does that mean? > After changing the code that does > the adding to the zope fs everything related to the catalog seems good. > Here's the new code: > > ob=PromoterPost(id,title) > ob.id = id > ob.title = title > > self._setObject(id,ob) > self.getCatalog().catalog_object(ob,id) I would expect that "_setObject" stores the association "id -> ob" somewhere. I assume, a Python dictionary is used for this purpose. Squishdot probably uses a BTree instead, because is can handle a big number of content objects more efficiently than a Python dict. > So here's the problem, the methods that squishdot uses to locate > sub-objects relies on a BTree() type method, called "data", and is used by > a few methods like this: > > def objectValues(self): > """ return list of subobjects """ > return map(lambda x, p=self: x.__of__(p), self.data.map(self.ids)) > or > > def is_local_user(self, thisuser): > """ returns true with ID if user is a local user > based on rev_id_list in squishdot > """ > rlist = map(None,self.ids) > rlist = filter(lambda x,p=self : p.data[x].validated, rlist) > rlist = filter(lambda x,p=self : p.data[x].meta_type == > 'SRPersonPost', rlist) > rlist = filter(lambda x,p=self,s=thisuser : p.data[x].title == s, > rlist) > return rlist > > Neither return any results, becuase in the new code, the data object is > not getting updated. Do I need to keep a record of all the ids like > squishdot does, or can I leave that up to zope? Use the BTree, if you want to use major parts of Squishdot. Otherwise, you must use methods from the same place you have taken "_setObject" from. I am sure, the class will have "objectValues" and "objectIds", too. And I expect, there will be some form of "_getObject" (probably named differently) to access the object corresponding to an "id". Have a look at the Object Reference in the Zope documentation. Dieter > > It seems like there should be an easier way than "self.data" to do this... > > Any ideas? > >

1 0

Re: [Zope] scared
by Rik Hoekstra 20 Jun '00

20 Jun '00

>I have reinstalled zope and zodb, and copied the data.fs across. It was >about two days old. All the changes that I had made were gone. Luckily I >made a backup of my app yesterday by exporting it. > >I must have a bad understanding of how this works. I had imagined that >everytime I hit CHANGE, that the data.fs file would have been updated. It should > >When the computer crashed where were all my current changes? Is there a >temp file I might be able to recover, as I am still missing quite a few >hours work! THis never happened to me before, but it did yesterday (zope 2.1.4 on Win95) ! This seems like a bug. As for your error: I have had to throw away a corrupted (read: one that couldn't be opened) logfile before on NT. It made it possible to restart Zope again. I have wondered what strange corruptions could happen to a logfile, but apparently this may happen at times (especially if the logfile is getting big) hth Rik

1 0

Re: [Zope] brain hurts regarding dynamic fcn args in Python
by Dieter Maurer 20 Jun '00

20 Jun '00

Jeff Sasmor writes: > Is there a (straightforward?) way to dynamically compose function > argument lists? For example, in C, you can write" > > f(arg1, arg2, (conditional expression)?(val for TRUE state):(val for FALSE state)). Others have pointed out, that you can use "and" and "or" to emulate "? ... : ...". Be careful, there are dangers, because the emulation is not faithful. > In my case here in Zope, sometimes I have to search a ZCatalog > prior to displaying the results in a <dtml-in> looping construct. > > <dtml-in > "Catalog.searchResults(meta_type='EventDoc',event_date=[first,last],event_date_usage='range:min:max',sort_on='event_date > ')"> > > .... > </dtml-in> > > > Now if the 'moderated' property is active I want to add the keyword arg > > reviewed='on' > > to the arg list at the time that the searchResults method is invoked. In some cases, you could use: ...(..., reviewed= moderated and 'on', ...) This will define "reviewed". It will have a Python "false" value if moderated is "false", otherwise the value 'on'. If your function uses code like: "if kw.has_key('reviewed') and kw['reviewed': ..." this will work. If the second and term is missing, if won't. I do not know, what code ZCatalog uses. Try it out or look into the source. Dieter

1 0

Re: [Zope] Internationalization 2nd post
by Rik Hoekstra 20 Jun '00

20 Jun '00

>How are my fellow Zopers handling Internationalization, especially text. > >We have a site that is composed of several hunderd pages. We don't use >classes but we have made heavy use of aquistion though. For example we >have one back button that is aquired thoughout the site etc etc. >Basically if the functionality (or code) is used in more than one place >it has been but into a method and aquired. > >Any thoughts or hints? You could use a number of different 'language specific' folders and make your site acquire from them. There is a caveat, however, because you have to be careful to use acquisition in this way. There is a bit of information in my Changing Contexts in Zope 2 http://www.zope.org/members/Hoekstra/ChangingContexts1 hth Rik

1 0

LocalFS cross platform bug
by Dan L. Pierson 20 Jun '00

20 Jun '00

If you upload from a browser on a Windows machine to a server running on Linux, the id (and thus the file name) of the new file will be the complete Windows path instead of just the file name. This happens because os.basename on Linux doesn't know how to handle Windows pathname syntax. Here's a rather crude diff -u patch that works for me: --- LocalFS.py-orig Fri Apr 14 00:36:06 2000 +++ LocalFS.py Thu Jun 15 15:36:19 2000 @@ -625,10 +625,16 @@ "to this directory.<p>") else: raise + def _canonicalize_pathname(self, path): + if (string.count(path, '\\')): + if (len(path) > 1 and path[0] in string.letters and path[1] == ':'): + path = path[2:] + path = string.translate(path, string.maketrans('\\', '/')) + def manage_upload(self, file, REQUEST=None): """Upload a file to the local file system. The 'file' parameter is a FileUpload instance representing the uploaded file.""" - id = os.path.basename(file.filename) + id = os.path.basename(self._canonicalize_pathname(file.filename)) path = self._getpath(id) data = file.read(_test_read) if (find_binary(data) >= 0):

3 10

Re: [Zope] Need to use a 'date' data type in sqltest
by Dieter Maurer 20 Jun '00

20 Jun '00

Jones, David H writes: > I need to include a test of a date in a DTML variable referenced in a sqltest tag in ZSQL. From reading documentation and testing, it does not appear that the 'date' data type is supported. As fas as I know, SQL databases vary greatly in the representation of times and dates. If your database accepts string representations for date fields, you could use an "dtml-var" (rather than "dtml-sqltest") with an appropriate "fmt" argument. Dieter

1 0

Re: [Zope] TAG for file date
by Dieter Maurer 20 Jun '00

20 Jun '00

CURTIS David writes: > I have a database file that gets copied via a cron job at night. I would to display the new the new file date in an htlm document using Zope. What I would like is a tag that displays the date of a specific file. Is there such a dynamic tag? I am thinking something like <File-tag>copied-file</File-tag> > Any help would be apprechiated. You probably will need an external method -- at least, if you speak about a file in the file system and not an object in the ZODB. The Python module "os" contains the function "stat" that allows you to access the modification time. You may want to have a look at the Python module "time" or the Zope module "DateTime.DateTime" for ways to format the time you got with "stat". Dieter

1 0

Creating a ZClass within a folder
by Aaron Payne 20 Jun '00

20 Jun '00

Hi all, I am trying to create a zclass instance within a newly added folder. Here is the sequence of events 1. get name from a form, vendor 2. add a folder with id of vendor 3. within the new folder create a CouponProduct The following add method (snipped) puts the zclass instance at the same level as the new folder and not inside of it. Note: merchants is a folder containing all of the vendor folders. The add method is at the same level as the merchant folder. <dtml-with merchants> <dtml-call "merchants.manage_addFolder(vendor,'',1)"> <dtml-with "vendor"> <dtml-with "manage_addProduct['CouponProduct']"> <dtml-call "REQUEST.set('id',`ZopeTime().timeTime()`)"> <dtml-call "CouponProductZClass_add(_.None, _, noRedirect=1)"> </dtml-with manage_addProduct--> </dtml-with vendor> </dtml-with merchants> Peacefully, Aaron

1 0

Internationalization 2nd post
by Dan Rusch 20 Jun '00

20 Jun '00

How are my fellow Zopers handling Internationalization, especially text. We have a site that is composed of several hunderd pages. We don't use classes but we have made heavy use of aquistion though. For example we have one back button that is aquired thoughout the site etc etc. Basically if the functionality (or code) is used in more than one place it has been but into a method and aquired. Any thoughts or hints? thanks, DR

2 1