June 2000 - Zope - Zope lists

Re: [Zope] images in access database
by Rik Hoekstra 02 Jun '00

02 Jun '00

> >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? > Um, in general you'd have to have very strong reasons to put large objects like images in a database (especially in Access). This has a negative effect on the performance of your application as it adds to the overhead (putting another layer between your webserver and your image retrieval). I don't see what the gains would be. If you consider putting image descriptions in your database, do so and no more. Put the images on a filesystem somewhere and make your database records point to them. This is much easier and much faster. If the number of images is large you may have to do some thinking about the directory structure. hth Rik

1 0

RE: [Zope] <dtml-tree> <div> issue from this morning.
by Marcus Collins 02 Jun '00

02 Jun '00

Hi, > -----Original Message----- > From: Patrick Keane [mailto:keane@danet.com] > Sent: 01 June 2000 19:10 > To: zope(a)zope.org > Subject: [Zope] <dtml-tree> <div> issue from this morning. > > The problem is the order. > > Netscape apparently likes to see URLS like > > http://www.my.com/this.html#foo?var=data > not > http://www.my.com/this.html?var=data#foo > > It chokes on the first, and is happy with the 2nd. IE is happy with > either. Any chance this can be checked in as a revision to the tree > code to be tested and confirmed? > > PS - Which is the standard format of the two (as per ww3 or whatnot?) Neither is "standard" per se -- RFC1808, which deals with URI's, says: "Note that the fragment identifier (and the "#" that precedes it) is not considered part of the URL. However, since it is commonly used within the same string context as a URL, a parser must be able to recognize the fragment when it is present and set it aside as part of the parsing process." However, the first form is recommended in the generic-RL syntax: <scheme>://<net_loc>/<path>;<params>?<query>#<fragment> and under Recommended Practices, so it would not be _recommended_ to change the order, although it might be _desirable_ hth, -- Marcus

1 0

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