I am pleased to announce the first public release of
SQLAlchemyDA V 0.2.0
Download:
---------
<http://opensource.zopyx.com/software/sqlalchemyda/releases/0.2.0>
What is SQLAlchemyDA?
---------------------
SQLAlchemyDA is both a tiny frontend to the z3c.sqlalchemy SQLAlchemy
package for Zope 2 and Zope 3. In addition it acts as a database adapter
for ZSQL methods. Since it is based on SQLAlchemy, SQLAlchemy supports all
databases out-of-the box that are supported by SQLAlchemy.
Requirements:
-------------
- Zope 2.8 +
- SQLAlchemy 0.3.X
- z3c.sqlalchemy 1.0.0 +
Installation:
-------------
- download and install z3c.sqlalchemy as egg or from the sources
from Cheeseshop (easy_install z3c.sqlalchemy)
- A z3c.sqlAlchemy SAWrapper must be registered. The best way to do this
right now to put something like this into your Product's initialize():
Products/YourProduct/__init__.py:
def initialize(context):
from z3c.sqlalchemy import createSAWrapper, registerSAWrapper
wrapper =
createSAWrapper('postgres://user:password@host/database', forZope=True)
registerSAWrapper(wrapper, 'my-sa-wrapper')
- After restarting Zope you go to the ZMI and create an instance of
"SQLAlchemy Wrapper Integration" (as you would create some DA instance).
After creating the instance you should see 'my-sa-wrapper' in the
properties form of the new instance. When creating a new ZSQL method
you should be able to use this DA instance as connection id.
Using SQLAlchemyDA:
-------------------
- for using SQLAlchemyDA through object mappers as used in SQLAlchemy
you can use the getMapper() and getMappers() methods. Check
the z3c.sqlchemy documentation for details. A SQLAlchemy Session object
can be obtained by the getSession() method. Sessions are integrated
with Zope 2 transaction management.
- a SQLAlchemyDA instance can be used as a standard DA together with
ZSQL methods.
WARNING: YOU SHOULD NOT USE ZSQL METHODS AND MAPPERS WITHIN THE SAME
REQUEST!!!
Mappers/Sessions and Connections (for ZSQL methods) are totally
independent and have their own transaction. Mixing both would
result in two distinct transactions leading to unpredictable results.
License
=======
SQLAlchemyDA is licensed under the Zope Public License 2.1.
See LICENSE.txt.
Andreas Jung
--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: info@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
SQLAlchemyDA V 0.2.0
Download:
---------
<http://opensource.zopyx.com/software/sqlalchemyda/releases/0.2.0>
What is SQLAlchemyDA?
---------------------
SQLAlchemyDA is both a tiny frontend to the z3c.sqlalchemy SQLAlchemy
package for Zope 2 and Zope 3. In addition it acts as a database adapter
for ZSQL methods. Since it is based on SQLAlchemy, SQLAlchemy supports all
databases out-of-the box that are supported by SQLAlchemy.
Requirements:
-------------
- Zope 2.8 +
- SQLAlchemy 0.3.X
- z3c.sqlalchemy 1.0.0 +
Installation:
-------------
- download and install z3c.sqlalchemy as egg or from the sources
from Cheeseshop (easy_install z3c.sqlalchemy)
- A z3c.sqlAlchemy SAWrapper must be registered. The best way to do this
right now to put something like this into your Product's initialize():
Products/YourProduct/__init__.py:
def initialize(context):
from z3c.sqlalchemy import createSAWrapper, registerSAWrapper
wrapper =
createSAWrapper('postgres://user:password@host/database', forZope=True)
registerSAWrapper(wrapper, 'my-sa-wrapper')
- After restarting Zope you go to the ZMI and create an instance of
"SQLAlchemy Wrapper Integration" (as you would create some DA instance).
After creating the instance you should see 'my-sa-wrapper' in the
properties form of the new instance. When creating a new ZSQL method
you should be able to use this DA instance as connection id.
Using SQLAlchemyDA:
-------------------
- for using SQLAlchemyDA through object mappers as used in SQLAlchemy
you can use the getMapper() and getMappers() methods. Check
the z3c.sqlchemy documentation for details. A SQLAlchemy Session object
can be obtained by the getSession() method. Sessions are integrated
with Zope 2 transaction management.
- a SQLAlchemyDA instance can be used as a standard DA together with
ZSQL methods.
WARNING: YOU SHOULD NOT USE ZSQL METHODS AND MAPPERS WITHIN THE SAME
REQUEST!!!
Mappers/Sessions and Connections (for ZSQL methods) are totally
independent and have their own transaction. Mixing both would
result in two distinct transactions leading to unpredictable results.
License
=======
SQLAlchemyDA is licensed under the Zope Public License 2.1.
See LICENSE.txt.
Andreas Jung
--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: info@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