Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (
Help us improve Python packaging - Donate today!

Feed data from SQLAlchemy into a transmogrifier pipeline

Project Description


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]

Release History

This version
History Node


History Node


History Node


Download Files

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

Filename, Size & Hash SHA256 Hash Help File Type Python Version Upload Date
(10.8 kB) Copy SHA256 Hash SHA256
Source None Nov 6, 2014

Supported By

Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Kabu Creative Kabu Creative UX & Design Google Google Cloud Servers Fastly Fastly CDN StatusPage StatusPage Statuspage DigiCert DigiCert EV Certificate