ztfy.alchemy 0.3.6

SQLAlchemy integration package for Zope3

Contents

• What is ztfy.alchemy ?

• How to use ztfy.alchemy ?

• Changelog

  • 0.3.6

  • 0.3.5

  • 0.3.4

  • 0.3.3

  • 0.3.2

  • 0.3.1

  • 0.3.0

  • 0.2.5

  • 0.2.4

  • 0.2.3

  • 0.2.2

  • 0.2.1

  • 0.2

  • 0.1.1

  • 0.1

What is ztfy.alchemy ?

ZTFY.alchemy is a Zope3 package which can be used to connect Zope3 applications with SQLAlchemy.

Main features include :

• integration of SQLAlchemy transactions with Zope3 transaction manager

• register PostgreSQL geometric data types (PostGIS) through GeoTypes package.

Most code fragments are based on zope.sqlalchemy, z3c.sqlalchemy and z3c.zalchemy elements and source codes, except for elements handling PostGIS data types..

How to use ztfy.alchemy ?

#TODO: To be written…

Changelog

0.3.6

• added “close_all_connections” function in ztfy.alchemy.engine module. This function should be called in any scheduler task in an after-commit hook to be sure that all databases connections are correctly closed when the task ends

0.3.5

• replace “@listens_for” decorator with “listen” calls in connections events listeners

0.3.4

• added connections cleaning thread to invalidate connections which are still unused five minutes after begin checked-in to connections pool

0.3.3

• small changes in session management with a new argument allowing to create a session without integrating it in the Zope transaction’s scoped session

• corrected parent’s call in GeometryLINESTRING constructor

0.3.2

• small changes in session management

• remove thread-local sessions store

0.3.1

• handle aliases in session management via new getSession() function “alias” argument

0.3.0

• add new getUserSession function which can accept an existing session as input argument

• removed GeoTypes dependency

0.2.5

• changed package source layout

0.2.4

• added SQLAlchemy engines vocabulary

0.2.3

• updated package dependencies

0.2.2

• changed import of threading.local module

0.2.1

• merged updates from z3c.zalchemy parent package

0.2

• switched to ZTK-1.1.2

0.1.1

• add “pool_recycle” attribute to IEngineDirective and IAlchemyEngineUtility interfaces

• use properties in AlchemyEngineUtility

• updated locales

0.1

• initial release