How to install transmogrify.sqlalchemy
- Download and install ActivePython
- Open Command Prompt
- Type
pypm install transmogrify.sqlalchemy
Lastest release
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.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]