January 2000 - Zope - Zope lists

Sybase: patch for handling DECIMAL data type (Invalid buffer element type)
by Hung Jung Lu 14 Jan '00

14 Jan '00

Hi, I will recap here the problem with SybaseDAv2 regarding the handling of DECIMAL data type, this is the source of the "Invalid buffer element type" error that I found. Right now the database adapter is crashing for DECIMAL data types that are integers with precisions higher than 9 digits. (For DECIMAL data types that are integers with precisions less or equal than 9 digits, the adapter converts them into INT data type, and there will be no problem.) To fix this glitch, I had to modify two files in the SybaseDAv2 distribution. (The current release is v2.0.0b1, http://www.zope.org/Products/DA/SybaseDA/) (1) Follow the instructions till you have done the command make -f Makefile.pre.in boot (2) Edit the file SybaseDAv2/src/sy_occbf.c near the place where it says "Invalid buffer element type", insert another case statement for the CS_DECIMAL_TYPE. The result should look like: case CS_DATETIME4_TYPE: element_size=sizeof(CS_DATETIME4); break; case CS_NUMERIC_TYPE: element_size=sizeof(CS_NUMERIC); break; case CS_DECIMAL_TYPE: element_size=sizeof(CS_NUMERIC); break; case CS_BIT_TYPE: element_size=sizeof(CS_BIT); break; case STRING_CASES: break; default: return SybaseError("Invalid buffer element type"); } (3) Proceed with the instructions and issue the make command, and move the sy_occ.so library a level up to your SybaseDAv2 directory. Follow all other instructions of the README.txt file provided with the distribution. (4) You will also need to edit the SybaseDAv2/db.py file. Search for the lines that say: if string_type(t): v=rstrip(buf[:cop[0]]) elif t is sy_occ.CS_NUMERIC_TYPE: and change the elif line to: elif t in (sy_occ.CS_NUMERIC_TYPE, sy_occ.CS_DECIMAL_TYPE): (5) Restart your Zope. And hopefully this solves your problem with the DECIMAL database. At least this is how fixed my problem. :) I guess SybaseDAv2 needs more people's feedback. Right now it seems to have a some problems. regards, Hung Jung ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0

Epoch time use
by coder＠kanga.nu 14 Jan '00

14 Jan '00

How do I: a) Get the time in terms of seconds from the epoch (standard unix time_t ala 1970)? b) Translate a time_t value under Zope into human readable ala ctime() or DateTime? I don't see that the DateTime class can do this per the DTML guide and I have an external DB that relies on time_t based indexing. Do I really have to write an external method? -- J C Lawrence Internet: claw(a)kanga.nu ----------(*) Internet: coder(a)kanga.nu ...Honorary Member of Clan McFud -- Teamer's Avenging Monolith...

1 0

Zope 'source'
by Darcy Clark 14 Jan '00

14 Jan '00

I was curious as to how the manage_workspace and other manage_ methods work, so I am wondering how to view the source for these methods ? Where are they 'stored' ? thanks for any info., Darcy -- --------------------------------------------------- Ph: (734) 764 3377 Email: darcyc(a)engin.umich.edu URL: http://www-personal.engin.umich.edu/~darcyc/ --------------------------------------------------- 'If you're not part of the solution, you're part of the precipitate' ..... Steven Wright

1 0

Re: [Zope] <SELECT> in forms.
by J C Lawrence 14 Jan '00

14 Jan '00

On Fri, 14 Jan 2000 11:30:01 -0700 Guy Davis <davis(a)arc.ab.ca> wrote: > <SELECT NAME="priority" SIZE=7> I just fought with this last night: <SELECT NAME="'priority'" SIZE=7> Notice the extra quote layer. -- J C Lawrence Internet: claw(a)kanga.nu ----------(*) Internet: coder(a)kanga.nu ...Honorary Member of Clan McFud -- Teamer's Avenging Monolith...

1 0

Re: [Zope] Organizing Zope Content
by James W. Howe 14 Jan '00

14 Jan '00

Anything's possible. It's too soon to tell at this point, however. I would certainly like to if it shakes out (and if management approves). At 01:16 PM 1/14/00 -0800, you wrote: >Are you thinking about making this available as a product? > >-jfarr > >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Hi! I'm a signature virus. >Copy me into your .sig to join the fun! >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > >----- Original Message ----- >From: James W. Howe <jwh(a)allencreek.com> >To: <zope(a)zope.org> >Cc: Maik Roeder <roeder(a)berg.net> >Sent: Friday, January 14, 2000 1:04 PM >Subject: RE: [Zope] Organizing Zope Content > > > > Following some advise from Maik and Michel concerning ways to organization > > my Zope content to support a news web site I think I'm evolving toward a > > solution that I like. I would like to explain it here a little bit just to > > get feedback. > >[snip] > James W. Howe mailto:jwh@allencreek.com Allen Creek Software, Inc. pgpkey: http://ic.net/~jwh/pgpkey.html Ann Arbor, MI 48103

1 0

RE: [Zope] Arguments to DTML methods
by Michel Pelletier 14 Jan '00

14 Jan '00

> -----Original Message----- > From: coder(a)kanga.nu [mailto:coder@kanga.nu] > This is pretty hokey, especially when I invoke "custom_segment" half > a dozen times in a single template or method. Is there a better > way to fake passing arguments to a DTML method? You don't need to fake it, because all DTML objects _can_ be passed arguments. <dtml-var "aMethod(aMappingObject, aClient, arg1, arg2...)"> 'aMappingObject' is a mapping containing the current 'namespace', or the namespace you want this method to use. This is often '_' (the current DTML namespace) 'aClient' is an object you want to provide the namespace for this method. This is often '_.None' (no client object) They rest are all keyword arguments. This is the most common usage: <dtml-var "aMethod(_, _.None, bob='uncle')"> Note the double quotes, they are important. -Michel

1 0

Re: [Zope] Arguments to DTML methods
by J C Lawrence 14 Jan '00

14 Jan '00

On Fri, 14 Jan 2000 16:24:48 -0500 Michel Pelletier <michel(a)digicool.com> wrote: >> From: coder(a)kanga.nu >> This is pretty hokey, especially when I invoke "custom_segment" >> half a dozen times in a single template or method. Is there a >> better way to fake passing arguments to a DTML method? > You don't need to fake it, because all DTML objects _can_ be > passed arguments. Ahh. Is this buried in the DTML guide or am I going blind? I read that thing three times last night looking... > <dtml-var "aMethod(aMappingObject, aClient, arg1, arg2...)"> Excellent. > They rest are all keyword arguments. This is the most common > usage: > <dtml-var "aMethod(_, _.None, bob='uncle')"> > Note the double quotes, they are important. Thanks. I just got bit on that point last night in using a dtml-let to assign a string to a variable. It wasn't obvious from the DTML guide that I needed to nest single quotes in a double quotes ala: <dtml-let variable="'text'"> -- J C Lawrence Internet: claw(a)kanga.nu ----------(*) Internet: coder(a)kanga.nu ...Honorary Member of Clan McFud -- Teamer's Avenging Monolith...

1 0

Epoch time use
by Jerry 14 Jan '00

14 Jan '00

I should have mentioned : ZopeTime() There have been several messages re. to this topic, timezone issues, and GMT (Greenwich Mean Time) in the last few days. Scan up the list to get some ideas. Even though the title doesn't seem related, some of the "REQUEST.set not incrementing" messages have ZopeTime examples. Later, Jerry S.

1 0

RE: [Zope] Organizing Zope Content
by Maik Roeder 14 Jan '00

14 Jan '00

Hi ! I would propose using ZClasses from the start for your project. > > I'm looking for ideas on how to structure my content. For > > example, one of > > my pages needs to display headlines with little snippets of > > the article > > itself. Clicking the headline would cause the full article to > > display. You have the domain object article. A newsitem is just a view on the articles. Articles should be contained in a controller you can call something like ArticleFolder. > > What I want to be able to do is build a structure > > such that I > > could iterate over items, pick up headlines, and generate the > > headlines > > page dynamically. You can create a Folder on your site like "News". Inside, you use a view created by a ZCatalog to show articles with headlines. > When you have a collection of objects you want to iterate over, it is > useful to put them in a container-like data structure, like a Folder. I would put the Articles inside an ArticleFolder ZClass, in which Article ZClasses are managed. > In your case, I think you can do everything you need by just placing all > of your articles in a Folder. If the folder was called 'Articles' you > could do very simple iterative manipulations using the <dtml-in> tag. > > <ul> > <dtml-in Articles> > <li><a href="<dtml-var absolute_url>"><dtml-var title_or_id></a><br> > <dtml-var sequence-item size=200></li> > </dtml-in> > </ul> If you use ZClasses, this is a view of the ArticleFolder. > This will print a link to each article, showing 200 characters of the > objects body (This assumes your article objects are DTML Documents). I would say that the representation is the task of the Article itself and only partly of the ArticleFolder. The article should be able to create different view on itself based on what type of content it contains. If the Article is html, use the HTML_View, and it it is structured text, the Article uses the Structured_Text_View. > As an added hook point, you can write a DTML method that you pass the > object to: > > <dtml-in Articles> > <dtml-var "displayArticle(_['sequence-item'])"> > </dtml-in> This view method can be placed in an ArticleFolder ZClass. > If you place Articles and displayArticle in your root folder, then they > will be accessable from anywhere in your Zope, all objects in the root > folder are acquireable from all objects in Zope (note, when you drop to > python, you have to play by the rules of the Acquisition mechanism). I don't think it is very nice to clutter the root folder with all kinds if views. It is much nicer to have the views in the appropriate ZClasses. > > It is also a requirement of this site that it can > > display previous editions of the web site. For that I would > > like to be > > able to invoke my headlines in such a way that it could > > generate different > > headlines depending on which issue of the news publication > > was desired. > > Here the catalog can help you. If all of your article objects are > cataloged in a ZCatalog object, then you can do a very fast range search > over all of the objects' creation dates. > This is used on the Zope site > on the advanced search page when you pull down the combo box to do a > range search of objects created after a certain fixed point in the past > (day, week, month, year, ever). If your Articles are ZClasses, then you can perform a Catalog search for all ZClasses with meta_type "Article". You can also search for all ArticleFolders. This is best if you create one ArticleFolder for each issue of your Newspaper. > The problem is that as your articles change, you need to keep cataloging > and recataloging them so that the catalog tracks any changes in the > object. > This is where things get tricky and you start developing an > application, because you need your own kind of object to do that. This > is when you should investigate ZClasses. There's a couple how-tos on > the Zope site on how to make your own kind of catalog aware objects. The ZClasses Article and ArticleFolder would be ZCatalogAware, and when changed they can update the Catalog automatically. > > Any tips on how I might structure my content (basically news > > articles) As I said, you would have an ArticleFolder per edition, or per week or month. > and > > how my presentation layer might be able to utilize the > > content would be > > appreciated. The presentation is handled by the ArticleFolder Views and the Article Views. > Make sure that all your major components are seperated from each other > and use each other without strange dependencies (like assuming a path to > a component, why assume when it can be acquired?). You should make the ArticleFolder intelligent, and the Article dumb. The Article only knows how to provide representations of itself, and the ArticleFolder is responsible for managing the Articles inside. > Keep collections of > similar objects in folders by themselves. Just like Michel says. > It is generally a good idea > to keep methods related to certain types of objects in the same place as > the folder that contains those objects. With ZClasses you don't have these problems. > Use your root folder wisely, Luke. Don't use the root folder, Luke :-) The ideas I have described here are already used by the ZDP-Tools, which I have written for the Zope Documentation Project together with Tom Deprez. http://zdp.zope.org:8080/ZDP/ The site is currently down, so you'll have to check back later. I would like to discuss the design with you, so if you are interested, contact me personally or maybe just add your comments on the ZDP-Tools right on the zdp.zope.org:8080/ZDP/projects/zdptools/ in the Comments Section. Greetings, Maik Röder roeder(a)berg.net

2 1

Re: [Zope] Sybase error: Products.SybaseDAv2.db.Error: ct_command():
by Chris McDonough 14 Jan '00

14 Jan '00

Hung, Please keep the posts on the list... We may have missed a datatype when coding the adapter. This is going over my head, that's for sure. If this is the case, I'd suggest submitting a Collector report on Zope.org about it with all the information you've given so far on the list. We'd very much appreciate it so we can fix it when time allows. In the meantime, change the datatype to something that's supported and see what happens. Sorry and thanks, Chris Hung Jung Lu wrote: > > OK, more information privately. > > The datatype in question is > > CONSTANT(CS_DECIMAL_TYPE); > > which has value 17. This datatype does not appear in sy_occbf.c > > switch(element_type) > { > case CS_TINYINT_TYPE: element_size=sizeof(CS_TINYINT); break; > case CS_SMALLINT_TYPE: element_size=sizeof(CS_SMALLINT); break; > case CS_INT_TYPE: element_size=sizeof(CS_INT); break; > case CS_REAL_TYPE: element_size=sizeof(CS_REAL); break; > case CS_FLOAT_TYPE: element_size=sizeof(CS_FLOAT); break; > case CS_MONEY_TYPE: element_size=sizeof(CS_MONEY); break; > case CS_MONEY4_TYPE: element_size=sizeof(CS_MONEY4); break; > case CS_DATETIME_TYPE: element_size=sizeof(CS_DATETIME); break; > case CS_DATETIME4_TYPE: element_size=sizeof(CS_DATETIME4); break; > case CS_NUMERIC_TYPE: element_size=sizeof(CS_NUMERIC); break; > case CS_BIT_TYPE: element_size=sizeof(CS_BIT); break; > case STRING_CASES: break; > default: > return SybaseError("Invalid buffer element type"); > } > > What's the appropriate action to follow? > > regards, > > Hung Jung > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com -- Chris McDonough - Digital Creations, Inc. Publishers of Zope - http://www.zope.org

1 0