Skip to main content

Feed data from SQLAlchemy into a transmogrifier pipeline

Project description

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

.. _create_engine() arguments:
http://www.sqlalchemy.org/docs/04/dbengine.html#dbengine_establishing
.. _collective.transmogrifier:
https://pypi.python.org/pypi/collective.transmogrifier



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]

Project details


Download files

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

Source Distribution

transmogrify.sqlalchemy-1.0.1.tar.gz (4.4 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page