Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

Map a single RDBMS table to a bag.

Project Description

mappingsql is TiddlyWeb StorageInterface implementation that maps an RDBMS table as a bag, with each row representing a tiddler.

It has many limitations (on purpose):

  • It is READ ONLY
  • It only supports one bag.
  • It has no support for recipes.
  • It has no support revisions.
  • It has limited support for search.

You tell tiddlywebconfig.py what database you want to look at, what table you want to map, and what bag name you want that table to think of itself as. The column name ‘id’ is mapped to tiddler.title unless overridden by the configuration setting of ‘mappingsql.id_column’. Any column names that map to Tiddler attributes are applied. Otherwise, columns are mapped into tiddler.fields.

Search support is used primarily with MySQL and its full text indexing system. You may turn on this support with ‘mappingsql.full_text’ set to True.

This is experimental alpha software, reading and understanding the code is recommending before using. There is additional information in the module docstring.

TODO:

  • Make mapping of columns to tiddler attributes optional.
  • Cast column data to unicode with flair.

This work was created by Chris Dent <cdent@peermore.com> for Peermore Limited, working for Yellowcar Limited, under the auspices of the wiki-data project of Avox.

It is license under the BSD license. See COPYRIGHT for more information.

Release History

Release History

This version
History Node

1.2

History Node

1.1

History Node

1.0

History Node

0.9

History Node

0.8

History Node

0.7

History Node

0.6

History Node

0.5

History Node

0.4

History Node

0.3

History Node

0.2

History Node

0.1

Download Files

Download Files

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

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
tiddlywebplugins.mappingsql-1.2.tar.gz (8.6 kB) Copy SHA256 Checksum SHA256 Source May 20, 2011

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting