transmogrify.sqlalchemy 1.0

Introduction

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.

Configuration

A transmogrify.sqlalchemy blueprint takes two or more parameters:

dsn

Connection information for the SQL database. The exact format is documented in the SQLAlchemy documentation for create_engine() arguments.

query*

The SQL queries that will be executed. Any parameter starting with ‘query’ will be executed, in sorted order.

Example

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

[sqlite]
blueprint=transmogrify.sqlalchemy
dsn=postgres://scott:tiger@localhost:5432/mydatabase
query1=SELECT * FROM menu WHERE id=1
query2=SELECT * FROM menu WHERE id>1

Changelog

1.0 - 2008-05-22

• Initial release