- Zope - Zope lists

postgres DA
by Bak ＠ kedai 02 Jun '00

02 Jun '00

hi all, what's the current status of ZPygreSQLDA and ZPoPyDA? if i were to choose, which should i use? and the reasons for using it? i understand that ZPoPyDA is level 2 thread safety, and not quite sure what ZPygreSQLDA thread safety is. docs, pointers, explanation sought! thanks -- ------------------------------------------------------ http://www.kedai.com.my/kk Am I Evil?

1 0

RE: [Zope] Zope on Windows NT
by brabander 02 Jun '00

02 Jun '00

One method that works is to change the port in z2.py. cb >===== Original Message From Luis Cortes <lcortes(a)pollak.com> ===== >Hello, > > Does anybody know how to change the Port that Zope uses on Windows NT >when it is installed as a Service??? I know how to change it when it is >installed as standalone - but that doesn't work when I run it as a service. > > >Thanks for your help, >Luis. >

1 0

(no subject)
by Andy Gates 02 Jun '00

02 Jun '00

Two in one? I'm stuck (again!). Here's what I'm trying to do, so you mighty boffins can stroke your beards while chuckling... On one page I want to show the details o a project and the people working in it. This needs to be reachable via a simple friendly search. So, I have a SQL method that takes parameter "search" and looks for LIKEs against the common text fields, then returns the project details. One of those details is the project ID, which I want to pass to the second search (in a differnet data- base) as parameter for finding who works on the project. I've tried just putting the second search in the <dtml-in> lop of the first one, which I hoped would mean that the second search had access to the projID var, but it doesn't seem to be passing to the second SQL method. So, in time-honoured tradition: What am I doing wrong? Cheers (and beers) Andy Gates

1 0

MS SQL server and Zope
by paul beard 02 Jun '00

02 Jun '00

anyone have any insight on accessing a SQL server store thru Zope? I have an app that's backed by SQL server and rather than buy r/w licenses for it, I'd be happy to use Zope to access it readonly. -- Paul Beard / 206 728 4282 x138 Fizzylab / 2025 First Ave, Suite 1150 Seattle WA 98121

2 2

Re: [Zope] MS SQL server and Zope
by Anthony Baxter 02 Jun '00

02 Jun '00

>>> paul beard wrote > anyone have any insight on accessing a SQL server store thru Zope? I have > an app that's backed by SQL server and rather than buy r/w licenses for > it, I'd be happy to use Zope to access it readonly. You can use the Sybase libs to access it. See http://www.zope.org/Members/anthony/dcSybase-on-linux/

1 0

[announce] SQL Session 0.2.9 available.
by Anthony Baxter 02 Jun '00

02 Jun '00

A long-overdue update to SQL Session is out. This version (0.2.9) will be the last version in the 0.2.x series (assuming no brown paper bag bugs in this release). I will be now working on 0.3.x, which will hook into the transaction machinery so that it only makes a single set of updates in a transaction. This should lower the database hits significantly. Installation: If you have a previous version of SQLSession, you might need to go to the management panel of your Session object after installing the new version and hit 'Change'. Note that the default schema has changed to avoid bad words like 'name', 'session', 'sessions' and 'value', since some databases have issues with these. Changelog from 0.2.3: Code now uses it's own decodestring/encodestring, because the standard python lib supplies an incredibly stupid implementation. (take a string, wrap it in a StringIO, then pass it to encode which then pulls out the string again.) Rough testing shows that a small string encode or decode drops from 1ms or so to about 1/20th of that. Given how often this is done, it makes a big big difference. Jeff Hoffman supplied a patch that makes SQLSession work with 2.2 - adding __allow_access_to_unprotected_subobjects__ = 1 to the SESSION object. Ooo, magic. Changed the default schema and queries to avoid using the words 'session', 'value' or 'name'. Different databases have different ideas of which are and are not reserved words. Added a new option 'path', to specify the cookie path. This means that you can specify, say, /foo, and only the browser will only send the cookie when requesting URLs beginning with /foo. Re-did some of the internals to avoid what may or may not have been a refcount cycle. I'm still not sure what caused it - assigning the SESSION object to REQUEST.SESSION, with SESSION keeping a reference to the parent Session object. It now finds Session by acquisition. A number of dumb bugs were squished. Anthony -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

1 0

Re: [Zope] Interbase / Cacheing - A thought
by Cary O'Brien 02 Jun '00

02 Jun '00

> Ian Sparks wrote: > > > > Had a thought that I wanted to share. > > > > Interbase has a feature known as "event alerts". In a trigger you can post > > "events" which are just fixed data strings e.g. "DataAdded" or > > "Insert_tblUsers". > > PostgreSQL has them too. > > It's not (afaik) supported by DB-API, but could be used in a DA that talks > to some lower level API. > They are supported by the TCL interface that comes with PostgreSQL (src/interfaces/libpgtcl in the PostgreSQL source tree) if you are looking for examples of how they work. (Search for listen and notify in pgtclCmds.c -- cary > > A client database connection can register to listen to these events. > > > > I don't know if any Zopeish Interbase access method supports this (ODBC > > doesn't to my knowledge) but it would be incredibly useful for synching > > cached database objects. Zope could hold a representation of the table data > > in cached objects for quick access. Each object could have one or more > > "event" methods which related to a database event. When the database adaptor > > received an event message from Interbase it could inform all objects with a > > matching event method (these methods would refresh their cached data with > > current values from the database). > > > > In this way database and Zope cache could be synced *without* having to poll > > the database at an interval. In all, a very efficient mechanism. > > > > Just an idea I wanted to put out there. > > Thanks for getting it out. > > I have been contemplating the same for PostgreSQL but have been too lazy to do > it myself ;) > > ------------------ > Hannu > > --__--__-- >

2 1

Interbase / Cacheing - A thought
by Ian Sparks 02 Jun '00

02 Jun '00

Had a thought that I wanted to share. Interbase has a feature known as "event alerts". In a trigger you can post "events" which are just fixed data strings e.g. "DataAdded" or "Insert_tblUsers". A client database connection can register to listen to these events. I don't know if any Zopeish Interbase access method supports this (ODBC doesn't to my knowledge) but it would be incredibly useful for synching cached database objects. Zope could hold a representation of the table data in cached objects for quick access. Each object could have one or more "event" methods which related to a database event. When the database adaptor received an event message from Interbase it could inform all objects with a matching event method (these methods would refresh their cached data with current values from the database). In this way database and Zope cache could be synced *without* having to poll the database at an interval. In all, a very efficient mechanism. Just an idea I wanted to put out there. - Ian Sparks.

2 3

images in access database
by Terry Kerr 02 Jun '00

02 Jun '00

Hi, I would like to be able to have gifs/jpgs stored in an MS access database and then pull the out using zope and display them in rendered documents. I am completely new to access. I have successfully installed the ODBCDA into zope, and are able to connect to an access database and pull ordinary text data out of tables. I have created a table in access with a column of type 'OLE object' and put a gif image in as data. This is the only way I know how to get an image into the table. The problem I think with this is that it is a link to the gif on the HDD, and doesn't actually have the data in the table? Anyway, when I pull the data out of the table from zope, access puts a header and footer around the gif binary data, and hence a simple <dtml-var blah> wont work to display the image. Has anyone else every pulled images from an access database. Will I have to write a method to strip the header and footer from the returned data before displaying the gif? terry. -- ----------------------------- Terry Kerr (terry(a)adroit.net) Adroit Internet Solutions http://www.adroit.net/ 03 9563 4461 0414 938 124

1 0

Python and Zope Question
by Scott Burton 01 Jun '00

01 Jun '00

Major newbie here. I am wanting to create a python method that iterates over items in a folder object in Zope. I am struggling with how to access objects in the ZODB in python. Here's the script in the simplest form. for x in folderObject : return x I am going to do things to the items once I have access to them, I just can't figure out how to reference ZODB objects in Python. I have done searches on the zope site and looked through the zdp but could not find anything. I am calling the method from a <DTML-var pythonMethodName> with no args. My assumption is that since this is a Python Method, it has access to the ODB structure without having to pass it anything. Am I wrong here? Thanks, Scott B. Voice: 661-325-0288 Business: www.launchpoint.net Weblog Portal: www.blogthis.com

3 2