April 2000 - Zope-Dev

Where to put stuff (ZCron)
by Morten W. Petersen 08 Apr '00

08 Apr '00

I'm planning on adding a feature to Zope, called ZCron or somesuch, that'll run jobs on a regular basis, as with UNIX cron. Just so I don't reinvent the wheel, are there any similar that have been or are being done? Where is the right place to put it (in the source)? Regards, Morten W. Petersen

2 1

DCOracle and BLOBs Handling
by Cheuk Cheng 07 Apr '00

07 Apr '00

Hi Everyone: In the past couple weeks, I started looking at Zope for my future development work. One of the requirements is to be able to upload and download Oracle blob via Zope. In the last few days, I spent most of my time searching through the mailing list for help from installing DCOracle to inserting blob from an external method. So far I've successfully used DCOracle to create an Oracle connection in an external method and performed some simple db tasks. Now here're my questions for all the zope gurus: 1. Can I use ZSQL method to insert blob into Oracle? It works for querying blob out of the database. Why doesn't it work in insertion? 2. In an external method can I get a hold of the connection object from zope by doing these: import Shared.DCOracle def sql_exec(self, param) ..... conn = self.oracle_connection cur = conn.cursor() cur.execute(sqlstat) ..... When I execute the function from Zope, it keeps giving me an AttributeError for the cursor. Can someone please explain? And if I create the db connection inside using conn = Shared.DCOracle.Connect('scott/tiger@oracledb'), I'll be getting the cursor successfully. 3. With the connection created in the external method, I thought I could make the blob insertion work. Obviously, I'm wrong! I keep getting an error about invalid hex number "oci.error: (1465, 'ORA-01465: invalid hex number\012')". The way I'm testing the insertion is to select a blob from one table and try to insert it in another as follow: cur.execute('select no, blob_data from res_info where no=1000') data = cur.fetchall() a,b = data[0] image = (100, b) cur.execute('insert into test_info (no, data) values(:p1, :p2)', image) I found that the returned "data" is a list of tuple. So I get the first tuple and unpack it. Then I created a new tuple and tried to insert it into the test_info table. And I keep getting the invalid hex number error. When I took this and converted it to a standalone program with a print statement for 'b', it printed out the correct binary data. So I suspect that I may have to convert the binary stream into a string before I can do the insertion? I also tried to set b = 'ff00ff00ff' (a text string of hex numbers), and it didn't complain about it. Can someone please tell me how blob shall be handled? Thanks in advance. - Cheuk

2 1

PLEASE answer: how do I create users in dtml
by news-list.zope.dev＠innominate.de 07 Apr '00

07 Apr '00

Hi, in my ZClass product I have to add a default user. I managed to create an acl_users folder upon instance creation of the product, but I also _need_ a predefined user account in the instance. can this be done from dtml or do I need an external method? (this would be extremely annoying because my whole product is ZClass only. what's the point of being able to create user folders but not users?) I've had a look at the 'manager_users' method but it does not fit my needs. _please_ help, this is the only thing that's missing for a release. I will upload the product to zope.org, I promise. greetings, Heiko Stoermer -- heiko.stoermer(a)innominate.de innominate AG networkingpeople fon: +49.30.308806-0 fax: -77 web: http://innominate.de

1 0

Possible new security API
by Jim Fulton 06 Apr '00

06 Apr '00

I've put together some thoughts and a proposed API for making it easier for application code to operate securely and for implementing new security policies. See: http://www.zope.org/Members/jim/ZopeSecurity/ZopeSecurityPolicies As usual, it's a wiki page. :) Feel free to comment there. Jim -- Jim Fulton mailto:jim@digicool.com Technical Director (888) 344-4332 Python Powered! Digital Creations http://www.digicool.com http://www.python.org Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.

1 0

Spliting text
by Michel Pelletier 06 Apr '00

06 Apr '00

I'm trying to think of some good ways to improve the way ZCatalog splits text. The component that does this is called the Splitter, and it is currently written in C. In the CVS there is a new mechanism for abstracting out language dependent features, like splitting, into various Vocabulary objects. I want to make it as trivial as possible for an average programmer to create Vocabulary objects for their language of choice. Right now there are some prototypes doing Japanese, and I and the guys at Digital Garage have done some research on the similar Chinese problem. I am contemplating checking in Brian Hooper's ExtensionClass patch to the Splitter, so that the splitter can be subclasses in python. While more useful, I don't think this will gain much; the Splitter is very english centric and not very extensible (to solve, for example, the japanese problem) and subclassers would need to re-implement most of it in python anyway, so there is no big win. I think that the existing C splitter should be internationalized. I would like some suggestions on how people think the lexical analysis problem is solved for their particular language, and I'd like to discuss how to generalize the Splitter on the Interfaces Wiki: http://www.zope.org/Members/michel/Projects/Interfaces/Splitter Can someone post this to the ZIP list? I'm not on it at the moment... -Michel

1 0

Problems with Inheriting a contained ZClass.
by Brian McGinnis 06 Apr '00

06 Apr '00

Hello, Here is the scenario. I have ZClass A, which contains ZClass B. Now ZClass C is a subclass of A. >From within C I now try to create another ZClass D and I want to make D a subclass of B. Simple right. The problem is that D ZCLASS create form doesn't display ZClass B as class from which I can subclassed from. Is there some secret to getting this to work or is this something that can't or shouldn't be done. Thanks in advance, Brian McGinnis

1 0

RE: Week of the year
by Jason Spisak 06 Apr '00

06 Apr '00

Zopsters, In case anyone cares, <dtml-var expr="((ZopeTime().dayOfYear())/7) + 1"> gives you the week of the year and will allow for tests to see if DateTime's occur in the same week. I was just looking to see if it was in a module. All my best, -- Jason Spisak 444(a)hiretechs.com

1 0

Summary of the Java Security model
by Jim Fulton 06 Apr '00

06 Apr '00

I've put together a brief summary of the Java security model for comparison with Zope's present and future security models: http://www.zope.org/Members/jim/ZopeSecurity/JavaSecurityModel This is based on pretty limited research. If I've gotten anything wrong or missed any important points, please add comments or corrections. (Note that the above URL points at a wiki page, which you can edit if you are a member of zope.org.) Jim -- Jim Fulton mailto:jim@digicool.com Technical Director (888) 344-4332 Python Powered! Digital Creations http://www.digicool.com http://www.python.org Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.

1 0

Possible New Standard Idiot: GET and POST to same page?
by Jim Fulton 06 Apr '00

06 Apr '00

See (and comment at): http://www.zope.org/Members/jim/ZopeSecurity/GetAndPostToSamePage Jim -- Jim Fulton mailto:jim@digicool.com Technical Director (888) 344-4332 Python Powered! Digital Creations http://www.digicool.com http://www.python.org Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.

1 0

adding users from dtml
by news-list.zope.dev＠innominate.de 06 Apr '00

06 Apr '00

Hi, how can I add users to user folders using dtml? in my zclass is a folderish object and in its _add method I create a user folder in it. for my application I need to add a default user to acl_users, but I have not managed to do this. thanks in advance, Heiko Stoermer -- heiko.stoermer(a)innominate.de innominate AG networkingpeople fon: +49.30.308806-0 fax: -77 web: http://innominate.de

1 0