Skip to main content

SQLAlchemy integration package for Zope3

Project description

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…



  • 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


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


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


  • 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


  • small changes in session management
  • remove thread-local sessions store


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


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


  • changed package source layout


  • added SQLAlchemy engines vocabulary


  • updated package dependencies


  • changed import of threading.local module


  • merged updates from z3c.zalchemy parent package


  • switched to ZTK-1.1.2


  • add “pool_recycle” attribute to IEngineDirective and IAlchemyEngineUtility interfaces
  • use properties in AlchemyEngineUtility
  • updated locales


  • initial release

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for ztfy.alchemy, version 0.3.6
Filename, size File type Python version Upload date Hashes
Filename, size ztfy.alchemy-0.3.6.tar.gz (16.1 kB) File type Source Python version None Upload date Hashes View
Filename, size ztfy.alchemy-0.3.6-py2.7.egg (41.1 kB) File type Egg Python version 2.7 Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page