Re: [Zope-DB] questions

[Andreas Jung]

Zope used the related Python-DB API  compatible driver with some
integration and boilerplate code in order to integrate the
Zope transaction mechanism with the transaction mechanism of the database
(rollback vs. commit). There are additional (optional)
integration layers working on top of SQLAlchemy like my ZSQLAlchemyDA.

-aj


2013/4/12 posgrado 

>  Hi,
>
>
>  Could you answer me some questions please?
>
>
>  I undestand that Zope woks with ZODB and if required also works with a
> relational database, both are connected by Zope core, I would like to know
> how Zope core works and how these database work, do they use an  
> Object-Relational
> mapping and what is it? Also I would like to know how query work to
> database.
>
>
>
>  Sincerely yours
>
> ___
> Zope-DB mailing list
> Zope-DB@zope.org
> https://mail.zope.org/mailman/listinfo/zope-db
>
>
___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope-db[Zope_Openflow_installation]

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

OpenFlow has nothing to do with zope-db. Please ask on the z...@zope.org
mailing list. Apart from that Openflow is dead.

- -aj

smita kamdar wrote:
> 
> 
> HI,
> 
> I am supposed to install Openflow-0.0.1 on LINUX box. I installed it
> following the below steps –
> 
> ./configure
> 
> Make
> 
> Make install
> 
>  
> 
> After this I restarted zope, but still it is not appearing in the
> Product’s folder of Zope Management Interface.
> 
> Do I need to do anything else for this?
> 
>  
> 
> Smita Kamdar
> 
> 
> 
> ___
> Zope-DB mailing list
> Zope-DB@zope.org
> https://mail.zope.org/mailman/listinfo/zope-db


- -- 
ZOPYX Limited   | zopyx group
Charlottenstr. 37/1 | The full-service network for Zope & Plone
D-72070 Tübingen| Produce & Publish
www.zopyx.com   | www.produce-and-publish.com
- 
E-Publishing, Python, Zope & Plone development, Consulting


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJM78kNAAoJEADcfz7u4AZjC2oLvRf22v5kbJ1yJTsrsP1g7DtD
sZvBK93Ag6nYDCf1sgDbHdJgMS4eP4SnrixuehwmA/pqBORnzwlxYsYttj2A8ybU
ratPtOv6IpYFiONXopDvB1mfy3GrVFcT3ZAk+YBxCBWMNTgN17U3FTXWvHCnRDwG
+Pp478h5t1h2d9XuHDSCCnjNMPBLkMJVr996XjvflEt5ocYnoqV5BoEvqmGXcmE7
ZxBssaF+qf7lgtX1npBC3XwlCN+0CspkFK/EB5644T8JcGufNMvQXrqXgmsJfIPe
7bqsBl3BXcNER2F0ejvBdRoEXCOipoktKsV6e9qPSlQV2X6ystRQIDH/JxtGoY2R
vper09UdHCE+yxvQPgFTQfQ7IOZ2IhwjLRiYwlDsoSFQR93BNhQX16sbR8z4CAKp
fuUEeSJoxFCpWCS3cYuA0wWDoeRP3LmUfAHZgvkSKjBHjLcv+X2pZJNQKOle6dVn
ro81dD5Vwi/tLNOh7szaXC8bU3lbR20=
=enqb
-END PGP SIGNATURE-
<>___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Fwd: Zope_Database_issue

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,

you are resistent reading advices.

We adviced you to use psycopg2 instead of psycopg1

psycopg2 is a *mandatory* requirements for using ZPsycopgDA.

So please follow our recommendations instead of trying
the wrong things.

- From my experience: psycopg2 usually installs without major issues.

So use pyscopg2 *and* SQLAlchemyDA (as adviced already several times).

- -aj

smita kamdar wrote:
> 
> 
> 
> HI,
> 
>  
> 
> I uninstalled Psycopg from my LINUX m/c & now zope is working fine.
> 
>  
> 
> Again I started installing psycopg-1.1.6 & in the first step itsef it
> gives the following error:
> 
>  
> 
> [t...@test psycopg-1.1.6]$. /configure
> 
>   --prefix=/opt/zope/psycopg-1.1.6
> 
>  
> --with-mxdatetime-includes=/home/test/egenix/2.0.6/mx/DateTime/mxDateTime
> 
>  
> --with-postgres-includes=/home/postgres/7.4.13/src/include
> 
>  
> --with-postgres-libraries=/home/postgres/7.4.13/lib
> 
>   --with-zope=/opt/zope
> 
> loading cache ./config.cache
> 
> checking for python... /usr/bin/python
> 
> checking python version... 2.4
> 
> checking python installation prefix... /home/test/Python/2.4.4
> 
> checking python installation exec_prefix... /home/test/Python/2.4.4
> 
> checking definitions in Python library makefile... done
> 
> checking location of python library... $(prefix)/lib/python2.4/site-packages
> 
> checking location of python shared modules...
> $(exec_prefix)/lib/python2.4/site-packages
> 
> checking for gcc... gcc -pthread
> 
> checking whether the C compiler (gcc -pthread   ) works... yes
> 
> checking whether the C compiler (gcc -pthread   ) is a cross-compiler... no
> 
> checking whether we are using GNU C... yes
> 
> checking whether gcc -pthread accepts -g... yes
> 
> checking how to run the C preprocessor... gcc -pthread -E
> 
> checking whether make sets ${MAKE}... yes
> 
> checking for inline... inline
> 
> *checking PostgreSQL version... configure: error: missing PostgreSQL
> headers*
> 
>  
> 
> Is it because of this error that I am not able to solve the issue?
> Because last time when I Installed Psycopg I faced the same error.
> 
>  
> 
> How shall I progress?
> 
>  
> 
> Please Note: Paths of the Directories where my installables are –
> 
>  
> 
> Zope --à  /opt/zope
> 
> Python à/home/test/Python/2.4.4
> 
> Egenix -à/home/test/egenix
> 
> Postgresqlà/home/postgres/7.4.13
> 
> Psycopgà/opt/zope/psycopg-1.1.6
> 
>  
> 
> 
> 
> 
> 
> ___
> Zope-DB mailing list
> Zope-DB@zope.org
> https://mail.zope.org/mailman/listinfo/zope-db


- -- 
ZOPYX Limited   | zopyx group
Charlottenstr. 37/1 | The full-service network for Zope & Plone
D-72070 Tübingen| Produce & Publish
www.zopyx.com   | www.produce-and-publish.com
- 
E-Publishing, Python, Zope & Plone development, Consulting


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJM5n/5AAoJEADcfz7u4AZj86gLv2Grtv98HUMbESEX7D3dSO2Z
iJzOLDU0gs48MFkJdniFuzQ51JimGm0oWcYPN3syfRSwKAJX36gHAObj+RAI4pJP
XUQUFYEH17VkyE447xs7uaqodmvKSM8MMlpJ14rEc2TK7xtOPE+cF4g0ej07d7CR
6dABNDtz047mQ+OnDgPtFbMgVC39Mkj60mH1e0fwjZB+3as6vUZEmDPvAZ7r++0f
9D8BkSZwpwxkDSPRf+Qi/ddB5aR/tfu4FCU4v1TDb5Xre3b+vHm/7LdgtsHf1e86
SLUlJ8xvVVt84H6yApCYEsRr37hz2B6W6gp0USvDeOLCu6ujq8c+4f2rG8JNkByS
cqK1l8Puw5QGnw2GUJ7j29PDfPueeyYq3PsozPBtLI92VoD3Si0n3ofIqRBWJnD3
p58slqr7DoCkWwvJ7OFnSJCaHf3Kxf9USptyYb2aQu8ziuqClFYJZsba/BAuXLbW
1d2OlIwVjEDdYyLzt6ECUE6TxUy5xck=
=XZB7
-END PGP SIGNATURE-
<>___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope_Database_issue

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

smita kamdar wrote:

> 
> Please do tel me if I can try something else.

Are the read permission set correctly?

- -aj
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJM5WOsAAoJEADcfz7u4AZj1ysLvi2L38XTwbLJaSXAv+jdWrrI
suqYvtHLyrka0va6+JQrpBm66IQC8WFj0+nIRzGNfyXAhFxFD9DZ7rRRXvSRYO7a
xq2S8nrl4Lzy/42tKpqkn0zlSRl8Ku4Uu5r3FS42Peu0yKishPi+6T7IbuWsBp8l
SR7Lh2wL3r06vQeIMDenuFWhZ8YFfdORvoInMgpWqATA3NsEiisCmaT3PzrzlBnH
P2YvYb0N+8cRrmzGluFGzUysC8Aw0vgmc0Tt2LSep5hy+Bzz9Qj4eups35U5FmZg
Qi+ml/OZVXI7pHGhhISN2M2cy0lt0B6srvsSLo+rWEQy1xqEsswMXsfwiJBvHxbC
3xpFvMri/Gnk//SHDY0+IHOCltKOZpNsR6E8J8N8kDvuhpSUmG3DfV+xl3yu8Qfe
1vB+tA1HFRtI+CAF9T3T+yqWoDvkLfOPup096PDDiI5vC78imOK7nbdDw3vM/ZlR
yG8/41ykIarxQ7SJKET2WL1xtO0jCeU=
=Oc6K
-END PGP SIGNATURE-
<>___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope_Database_issue

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

smita kamdar wrote:

> LD_Library_path = /home/postgres/7.4.13/lib. But this didnt work. I
> still got the same error.

check your *spelling* - environment variablea are *case-sensitive*.

- -aj
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJM5Ro1AAoJEADcfz7u4AZjaEMLwJb5i/9gGkpal7Hw6K5ee6z4
h+HEFAy+efmms2vsxCdibD9F+dehL2VpRMjqEbmyNmvIWZk0xY2qwsYgRP17cSAq
cyfGRW01JZJJj/DXNoM2IkoNpyruiAVRgaF6oP680I0SEPNQgzLYALOycGzVNzLN
10EoBoGy+lpo3wNrG0ffcdjHQ3iK8MGFzasPEphGvcUVKgIQIMZzs49qIVthXzfY
BQg1YOEnC1np+3dVRbXX0q5ngcqm/Cw+p9A55guKDfcw/WEeiA0I2846VwgkJbZ1
HidxeSMD30VuKhWosfqrYjALfBZq9vslX6yEb2iXa/YegDRJetEZpEFcsrPF0RfH
sHrcEjTnESr2jYF67D3isDanAyyEs4fH9HzFQnJ/XfPn/3oxeYWCpNvO/2/+fy2e
lEFyitgmTrsiL3ulGvfdwSt/EYtKO+b33yh0r2MXJQMi6l87sPLazEZgeN4Kd7/X
CWZ792cWSKgA9Hm0fupbkJBfpuSafP8=
=gfIf
-END PGP SIGNATURE-
<>___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope_Database_issue

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Charlie Clark wrote:

> BTW. I think that you may well be better off with psycopg2 as the library.

...which is a mandatory requirement for ZPsycopgDA - and as said:
SQLAlchemyDA is much easier to install and handle.

- -aj
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJM5PLqAAoJEADcfz7u4AZjphsLv2V3bVuhXeJMryTD8OJOZ3cK
Vu4ICp//azPVuDQU+ECWiLIHAKbc+Fx32d3SrtSUWb8/yQLwSyfj+2Smsk7wVUQO
v8/BRDpFizuDcPC2l6Ku34INcFcecEwclhshYMBrjusN4VPVzTa8MltTOVMLcv5x
Y/B7zyFQlmd66VfvPlNo5qwHW2iLglYOf8R31X+cpcsi9reyJvNHv8GrMHbzDxV+
pjsOrzGtNWDs2WNSn492JA8qGL8Yu6w4Tu7crlJoQBhlrIUFpZRAC/JVxXGp8VVL
RdMsGuCFHLrpmXv+okJSOKrR7ty4HCBybUVgUCA/1Mx9DfqHYTQYIvO2oO+k5tQS
HTqHyxWagcE3QGXPg8b6ic10Q87Hk7kXervZXmWelF22cy4gYIGxya9Yz8zAxklo
YuVfypOgwWRbXTfZ865eIJ0izEKkFjuYGSaP1PRBwrYMAO5dxWRAmd85Ly04Veoh
OfirT4UCsjewritf4RBTNgKO/EQV/LQ=
=L466
-END PGP SIGNATURE-
<>___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope_Database_issue

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Why can't you read short answers carefully?
Using the LD_LIBRARY_PATH environment variable is likely
the solution for your problem.

- -aj

smita kamdar wrote:
>  
> 
> HI,
> 
>  
> 
> But I can see the library ‘ libpq.so.3’ in the Postgres lib directory &
> also while installing Psycopg I gave the same path of Postgres library.
> 
> Now what else I need to do?
> 
>  
> 
> Thanks a lot!!
> 
>  
> 
> -- Forwarded message --
> From: *Andreas Jung* mailto:li...@zopyx.com>>
> Date: Thu, Nov 18, 2010 at 1:14 PM
> Subject: Re: [Zope-DB] Zope_Database_issue
> To: smita kamdar  <mailto:smita.kamda...@gmail.com>>
> Cc: zope-db@zope.org <mailto:zope-db@zope.org>
> 
> 
> smita kamdar wrote:
> 
> 
>> *ImportError: libpq.so.3: cannot open shared object file: No such file
>> or directory*
> 
> 
> This error message is self-speaking - either the Postgres library is not
> present or at a different place. Adjust your LD_LIBRARY_PATH as needed
> or fix the location of the Postgres libs.
> 
> -aj

___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db


- -- 
ZOPYX Limited   | zopyx group
Charlottenstr. 37/1 | The full-service network for Zope & Plone
D-72070 Tübingen| Produce & Publish
www.zopyx.com   | www.produce-and-publish.com
- 
E-Publishing, Python, Zope & Plone development, Consulting


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJM5O7pAAoJEADcfz7u4AZjK8gLwIZv94X7RjlMa3J1mgC7RVk+
3KJh1jG9C0lMTnEITlY5lQXkYkD8UGoU9NffrOenjm3mtqyt8XOQxkhXoBBTLxBI
T7yQ31p0Pf+NySxKyDbz3v3KxAeUjSQLHhj7WUGBAR0pHNxgX/fOIsiV/hg+pkES
RGbQoyuHO4IaX99T8L9e/9X+hlCvCGjLQN/WTO+F+24tqorxybpOQ/EOPmB+EJU4
ZsP/CR0tUqAs8AQnE8WN6p7olHDauqp2SHW0148ozLts3LWi5/9iO4NusUagr/Jn
riXQej2Aytu/5C6PtezgPfFBxBp4qOeOic28x8AYF0FXNWGjSnMv5eXbaSWMc7tI
tS+wREk6EdQZZL9omxOdE/2U4t5tFqh4vkgk6ggLo2goOaMTz+/kQoHoyWEhFuN6
uJvAh+cK82NcBXmbGvS8nvbEoYVZe3PQUcvG/az+jUI16Y/vGBTXdiLwgFDcPY6N
irIcMoyEEDn+9bwRoKPwKxfcaBOJxRw=
=74eI
-END PGP SIGNATURE-
<>___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope_Database_issue

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

smita kamdar wrote:

> 
> *ImportError: libpq.so.3: cannot open shared object file: No such file
> or directory*


This error message is self-speaking - either the Postgres library is not
present or at a different place. Adjust your LD_LIBRARY_PATH as needed
or fix the location of the Postgres libs.

- -aj
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJM5NlvAAoJEADcfz7u4AZjMjALwIyT4MD7KiqUYnM5vhCO6IMU
Q+h2qU5yjoY/6CjyEIKQ94ooSkjfBmNG0a3g1jlj62WyIUdBp9N0rw5fuL+W2bIK
KPhuJ8//JrWBoOCHk4M2waKG6EjZIarbsWZksYpcDJXkU25AcHVKAYmUMN8m4dTW
yFSOW8IhG5wM8O3In39/E1WiZm83eH/r0LsAWE43c54Ej+/Jc3TXMiUPHyvP0djB
Xktl44U8FXTaSl3T9OtBCpMzffEag9Rq+x2lcYphKjRZIUuXr5c3Vo/L+t8Cvq2W
p9k6Hpoj/wk+CfoWDBl5UKtBlI6hw3AuRCreufC5NcrOAYLSAi37DG/3thZnINag
t7PyGkXbSsMsg1G7RifxR+hZwDO/0g7RX7bytjzqX1y76l9xzXwyqfZwLL0RPIPq
/aZgRTLgdW2cBxSZlHNWHm1dw11bx01bPxM6rXUWp4s5IBH56E5WAjqD9Up/js7B
x3yt+iudq/v6LZ2afsgh6ykive4FM3g=
=QlHU
-END PGP SIGNATURE-
<>___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope_Database_issue

[Andreas Jung]

Try using Products.SQLAlchemyDA instead.

-aj

2010/11/16 smita kamdar 

>
>   Hi,
>
>
>
> I am a beginner in zope with no prior experience. I am supposed to setup a
> development environment with zope, postgres, python, openflow, egenix &
> psycopg.
>
>
>
> I have installed all of them on Red Hat Linux. All of them are installed
> successfully.
>
>
>
> I have properly installed Psycopg in the zope path i.e.
> (lib/python/Products) & that too with proper permissions.
>
>
>
> Now after installing psycopg, when I restart zope, I am not able to see the
> option ‘Add ZPsycopg Database Connection’ in the Zope Management Screen.
>
>
>
> And because of that I am not able to setup a database for the project.
>
>
>
> I request you to please help me for this. Any advice from you will really
> help me in a great way.
>
>
>
> Kindly suggest me something.
>
>
>
> Thanks a lot!!
>
>
>
>
>
> Thanks & Regards,
>
> Smita Kamdar
>
>
> ___
> Zope-DB mailing list
> Zope-DB@zope.org
> https://mail.zope.org/mailman/listinfo/zope-db
>
>
___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Migrating zope from Windows to Linux

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Joel Fitzgerald wrote:
> Hi all, we currently have a document management system running on a zope
> platform on a Windows 2003 server. We would like to investigate
> migrating this to a Linux OS.
> 
> Is this something that is achievable? Is there any documentation that
> may help get us started or point us in the right direction?
> 
>  

Create a Zope instance on Linux using the same software versions of Zope
and add-ons as used on Windows and copy over your Data.fs. That's it
basically - except you are running some hand-made software depending on
Windows features or so.

- -aj
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJMyNdLAAoJEADcfz7u4AZjYcsLv1za/9abTGIaDHwoCqHs48Hj
ptB1VcqabqxzE9ZYCNdVx3da10NhSg2lWrj95kOoXiH8hjeOjdk54MMb5JEIl/yE
CdHnNE3YzIhE7/wgG1RnL7lD2oaDVAjFXhFKJYNpZ9QApmiAturpCP3mL+k258p4
lb3I+PBG3F8YwyqB/HjXYPFwIUp5VAizNozrlnnPoSmzlDPaeesKNg2xSTlOnWKg
uyy2d7Bd9c6pCOR/4J9tRlOKw2+nsmQ1sCEqztW+BDjwhiumvS2JLJGQtzayPiGt
1FIOnGF+5pfrqDrC/LktSIqn31ddmCKI3V5edocAnT4/URdbGQYKfcgST2J5Qm+O
fYhPEQ8/HZ14voqZcEmMtqY+nmwNlDCNdhQ2l+9txpwV5tfpm9qrrUedKtBdy0dq
jD9cgtY1LvZWIDy/Y3EPxUWlv/2xVyuwOiKIhy/qKdZ5zsr/Fo4nlaDlMco6SM75
R9dTgHpCRdvl09IUVj1iylUr5mlNZ5A=
=Y4kf
-END PGP SIGNATURE-
<>___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope-DB Digest, Vol 72, Issue 1

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Richard Harley wrote:
> Hmmm..If the database was modeled properly in the first place if
> wouldn't be referenced in many different places therefore it would not
> require changes in tons of SQL methods.

Perhaps you haven't work with large installation using SQL heavily?
After having ported a project with roughly 200 ZSQL methods to
Sqlalchemy: it was a *huge* win working with the backend on the Python
level and dealing with database entities like Python objects.

> 
> SQL code isn't complicated, it does exactly what it says on the tin!
> (most of the time :)). 

SQL can become *very complicated* - ever tried to understand complex
SQL queries of other people? Working with a proper database model
on the Python level is much easier. Yes, you are moving complexity from
SQL to Python and ORM configuration can be confusing as well. However
a descriptive model of a database in Python with its relations is much
easier to handle than dealing with it on the SQL layer directly.

> ORM encourages lazy programming = problems later
> down the line.

Nonsense - using SQLAlchemy for more than four years now in four or five
larger projects and it is a major win regarding productivity, software
architecture, implementation and testing.

- -aj


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJMdPPnAAoJEADcfz7u4AZj6dULv13bzwtodOh1mM0hdl/OamKE
zBlXNMbcKWlZ0pFErFGWuhCQDjgFBTI5nXuNE/py8Ckmzdzrss2Opk1fselyv6qT
AC/++/FX/Zv5HA7yzVKeBGJ88KIoc/XcFm/5syQrbik67mSCtJcQyjoIOrjGXIy/
HmlbWzRYOYM7hORTkWEmsjPFEjlNfQFUx01CkAstkOp2nAsQe0LH2X9N2gs6BI1H
IORI0u0GkNPvkwXJTgHEoR62bPmrWS+MANdLORQI62G7Rm1WG8cZ/jMzUH6yT0r6
p0bGnca2eux3JyvBSm4p+8Ap64zEbjxhB/Iww5qzojSY+xgZmG0DUJKUAMeXMYZU
dd5es9CmoDRNsMjDfBsnciSRcHw9S+T/eRdcf8YEiUPkeSC1P/4RIbgk7vIWnyef
KtlNYoHCVL8IUIYAGOJNytiTp1Oxg9Q581KM2auFZpUSlZBLafovqGvJSCudxYbs
SlSiXx7aI6uv5vPLuOjMF/ZXPvfKp6E=
=Lrga
-END PGP SIGNATURE-
<>___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope-DB Digest, Vol 72, Issue 1

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Richard Harley wrote:
> Please can someone explain why ORM is better than speaking directly to 
> the database? Isn't this just  adding another layer of complexity which 
> in huge databases is certainly not needed.

Modifying the database schema (adding a new field) requires usually
changes in tons of SQL methods..updating your ORM schema definition
usually takes only one or a few lines of code.

Or why the hell do you want to write complicated SQL code (I
remember legacy code of a co-worker to tons of complex JOINs)
yourself while you could implement the same functionality in much
nicer way using Python?

If you ask me: writing SQL is for masochists.

- -aj
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJMdOvsAAoJEADcfz7u4AZjqyALwNWRbc5Pz3keM2x1wkDQfwfU
WdtHLdNvLO6jIRMadMjlO4lOgPU0/ANIlkrUFgmstiEkpEt4zj8IIBWYZfdkrryo
6Cb5OeYN+/stFURDSdqGPViJYxybbPFd2pmcX5HW9W9msxIsZsC7mmjLWgUWQEY4
XXZBLbSTWB3DQt1gOXXNrntPzuSopad6QUb/Pqb/JWF7dtE3WYFY2/ar0YWOd/iU
I7K3rKSTnQaBiDBwFrdrm/hHgeA34zlCs4M0qb8tWKCLsafwYNojAxdF28ScLSBD
pHbxmcQY3aRqkHFPC1DZLqJNmMqbDitIpeUqgx6oLIc73trk2znRmT/HHFP+UhWU
K72Qs6fBfEu1dvJYCA2iKFk2aE83ckqbdQnpwYtL0S3pVY3V5s1Z1ZQ4T1rz4+19
BnuClXsZEWxfn8nn3uNZ0kpv9RI3Tw2qRgd4L5vk1s/mCFCRUi1riCKkEb/U8ygI
kiJw/Zv6hJrgY74ZA67sfaymJ6hrSfE=
=JGcb
-END PGP SIGNATURE-
<>___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] ZSQL Question - Insert multiple rows in one statement?

[Andreas Jung]

2010/8/25 Jaroslav Lukesh 

>
> - Puvodní zpráva - Od: "Andreas Jung" 
>
>
>
>  -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> I would assume that you can use DTML-IN for looping and generating
>> multiple SQL statements of the same kind. You have to ensure that
>> the statements having a proper delimiter (there was something in DTML?!
>> DTML-SQLDELIMITER?...no idea, you need to checks the docs of this
>> ancient technology).
>>
>
> DTML is mature, not ancient. For ZSQL is DTML the best one.


For ZSQL methods perhaps - fortunately we moved on and we are having
higher-level
solutions like ORMs for implementing SQL connectivity in a more clean way.
Of course, use SQL and ZSQL methods if you need to...but from the
prospective
of software architecture we have better solutions in our toolbox.


>
>
> Did you try to make many small dynamic javascript in one page with ZPT?
> Yeah, python scripts calling, instead of placing small dtml code into
> javascript in page...
>
> ZPT is more academic platform, than for everyday usage.


Truly  nonsense.  ZPT is the adopted solution in the Zope universe for doing
templating - for a variety of reasons
(e.g. support for unicode, ZPT is maintained - DTML has not seen any changes
and fixes lately).

-aj

>
___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] ZSQL Question - Insert multiple rows in one statement?

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I would assume that you can use DTML-IN for looping and generating
multiple SQL statements of the same kind. You have to ensure that
the statements having a proper delimiter (there was something in DTML?!
DTML-SQLDELIMITER?...no idea, you need to checks the docs of this
ancient technology).

- -aj

Mark Phillips wrote:
> When I retrieve multiple values from a selection box, I need to create a
> loop somewhere to insert the multiple values (rows) into a table. Is
> there a way to do this within a ZSQL statement, or is it best to do the
> looping in a Python script?
> 
> My specific example
> 
> table 1 (Players) has information about players (i.e. team members for a
> sports team). There is a primary key - playerID
> table 2 (Seasons) has information about each season - primary key is
> seasonID
> table 3 (PlayerSeasons) has two columns - playerID and seasonID.
> 
> The form to crud a player has a combobox where one can select multiple
> seasons for a player. When I do an add or update, I have to add one or
> more rows to the PlayerSeasons table. Does this loop have to be in a
> Python script, or can it be implemented in ZSQL? I looked at the
> 'multiple' keyword, but all the examples indicate that it apples to sql
> tests, such as testing against a set of values. I can't seem to find any
> examples where one is inserting multiple rows into a table.
> 
> Thanks!
> 
> Mark
> 
> 
> 
> 
> ___
> Zope-DB mailing list
> Zope-DB@zope.org
> https://mail.zope.org/mailman/listinfo/zope-db


- -- 
ZOPYX Limited   | zopyx group
Charlottenstr. 37/1 | The full-service network for Zope & Plone
D-72070 Tübingen| Produce & Publish
www.zopyx.com   | www.produce-and-publish.com
- 
E-Publishing, Python, Zope & Plone development, Consulting


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJMc9/tAAoJEADcfz7u4AZjlPwLwNiLG+kZUrlZ+BuFEWKL42eE
bmzllHixdEq6qy2gHP3pbf5AmICS66JJGfqaI6Gv7JqxY6XM1N35oeXK7PzUk+gb
PYPtIwN62HMQzrvYXB6JHyFEkyMuOd9MFyyHMgh24JqC6xtMBbYI3+yjiXJor1QP
Xd56qoxWmhHZVnC2YhddpR3DLlAx/qebi2mk+C15g2C+LkVzz0J2rHb5FNB/Izdt
uJmknn9pDjBewSQhtPIsX/rj7R4SUtJUZ78H8Isn2yoEftsG4ONtpzT3O9ICXF4R
Y4V/iV9KepUoxU5dpH9YDTl00YA6UVvyafhDufkPzq5dnKUQL+QzPXFcmC9tSRux
OIDiTOLZwYVS0a5hT/OUtYB1p+JGhITxLKxspXH4vJ5po8IJR7CmxO0FOooqGeOc
muaWclDrxPIsyWEAEZg6+ahyydWgFCePuMLCrEEvhZRpx4DxvhisXRVB5V/h6Z7L
OSSYDljCM/mu1mKIPRUuHqBlc0mB4qI=
=1o0Q
-END PGP SIGNATURE-
<>___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Question Concerning Z SQL Method and Class Bindings

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Mark Phillips wrote:
> Peter,
> 
> I don't think I phrased my question very well. Also, I am coming from a
> Java background, so I am thinking about result sets, which may not be
> applicable to Python.
> 
> If I have a Z SQL Method query that returns multiple rows to a brains
> class, how do I
> 
> (1) reference the returned object that has all the rows
> (2) reference a particular row in the returned object
> (3) reference a particular piece of data in the returned object.
> 
> What is the returned object - list, dictionary, some special object with
> associated APIs?
> 
> Where is this documented? I can't seem to find it in the Zope 2 book.
> 
>

If you want object-oriented approach in your Zope app: use an ORM like
SQLAlchemy or Storm. Sqlalchemy + zope.sqlalchemy (or z3c.sqlalchemy)
are widely used for SQL connectivity inside Zope/Plone/Python apps.

- -aj
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkv8otEACgkQCJIWIbr9KYy+4ACgr0LCPDN/lPuYNGDq7AGxXP+P
wK8AnjQMDVx3sYd1wlMIYxf6Cd7JFcBG
=dM/l
-END PGP SIGNATURE-
<>___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] problem with using ZMySQLDA

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

The error message is self-speaking. Either libssl is not installed
or not configured. Check if the file is available and where. Install
it (or the related package) and/or adjust your ld.so.conf or the
LD_LIBRARY_PATH environment variable.

- -aj

On 14.02.2009 1:29 Uhr, problem solver wrote:
> Hello All,
>  I am trying to install ZMySQL on my v ubuntu server,
> everything went fine except when I ran into this problem, any help would be
> really appreciated.
> 
> Thanks!
> 
> ps: I have also installed libssl-dev :/
> 
> 2009-02-13T18:39:14 ERROR Zope Could not import Products.ZMySQLDA
> Traceback (most recent call last):
>   File "/opt/Plone-2.5/lib/python/OFS/Application.py", line 715, in
> import_prod$
> product=__import__(pname, global_dict, global_dict, silly)
>   File "/opt/Plone-2.5/lib/python/Products/ZMySQLDA/__init__.py", line
> 91, in ?
> import DA
>   File "/opt/Plone-2.5/lib/python/Products/ZMySQLDA/DA.py", line 92, in ?
> from db import DB
>   File "/opt/Plone-2.5/lib/python/Products/ZMySQLDA/db.py", line 89, in ?
> import _mysql
>   File "build/bdist.linux-i686/egg/_mysql.py", line 7, in ?
>   File "build/bdist.linux-i686/egg/_mysql.py", line 6, in __bootstrap__
> ImportError: libssl.so.6: cannot open shared object file: No such file
> or direc$
> 
> 
> 
> 
> 
> ___
> Zope-DB mailing list
> Zope-DB@zope.org
> http://mail.zope.org/mailman/listinfo/zope-db


- -- 
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: i...@zopyx.com - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK
- 
E-Publishing, Python, Zope & Plone development, Consulting

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkmWagkACgkQCJIWIbr9KYyOMwCfQFwR2YIxMM7Ct04Ved8hdNhE
a5kAnjp9eVfOEWMOsoedIyKGYj41mIZn
=+ulh
-END PGP SIGNATURE-
begin:vcard
fn:Andreas Jung
n:Jung;Andreas
org:ZOPYX Ltd. & Co. KG
adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
email;internet:i...@zopyx.com
title:CEO
tel;work:+49-7071-793376
tel;fax:+49-7071-7936840
tel;home:+49-7071-793257
x-mozilla-html:FALSE
url:www.zopyx.com
version:2.1
end:vcard

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Oracle Connection - Zope + Windows

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 20.01.2009 6:51 Uhr, Nachiyappan wrote:
> Dear Zope Experts ,
> 
> I am using Zope 2.9.4-final, python 2.4.1, Windows xp . My question is ,
> How to create oracle connection in zope for windows xp ?
> I have downloaded DCOracle2 for windows . but it is not working . please
> help me .
> 

"does not work" means what exactly?

- -aj
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkl1fgYACgkQCJIWIbr9KYwLFQCfUd/xzROuad48AJBpFsU3h14p
X20AnjmKFTmOUaPTZ6xDPxV4rL3dHNdP
=NomU
-END PGP SIGNATURE-
begin:vcard
fn:Andreas Jung
n:Jung;Andreas
org:ZOPYX Ltd. & Co. KG
adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
email;internet:i...@zopyx.com
title:CEO
tel;work:+49-7071-793376
tel;fax:+49-7071-7936840
tel;home:+49-7071-793257
x-mozilla-html:FALSE
url:www.zopyx.com
version:2.1
end:vcard

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] How to work with Sessions in Zope

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 20.01.2009 5:07 Uhr, Nachiyappan wrote:
> Hi Zope Experts ,
> 
> i am new to zope . i want to know , how to work with sessions in zope ?
> If anyone have guide about this please send me .

"The Zope Book 2.7 edition" is your friend.

- -aj
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkl1UM0ACgkQCJIWIbr9KYxqBACfWeRX8bb2OneAJPeAv9pqY5xs
ItoAniwKEPh98Iu10x4/DxxQn9gj5m/u
=XIKG
-END PGP SIGNATURE-
begin:vcard
fn:Andreas Jung
n:Jung;Andreas
org:ZOPYX Ltd. & Co. KG
adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
email;internet:i...@zopyx.com
title:CEO
tel;work:+49-7071-793376
tel;fax:+49-7071-7936840
tel;home:+49-7071-793257
x-mozilla-html:FALSE
url:www.zopyx.com
version:2.1
end:vcard

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

[Zope-DB] [Fwd: Re: Zope - Oracle Database Connection]

[Andreas Jung]

Stay on the list!

"The same error"?? Which error?

-aj

 Original Message 
Subject: Re: [Zope-DB] Zope - Oracle Database Connection
Date: Mon, 01 Dec 2008 12:16:41 +0530
From: Nachiyappan <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
References: <[EMAIL PROTECTED]> 
<[EMAIL PROTECTED]>


Hi Andreas

i am using zope for windows , i have downloaded DAOracle from zope site
and installed the same . but i'm getting the same error
Please help me

Regards
Nachs



Andreas Jung wrote:

If you are on Windows, you might consider using something based on
ODBC (mxODBC (commercial but considered good) or some free variant
(check zope.org)). If you are on Unix, you might consider installing
cxoracle
(for the Python bindings to Oracle) + SQLAlchemy as ORM (re-using
cxoracle). If you do SQL programming, look at SQLAlchemyDA on top of
SQLAlchemy or do ORM programming directly on the ORM layer...maybe you
explain what your goal is.

-aj

On 01.12.2008 5:42 Uhr, Nachiyappan wrote:

Hi Zope Gurus ,

i am new to oracle and php . i am developing a web appplication using
PHP , Python , Zope and Oracle .

My question is how can i make database connection to oraclein zope ?

i have installed DCOracleda for oracle . but i didn't make connection
in zope to oracle ! Zope won't display the connection adapter .

  Is there any other methods available , please let me know the
procedures to connect

Thanks in Advance


Regards

Nachs


Confidentiality Notice

The information contained in this electronic message and any
attachments to this message are intended for the exclusive use of the
addressee(s) and may contain confidential or privileged information.
If you are not the intended recipient, please notify the sender at
HMA or [EMAIL PROTECTED] immediately and destroy all copies
of this message and any attachments.



HMA STARWARE LTD, CHENNAI, INDIA


!-- Virus-Free Mail Using AntiVirus for IQ Mail& QuickHeal Engine --!




___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db



!-- Virus-Free Mail Using AntiVirus for IQ Mail & QuickHeal Engine --!


Confidentiality Notice

The information contained in this electronic message and any attachments 
to this message are intended for the exclusive use of the addressee(s) 
and may contain confidential or privileged information. If you are not 
the intended recipient, please notify the sender at HMA or 
[EMAIL PROTECTED] immediately and destroy all copies of this 
message and any attachments.




HMA STARWARE LTD, CHENNAI, INDIA


!-- Virus-Free Mail Using AntiVirus for IQ Mail & QuickHeal Engine --!

--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK

E-Publishing, Python, Zope & Plone development, Consulting

begin:vcard
fn:Andreas Jung
n:Jung;Andreas
org:ZOPYX Ltd. & Co. KG
adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
email;internet:[EMAIL PROTECTED]
title:CEO
tel;work:+49-7071-793376
tel;fax:+49-7071-7936840
tel;home:+49-7071-793257
x-mozilla-html:FALSE
url:www.zopyx.com
version:2.1
end:vcard

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Zope - Oracle Database Connection

[Andreas Jung]

If you are on Windows, you might consider using something based on ODBC 
(mxODBC (commercial but considered good) or some free variant (check 
zope.org)). If you are on Unix, you might consider installing cxoracle
(for the Python bindings to Oracle) + SQLAlchemy as ORM (re-using 
cxoracle). If you do SQL programming, look at SQLAlchemyDA on top of 
SQLAlchemy or do ORM programming directly on the ORM layer...maybe you 
explain what your goal is.


-aj

On 01.12.2008 5:42 Uhr, Nachiyappan wrote:

Hi Zope Gurus ,

i am new to oracle and php . i am developing a web appplication using PHP , 
Python , Zope and Oracle .

My question is how can i make database connection to oraclein zope ?

i have installed DCOracleda for oracle . but i didn't make connection in zope 
to oracle ! Zope won't display the connection adapter .

  Is there any other methods available , please let me know the procedures to 
connect

Thanks in Advance


Regards

Nachs


Confidentiality Notice

The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain confidential or privileged information. If you are not the intended 
recipient, please notify the sender at HMA or [EMAIL PROTECTED] immediately and 
destroy all copies of this message and any attachments.



HMA STARWARE LTD, CHENNAI, INDIA


!-- Virus-Free Mail Using AntiVirus for IQ Mail& QuickHeal Engine --!




___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db



--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK

E-Publishing, Python, Zope & Plone development, Consulting

begin:vcard
fn:Andreas Jung
n:Jung;Andreas
org:ZOPYX Ltd. & Co. KG
adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
email;internet:[EMAIL PROTECTED]
title:CEO
tel;work:+49-7071-793376
tel;fax:+49-7071-7936840
tel;home:+49-7071-793257
x-mozilla-html:FALSE
url:www.zopyx.com
version:2.1
end:vcard

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Help me.

[Andreas Jung]

--On 11. März 2008 22:13:29 +0700 Cu Vinh Loc <[EMAIL PROTECTED]> wrote:


  Dear friends,

  I am using plone for deploying the website, but I have some problems
such as:
   - Using relational (internal) database "Gadfly database": I do not know
where the database is stored in the Zope.


Please forget Gadfly. If you are seriously thinking about using a RDBMS for 
whatever reason then consider using a real database like Mysql, Postgres...

There are various ways for interacting with a RDBMS in Zope:

- using ZSQL methods (check "THe Zope Book 2.7 edition RDBMS Chapter")
- wrappers based on SQLAlchemy: collective.lead or z3c.sqlalchemy or
  ZSQLAlchemyDA

-aj

pgpiUtGRHbhWO.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] compiling dco2.c with Oracle 10g using mingw on Windows XP - interesting errror

[Andreas Jung]

You might consider using cx_oracle as an alternative to DCO2. cx_oracle 
could be integrated with Zope as an DA using SQLAlchemyDA (although 
untested). DCO2 is pretty old and seems to be unmaintained.


-aj

--On 5. Dezember 2007 18:32:14 -0600 "Maan M. Hamze" <[EMAIL PROTECTED]> 
wrote:



I compiled dco2.c on Solaris 9 with Oracle 9i and Oracle 10g with no
problems.
On Windows XP, compiling dco2.c with Oracle9i is fine.

With Oracle 10g on Windows XP (using Mingw C compiler), I ran into
following errors:
#
In file included from C:/oracle/ora10/oci/include/oci.h:394,
 from dco2.c:109:
C:/oracle/ora10/oci/include/oratypes.h:97: error: syntax error before
"oraub8"
C:/oracle/ora10/oci/include/oratypes.h:97: warning: data definition has no
type
or storage class
C:/oracle/ora10/oci/include/oratypes.h:98: error: syntax error before
"orasb8"
C:/oracle/ora10/oci/include/oratypes.h:98: warning: data definition has no
type
or storage class
C:/oracle/ora10/oci/include/oratypes.h:99: error: syntax error before
"ub8" C:/oracle/ora10/oci/include/oratypes.h:99: warning: data definition
has no type
or storage class
C:/oracle/ora10/oci/include/oratypes.h:100: error: syntax error before
"sb8" C:/oracle/ora10/oci/include/oratypes.h:100: warning: data
definition has no type
 or storage class
###

Culprit is this, in oratypes.h:

# define ORAXB8_DEFINED
# ifndef lint
 typedef unsigned _int64 oraub8;
 typedef signed _int64 orasb8;
 typedef oraub8 ub8;
 typedef orasb8 sb8;
# else
# define ub8 oraub8
# define sb8 orasb8
# define oraub8 unsigned _int64
# define orasb8 signed _int64
# endif /* !lint */

---

_int64 

Changing this to __int64 solved the problem, and dco2.c compiled fine.

_int64 caused the problem in oratypes.h of Oracle10g.

Can this be fixed via some define in dco2.c so that I do not have to
change oratypes.h (_int64 to __int64)?

Thanks,
Maan



___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db




--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK

E-Publishing, Python, Zope & Plone development, Consulting


pgpuYUMOTT7hh.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Reading Oracle BLOBS from Zope

[Andreas Jung]

--On 7. September 2007 15:08:48 -0400 "Kenneth A. Englund" 
<[EMAIL PROTECTED]> wrote:



  I want to read an Oracle BLOB and display it.  I have seen several
examples on the internet, but none of them seem to work.

I am on the following platform:

Zope Version  (Zope 2.6.1 (source release, python 2.1, linux2), python
2.1.3, linux2) Python Version  2.1.3 (#1, Sep 19 2002, 21:42:04) [GCC
2.96 2731 (Red Hat Linux 7.3 2.96-110)] System Platform  linux2



Zope 2.6.1 is *old*. You might look at the various SQLAlchemy wrappers 
available for Python which should support Oracle BLOBs.


-aj



pgpfU36WfeQHD.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] total- variables does not work with MySQL 5.x

[Andreas Jung]

--On 30. August 2007 09:08:07 +0200 Lukas Zapletal 
<[EMAIL PROTECTED]> wrote:



Hello,

I have a problem with "total-*" variables when suming results from
MySQL 5.x. It does not work with monetary (float) numbers - only with
integers. When trying to sum floats it cointanins nulls. IMHO the
reason is in a driver because it probably do not convert numbers in
national currency format (some countries, e.g. mine, do not use dot as
separator). The problem is that the driver is outdated and old.

Is there a fixaround? How could I for example convert the numbers
explicitely? Or how do I ovverride the behaviour of the code that is
responsible for the sumarizing?



Not sure how your issue relates to Zope. Zope basically only generates the 
queries using ZSQL methods and returns the results back. Check if this
error also happens when you connect directly to MySQL using the standard 
Pytrhon DB-API.


Andreas

pgpVO60WfXL7G.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Connecting Zope 3 to Oracle 10g

[Andreas Jung]

--On 16. Juli 2007 12:31:50 +1000 Catriona Johnson 
<[EMAIL PROTECTED]> wrote:



Hello

I am a novice Zope 3 user and would like some help in the best method
to connect to an existing Oracle instance using Zope 3. The reason I
want to do this is to take advantage of Oracle's spatial data types
and our corporate data store.

I am developing an OLTP web application that allows users to manage
their own data with the possibility of developing some kind of data
warehouse with nonspatial and spatial data.




Look at z3c.sqlalchemy or z3c.zalchemy.

-aj

pgpc51WPfAzD5.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Migration from Windows to Linux. How to do it?

[Andreas Jung]

--On 5. Juli 2007 18:26:34 -0700 Mongolkhuu Baatar <[EMAIL PROTECTED]> 
wrote:




 I have tried and copied only Data.fs file from Windows to Linux machines
related "/var/opt/zope/default/var/" folder.   Then I have problem with
my Plone server running instead Zope of port number 8080.


"have problem" means what? We can not help if you don't describe what your
real problem is. Any related network configuration happens in zope.conf.

-aj

P.S. you're on the wrong list. For Plone related issues use the Plone-users 
list or at least the [EMAIL PROTECTED] list. This issue isn't DB related as the 
mailinglist name indicates.

pgp4WCJb711JD.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

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

[Andreas Jung]

First, Jaroslav is right. One time you're passing a string and next
your passing a list. Make your choice how the API should looks like.

Second..it would be *really* helpful to see the full traceback instead
of just *Keyerror*. It's somewhat boring to ask every time for it :-)

-aj

--On 16. Juni 2007 15:19:10 -0400 Ken Winter <[EMAIL PROTECTED]> wrote:


Jaroslav ~

I'm pretty sure that 'delete_this' is a list (of integers), because the
lines

"
p = context.REQUEST.get('delete_this')
s = ', '.join([str(x) for x in p])
"

process it correctly into the string 's'.  In other words, I think it is
the same as if p had been assigned a list in this way:

"
p = [9765, 10058, 11333]
s = ', '.join([str(x) for x in p])
"

In either case, s ends up as the string "9765, 10058, 11333".  That's what
gets passed to the ZSQL method (below), and that's where 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 List'
Subject: Re: [Zope-DB] Using s in ZSQL methods?

It is just because 'delete_this' is a string, not the list, or vice
versa?

- Original Message -
From: "Ken Winter" <[EMAIL PROTECTED]>
To: "'Zope-DB List'" 
Sent: Saturday, June 16, 2007 5:15 AM
Subject: [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 ZSQL method through the ZMI, passing it a
string
such as "9765, 10058, 11333", it indeed deletes the rows with those
values on person_id.

BUT when I invoke the same ZSQL method from a Python script with the
following code:

"
p = context.REQUEST.get('delete_this')
if p:
s = ', '.join([str(x) for x in p])
context.people_delete_by_id(id_list=s)
"

...and with a REQUEST variable 'delete_this' that comes from this snippet
of
a form in a page template:

"









...


...

"

...and with the same three person_ids (9765, 10058, 11333) the 4th line
of the Python script evokes an error:

"
KeyError: 'id_list'
"

The core idea is that the string id_list is passed into the ZSQL method,
where it is spliced into the "delete...where" clause via the ) to provide the list of person_ids to delete.


Here's the question:

WHY?

~ TIA
~ Ken

P.S.  I know that  rather than  is an
unorthodox and apparently undocumented construct to use within a ZSQL
definition.  But I need it because  malformats the
string. And if doing this trick is a no-no, how come it works in the ZMI
test but not when called from Python?  More importantly, how can I get
it to work from Python?

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db




--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK

E-Publishing, Python, Zope & Plone development, Consulting


pgpX6f3WaiFKL.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

[Zope-DB] [ANN] SQLAlchemyDA 0.3.0 released - a generic database adapter for Zope 2

[Andreas Jung]

I am pleased to announce the first public release of

 SQLAlchemyDA V 0.3.0

Download:
-

  <http://opensource.zopyx.com/software/sqlalchemyda/releases/0.3.0>


What is SQLAlchemyDA?
-

SQLAlchemyDA is generic database adapter for ZSQL methods. Since it is 
based on SQLAlchemy, SQLAlchemyDA supports all databases out-of-the box 
that are supported by SQLAlchemy (Postgres, MySQL, Oracle, SQLite, MS-SQL, 
Firebird, Informix).



Changes in 0.3.0:

   - fixed some security assertions

   - added "Test" tab for executing SQL queries directly

   - better error handling for ZMI screens

   - no longer depending on a pre-registered SQLAlchemy wrapper.
 SQLAlchemyDA  now accepts (as any other DA) a DSN as property 'dsn'

   - DSN can be passed through the add form

   - redirect directly to "Info" tab after creating an instance through
 the ZMI

   - catching some low-level exceptions from the sqlite interface in
 order to make it work with SQLite

   - new properties 'transactional' and 'quoting_style'

   - improved support for Oracle and MySQL

   - SQLAlchemyDA no longer provides access to mapper
 related functionalities.
 It now acts as a DA for executing SQL statements *only*.

   - fixed unregistration code for a wrapper (hopefully works with
 Zope 2.8 or higher)

   - updated documentation


Requirements:
-

 - Zope 2.8+, Zope 3.3+

 - SQLAlchemy 0.3.X

 - z3c.sqlalchemy 1.0.5 +


License
===
SQLAlchemyDA is  licensed under the Zope Public License 2.1.
See LICENSE.txt.

This release has been funded by Renovis, SF, USA.

Andreas Jung

--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK

E-Publishing, Python, Zope & Plone development, Consulting


pgp7Di1QJn3Au.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

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

[Andreas Jung]

--On 14. Juni 2007 10:41:46 -0400 Ken Winter <[EMAIL PROTECTED]> wrote:


-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 database transaction,
so
> that no other user can inset another record between the two actions in
> this ZSQL method?
>

*If* you database provides
transaction support and *if* your DA integrates with the transaction of
Zope
*then* everything happening within one Zope request will happen within
one Zope transaction and therefore within one DB transaction. This isn't
necessarily true to databases like MySQL.

-aj


My database is PostgreSQL 8.x and my adapter is ZPsyocopgDA.  Does this
combination provide the transaction support you're talking about?



*Of course*

-aj

pgpcUMmhhtNvJ.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

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

[Andreas Jung]

--On 13. Juni 2007 21:11:08 -0400 Ken Winter <[EMAIL PROTECTED]> wrote:


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?


You have to answer this question your self. It depends on your database, 
your isolation level and your database adapter



2.  Will it do this even if another user inserted another person just in
between the two SQL actions in this ZSQL method?


see above.


3.  In other words: Does a ZSQL method initiate a database transaction, so
that no other user can inset another record between the two actions in
this ZSQL method?



This is a completely different question. *If* you database provides 
transaction support and *if* your DA integrates with the transaction of Zope
*then* everything happening within one Zope request will happen within one 
Zope transaction and therefore within one DB transaction. This isn't

necessarily true to databases like MySQL.

-aj



pgpsqiixBCfep.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] FileMaker with Zope

[Andreas Jung]

--On 23. Mai 2007 10:50:40 +0100 David Daniel Estévez Durey 
<[EMAIL PROTECTED]> wrote:


Hello Andreas! First of all, thank you very much for answering.
Yes! of course I took all advices into account, and then someone told me
that I could make an ODBC connection.


Have you tried SQLAlchemy?
Have you tried z3c.sqlalchemy together with SQLAlchemy?
Have you tried SQLAlchemyDA together with SQLAlchemy?

If yes, why did it work? We would like to hear feedback and informations
about errors *in order* to improve our software. So please be a bit more
helpful...


From what I heard: SQLAlchemy is working on several systems over ODBC.

So if your DB speaks ODBC then there is a good chance to make it work.
If it does not work then please explain what the problems are.

-aj

pgppcWGcfrSGB.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] FileMaker with Zope

[Andreas Jung]

--On 23. Mai 2007 10:52:42 +0100 David Daniel Estévez Durey 
<[EMAIL PROTECTED]> wrote:



Thank you very much for answering, Dieter, but the same I explained to
Andreas, money is a very big problem in my case.



Then the final answer is: No, there is no suitable for solution for you.

-aj

pgpjPKvFInNdG.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] FileMaker with Zope

[Andreas Jung]

--On 22. Mai 2007 13:54:14 +0100 David Daniel Estévez Durey 
<[EMAIL PROTECTED]> wrote:



Hello,

I'm trying to connect FileMaker with Zope through ODBC, but I'm not sure
if I could do this for free, without buying any driver or software. Can
anyone explain to me how to do it or if it isn't possible?



You ask that already two weeks ago and got several advices...did you take
them into account? If yes and if they don't fulfill your requirements, 
spend 95 Euro for mxODBC from Egenix and be a happy man. 95 Euro don't 
justify a week-long research with zero results.


-aj

pgpKb6TRzBXEV.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: Fwd: [Zope-DB] Connecting FileMaker with Zope

[Andreas Jung]

--On 3. Mai 2007 11:14:10 +0100 David Daniel Estévez Durey 
<[EMAIL PROTECTED]> wrote:



Thank you very much for answering.

I'm reading the documentation of SQLAlchemy project, but I'm realizing
that FileMaker isn't supported:

http://www.sqlalchemy.org/docs/dbengine.html#dbengine_supported



Please read carefully. Since your database obviously speak ODBC you could
use the ODBC level of SQLAlchemy through pyodbc:

Read this:



-aj

pgpCnfNcjAixa.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Connecting FileMaker with Zope

[Andreas Jung]

--On 3. Mai 2007 10:44:36 +0100 David Daniel Estévez Durey 
<[EMAIL PROTECTED]> wrote:



Hello,

I am trying to connect my FileMaker database with Zope, so I need a Zope
Database Adapter for FileMaker. I haven't founded any in the Zope site,
in exception of mxODBC Zope DA, but this bridge isn't free.



You might look at SQLAlchemy (mssql:// protocol support pyodbc). As 
integration of SQLAlchemy you might check z3c.sqlalchemy and SQLAlchemyDA.


-aj

pgpTUlmI43Rbm.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

[Andreas Jung]

--On 26. März 2007 22:49:21 +0200 Maciej Wisniowski 
<[EMAIL PROTECTED]> wrote:



My posting says *nothing* about deprecating something. So __please__
stop reading between the lines when there is nothing - except
whitespaces.

But you said about *replacing* all different zope DAs. So I think
it is not reading between lines.

I agree that this kind of adapter (as additional one) is a nice idea :)


For all who might be interested: there is now something like that
called SQLAlchemyDA:



It uses my z3c.sqlalchemy implementation. The code quality is still alpha 
but good enough to let it work with ZSQL methods (but only roughly tested).


Feedback welcome!
Andreas

pgpS94MllJA2u.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] General Recommendations for a MySQL Connection

[Andreas Jung]

--On 23. April 2007 11:46:58 -0400 [EMAIL PROTECTED] wrote:


Hi all,
  I could use a recommendation on connecting to MySQL databases.  I'll
keep it short and say that we have a few apps now that connect to MySQL
and that have taking a 'wrong turn' in development.  I think fulfilling
these requirements will solve our issues and keep the development on the
right path and I would greatly appreciate feedback.
1.)  Provide a migration path to zope3.  An application that provides a
connection object which can provide the same API for zope2/Five and
zope3(we're currently using zope 2.9.6/Five 1.4)
2.)  Provide 1 connection which will also try to reconnect when accessed
if the connection has timed out, the server has restarted.

We're currently importing MysqlDB which I think I could genarlize a bit.
I've used the zope 2 mysqlDA in the past which has seemed pretty stable,
but is this the way to go if the plan is to eventually migrate to zope3.
I've also looked at zalchemy which  I  think could also be used to
provide a utility with a connection pool, but seems to be more than what
we need right now.



Independent of the question Zope 2 vs. Zope 3: I would use something 
SQLAlchemy based nowadays. My tool z3c.sqlalchemy works with Zope 2, Zope 3

and Python-only environments.

-aj

pgpzGxcLjPFwq.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

[Andreas Jung]

--On 26. März 2007 22:49:21 +0200 Maciej Wisniowski 
<[EMAIL PROTECTED]> wrote:



My posting says *nothing* about deprecating something. So __please__
stop reading between the lines when there is nothing - except
whitespaces.

But you said about *replacing* all different zope DAs. So I think
it is not reading between lines.


Well you know that Zope does not skip with any DA (except the one
for Gadyfly). So I am not in the position to replace anything in the Zope
core that does not exist :-) Especially I am not in the position to
replace any third-party products. So my whole posting has absolutely
nothing to with the Zope core. I am just trying to collect feedback - good
or bad - for a such a project  - *totally independent* of the Zope 2 core.
I hope this was clear enough - even for Dieter.


I agree that this kind of adapter (as additional one) is a nice idea :)


Andreas

pgpaD0GiU0l8j.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

[Andreas Jung]

--On 26. März 2007 22:21:02 +0200 Dieter Maurer <[EMAIL PROTECTED]> 
wrote:



Andreas Jung wrote at 2007-3-25 17:49 +0200:

In the Zope 2 worlds we have dedicated database adapters
for different databases. Fortunately the Python world made us a
wonderful present called SQLAlchemy that abstracts the different
databases. In the Zope world we have some wrappers like
z3c.zalchemy and z3c.sqlalchemy... basically they deal with connection
handling, mapper handling and integration with the Zope transaction
system. Would it make sense to replace all different Zope DAs with
a generic DA on top of one of the z3c.* wrappers? I think it would not
be too hard to write such a DA...or am I missing something? Thoughts?


As I think I know you a bit, I would expect that you also want
to deprecate the current support and get rid of it altogether
within a year.


My posting says *nothing* about deprecating something. So __please__
stop reading between the lines when there is nothing - except whitespaces.



This would get an even greater desaster than the tried removal of "zLOG":
huge amounts of applications would stop to work -- and many people
would stop to use new Zope releases.
>



Otherwise, I would not object against an *additional* SQLAlchemy based
adapter.


That's *exactly* what I am talking about - an *additional* generic DA
on top of SA  where we don't have to care about the different RDBMS
flavours - at least not the ones directly supported through SA.

-aj

pgp6f2ihWA6Ze.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

[Andreas Jung]

--On 25. März 2007 23:54:14 +0200 Maciej Wisniowski 
<[EMAIL PROTECTED]> wrote:



In the Zope 2 worlds we have dedicated database adapters
for different databases. Fortunately the Python world made us a
wonderful present called SQLAlchemy that abstracts the different
databases. In the Zope world we have some wrappers like
z3c.zalchemy and z3c.sqlalchemy... basically they deal with connection
handling, mapper handling and integration with the Zope transaction
system. Would it make sense to replace all different Zope DAs with
a generic DA on top of one of the z3c.* wrappers? I think it would not
be too hard to write such a DA...or am I missing something? Thoughts?


Now (in Zope2) we have things like ZOracleDA (DCOracle2), ZPsycopgDA
etc. that are adapters to these specific databases. They're based on
Shared/DC/ZRDB/.
In Zope3 there are also such adapters eg. one using cx_Oracle. They're
based on Zope3 rdb module.

What do you mean by 'replacing' them? You want wrapper build for
z3c.* to be used instead of ZRDB (rdb)?

You're talking about Zope2 or Zope3 too?


The subject says Zope 2:-)

-aj

pgplwOvDfcK4O.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

[Zope-DB] Unified DA for Zope 2 using SQLAlchemy?

[Andreas Jung]

Hi,

Sunday afternoon, time for some weird thoughts :-)

In the Zope 2 worlds we have dedicated database adapters
for different databases. Fortunately the Python world made us a
wonderful present called SQLAlchemy that abstracts the different
databases. In the Zope world we have some wrappers like
z3c.zalchemy and z3c.sqlalchemy... basically they deal with connection
handling, mapper handling and integration with the Zope transaction
system. Would it make sense to replace all different Zope DAs with
a generic DA on top of one of the z3c.* wrappers? I think it would not
be too hard to write such a DA...or am I missing something? Thoughts?

Andreas

pgpJYBprLJhKI.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] MySQL gone away

[Andreas Jung]

--On 20. März 2007 09:18:19 +0100 [EMAIL PROTECTED] wrote:


Hello,

I am getting errors in queries on a MySQL 5.027 database using zmysqlda
2.0.9b3 and mysql-python 1.2.1 with Zope 2.10.2.

The errors occured the next day after setting the whole thing up and
while at first it was working all right. The event log tells me that
MySQL has 'gone away', it probably has lost its connection in the zmysql
adapter. But why or how?


How shall we know why your database went down? :-)
Check for indications on the mysql server side  - means: check your mysql
server logs.

-aj

pgpzBhEtSOr4e.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] zmysql filesystem database connection

[Andreas Jung]

--On 19. März 2007 10:09:06 +0100 javi lopez <[EMAIL PROTECTED]> wrote:


hello everyone
how to do a filesystem database connection??
I need it for my product, how to create it??


You asked already on the Zope list and got some answers.

-aj

pgpshkdQdZuJy.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] MySQL-python and MAC OS X

[Andreas Jung]

--On 12. März 2007 14:52:34 +0100 vw393 <[EMAIL PROTECTED]> wrote:



Hi all,

I'm having troubles in installing MySQL-python 1.2.2 on MAC OS X


"troubles" means? If you have a particular problem, tell us about the
problem :-)

-aj

pgpMTvFDmLz47.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Exporting portal member data to csv

[Andreas Jung]

--On 26. Februar 2007 19:43:11 -0800 Win Myint Aung <[EMAIL PROTECTED]> 
wrote:



When i run the external method in plone site, it shows errors.

The error shows.

Site Error
An error was encountered while publishing this resource.
Error Type: AttributeError
Error Value: portal_memberdata



You must provide the *full* traceback when reporting an error.

-aj

pgpKOnFdFi2lO.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Please help me about driver adapter

[Andreas Jung]

--On 17. Februar 2007 19:35:22 +0700 Nguyen Viet Minh Quang 
<[EMAIL PROTECTED]> wrote:


If you know about pymssql, please help me.


This module is not widely used. It you don't want to stick
with the mainstream stuff you have to fight and struggle.
The "best practice" solution is mxODBC.

-aj



pgpprKorec9mb.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Please help me about driver adapter

[Andreas Jung]

--On 17. Februar 2007 19:01:26 +0700 Nguyen Viet Minh Quang 
<[EMAIL PROTECTED]> wrote:


By the way, I'm using mxODBC but I don't like because it's not free.


It's cheap enough (I think 99 USD or so). Multiply the hours you're trying 
to get the other thing running with your hour rate and you'll see how cheap 
mxODBC is. But obviously your hour rate seems to be very low :-)


-aj

pgpmmxheBGZy3.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

[Zope-DB] [Sqlalchemy] Integration with Zope DA?

[Andreas Jung]

Hi,

has anyone integrated the SQLAlchemy connection handling with an existing 
Zope DA? The basic goal is to let the DA do the connection and transaction 
handling and let SQLAlchemy produce the SQL queries.


Andreas



pgptZ8lTOANzK.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] modifications on a query

[Andreas Jung]

--On 26. Januar 2007 07:37:25 + Graziella Toutoungis 
<[EMAIL PROTECTED]> wrote:





Hello,

I use zope2.9.4 with postgresql8.1, in my database i have some tables are
the result  of a query on other tables.  exe: table1 is the result of
table2 with table3

My
user can connect to the database and he can modify the  table1, this
modification should done on the orginals tables table2 and table3
 my
problem is how  i can  specify the origin of the column in table for
verifing that table2 and table3 may this modifications?



Please rephrase your question and point out the Zope specific part of the
question.

-aj

pgpcXrKPpMCqG.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Sybase Adapter error :: alternatives?

[Andreas Jung]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1



- --On 27. Dezember 2006 11:28:25 -0300 Pablo Avalos <[EMAIL PROTECTED]> 
wrote:

> Hi guys
>
> Sadly I'm stuck here at work with some Sybase DB, and I need to get some
> info to the intranet plone-site..
>
> I've found the SybDAv2 but it's dead old and doesn't work..
>
> a) Has anyone made it work (recently)
> b) any alternatives to get connect to a Sybase DB?
>
> I really need help here =/
>


How about mxODBC?

- -aj
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (Darwin)

iD8DBQFFkokECJIWIbr9KYwRAnVbAJ96Z7pSPfA1HMEExWxtmt/7YFtxgACeJmy7
mKA/oHWYNM2DHRxfXn7l6Qs=
=fOED
-END PGP SIGNATURE-

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] URL Loading Error - Zope+MySQL

[Andreas Jung]

--On 16. November 2006 06:10:11 + oknam park <[EMAIL PROTECTED]> 
wrote:




Hi,

Terribly Sorry for cross posting. and not clear explanation.



Unclear? You posted a simple HTML form and said something about
MySQL. All RDMBS issues *including examples* are documented
when you follow the link and read about the RDBMS basics.
Any problem with that?

-aj

pgpvBpOjK6jJG.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] URL Loading Error - Zope+MySQL

[Andreas Jung]

Your posting really does not contain anything related to your question.
You provide the code of a form and ask about putting the stuff into
a database. What do you want to tell us? You need to write a ZSQL method.
Everything is documented here



-aj

--On 16. November 2006 05:23:08 + oknam park <[EMAIL PROTECTED]> 
wrote:



Hi All,

I'm trying to add data in mysql database using DTML in Zope.

But, all other fields are okay. But, url fiels does not call URL I
entered. Instead it
generates the url for add dtml method like
http://www.thegateway.org/about/gemingeneral/gemConsortium/memberDirector
y/contactadd.

Could you give me some piece of advice how to handle?
Any advice would be really appreciated. Best regards, Nam

Here is my add dtml method:



New Member Information Added!!

View all Member Information|
View Added
Information

Edit Member Information |
Delete Member Information |
Add Member Information



Member Information Add


  
SiteID:

  


Agency:

  


URL:

  


Last
Name:

  










Here is memberlist2 page:

Member Information Update


 


Edit|delete






Add a New Member Information


_
Get the latest Windows Live Messenger 8.1 Beta version.?Join now.
http://ideas.live.com

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db




--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
E-Publishing, Python, Zope & Plone development, Consulting


pgpfpZyrYqMBw.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] gadfly dbms,multiple records

[Andreas Jung]

--On 20. Oktober 2006 18:33:09 +0200 fabio gravina 
<[EMAIL PROTECTED]> wrote:



I want to store more than one records in a single call of zsql method, or
something like LOAD DATA in mysql..


You can specify multiple INSERT statements within ZSQL method.

-aj

pgpEROxLtptKx.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Some help about introductory Zope concepts.

[Andreas Jung]

--On 6. September 2006 08:42:40 +0200 Jose Carlos Balderas Alberico 
<[EMAIL PROTECTED]> wrote:



Hi,
I have a few beginner's questions regarding Zope. I need your help to help
me clarify some concepts that remain unclear for me still.



Sorry, but this list is for Zope database issues only. Use the "standard"
zope@zope.org list instead.

-aj

pgpyVLs0QulWc.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] ZOPE and "find in files feature"

[Andreas Jung]

--On 20. August 2006 05:51:18 -0400 Harry Spier <[EMAIL PROTECTED]> 
wrote:




Dear list members,

I am a Python programmer but not familiar with ZOPE.

I am building a website with a MYSQL database of text documents (several
thousand).  I need to construct a feature similar to a "find in files" of
a text editor.

I.e. the user will enter a text string in a form on the client-side and
be passed back a results page from the server giving all the lines in the
files in the Mysql database that contain that string. When he clicks on a
line in the results page it will cause the file containing that line to
be downloaded.

Are there features in ZOPE that do any of this kind of functionality.


What is the problem? Zope supports most databases (The Zope Book -> RDBMS 
chapter on plone.com is your primary sources). Using scripting with Python 
you can implement anything you want. But you really want to read about the 
basics first.


-aj


pgp2zxvSdqmsq.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] zope-db@zope.org

[Andreas Jung]

--On 18. August 2006 15:20:09 -0700 Rick Wagner <[EMAIL PROTECTED]> 
wrote:



On Aug 18, 2006, at 2:47 PM, Roberto Benitez wrote:


Does anyone know where i can get a working database adapter for
zope 2.8/2.9?


You may want to specify the type of database you need to access.



..and read the RDBMS chapter of the Zope book and use a reasonable
subject for postings and google and search on zope.org...

-aj

pgpmQvW9PRxqN.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Working with ZPsycopgDA (or any DA) - commiting

[Andreas Jung]

--On 11. August 2006 16:56:59 + [EMAIL PROTECTED] wrote:



Hi :-)

I'm working with a Postgresql database which I have to insert a lot of
data to... I'm using the ZPsycopgDA database adapter, and ZSQL methods.

I have noticed that though I am calling the zsql method no data gets
really commited to the database. It all gets entered to database at the
very end.


The DA is usually tied to the transaction system of Zope. So this behaviour 
is totally perfect and usually highly desirable.



This behavior seems reasonable for keeping database consistent, but in my
situation it is really not so good - I have couple houndreds megabytes of
data and as I believe it all gets stored in memory


ZSQL methods are executed at the time they are called and immediately 
executed on the server. THat does not mean that the every ZSQL method 
causes

an automatic commit after execution (see above).


before being sent to
the database causing serious system lags.


You might google for "postgres autocommit mode".


I could be wrong though - this
is only my observation... What could be another reason for slooow inserts?


What means slow inserts? Depending on the isolation level, changes are 
visible to other apps only after a commit..that's how databases usually 
work.


Either way, it would be far better for me if every "INSERT" would be
commited immediatelly or better yet if I could force a "commit" within my
code. Is there some way I can do it?



See above. You can configure autocommit mode either on the server side or 
on the client side with psycopg (check the autocommit() method of the 
connection object as returned through psycopg.connect()). You might extend 
the ZPsycopgDA sources in order to create a DB connection either with or 
without autocommit mode.


-aj

pgpNynVV7WGY5.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Vietnamese charater displayed not correctly!

[Andreas Jung]

--On 10. August 2006 11:16:27 +0200 Charlie Clark <[EMAIL PROTECTED]> 
wrote:



NGUYEN HUU DINH wrote:

Hi,

I used mxodbc connected to MSSQL Server to get vietnamese data and
displayed it in portlets. But vietnamese characters displayed not
correctly, question mark appeared!!! I've set the encoding to utf-8 but
I don't know why. Can you help me.
See the website with error: http://demo.evn.com.vn
I used Zope 2.7.3 and Plone 2.0.4


Dear all,

This customer has requested commercial support (including a demonstration
of the solution on an equivalent system) from eGenix in relation this but
seems to be having second thoughts about actually paying for the support.




Annoying behavior ...

-aj

pgpdyqDxtXDjJ.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Vietnamese charater displayed not correctly!

[Andreas Jung]

--On 10. August 2006 06:31:04 +0200 Andreas Jung <[EMAIL PROTECTED]> wrote:




--On 10. August 2006 10:04:58 +0700 NGUYEN HUU DINH
<[EMAIL PROTECTED]> wrote:


Hi,

I used mxodbc connected to MSSQL Server to get vietnamese data and
displayed it in portlets. But vietnamese characters displayed not
correctly, question mark appeared!!! I've set the encoding to utf-8 but I
don't know why.


Which encoding?

*You* must ensure that you receive your data from database as Python
Unicode strings or UTF-8. If your database encoding is  you *can't*
expect that the data will be shown correctly.



In addition you must ensure that the HTML page is sent out with a 
content-type: text/html; charset=utf-8 HTTP header. You 
RESPONSE.setHeader() to set the header.


-aj

pgpeYBV7PrqLy.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Vietnamese charater displayed not correctly!

[Andreas Jung]

--On 10. August 2006 10:04:58 +0700 NGUYEN HUU DINH 
<[EMAIL PROTECTED]> wrote:



Hi,

I used mxodbc connected to MSSQL Server to get vietnamese data and
displayed it in portlets. But vietnamese characters displayed not
correctly, question mark appeared!!! I've set the encoding to utf-8 but I
don't know why.


Which encoding?

*You* must ensure that you receive your data from database as Python 
Unicode strings or UTF-8. If your database encoding is  you *can't* 
expect that the data will be shown correctly.


-aj


pgpnoMcyncUis.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] regarding zope

[Andreas Jung]

--On 5. Juli 2006 18:56:23 +0530 [EMAIL PROTECTED] wrote:


Hi all

i am developing a project using Zope 2.7.6-final, python 2.3.5 on debian
linux.
Wheneever i make changes in python script or any thing regarding project.
it is not get effected.


What means "not get effected"? When you can scripts through the ZMI then 
the changes are directly effective. Caching issues?


-aj

P.S. you're on the wrong list. Please use zope@zope.org instead...no idea 
why you are using the DB list?




pgpWvPEkKRvgj.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Changing a Z SQL Method's connector dynamically

[Andreas Jung]

--On 30. Juni 2006 08:50:26 +0200 Jose Carlos Balderas Alberico 
<[EMAIL PROTECTED]> wrote:



Greetings. I have a question regarding Z SQL Methods and their connector.
I need to be able to change their connector dynamically, using a python
script, which will select the connector depending on the parameters passed
to the script. I'll give you an example:

This issue has been already discussed some weeks ago. Please look in the 
mailinglist archives first.


-aj

pgpmGXOOQ7RdJ.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] OracleStorage problem

[Andreas Jung]

Is there a *real* need your you using OracleStorage?
It is old, it is unmaintained, it is about 10 times slower than
FileSystemStorage.

-aj

--On 28. Juni 2006 14:33:46 +0200 [EMAIL PROTECTED] wrote:


Hello all.

After installing a Oracle8i client in my Zope machine(2.8.3) and compiling
DCOracle2 product satisfactory, I added the DCOracle2 and DCOracleStorage
Directories at $ZOPE_INSTANCE/lib/python. Later, I created a
zodb_custom.py file at $ZOPE_INSTANCE and fixed $ORACLE_HOME variable at
my oracle_home client Directory.

My Oracle8i Database resides in other machine Zope resides. I fixed
tnsnames.ora of my Oracle client correctly to the Oracle machine(Solaris
9).

I executed the sqlplus -s user/[EMAIL PROTECTED] @Full.sql sentence and tables 
were
created correctly in Oracle machine.

The problem resides at startup Zope, showing this error:

Traceback (most recent call last):
  File "/home/jagarrido/Zope/DMR/lib/python/Zope2/Startup/run.py", line
56, in ?
run()
  File "/home/jagarrido/Zope/DMR/lib/python/Zope2/Startup/run.py", line
21, in run
starter.prepare()
  File "/home/jagarrido/Zope/DMR/lib/python/Zope2/Startup/__init__.py",
line 98, in prepare
self.startZope()
  File "/home/jagarrido/Zope/DMR/lib/python/Zope2/Startup/__init__.py",
line 257, in startZope
Zope2.startup()
  File "/home/jagarrido/Zope/DMR/lib/python/Zope2/__init__.py", line 47,
in startup
_startup()
  File "/home/jagarrido/Zope/DMR/lib/python/Zope2/App/startup.py", line
64, in startup
DB = ZODB.DB(storage)
  File "/home/jagarrido/Zope/DMR/lib/python/ZODB/DB.py", line 239, in
__init__
storage.load(z64,'')
  File "/home/jagarrido/Zope/DMR/lib/python/DCOracleStorage/Full.py", line
250, in load
s, c = self._call('load', (z_oid, version), 'pickle')
  File "/home/jagarrido/Zope/DMR/lib/python/DCOracleStorage/Full.py", line
201, in _call
return apply(getattr(self, name), args+(c,))
  File "/home/jagarrido/Zope/DMR/lib/python/DCOracle2/DCOracle2.py", line
1492, in __call__
cursor.execute(sql,__plist=args)
  File "/home/jagarrido/Zope/DMR/lib/python/DCOracle2/DCOracle2.py", line
973, in execute
result = self._cursor.execute()
dco2.DatabaseError: (24370, 'ORA-24370: illegal piecewise operation
attempted')


I see the Oracle error and says me:
ORA-24370:  illegal piecewise operation attempted
  Cause:  Data of a certain datatype that does not support piecewise
operation is being sent or fetched in pieces.
  Action:  Always set the piece value to OCI_ONE_PIECE for datatypes that
does not support piecewise operation.

I see in a comment from Mathew:
This one looks like the stored procedure is trying to
return two LONG columns (which is not supported right now).  Without
tracing it I can't say for sure what the illegal piecewise operation it
was trying to do, but it is LONG related, for sure.
The unique LONG is Z_PICKLE in ZODB_PICKLE table.

suggestions to resolve?

Thanks for all




___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db




--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
E-Publishing, Python, Zope & Plone development, Consulting


pgp78N0aXV7Lf.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] OracleStorage - DCOracle2

[Andreas Jung]

--On 26. Juni 2006 18:21:47 +0200 [EMAIL PROTECTED] wrote:


Hi all!!

I need save the zope objects in an Oracle 8.1.7 Database,who I'm trying do
it with DCOracle2 Product.

My initial problem is I need save objects in Oracle Database who reside in
other machine distinc Zope resides. Due to it, I have a compilation
problem because Oracle server resides in other machine(error:




/ora00/ora8i/u01/app/oracle/product/8.1.7/lib/libclntsh.so not readable;


A permission problem with this file?

-aj

pgp6tneKuFtqw.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] MySql connectivity on Windows - state of the art

[Andreas Jung]

--On 23. Juni 2006 00:21:32 +0200 Adriano <[EMAIL PROTECTED]> wrote:


Hello people,

I'm going to ask a simple question, I took a look at the list  archives
and didn't find any clear answer to this.

On the page at http://www.zope.org/Products/DA/ZODBCDA/

I see a software for connecting Zope to MySql on win32 platforms but  I
see the latest release has been in 2001 !

Is ZODBCDA actually working , now ?

I also took a look at this: http://www.pastrytech.com/willy/
zopemysql.html
and it really scares me a bit. That make seem connecting to mysql is  not
to be supposed easy.

Is there any alternative to get Zope connected to MySql on Windows
machines ?



Look at mxODBC from Egenix. The mysql-python binding are also pretty much 
recent afaik. Also there is ZMySQLDA...you just have to look more carefully.


-aj

pgprwQFuhwFLy.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Multiple databases connection

[Andreas Jung]

--On 8. Juni 2006 22:19:17 -0700 Infor Gates <[EMAIL PROTECTED]> wrote:



My apologies if my query is unclear.
M.Banaouas got it right.  Let try to explain it another way:
1. We have a standard Zope application which is replicated in ZMI.
2. the difference in each Zope application is DBconnection.
3. Each DBconnection is connection to each Branch database.

In other words, if I have 10 branches, I will replicate 10 times of the
same Zope application which is not a wise thing to do. As such,
I exploring to find a way if there is "dynamically" way to
change the db connection to the intended (branch) database.
Thus eliminating the Zope application replication.



I think our answers were clear enough. Zope does not support this by 
default. If you want to have this feature, you must code it on your own or 
pay someone to code it for you.


-aj

--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
E-Publishing, Python, Zope & Plone development, Consulting


pgpGzwIusah8A.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Fwd: Re: [Zope-DB] Multiple databases connection]

[Andreas Jung]

--On 8. Juni 2006 09:59:28 +0200 Federico Di Gregorio <[EMAIL PROTECTED]> wrote:


In other words, is it possible to define "database connection" property
of a "Z SQL Method" like we do for parameters ?


I don't think so, but I am no (longer) a Zope wizard. :)



I am pretty sure you can do it with little coding. Since the DA (or its
ID is just a property or attribute (check the implemenation) you should be 
able to modify it.


Andreas

--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
E-Publishing, Python, Zope & Plone development, Consulting


pgpvsSm2ak71m.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Unicode - ISO 8859-1 conversion

[Andreas Jung]

--On 2. Juni 2006 12:08:09 +0200 Jonas Nielsen <[EMAIL PROTECTED]> wrote:


I have a MySQL database with text in ISO 8859-1. However Plone displays
strings in UTF-8.

I am looking for a function to convert between ISO 8859-1 and unicode. (I
am /not/ looking for a way to change how the strings are stored in MySQL
or how to change the encoding of an entire html page).


Python unicode strings have an encode() Method. For converting to a unicode
string you want to use the unicode() method of Python...the Python doc is 
your friend.


-aj

--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
E-Publishing, Python, Zope & Plone development, Consulting


pgpUaLvu2PBhI.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Re: Database connection in a file system product

[Andreas Jung]

--On 27. April 2006 11:56:39 +0200 Jonas Nielsen <[EMAIL PROTECTED]> 
wrote:



Andreas Jung wrote:

Jonas Nielsen wrote:


Is it possible to store a database connection (i.e. a "Z MySQL Database
Connection") in a file system product ? How ?


What is the sense? You can not store persistent objects. You might store
a reference to the object using some _v_ variables to avoid getting
the DA everytime through acquisition (this makes only sense
if you have performance issues, do you?).


The sense is that I would like to find an easy way to install my product
without setting up the database connection manually. I guess the way to
do it is to add some code in install.py then ?



huh? Either you expect a DA under a particular ID and use acquisition to 
get hold of it or you except a certain meta_type and use superValues() to 
search for instances of this particular meta_type.


-aj

--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
E-Publishing, Python, Zope & Plone development, Consulting


pgpxvP2k2CSm9.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Database connection in a file system product

[Andreas Jung]

--On 27. April 2006 10:54:23 +0200 Jonas Nielsen <[EMAIL PROTECTED]> 
wrote:



Is it possible to store a database connection (i.e. a "Z MySQL Database
Connection") in a file system product ? How ?



What is the sense? You can not store persistent objects. You might store
a reference to the object using some _v_ variables to avoid getting
the DA everytime through acquisition (this makes only sense
if you have performance issues, do you?).

-aj


--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
E-Publishing, Python, Zope & Plone development, Consulting


pgpgBeKlZu7IG.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Connection to MySQL

[Andreas Jung]

--On 15. April 2006 14:27:51 +0200 Vladimir Drobnjak 
<[EMAIL PROTECTED]> wrote:



When I want to add ZMySQLDA I have this problem:

Zope has encountered an error while publishing this resource.

Error type: OperationalError
Error Value: (1130, "Host '..' is not allowed to connect to this
MySQL server")

MySQL server is on a windows machine and Zope is on a linux machine. MySQL
is running OK and Zope too.


This question is purely MySQL related. Google for "mysql access control" 
and learn about the MySQL Access Privilege System which is perfectly 
documented in the MySQL documentation. Basically your problem is that is 
your host
not authorized as the error message says. The MySQL docs will tell you the 
solution.


-aj

--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
E-Publishing, Python, Zope & Plone development, Consulting


pgpdqhdwPvbKN.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Help request from a non-developer

[Andreas Jung]

--On 14. April 2006 18:19:38 +0200 Christophe Appell <[EMAIL PROTECTED]> 
wrote:



On 4/14/06, Andreas Jung <[EMAIL PROTECTED]> wrote:

> Can you give me an idea of the level of effort to accomplish this
> partial data abstraction ?
This depends really on your individual use case. Sometimes you have an
exisiting RDBMS and want to store additional content in the ZODB and
sometimes it is vice versa.


In this case _everything_ is currently in the ZoDB and I want to be
able to protect some of the data.


"protect"?


I am in no way attempting to impose
a database choice, there is no reason in particular in this case that
pushes us to use an RDBMS. In fact another hypothesis I had thought
about was setting up a ZEO server to abstract the data, perhaps this
is a better route ?


"abstract"?


Please define both.

-aj

--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
E-Publishing, Python, Zope & Plone development, Consulting


pgpjKYYccritR.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Help request from a non-developer

[Andreas Jung]

--On 14. April 2006 17:55:15 +0200 Christophe Appell <[EMAIL PROTECTED]> 
wrote:



> It was my understanding though that you can use an external DB in
> conjunction with the ZoDB, wouldn't it be possible to put my
> client-entered data (form responses mostly) on this external DB ?
Yes.


Can you give me an idea of the level of effort to accomplish this
partial data abstraction ? I imagine it's not so straight forward
since he has pushed back pretty hard to my initial requests but I
figured it's worth asking about as he may simply not know how to go
about it.



This depends really on your individual use case. Sometimes you have an 
exisiting RDBMS and want to store additional content in the ZODB and 
sometimes it is vice versa. The "tricky" part is to keep track which 
objects in the ZODB belong to which row(s) in your RDBMS. For such a hybrid 
solution I stored the path of the objects in the ZODB as new column in the 
primary table of the RDBMS (this is ok as long as you don't move objects 
around)...or you might store the primary key as attribute of your objects..
don't try to move data from a RDBMS into Zope if your data depends very 
much on the relational mode...the ZODB and RDBMSs have their pros and 
cons..just

use them  for the purpose they were designed to.

-aj

--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: [EMAIL PROTECTED] - Phone +49 - 7071 - 793376
E-Publishing, Python, Zope & Plone development, Consulting


pgpniicyCKKHi.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] mysql / zope db connection issue

[Andreas Jung]

--On 6. April 2006 21:51:05 +0200 Charlie Clark <[EMAIL PROTECTED]> wrote:



On 2006-04-06 at 20:46:36 [+0200], Jamie O'Keefe
<[EMAIL PROTECTED]>  wrote:

Hi Dieter,

> We switched to Postgres, MySQL is used only for legacy components.

Isn't postgres linux only?  We use FreeBSD.


PostgreSQL was developed at the University of California, Berkeley and
runs  on a huge range of problems.


problems? you mean systems :-)

-aj

pgpZvGcsVmzJX.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] mysql / zope db connection issue

[Andreas Jung]

--On 6. April 2006 14:46:36 -0400 Jamie O'Keefe <[EMAIL PROTECTED]> 
wrote:



Hi Dieter,


We switched to Postgres, MySQL is used only for legacy components.




Huh...google will tell you that it runs even on Windows.

-aj


   ---
  -   Andreas JungZOPYX Ltd. & Co KG-
 -   E-mail: [EMAIL PROTECTED]   Web: www.zopyx.com, www.zopyx.de -
  ---


pgpt9j8A3STBo.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] strange date problem: 2015-11-23 08:10

[Andreas Jung]

You might check your system clock first.

-aj

--On 14. Februar 2006 09:17:17 +0100 Marc Petitmermet 
<[EMAIL PROTECTED]> wrote:



dear list members

i have a strange date problem: when creating zope objects, like a  zope
file or folder, the date is always set to 2015-11-23 08:10. this  is
zope-2.7.3. we have a content management system (silva) where the  dates
of new created silva objects in the silva content management  system is
correct, but down in the zmi it is always 2015-11-23 08:10.  the
consequence of this problem is that i cannot pack the ZODB anymore.

can anybody tell me how to fix this problem? does an upgrade to
zope-2.7.8 fix this problem? and how can i change the date of the
objects in the future?

thanks for any advice.

regards,
marc

___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db






pgpKDY66CGq89.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] How I can connect MySQL database?

[Andreas Jung]

--On 9. Februar 2006 10:01:45 +0800 G E R R I T <[EMAIL PROTECTED]> 
wrote:



How  I can connect MySQL database from my zope web project?

e.q.: create login form with information save on MySQL database. Insert,
update and delete information on MySQL database. Use query on project.


And btw. _learn_ how to post. Sending a three line posting as a 44 KB large 
mail containing html and lots of images is only _disgusting_. If you do 
expect help from community then stick to their basic rules.


Thanks,
Andreas

pgpxegAeS7kPn.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] How I can connect MySQL database?

[Andreas Jung]

--On 9. Februar 2006 10:01:45 +0800 G E R R I T <[EMAIL PROTECTED]> 
wrote:



How  I can connect MySQL database from my zope web project?

e.q.: create login form with information save on MySQL database. Insert,
update and delete information on MySQL database. Use query on project.




Did you look at the RDBMS chapter of the Zope Book (zope.org)?

-aj



pgpv0yQUW2oxZ.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Setting max_rows and cache_time for SQLMethods on the file system

[Andreas Jung]

--On 13. Januar 2006 11:12:22 +0100 Michele Simionato 
<[EMAIL PROTECTED]> wrote:

I have discovered that the values in the dtml-comment are not honored:
so if I change max_rows_ to a different value nothing happens.
Zope always retrieve up to 1000 rows, which is the default value
fixed somewhere: grepping a bit I discovered that there is a
``max_rows = 1000`` statement in Shared/DC/ZRDB/DA.py, but changing this
had no effect, so it must be set somewhere else.



Because it must be "max_rows: 1000".

-aj

pgpaYBu7G5H17.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] MySQL connection

[Andreas Jung]

#

--On 22. Dezember 2005 10:06:11 +0100 Fabio <[EMAIL PROTECTED]> wrote:


Hi!
I need to create a new database MySQL (and a new Z MySQL Database
Connection)  at user login. Can I create a new Z MySQL Database
Connection dynamically in  python? How?

How can I bind new Z MySQL Database Connection with logged user? (I need
to  bind a Z MySQL Database Connection for each user logged).



Please check the mailinglist archive. The same question has been discussed 
some days ago. To make it short: you can't. DB connections are shared and 
tied only to *one* general user.


-aj




pgpekgHd3gKXx.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Getting a newly created record

[Andreas Jung]

--On 17. November 2005 17:04:22 + Sean Fulmer <[EMAIL PROTECTED]> 
wrote:



How can I insert a new record and have the new record immediately
returned to me as an object?



When you insert the data then you have the data you need inside your 
application. If not perform a second query using *some* WHERE clause based 
on the inserted data.


-aj

pgpi3BtWr846T.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Suggestions If Any Please ! ! ! ! !

[Andreas Jung]

--On 18. November 2005 12:58:46 +0530 Rajesh <[EMAIL PROTECTED]> 
wrote:



  Hi All,

  I'm Having problem in Zsql Method ,which return recordset
dictionary,containing key<--.>value pairs,   this recordset returns
only 1000 records ,Even if my Sql query satisfies more than 1000 records ,
  Looking forward for suggestions/alternatives




Look at the properties tab of your ZSQL method. There should be a property 
limiting the resultset to 1000 rows.


-aj

p.s. please learn to use a reasonable subject

pgplHMmiz0dIO.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] related to Plone+Zope+MySQL

[Andreas Jung]

--On 11. November 2005 14:27:49 +0700 "<-bhavana ->" <[EMAIL PROTECTED]> 
wrote:



Dear all,
 i have connection with MySQL from Zope and Plone and i create search from
Zope and Plone too. But i cant search from the portlet that is in Plone
interface to MySQL database. Please help me out of this...
 thankx in advance
bh



""" i cant search from the portlet""" means what?

-aj


pgpG05BL4HA8o.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Get the name of the database

[Andreas Jung]

--On 10. November 2005 13:59:41 +0100 Jochen Knuth <[EMAIL PROTECTED]> wrote:


Hi,

is there a way to get the name of the database from a database connection
object?


Connection settings are stored specific to implementation of every DA. You 
have to look the sources of your DA how it stores the informations you need.


-aj


pgp8k6TANgC9R.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] displaying more than one db row across the screen

[Andreas Jung]

--On 19. August 2005 12:45:13 +1000 John Haley 
<[EMAIL PROTECTED]> wrote:



G'Day Guys I'm new at this


I have a need to put more than the contents of a single db row across the
page on a report. I know each iteration or delivery of a row from a
dtml-in only allows me to display the contents of the that row and then
moves to the next line. I want to put the contents of two rows on the one
line. Would I do it with arrays and build the array in the dtml-in and
display the contents of the array after the /dtml-in?If so how?


Prepare your data to be displayed outside DTML inside a Python Script the 
way you need it. PythonScripts give you more choices than DTML. Then use 
the standard DTML-in to display your prepared data from the PythonScript.


-aj



pgpbNdGS9m4Y4.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] ... MySql connection pooling

[Andreas Jung]

--On 18. August 2005 18:39:29 +0200 [EMAIL PROTECTED] wrote:


Bonjour,

I'm new to zope/mysql. I succedeed in installing Zmsqlda/mysqldb (tested
a "Z SQL method" referencing a "Z Mysql Database connection").

For performance reasons, I want to use connection pooling.
It seems that Zmsqlda/mysqldb implements this (in somme circumstances
mysqladmin processlist shows multiple connections).

What's the way to requesting a connection from an external method or from
a python script and thus not having to open a new connection anytime the
method is run ? Can someone provide me a code sample ?



You don't have to deal with connections directly. You write your SQL code 
using ZSQL methods with are bound to a DA by ID. You call the ZSQL methods 
and don't have to care about connection issues. Everything is handled under 
the hood automatically for you.


-aj



pgpAQrns1SAPZ.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Parametric queries

[Andreas Jung]

--On 29. Juli 2005 22:22:38 +0200 Marcin Wudarczyk <[EMAIL PROTECTED]> wrote:


Andreas Jung wrote:

For the record: the overhead is about 40% on non-cached queries.r


That's why were are using CCSQL methods :-)


Not really - CCSQL caches results of the same query. Caching queries in
compiled form in DB server allows to speed up execution of all further
queries (i.e. for any parameters) based on that query.



It does not matter. My point is: most of my database-driven applications 
are "fast" enough (fast enough means that nobody complains about speed). In 
the case where I had slow response times than this was caused either by 
non-DB code or by unoptimized SQL queries, missing indexes etc...nothing 
where prepared SQL statement would have solved my life.


-aj




pgpUDX9SU3v1i.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Parametric queries

[Andreas Jung]

--On 29. Juli 2005 06:54:00 +0200 Charlie Clark <[EMAIL PROTECTED]> wrote:



On 2005-07-28 at 21:52:28 [+0200], Andreas Jung <[EMAIL PROTECTED]>
wrote:

Not really.

> (I understand that I can manually make queries via DB-API, but I loose
> sync with Zope transactions? Anyway I would prefer to use Z SQL
> Methods)

I've never had the case where ZSQL methods  were *slow* whatever this
means. There are usually parts inside an application that are slower :-)
It's nice2have feature but you can live without it.


For the record: the overhead is about 40% on non-cached queries.r


That's why were are using CCSQL methods :-)

-aj


pgp0HWguuOQPE.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Parametric queries

[Andreas Jung]

--On 28. Juli 2005 21:26:35 +0200 Marcin Wudarczyk <[EMAIL PROTECTED]> wrote:



Hello,

I've read the manual for Z SQL method and set up a simple example with
query having a parameter. Everything works fine but then I realised that
parametric Z SQL Methods are not passing its parameters to DB as
parameters but inserting it into SQL string. I think this has
significant impact on perfomance - DBs have special facilities to cache
compiled queries and change only parameters. Is there a way to use this
features from Zope?



Not really.


(I understand that I can manually make queries via DB-API, but I loose
sync with Zope transactions? Anyway I would prefer to use Z SQL Methods)


I've never had the case where ZSQL methods  were *slow* whatever this 
means. There are usually parts inside an application that are slower :-) 
It's nice2have feature but you can live without it.


-aj

pgpZobXzUp2Ed.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Basic Zope-DB question

[Andreas Jung]

--On 21. Juli 2005 15:53:13 +0200 Nicholas Wieland 
<[EMAIL PROTECTED]> wrote:



It seems to me that it doesn't even nominate Products.ZSQLMethods.SQL or
filesystem based products ...  Maybe I'm missing the interesting bits...



This comment raises the assumption that you have not understand the basics 
of Zope yet. ZSQL instances are *objects* that can be called from 
*everywhere* in Zope (ZPT, DTML, PythonScript, Product code or whatever). 
It does not matter from where you call them. ZSQL methods like any other 
object has an API that can be used from any everywhere in Zope (general 
speaking).


-aj




pgpU7ppDkZ7ri.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Basic Zope-DB question

[Andreas Jung]

--On 21. Juli 2005 15:17:49 +0200 Nicholas Wieland 
<[EMAIL PROTECTED]> wrote:



Hi *,
 I'm developing a FS based product with Zope, and I need to fetch some
data from a DB (SQLServer). I've installed the DA, got a connection, now
I need to query the db from within my product. I've searched the web for
documentation, but didn't find the information I'm searching. From what I
understand I have to acquire the connection from Zope, but I don't know
how.


You should read the RDBMS chapter of The Zope Book. It explains everything
carefully, doesn't it?

-aj




pgpXJqzLkm65Z.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Using psycopg directly in Zope Python script

[Andreas Jung]

--On 1. Juli 2005 23:28:51 +0200 Jørgen Frøjk Kjærsgaard 
<[EMAIL PROTECTED]> wrote:





Does Zope somehow create a restricted environment where opening a
database connection is impossible? Is there a way to bypass that
restriction?



That's a misuse of PythonScripts. They are not designed to handle such 
tasks. Use an external method or write a Zope product instead.


-aj

pgpo4O6vTMNR3.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] option selection in db entry sceens

[Andreas Jung]

--On 26. Juni 2005 17:23:38 +1200 stephen pearce <[EMAIL PROTECTED]> 
wrote:



Hi
I'm new to zope and particularly to zope sql db applications

Could someone direct me to the easiest way


You should learn how to write dynamic pages with Zope using ZPT and how to 
pass form parameters to ZSQL methods...both is explained in "The Zope Book" 
-> zope.org


-aj



pgpKFy6embdf5.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Connect to ms sql server from zope 2.8 on windows server

[Andreas Jung]

--On 21. Juni 2005 09:14:59 +0600 ЦЗЛ УЭХК <[EMAIL PROTECTED]> wrote:


I use zope 2.8 on windows server and ms sql server.
What kind of database adapter could connect zope to ms sql server?



Look at mxODBC or the latest version of ZODBCDA from zope.org.

-aj


pgpxRZXdiJu3M.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] key error on query variable in previous and next batches

[Andreas Jung]

--On Donnerstag, 19. Mai 2005 14:07 Uhr +0200 Henk Laloli 
<[EMAIL PROTECTED]> wrote:

Inside the code generated by the zope search interface dtml result page
a batch variable 'query' is used in Zope 2.7.6. This gives a key error
when having next and previous batches. It also seems to be used in the
ZSQL methods query template because the same error occurs there when
having more than 20 results (the batch value).  Does anybody know about
this? In the dtml template it is easy to change, but I can't do much
about the ZSQL template.
Fixed in Zope 2.7.7.
-aj

pgpzrVOWmYDr8.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Python Script / ZSQL

[Andreas Jung]

--On Dienstag, 10. Mai 2005 18:24 Uhr -0700 Infor Gates 
<[EMAIL PROTECTED]> wrote:



(which is documented in the Zope Book 2.7 edition -> RDBMS chapter)
-aj


pgpGEM6zFQaUv.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] dumb INSERT Question

[Andreas Jung]

--On Sonntag, 1. Mai 2005 20:29 Uhr -0400 Michael Schwartz <[EMAIL PROTECTED]> 
wrote:

I have a Z SQL method that looks like this:
Arguments: userId, roleId
Parameters should be separated by whitespaces and not by a comma afaik.
-aj

pgpghSCaz37cb.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] ZPTs and database accesses

[Andreas Jung]

--On Donnerstag, 28. April 2005 14:05 Uhr -0400 Ken Winter 
<[EMAIL PROTECTED]> wrote:

The Zope Book (version 2.7,
http://www.plope.com/Books/2_7Edition/ZPT.stx#1-8) implies that you can't
do "SQL queries" from Zope Page Templates.  If this implication is
correct, I (for one) have a problem, as I'm trying to do all my work with
ZPTs (rather than DTML) in order to use my WYSIWYG HTML editor
(DreamWeaver) to design my pages.

The RDB chapter in the Zope book
(http://www.plope.com/Books/2_7Edition/RelationalDatabases.stx#1-10)
shows a ZPT example that works for getting retrieved data from the
database through ZSQL objects onto web pages.  But I haven't found an
example of a ZPT for an HTML form that can take data from the web page
into the database.
You have not read the book correctly. First statement just said that you
can't SQL queries using ZPT. In Zope you specify SQL queries using
*ZSQL methods* that use DTML as markup language...this is not the same
as defining SQL inside DTML methods/documents or Page Templates.
Since ZSQL methods are first-class objects in Zope, you can call them
of course from DTML method/documents, Python Scripts *and* Zope 
Pagetemplates
(as shown in the RDBMS chapter).

Hope this makes things clearer,
-aj

pgpiT9EGbjdSa.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] bulk connection change

[Andreas Jung]

--On Samstag, 9. April 2005 11:41 Uhr +0100 garry saddington 
<[EMAIL PROTECTED]> wrote:

I have many ZSQL queries for which I use Zpsycopg connector on my linux
machine. On my Windows machine (laptop) I want to use another connector
as  Zpsycopg refuses to work and I hate messing with windows - you never
know  what it is doing or going to do. Is there a way to change all the
connections  at the same time or do I have to go through each ZSQL method
individually? regards
garry
The ID of the DA is likely an attribute of every single ZSQL method.
Look at the DTML code used by the ZMI to render the ZSQL's manage screen.
There you will find the name of the attribute. Then write a script to
find all ZSQL methods (hint: -> ZopeFind()) and then you can change the 
attribute
through your script.

-aj



pgpoMQ3Hn44Vf.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Re: [Zope-DB] Re: Connect Zope to Progress8.3

[Andreas Jung]

--On Dienstag, 5. April 2005 12:22 Uhr +0100 Pawel Lewicki 
<[EMAIL PROTECTED]> wrote:

U?ytkownik Andreas Jung napisa?:

--On Dienstag, 5. April 2005 11:37 Uhr +0100 Pawel Lewicki
<[EMAIL PROTECTED]> wrote:
Hi,
Does anyone know how to connect Zope to Progress 8.3? The only way I
know is via ODBC, but I can't find drivers to my configuration.
DB server: Progress 8.3

ZPsycopgDA?
-aj
There is a slight difference between Postgresql and Progress ;)
ups...:-) what about mxODBC?
-aj

pgpwtfROajQGi.pgp
Description: PGP signature
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db