skip to navigation
skip to content

Not Logged In

transmogrify.sqlalchemy 1.0.1

Feed data from SQLAlchemy into a transmogrifier pipeline

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]
 
File Type Py Version Uploaded on Size
transmogrify.sqlalchemy-1.0.1.tar.gz (md5, pgp) Source 2008-09-17 4KB
  • Downloads (All Versions):
  • 15 downloads in the last day
  • 44 downloads in the last week
  • 233 downloads in the last month