skip to navigation
skip to content

transmogrify.sqlalchemy 1.0.2

Feed data from SQLAlchemy into a transmogrifier pipeline


This package implements a simple SQLAlchemy blueprint for collective.transmogrifier.

If you are not familiar with transmogrifier please read its documentation first to get a basic understanding of how you can use this package.

This package implements the transmogrify.sqlalchemy blueprint which executes a SQL statement, generally a query, and feeds the return values from that query into the transmogrifier pipeline.


A transmogrify.sqlalchemy blueprint takes two or more parameters:

Connection information for the SQL database. The exact format is documented in the SQLAlchemy documentation for create_engine() arguments.
The SQL queries that will be executed. Any parameter starting with ‘query’ will be executed, in sorted order.


This will feed all data from the menu table in a local postgres database into the pipeline:

query1=SELECT * FROM menu WHERE id=1
query2=SELECT * FROM menu WHERE id>1


1.0.2 (2014-11-06)

  • Use IAnnotations to store info on the transmogrifier context, instead of supersekrit attributes. [mj]
  • Added workaround for sqlalchemy versions > 0.7.2 where sqlalchemy.exceptions is gone in favour of sqlalchemy.exc. [pilz]

1.0.1 (2008-09-17)

  • The keys in the returned dictionary need to be normal strings. [fschulze, soerensigfusson]

1.0 (2008-05-22)

  • Initial release [wichert, mj]
File Type Py Version Uploaded on Size (md5) Source 2014-11-06 10KB