[Zope-DB] Re: Zope-DB digest, Vol 1 #229 - 7 msgs
CONTRERAS, Pablo Alejandro
pcontreras@ecogas.com.ar
Wed, 24 Jul 2002 13:31:43 -0300
Hi, where I can download or update Zope in spanish
Thanks
----- Original Message -----
From: <zope-db-request@zope.org>
To: <zope-db@zope.org>
Sent: Wednesday, July 24, 2002 1:00 PM
Subject: Zope-DB digest, Vol 1 #229 - 7 msgs
> Send Zope-DB mailing list submissions to
> zope-db@zope.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.zope.org/mailman/listinfo/zope-db
> or, via email, send a message with subject or body 'help' to
> zope-db-request@zope.org
>
> You can reach the person managing the list at
> zope-db-admin@zope.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Zope-DB digest..."
>
>
> Today's Topics:
>
> 1. Re: DCOracle2 and jython? (Maan M. Hamze)
> 2. reading rowcount after calling zsql (Werner Hennrich)
> 3. Re: ZODBC Information (Dieter Maurer)
> 4. Re: ZODBC Information (Jose Gerardo Amaya Giron)
> 5. Trying Psycopg (=3D?ISO-8859-1?Q?=3D22Ricardo_L=3D2E_A=3D2E_B=3DE=
1nffy=3D22?=3D)
> 6. Re: Trying Psycopg (Tom Jenkins)
> 7. Re: Trying Psycopg (M.-A. Lemburg)
>
> --__--__--
>
> Message: 1
> Reply-To: "Maan M. Hamze" <mmhamze@pleiades.net>
> From: "Maan M. Hamze" <mmhamze@pleiades.net>
> To: <zope-db@zope.org>
> Date: Tue, 23 Jul 2002 11:23:47 -0500
> Subject: [Zope-DB] Re: DCOracle2 and jython?
>
> > Subject: [Zope-DB] DCOracle2 and jython?
> >
> > Hi,
> > Is there any chance someone could make a version of
> > DCOracle2 (e.g., SWIG) that would be compatible with
> > jython? Because DCOracle2 uses compiled c libs, it
> > cannot be used with jython in its current form. Or is
> > there something else (other than straight jbdc) that
> > can be used with jython?
> >
> > Thanks,
> > Daniel
> >
> Check out:
> http://www.ziclix.com/zxjdbc/
>
> Work with Google, it works for you :-O
> Maan
>
>
>
> --__--__--
>
> Message: 2
> From: "Werner Hennrich" <wehe@gmx.at>
> To: <zope-db@zope.org>
> Date: Tue, 23 Jul 2002 21:39:46 +0200
> Subject: [Zope-DB] reading rowcount after calling zsql
>
> Hello everybody,
> I'm looking for a solution to this problem:
>
> 1) I'm calling an ZSQL-Method (from a pythnon script)
>
> 2) the ZSQL updates a record only if a timestamp hasn't changed since l=
ast
> read ("update table set field1=3Dnewvalue, f2=3Detc, timestamp=3Dnewtim=
estamp
> where id=3Dkey and timestamp=3Doldtimestamp")
>
> 3) after that I want the calling script to check if an update has occur=
ed
> (so I can issue an error message).
>
> I'm looking for a way to obtain the number of records; my rdbms
(postgresql)
> dosn't have a construct to query this, but the db-driver in zope (it is
> DB-API 2.0 compliant) can tell via 'driver.cursor().rowcount()' - but h=
ow
> can I get the cursor-object of a ZSQL-Method?
>
> any ideas?
> thanks for your attention and help....
>
> Werner
>
>
>
>
>
>
>
>
>
> --__--__--
>
> Message: 3
> From: Dieter Maurer <dieter@handshake.de>
> Date: Tue, 23 Jul 2002 23:52:36 +0200
> To: Jose Gerardo Amaya Giron <gamaya@aldeacentroamerica.com>
> Cc: zope-db@zope.org
> Subject: Re: [Zope-DB] ZODBC Information
>
> Jose Gerardo Amaya Giron writes:
> > > > You see the problem is not mine, one of our programmers develop=
a
> > > > website with multiple SQL Methods, but he never use transaction=
s
and now
> > > > we have kind of a problem. He asume that Zope create transactio=
n
and
> > > > rollback if necesary, so we are all trying to find a solution t=
hat
> > > > causes less damage to the hole development.
> > > He is right.
> >
> > But when I try to use transaction with multiple SQL Methods it did n=
ot
> > work
> In what way does it not work?
>
>
> Dieter
>
>
> --__--__--
>
> Message: 4
> Subject: Re: [Zope-DB] ZODBC Information
> From: Jose Gerardo Amaya Giron <gamaya@aldeacentroamerica.com>
> To: Dieter Maurer <dieter@handshake.de>
> Cc: zope-db@zope.org
> Date: 23 Jul 2002 16:29:44 -0600
>
> On Tue, 2002-07-23 at 15:52, Dieter Maurer wrote:
> > Jose Gerardo Amaya Giron writes:
> > > > > You see the problem is not mine, one of our programmers devel=
op
a
> > > > > website with multiple SQL Methods, but he never use transacti=
ons
and now
> > > > > we have kind of a problem. He asume that Zope create transact=
ion
and
> > > > > rollback if necesary, so we are all trying to find a solution
that
> > > > > causes less damage to the hole development.
> > > > He is right.
> > >
> > > But when I try to use transaction with multiple SQL Methods it did
not
> > > work
> > In what way does it not work?
>
> the only way it works was by starting and commiting(or rollin back the
> transaction in the same SQL Method). How would you create a transaction
> with several SQL Methods a python Script, External Method, I'm kind of
> lost.
>
> thanks for all the help
>
> Gerardo Amaya
>
>
>
> --__--__--
>
> Message: 5
> Date: Wed, 24 Jul 2002 00:49:07 -0300
> From:
> "=3D?ISO-8859-1?Q?=3D22Ricardo_L=3D2E_A=3D2E_B=3DE1nffy=3D22?=3D"
<rbanffy@utopia.com.br>
> To: zope-db@zope.org
> Subject: [Zope-DB] Trying Psycopg
>
> Hi.
>
> I am having a problem that has been reported before (I am sure it is a
> FAQ, but it doesn't seem to be a Frequently Answered one ;-) )
>
> On October, 2001, Craig Ching had the same problem I am having now, but
> 's fix seem not to fit.
>
> Everything configured (after the lenghty enchantment ./configure
> --with-python=3D/opt/zope_stable/bin/python --with-zope=3D/opt/zope_sta=
ble/
> --with-postgres-includes=3D/usr/include/postgresql/
> --with-mxdatetime-includes=3D/usr/include/python2.1/mx/), made, made
> installed and made install-zope'ed fine, but the same error seems to
exist:
>
> <from the product screen>
> Traceback (most recent call last):
> File "/opt/zope_stable/lib/python/OFS/Application.py", line 531, in
> import_product
> product=3D__import__(pname, global_dict, global_dict, silly)
> File "/opt/zope_stable/lib/python/Products/ZPsycopgDA/__init__.py",
> line 92, in ?
> import DA
> File "/opt/zope_stable/lib/python/Products/ZPsycopgDA/DA.py", line
> 92, in ?
> from db import DB
> File "/opt/zope_stable/lib/python/Products/ZPsycopgDA/db.py", line
> 99, in ?
> import psycopg
> AttributeError: 'DateTime' module has no attribute 'mxDateTimeAPI'
> </from the product screen>
>
> <from the stupid log>
> Traceback (innermost last):
> File /opt/zope_stable/lib/python/OFS/Application.py, line 531, in
> import_product
> File /opt/zope_stable/lib/python/Products/ZPsycopgDA/__init__.py,
> line 92, in ?
> File /opt/zope_stable/lib/python/Products/ZPsycopgDA/DA.py, line 92,=
in
?
> File /opt/zope_stable/lib/python/Products/ZPsycopgDA/db.py, line 99,=
in
?
> AttributeError: 'DateTime' module has no attribute 'mxDateTimeAPI'
> </from the stupid log>
>
> I even tried to ln -s the psycopgmodule.so to the lib-dynload folder as
> another workaround suggested.
>
> Has anyone successfully installed psycopg 1.0.10 under Zope 2.5.1?
>
> Couldn't we just integrate adapters for PostgreSQL and MySQL (and ODBC
> under Windows) in the main Zope core so such mishaps could be avoided?
>
>
>
>
> --__--__--
>
> Message: 6
> Date: Wed, 24 Jul 2002 06:33:17 -0400
> From: Tom Jenkins <tjenkins@devis.com>
> To: =3D?ISO-8859-1?Q?=3D22Ricardo_L=3D2E_A=3D2E_B=3DE1nffy=3D22?=3D
> <rbanffy@utopia.com.br>
> CC: zope-db@zope.org
> Subject: Re: [Zope-DB] Trying Psycopg
>
> Ricardo L. A. B=E1nffy wrote:
> > Hi.
> >
> > I am having a problem that has been reported before (I am sure it is =
a
> > FAQ, but it doesn't seem to be a Frequently Answered one ;-) )
> >
> > On October, 2001, Craig Ching had the same problem I am having now, b=
ut
> > 's fix seem not to fit.
> >
> > Everything configured (after the lenghty enchantment ./configure
> > --with-python=3D/opt/zope_stable/bin/python --with-zope=3D/opt/zope_s=
table/
> > --with-postgres-includes=3D/usr/include/postgresql/
> > --with-mxdatetime-includes=3D/usr/include/python2.1/mx/), made, made
> > installed and made install-zope'ed fine, but the same error seems to
exist:
> >
>
> yes, this is a faq on psycopg and i believe even mentioned in the readm=
e.
>
> you have --with-python pointing to zope's bundled python but mxdatetime
> is installed under your system's python2.1
>
> either use your system's python installation or install mxDateTime unde=
r
> bundled python.
>
> Tom
>
>
>
>
> --__--__--
>
> Message: 7
> Date: Wed, 24 Jul 2002 12:45:33 +0200
> From: "M.-A. Lemburg" <mal@lemburg.com>
> Organization: eGenix.com Software GmbH
> To: Tom Jenkins <tjenkins@devis.com>
> CC: =3D?ISO-8859-1?Q?=3D22Ricardo_L=3D2E_A=3D2E_B=3DE1nffy=3D22?=3D
> <rbanffy@utopia.com.br>,
> zope-db@zope.org
> Subject: Re: [Zope-DB] Trying Psycopg
>
> Tom Jenkins wrote:
> > Ricardo L. A. B=3DE1nffy wrote:
> >=3D20
> >> Hi.
> >>
> >> I am having a problem that has been reported before (I am sure it is=
a=3D
> =3D20
> >> FAQ, but it doesn't seem to be a Frequently Answered one ;-) )
> >>
> >> On October, 2001, Craig Ching had the same problem I am having now,=3D=
20
> >> but 's fix seem not to fit.
> >>
> >> Everything configured (after the lenghty enchantment ./configure=3D2=
0
> >> --with-python=3D3D/opt/zope_stable/bin/python=3D20
> >> --with-zope=3D3D/opt/zope_stable/=3D20
> >> --with-postgres-includes=3D3D/usr/include/postgresql/=3D20
> >> --with-mxdatetime-includes=3D3D/usr/include/python2.1/mx/), made, ma=
de=3D20
> >> installed and made install-zope'ed fine, but the same error seems to=
=3D20
> >> exist:
> >>
> >=3D20
> > yes, this is a faq on psycopg and i believe even mentioned in the rea=
dm=3D
> e.
> >=3D20
> > you have --with-python pointing to zope's bundled python but mxdateti=
me=3D
> =3D20
> > is installed under your system's python2.1
> >=3D20
> > either use your system's python installation or install mxDateTime un=
de=3D
> r=3D20
> > bundled python.
>
> Wouldn't it be much easier telling people to install mxDateTime
> using the bundled python version ?
>
> /opt/zope_stable/bin/python setup.py install
>
> Note that mxDateTime header files always live in
> mx.DateTime.mxDateTime, so finding the path to them is easy
> using Python and can be automated.
>
> --=3D20
> Marc-Andre Lemburg
> CEO eGenix.com Software GmbH
> _______________________________________________________________________
> eGenix.com -- Makers of the Python mx Extensions: mxDateTime,mxODBC,...
> Python Consulting: http://www.egenix.com/
> Python Software: http://www.egenix.com/files/python/
>
>
>
>
> --__--__--
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://lists.zope.org/mailman/listinfo/zope-db
>
>
> End of Zope-DB Digest