public
Description: Plugins for TiddlyWeb
Homepage: http://tiddlyweb.peermore.com/
Clone URL: git://github.com/tiddlyweb/tiddlyweb-plugins.git
commit  9eb608a46ad2375ba501acefe0928718c9379e73
tree    9a03cfed46b1bd2582c8f62fc883faea2e003108
parent  2ae4d8b9e2337e80d0abbb664b803c868be90812
tiddlyweb-plugins / mappingsqlstore
name age message
..
file COPYRIGHT Loading commit data...
file Makefile Wed Oct 21 13:40:43 -0700 2009 A first pass a simple read only store that maps... [cdent]
file README Thu Oct 22 06:11:50 -0700 2009 Make sure we are testing the proper GUEST strin... [cdent]
file mappingsql.py Fri Nov 06 07:11:56 -0800 2009 Ignore fields which have no values. [Chris Dent]
file table.sql Fri Oct 23 07:45:34 -0700 2009 Control access on searches mappingsql using the... [Chris Dent]
directory test/
file tiddlywebconfig.py Fri Oct 23 06:53:19 -0700 2009 Add a type of search to the mappingsql store. ... [Chris Dent]
mappingsqlstore/README
mappingsql is TiddlyWeb StorageInterface implementation
that stubs out some ideas for mapping any arbitrary 
RDBMS table to 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 no 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'[1]
is mapped to tiddler.title. Any column names that map to 
Tiddler attributes are applied. Otherwise, columns are
mapped into tiddler.fields.

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.

[1] In the future it will be possible to map a specific 
column to tiddler.title.