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
Changelog
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]
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Hashes for transmogrify.sqlalchemy-1.0.2.zip
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7f538b293383b28ed537c8c726b233316f045ab20b5b7c53691883e8b5d2d71e |
|
MD5 | b96dd0e5068f0889a40ad1e9bee4e68a |
|
BLAKE2b-256 | ec50528f6e2d80804457746cc1160007bef0fac9e9f01a09d453bc6473e49e39 |