[Zope-DB] A new event.log on every restart of Zope

It would accelerate my Zope debugging cycle to have a new event.log file automatically started every time I restart Zope, with the old file preserved. It seems like a simple way to do this would be to modify the zope.conf entry, which currently reads like this. level info

[Zope-DB] Problem with feature

This ZSQL method: select organization_id, name, url_name, short_name from organization doesn't work properly when I give it "a sequence of values to test the condition against", which is what the "multiple" tag is supposed to allow according to http://www.plope.com/

[Zope-DB] Seeking help with Accessing Zope from PostgreSQL

I'm trying to implement the scheme for "Accessing Zope from PostgreSQL" that is described in http://zope.org/Members/pupq/zope_in_pg. I'm trying to implement it in a Plone installation in a WinXP environment (Plone 2.5.2, Zope 2.9.6, Python 2.4.3, win32, PostgreSQL 8.1.10). I have changed the f

RE: [Zope-DB] Automatic capture of user ids for auditing

'd appreciate any guidance anybody can offer. ~ Thanks ~ Ken > -Original Message- > From: Charlie Clark [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 06, 2007 3:26 PM > To: Ken Winter; Zope-DB List > Cc: Jim Myers; Michael Adams > Subject: Re: [Zope-DB] Automat

[Zope-DB] Automatic capture of user ids for auditing

I have a Zope site with a PostgreSQL (8.1) back end. Only authenticated users have access to the site and the database. Each database table has created_by and last_updated_by columns for auditing purposes. The question here is: How to get these audit columns *automatically* updated with the u

RE: [Zope-DB] Using s in ZSQL methods?

Thanks Charlie & Jim ~ SQL injection is a new one on me, and I'm glad to learn about it now (painlessly) rather than later (painfully). ~ Ken > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, June 18, 2007 10:03 AM > To: Ken

RE: [Zope-DB] Using s in ZSQL methods?

> -Original Message- > From: Maciej Wisniowski [mailto:[EMAIL PROTECTED] > Sent: Monday, June 18, 2007 1:34 AM > To: Ken Winter > Cc: 'Zope-DB List' > Subject: Re: [Zope-DB] Using s in ZSQL methods? > > > > I tried to invoke the "query" m

RE: [Zope-DB] Using s in ZSQL methods?

> -Original Message- > From: Charlie Clark [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 16, 2007 6:24 PM > To: Ken Winter; 'Zope-DB List' > Subject: Re: [Zope-DB] Using s in ZSQL methods? > ... > FWIW you > might want to call the query or

RE: [Zope-DB] Using s in ZSQL methods?

Charlie ~ I tried several experiments based on your suggestion. See results inserted below. ~ Thanks, Ken > -Original Message- > From: Charlie Clark [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 16, 2007 3:54 PM > To: Ken Winter; 'Zope-DB List' > Subject: Re:

RE: [Zope-DB] Using s in ZSQL methods?

n/x-www-form-urlencoded' HTTP_ACCEPT_ENCODING'gzip,deflate' PATH_INFO '/DAgroups/portal_factory/People/people.2007-06-16.3625931808/people_edit' " Let me add that I get the same error (down to all the details) if I simply put a single string or integer constant i

RE: [Zope-DB] Using s in ZSQL methods?

the trouble seems to be. I will put in another message to this thread documenting some further experiments I have done. ~ Thanks ~ Ken > -Original Message- > From: Jaroslav Lukesh [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 16, 2007 1:41 AM > To: Ken Winter; 'Zope-DB Li

[Zope-DB] Using s in ZSQL methods?

Here's the definition of a ZSQL method, "people_delete_by_id.zsql": " title: Method to delete People by ids given in a comma-separated list connection_id: my_database arguments: id_list delete from person where person_id in () " Here's the puzzle: When I define and test this Z

RE: [Zope-DB] Two actions in one ZSQL method = one transaction?

Great! Thanks again. > -Original Message- > From: Andreas Jung [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 14, 2007 10:48 AM > To: Ken Winter; 'Andreas Jung'; 'Zope-DB List' > Subject: RE: [Zope-DB] Two actions in one ZSQL method = one transaction?

RE: [Zope-DB] Two actions in one ZSQL method = one transaction?

> -Original Message- > From: Andreas Jung [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 14, 2007 12:54 AM > To: Ken Winter; 'Zope-DB List' > Subject: Re: [Zope-DB] Two actions in one ZSQL method = one transaction? ... > > Does a ZSQL method initiate a data

[Zope-DB] Two actions in one ZSQL method = one transaction?

I have a question (stated in three different ways) about the following ZSQL method: 1. Will it *always* return the person_id of the person that it just inserted? 2. Will it do this even if another user inserted another person just in between the two SQL actions in this ZSQL method? 3. In othe

RE: [Zope-DB] Seeking a suitable ZpsycopgDA

Thanks, Maciej. That worked. ~ Ken > -Original Message- > From: Maciej Wisniowski [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 01, 2007 5:19 PM > To: Ken Winter > Cc: 'Zope-DB List' > Subject: Re: [Zope-DB] Seeking a suitable ZpsycopgDA > > > >

RE: [Zope-DB] Seeking a suitable ZpsycopgDA

Correction: What I'm looking for seems to be called ZpsycopgDA, not just psycopgDA. Anyway, I still haven't found it for the environment described below. Pls advise. ~ TIAA ~ Ken > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > O

[Zope-DB] Seeking a suitable psycopgDA

I'm looking for the right version of psycopgDA for the following setup: Windows XP PostgreSQL 8.0 Zope 2.9.6-final Plone 2.5.2 (don't know if that matters) Python 2.4.3 Psycopg = win-psycopg24-pg8.0.zip downloaded from http://stickpeople.com/projects/python/win-psycopg/ MX Toolkit = egenix-m

RE: [Zope-DB] Accessing the MySQL data dictionary

> -Original Message- > From: Chris Withers [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 01, 2005 3:54 PM > To: [EMAIL PROTECTED] > Cc: zope-db@zope.org > Subject: Re: [Zope-DB] Accessing the MySQL data dictionary > > Ken Winter wrote: > > - Thanks f

RE: [Zope-DB] Accessing the MySQL data dictionary

From: Dieter Maurer [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 01, 2005 4:30 PM > To: [EMAIL PROTECTED] > Cc: zope-db@zope.org > Subject: Re: [Zope-DB] Accessing the MySQL data dictionary > > Ken Winter wrote at 2005-5-31 21:21 -0400: > > ... > >The nicest

[Zope-DB] Accessing the MySQL data dictionary

I need to read the definitions of my database’s tables, columns, and constraints out of the data dictionary (or catalog, or whatever MySQL calls its meta-data tables) from Python, via Z SQL methods or whatever else will work.  I also need to be able to get “last update” timestamps on each c

[Zope-DB] RE: ZPTs and database accesses

> Date: Thu, 28 Apr 2005 23:48:58 +0200 > From: Charlie Clark <[EMAIL PROTECTED]> > Subject: RE: [Zope-DB] ZPTs and database accesses > To: zope-db@zope.org > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain; charset="us-ascii" > > &

RE: [Zope-DB] ZPTs and database accesses

uch a reference? - Thanks, Ken > -Original Message- > From: Andreas Jung [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 28, 2005 2:17 PM > To: [EMAIL PROTECTED]; zope-db@zope.org > Subject: Re: [Zope-DB] ZPTs and database accesses > > > > --On Donnerstag, 28

[Zope-DB] ZPTs and database accesses

example of a ZPT for an HTML form that can take data from the web page into the database.   Could anybody tell me how to do this, or point to a reference that does?  In case it matters, the DBMS I’m using is MySQL.   -    Thanks -    Ken Winter