Re: [Zope-DB] questions
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 posgr...@correo.chapingo.mx 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]
-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- attachment: lists.vcf___ Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Fwd: Zope_Database_issue
-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-
attachment: lists.vcf___
Zope-DB mailing list
Zope-DB@zope.org
https://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Zope_Database_issue
-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* li...@zopyx.com mailto:li...@zopyx.com Date: Thu, Nov 18, 2010 at 1:14 PM Subject: Re: [Zope-DB] Zope_Database_issue To: smita kamdar smita.kamda...@gmail.com 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- attachment: lists.vcf___ Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Zope_Database_issue
-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- attachment: lists.vcf___ Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Zope_Database_issue
Try using Products.SQLAlchemyDA instead. -aj 2010/11/16 smita kamdar smita.kamda...@gmail.com 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
-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- attachment: lists.vcf___ 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?
2010/8/25 Jaroslav Lukesh luk...@seznam.cz - Puvodní zpráva - Od: Andreas Jung li...@zopyx.com -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?
-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- attachment: lists.vcf___ 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
-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- attachment: lists.vcf___ Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Zope - Oracle Database Connection
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
[Zope-DB] [Fwd: Re: Zope - Oracle Database Connection]
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] Help me.
--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
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
--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] Connecting Zope 3 to Oracle 10g
--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
[Zope-DB] [ANN] SQLAlchemyDA 0.3.0 released - a generic database adapter for Zope 2
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] Using dtml-vars in ZSQL methods?
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 dtml-vars 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' zope-db@zope.org
Sent: Saturday, June 16, 2007 5:15 AM
Subject: [Zope-DB] Using dtml-vars in ZSQL methods?
Here's the definition of a ZSQL method, people_delete_by_id.zsql:
dtml-comment
title: Method to delete People by ids given in a comma-separated list
connection_id: my_database
arguments:
id_list
/dtml-comment
delete from person
where person_id in (dtml-var id_list)
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:
form method=post name=form2
tal:attributes=action string:${here/absolute_url}/${template/id};
input type=hidden name=form.submitted value=1 /
p class=error_message tal:define=err errors/n|nothing
tal:condition=errb tal:content=err //p
table
tr tal:repeat=person options/dataa name=id id=id
tal:attributes=name person/person_id/a
td tal:condition=not:options/selectall | nothing
input type=checkbox name=delete_this:list:int value=
tal:attributes=value person/person_id/
/td
...
/tr
/table
...
/form
...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 dtml-var
id_list) to provide the list of person_ids to delete.
Here's the question:
WHY?
~ TIA
~ Ken
P.S. I know that dtml-var... rather than dtml-sqlvar... is an
unorthodox and apparently undocumented construct to use within a ZSQL
definition. But I need it because dtml-sqlvar... 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
RE: [Zope-DB] Two actions in one ZSQL method = one transaction?
--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?
--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
--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
--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: [Zope-DB] Connecting FileMaker with Zope
--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: Fwd: [Zope-DB] Connecting FileMaker with Zope
--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: http://www.mail-archive.com/[EMAIL PROTECTED]/msg03390.html -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] Unified DA for Zope 2 using SQLAlchemy?
--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: http://svn.zope.org/Products.SQLAlchemyDA/trunk/ 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
--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?
--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?
--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?
--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
Re: [Zope-DB] zmysql filesystem database connection
--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] Please help me about driver adapter
--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] modifications on a query
--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?
-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] Some help about introductory Zope concepts.
--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
--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
--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] Unicode - ISO 8859-1 conversion
--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] Database connection in a file system product
--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] Help request from a non-developer
--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] mysql / zope db connection issue
--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] mysql / zope db connection issue
--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] strange date problem: 2015-11-23 08:10
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?
--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] How I can connect MySQL database?
--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] Setting max_rows and cache_time for SQLMethods on the file system
--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] Suggestions If Any Please ! ! ! ! !
--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] Get the name of the database
--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] related to Plone+Zope+MySQL
--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] Using psycopg directly in Zope Python script
--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] Python Script / ZSQL
--On Dienstag, 10. Mai 2005 18:24 Uhr -0700 Infor Gates [EMAIL PROTECTED] wrote: dtml-call insertZSQL tal:def define=dummy python: context.somemethod(arg1=..., arg2=...) / (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] bulk connection change
--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
