- Zope-Dev - Zope lists

BTW: CalendarTag
by Jason Spisak 16 Jul '99

16 Jul '99

Kent, >They are getting > set, but the new values aren't always being retained in the object. > They are reverting back to an earlier value with each bobo_traverse > call except the very first one... As in I can only set the variable > one time and have it retained. Truly strange. Sounds like a caching effect of some kind. I'm not that with traversing. It's get me caught up. I ask, "where the heck is it getting that from the namespace?" Oh, BTW, I was futzing with the CalendarTag and found this. Just a heads up. I love the CalendarTag, I thought you should know :). With the ZCatalog it makes for a powerful scheduler. Anyway, I test to see if the day on the calendar is the same as a the day value of a calendar_date property. It worked like a charm in Zope 1.10, but I get a 'tuple' object AttributError in Zope 2. I'm not sure if this is the DateTime module, or the CalendarTag so I sent it to the list as well. Error Type: AttributeError Error Value: 'tuple' object has no attribute 'dayOfYear' <snip> File /home/mike_weltz/Zope/lib/python/DocumentTemplate/DT_In.py, line 689, in renderwob (Object: Catalog(recruiter=AUTHENTICATED_USER.getUserName())) File /home/mike_weltz/Zope/lib/python/DocumentTemplate/DT_Util.py, line 315, in eval (Object: calendar_date.dayOfYear()==date.dayOfYear()) File <string>, line 0, in ? File /home/mike_weltz/Zope/lib/python/DocumentTemplate/DT_Util.py, line 128, in careful_getattr AttributeError: (see above) All my best, Jason Spisak webmaster(a)mtear.com

1 0

BTW: CalendarTag
by Jason Spisak 16 Jul '99

16 Jul '99

Kent, Oh, BTW, I was futzing with the CalendarTag and found this. Just a heads up. I love the CalendarTag, I thought you should know :). With the ZCatalog it makes for a powerful scheduler. Anyway, I test to see if the day on the calendar is the same as a the day value of a calendar_date property. It worked like a charm in Zope 1.10, but I get a 'tuple' object AttributError in Zope 2. I'm not sure if this is the DateTime module, or the CalendarTag so I sent it to the list as well. Error Type: AttributeError Error Value: 'tuple' object has no attribute 'dayOfYear' <snip> File /home/mike_weltz/Zope/lib/python/DocumentTemplate/DT_In.py, line 689, in renderwob (Object: Catalog(recruiter=AUTHENTICATED_USER.getUserName())) File /home/mike_weltz/Zope/lib/python/DocumentTemplate/DT_Util.py, line 315, in eval (Object: calendar_date.dayOfYear()==date.dayOfYear()) File <string>, line 0, in ? File /home/mike_weltz/Zope/lib/python/DocumentTemplate/DT_Util.py, line 128, in careful_getattr AttributeError: (see above) All my best, Jason Spisak webmaster(a)mtear.com

1 0

Re: [Zope] Tiny Table Zope 2
by Jason Spisak 16 Jul '99

16 Jul '99

Kent, > Thanks for the info. You bet. >I can probably fix, > but it would be with the new TinyTables, which is utterly and > completely different than the old stuff. I use it just to store long select lists, so that probably wouldn't be affected. I'm sure the Zope world would love a Zope 2 compatible TinyTables, since I know everybody uses it for something ;) It's just so perfect for so many little jobs! All my best, Jason Spisak webmaster(a)mtear.com

1 0

DA Update: BLOBs
by Christopher Petrilli 16 Jul '99

16 Jul '99

Gang, A few people have brought up the support, or lack of support, for BLOBS in the Zope DA products. This is something we're acutely aware of, and we have a customer now who will probably require support for a project we are doing for them. This means we're beginning to deal with the issues surrounding implementing support, which include: * Support for statement handles * Passing data by reference * Extensions to the sqlvar tag These are all interrelated because of some quoting rule issues. One of the details you will probably see introduced at the same time, is a couple of new fmt options for sqlvar: <dtml-sqlvar foo fmt=varchar> <dtml-sqlvar foo fmt=varbin> These are taken from the ODBC standard, and are probably the most agnostic of options available. It is important to distinguish between text and binary BLOBs because of the nature of statement handles. What are statement handles you ask? Well, quite simply, they are pre-digested SQL queries that are held on the server side (somewhat like anonymous stored procedures, but they don't survive connections). You can then call them, substituting data in by reference. This allows you to pass in large quantities of data in a clean manner. It also allows you to go through the query parser and optimizer once, rather than each time. What is the implication of this? Well, it means that there will probably be some new options on ZSQLMethods that you can set. One of them will be "hold as statement handle" which will only be possible on methods which have SQL components which have *nothing* but <dtml-sqlvar> statements in them. Anything else, any OR or AND processing and it no longer becomes feasible. The check-box will be a suggestion to the connection to hold it, but the connection can choose to ignore this if it isn't supported, or if by some reason, the number of handles allowed is already exceeded. Thoughts? Chris -- | Christopher Petrilli Python Powered Digital Creations, Inc. | petrilli(a)digicool.com http://www.digicool.com

1 0

Re: [Zope-dev] External Method creation of ZClass instances
by michel＠digicool.com 16 Jul '99

16 Jul '99

Jason Spisak <webmaster(a)mtear.com> writes: > Zope Gang, > > I am was using this external method it import the properties of a ZClass > instance and create it from a flat text file. It worked fine under Zope > 1.10, but now I am > trying like a bear to get it to jive with Zope 2, and failing miserably. > I'm just offering it up > in case anybody sees anything obvious that I missed. I can create these > objects fine in the management interface using the same methods, and I > am using the same import files as I did before. > > <snip> > > > The index_object method a add it to the Catalog. I'll still be trying > to figure it out long after the sun goes own and comes up again. Many > thanks to all in advance. > Something similar (but much simpler) works for me, how exactly does this fail for you? > All my best, > > Jason Spisak > webmaster(a)mtear.com > > _______________________________________________ > Zope-Dev maillist - Zope-Dev(a)zope.org > http://www.zope.org/mailman/listinfo/zope-dev > > (For non-developer, user-level issues, use the companion list, > zope(a)zope.org, http://www.zope.org/mailman/listinfo/zope )

1 0

Reading Oracle BLOB
by Marcin Kolbuszewski 16 Jul '99

16 Jul '99

Hi! I am brand new to Zope - and have a question: How can I get an Oracle BLOB into Zope. I know it can be done with DCOracle, but Zope returns nothing when you ask for content of a column of type BLOB? Marcin Kolbuszewski

1 0

External Method creation of ZClass instances
by Jason Spisak 16 Jul '99

16 Jul '99

Zope Gang, I am was using this external method it import the properties of a ZClass instance and create it from a flat text file. It worked fine under Zope 1.10, but now I am trying like a bear to get it to jive with Zope 2, and failing miserably. I'm just offering it up in case anybody sees anything obvious that I missed. I can create these objects fine in the management interface using the same methods, and I am using the same import files as I did before. import string def import_candidate(self,file,REQUEST,RESPONSE,URL2): """ External Method to import Candidate data and build Candidate objects. file is a tab delimited file object (obtained from a file upload form). The file schema is: ID,FIRST_NAME,LAST_NAME,COMPANY,ADDRESS,CITY,STATE,ZIP,WORK_AREA_CODE,HOME_AREA_CODE, WORK_PHONE,HOME_PHONE,WORK_EXT,TITLE,RECRUITER,SKILLS,SKILLS,SKILLS,SALARY,SKILLS, SKILLS,SKILLS,SKILLS,CONTRACTOR,EMAIL,WAGNER,CREATE """ added=0 failed=[] while 1: line=file.readline() if line=="": break fields=string.split(line,'\t') id=fields[0] first_name=fields[1] last_name=fields[2] company=fields[3] address=fields[4] city=fields[5] state=fields[6] zip=fields[7] work_area_code=fields[8] work_phone=fields[10] work_ext=fields[12] home_area_code=fields[9] home_phone=fields[11] title=fields[13] recruiter=fields[14] skills="%s %s %s %s %s %s %s" % (fields[15], fields[16], fields[17], fields[19], fields[20], fields[21], fields[22]) salary=fields[18] contractor=fields[23] email=fields[24] wagner=fields[25] create=fields[26] if id=='ID': continue # bogus first line #try: REQUEST.set('id',id) REQUEST.set('first_name',first_name) REQUEST.set('last_name',last_name) REQUEST.set('current_company',company) REQUEST.set('address',address) REQUEST.set('city',city) REQUEST.set('state',state) REQUEST.set('zip',zip) REQUEST.set('work_area_code',work_area_code) REQUEST.set('work_phone',work_phone) REQUEST.set('work_extension',work_ext) REQUEST.set('home_area_code',home_area_code) REQUEST.set('home_phone',home_phone) REQUEST.set('title',title) REQUEST.set('recruiter',recruiter) if salary: REQUEST.set('salary',salary) else: REQUEST.set('salary',0) REQUEST.set('contractor',contractor) REQUEST.set('email_address',email) REQUEST.set('skills',skills) REQUEST.set('wagner',wagner) REQUEST.set('fax_phone','') REQUEST.set('fax_area_code','') REQUEST.set('fax_extension','') REQUEST.set('pager_phone','') REQUEST.set('pager_area_code','') REQUEST.set('pager_extension','') REQUEST.set('cell_area_code','') REQUEST.set('cell_phone','') REQUEST.set('resume_in',1) if create: REQUEST.set('create_date',create) else: REQUEST.set('create_date','1999/05/17') REQUEST.set('resume','/home/jason/resumes/' + id + '.html') method=self.manage_addProduct['Candidate'].CandidateClass_add method(method,REQUEST=REQUEST,RESPONSE=RESPONSE, DestinationURL=lambda url=URL2: url) added=added+1 #except: # failed.append(title) return """<html> Added %d candidates. Failed to add: %s </html>""" % (added, string.join(failed," ")) The Candidate meta_type is created by a Factory for a ZClass. The CandidateClass_add is the constructor, and it looks like this:     The index_object method a add it to the Catalog. I'll still be trying to figure it out long after the sun goes own and comes up again. Many thanks to all in advance. All my best, Jason Spisak webmaster(a)mtear.com

1 0

Re: [Zope-dev] ZClass Meta Types
by Kevin Dangoor 15 Jul '99

15 Jul '99

Here are what I think should be reproduceable steps that illustrate the problem that I mentioned (delete a ZClass and the Meta Type still shows up): 1) Create a new Product 2) Create a ZClass in that Product that subclasses Object Manager 3) Create a ZClass in that ZClass. For me, after I fill out the ZClass form and click Add, the screen display doesn't change. But, the ZClass *is* added. 4) Select a couple of Subobject types for the Step 2 ZClass. 5) Delete that ZClass created in step 3 6) Add an object to the hierarchy of step 2's ZClass. 7) Inside that object, you should be able to add a Step 3 ZClass, despite the fact that the class has been deleted. So, there's really two bits of bug-like behavior. The unusual "Add" button behavior in step 3, and the persistence of the Metatype for that ZClass. I must say, though, that to me the ZClass/ZCatalog way of doing things is the coolest thing I've seen since Zope itself. Kevin _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

2 1

Re: [Zope-dev] ZClass Meta Types
by Kevin Dangoor 15 Jul '99

15 Jul '99

I have noticed a (most likely) related problem. If I add a ZClass and then delete it, its meta type still shows up in the menus. Kevin --- Jason Spisak <webmaster(a)mtear.com> wrote: > Zopists, > > When I add a New ZClass and then Change it's > meta_type name, that > changes doesn't take place in the pull down add > menus. even after a pack > and restart. Anybody else experienceing that? It > changes in the Basic > tab, but it doesn't really change. > > Jason Spisak > webmaster(a)mtear.com > > _______________________________________________ > Zope-Dev maillist - Zope-Dev(a)zope.org > http://www.zope.org/mailman/listinfo/zope-dev > > (For non-developer, user-level issues, use the > companion list, > zope(a)zope.org, > http://www.zope.org/mailman/listinfo/zope ) > > > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

2 1

RE: Catalog
by Michel Pelletier 15 Jul '99

15 Jul '99

> -----Original Message----- > From: Jason Spisak [mailto:webmaster@mtear.com] > Sent: Thursday, July 15, 1999 4:16 PM > To: Michel Pelletier > Cc: zope-dev(a)zope.org > Subject: Re: Catalog > > > Michel, > > Howdy. When asking for objects out of the Catalog the > following doesn't > process the second parameter. It gives me all objects with the id that > is the same as the user's name. Is there another syntax for narrowing > it down? > > {'id' : AUTHENTICATED_USER.getUserName()},{'meta_type' : 'Employee'} It should just be one mapping with two keys, not two one key mappings: {'id' : AUTHENTICATED_USER.getUserName(), 'meta_type' : 'Employee'} > > Also, did you get that mail about the import scripts? I haven't had a chance to reproduce it yet, I will get to it however. -Michel > > All my best, > > Jason Spisak > webmaster(a)mtear.com >

2 1